blob: bd0879325e7e35330368a9ac09893aff14722e1b (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
#
# MDEV-4958 Adding datatype UUID
#
SET NAMES utf8;
CREATE TABLE t1 (a UUID)
PARTITION BY LIST COLUMNS(a)
(PARTITION p00 VALUES IN (10));
ERROR HY000: Partition column values of incorrect type
CREATE TABLE t1 (a UUID)
PARTITION BY LIST COLUMNS(a)
(PARTITION p00 VALUES IN (TIME'10:20:30'));
ERROR HY000: Partition column values of incorrect type
CREATE TABLE t1 (a UUID)
PARTITION BY LIST COLUMNS(a)
(PARTITION p00 VALUES IN ('€'));
ERROR 22007: Incorrect uuid value: '€'
CREATE TABLE t1 (a UUID)
PARTITION BY LIST COLUMNS(a)
(PARTITION p00 VALUES IN ('123e4567-e89b-12d3-a456-426655440000'),
PARTITION pFF VALUES IN (0xffff000000000000000000000000ffff));
INSERT INTO t1 VALUES ('123e4567-e89b-12d3-a456-426655440000');
INSERT INTO t1 VALUES ('ffff0000-0000-0000-0000-00000000ffff');
SELECT * FROM t1 PARTITION (p00);
a
123e4567-e89b-12d3-a456-426655440000
SELECT * FROM t1 PARTITION (pFF);
a
ffff0000-0000-0000-0000-00000000ffff
DROP TABLE t1;
|
