← Back to branch summary

~ubuntu-branches/ubuntu/trusty/drizzle/trusty

« back to all changes in this revision

Viewing changes to tests/kewpie/randgen/conf/partitioning/partition_pruning.zz

  • Committer: Package Import Robot
  • Author(s): Dmitrijs Ledkovs
  • Date: 2013-10-29 15:43:40 UTC
  • mfrom: (1.2.12) (2.1.19 trusty-proposed)
  • Revision ID: package-import@ubuntu.com-20131029154340-2gp39el6cv8bwf2o
Tags: 1:7.2.3-2ubuntu1
* Merge from debian, remaining changes:
  - Link against boost_system because of boost_thread.
  - Add required libs to message/include.am
  - Add upstart job and adjust init script to be upstart compatible.
  - Disable -floop-parallelize-all due to gcc-4.8/4.9 compiler ICE
    http://gcc.gnu.org/bugzilla/show_bug.cgi?id=57732

Show diffs side-by-side

added added

removed removed

Lines of Context:
tests/kewpie/randgen/conf/partitioning/partition_pruning.zz
1
 
# Copyright (C) 2008-2009 Sun Microsystems, Inc. All rights reserved.
2
 
# Use is subject to license terms.
3
 
#
4
 
# This program is free software; you can redistribute it and/or modify
5
 
# it under the terms of the GNU General Public License as published by
6
 
# the Free Software Foundation; version 2 of the License.
7
 
#
8
 
# This program is distributed in the hope that it will be useful, but
9
 
# WITHOUT ANY WARRANTY; without even the implied warranty of
10
 
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
11
 
# General Public License for more details.
12
 
#
13
 
# You should have received a copy of the GNU General Public License
14
 
# along with this program; if not, write to the Free Software
15
 
# Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301
16
 
# USA
17
 
 
18
 
