|
1996.2.1
by Brian Aker
uuid type code. |
1 |
CREATE TEMPORARY TABLE t1 (a UUID, PRIMARY KEY(a)) ENGINE=MEMORY; |
2 |
show create table t1; |
|
3 |
INSERT INTO t1 VALUES (uuid()); |
|
4 |
INSERT INTO t1 VALUES (uuid()); |
|
5 |
INSERT INTO t1 VALUES (uuid()); |
|
6 |
INSERT INTO t1 VALUES (uuid()); |
|
7 |
SELECT count(a) FROM t1; |
|
8 |
||
9 |
TRUNCATE t1; |
|
10 |
SELECT count(a) FROM t1; |
|
11 |
||
12 |
INSERT INTO t1 VALUES ("1b4e28ba-2fa1-11d2-883f-b9a761bde3fb"); |
|
13 |
INSERT INTO t1 VALUES ("4843cbfb-7b27-4f1b-b05d-757d1d4daaaa"); |
|
14 |
INSERT INTO t1 VALUES ("41e5daca-e4ef-4dad-a7ca-50293e89aaaa"); |
|
15 |
INSERT INTO t1 VALUES ("a2a4ab7a-968b-4353-8dcc-5ae82a07aaaa"); |
|
16 |
INSERT INTO t1 VALUES ("92b6ac44-04ad-451e-bed8-395325dfaaaa"); |
|
17 |
INSERT INTO t1 VALUES ("e3ec4f25-8bb0-4cca-8835-6ba00a1caaaa"); |
|
18 |
INSERT INTO t1 VALUES ("85b6fd2e-b384-46b3-9718-0e303a90aaaa"); |
|
19 |
INSERT INTO t1 VALUES ("d9163f3c-6228-4f62-9c21-0af56883aaaa"); |
|
|
2107.1.3
by Brian Aker
Fixes the rest of the errors to be symbols, not numbers. |
20 |
--error ER_DUP_ENTRY
|
|
1996.2.1
by Brian Aker
uuid type code. |
21 |
INSERT INTO t1 VALUES ("d9163f3c-6228-4f62-9c21-0af56883aaaa"); |
22 |
SELECT a FROM t1 ORDER BY a; |
|
23 |
||
|
2082.4.1
by Brian Aker
Merge in trunk. |
24 |
--error ER_INVALID_UUID_VALUE
|
|
1996.2.1
by Brian Aker
uuid type code. |
25 |
INSERT INTO t1 VALUES ("d9163f3c-6228-4f62-9c21-0af56883"); |
26 |
SELECT a FROM t1 ORDER BY a; |
|
27 |
||
28 |
# Test NULL insert/order |
|
|
2107.1.3
by Brian Aker
Fixes the rest of the errors to be symbols, not numbers. |
29 |
--error ER_BAD_NULL_ERROR
|
|
1996.2.1
by Brian Aker
uuid type code. |
30 |
INSERT INTO t1 VALUES(NULL); |
31 |
SELECT a FROM t1 ORDER BY a; |
|
32 |
||
33 |
DROP TABLE t1; |