plugin/type_inet/mysql-test/type_inet/type_inet6_partition.test


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
30
31
32

--source include/have_partition.inc

--echo #
--echo # MDEV-20831 Table partitioned by LIST/RANGE COLUMNS(inet6) can be created, but not inserted into
--echo #

SET NAMES utf8;

--error ER_WRONG_TYPE_COLUMN_VALUE_ERROR
CREATE TABLE t1 (a INET6)
  PARTITION BY LIST COLUMNS(a)
    (PARTITION p00 VALUES IN (10));

--error ER_WRONG_TYPE_COLUMN_VALUE_ERROR
CREATE TABLE t1 (a INET6)
  PARTITION BY LIST COLUMNS(a)
    (PARTITION p00 VALUES IN (TIME'10:20:30'));

--error ER_TRUNCATED_WRONG_VALUE
CREATE TABLE t1 (a INET6)
  PARTITION BY LIST COLUMNS(a)
    (PARTITION p00 VALUES IN ('€'));

CREATE TABLE t1 (a INET6)
  PARTITION BY LIST COLUMNS(a)
    (PARTITION p00 VALUES IN ('::'),
     PARTITION pFF VALUES IN (0xFFFF000000000000000000000000FFFF));
INSERT INTO t1 VALUES ('::');
INSERT INTO t1 VALUES ('ffff::ffff');
SELECT * FROM t1 PARTITION (p00);
SELECT * FROM t1 PARTITION (pFF);
DROP TABLE t1;