diff options
Diffstat (limited to 'mysql-test/suite/engines/funcs/r/in_number_unique_constraint_error.result')
-rw-r--r-- | mysql-test/suite/engines/funcs/r/in_number_unique_constraint_error.result | 141 |
1 files changed, 141 insertions, 0 deletions
diff --git a/mysql-test/suite/engines/funcs/r/in_number_unique_constraint_error.result b/mysql-test/suite/engines/funcs/r/in_number_unique_constraint_error.result new file mode 100644 index 00000000000..807eb009d96 --- /dev/null +++ b/mysql-test/suite/engines/funcs/r/in_number_unique_constraint_error.result @@ -0,0 +1,141 @@ +DROP TABLE IF EXISTS t1; +CREATE TABLE t1(c1 TINYINT NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 SMALLINT NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 MEDIUMINT NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 INT NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 INTEGER NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 BIGINT NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 DECIMAL NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 DEC NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 FIXED NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 NUMERIC NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 DOUBLE NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 REAL NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 DOUBLE PRECISION NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; +CREATE TABLE t1(c1 FLOAT NULL UNIQUE); +INSERT INTO t1 (c1) VALUES(10); +INSERT INTO t1 (c1) VALUES(11); +INSERT INTO t1 (c1) VALUES(10); +ERROR 23000: Duplicate entry '10' for key 'c1' +SELECT * FROM t1; +c1 +10 +11 +DROP TABLE t1; |