diff options
Diffstat (limited to 'mysql-test/main/comment_database.test')
| -rw-r--r-- | mysql-test/main/comment_database.test | 65 |
1 files changed, 65 insertions, 0 deletions
diff --git a/mysql-test/main/comment_database.test b/mysql-test/main/comment_database.test new file mode 100644 index 00000000..bf89a57c --- /dev/null +++ b/mysql-test/main/comment_database.test @@ -0,0 +1,65 @@ +--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 |