diff options
| author | unknown <venu@myvenu.com> | 2003-04-30 00:07:37 -0700 |
|---|---|---|
| committer | unknown <venu@myvenu.com> | 2003-04-30 00:07:37 -0700 |
| commit | b85712945457d5455f603678f8bcb15d2f929e82 (patch) | |
| tree | 19e2ae7cf49f8bfd63f42100781c94f9338f4e54 /mysql-test/r/key.result | |
| parent | 05af39d59102c5b46f71ca4d3626feba2c3c777a (diff) | |
| download | mariadb-git-b85712945457d5455f603678f8bcb15d2f929e82.tar.gz | |
Updated warning test
Updated all tests to catchup warnings for all field conversions
mysql-test/t/ctype_many.test:
Disable the warnings for misc conversion
mysql-test/t/warnings.test:
More warning tests
Diffstat (limited to 'mysql-test/r/key.result')
| -rw-r--r-- | mysql-test/r/key.result | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/mysql-test/r/key.result b/mysql-test/r/key.result index 9e1f743d132..168bc276c30 100644 --- a/mysql-test/r/key.result +++ b/mysql-test/r/key.result @@ -32,6 +32,11 @@ KEY price (price,area,type,transityes,shopsyes,schoolsyes,petsyes) 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 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'); @@ -90,9 +95,13 @@ 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, @@ -150,6 +159,9 @@ drop table t1; 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 SELECT * FROM t1; c i 1 |