35
35
select count(*) from t2;
39
# Bug 30577: FLOOR() and CEILING() not usable as partition functions
40
# Partition functions are required to return INT_RESULT; FLOOR() and
41
# CEILING() do not, unless they have an INT argument. Disable this
42
# portion of the test until bug 30577 is fixed.
46
eval create table t3 (a double not null, primary key(a)) engine=$engine
47
partition by range (floor(a)) subpartition by key (a) subpartitions 3 (
48
partition pa1 values less than (3),
49
partition pa3 values less than (6),
50
partition pa10 values less than (10)
54
--echo $count*3 inserts;
57
eval insert into t3 values ($count);
58
eval insert into t3 values ($count+0.33);
59
eval insert into t3 values ($count+0.75);
62
select count(*) from t3;
66
eval create table t4 (a double not null, primary key(a)) engine=$engine
67
partition by list (floor(a)) subpartition by key (a) subpartitions 3 (
68
partition pa1 values in (1,2,3),
69
partition pa3 values in (4,5,6),
70
partition pa10 values in (7,8,9,10)
74
--echo $count*3 inserts;
77
eval insert into t4 values ($count);
78
eval insert into t4 values ($count+0.33);
79
eval insert into t4 values ($count+0.75);
82
select count(*) from t4;
86
# Disabled due to Bug 30577