summaryrefslogtreecommitdiff
path: root/mysql-test/r/partition_bug18198.result
diff options
context:
space:
mode:
authormikael@dator6.(none) <>2007-06-13 17:28:59 +0200
committermikael@dator6.(none) <>2007-06-13 17:28:59 +0200
commit4ab5e26d933b240a48d7fe04f51e20a47ce19af5 (patch)
tree042f563a659cfeeaffb727a1021e7e4b47147a1f /mysql-test/r/partition_bug18198.result
parentc7f0c9101295aaf8dcee2dc87ec73f5928576ab8 (diff)
downloadmariadb-git-4ab5e26d933b240a48d7fe04f51e20a47ce19af5.tar.gz
Disabled 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));