mirror of
https://github.com/MariaDB/server.git
synced 2025-11-04 04:46:15 +01:00
2c0ba2680b
Added caching of database directories that did not have a db.opt file. This was common for older MariaDB installaiton or if a user created a database with 'mkdir'. Other things: - Give a note "no db.opt file" if one uses SHOW CREATE DATABASE one a database without a db.opt file.
73 lines
4.9 KiB
Text
73 lines
4.9 KiB
Text
--echo #
|
|
--echo # MDEV-307: Add functionality for database comments
|
|
--echo #
|
|
|
|
# Check an error state
|
|
--error ER_PARSE_ERROR
|
|
CREATE DATABASE db1 COMMENT=;
|
|
|
|
# 1024 bytes
|
|
CREATE DATABASE db1
|
|
COMMENT='abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcd';
|
|
SHOW CREATE DATABASE db1;
|
|
SELECT schema_comment, char_length(schema_comment)
|
|
FROM information_schema.schemata
|
|
WHERE schema_name='db1';
|
|
DROP DATABASE db1;
|
|
|
|
# 1025 bytes (warning)
|
|
SET SQL_MODE='';
|
|
CREATE DATABASE db1
|
|
COMMENT='abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde';
|
|
SHOW CREATE DATABASE db1;
|
|
SELECT schema_comment, char_length(schema_comment)
|
|
FROM information_schema.schemata
|
|
WHERE schema_name='db1';
|
|
DROP DATABASE db1;
|
|
SET SQL_MODE='TRADITIONAL';
|
|
|
|
# 1025 bytes (error)
|
|
--error ER_TOO_LONG_DATABASE_COMMENT
|
|
CREATE DATABASE db1
|
|
COMMENT='abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcde';
|
|
SELECT schema_comment, char_length(schema_comment)
|
|
FROM information_schema.schemata
|
|
WHERE schema_name='db1';
|
|
|
|
CREATE DATABASE db1 COMMENT 'db1';
|
|
SHOW CREATE DATABASE db1;
|
|
ALTER DATABASE db1 COMMENT = "db1 comment";
|
|
SELECT * FROM information_schema.schemata
|
|
WHERE schema_name='db1';
|
|
DROP DATABASE db1;
|
|
|
|
CREATE DATABASE db1;
|
|
USE db1;
|
|
ALTER DATABASE COMMENT 'db1 comment' CHARACTER SET 'utf8';
|
|
SHOW CREATE DATABASE db1;
|
|
ALTER DATABASE db1 COMMENT 'this is db1 comment';
|
|
SHOW CREATE DATABASE db1;
|
|
ALTER DATABASE CHARACTER SET 'latin1';
|
|
SHOW CREATE DATABASE db1;
|
|
DROP DATABASE db1;
|
|
|
|
# Test the case when the database is named 'comment'
|
|
--disable_service_connection
|
|
CREATE DATABASE comment COMMENT 'comment' CHARACTER SET 'latin2';
|
|
SHOW CREATE DATABASE comment;
|
|
ALTER DATABASE comment COMMENT 'comment comment';
|
|
SHOW CREATE DATABASE comment;
|
|
USE comment;
|
|
ALTER DATABASE COMMENT 'comment';
|
|
SELECT * FROM information_schema.schemata
|
|
WHERE schema_name='comment';
|
|
DROP DATABASE comment;
|
|
--enable_service_connection
|
|
|
|
CREATE DATABASE db1;
|
|
--remove_file $MARIADB_DATADIR/db1/db.opt
|
|
--source include/restart_mysqld.inc
|
|
# We need to call this two times to ensure all code paths are used
|
|
SHOW CREATE DATABASE db1;
|
|
SHOW CREATE DATABASE db1;
|
|
DROP DATABASE db1;
|