mirror of
https://github.com/MariaDB/server.git
synced 2025-02-15 18:05:32 +01: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.
20 lines
346 B
Text
20 lines
346 B
Text
--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;
|
|
|