$tables = {
19
 
          names => ['PP_A', 'PP_B', 'PP_C', 'PP_D', 'PP_E', 'PP_F', 'PP_G', 'PP_H', 'PP_I', 'PP_J', 'PP_K', 'PP_L', 'PP_M',
20
 
                    'PP_N', 'PP_O', 'PP_P', 'PP_Q', 'PP_R', 'PP_S', 'PP_T' , 'PP_U', 'PP_V', 'PP_W', 'PP_X', 'PP_Y', 'PP_Z'],
21
 
          rows => [ 5000 ] ,
22
 
          engines => [ 'MyISAM', 'Innodb' ] ,
23
 
          pk => [ undef ] , 
24
 
          partitions => [
25
 
                          "RANGE COLUMNS(col_int_signed, col_varchar_5_utf8)
26
 
                          ( PARTITION p0 VALUES LESS THAN (5, 'm'), 
27
 
                          PARTITION p1 VALUES LESS THAN (10, 'za' ))",
28
 
                          "RANGE COLUMNS(col_int_signed, col_varchar_512_cp932)
29
 
                          SUBPARTITION BY HASH( TO_SECONDS(`col_datetime`))
30
 
                          SUBPARTITIONS 3 (
31
 
                          PARTITION p0 VALUES LESS THAN (2, 'b'),
32
 
                          PARTITION p1 VALUES LESS THAN (4, 'd'),
33
 
                          PARTITION p2 VALUES LESS THAN (10,'za'))",
34
 
                          "RANGE COLUMNS(col_varchar_256_cp932, col_varchar_512_latin1)
35
 
                          SUBPARTITION BY HASH(YEAR(`col_datetime`))
36
 
                          SUBPARTITIONS 2 (
37
 
                          PARTITION p0 VALUES LESS THAN ('m','m'),
38
 
                          PARTITION p1 VALUES LESS THAN ('za','za'))",
39
 
                          "RANGE COLUMNS(col_varchar_256_cp932, col_varchar_512_latin1)
40
 
                          SUBPARTITION BY KEY(col_date)
41
 
                          SUBPARTITIONS 4 (
42
 
                          PARTITION p0 VALUES LESS THAN ('m','m'),
43
 
                          PARTITION p1 VALUES LESS THAN ('za','za'))",
44
 
                          "RANGE COLUMNS(col_varchar_256_utf8, col_varchar_512_utf8)
45
 
                          SUBPARTITION BY LINEAR KEY(`col_datetime`)
46
 
                          SUBPARTITIONS 2 (
47
 
                          PARTITION p0 VALUES LESS THAN ('m','m'),
48
 
                          PARTITION p1 VALUES LESS THAN ('za','za'))",
49
 
                          "LIST COLUMNS(col_int_signed)
50
 
                           SUBPARTITION BY KEY(col_varchar_256_utf8)
51
 
                           SUBPARTITIONS 4 (
52
 
                           PARTITION p0 VALUES IN (1,3,
53
 
                                                  5,7,
54
 
                                                  9,NULL),
55
 
                           PARTITION p1 VALUES IN (2,4,
56
 
                                                  6,8,
57
 
                                                  0))",
58
 
                          "LIST COLUMNS(col_int_signed)
59
 
                           SUBPARTITION BY LINEAR KEY(col_varchar_512_latin1)
60
 
                           SUBPARTITIONS 4 (
61
 
                           PARTITION p0 VALUES IN (1,3,
62
 
                                                  5,7,
63
 
                                                  9,NULL),
64
 
                           PARTITION p1 VALUES IN (2,4,
65
 
                                                  6,8,
66
 
                                                  0))",
67
 
                          "LIST COLUMNS(col_int_signed)
68
 
                           SUBPARTITION BY LINEAR HASH( TO_SECONDS(`col_date`))
69
 
                           SUBPARTITIONS 4 (
70
 
                           PARTITION p0 VALUES IN (1,3,
71
 
                                                  5,7,
72
 
                                                  9,NULL),
73
 
                           PARTITION p1 VALUES IN (2,4,
74
 
                                                  6,8,
75
 
                                                  0))" ,
76
 
                          "LIST COLUMNS(col_int_signed)
77
 
                          SUBPARTITION BY HASH( TO_SECONDS(`col_date`))
78
 
                          SUBPARTITIONS 2 (
79
 
                          PARTITION p0 VALUES IN (1, 2,
80
 
                                                 3, 4,
81
 
                                                 5, 6,
82
 
                                                 7, 8,
83
 
                                                 9, 0,
84
 
                                                 NULL))",
85
 
                          "LIST COLUMNS(col_int_signed)
86
 
                          SUBPARTITION BY HASH( TO_SECONDS(`col_date`))
87
 
                          SUBPARTITIONS 2 (
88
 
                          PARTITION p0 VALUES IN (NULL, 0,
89
 
                                                 1, 2,
90
 
                                                 3, 4,
91
 
                                                 5, 6,
92
 
                                                 7, 8,
93
 
                                                 9))",
94
 
                          "LIST COLUMNS(col_int_signed, col_varchar_5_utf8)
95
 
                          ( PARTITION p0 VALUES IN (
96
 
                         (1,'a'),(1,'b'),(1,'c'),
97
 
                         (1,'d'),(1,'e'),(1,'f'),
98
 
                         (1,'g'),(1,'h'),(1,'i'),
99
 
                         (1,'j'),(1,'k'),(1,'l'),
100
 
                         (1,'m'),(1,'n'),(1,'o'),
101
 
                         (1,'p'),(1,'q'),(1,'r'),
102
 
                         (1,'s'),(1,'t'),(1,'u'),
103
 
                         (1,'v'),(1,'w'),(1,'x'),
104
 
                         (1,'y'),(1,'z'),(1,NULL),
105
 
                         (3,'a'),(3,'b'),(3,'c'),
106
 
                         (3,'d'),(3,'e'),(3,'f'),
107
 
                         (3,'g'),(3,'h'),(3,'i'),
108
 
                         (3,'j'),(3,'k'),(3,'l'),
109
 
                         (3,'m'),(3,'n'),(3,'o'),
110
 
                         (3,'p'),(3,'q'),(3,'r'),
111
 
                         (3,'s'),(3,'t'),(3,'u'),
112
 
                         (3,'v'),(3,'w'),(3,'x'),
113
 
                         (3,'y'),(3,'z'),(3,NULL),
114
 
                         (5,'a'),(5,'b'),(5,'c'),
115
 
                         (5,'d'),(5,'e'),(5,'f'),
116
 
                         (5,'g'),(5,'h'),(5,'i'),
117
 
                         (5,'j'),(5,'k'),(5,'l'),
118
 
                         (5,'m'),(5,'n'),(5,'o'),
119
 
                         (5,'p'),(5,'q'),(5,'r'),
120
 
                         (5,'s'),(5,'t'),(5,'u'),
121
 
                         (5,'v'),(5,'w'),(5,'x'),
122
 
                         (5,'y'),(5,'z'),(5,NULL),
123
 
                         (7,'a'),(7,'b'),(7,'c'),
124
 
                         (7,'d'),(7,'e'),(7,'f'),
125
 
                         (7,'g'),(7,'h'),(7,'i'),
126
 
                         (7,'j'),(7,'k'),(7,'l'),
127
 
                         (7,'m'),(7,'n'),(7,'o'),
128
 
                         (7,'p'),(7,'q'),(7,'r'),
129
 
                         (7,'s'),(7,'t'),(7,'u'),
130
 
                         (7,'v'),(7,'w'),(7,'x'),
131
 
                         (7,'y'),(7,'z'),(7,NULL),
132
 
                         (9,'a'),(9,'b'),(9,'c'),
133
 
                         (9,'d'),(9,'e'),(9,'f'),
134
 
                         (9,'g'),(9,'h'),(9,'i'),
135
 
                         (9,'j'),(9,'k'),(9,'l'),
136
 
                         (9,'m'),(9,'n'),(9,'o'),
137
 
                         (9,'p'),(9,'q'),(9,'r'),
138
 
                         (9,'s'),(9,'t'),(9,'u'),
139
 
                         (9,'v'),(9,'w'),(9,'x'),
140
 
                         (9,'y'),(9,'z'),(9,NULL),
141
 
                         (NULL,'a'),(NULL,'b'),(NULL,'c'),
142
 
                         (NULL,'d'),(NULL,'e'),(NULL,'f'),
143
 
                         (NULL,'g'),(NULL,'h'),(NULL,'i'),
144
 
                         (NULL,'j'),(NULL,'k'),(NULL,'l'),
145
 
                         (NULL,'m'),(NULL,'n'),(NULL,'o'),
146
 
                         (NULL,'p'),(NULL,'q'),(NULL,'r'),
147
 
                         (NULL,'s'),(NULL,'t'),(NULL,'u'),
148
 
                         (NULL,'v'),(NULL,'w'),(NULL,'x'),
149
 
                         (NULL,'y'),(NULL,'z'),(NULL,NULL)),
150
 
                         PARTITION p1 VALUES IN (
151
 
                         (2,'a'),(2,'b'),(2,'c'),
152
 
                         (2,'d'),(2,'e'),(2,'f'),
153
 
                         (2,'g'),(2,'h'),(2,'i'),
154
 
                         (2,'j'),(2,'k'),(2,'l'),
155
 
                         (2,'m'),(2,'n'),(2,'o'),
156
 
                         (2,'p'),(2,'q'),(2,'r'),
157
 
                         (2,'s'),(2,'t'),(2,'u'),
158
 
                         (2,'v'),(2,'w'),(2,'x'),
159
 
                         (2,'y'),(2,'z'),(2,NULL),
160
 
                         (4,'a'),(4,'b'),(4,'c'),
161
 
                         (4,'d'),(4,'e'),(4,'f'),
162
 
                         (4,'g'),(4,'h'),(4,'i'),
163
 
                         (4,'j'),(4,'k'),(4,'l'),
164
 
                         (4,'m'),(4,'n'),(4,'o'),
165
 
                         (4,'p'),(4,'q'),(4,'r'),
166
 
                         (4,'s'),(4,'t'),(4,'u'),
167
 
                         (4,'v'),(4,'w'),(4,'x'),
168
 
                         (4,'y'),(4,'z'),(4,NULL),
169
 
                         (6,'a'),(6,'b'),(6,'c'),
170
 
                         (6,'d'),(6,'e'),(6,'f'),
171
 
                         (6,'g'),(6,'h'),(6,'i'),
172
 
                         (6,'j'),(6,'k'),(6,'l'),
173
 
                         (6,'m'),(6,'n'),(6,'o'),
174
 
                         (6,'p'),(6,'q'),(6,'r'),
175
 
                         (6,'s'),(6,'t'),(6,'u'),
176
 
                         (6,'v'),(6,'w'),(6,'x'),
177
 
                         (6,'y'),(6,'z'),(6,NULL),
178
 
                         (8,'a'),(8,'b'),(8,'c'),
179
 
                         (8,'d'),(8,'e'),(8,'f'),
180
 
                         (8,'g'),(8,'h'),(8,'i'),
181
 
                         (8,'j'),(8,'k'),(8,'l'),
182
 
                         (8,'m'),(8,'n'),(8,'o'),
183
 
                         (8,'p'),(8,'q'),(8,'r'),
184
 
                         (8,'s'),(8,'t'),(8,'u'),
185
 
                         (8,'v'),(8,'w'),(8,'x'),
186
 
                         (8,'y'),(8,'z'),(8,NULL),
187
 
                         (0,'a'),(0,'b'),(0,'c'),
188
 
                         (0,'d'),(0,'e'),(0,'f'),
189
 
                         (0,'g'),(0,'h'),(0,'i'),
190
 
                         (0,'j'),(0,'k'),(0,'l'),
191
 
                         (0,'m'),(0,'n'),(0,'o'),
192
 
                         (0,'p'),(0,'q'),(0,'r'),
193
 
                         (0,'s'),(0,'t'),(0,'u'),
194
 
                         (0,'v'),(0,'w'),(0,'x'),
195
 
                         (0,'y'),(0,'z'),(0,NULL)))" ]
196
 
};
197
 
 
198
 
 
199
 
$fields = {
200
 
          types => [ 'int' , 'varchar(5)', 'varchar(256)' , 'varchar(512)' , 'date' ,  'datetime' ] ,
201
 
          sign => [ 'signed' ],
202
 
          charsets => [ 'utf8' , 'latin1' , 'cp932' ]
203
 
 
204
 
};
205
 
 
206
 
$data = {
207
 
numbers => [ 'digit' , 'digit' , 'digit' , 'digit' , 'null' ],
208
 
strings => [ 'letter' , 'letter' , 'letter' , 'letter' , 'null' ]
209
 
};
210