diff options
Diffstat (limited to 'mysql-test/r/type_num.result')
| -rw-r--r-- | mysql-test/r/type_num.result | 1222 |
1 files changed, 1222 insertions, 0 deletions
diff --git a/mysql-test/r/type_num.result b/mysql-test/r/type_num.result new file mode 100644 index 00000000000..cbac7b6f445 --- /dev/null +++ b/mysql-test/r/type_num.result @@ -0,0 +1,1222 @@ +# +# Start of 10.0 tests +# +# +# MDEV-8468 CAST and INSERT work differently for DECIMAL/INT vs DOUBLE for a string with trailing spaces +# +SET sql_mode='STRICT_ALL_TABLES'; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES ('1 '); +Warnings: +Note 1265 Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES ('1 '); +Warnings: +Note 1265 Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES ('1 '); +Warnings: +Note 1265 Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES ('1 '); +Warnings: +Note 1265 Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES ('1 '); +Warnings: +Note 1265 Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES ('1 '); +Warnings: +Note 1265 Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES ('1 '); +Warnings: +Note 1265 Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES (''); +ERROR 22007: Incorrect double value: '' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES (''); +ERROR 22007: Incorrect double value: '' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES (''); +ERROR 22007: Incorrect integer value: '' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES (''); +ERROR 22007: Incorrect integer value: '' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (''); +ERROR 22007: Incorrect integer value: '' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES (''); +ERROR 22007: Incorrect integer value: '' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES (''); +ERROR 22007: Incorrect decimal value: '' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES ('x'); +ERROR 22007: Incorrect double value: 'x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES ('x'); +ERROR 22007: Incorrect double value: 'x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES ('x'); +ERROR 22007: Incorrect integer value: 'x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES ('x'); +ERROR 22007: Incorrect integer value: 'x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES ('x'); +ERROR 22007: Incorrect integer value: 'x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES ('x'); +ERROR 22007: Incorrect integer value: 'x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES ('x'); +ERROR 22007: Incorrect decimal value: 'x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES (' x'); +ERROR 22007: Incorrect double value: ' x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES (' x'); +ERROR 22007: Incorrect double value: ' x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES (' x'); +ERROR 22007: Incorrect integer value: ' x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES (' x'); +ERROR 22007: Incorrect integer value: ' x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES (' x'); +ERROR 22007: Incorrect integer value: ' x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES (' x'); +ERROR 22007: Incorrect integer value: ' x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES (' x'); +ERROR 22007: Incorrect decimal value: ' x' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES ('.'); +ERROR 22007: Incorrect double value: '.' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES ('.'); +ERROR 22007: Incorrect double value: '.' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES ('.'); +ERROR 22007: Incorrect integer value: '.' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES ('.'); +ERROR 22007: Incorrect integer value: '.' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES ('.'); +ERROR 22007: Incorrect integer value: '.' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES ('.'); +ERROR 22007: Incorrect integer value: '.' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES ('.'); +ERROR 22007: Incorrect decimal value: '.' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES ('-'); +ERROR 22007: Incorrect double value: '-' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES ('-'); +ERROR 22007: Incorrect double value: '-' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES ('-'); +ERROR 22007: Incorrect integer value: '-' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES ('-'); +ERROR 22007: Incorrect integer value: '-' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES ('-'); +ERROR 22007: Incorrect integer value: '-' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES ('-'); +ERROR 22007: Incorrect integer value: '-' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES ('-'); +ERROR 22007: Incorrect decimal value: '-' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES ('+'); +ERROR 22007: Incorrect double value: '+' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES ('+'); +ERROR 22007: Incorrect double value: '+' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES ('+'); +ERROR 22007: Incorrect integer value: '+' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES ('+'); +ERROR 22007: Incorrect integer value: '+' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES ('+'); +ERROR 22007: Incorrect integer value: '+' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES ('+'); +ERROR 22007: Incorrect integer value: '+' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES ('+'); +ERROR 22007: Incorrect decimal value: '+' for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES ('1x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES ('1x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES ('1x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES ('1x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES ('1x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES ('1x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES ('1x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES ('1e'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES ('1e'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES ('1e'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES ('1e'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES ('1e'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES ('1e'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES ('1e'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES ('1e+'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES ('1e+'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES ('1e+'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES ('1e+'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES ('1e+'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES ('1e+'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES ('1e+'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES ('1E-'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES ('1E-'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES ('1E-'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES ('1E-'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES ('1E-'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES ('1E-'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES ('1E-'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES ('1Ex'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES ('1Ex'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES ('1Ex'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES ('1Ex'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES ('1Ex'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES ('1Ex'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES ('1Ex'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES ('1e+x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES ('1e+x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES ('1e+x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES ('1e+x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES ('1e+x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES ('1e+x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES ('1e+x'); +ERROR 01000: Data truncated for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a FLOAT); +INSERT INTO t1 VALUES ('1e1000'); +ERROR 22003: Out of range value for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DOUBLE); +INSERT INTO t1 VALUES ('1e1000'); +ERROR 22003: Out of range value for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a TINYINT); +INSERT INTO t1 VALUES ('1e1000'); +ERROR 22003: Out of range value for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a SMALLINT); +INSERT INTO t1 VALUES ('1e1000'); +ERROR 22003: Out of range value for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a INT); +INSERT INTO t1 VALUES ('1e1000'); +ERROR 22003: Out of range value for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a BIGINT); +INSERT INTO t1 VALUES ('1e1000'); +ERROR 22003: Out of range value for column 'a' at row 1 +DROP TABLE t1; +CREATE TABLE t1 (a DECIMAL); +INSERT INTO t1 VALUES ('1e1000'); +ERROR 22003: Out of range value for column 'a' at row 1 +DROP TABLE t1; +SET sql_mode=DEFAULT; +CREATE TABLE t1 ( +f4 FLOAT, +f8 DOUBLE, +i1 TINYINT, +i2 SMALLINT, +i4 INT, +i8 BIGINT, +d DECIMAL +); +INSERT INTO t1 VALUES ('1 ','1 ','1 ','1 ','1 ','1 ','1 '); +Warnings: +Note 1265 Data truncated for column 'f4' at row 1 +Note 1265 Data truncated for column 'f8' at row 1 +Note 1265 Data truncated for column 'i1' at row 1 +Note 1265 Data truncated for column 'i2' at row 1 +Note 1265 Data truncated for column 'i4' at row 1 +Note 1265 Data truncated for column 'i8' at row 1 +Note 1265 Data truncated for column 'd' at row 1 +INSERT INTO t1 VALUES ('','','','','','',''); +Warnings: +Warning 1366 Incorrect double value: '' for column 'f4' at row 1 +Warning 1366 Incorrect double value: '' for column 'f8' at row 1 +Warning 1366 Incorrect integer value: '' for column 'i1' at row 1 +Warning 1366 Incorrect integer value: '' for column 'i2' at row 1 +Warning 1366 Incorrect integer value: '' for column 'i4' at row 1 +Warning 1366 Incorrect integer value: '' for column 'i8' at row 1 +Warning 1366 Incorrect decimal value: '' for column 'd' at row 1 +INSERT INTO t1 VALUES ('x','x','x','x','x','x','x'); +Warnings: +Warning 1366 Incorrect double value: 'x' for column 'f4' at row 1 +Warning 1366 Incorrect double value: 'x' for column 'f8' at row 1 +Warning 1366 Incorrect integer value: 'x' for column 'i1' at row 1 +Warning 1366 Incorrect integer value: 'x' for column 'i2' at row 1 +Warning 1366 Incorrect integer value: 'x' for column 'i4' at row 1 +Warning 1366 Incorrect integer value: 'x' for column 'i8' at row 1 +Warning 1366 Incorrect decimal value: 'x' for column 'd' at row 1 +INSERT INTO t1 VALUES (' x',' x',' x',' x',' x',' x',' x'); +Warnings: +Warning 1366 Incorrect double value: ' x' for column 'f4' at row 1 +Warning 1366 Incorrect double value: ' x' for column 'f8' at row 1 +Warning 1366 Incorrect integer value: ' x' for column 'i1' at row 1 +Warning 1366 Incorrect integer value: ' x' for column 'i2' at row 1 +Warning 1366 Incorrect integer value: ' x' for column 'i4' at row 1 +Warning 1366 Incorrect integer value: ' x' for column 'i8' at row 1 +Warning 1366 Incorrect decimal value: ' x' for column 'd' at row 1 +INSERT INTO t1 VALUES ('.','.','.','.','.','.','.'); +Warnings: +Warning 1366 Incorrect double value: '.' for column 'f4' at row 1 +Warning 1366 Incorrect double value: '.' for column 'f8' at row 1 +Warning 1366 Incorrect integer value: '.' for column 'i1' at row 1 +Warning 1366 Incorrect integer value: '.' for column 'i2' at row 1 +Warning 1366 Incorrect integer value: '.' for column 'i4' at row 1 +Warning 1366 Incorrect integer value: '.' for column 'i8' at row 1 +Warning 1366 Incorrect decimal value: '.' for column 'd' at row 1 +INSERT INTO t1 VALUES ('-','-','-','-','-','-','-'); +Warnings: +Warning 1366 Incorrect double value: '-' for column 'f4' at row 1 +Warning 1366 Incorrect double value: '-' for column 'f8' at row 1 +Warning 1366 Incorrect integer value: '-' for column 'i1' at row 1 +Warning 1366 Incorrect integer value: '-' for column 'i2' at row 1 +Warning 1366 Incorrect integer value: '-' for column 'i4' at row 1 +Warning 1366 Incorrect integer value: '-' for column 'i8' at row 1 +Warning 1366 Incorrect decimal value: '-' for column 'd' at row 1 +INSERT INTO t1 VALUES ('+','+','+','+','+','+','+'); +Warnings: +Warning 1366 Incorrect double value: '+' for column 'f4' at row 1 +Warning 1366 Incorrect double value: '+' for column 'f8' at row 1 +Warning 1366 Incorrect integer value: '+' for column 'i1' at row 1 +Warning 1366 Incorrect integer value: '+' for column 'i2' at row 1 +Warning 1366 Incorrect integer value: '+' for column 'i4' at row 1 +Warning 1366 Incorrect integer value: '+' for column 'i8' at row 1 +Warning 1366 Incorrect decimal value: '+' for column 'd' at row 1 +INSERT INTO t1 VALUES ('1x','1x','1x','1x','1x','1x','1x'); +Warnings: +Warning 1265 Data truncated for column 'f4' at row 1 +Warning 1265 Data truncated for column 'f8' at row 1 +Warning 1265 Data truncated for column 'i1' at row 1 +Warning 1265 Data truncated for column 'i2' at row 1 +Warning 1265 Data truncated for column 'i4' at row 1 +Warning 1265 Data truncated for column 'i8' at row 1 +Warning 1265 Data truncated for column 'd' at row 1 +INSERT INTO t1 VALUES ('1e','1e','1e','1e','1e','1e','1e'); +Warnings: +Warning 1265 Data truncated for column 'f4' at row 1 +Warning 1265 Data truncated for column 'f8' at row 1 +Warning 1265 Data truncated for column 'i1' at row 1 +Warning 1265 Data truncated for column 'i2' at row 1 +Warning 1265 Data truncated for column 'i4' at row 1 +Warning 1265 Data truncated for column 'i8' at row 1 +Warning 1265 Data truncated for column 'd' at row 1 +INSERT INTO t1 VALUES ('1e-','1e-','1e-','1e-','1e-','1e-','1e-'); +Warnings: +Warning 1265 Data truncated for column 'f4' at row 1 +Warning 1265 Data truncated for column 'f8' at row 1 +Warning 1265 Data truncated for column 'i1' at row 1 +Warning 1265 Data truncated for column 'i2' at row 1 +Warning 1265 Data truncated for column 'i4' at row 1 +Warning 1265 Data truncated for column 'i8' at row 1 +Warning 1265 Data truncated for column 'd' at row 1 +INSERT INTO t1 VALUES ('1E+','1E+','1E+','1E+','1E+','1E+','1E+'); +Warnings: +Warning 1265 Data truncated for column 'f4' at row 1 +Warning 1265 Data truncated for column 'f8' at row 1 +Warning 1265 Data truncated for column 'i1' at row 1 +Warning 1265 Data truncated for column 'i2' at row 1 +Warning 1265 Data truncated for column 'i4' at row 1 +Warning 1265 Data truncated for column 'i8' at row 1 +Warning 1265 Data truncated for column 'd' at row 1 +INSERT INTO t1 VALUES ('1e1000','1e1000','1e1000','1e1000','1e1000','1e1000','1e1000'); +Warnings: +Warning 1264 Out of range value for column 'f4' at row 1 +Warning 1264 Out of range value for column 'f4' at row 1 +Warning 1264 Out of range value for column 'f8' at row 1 +Warning 1264 Out of range value for column 'i1' at row 1 +Warning 1264 Out of range value for column 'i2' at row 1 +Warning 1264 Out of range value for column 'i4' at row 1 +Warning 1264 Out of range value for column 'i8' at row 1 +Warning 1264 Out of range value for column 'd' at row 1 +DELETE FROM t1; +INSERT INTO t1 VALUES (0,0,0,0,0,0,0); +INSERT INTO t1 VALUES (0,0,0,0,0,0,0); +INSERT INTO t1 VALUES (1,1,1,1,1,1,1); +INSERT INTO t1 VALUES (1,1,1,1,1,1,1); +INSERT INTO t1 VALUES (2,2,2,2,2,2,2); +INSERT INTO t1 VALUES (2,2,2,2,2,2,2); +INSERT INTO t1 VALUES (3,3,3,3,3,3,3); +INSERT INTO t1 VALUES (3,3,3,3,3,3,3); +INSERT INTO t1 VALUES (4,4,4,4,4,4,4); +INSERT INTO t1 VALUES (4,4,4,4,4,4,4); +INSERT INTO t1 VALUES (5,5,5,5,5,5,5); +INSERT INTO t1 VALUES (5,5,5,5,5,5,5); +SELECT COUNT(*) FROM t1 WHERE f4='1 '; +COUNT(*) +2 +Warnings: +Note 1292 Truncated incorrect DOUBLE value: '1 ' +SELECT COUNT(*) FROM t1 WHERE f8='1 '; +COUNT(*) +2 +Warnings: +Note 1292 Truncated incorrect DOUBLE value: '1 ' +SELECT COUNT(*) FROM t1 WHERE i1='1 '; +COUNT(*) +2 +Warnings: +Note 1292 Truncated incorrect DOUBLE value: '1 ' +SELECT COUNT(*) FROM t1 WHERE i2='1 '; +COUNT(*) +2 +Warnings: +Note 1292 Truncated incorrect DOUBLE value: '1 ' +SELECT COUNT(*) FROM t1 WHERE i4='1 '; +COUNT(*) +2 +Warnings: +Note 1292 Truncated incorrect DOUBLE value: '1 ' +SELECT COUNT(*) FROM t1 WHERE i8='1 '; +COUNT(*) +2 +Warnings: +Note 1292 Truncated incorrect DOUBLE value: '1 ' +SELECT COUNT(*) FROM t1 WHERE d='1 '; +COUNT(*) +2 +Warnings: +Note 1292 Truncated incorrect DOUBLE value: '1 ' +SELECT COUNT(*) FROM t1 WHERE f4=''; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '' +SELECT COUNT(*) FROM t1 WHERE f8=''; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '' +SELECT COUNT(*) FROM t1 WHERE i1=''; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '' +SELECT COUNT(*) FROM t1 WHERE i2=''; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '' +SELECT COUNT(*) FROM t1 WHERE i4=''; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '' +SELECT COUNT(*) FROM t1 WHERE i8=''; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '' +SELECT COUNT(*) FROM t1 WHERE d=''; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '' +SELECT COUNT(*) FROM t1 WHERE f4='x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'x' +SELECT COUNT(*) FROM t1 WHERE f8='x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'x' +SELECT COUNT(*) FROM t1 WHERE i1='x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'x' +SELECT COUNT(*) FROM t1 WHERE i2='x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'x' +SELECT COUNT(*) FROM t1 WHERE i4='x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'x' +SELECT COUNT(*) FROM t1 WHERE i8='x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'x' +SELECT COUNT(*) FROM t1 WHERE d='x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: 'x' +SELECT COUNT(*) FROM t1 WHERE f4=' x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: ' x' +SELECT COUNT(*) FROM t1 WHERE f8=' x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: ' x' +SELECT COUNT(*) FROM t1 WHERE i1=' x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: ' x' +SELECT COUNT(*) FROM t1 WHERE i2=' x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: ' x' +SELECT COUNT(*) FROM t1 WHERE i4=' x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: ' x' +SELECT COUNT(*) FROM t1 WHERE i8=' x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: ' x' +SELECT COUNT(*) FROM t1 WHERE d=' x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: ' x' +SELECT COUNT(*) FROM t1 WHERE f4='.'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '.' +SELECT COUNT(*) FROM t1 WHERE f8='.'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '.' +SELECT COUNT(*) FROM t1 WHERE i1='.'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '.' +SELECT COUNT(*) FROM t1 WHERE i2='.'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '.' +SELECT COUNT(*) FROM t1 WHERE i4='.'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '.' +SELECT COUNT(*) FROM t1 WHERE i8='.'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '.' +SELECT COUNT(*) FROM t1 WHERE d='.'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '.' +SELECT COUNT(*) FROM t1 WHERE f4='-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '-' +SELECT COUNT(*) FROM t1 WHERE f8='-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '-' +SELECT COUNT(*) FROM t1 WHERE i1='-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '-' +SELECT COUNT(*) FROM t1 WHERE i2='-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '-' +SELECT COUNT(*) FROM t1 WHERE i4='-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '-' +SELECT COUNT(*) FROM t1 WHERE i8='-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '-' +SELECT COUNT(*) FROM t1 WHERE d='-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '-' +SELECT COUNT(*) FROM t1 WHERE f4='+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '+' +SELECT COUNT(*) FROM t1 WHERE f8='+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '+' +SELECT COUNT(*) FROM t1 WHERE i1='+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '+' +SELECT COUNT(*) FROM t1 WHERE i2='+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '+' +SELECT COUNT(*) FROM t1 WHERE i4='+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '+' +SELECT COUNT(*) FROM t1 WHERE i8='+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '+' +SELECT COUNT(*) FROM t1 WHERE d='+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '+' +SELECT COUNT(*) FROM t1 WHERE f4='1x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1x' +SELECT COUNT(*) FROM t1 WHERE f8='1x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1x' +SELECT COUNT(*) FROM t1 WHERE i1='1x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1x' +SELECT COUNT(*) FROM t1 WHERE i2='1x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1x' +SELECT COUNT(*) FROM t1 WHERE i4='1x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1x' +SELECT COUNT(*) FROM t1 WHERE i8='1x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1x' +SELECT COUNT(*) FROM t1 WHERE d='1x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1x' +SELECT COUNT(*) FROM t1 WHERE f4='1e'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e' +SELECT COUNT(*) FROM t1 WHERE f8='1e'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e' +SELECT COUNT(*) FROM t1 WHERE i1='1e'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e' +SELECT COUNT(*) FROM t1 WHERE i2='1e'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e' +SELECT COUNT(*) FROM t1 WHERE i4='1e'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e' +SELECT COUNT(*) FROM t1 WHERE i8='1e'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e' +SELECT COUNT(*) FROM t1 WHERE d='1e'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e' +SELECT COUNT(*) FROM t1 WHERE f4='1e+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+' +SELECT COUNT(*) FROM t1 WHERE f8='1e+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+' +SELECT COUNT(*) FROM t1 WHERE i1='1e+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+' +SELECT COUNT(*) FROM t1 WHERE i2='1e+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+' +SELECT COUNT(*) FROM t1 WHERE i4='1e+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+' +SELECT COUNT(*) FROM t1 WHERE i8='1e+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+' +SELECT COUNT(*) FROM t1 WHERE d='1e+'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+' +SELECT COUNT(*) FROM t1 WHERE f4='1E-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1E-' +SELECT COUNT(*) FROM t1 WHERE f8='1E-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1E-' +SELECT COUNT(*) FROM t1 WHERE i1='1E-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1E-' +SELECT COUNT(*) FROM t1 WHERE i2='1E-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1E-' +SELECT COUNT(*) FROM t1 WHERE i4='1E-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1E-' +SELECT COUNT(*) FROM t1 WHERE i8='1E-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1E-' +SELECT COUNT(*) FROM t1 WHERE d='1E-'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1E-' +SELECT COUNT(*) FROM t1 WHERE f4='1Ex'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1Ex' +SELECT COUNT(*) FROM t1 WHERE f8='1Ex'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1Ex' +SELECT COUNT(*) FROM t1 WHERE i1='1Ex'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1Ex' +SELECT COUNT(*) FROM t1 WHERE i2='1Ex'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1Ex' +SELECT COUNT(*) FROM t1 WHERE i4='1Ex'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1Ex' +SELECT COUNT(*) FROM t1 WHERE i8='1Ex'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1Ex' +SELECT COUNT(*) FROM t1 WHERE d='1Ex'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1Ex' +SELECT COUNT(*) FROM t1 WHERE f4='1e+x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+x' +SELECT COUNT(*) FROM t1 WHERE f8='1e+x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+x' +SELECT COUNT(*) FROM t1 WHERE i1='1e+x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+x' +SELECT COUNT(*) FROM t1 WHERE i2='1e+x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+x' +SELECT COUNT(*) FROM t1 WHERE i4='1e+x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+x' +SELECT COUNT(*) FROM t1 WHERE i8='1e+x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+x' +SELECT COUNT(*) FROM t1 WHERE d='1e+x'; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e+x' +SELECT COUNT(*) FROM t1 WHERE f4='1e1000'; +COUNT(*) +0 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e1000' +SELECT COUNT(*) FROM t1 WHERE f8='1e1000'; +COUNT(*) +0 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e1000' +SELECT COUNT(*) FROM t1 WHERE i1='1e1000'; +COUNT(*) +0 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e1000' +SELECT COUNT(*) FROM t1 WHERE i2='1e1000'; +COUNT(*) +0 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e1000' +SELECT COUNT(*) FROM t1 WHERE i4='1e1000'; +COUNT(*) +0 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e1000' +SELECT COUNT(*) FROM t1 WHERE i8='1e1000'; +COUNT(*) +0 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e1000' +SELECT COUNT(*) FROM t1 WHERE d='1e1000'; +COUNT(*) +0 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '1e1000' +ALTER TABLE t1 +ADD KEY f4(f4), +ADD KEY f8(f8), +ADD KEY i1(i1), +ADD KEY i2(i2), +ADD KEY i4(i4), +ADD KEY i8(i8), +ADD KEY d(d); +SELECT COUNT(*) FROM t1 FORCE INDEX(f4) WHERE f4='1 '; +COUNT(*) +2 +Warnings: +Note 1292 Truncated incorrect DOUBLE value: '1 ' +SELECT COUNT(*) FROM t1 FORCE INDEX(f8) WHERE f8='1 '; +COUNT(*) +2 +SELECT COUNT(*) FROM t1 FORCE INDEX(i1) WHERE i1='1 '; +COUNT(*) +2 +SELECT COUNT(*) FROM t1 FORCE INDEX(i2) WHERE i2='1 '; +COUNT(*) +2 +SELECT COUNT(*) FROM t1 FORCE INDEX(i4) WHERE i4='1 '; +COUNT(*) +2 +SELECT COUNT(*) FROM t1 FORCE INDEX(i8) WHERE i8='1 '; +COUNT(*) +2 +Warnings: +Note 1292 Truncated incorrect DOUBLE value: '1 ' +SELECT COUNT(*) FROM t1 FORCE INDEX(d) WHERE d='1 '; +COUNT(*) +2 +SELECT COUNT(*) FROM t1 FORCE INDEX(f4) WHERE f4=''; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '' +SELECT COUNT(*) FROM t1 FORCE INDEX(f8) WHERE f8=''; +COUNT(*) +2 +SELECT COUNT(*) FROM t1 FORCE INDEX(i1) WHERE i1=''; +COUNT(*) +2 +SELECT COUNT(*) FROM t1 FORCE INDEX(i2) WHERE i2=''; +COUNT(*) +2 +SELECT COUNT(*) FROM t1 FORCE INDEX(i4) WHERE i4=''; +COUNT(*) +2 +SELECT COUNT(*) FROM t1 FORCE INDEX(i8) WHERE i8=''; +COUNT(*) +2 +Warnings: +Warning 1292 Truncated incorrect DOUBLE value: '' +SELECT COUNT(*) FROM t1 FORCE INDEX(d) WHERE d=''; +COUNT(*) +2 +DROP TABLE t1; +SELECT +CAST('1 ' AS SIGNED), +CAST('1 ' AS UNSIGNED), +CAST('1 ' AS DECIMAL), +CAST('1 ' AS DOUBLE); +CAST('1 ' AS SIGNED) CAST('1 ' AS UNSIGNED) CAST('1 ' AS DECIMAL) CAST('1 ' AS DOUBLE) +1 1 1 1 +Warnings: +Note 1292 Truncated incorrect INTEGER value: '1 ' +Note 1292 Truncated incorrect INTEGER value: '1 ' +Note 1292 Truncated incorrect DECIMAL value: '1 ' +Note 1292 Truncated incorrect DOUBLE value: '1 ' +SELECT +CAST('' AS SIGNED), +CAST('' AS UNSIGNED), +CAST('' AS DECIMAL), +CAST('' AS DOUBLE); +CAST('' AS SIGNED) CAST('' AS UNSIGNED) CAST('' AS DECIMAL) CAST('' AS DOUBLE) +0 0 0 0 +Warnings: +Warning 1292 Truncated incorrect INTEGER value: '' +Warning 1292 Truncated incorrect INTEGER value: '' +Warning 1292 Truncated incorrect DECIMAL value: '' +Warning 1292 Truncated incorrect DOUBLE value: '' +SELECT +CAST('x' AS SIGNED), +CAST('x' AS UNSIGNED), +CAST('x' AS DECIMAL), +CAST('x' AS DOUBLE); +CAST('x' AS SIGNED) CAST('x' AS UNSIGNED) CAST('x' AS DECIMAL) CAST('x' AS DOUBLE) +0 0 0 0 +Warnings: +Warning 1292 Truncated incorrect INTEGER value: 'x' +Warning 1292 Truncated incorrect INTEGER value: 'x' +Warning 1292 Truncated incorrect DECIMAL value: 'x' +Warning 1292 Truncated incorrect DOUBLE value: 'x' +SELECT +CAST(' x' AS SIGNED), +CAST(' x' AS UNSIGNED), +CAST(' x' AS DECIMAL), +CAST(' x' AS DOUBLE); +CAST(' x' AS SIGNED) CAST(' x' AS UNSIGNED) CAST(' x' AS DECIMAL) CAST(' x' AS DOUBLE) +0 0 0 0 +Warnings: +Warning 1292 Truncated incorrect INTEGER value: ' x' +Warning 1292 Truncated incorrect INTEGER value: ' x' +Warning 1292 Truncated incorrect DECIMAL value: ' x' +Warning 1292 Truncated incorrect DOUBLE value: ' x' +SELECT +CAST('.' AS SIGNED), +CAST('.' AS UNSIGNED), +CAST('.' AS DECIMAL), +CAST('.' AS DOUBLE); +CAST('.' AS SIGNED) CAST('.' AS UNSIGNED) CAST('.' AS DECIMAL) CAST('.' AS DOUBLE) +0 0 0 0 +Warnings: +Warning 1292 Truncated incorrect INTEGER value: '.' +Warning 1292 Truncated incorrect INTEGER value: '.' +Warning 1292 Truncated incorrect DECIMAL value: '.' +Warning 1292 Truncated incorrect DOUBLE value: '.' +SELECT +CAST('-' AS SIGNED), +CAST('-' AS UNSIGNED), +CAST('-' AS DECIMAL), +CAST('-' AS DOUBLE); +CAST('-' AS SIGNED) CAST('-' AS UNSIGNED) CAST('-' AS DECIMAL) CAST('-' AS DOUBLE) +0 0 0 0 +Warnings: +Warning 1292 Truncated incorrect INTEGER value: '-' +Warning 1292 Truncated incorrect INTEGER value: '-' +Warning 1292 Truncated incorrect DECIMAL value: '-' +Warning 1292 Truncated incorrect DOUBLE value: '-' +SELECT +CAST('+' AS SIGNED), +CAST('+' AS UNSIGNED), +CAST('+' AS DECIMAL), +CAST('+' AS DOUBLE); +CAST('+' AS SIGNED) CAST('+' AS UNSIGNED) CAST('+' AS DECIMAL) CAST('+' AS DOUBLE) +0 0 0 0 +Warnings: +Warning 1292 Truncated incorrect INTEGER value: '+' +Warning 1292 Truncated incorrect INTEGER value: '+' +Warning 1292 Truncated incorrect DECIMAL value: '+' +Warning 1292 Truncated incorrect DOUBLE value: '+' +SELECT +CAST('1x' AS SIGNED), +CAST('1x' AS UNSIGNED), +CAST('1x' AS DECIMAL), +CAST('1x' AS DOUBLE); +CAST('1x' AS SIGNED) CAST('1x' AS UNSIGNED) CAST('1x' AS DECIMAL) CAST('1x' AS DOUBLE) +1 1 1 1 +Warnings: +Warning 1292 Truncated incorrect INTEGER value: '1x' +Warning 1292 Truncated incorrect INTEGER value: '1x' +Warning 1292 Truncated incorrect DECIMAL value: '1x' +Warning 1292 Truncated incorrect DOUBLE value: '1x' +SELECT +CAST('1e' AS SIGNED), +CAST('1e' AS UNSIGNED), +CAST('1e' AS DECIMAL), +CAST('1e' AS DOUBLE); +CAST('1e' AS SIGNED) CAST('1e' AS UNSIGNED) CAST('1e' AS DECIMAL) CAST('1e' AS DOUBLE) +1 1 1 1 +Warnings: +Warning 1292 Truncated incorrect INTEGER value: '1e' +Warning 1292 Truncated incorrect INTEGER value: '1e' +Warning 1292 Truncated incorrect DECIMAL value: '1e' +Warning 1292 Truncated incorrect DOUBLE value: '1e' +SELECT +CAST('1e-' AS SIGNED), +CAST('1e-' AS UNSIGNED), +CAST('1e-' AS DECIMAL), +CAST('1e-' AS DOUBLE); +CAST('1e-' AS SIGNED) CAST('1e-' AS UNSIGNED) CAST('1e-' AS DECIMAL) CAST('1e-' AS DOUBLE) +1 1 1 1 +Warnings: +Warning 1292 Truncated incorrect INTEGER value: '1e-' +Warning 1292 Truncated incorrect INTEGER value: '1e-' +Warning 1292 Truncated incorrect DECIMAL value: '1e-' +Warning 1292 Truncated incorrect DOUBLE value: '1e-' +SELECT +CAST('1E+' AS SIGNED), +CAST('1E+' AS UNSIGNED), +CAST('1E+' AS DECIMAL), +CAST('1E+' AS DOUBLE); +CAST('1E+' AS SIGNED) CAST('1E+' AS UNSIGNED) CAST('1E+' AS DECIMAL) CAST('1E+' AS DOUBLE) +1 1 1 1 +Warnings: +Warning 1292 Truncated incorrect INTEGER value: '1E+' +Warning 1292 Truncated incorrect INTEGER value: '1E+' +Warning 1292 Truncated incorrect DECIMAL value: '1E+' +Warning 1292 Truncated incorrect DOUBLE value: '1E+' +# +# End of 10.0 tests +# |