mysql-test/r/partition_bug18198.result

3 partition by range(datediff(col1,col1))
4 (partition p0 values less than (10), partition p1 values less than (30));
7 partition by range(greatest(col1,10))
8 (partition p0 values less than (2), partition p1 values less than (6));
9 ERROR HY000: This partition function is not allowed
11 partition by range(isnull(col1))
12 (partition p0 values less than (2), partition p1 values less than (6));
13 ERROR HY000: This partition function is not allowed
15 partition by range(least(col1,12))
16 (partition p0 values less than (2), partition p1 values less than (6));
17 ERROR HY000: This partition function is not allowed
19 partition by range(case when col1>0 then 10 else 20 end)
20 (partition p0 values less than (2), partition p1 values less than (6));
21 ERROR HY000: This partition function is not allowed
23 partition by range(ifnull(col1,5))
24 (partition p0 values less than (2), partition p1 values less than (6));
25 ERROR HY000: This partition function is not allowed
27 partition by range(nullif(col1,5))
28 (partition p0 values less than (2), partition p1 values less than (6));
29 ERROR HY000: This partition function is not allowed
31 partition by range(bit_length(col1))
32 (partition p0 values less than (2), partition p1 values less than (6));
33 ERROR HY000: This partition function is not allowed
35 partition by range(bit_length(col1))
36 (partition p0 values less than (2), partition p1 values less than (6));
37 ERROR HY000: This partition function is not allowed
39 partition by range(char_length(col1))
40 (partition p0 values less than (2), partition p1 values less than (6));
41 ERROR HY000: This partition function is not allowed
43 partition by range(char_length(col1))
44 (partition p0 values less than (2), partition p1 values less than (6));
45 ERROR HY000: This partition function is not allowed
47 partition by range(character_length(col1))
48 (partition p0 values less than (2), partition p1 values less than (6));
49 ERROR HY000: This partition function is not allowed
51 partition by range(find_in_set(col1,1))
52 (partition p0 values less than (2), partition p1 values less than (6));
53 ERROR HY000: This partition function is not allowed
55 partition by range(find_in_set(col1,'1'))
56 (partition p0 values less than (2), partition p1 values less than (6));
57 ERROR HY000: This partition function is not allowed
59 partition by range(instr(col1,3))
60 (partition p0 values less than (2), partition p1 values less than (6));
61 ERROR HY000: This partition function is not allowed
63 partition by range(instr(col1,'3'))
64 (partition p0 values less than (2), partition p1 values less than (6));
65 ERROR HY000: This partition function is not allowed
67 partition by range(length(col1))
68 (partition p0 values less than (2), partition p1 values less than (6));
69 ERROR HY000: This partition function is not allowed
71 partition by range(locate(1,col1))
72 (partition p0 values less than (2), partition p1 values less than (6));
73 ERROR HY000: This partition function is not allowed
75 partition by range(locate(1,col1))
76 (partition p0 values less than (2), partition p1 values less than (6));
77 ERROR HY000: This partition function is not allowed
79 partition by range(octet_length(col1))
80 (partition p0 values less than (2), partition p1 values less than (6));
81 ERROR HY000: This partition function is not allowed
83 partition by range(position(1 in col1))
84 (partition p0 values less than (2), partition p1 values less than (6));
85 ERROR HY000: This partition function is not allowed
87 partition by range(position(1 in col1))
88 (partition p0 values less than (2), partition p1 values less than (6));
89 ERROR HY000: This partition function is not allowed
91 partition by range(strcmp(col1,2))
92 (partition p0 values less than (2), partition p1 values less than (6));
93 ERROR HY000: This partition function is not allowed
95 partition by range(strcmp(col1,2))
96 (partition p0 values less than (2), partition p1 values less than (6));
97 ERROR HY000: This partition function is not allowed
99 partition by range(crc32(col1))
100 (partition p0 values less than (2), partition p1 values less than (6));
101 ERROR HY000: This partition function is not allowed
103 partition by range(round(col1))
104 (partition p0 values less than (2), partition p1 values less than (6));
105 ERROR HY000: This partition function is not allowed
107 partition by range(sign(col1))
108 (partition p0 values less than (2), partition p1 values less than (6));
109 ERROR HY000: This partition function is not allowed
111 partition by range(period_add(col1,5))
112 (partition p0 values less than (10), partition p1 values less than (30));
113 ERROR HY000: This partition function is not allowed
115 partition by range(period_diff(col1,col2))
116 (partition p0 values less than (10), partition p1 values less than (30));
117 ERROR HY000: This partition function is not allowed
119 partition by range(period_diff(col1,col2))
120 (partition p0 values less than (10), partition p1 values less than (30));
121 ERROR HY000: This partition function is not allowed
123 partition by range(timestampdiff(day,5,col1))
124 (partition p0 values less than (10), partition p1 values less than (30));
125 ERROR HY000: This partition function is not allowed
127 partition by range(unix_timestamp(col1))
128 (partition p0 values less than (10), partition p1 values less than (30));
131 partition by range(week(col1))
132 (partition p0 values less than (10), partition p1 values less than (30));
133 ERROR HY000: This partition function is not allowed
135 partition by range(cast(col1 as signed))
136 (partition p0 values less than (10), partition p1 values less than (30));
137 ERROR HY000: This partition function is not allowed
139 partition by range(convert(col1,unsigned))
140 (partition p0 values less than (10), partition p1 values less than (30));
141 ERROR HY000: This partition function is not allowed
143 partition by range(col1 | 20)
144 (partition p0 values less than (10), partition p1 values less than (30));
145 ERROR HY000: This partition function is not allowed
147 partition by range(col1 & 20)
148 (partition p0 values less than (10), partition p1 values less than (30));
149 ERROR HY000: This partition function is not allowed
151 partition by range(col1 ^ 20)
152 (partition p0 values less than (10), partition p1 values less than (30));
153 ERROR HY000: This partition function is not allowed
155 partition by range(col1 << 20)
156 (partition p0 values less than (10), partition p1 values less than (30));
157 ERROR HY000: This partition function is not allowed
159 partition by range(col1 >> 20)
160 (partition p0 values less than (10), partition p1 values less than (30));
161 ERROR HY000: This partition function is not allowed
163 partition by range(~col1)
164 (partition p0 values less than (10), partition p1 values less than (30));
165 ERROR HY000: This partition function is not allowed
167 partition by range(bit_count(col1))
168 (partition p0 values less than (10), partition p1 values less than (30));
169 ERROR HY000: This partition function is not allowed
171 partition by range(inet_aton(col1))
172 (partition p0 values less than (10), partition p1 values less than (30));
173 ERROR HY000: This partition function is not allowed