1
CREATE TEMPORARY TABLE t1 (a UUID, PRIMARY KEY(a)) ENGINE=MEMORY;
4
t1 CREATE TEMPORARY TABLE `t1` (
7
) ENGINE=MEMORY COLLATE = utf8_general_ci
8
INSERT INTO t1 VALUES (uuid());
9
INSERT INTO t1 VALUES (uuid());
10
INSERT INTO t1 VALUES (uuid());
11
INSERT INTO t1 VALUES (uuid());
12
SELECT count(a) FROM t1;
16
SELECT count(a) FROM t1;
19
INSERT INTO t1 VALUES ("1b4e28ba-2fa1-11d2-883f-b9a761bde3fb");
20
INSERT INTO t1 VALUES ("4843cbfb-7b27-4f1b-b05d-757d1d4daaaa");
21
INSERT INTO t1 VALUES ("41e5daca-e4ef-4dad-a7ca-50293e89aaaa");
22
INSERT INTO t1 VALUES ("a2a4ab7a-968b-4353-8dcc-5ae82a07aaaa");
23
INSERT INTO t1 VALUES ("92b6ac44-04ad-451e-bed8-395325dfaaaa");
24
INSERT INTO t1 VALUES ("e3ec4f25-8bb0-4cca-8835-6ba00a1caaaa");
25
INSERT INTO t1 VALUES ("85b6fd2e-b384-46b3-9718-0e303a90aaaa");
26
INSERT INTO t1 VALUES ("d9163f3c-6228-4f62-9c21-0af56883aaaa");
27
INSERT INTO t1 VALUES ("d9163f3c-6228-4f62-9c21-0af56883aaaa");
28
ERROR 23000: Duplicate entry 'd9163f3c-6228-4f62-9c21-0af56883aaaa' for key 'PRIMARY'
29
SELECT a FROM t1 ORDER BY a;
31
1b4e28ba-2fa1-11d2-883f-b9a761bde3fb
32
41e5daca-e4ef-4dad-a7ca-50293e89aaaa
33
4843cbfb-7b27-4f1b-b05d-757d1d4daaaa
34
85b6fd2e-b384-46b3-9718-0e303a90aaaa
35
92b6ac44-04ad-451e-bed8-395325dfaaaa
36
a2a4ab7a-968b-4353-8dcc-5ae82a07aaaa
37
d9163f3c-6228-4f62-9c21-0af56883aaaa
38
e3ec4f25-8bb0-4cca-8835-6ba00a1caaaa
39
INSERT INTO t1 VALUES ("d9163f3c-6228-4f62-9c21-0af56883");
40
ERROR HY000: Received an invalid UUID value
41
SELECT a FROM t1 ORDER BY a;
43
1b4e28ba-2fa1-11d2-883f-b9a761bde3fb
44
41e5daca-e4ef-4dad-a7ca-50293e89aaaa
45
4843cbfb-7b27-4f1b-b05d-757d1d4daaaa
46
85b6fd2e-b384-46b3-9718-0e303a90aaaa
47
92b6ac44-04ad-451e-bed8-395325dfaaaa
48
a2a4ab7a-968b-4353-8dcc-5ae82a07aaaa
49
d9163f3c-6228-4f62-9c21-0af56883aaaa
50
e3ec4f25-8bb0-4cca-8835-6ba00a1caaaa
51
INSERT INTO t1 VALUES(NULL);
52
ERROR 23000: Column 'a' cannot be null
53
SELECT a FROM t1 ORDER BY a;
55
1b4e28ba-2fa1-11d2-883f-b9a761bde3fb
56
41e5daca-e4ef-4dad-a7ca-50293e89aaaa
57
4843cbfb-7b27-4f1b-b05d-757d1d4daaaa
58
85b6fd2e-b384-46b3-9718-0e303a90aaaa
59
92b6ac44-04ad-451e-bed8-395325dfaaaa
60
a2a4ab7a-968b-4353-8dcc-5ae82a07aaaa
61
d9163f3c-6228-4f62-9c21-0af56883aaaa
62
e3ec4f25-8bb0-4cca-8835-6ba00a1caaaa