storage/mroonga/mysql-test/mroonga/storage/r/alter_table_add_column_with_type.result


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
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;