mirror of
https://github.com/MariaDB/server.git
synced 2025-08-07 00:04:31 +03:00
cc06415fd6
In 10.0 output of SHOW DATABASES appears to be sorted, while in result files it is not. Added sorted_result for certainty and updated result files.
21 lines
346 B
Plaintext
21 lines
346 B
Plaintext
--disable_warnings
|
|
DROP DATABASE IF EXISTS d1;
|
|
--enable_warnings
|
|
CREATE DATABASE d1;
|
|
--sorted_result
|
|
SHOW DATABASES;
|
|
SHOW DATABASES LIKE 'd%';
|
|
--sorted_result
|
|
SHOW DATABASES LIKE '%';
|
|
USE d1;
|
|
DROP DATABASE d1;
|
|
CREATE SCHEMA d1;
|
|
--sorted_result
|
|
SHOW SCHEMAS;
|
|
SHOW SCHEMAS LIKE 'd%';
|
|
--sorted_result
|
|
SHOW SCHEMAS LIKE '%';
|
|
USE d1;
|
|
DROP SCHEMA d1;
|
|
|