diff options
Diffstat (limited to 'mysql-test/main/type_blob.test')
-rw-r--r-- | mysql-test/main/type_blob.test | 41 |
1 files changed, 38 insertions, 3 deletions
diff --git a/mysql-test/main/type_blob.test b/mysql-test/main/type_blob.test index f97ddc755ce..df565b187b4 100644 --- a/mysql-test/main/type_blob.test +++ b/mysql-test/main/type_blob.test @@ -131,8 +131,6 @@ select c,count(*) from t1 group by c; select d,count(*) from t1 group by d; drop table t1; --- error 1071 -create table t1 (a text, unique (a(2100))); # should give an error create table t1 (a text, key (a(2100))); # key is auto-truncated show create table t1; drop table t1; @@ -360,7 +358,8 @@ select * from t1 where txt >= 'Chevy'; drop table t1; create table t1 (id integer primary key auto_increment, txt text, index txt_index (txt (20))); -insert into t1 (txt) values ('Chevy'), ('Chevy '), (NULL); +insert into t1 (txt) values + ('Chevy'), ('Chevy '), (NULL), ('Honda'), ('Subaru'), ('Honda'); select * from t1 where txt='Chevy' or txt is NULL; explain select * from t1 where txt='Chevy' or txt is NULL; select * from t1 where txt='Chevy '; @@ -703,3 +702,39 @@ drop table t1; --echo # --echo # End of 10.2 test --echo # + + +--echo # +--echo # Start of 10.4 test +--echo # + +--echo # +--echo # MDEV-19317 TEXT column accepts too long literals as a default value +--echo # + +EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a TINYTEXT DEFAULT ?)' USING REPEAT('a', 255); +INSERT INTO t1 VALUES (); +SELECT LENGTH(a), LENGTH(DEFAULT(a)) FROM t1; +DROP TABLE t1; + +--error ER_INVALID_DEFAULT +EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a TINYTEXT DEFAULT ?)' USING REPEAT('a', 256); + +--error ER_INVALID_DEFAULT +CREATE OR REPLACE TABLE t1 (a TINYTEXT DEFAULT 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'); + + +EXECUTE IMMEDIATE 'CREATE OR REPLACE TABLE t1 (a TEXT DEFAULT ?)' USING REPEAT('a', 256); +INSERT INTO t1 VALUES (); +SELECT LENGTH(a), LENGTH(DEFAULT(a)) FROM t1; +DROP TABLE t1; + +CREATE OR REPLACE TABLE t1 (a TEXT DEFAULT 'aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa'); +INSERT INTO t1 VALUES (); +SELECT LENGTH(a), LENGTH(DEFAULT(a)) FROM t1; +DROP TABLE t1; + + +--echo # +--echo # End of 10.4 test +--echo # |