Edit File: in_number_boundary_error.result
SET SQL_MODE="TRADITIONAL,ANSI"; DROP TABLE IF EXISTS t4; CREATE TABLE t4(c1 TINYINT UNSIGNED NOT NULL); INSERT INTO t4 (c1) VALUES(NULL); ERROR 23000: Column 'c1' cannot be null INSERT INTO t4 (c1) VALUES(0); INSERT INTO t4 (c1) VALUES(-1); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t4 (c1) VALUES('x'); ERROR HY000: Incorrect integer value: 'x' for column 'c1' at row 1 INSERT INTO t4 (c1) VALUES('9'); SELECT COUNT(c1) AS total_rows FROM t4; total_rows 2 SELECT COUNT(c1) AS null_rows FROM t4 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t4 WHERE c1 IS NOT NULL; not_null_rows 2 DROP TABLE t4; CREATE TABLE t4(c1 SMALLINT UNSIGNED NOT NULL); INSERT INTO t4 (c1) VALUES(NULL); ERROR 23000: Column 'c1' cannot be null INSERT INTO t4 (c1) VALUES(0); INSERT INTO t4 (c1) VALUES(-1); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t4 (c1) VALUES('x'); ERROR HY000: Incorrect integer value: 'x' for column 'c1' at row 1 INSERT INTO t4 (c1) VALUES('9'); SELECT COUNT(c1) AS total_rows FROM t4; total_rows 2 SELECT COUNT(c1) AS null_rows FROM t4 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t4 WHERE c1 IS NOT NULL; not_null_rows 2 DROP TABLE t4; CREATE TABLE t4(c1 MEDIUMINT UNSIGNED NOT NULL); INSERT INTO t4 (c1) VALUES(NULL); ERROR 23000: Column 'c1' cannot be null INSERT INTO t4 (c1) VALUES(0); INSERT INTO t4 (c1) VALUES(-1); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t4 (c1) VALUES('x'); ERROR HY000: Incorrect integer value: 'x' for column 'c1' at row 1 INSERT INTO t4 (c1) VALUES('9'); SELECT COUNT(c1) AS total_rows FROM t4; total_rows 2 SELECT COUNT(c1) AS null_rows FROM t4 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t4 WHERE c1 IS NOT NULL; not_null_rows 2 DROP TABLE t4; CREATE TABLE t4(c1 INT UNSIGNED NOT NULL); INSERT INTO t4 (c1) VALUES(NULL); ERROR 23000: Column 'c1' cannot be null INSERT INTO t4 (c1) VALUES(0); INSERT INTO t4 (c1) VALUES(-1); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t4 (c1) VALUES('x'); ERROR HY000: Incorrect integer value: 'x' for column 'c1' at row 1 INSERT INTO t4 (c1) VALUES('9'); SELECT COUNT(c1) AS total_rows FROM t4; total_rows 2 SELECT COUNT(c1) AS null_rows FROM t4 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t4 WHERE c1 IS NOT NULL; not_null_rows 2 DROP TABLE t4; CREATE TABLE t4(c1 INTEGER UNSIGNED NOT NULL); INSERT INTO t4 (c1) VALUES(NULL); ERROR 23000: Column 'c1' cannot be null INSERT INTO t4 (c1) VALUES(0); INSERT INTO t4 (c1) VALUES(-1); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t4 (c1) VALUES('x'); ERROR HY000: Incorrect integer value: 'x' for column 'c1' at row 1 INSERT INTO t4 (c1) VALUES('9'); SELECT COUNT(c1) AS total_rows FROM t4; total_rows 2 SELECT COUNT(c1) AS null_rows FROM t4 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t4 WHERE c1 IS NOT NULL; not_null_rows 2 DROP TABLE t4; CREATE TABLE t4(c1 BIGINT UNSIGNED NOT NULL); INSERT INTO t4 (c1) VALUES(NULL); ERROR 23000: Column 'c1' cannot be null INSERT INTO t4 (c1) VALUES(0); INSERT INTO t4 (c1) VALUES(-1); ERROR 22003: Out of range value for column 'c1' at row 1 INSERT INTO t4 (c1) VALUES('x'); ERROR HY000: Incorrect integer value: 'x' for column 'c1' at row 1 INSERT INTO t4 (c1) VALUES('9'); SELECT COUNT(c1) AS total_rows FROM t4; total_rows 2 SELECT COUNT(c1) AS null_rows FROM t4 WHERE c1 IS NULL; null_rows 0 SELECT COUNT(c1) AS not_null_rows FROM t4 WHERE c1 IS NOT NULL; not_null_rows 2 DROP TABLE t4;
Back to File Manager