mirror of
https://github.com/MariaDB/server.git
synced 2025-02-20 20:33:15 +01:00
50 lines
882 B
Text
50 lines
882 B
Text
#
|
||
# Start of 11.5 tests
|
||
#
|
||
#
|
||
# MDEV-31340 Remove MY_COLLATION_HANDLER::strcasecmp()
|
||
#
|
||
SET NAMES utf8;
|
||
CREATE TABLE t1
|
||
(
|
||
a INT
|
||
)
|
||
PARTITION BY LIST (a)
|
||
(
|
||
PARTITION I VALUES IN (0),
|
||
PARTITION ı DEFAULT
|
||
);
|
||
ERROR HY000: Duplicate partition name ı
|
||
CREATE TABLE t1
|
||
(
|
||
a INT
|
||
)
|
||
PARTITION BY LIST (a)
|
||
(
|
||
PARTITION I0 VALUES IN (0),
|
||
PARTITION I1 VALUES IN (1),
|
||
PARTITION Id DEFAULT
|
||
);
|
||
SHOW CREATE TABLE t1;
|
||
Table Create Table
|
||
t1 CREATE TABLE `t1` (
|
||
`a` int(11) DEFAULT NULL
|
||
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
|
||
PARTITION BY LIST (`a`)
|
||
(PARTITION `I0` VALUES IN (0) ENGINE = MyISAM,
|
||
PARTITION `I1` VALUES IN (1) ENGINE = MyISAM,
|
||
PARTITION `Id` DEFAULT ENGINE = MyISAM)
|
||
INSERT INTO t1 VALUES (0),(1),(2);
|
||
SELECT * FROM t1 PARTITION (ı0);
|
||
a
|
||
0
|
||
SELECT * FROM t1 PARTITION (ı1);
|
||
a
|
||
1
|
||
SELECT * FROM t1 PARTITION (ıd);
|
||
a
|
||
2
|
||
DROP TABLE t1;
|
||
#
|
||
# End of 11.5 tests
|
||
#
|