diff options
Diffstat (limited to 'storage/myisammrg/mysql-test/storage_engine/vcol.rdiff')
| -rw-r--r-- | storage/myisammrg/mysql-test/storage_engine/vcol.rdiff | 79 |
1 files changed, 79 insertions, 0 deletions
diff --git a/storage/myisammrg/mysql-test/storage_engine/vcol.rdiff b/storage/myisammrg/mysql-test/storage_engine/vcol.rdiff new file mode 100644 index 00000000000..20431a9c713 --- /dev/null +++ b/storage/myisammrg/mysql-test/storage_engine/vcol.rdiff @@ -0,0 +1,79 @@ +3,69c3,12 +< SHOW COLUMNS IN t1; +< Field Type Null Key Default Extra +< a int(11) # # +< b int(11) # # VIRTUAL +< INSERT INTO t1 (a) VALUES (1),(2); +< INSERT INTO t1 (a,b) VALUES (3,3),(4,4); +< Warnings: +< Warning 1906 The value specified for computed column 'b' in table 't1' ignored +< Warning 1906 The value specified for computed column 'b' in table 't1' ignored +< SELECT * FROM t1; +< a b +< 1 2 +< 2 3 +< 3 4 +< 4 5 +< DROP TABLE t1; +< CREATE TABLE t1 (a <INT_COLUMN>, b <INT_COLUMN> GENERATED ALWAYS AS (a+1) PERSISTENT) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; +< SHOW COLUMNS IN t1; +< Field Type Null Key Default Extra +< a int(11) # # +< b int(11) # # PERSISTENT +< INSERT INTO t1 (a) VALUES (1),(2); +< INSERT INTO t1 (a,b) VALUES (3,3),(4,4); +< Warnings: +< Warning 1906 The value specified for computed column 'b' in table 't1' ignored +< Warning 1906 The value specified for computed column 'b' in table 't1' ignored +< SELECT * FROM t1; +< a b +< 1 2 +< 2 3 +< 3 4 +< 4 5 +< DROP TABLE t1; +< CREATE TABLE t1 (a <INT_COLUMN>, b <INT_COLUMN> GENERATED ALWAYS AS (a+1) VIRTUAL) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; +< SHOW COLUMNS IN t1; +< Field Type Null Key Default Extra +< a int(11) # # +< b int(11) # # VIRTUAL +< INSERT INTO t1 (a) VALUES (1),(2); +< INSERT INTO t1 (a,b) VALUES (3,3),(4,4); +< Warnings: +< Warning 1906 The value specified for computed column 'b' in table 't1' ignored +< Warning 1906 The value specified for computed column 'b' in table 't1' ignored +< SELECT * FROM t1; +< a b +< 1 2 +< 2 3 +< 3 4 +< 4 5 +< DROP TABLE t1; +< CREATE TABLE t1 (a <INT_COLUMN>, b <INT_COLUMN> AS (a+1) PERSISTENT) ENGINE=<STORAGE_ENGINE> <CUSTOM_TABLE_OPTIONS>; +< SHOW COLUMNS IN t1; +< Field Type Null Key Default Extra +< a int(11) # # +< b int(11) # # PERSISTENT +< INSERT INTO t1 (a) VALUES (1),(2); +< INSERT INTO t1 (a,b) VALUES (3,3),(4,4); +< Warnings: +< Warning 1906 The value specified for computed column 'b' in table 't1' ignored +< Warning 1906 The value specified for computed column 'b' in table 't1' ignored +< SELECT * FROM t1; +< a b +< 1 2 +< 2 3 +< 3 4 +< 4 5 +< DROP TABLE t1; +--- +> ERROR HY000: MRG_MYISAM storage engine does not support computed columns +> # ERROR: Statement ended with errno 1910, errname ER_UNSUPPORTED_ENGINE_FOR_VIRTUAL_COLUMNS (expected to succeed) +> # ------------ UNEXPECTED RESULT ------------ +> # [ CREATE TABLE t1 (a INT(11) /*!*/ /*Custom column options*/, b INT(11) /*!*/ /*Custom column options*/ GENERATED ALWAYS AS (a+1)) ENGINE=MRG_MYISAM /*!*/ /*Custom table options*/ UNION(mrg.t1) INSERT_METHOD=LAST ] +> # The statement|command finished with ER_UNSUPPORTED_ENGINE_FOR_VIRTUAL_COLUMNS. +> # Virtual columns or the mix could be unsupported|malfunctioning, or the problem was caused by previous errors. +> # You can change the engine code, or create an rdiff, or disable the test by adding it to disabled.def. +> # Further in this test, the message might sometimes be suppressed; a part of the test might be skipped. +> # Also, this problem may cause a chain effect (more errors of different kinds in the test). +> # ------------------------------------------- |