summaryrefslogtreecommitdiff
path: root/mysql-test/r/partition_bug18198.result
diff options
context:
space:
mode:
authorunknown <mikael@dator6.(none)>2007-06-13 17:28:59 +0200
committerunknown <mikael@dator6.(none)>2007-06-13 17:28:59 +0200
commitff3f8990e74e8133fb68bea7b85a60b055c9feb9 (patch)
tree042f563a659cfeeaffb727a1021e7e4b47147a1f /mysql-test/r/partition_bug18198.result
parented3ff663f3dc4aa87e24c60a35ffe7e9f77ac119 (diff)
downloadmariadb-git-ff3f8990e74e8133fb68bea7b85a60b055c9feb9.tar.gz
Disabled ascii-function
mysql-test/r/partition_bug18198.result: Disabled a lot of test cases using ascii-function mysql-test/r/partition_charset.result: Disabled a lot of test cases using ascii-function mysql-test/r/partition_error.result: Disabled a lot of test cases using ascii-function mysql-test/r/partition_pruning.result: Disabled a lot of test cases using ascii-function mysql-test/r/partition_range.result: Disabled a lot of test cases using ascii-function mysql-test/t/partition_bug18198.test: Disabled a lot of test cases using ascii-function mysql-test/t/partition_charset.test: Disabled a lot of test cases using ascii-function mysql-test/t/partition_error.test: Disabled a lot of test cases using ascii-function mysql-test/t/partition_pruning.test: Disabled a lot of test cases using ascii-function mysql-test/t/partition_range.test: Disabled a lot of test cases using ascii-function
Diffstat (limited to 'mysql-test/r/partition_bug18198.result')
-rw-r--r--mysql-test/r/partition_bug18198.result30
1 files changed, 0 insertions, 30 deletions
diff --git a/mysql-test/r/partition_bug18198.result b/mysql-test/r/partition_bug18198.result
index 2071545dbca..18d7d904bb0 100644
--- a/mysql-test/r/partition_bug18198.result
+++ b/mysql-test/r/partition_bug18198.result
@@ -1,38 +1,8 @@
drop table if exists t1;
-create table t1 (a char(5) character set koi8r)
-partition by list (ascii(a) mod 3)
-subpartition by hash(ascii(a))
-subpartitions 3
-(partition p1 values in (1),
-partition p2 values in (2),
-partition p0 values in (0));
-insert into t1 values ('a');
-explain partitions select * from t1 where a = 'a';
-id select_type table partitions type possible_keys key key_len ref rows Extra
-1 SIMPLE t1 p2_p2sp2 system NULL NULL NULL NULL 1
-select * from t1 where a = 'a';
-a
-a
-drop table t1;
-create table t1 (a char(5) character set cp1251)
-partition by list (ascii(a)) (partition pn values in (null));
-drop table t1;
create table t1 (col1 datetime)
partition by range(datediff(col1,col1))
(partition p0 values less than (10), partition p1 values less than (30));
drop table t1;
-create table t1 (a char(5) character set big5)
-partition by list (ascii(a)) (partition pn values in (null));
-ERROR HY000: This partition function is not allowed
-create table t1 (a char(1))
-partition by list(ascii(a))
-(partition p1 values in (ascii('i')));
-drop table t1;
-create table t1 (s1 char(5) character set latin5)
-partition by list (ascii(s1))
-(partition p1 values in (1));
-set names utf8;
-drop table t1;
create table t1 (col1 int)
partition by range(greatest(col1,10))
(partition p0 values less than (2), partition p1 values less than (6));