[tomato.git] / release / src / router / mysql / mysql-test / suite / engines / funcs / t / in_string_unique_constraint_duplicate_update.test
| blob | b0abffa99606b717cf4a48bf8ba495ce3d5f00c8 |
1 --disable_warnings
2 DROP TABLE IF EXISTS t1;
3 --enable_warnings
4 CREATE TABLE t1(c1 CHAR(10) NULL UNIQUE);
5 INSERT INTO t1 (c1) VALUES('abc');
6 INSERT INTO t1 (c1) VALUES('def');
7 INSERT INTO t1 (c1) VALUES('abc') ON DUPLICATE KEY UPDATE c1='abcdefg';
8 SELECT * FROM t1;
9 DROP TABLE t1;
10 CREATE TABLE t1(c1 VARCHAR(10) NULL UNIQUE);
11 INSERT INTO t1 (c1) VALUES('abc');
12 INSERT INTO t1 (c1) VALUES('def');
13 INSERT INTO t1 (c1) VALUES('abc') ON DUPLICATE KEY UPDATE c1='abcdefg';
14 SELECT * FROM t1;
15 DROP TABLE t1;
16 CREATE TABLE t1(c1 BINARY(10) NULL UNIQUE);
17 INSERT INTO t1 (c1) VALUES('abc');
18 INSERT INTO t1 (c1) VALUES('def');
19 INSERT INTO t1 (c1) VALUES('abc') ON DUPLICATE KEY UPDATE c1='abcdefg';
20 SELECT * FROM t1;
21 DROP TABLE t1;
22 CREATE TABLE t1(c1 VARBINARY(10) NULL UNIQUE);
23 INSERT INTO t1 (c1) VALUES('abc');
24 INSERT INTO t1 (c1) VALUES('def');
25 INSERT INTO t1 (c1) VALUES('abc') ON DUPLICATE KEY UPDATE c1='abcdefg';
26 SELECT * FROM t1;
27 DROP TABLE t1;