diff options
| author | monty@mysql.com <> | 2004-12-06 02:00:37 +0200 |
|---|---|---|
| committer | monty@mysql.com <> | 2004-12-06 02:00:37 +0200 |
| commit | 67ce24796584e80cf843b37b09aeb794c9231190 (patch) | |
| tree | b75e098b12b8e91a3470008602bacbb5b3009e45 /mysql-test/r/strict.result | |
| parent | 46089cfd144be3430f69e2a8b48b0aeee154d6fa (diff) | |
| download | mariadb-git-67ce24796584e80cf843b37b09aeb794c9231190.tar.gz | |
Add support for up to VARCHAR (size up to 65535)
Renamed HA_VAR_LENGTH to HA_VAR_LENGTH_PART
Renamed in all files FIELD_TYPE_STRING and FIELD_TYPE_VAR_STRING to MYSQL_TYPE_STRING and MYSQL_TYPE_VAR_STRING to make it easy to catch all possible errors
Added support for VARCHAR KEYS to heap
Removed support for ISAM
Now only long VARCHAR columns are changed to TEXT on demand (not CHAR)
Internal temporary files can now use fixed length tables if the used VARCHAR columns are short
Diffstat (limited to 'mysql-test/r/strict.result')
| -rw-r--r-- | mysql-test/r/strict.result | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/mysql-test/r/strict.result b/mysql-test/r/strict.result index 19c4def9b32..4c2dcd19a9c 100644 --- a/mysql-test/r/strict.result +++ b/mysql-test/r/strict.result @@ -810,12 +810,14 @@ col1 col2 NULL NULL 1.79769313486232e+308 0 DROP TABLE t1; -CREATE TABLE t1 (col1 CHAR(5), col2 VARCHAR(5)); -INSERT INTO t1 VALUES ('hello', 'hello'),('he', 'he'),('hello ', 'hello '); +CREATE TABLE t1 (col1 CHAR(5), col2 VARCHAR(6)); +INSERT INTO t1 VALUES ('hello', 'hello'),('he', 'he'),('hello ', 'hello '); INSERT INTO t1 (col1) VALUES ('hellobob'); ERROR 01000: Data truncated for column 'col1' at row 1 INSERT INTO t1 (col2) VALUES ('hellobob'); ERROR 01000: Data truncated for column 'col2' at row 1 +INSERT INTO t1 (col2) VALUES ('hello '); +ERROR 01000: Data truncated for column 'col2' at row 1 UPDATE t1 SET col1 ='hellobob' WHERE col1 ='he'; ERROR 01000: Data truncated for column 'col1' at row 2 UPDATE t1 SET col2 ='hellobob' WHERE col2 ='he'; @@ -830,9 +832,9 @@ Warning 1265 Data truncated for column 'col2' at row 2 SELECT * FROM t1; col1 col2 hello hello -he hello -hello hello -hello hello +he hellot +hello hello +hello hellob DROP TABLE t1; CREATE TABLE t1 (col1 enum('red','blue','green')); INSERT INTO t1 VALUES ('red'),('blue'),('green'); |