diff options
Diffstat (limited to 'mysql-test/r/key.result')
| -rw-r--r-- | mysql-test/r/key.result | 17 |
1 files changed, 7 insertions, 10 deletions
diff --git a/mysql-test/r/key.result b/mysql-test/r/key.result index e0b2b84ac16..89deab4bb1f 100644 --- a/mysql-test/r/key.result +++ b/mysql-test/r/key.result @@ -1,4 +1,5 @@ drop table if exists t1,t2,t3; +SET SQL_WARNINGS=1; CREATE TABLE t1 ( ID CHAR(32) NOT NULL, name CHAR(32) NOT NULL, @@ -33,10 +34,10 @@ INSERT INTO t1 VALUES (900,'Vancouver','Shared/Roomate','N','N','N','N'); INSERT INTO t1 VALUES (900,'Vancouver','Shared/Roomate','N','N','N','N'); INSERT INTO t1 VALUES (900,'Vancouver','Shared/Roomate','','','',''); Warnings: -Warning 1263 Data truncated for column 'transityes' at row 1 -Warning 1263 Data truncated for column 'shopsyes' at row 1 -Warning 1263 Data truncated for column 'schoolsyes' at row 1 -Warning 1263 Data truncated for column 'petsyes' at row 1 +Warning 1264 Data truncated for column 'transityes' at row 1 +Warning 1264 Data truncated for column 'shopsyes' at row 1 +Warning 1264 Data truncated for column 'schoolsyes' at row 1 +Warning 1264 Data truncated for column 'petsyes' at row 1 INSERT INTO t1 VALUES (900,'Vancouver','Shared/Roomate','Y','Y','Y','Y'); INSERT INTO t1 VALUES (900,'Vancouver','Shared/Roomate','Y','Y','Y','Y'); INSERT INTO t1 VALUES (900,'Vancouver','Shared/Roomate','Y','Y','Y','Y'); @@ -94,13 +95,9 @@ INSERT t1 VALUES(NULL,'/'); INSERT t1 VALUES(NULL,'[T,U]_axpby'); SELECT * FROM t1 WHERE name='[T,U]_axpy'; name_id name -Warnings: -Warning 1263 Data truncated for column 'name' at row 1 SELECT * FROM t1 WHERE name='[T,U]_axpby'; name_id name 2 [T,U]_axpby -Warnings: -Warning 1263 Data truncated for column 'name' at row 1 create table t2 ( name_id int not null auto_increment, @@ -159,8 +156,8 @@ CREATE TABLE t1 (c CHAR(10) NOT NULL,i INT NOT NULL AUTO_INCREMENT, UNIQUE (c,i)); INSERT INTO t1 (c) VALUES (NULL),(NULL); Warnings: -Warning 1261 Data truncated, NULL supplied to NOT NULL column 'c' at row 1 -Warning 1261 Data truncated, NULL supplied to NOT NULL column 'c' at row 2 +Warning 1262 Data truncated, NULL supplied to NOT NULL column 'c' at row 1 +Warning 1262 Data truncated, NULL supplied to NOT NULL column 'c' at row 2 SELECT * FROM t1; c i 1 |