summaryrefslogtreecommitdiff
path: root/mysql-test/r/partition_utf8.result
diff options
context:
space:
mode:
authorMichael Widenius <monty@mariadb.org>2018-03-09 14:05:35 +0200
committerMonty <monty@mariadb.org>2018-03-29 13:59:44 +0300
commita7abddeffa6a760ce948c2dfb007cdf3f1a369d5 (patch)
tree70eb743fa965a17380bbc0ac88ae79ca1075b896 /mysql-test/r/partition_utf8.result
parentab1941266c59a19703a74b5593cf3f508a5752d7 (diff)
downloadmariadb-git-a7abddeffa6a760ce948c2dfb007cdf3f1a369d5.tar.gz
Create 'main' test directory and move 't' and 'r' there
Diffstat (limited to 'mysql-test/r/partition_utf8.result')
-rw-r--r--mysql-test/r/partition_utf8.result53
1 files changed, 0 insertions, 53 deletions
diff --git a/mysql-test/r/partition_utf8.result b/mysql-test/r/partition_utf8.result
deleted file mode 100644
index 7718e651423..00000000000
--- a/mysql-test/r/partition_utf8.result
+++ /dev/null
@@ -1,53 +0,0 @@
-set names utf8;
-create table t1 (a varchar(2) character set cp1250)
-partition by list columns (a)
-( partition p0 values in (0x81));
-show create table t1;
-Table Create Table
-t1 CREATE TABLE `t1` (
- `a` varchar(2) CHARACTER SET cp1250 DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
- PARTITION BY LIST COLUMNS(`a`)
-(PARTITION `p0` VALUES IN (_cp1250 0x81) ENGINE = MyISAM)
-drop table t1;
-create table t1 (a varchar(2) character set cp1250)
-partition by list columns (a)
-( partition p0 values in (0x80));
-show create table t1;
-Table Create Table
-t1 CREATE TABLE `t1` (
- `a` varchar(2) CHARACTER SET cp1250 DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
- PARTITION BY LIST COLUMNS(`a`)
-(PARTITION `p0` VALUES IN ('€') ENGINE = MyISAM)
-drop table t1;
-create table t1 (a varchar(1500), b varchar(1570))
-partition by list columns(a,b)
-( partition p0 values in (('a','b')));
-ERROR HY000: The total length of the partitioning fields is too large
-create table t1 (a varchar(1023) character set utf8 collate utf8_spanish2_ci)
-partition by range columns(a)
-( partition p0 values less than ('CZ'),
-partition p1 values less than ('CH'),
-partition p2 values less than ('D'));
-insert into t1 values ('czz'),('chi'),('ci'),('cg');
-select * from t1 where a between 'cg' AND 'ci';
-a
-ci
-cg
-drop table t1;
-create table t1 (a varchar(2) character set ucs2)
-partition by list columns (a)
-(partition p0 values in (0x2020),
-partition p1 values in (''));
-show create table t1;
-Table Create Table
-t1 CREATE TABLE `t1` (
- `a` varchar(2) CHARACTER SET ucs2 DEFAULT NULL
-) ENGINE=MyISAM DEFAULT CHARSET=latin1
- PARTITION BY LIST COLUMNS(`a`)
-(PARTITION `p0` VALUES IN ('†') ENGINE = MyISAM,
- PARTITION `p1` VALUES IN ('') ENGINE = MyISAM)
-insert into t1 values ('');
-insert into t1 values (_ucs2 0x2020);
-drop table t1;