2942
2942
drop table if exists t55 ;
2943
2943
drop table if exists t66 ;
2944
2944
-------------------------------------------------------------------------
2945
--- unix_timestamp(col1) in partition with coltype date
2946
-------------------------------------------------------------------------
2948
drop table if exists t1 ;
2949
drop table if exists t2 ;
2950
drop table if exists t3 ;
2951
drop table if exists t4 ;
2952
drop table if exists t5 ;
2953
drop table if exists t6 ;
2954
create table t1 (col1 date) engine='MYISAM'
2955
partition by range(unix_timestamp(col1))
2956
(partition p0 values less than (15),
2957
partition p1 values less than (31));
2958
Got one of the listed errors
2959
create table t2 (col1 date) engine='MYISAM'
2960
partition by list(unix_timestamp(col1))
2961
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
2962
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
2963
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2964
Got one of the listed errors
2965
create table t3 (col1 date) engine='MYISAM'
2966
partition by hash(unix_timestamp(col1));
2967
Got one of the listed errors
2968
create table t4 (colint int, col1 date) engine='MYISAM'
2969
partition by range(colint)
2970
subpartition by hash(unix_timestamp(col1)) subpartitions 2
2971
(partition p0 values less than (15),
2972
partition p1 values less than (31));
2973
Got one of the listed errors
2974
create table t5 (colint int, col1 date) engine='MYISAM'
2975
partition by list(colint)
2976
subpartition by hash(unix_timestamp(col1)) subpartitions 2
2977
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
2978
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
2979
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
2980
Got one of the listed errors
2981
create table t6 (colint int, col1 date) engine='MYISAM'
2982
partition by range(colint)
2983
(partition p0 values less than (unix_timestamp ('2002-05-01')),
2984
partition p1 values less than maxvalue);
2985
Got one of the listed errors
2986
drop table if exists t11 ;
2987
drop table if exists t22 ;
2988
drop table if exists t33 ;
2989
drop table if exists t44 ;
2990
drop table if exists t55 ;
2991
drop table if exists t66 ;
2992
create table t11 (col1 date) engine='MYISAM' ;
2993
create table t22 (col1 date) engine='MYISAM' ;
2994
create table t33 (col1 date) engine='MYISAM' ;
2995
create table t44 (colint int, col1 date) engine='MYISAM' ;
2996
create table t55 (colint int, col1 date) engine='MYISAM' ;
2997
create table t66 (colint int, col1 date) engine='MYISAM' ;
2999
partition by range(unix_timestamp(col1))
3000
(partition p0 values less than (15),
3001
partition p1 values less than (31));
3002
Got one of the listed errors
3004
partition by list(unix_timestamp(col1))
3005
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
3006
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
3007
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3008
Got one of the listed errors
3010
partition by hash(unix_timestamp(col1));
3011
Got one of the listed errors
3013
partition by range(colint)
3014
subpartition by hash(unix_timestamp(col1)) subpartitions 2
3015
(partition p0 values less than (15),
3016
partition p1 values less than (31));
3017
Got one of the listed errors
3019
partition by list(colint)
3020
subpartition by hash(unix_timestamp(col1)) subpartitions 2
3021
(partition p0 values in (1,2,3,4,5,6,7,8,9,10),
3022
partition p1 values in (11,12,13,14,15,16,17,18,19,20),
3023
partition p2 values in (21,22,23,24,25,26,27,28,29,30));
3024
Got one of the listed errors
3026
partition by range(colint)
3027
(partition p0 values less than (unix_timestamp ('2002-05-01')),
3028
partition p1 values less than maxvalue);
3029
Got one of the listed errors
3030
drop table if exists t1 ;
3031
drop table if exists t2 ;
3032
drop table if exists t3 ;
3033
drop table if exists t4 ;
3034
drop table if exists t5 ;
3035
drop table if exists t6 ;
3036
drop table if exists t11 ;
3037
drop table if exists t22 ;
3038
drop table if exists t33 ;
3039
drop table if exists t44 ;
3040
drop table if exists t55 ;
3041
drop table if exists t66 ;
3042
-------------------------------------------------------------------------
3043
2945
--- week(col1) in partition with coltype datetime
3044
2946
-------------------------------------------------------------------------