diff options
Diffstat (limited to 'storage/mroonga/mysql-test/mroonga/storage/r/alter_table_add_column_with_type.result')
-rw-r--r-- | storage/mroonga/mysql-test/mroonga/storage/r/alter_table_add_column_with_type.result | 16 |
1 files changed, 16 insertions, 0 deletions
diff --git a/storage/mroonga/mysql-test/mroonga/storage/r/alter_table_add_column_with_type.result b/storage/mroonga/mysql-test/mroonga/storage/r/alter_table_add_column_with_type.result new file mode 100644 index 00000000000..6ff92ec8e99 --- /dev/null +++ b/storage/mroonga/mysql-test/mroonga/storage/r/alter_table_add_column_with_type.result @@ -0,0 +1,16 @@ +CREATE TABLE tags ( +id INT UNSIGNED PRIMARY KEY +) DEFAULT CHARSET=utf8; +CREATE TABLE bugs ( +id INT UNSIGNED PRIMARY KEY +) DEFAULT CHARSET=utf8; +ALTER TABLE bugs ADD COLUMN name VARCHAR(64) COMMENT 'type "tags"'; +SELECT mroonga_command("dump"); +mroonga_command("dump") +table_create tags TABLE_PAT_KEY UInt32 +column_create tags id COLUMN_SCALAR UInt32 +table_create bugs TABLE_PAT_KEY UInt32 +column_create bugs id COLUMN_SCALAR UInt32 +column_create bugs name COLUMN_SCALAR tags +DROP TABLE bugs; +DROP TABLE tags; |