oceanbase

1
#### owner: zuojiao.hzj
2
#### owner group: sql3
3
#### description: test
4
# tags: expr, datatype
5

6
--disable_warnings
7
drop table if exists mul_sb;
8
create table mul_sb(c1 int,c2 int(255) zerofill,c3 bigint,c4 bigint unsigned,c5 bigint(255) zerofill,c6 decimal,c7 decimal(35, 15),c8 decimal(35, 7) zerofill,c9 varchar(123) collate utf8mb4_general_ci,c10 date,c11 datetime(5),c12 timestamp(5),c13 year(4),c14 char(24),c15 binary(24),c16 varchar(123) collate utf8mb4_bin);
9
set @tmp_sql_mode = @@sql_mode;
10
set @@sql_mode = '';
11
insert into mul_sb(c1) values(NULL);
12
insert into mul_sb(c1) values(-2146583648);
13
insert into mul_sb(c1) values(0);
14
insert into mul_sb(c1) values(-1);
15
insert into mul_sb(c1) values(123456);
16
insert into mul_sb(c1) values(20120101);
17
insert into mul_sb(c1) values(99990101);
18
insert into mul_sb(c1) values(2146583647);
19
insert into mul_sb(c2) values(NULL);
20
insert into mul_sb(c2) values(0);
21
insert into mul_sb(c2) values(123456);
22
insert into mul_sb(c2) values(20120101);
23
insert into mul_sb(c2) values(99990101);
24
insert into mul_sb(c2) values(2146583647);
25
insert into mul_sb(c3) values(NULL);
26
insert into mul_sb(c3) values(-9223372036854775808);
27
insert into mul_sb(c3) values(-123456789);
28
insert into mul_sb(c3) values(-1);
29
insert into mul_sb(c3) values(0);
30
insert into mul_sb(c3) values(20120101123456);
31
insert into mul_sb(c3) values(99990101123456);
32
insert into mul_sb(c3) values(20120101163456);
33
insert into mul_sb(c3) values(9223372036854775807);
34
insert into mul_sb(c4) values(NULL);
35
insert into mul_sb(c4) values(0);
36
insert into mul_sb(c4) values(20120101123456);
37
insert into mul_sb(c4) values(99990101123456);
38
insert into mul_sb(c4) values(20120101163456);
39
insert into mul_sb(c4) values(9223372036854775807);
40
insert into mul_sb(c4) values(18446744073709551615);
41
insert into mul_sb(c5) values(NULL);
42
insert into mul_sb(c5) values(0);
43
insert into mul_sb(c5) values(123456789);
44
insert into mul_sb(c5) values(20120101123456);
45
insert into mul_sb(c5) values(99990101123456);
46
insert into mul_sb(c5) values(20120101163456);
47
insert into mul_sb(c5) values(9223372036854775807);
48
insert into mul_sb(c6) values(NULL);
49
insert into mul_sb(c6) values(1);
50
insert into mul_sb(c6) values(-1);
51
insert into mul_sb(c6) values(0);
52
insert into mul_sb(c6) values(20120101);
53
insert into mul_sb(c6) values(99991231);
54
insert into mul_sb(c6) values(1234567);
55
insert into mul_sb(c6) values(123);
56
insert into mul_sb(c6) values(-123);
57
insert into mul_sb(c7) values(NULL);
58
insert into mul_sb(c7) values(0);
59
insert into mul_sb(c7) values(0.0);
60
insert into mul_sb(c7) values(0.00000000000000000001);
61
insert into mul_sb(c7) values(1.123456);
62
insert into mul_sb(c7) values(1234567);
63
insert into mul_sb(c7) values(123.45);
64
insert into mul_sb(c7) values(9.999999999999999);
65
insert into mul_sb(c7) values(9.999999999);
66
insert into mul_sb(c7) values(999999999.9);
67
insert into mul_sb(c7) values(9999999999.9);
68
insert into mul_sb(c7) values(999999999);
69
insert into mul_sb(c7) values(-999999999.9);
70
insert into mul_sb(c7) values(-9999999999.9);
71
insert into mul_sb(c7) values(-999999999);
72
insert into mul_sb(c7) values(-9.99999999999);
73
insert into mul_sb(c7) values(20120101123456.99999);
74
insert into mul_sb(c7) values(99990101123456);
75
insert into mul_sb(c7) values(20120101163456);
76
insert into mul_sb(c7) values(1.1234567);
77
insert into mul_sb(c7) values(1.0);
78
insert into mul_sb(c7) values(1.0000000);
79
insert into mul_sb(c7) values(-9.999999999999999);
80
insert into mul_sb(c8) values(NULL);
81
insert into mul_sb(c8) values(1.123456);
82
insert into mul_sb(c8) values(1234567);
83
insert into mul_sb(c8) values(123.45);
84
insert into mul_sb(c8) values(20120101123456);
85
insert into mul_sb(c8) values(99990101123456);
86
insert into mul_sb(c8) values(20120101163456);
87
insert into mul_sb(c8) values(1.1234567);
88
insert into mul_sb(c8) values(1.00000);
89
insert into mul_sb(c8) values(1.0000000);
90
insert into mul_sb(c9) values(NULL);
91
insert into mul_sb(c9) values("0");
92
insert into mul_sb(c9) values("-123");
93
insert into mul_sb(c9) values("a");
94
insert into mul_sb(c9) values("A");
95
insert into mul_sb(c9) values("helloworld");
96
insert into mul_sb(c9) values("");
97
insert into mul_sb(c9) values(" ");
98
insert into mul_sb(c9) values("我爱你C++Soupen");
99
insert into mul_sb(c9) values("20120101123456");
100
insert into mul_sb(c9) values("99990101123456");
101
insert into mul_sb(c9) values("20120101163456");
102
insert into mul_sb(c9) values("111111111111111111111111111111");
103
insert into mul_sb(c9) values("%y%m%d");
104
insert into mul_sb(c9) values("%y%m%d HH:MM:SS");
105
insert into mul_sb(c9) values("192.168.1.1");
106
insert into mul_sb(c10) values(NULL);
107
insert into mul_sb(c10) values(20100101);
108
insert into mul_sb(c10) values(99991301);
109
insert into mul_sb(c11) values(NULL);
110
insert into mul_sb(c11) values(20100101123456);
111
insert into mul_sb(c11) values(20100101123456.789);
112
insert into mul_sb(c11) values(20100101123456.99999);
113
insert into mul_sb(c11) values(20101231235959.99999);
114
insert into mul_sb(c11) values(20100101000000.99999);
115
insert into mul_sb(c11) values(99991301123466);
116
insert into mul_sb(c11) values("9999-12-31 23:59:59.9999997");
117
insert into mul_sb(c12) values(NULL);
118
insert into mul_sb(c12) values(20100101123456);
119
insert into mul_sb(c12) values(20100101000000.99999);
120
insert into mul_sb(c12) values(20100101123456.99999);
121
insert into mul_sb(c12) values(20101231235959.99999);
122
insert into mul_sb(c12) values("9999-12-31 23:59:59.9999997");
123
insert into mul_sb(c13) values(NULL);
124
insert into mul_sb(c13) values(2012);
125
insert into mul_sb(c13) values(0000);
126
insert into mul_sb(c13) values(9999);
127
insert into mul_sb(c13) values(1234567);
128
insert into mul_sb(c14) values(NULL);
129
insert into mul_sb(c14) values("a");
130
insert into mul_sb(c14) values("A");
131
insert into mul_sb(c14) values("helloworld");
132
insert into mul_sb(c14) values("我爱你C++Soupen");
133
insert into mul_sb(c15) values(NULL);
134
insert into mul_sb(c15) values("a");
135
insert into mul_sb(c15) values("A");
136
insert into mul_sb(c15) values("helloworld");
137
insert into mul_sb(c15) values("我爱你C++Soupen");
138
insert into mul_sb(c16) values(NULL);
139
insert into mul_sb(c16) values("a");
140
insert into mul_sb(c16) values("A");
141
insert into mul_sb(c16) values("helloworld");
142
insert into mul_sb(c16) values("我爱你C++Soupen");
143
select (c1 * c1) from mul_sb;
144
select (c1 * c2) from mul_sb;
145
select (c1 * c3) from mul_sb;
146
select (c1 * c4) from mul_sb;
147
select (c1 * c5) from mul_sb;
148
select (c1 * c6) from mul_sb;
149
select (c1 * c7) from mul_sb;
150
select (c1 * c8) from mul_sb;
151
select (c1 * c9) from mul_sb;
152
select (c1 * c10) from mul_sb;
153
select (c1 * c11) from mul_sb;
154
select (c1 * c12) from mul_sb;
155
select (c1 * c13) from mul_sb;
156
select (c1 * c14) from mul_sb;
157
select (c1 * c15) from mul_sb;
158
select (c1 * c16) from mul_sb;
159
select (c1 * NULL) from mul_sb;
160
select (c1 * 0) from mul_sb;
161
select (c1 * 1) from mul_sb;
162
select (c1 * -1) from mul_sb;
163
select (c1 * 1.0) from mul_sb;
164
select (c1 * -1.0) from mul_sb;
165
select (c1 * 0.0) from mul_sb;
166
select (c1 * 1.1111) from mul_sb;
167
--error 1690
168
select (c1 * 1111111111111) from mul_sb;
169
select (c1 * 111.0) from mul_sb;
170
select (c1 * 123) from mul_sb;
171
--error 1690
172
select (c1 * 20120101123456) from mul_sb;
173
select (c1 * "20120101123456") from mul_sb;
174
select (c1 * "helloworld") from mul_sb;
175
select (c1 * "9999-12-31 23:59:59.9999997") from mul_sb;
176
select (c1 * "abc") from mul_sb;
177
select (c1 * "爱拼才会赢") from mul_sb;
178
select (c1 * "A") from mul_sb;
179
select (c1 * "a") from mul_sb;
180
select (c1 * "%y%m%d") from mul_sb;
181
--error 1690
182
select (c1 * -9223372036854775808) from mul_sb;
183
--error 1690
184
select (c1 * 9223372036854775807) from mul_sb;
185
--error 1690
186
select (c1 * 18446744073709551615) from mul_sb;
187
select (c2 * c1) from mul_sb;
188
select (c2 * c2) from mul_sb;
189
select (c2 * c3) from mul_sb;
190
select (c2 * c4) from mul_sb;
191
select (c2 * c5) from mul_sb;
192
select (c2 * c6) from mul_sb;
193
select (c2 * c7) from mul_sb;
194
select (c2 * c8) from mul_sb;
195
select (c2 * c9) from mul_sb;
196
select (c2 * c10) from mul_sb;
197
select (c2 * c11) from mul_sb;
198
select (c2 * c12) from mul_sb;
199
select (c2 * c13) from mul_sb;
200
select (c2 * c14) from mul_sb;
201
select (c2 * c15) from mul_sb;
202
select (c2 * c16) from mul_sb;
203
select (c2 * NULL) from mul_sb;
204
select (c2 * 0) from mul_sb;
205
select (c2 * 1) from mul_sb;
206
--error 1690
207
select (c2 * -1) from mul_sb;
208
select (c2 * 1.0) from mul_sb;
209
select (c2 * -1.0) from mul_sb;
210
select (c2 * 0.0) from mul_sb;
211
select (c2 * 1.1111) from mul_sb;
212
--error 1690
213
select (c2 * 1111111111111) from mul_sb;
214
select (c2 * 111.0) from mul_sb;
215
select (c2 * 123) from mul_sb;
216
--error 1690
217
select (c2 * 20120101123456) from mul_sb;
218
select (c2 * "20120101123456") from mul_sb;
219
select (c2 * "helloworld") from mul_sb;
220
select (c2 * "9999-12-31 23:59:59.9999997") from mul_sb;
221
select (c2 * "abc") from mul_sb;
222
select (c2 * "爱拼才会赢") from mul_sb;
223
select (c2 * "A") from mul_sb;
224
select (c2 * "a") from mul_sb;
225
select (c2 * "%y%m%d") from mul_sb;
226
--error 1690
227
select (c2 * -9223372036854775808) from mul_sb;
228
--error 1690
229
select (c2 * 9223372036854775807) from mul_sb;
230
--error 1690
231
select (c2 * 18446744073709551615) from mul_sb;
232
select (c3 * c1) from mul_sb;
233
select (c3 * c2) from mul_sb;
234
--error 1690
235
select (c3 * c3) from mul_sb;
236
select (c3 * c4) from mul_sb;
237
select (c3 * c5) from mul_sb;
238
select (c3 * c6) from mul_sb;
239
select (c3 * c7) from mul_sb;
240
select (c3 * c8) from mul_sb;
241
select (c3 * c9) from mul_sb;
242
select (c3 * c10) from mul_sb;
243
select (c3 * c11) from mul_sb;
244
select (c3 * c12) from mul_sb;
245
select (c3 * c13) from mul_sb;
246
select (c3 * c14) from mul_sb;
247
select (c3 * c15) from mul_sb;
248
select (c3 * c16) from mul_sb;
249
select (c3 * NULL) from mul_sb;
250
select (c3 * 0) from mul_sb;
251
select (c3 * 1) from mul_sb;
252
--error 1690
253
select (c3 * -1) from mul_sb;
254
select (c3 * 1.0) from mul_sb;
255
select (c3 * -1.0) from mul_sb;
256
select (c3 * 0.0) from mul_sb;
257
select (c3 * 1.1111) from mul_sb;
258
--error 1690
259
select (c3 * 1111111111111) from mul_sb;
260
select (c3 * 111.0) from mul_sb;
261
--error 1690
262
select (c3 * 123) from mul_sb;
263
--error 1690
264
select (c3 * 20120101123456) from mul_sb;
265
select (c3 * "20120101123456") from mul_sb;
266
select (c3 * "helloworld") from mul_sb;
267
select (c3 * "9999-12-31 23:59:59.9999997") from mul_sb;
268
select (c3 * "abc") from mul_sb;
269
select (c3 * "爱拼才会赢") from mul_sb;
270
select (c3 * "A") from mul_sb;
271
select (c3 * "a") from mul_sb;
272
select (c3 * "%y%m%d") from mul_sb;
273
--error 1690
274
select (c3 * -9223372036854775808) from mul_sb;
275
--error 1690
276
select (c3 * 9223372036854775807) from mul_sb;
277
--error 1690
278
select (c3 * 18446744073709551615) from mul_sb;
279
select (c4 * c1) from mul_sb;
280
select (c4 * c2) from mul_sb;
281
select (c4 * c3) from mul_sb;
282
--error 1690
283
select (c4 * c4) from mul_sb;
284
select (c4 * c5) from mul_sb;
285
select (c4 * c6) from mul_sb;
286
select (c4 * c7) from mul_sb;
287
select (c4 * c8) from mul_sb;
288
select (c4 * c9) from mul_sb;
289
select (c4 * c10) from mul_sb;
290
select (c4 * c11) from mul_sb;
291
select (c4 * c12) from mul_sb;
292
select (c4 * c13) from mul_sb;
293
select (c4 * c14) from mul_sb;
294
select (c4 * c15) from mul_sb;
295
select (c4 * c16) from mul_sb;
296
select (c4 * NULL) from mul_sb;
297
select (c4 * 0) from mul_sb;
298
select (c4 * 1) from mul_sb;
299
--error 1690
300
select (c4 * -1) from mul_sb;
301
select (c4 * 1.0) from mul_sb;
302
select (c4 * -1.0) from mul_sb;
303
select (c4 * 0.0) from mul_sb;
304
select (c4 * 1.1111) from mul_sb;
305
--error 1690
306
select (c4 * 1111111111111) from mul_sb;
307
select (c4 * 111.0) from mul_sb;
308
--error 1690
309
select (c4 * 123) from mul_sb;
310
--error 1690
311
select (c4 * 20120101123456) from mul_sb;
312
select (c4 * "20120101123456") from mul_sb;
313
select (c4 * "helloworld") from mul_sb;
314
select (c4 * "9999-12-31 23:59:59.9999997") from mul_sb;
315
select (c4 * "abc") from mul_sb;
316
select (c4 * "爱拼才会赢") from mul_sb;
317
select (c4 * "A") from mul_sb;
318
select (c4 * "a") from mul_sb;
319
select (c4 * "%y%m%d") from mul_sb;
320
--error 1690
321
select (c4 * -9223372036854775808) from mul_sb;
322
--error 1690
323
select (c4 * 9223372036854775807) from mul_sb;
324
--error 1690
325
select (c4 * 18446744073709551615) from mul_sb;
326
select (c5 * c1) from mul_sb;
327
select (c5 * c2) from mul_sb;
328
select (c5 * c3) from mul_sb;
329
select (c5 * c4) from mul_sb;
330
--error 1690
331
select (c5 * c5) from mul_sb;
332
select (c5 * c6) from mul_sb;
333
select (c5 * c7) from mul_sb;
334
select (c5 * c8) from mul_sb;
335
select (c5 * c9) from mul_sb;
336
select (c5 * c10) from mul_sb;
337
select (c5 * c11) from mul_sb;
338
select (c5 * c12) from mul_sb;
339
select (c5 * c13) from mul_sb;
340
select (c5 * c14) from mul_sb;
341
select (c5 * c15) from mul_sb;
342
select (c5 * c16) from mul_sb;
343
select (c5 * NULL) from mul_sb;
344
select (c5 * 0) from mul_sb;
345
select (c5 * 1) from mul_sb;
346
--error 1690
347
select (c5 * -1) from mul_sb;
348
select (c5 * 1.0) from mul_sb;
349
select (c5 * -1.0) from mul_sb;
350
select (c5 * 0.0) from mul_sb;
351
select (c5 * 1.1111) from mul_sb;
352
--error 1690
353
select (c5 * 1111111111111) from mul_sb;
354
select (c5 * 111.0) from mul_sb;
355
--error 1690
356
select (c5 * 123) from mul_sb;
357
--error 1690
358
select (c5 * 20120101123456) from mul_sb;
359
select (c5 * "20120101123456") from mul_sb;
360
select (c5 * "helloworld") from mul_sb;
361
select (c5 * "9999-12-31 23:59:59.9999997") from mul_sb;
362
select (c5 * "abc") from mul_sb;
363
select (c5 * "爱拼才会赢") from mul_sb;
364
select (c5 * "A") from mul_sb;
365
select (c5 * "a") from mul_sb;
366
select (c5 * "%y%m%d") from mul_sb;
367
--error 1690
368
select (c5 * -9223372036854775808) from mul_sb;
369
--error 1690
370
select (c5 * 9223372036854775807) from mul_sb;
371
--error 1690
372
select (c5 * 18446744073709551615) from mul_sb;
373
select (c6 * c1) from mul_sb;
374
select (c6 * c2) from mul_sb;
375
select (c6 * c3) from mul_sb;
376
select (c6 * c4) from mul_sb;
377
select (c6 * c5) from mul_sb;
378
select (c6 * c6) from mul_sb;
379
select (c6 * c7) from mul_sb;
380
select (c6 * c8) from mul_sb;
381
select (c6 * c9) from mul_sb;
382
select (c6 * c10) from mul_sb;
383
select (c6 * c11) from mul_sb;
384
select (c6 * c12) from mul_sb;
385
select (c6 * c13) from mul_sb;
386
select (c6 * c14) from mul_sb;
387
select (c6 * c15) from mul_sb;
388
select (c6 * c16) from mul_sb;
389
select (c6 * NULL) from mul_sb;
390
select (c6 * 0) from mul_sb;
391
select (c6 * 1) from mul_sb;
392
select (c6 * -1) from mul_sb;
393
select (c6 * 1.0) from mul_sb;
394
select (c6 * -1.0) from mul_sb;
395
select (c6 * 0.0) from mul_sb;
396
select (c6 * 1.1111) from mul_sb;
397
select (c6 * 1111111111111) from mul_sb;
398
select (c6 * 111.0) from mul_sb;
399
select (c6 * 123) from mul_sb;
400
select (c6 * 20120101123456) from mul_sb;
401
select (c6 * "20120101123456") from mul_sb;
402
select (c6 * "helloworld") from mul_sb;
403
select (c6 * "9999-12-31 23:59:59.9999997") from mul_sb;
404
select (c6 * "abc") from mul_sb;
405
select (c6 * "爱拼才会赢") from mul_sb;
406
select (c6 * "A") from mul_sb;
407
select (c6 * "a") from mul_sb;
408
select (c6 * "%y%m%d") from mul_sb;
409
select (c6 * -9223372036854775808) from mul_sb;
410
select (c6 * 9223372036854775807) from mul_sb;
411
select (c6 * 18446744073709551615) from mul_sb;
412
select (c7 * c1) from mul_sb;
413
select (c7 * c2) from mul_sb;
414
select (c7 * c3) from mul_sb;
415
select (c7 * c4) from mul_sb;
416
select (c7 * c5) from mul_sb;
417
select (c7 * c6) from mul_sb;
418
select (c7 * c7) from mul_sb;
419
select (c7 * c8) from mul_sb;
420
select (c7 * c9) from mul_sb;
421
select (c7 * c10) from mul_sb;
422
select (c7 * c11) from mul_sb;
423
select (c7 * c12) from mul_sb;
424
select (c7 * c13) from mul_sb;
425
select (c7 * c14) from mul_sb;
426
select (c7 * c15) from mul_sb;
427
select (c7 * c16) from mul_sb;
428
select (c7 * NULL) from mul_sb;
429
select (c7 * 0) from mul_sb;
430
select (c7 * 1) from mul_sb;
431
select (c7 * -1) from mul_sb;
432
select (c7 * 1.0) from mul_sb;
433
select (c7 * -1.0) from mul_sb;
434
select (c7 * 0.0) from mul_sb;
435
select (c7 * 1.1111) from mul_sb;
436
select (c7 * 1111111111111) from mul_sb;
437
select (c7 * 111.0) from mul_sb;
438
select (c7 * 123) from mul_sb;
439
select (c7 * 20120101123456) from mul_sb;
440
select (c7 * "20120101123456") from mul_sb;
441
select (c7 * "helloworld") from mul_sb;
442
select (c7 * "9999-12-31 23:59:59.9999997") from mul_sb;
443
select (c7 * "abc") from mul_sb;
444
select (c7 * "爱拼才会赢") from mul_sb;
445
select (c7 * "A") from mul_sb;
446
select (c7 * "a") from mul_sb;
447
select (c7 * "%y%m%d") from mul_sb;
448
select (c7 * -9223372036854775808) from mul_sb;
449
select (c7 * 9223372036854775807) from mul_sb;
450
select (c7 * 18446744073709551615) from mul_sb;
451
select (c8 * c1) from mul_sb;
452
select (c8 * c2) from mul_sb;
453
select (c8 * c3) from mul_sb;
454
select (c8 * c4) from mul_sb;
455
select (c8 * c5) from mul_sb;
456
select (c8 * c6) from mul_sb;
457
select (c8 * c7) from mul_sb;
458
select (c8 * c8) from mul_sb;
459
select (c8 * c9) from mul_sb;
460
select (c8 * c10) from mul_sb;
461
select (c8 * c11) from mul_sb;
462
select (c8 * c12) from mul_sb;
463
select (c8 * c13) from mul_sb;
464
select (c8 * c14) from mul_sb;
465
select (c8 * c15) from mul_sb;
466
select (c8 * c16) from mul_sb;
467
select (c8 * NULL) from mul_sb;
468
select (c8 * 0) from mul_sb;
469
select (c8 * 1) from mul_sb;
470
select (c8 * -1) from mul_sb;
471
select (c8 * 1.0) from mul_sb;
472
select (c8 * -1.0) from mul_sb;
473
select (c8 * 0.0) from mul_sb;
474
select (c8 * 1.1111) from mul_sb;
475
select (c8 * 1111111111111) from mul_sb;
476
select (c8 * 111.0) from mul_sb;
477
select (c8 * 123) from mul_sb;
478
select (c8 * 20120101123456) from mul_sb;
479
select (c8 * "20120101123456") from mul_sb;
480
select (c8 * "helloworld") from mul_sb;
481
select (c8 * "9999-12-31 23:59:59.9999997") from mul_sb;
482
select (c8 * "abc") from mul_sb;
483
select (c8 * "爱拼才会赢") from mul_sb;
484
select (c8 * "A") from mul_sb;
485
select (c8 * "a") from mul_sb;
486
select (c8 * "%y%m%d") from mul_sb;
487
select (c8 * -9223372036854775808) from mul_sb;
488
select (c8 * 9223372036854775807) from mul_sb;
489
select (c8 * 18446744073709551615) from mul_sb;
490
select (c9 * c1) from mul_sb;
491
select (c9 * c2) from mul_sb;
492
select (c9 * c3) from mul_sb;
493
select (c9 * c4) from mul_sb;
494
select (c9 * c5) from mul_sb;
495
select (c9 * c6) from mul_sb;
496
select (c9 * c7) from mul_sb;
497
select (c9 * c8) from mul_sb;
498
select (c9 * c9) from mul_sb;
499
select (c9 * c10) from mul_sb;
500
select (c9 * c11) from mul_sb;
501
select (c9 * c12) from mul_sb;
502
select (c9 * c13) from mul_sb;
503
select (c9 * c14) from mul_sb;
504
select (c9 * c15) from mul_sb;
505
select (c9 * c16) from mul_sb;
506
select (c9 * NULL) from mul_sb;
507
select (c9 * 0) from mul_sb;
508
select (c9 * 1) from mul_sb;
509
select (c9 * -1) from mul_sb;
510
select (c9 * 1.0) from mul_sb;
511
select (c9 * -1.0) from mul_sb;
512
select (c9 * 0.0) from mul_sb;
513
select (c9 * 1.1111) from mul_sb;
514
select (c9 * 1111111111111) from mul_sb;
515
select (c9 * 111.0) from mul_sb;
516
select (c9 * 123) from mul_sb;
517
select (c9 * 20120101123456) from mul_sb;
518
select (c9 * "20120101123456") from mul_sb;
519
select (c9 * "helloworld") from mul_sb;
520
select (c9 * "9999-12-31 23:59:59.9999997") from mul_sb;
521
select (c9 * "abc") from mul_sb;
522
select (c9 * "爱拼才会赢") from mul_sb;
523
select (c9 * "A") from mul_sb;
524
select (c9 * "a") from mul_sb;
525
select (c9 * "%y%m%d") from mul_sb;
526
select (c9 * -9223372036854775808) from mul_sb;
527
select (c9 * 9223372036854775807) from mul_sb;
528
select (c9 * 18446744073709551615) from mul_sb;
529
select (c10 * c1) from mul_sb;
530
select (c10 * c2) from mul_sb;
531
select (c10 * c3) from mul_sb;
532
select (c10 * c4) from mul_sb;
533
select (c10 * c5) from mul_sb;
534
select (c10 * c6) from mul_sb;
535
select (c10 * c7) from mul_sb;
536
select (c10 * c8) from mul_sb;
537
select (c10 * c9) from mul_sb;
538
select (c10 * c10) from mul_sb;
539
select (c10 * c11) from mul_sb;
540
select (c10 * c12) from mul_sb;
541
select (c10 * c13) from mul_sb;
542
select (c10 * c14) from mul_sb;
543
select (c10 * c15) from mul_sb;
544
select (c10 * c16) from mul_sb;
545
select (c10 * NULL) from mul_sb;
546
select (c10 * 0) from mul_sb;
547
select (c10 * 1) from mul_sb;
548
select (c10 * -1) from mul_sb;
549
select (c10 * 1.0) from mul_sb;
550
select (c10 * -1.0) from mul_sb;
551
select (c10 * 0.0) from mul_sb;
552
select (c10 * 1.1111) from mul_sb;
553
--error 1690
554
select (c10 * 1111111111111) from mul_sb;
555
select (c10 * 111.0) from mul_sb;
556
select (c10 * 123) from mul_sb;
557
--error 1690
558
select (c10 * 20120101123456) from mul_sb;
559
select (c10 * "20120101123456") from mul_sb;
560
select (c10 * "helloworld") from mul_sb;
561
select (c10 * "9999-12-31 23:59:59.9999997") from mul_sb;
562
select (c10 * "abc") from mul_sb;
563
select (c10 * "爱拼才会赢") from mul_sb;
564
select (c10 * "A") from mul_sb;
565
select (c10 * "a") from mul_sb;
566
select (c10 * "%y%m%d") from mul_sb;
567
--error 1690
568
select (c10 * -9223372036854775808) from mul_sb;
569
--error 1690
570
select (c10 * 9223372036854775807) from mul_sb;
571
--error 1690
572
select (c10 * 18446744073709551615) from mul_sb;
573
select (c11 * c1) from mul_sb;
574
select (c11 * c2) from mul_sb;
575
select (c11 * c3) from mul_sb;
576
select (c11 * c4) from mul_sb;
577
select (c11 * c5) from mul_sb;
578
select (c11 * c6) from mul_sb;
579
select (c11 * c7) from mul_sb;
580
select (c11 * c8) from mul_sb;
581
select (c11 * c9) from mul_sb;
582
select (c11 * c10) from mul_sb;
583
select (c11 * c11) from mul_sb;
584
select (c11 * c12) from mul_sb;
585
select (c11 * c13) from mul_sb;
586
select (c11 * c14) from mul_sb;
587
select (c11 * c15) from mul_sb;
588
select (c11 * c16) from mul_sb;
589
select (c11 * NULL) from mul_sb;
590
select (c11 * 0) from mul_sb;
591
select (c11 * 1) from mul_sb;
592
select (c11 * -1) from mul_sb;
593
select (c11 * 1.0) from mul_sb;
594
select (c11 * -1.0) from mul_sb;
595
select (c11 * 0.0) from mul_sb;
596
select (c11 * 1.1111) from mul_sb;
597
select (c11 * 1111111111111) from mul_sb;
598
select (c11 * 111.0) from mul_sb;
599
select (c11 * 123) from mul_sb;
600
select (c11 * 20120101123456) from mul_sb;
601
select (c11 * "20120101123456") from mul_sb;
602
select (c11 * "helloworld") from mul_sb;
603
select (c11 * "9999-12-31 23:59:59.9999997") from mul_sb;
604
select (c11 * "abc") from mul_sb;
605
select (c11 * "爱拼才会赢") from mul_sb;
606
select (c11 * "A") from mul_sb;
607
select (c11 * "a") from mul_sb;
608
select (c11 * "%y%m%d") from mul_sb;
609
select (c11 * -9223372036854775808) from mul_sb;
610
select (c11 * 9223372036854775807) from mul_sb;
611
select (c11 * 18446744073709551615) from mul_sb;
612
select (c12 * c1) from mul_sb;
613
select (c12 * c2) from mul_sb;
614
select (c12 * c3) from mul_sb;
615
select (c12 * c4) from mul_sb;
616
select (c12 * c5) from mul_sb;
617
select (c12 * c6) from mul_sb;
618
select (c12 * c7) from mul_sb;
619
select (c12 * c8) from mul_sb;
620
select (c12 * c9) from mul_sb;
621
select (c12 * c10) from mul_sb;
622
select (c12 * c11) from mul_sb;
623
select (c12 * c12) from mul_sb;
624
select (c12 * c13) from mul_sb;
625
select (c12 * c14) from mul_sb;
626
select (c12 * c15) from mul_sb;
627
select (c12 * c16) from mul_sb;
628
select (c12 * NULL) from mul_sb;
629
select (c12 * 0) from mul_sb;
630
select (c12 * 1) from mul_sb;
631
select (c12 * -1) from mul_sb;
632
select (c12 * 1.0) from mul_sb;
633
select (c12 * -1.0) from mul_sb;
634
select (c12 * 0.0) from mul_sb;
635
select (c12 * 1.1111) from mul_sb;
636
select (c12 * 1111111111111) from mul_sb;
637
select (c12 * 111.0) from mul_sb;
638
select (c12 * 123) from mul_sb;
639
select (c12 * 20120101123456) from mul_sb;
640
select (c12 * "20120101123456") from mul_sb;
641
select (c12 * "helloworld") from mul_sb;
642
select (c12 * "9999-12-31 23:59:59.9999997") from mul_sb;
643
select (c12 * "abc") from mul_sb;
644
select (c12 * "爱拼才会赢") from mul_sb;
645
select (c12 * "A") from mul_sb;
646
select (c12 * "a") from mul_sb;
647
select (c12 * "%y%m%d") from mul_sb;
648
select (c12 * -9223372036854775808) from mul_sb;
649
select (c12 * 9223372036854775807) from mul_sb;
650
select (c12 * 18446744073709551615) from mul_sb;
651
select (c13 * c1) from mul_sb;
652
select (c13 * c2) from mul_sb;
653
select (c13 * c3) from mul_sb;
654
select (c13 * c4) from mul_sb;
655
select (c13 * c5) from mul_sb;
656
select (c13 * c6) from mul_sb;
657
select (c13 * c7) from mul_sb;
658
select (c13 * c8) from mul_sb;
659
select (c13 * c9) from mul_sb;
660
select (c13 * c10) from mul_sb;
661
select (c13 * c11) from mul_sb;
662
select (c13 * c12) from mul_sb;
663
select (c13 * c13) from mul_sb;
664
select (c13 * c14) from mul_sb;
665
select (c13 * c15) from mul_sb;
666
select (c13 * c16) from mul_sb;
667
select (c13 * NULL) from mul_sb;
668
select (c13 * 0) from mul_sb;
669
select (c13 * 1) from mul_sb;
670
--error 1690
671
select (c13 * -1) from mul_sb;
672
select (c13 * 1.0) from mul_sb;
673
select (c13 * -1.0) from mul_sb;
674
select (c13 * 0.0) from mul_sb;
675
select (c13 * 1.1111) from mul_sb;
676
select (c13 * 1111111111111) from mul_sb;
677
select (c13 * 111.0) from mul_sb;
678
select (c13 * 123) from mul_sb;
679
select (c13 * 20120101123456) from mul_sb;
680
select (c13 * "20120101123456") from mul_sb;
681
select (c13 * "helloworld") from mul_sb;
682
select (c13 * "9999-12-31 23:59:59.9999997") from mul_sb;
683
select (c13 * "abc") from mul_sb;
684
select (c13 * "爱拼才会赢") from mul_sb;
685
select (c13 * "A") from mul_sb;
686
select (c13 * "a") from mul_sb;
687
select (c13 * "%y%m%d") from mul_sb;
688
--error 1690
689
select (c13 * -9223372036854775808) from mul_sb;
690
--error 1690
691
select (c13 * 9223372036854775807) from mul_sb;
692
--error 1690
693
select (c13 * 18446744073709551615) from mul_sb;
694
select (c14 * c1) from mul_sb;
695
select (c14 * c2) from mul_sb;
696
select (c14 * c3) from mul_sb;
697
select (c14 * c4) from mul_sb;
698
select (c14 * c5) from mul_sb;
699
select (c14 * c6) from mul_sb;
700
select (c14 * c7) from mul_sb;
701
select (c14 * c8) from mul_sb;
702
select (c14 * c9) from mul_sb;
703
select (c14 * c10) from mul_sb;
704
select (c14 * c11) from mul_sb;
705
select (c14 * c12) from mul_sb;
706
select (c14 * c13) from mul_sb;
707
select (c14 * c14) from mul_sb;
708
select (c14 * c15) from mul_sb;
709
select (c14 * c16) from mul_sb;
710
select (c14 * NULL) from mul_sb;
711
select (c14 * 0) from mul_sb;
712
select (c14 * 1) from mul_sb;
713
select (c14 * -1) from mul_sb;
714
select (c14 * 1.0) from mul_sb;
715
select (c14 * -1.0) from mul_sb;
716
select (c14 * 0.0) from mul_sb;
717
select (c14 * 1.1111) from mul_sb;
718
select (c14 * 1111111111111) from mul_sb;
719
select (c14 * 111.0) from mul_sb;
720
select (c14 * 123) from mul_sb;
721
select (c14 * 20120101123456) from mul_sb;
722
select (c14 * "20120101123456") from mul_sb;
723
select (c14 * "helloworld") from mul_sb;
724
select (c14 * "9999-12-31 23:59:59.9999997") from mul_sb;
725
select (c14 * "abc") from mul_sb;
726
select (c14 * "爱拼才会赢") from mul_sb;
727
select (c14 * "A") from mul_sb;
728
select (c14 * "a") from mul_sb;
729
select (c14 * "%y%m%d") from mul_sb;
730
select (c14 * -9223372036854775808) from mul_sb;
731
select (c14 * 9223372036854775807) from mul_sb;
732
select (c14 * 18446744073709551615) from mul_sb;
733
select (c15 * c1) from mul_sb;
734
select (c15 * c2) from mul_sb;
735
select (c15 * c3) from mul_sb;
736
select (c15 * c4) from mul_sb;
737
select (c15 * c5) from mul_sb;
738
select (c15 * c6) from mul_sb;
739
select (c15 * c7) from mul_sb;
740
select (c15 * c8) from mul_sb;
741
select (c15 * c9) from mul_sb;
742
select (c15 * c10) from mul_sb;
743
select (c15 * c11) from mul_sb;
744
select (c15 * c12) from mul_sb;
745
select (c15 * c13) from mul_sb;
746
select (c15 * c14) from mul_sb;
747
select (c15 * c15) from mul_sb;
748
select (c15 * c16) from mul_sb;
749
select (c15 * NULL) from mul_sb;
750
select (c15 * 0) from mul_sb;
751
select (c15 * 1) from mul_sb;
752
select (c15 * -1) from mul_sb;
753
select (c15 * 1.0) from mul_sb;
754
select (c15 * -1.0) from mul_sb;
755
select (c15 * 0.0) from mul_sb;
756
select (c15 * 1.1111) from mul_sb;
757
select (c15 * 1111111111111) from mul_sb;
758
select (c15 * 111.0) from mul_sb;
759
select (c15 * 123) from mul_sb;
760
select (c15 * 20120101123456) from mul_sb;
761
select (c15 * "20120101123456") from mul_sb;
762
select (c15 * "helloworld") from mul_sb;
763
select (c15 * "9999-12-31 23:59:59.9999997") from mul_sb;
764
select (c15 * "abc") from mul_sb;
765
select (c15 * "爱拼才会赢") from mul_sb;
766
select (c15 * "A") from mul_sb;
767
select (c15 * "a") from mul_sb;
768
select (c15 * "%y%m%d") from mul_sb;
769
select (c15 * -9223372036854775808) from mul_sb;
770
select (c15 * 9223372036854775807) from mul_sb;
771
select (c15 * 18446744073709551615) from mul_sb;
772
select (c16 * c1) from mul_sb;
773
select (c16 * c2) from mul_sb;
774
select (c16 * c3) from mul_sb;
775
select (c16 * c4) from mul_sb;
776
select (c16 * c5) from mul_sb;
777
select (c16 * c6) from mul_sb;
778
select (c16 * c7) from mul_sb;
779
select (c16 * c8) from mul_sb;
780
select (c16 * c9) from mul_sb;
781
select (c16 * c10) from mul_sb;
782
select (c16 * c11) from mul_sb;
783
select (c16 * c12) from mul_sb;
784
select (c16 * c13) from mul_sb;
785
select (c16 * c14) from mul_sb;
786
select (c16 * c15) from mul_sb;
787
select (c16 * c16) from mul_sb;
788
select (c16 * NULL) from mul_sb;
789
select (c16 * 0) from mul_sb;
790
select (c16 * 1) from mul_sb;
791
select (c16 * -1) from mul_sb;
792
select (c16 * 1.0) from mul_sb;
793
select (c16 * -1.0) from mul_sb;
794
select (c16 * 0.0) from mul_sb;
795
select (c16 * 1.1111) from mul_sb;
796
select (c16 * 1111111111111) from mul_sb;
797
select (c16 * 111.0) from mul_sb;
798
select (c16 * 123) from mul_sb;
799
select (c16 * 20120101123456) from mul_sb;
800
select (c16 * "20120101123456") from mul_sb;
801
select (c16 * "helloworld") from mul_sb;
802
select (c16 * "9999-12-31 23:59:59.9999997") from mul_sb;
803
select (c16 * "abc") from mul_sb;
804
select (c16 * "爱拼才会赢") from mul_sb;
805
select (c16 * "A") from mul_sb;
806
select (c16 * "a") from mul_sb;
807
select (c16 * "%y%m%d") from mul_sb;
808
select (c16 * -9223372036854775808) from mul_sb;
809
select (c16 * 9223372036854775807) from mul_sb;
810
select (c16 * 18446744073709551615) from mul_sb;
811
select (NULL * c1) from mul_sb;
812
select (NULL * c2) from mul_sb;
813
select (NULL * c3) from mul_sb;
814
select (NULL * c4) from mul_sb;
815
select (NULL * c5) from mul_sb;
816
select (NULL * c6) from mul_sb;
817
select (NULL * c7) from mul_sb;
818
select (NULL * c8) from mul_sb;
819
select (NULL * c9) from mul_sb;
820
select (NULL * c10) from mul_sb;
821
select (NULL * c11) from mul_sb;
822
select (NULL * c12) from mul_sb;
823
select (NULL * c13) from mul_sb;
824
select (NULL * c14) from mul_sb;
825
select (NULL * c15) from mul_sb;
826
select (NULL * c16) from mul_sb;
827
select (NULL * NULL) from mul_sb;
828
select (NULL * 0) from mul_sb;
829
select (NULL * 1) from mul_sb;
830
select (NULL * -1) from mul_sb;
831
select (NULL * 1.0) from mul_sb;
832
select (NULL * -1.0) from mul_sb;
833
select (NULL * 0.0) from mul_sb;
834
select (NULL * 1.1111) from mul_sb;
835
select (NULL * 1111111111111) from mul_sb;
836
select (NULL * 111.0) from mul_sb;
837
select (NULL * 123) from mul_sb;
838
select (NULL * 20120101123456) from mul_sb;
839
select (NULL * "20120101123456") from mul_sb;
840
select (NULL * "helloworld") from mul_sb;
841
select (NULL * "9999-12-31 23:59:59.9999997") from mul_sb;
842
select (NULL * "abc") from mul_sb;
843
select (NULL * "爱拼才会赢") from mul_sb;
844
select (NULL * "A") from mul_sb;
845
select (NULL * "a") from mul_sb;
846
select (NULL * "%y%m%d") from mul_sb;
847
select (NULL * -9223372036854775808) from mul_sb;
848
select (NULL * 9223372036854775807) from mul_sb;
849
select (NULL * 18446744073709551615) from mul_sb;
850
select (0 * c1) from mul_sb;
851
select (0 * c2) from mul_sb;
852
select (0 * c3) from mul_sb;
853
select (0 * c4) from mul_sb;
854
select (0 * c5) from mul_sb;
855
select (0 * c6) from mul_sb;
856
select (0 * c7) from mul_sb;
857
select (0 * c8) from mul_sb;
858
select (0 * c9) from mul_sb;
859
select (0 * c10) from mul_sb;
860
select (0 * c11) from mul_sb;
861
select (0 * c12) from mul_sb;
862
select (0 * c13) from mul_sb;
863
select (0 * c14) from mul_sb;
864
select (0 * c15) from mul_sb;
865
select (0 * c16) from mul_sb;
866
select (0 * NULL) from mul_sb;
867
select (0 * 0) from mul_sb;
868
select (0 * 1) from mul_sb;
869
select (0 * -1) from mul_sb;
870
select (0 * 1.0) from mul_sb;
871
select (0 * -1.0) from mul_sb;
872
select (0 * 0.0) from mul_sb;
873
select (0 * 1.1111) from mul_sb;
874
select (0 * 1111111111111) from mul_sb;
875
select (0 * 111.0) from mul_sb;
876
select (0 * 123) from mul_sb;
877
select (0 * 20120101123456) from mul_sb;
878
select (0 * "20120101123456") from mul_sb;
879
select (0 * "helloworld") from mul_sb;
880
select (0 * "9999-12-31 23:59:59.9999997") from mul_sb;
881
select (0 * "abc") from mul_sb;
882
select (0 * "爱拼才会赢") from mul_sb;
883
select (0 * "A") from mul_sb;
884
select (0 * "a") from mul_sb;
885
select (0 * "%y%m%d") from mul_sb;
886
select (0 * -9223372036854775808) from mul_sb;
887
select (0 * 9223372036854775807) from mul_sb;
888
select (0 * 18446744073709551615) from mul_sb;
889
select (1 * c1) from mul_sb;
890
select (1 * c2) from mul_sb;
891
select (1 * c3) from mul_sb;
892
select (1 * c4) from mul_sb;
893
select (1 * c5) from mul_sb;
894
select (1 * c6) from mul_sb;
895
select (1 * c7) from mul_sb;
896
select (1 * c8) from mul_sb;
897
select (1 * c9) from mul_sb;
898
select (1 * c10) from mul_sb;
899
select (1 * c11) from mul_sb;
900
select (1 * c12) from mul_sb;
901
select (1 * c13) from mul_sb;
902
select (1 * c14) from mul_sb;
903
select (1 * c15) from mul_sb;
904
select (1 * c16) from mul_sb;
905
select (1 * NULL) from mul_sb;
906
select (1 * 0) from mul_sb;
907
select (1 * 1) from mul_sb;
908
select (1 * -1) from mul_sb;
909
select (1 * 1.0) from mul_sb;
910
select (1 * -1.0) from mul_sb;
911
select (1 * 0.0) from mul_sb;
912
select (1 * 1.1111) from mul_sb;
913
select (1 * 1111111111111) from mul_sb;
914
select (1 * 111.0) from mul_sb;
915
select (1 * 123) from mul_sb;
916
select (1 * 20120101123456) from mul_sb;
917
select (1 * "20120101123456") from mul_sb;
918
select (1 * "helloworld") from mul_sb;
919
select (1 * "9999-12-31 23:59:59.9999997") from mul_sb;
920
select (1 * "abc") from mul_sb;
921
select (1 * "爱拼才会赢") from mul_sb;
922
select (1 * "A") from mul_sb;
923
select (1 * "a") from mul_sb;
924
select (1 * "%y%m%d") from mul_sb;
925
select (1 * -9223372036854775808) from mul_sb;
926
select (1 * 9223372036854775807) from mul_sb;
927
select (1 * 18446744073709551615) from mul_sb;
928
select (-1 * c1) from mul_sb;
929
--error 1690
930
select (-1 * c2) from mul_sb;
931
--error 1690
932
select (-1 * c3) from mul_sb;
933
--error 1690
934
select (-1 * c4) from mul_sb;
935
--error 1690
936
select (-1 * c5) from mul_sb;
937
select (-1 * c6) from mul_sb;
938
select (-1 * c7) from mul_sb;
939
select (-1 * c8) from mul_sb;
940
select (-1 * c9) from mul_sb;
941
select (-1 * c10) from mul_sb;
942
select (-1 * c11) from mul_sb;
943
select (-1 * c12) from mul_sb;
944
--error 1690
945
select (-1 * c13) from mul_sb;
946
select (-1 * c14) from mul_sb;
947
select (-1 * c15) from mul_sb;
948
select (-1 * c16) from mul_sb;
949
select (-1 * NULL) from mul_sb;
950
select (-1 * 0) from mul_sb;
951
select (-1 * 1) from mul_sb;
952
select (-1 * -1) from mul_sb;
953
select (-1 * 1.0) from mul_sb;
954
select (-1 * -1.0) from mul_sb;
955
select (-1 * 0.0) from mul_sb;
956
select (-1 * 1.1111) from mul_sb;
957
select (-1 * 1111111111111) from mul_sb;
958
select (-1 * 111.0) from mul_sb;
959
select (-1 * 123) from mul_sb;
960
select (-1 * 20120101123456) from mul_sb;
961
select (-1 * "20120101123456") from mul_sb;
962
select (-1 * "helloworld") from mul_sb;
963
select (-1 * "9999-12-31 23:59:59.9999997") from mul_sb;
964
select (-1 * "abc") from mul_sb;
965
select (-1 * "爱拼才会赢") from mul_sb;
966
select (-1 * "A") from mul_sb;
967
select (-1 * "a") from mul_sb;
968
select (-1 * "%y%m%d") from mul_sb;
969
--error 1690
970
select (-1 * -9223372036854775808) from mul_sb;
971
select (-1 * 9223372036854775807) from mul_sb;
972
--error 1690
973
select (-1 * 18446744073709551615) from mul_sb;
974
select (1.0 * c1) from mul_sb;
975
select (1.0 * c2) from mul_sb;
976
select (1.0 * c3) from mul_sb;
977
select (1.0 * c4) from mul_sb;
978
select (1.0 * c5) from mul_sb;
979
select (1.0 * c6) from mul_sb;
980
select (1.0 * c7) from mul_sb;
981
select (1.0 * c8) from mul_sb;
982
select (1.0 * c9) from mul_sb;
983
select (1.0 * c10) from mul_sb;
984
select (1.0 * c11) from mul_sb;
985
select (1.0 * c12) from mul_sb;
986
select (1.0 * c13) from mul_sb;
987
select (1.0 * c14) from mul_sb;
988
select (1.0 * c15) from mul_sb;
989
select (1.0 * c16) from mul_sb;
990
select (1.0 * NULL) from mul_sb;
991
select (1.0 * 0) from mul_sb;
992
select (1.0 * 1) from mul_sb;
993
select (1.0 * -1) from mul_sb;
994
select (1.0 * 1.0) from mul_sb;
995
select (1.0 * -1.0) from mul_sb;
996
select (1.0 * 0.0) from mul_sb;
997
select (1.0 * 1.1111) from mul_sb;
998
select (1.0 * 1111111111111) from mul_sb;
999
select (1.0 * 111.0) from mul_sb;
1000
select (1.0 * 123) from mul_sb;
1001
select (1.0 * 20120101123456) from mul_sb;
1002
select (1.0 * "20120101123456") from mul_sb;
1003
select (1.0 * "helloworld") from mul_sb;
1004
select (1.0 * "9999-12-31 23:59:59.9999997") from mul_sb;
1005
select (1.0 * "abc") from mul_sb;
1006
select (1.0 * "爱拼才会赢") from mul_sb;
1007
select (1.0 * "A") from mul_sb;
1008
select (1.0 * "a") from mul_sb;
1009
select (1.0 * "%y%m%d") from mul_sb;
1010
select (1.0 * -9223372036854775808) from mul_sb;
1011
select (1.0 * 9223372036854775807) from mul_sb;
1012
select (1.0 * 18446744073709551615) from mul_sb;
1013
select (-1.0 * c1) from mul_sb;
1014
select (-1.0 * c2) from mul_sb;
1015
select (-1.0 * c3) from mul_sb;
1016
select (-1.0 * c4) from mul_sb;
1017
select (-1.0 * c5) from mul_sb;
1018
select (-1.0 * c6) from mul_sb;
1019
select (-1.0 * c7) from mul_sb;
1020
select (-1.0 * c8) from mul_sb;
1021
select (-1.0 * c9) from mul_sb;
1022
select (-1.0 * c10) from mul_sb;
1023
select (-1.0 * c11) from mul_sb;
1024
select (-1.0 * c12) from mul_sb;
1025
select (-1.0 * c13) from mul_sb;
1026
select (-1.0 * c14) from mul_sb;
1027
select (-1.0 * c15) from mul_sb;
1028
select (-1.0 * c16) from mul_sb;
1029
select (-1.0 * NULL) from mul_sb;
1030
select (-1.0 * 0) from mul_sb;
1031
select (-1.0 * 1) from mul_sb;
1032
select (-1.0 * -1) from mul_sb;
1033
select (-1.0 * 1.0) from mul_sb;
1034
select (-1.0 * -1.0) from mul_sb;
1035
select (-1.0 * 0.0) from mul_sb;
1036
select (-1.0 * 1.1111) from mul_sb;
1037
select (-1.0 * 1111111111111) from mul_sb;
1038
select (-1.0 * 111.0) from mul_sb;
1039
select (-1.0 * 123) from mul_sb;
1040
select (-1.0 * 20120101123456) from mul_sb;
1041
select (-1.0 * "20120101123456") from mul_sb;
1042
select (-1.0 * "helloworld") from mul_sb;
1043
select (-1.0 * "9999-12-31 23:59:59.9999997") from mul_sb;
1044
select (-1.0 * "abc") from mul_sb;
1045
select (-1.0 * "爱拼才会赢") from mul_sb;
1046
select (-1.0 * "A") from mul_sb;
1047
select (-1.0 * "a") from mul_sb;
1048
select (-1.0 * "%y%m%d") from mul_sb;
1049
select (-1.0 * -9223372036854775808) from mul_sb;
1050
select (-1.0 * 9223372036854775807) from mul_sb;
1051
select (-1.0 * 18446744073709551615) from mul_sb;
1052
select (0.0 * c1) from mul_sb;
1053
select (0.0 * c2) from mul_sb;
1054
select (0.0 * c3) from mul_sb;
1055
select (0.0 * c4) from mul_sb;
1056
select (0.0 * c5) from mul_sb;
1057
select (0.0 * c6) from mul_sb;
1058
select (0.0 * c7) from mul_sb;
1059
select (0.0 * c8) from mul_sb;
1060
select (0.0 * c9) from mul_sb;
1061
select (0.0 * c10) from mul_sb;
1062
select (0.0 * c11) from mul_sb;
1063
select (0.0 * c12) from mul_sb;
1064
select (0.0 * c13) from mul_sb;
1065
select (0.0 * c14) from mul_sb;
1066
select (0.0 * c15) from mul_sb;
1067
select (0.0 * c16) from mul_sb;
1068
select (0.0 * NULL) from mul_sb;
1069
select (0.0 * 0) from mul_sb;
1070
select (0.0 * 1) from mul_sb;
1071
select (0.0 * -1) from mul_sb;
1072
select (0.0 * 1.0) from mul_sb;
1073
select (0.0 * -1.0) from mul_sb;
1074
select (0.0 * 0.0) from mul_sb;
1075
select (0.0 * 1.1111) from mul_sb;
1076
select (0.0 * 1111111111111) from mul_sb;
1077
select (0.0 * 111.0) from mul_sb;
1078
select (0.0 * 123) from mul_sb;
1079
select (0.0 * 20120101123456) from mul_sb;
1080
select (0.0 * "20120101123456") from mul_sb;
1081
select (0.0 * "helloworld") from mul_sb;
1082
select (0.0 * "9999-12-31 23:59:59.9999997") from mul_sb;
1083
select (0.0 * "abc") from mul_sb;
1084
select (0.0 * "爱拼才会赢") from mul_sb;
1085
select (0.0 * "A") from mul_sb;
1086
select (0.0 * "a") from mul_sb;
1087
select (0.0 * "%y%m%d") from mul_sb;
1088
select (0.0 * -9223372036854775808) from mul_sb;
1089
select (0.0 * 9223372036854775807) from mul_sb;
1090
select (0.0 * 18446744073709551615) from mul_sb;
1091
select (1.1111 * c1) from mul_sb;
1092
select (1.1111 * c2) from mul_sb;
1093
select (1.1111 * c3) from mul_sb;
1094
select (1.1111 * c4) from mul_sb;
1095
select (1.1111 * c5) from mul_sb;
1096
select (1.1111 * c6) from mul_sb;
1097
select (1.1111 * c7) from mul_sb;
1098
select (1.1111 * c8) from mul_sb;
1099
select (1.1111 * c9) from mul_sb;
1100
select (1.1111 * c10) from mul_sb;
1101
select (1.1111 * c11) from mul_sb;
1102
select (1.1111 * c12) from mul_sb;
1103
select (1.1111 * c13) from mul_sb;
1104
select (1.1111 * c14) from mul_sb;
1105
select (1.1111 * c15) from mul_sb;
1106
select (1.1111 * c16) from mul_sb;
1107
select (1.1111 * NULL) from mul_sb;
1108
select (1.1111 * 0) from mul_sb;
1109
select (1.1111 * 1) from mul_sb;
1110
select (1.1111 * -1) from mul_sb;
1111
select (1.1111 * 1.0) from mul_sb;
1112
select (1.1111 * -1.0) from mul_sb;
1113
select (1.1111 * 0.0) from mul_sb;
1114
select (1.1111 * 1.1111) from mul_sb;
1115
select (1.1111 * 1111111111111) from mul_sb;
1116
select (1.1111 * 111.0) from mul_sb;
1117
select (1.1111 * 123) from mul_sb;
1118
select (1.1111 * 20120101123456) from mul_sb;
1119
select (1.1111 * "20120101123456") from mul_sb;
1120
select (1.1111 * "helloworld") from mul_sb;
1121
select (1.1111 * "9999-12-31 23:59:59.9999997") from mul_sb;
1122
select (1.1111 * "abc") from mul_sb;
1123
select (1.1111 * "爱拼才会赢") from mul_sb;
1124
select (1.1111 * "A") from mul_sb;
1125
select (1.1111 * "a") from mul_sb;
1126
select (1.1111 * "%y%m%d") from mul_sb;
1127
select (1.1111 * -9223372036854775808) from mul_sb;
1128
select (1.1111 * 9223372036854775807) from mul_sb;
1129
select (1.1111 * 18446744073709551615) from mul_sb;
1130
--error 1690
1131
select (1111111111111 * c1) from mul_sb;
1132
--error 1690
1133
select (1111111111111 * c2) from mul_sb;
1134
--error 1690
1135
select (1111111111111 * c3) from mul_sb;
1136
--error 1690
1137
select (1111111111111 * c4) from mul_sb;
1138
--error 1690
1139
select (1111111111111 * c5) from mul_sb;
1140
select (1111111111111 * c6) from mul_sb;
1141
select (1111111111111 * c7) from mul_sb;
1142
select (1111111111111 * c8) from mul_sb;
1143
select (1111111111111 * c9) from mul_sb;
1144
--error 1690
1145
select (1111111111111 * c10) from mul_sb;
1146
select (1111111111111 * c11) from mul_sb;
1147
select (1111111111111 * c12) from mul_sb;
1148
select (1111111111111 * c13) from mul_sb;
1149
select (1111111111111 * c14) from mul_sb;
1150
select (1111111111111 * c15) from mul_sb;
1151
select (1111111111111 * c16) from mul_sb;
1152
select (1111111111111 * NULL) from mul_sb;
1153
select (1111111111111 * 0) from mul_sb;
1154
select (1111111111111 * 1) from mul_sb;
1155
select (1111111111111 * -1) from mul_sb;
1156
select (1111111111111 * 1.0) from mul_sb;
1157
select (1111111111111 * -1.0) from mul_sb;
1158
select (1111111111111 * 0.0) from mul_sb;
1159
select (1111111111111 * 1.1111) from mul_sb;
1160
--error 1690
1161
select (1111111111111 * 1111111111111) from mul_sb;
1162
select (1111111111111 * 111.0) from mul_sb;
1163
select (1111111111111 * 123) from mul_sb;
1164
--error 1690
1165
select (1111111111111 * 20120101123456) from mul_sb;
1166
select (1111111111111 * "20120101123456") from mul_sb;
1167
select (1111111111111 * "helloworld") from mul_sb;
1168
select (1111111111111 * "9999-12-31 23:59:59.9999997") from mul_sb;
1169
select (1111111111111 * "abc") from mul_sb;
1170
select (1111111111111 * "爱拼才会赢") from mul_sb;
1171
select (1111111111111 * "A") from mul_sb;
1172
select (1111111111111 * "a") from mul_sb;
1173
select (1111111111111 * "%y%m%d") from mul_sb;
1174
--error 1690
1175
select (1111111111111 * -9223372036854775808) from mul_sb;
1176
--error 1690
1177
select (1111111111111 * 9223372036854775807) from mul_sb;
1178
--error 1690
1179
select (1111111111111 * 18446744073709551615) from mul_sb;
1180
select (111.0 * c1) from mul_sb;
1181
select (111.0 * c2) from mul_sb;
1182
select (111.0 * c3) from mul_sb;
1183
select (111.0 * c4) from mul_sb;
1184
select (111.0 * c5) from mul_sb;
1185
select (111.0 * c6) from mul_sb;
1186
select (111.0 * c7) from mul_sb;
1187
select (111.0 * c8) from mul_sb;
1188
select (111.0 * c9) from mul_sb;
1189
select (111.0 * c10) from mul_sb;
1190
select (111.0 * c11) from mul_sb;
1191
select (111.0 * c12) from mul_sb;
1192
select (111.0 * c13) from mul_sb;
1193
select (111.0 * c14) from mul_sb;
1194
select (111.0 * c15) from mul_sb;
1195
select (111.0 * c16) from mul_sb;
1196
select (111.0 * NULL) from mul_sb;
1197
select (111.0 * 0) from mul_sb;
1198
select (111.0 * 1) from mul_sb;
1199
select (111.0 * -1) from mul_sb;
1200
select (111.0 * 1.0) from mul_sb;
1201
select (111.0 * -1.0) from mul_sb;
1202
select (111.0 * 0.0) from mul_sb;
1203
select (111.0 * 1.1111) from mul_sb;
1204
select (111.0 * 1111111111111) from mul_sb;
1205
select (111.0 * 111.0) from mul_sb;
1206
select (111.0 * 123) from mul_sb;
1207
select (111.0 * 20120101123456) from mul_sb;
1208
select (111.0 * "20120101123456") from mul_sb;
1209
select (111.0 * "helloworld") from mul_sb;
1210
select (111.0 * "9999-12-31 23:59:59.9999997") from mul_sb;
1211
select (111.0 * "abc") from mul_sb;
1212
select (111.0 * "爱拼才会赢") from mul_sb;
1213
select (111.0 * "A") from mul_sb;
1214
select (111.0 * "a") from mul_sb;
1215
select (111.0 * "%y%m%d") from mul_sb;
1216
select (111.0 * -9223372036854775808) from mul_sb;
1217
select (111.0 * 9223372036854775807) from mul_sb;
1218
select (111.0 * 18446744073709551615) from mul_sb;
1219
select (123 * c1) from mul_sb;
1220
select (123 * c2) from mul_sb;
1221
--error 1690
1222
select (123 * c3) from mul_sb;
1223
--error 1690
1224
select (123 * c4) from mul_sb;
1225
--error 1690
1226
select (123 * c5) from mul_sb;
1227
select (123 * c6) from mul_sb;
1228
select (123 * c7) from mul_sb;
1229
select (123 * c8) from mul_sb;
1230
select (123 * c9) from mul_sb;
1231
select (123 * c10) from mul_sb;
1232
select (123 * c11) from mul_sb;
1233
select (123 * c12) from mul_sb;
1234
select (123 * c13) from mul_sb;
1235
select (123 * c14) from mul_sb;
1236
select (123 * c15) from mul_sb;
1237
select (123 * c16) from mul_sb;
1238
select (123 * NULL) from mul_sb;
1239
select (123 * 0) from mul_sb;
1240
select (123 * 1) from mul_sb;
1241
select (123 * -1) from mul_sb;
1242
select (123 * 1.0) from mul_sb;
1243
select (123 * -1.0) from mul_sb;
1244
select (123 * 0.0) from mul_sb;
1245
select (123 * 1.1111) from mul_sb;
1246
select (123 * 1111111111111) from mul_sb;
1247
select (123 * 111.0) from mul_sb;
1248
select (123 * 123) from mul_sb;
1249
select (123 * 20120101123456) from mul_sb;
1250
select (123 * "20120101123456") from mul_sb;
1251
select (123 * "helloworld") from mul_sb;
1252
select (123 * "9999-12-31 23:59:59.9999997") from mul_sb;
1253
select (123 * "abc") from mul_sb;
1254
select (123 * "爱拼才会赢") from mul_sb;
1255
select (123 * "A") from mul_sb;
1256
select (123 * "a") from mul_sb;
1257
select (123 * "%y%m%d") from mul_sb;
1258
--error 1690
1259
select (123 * -9223372036854775808) from mul_sb;
1260
--error 1690
1261
select (123 * 9223372036854775807) from mul_sb;
1262
--error 1690
1263
select (123 * 18446744073709551615) from mul_sb;
1264
--error 1690
1265
select (20120101123456 * c1) from mul_sb;
1266
--error 1690
1267
select (20120101123456 * c2) from mul_sb;
1268
--error 1690
1269
select (20120101123456 * c3) from mul_sb;
1270
--error 1690
1271
select (20120101123456 * c4) from mul_sb;
1272
--error 1690
1273
select (20120101123456 * c5) from mul_sb;
1274
select (20120101123456 * c6) from mul_sb;
1275
select (20120101123456 * c7) from mul_sb;
1276
select (20120101123456 * c8) from mul_sb;
1277
select (20120101123456 * c9) from mul_sb;
1278
--error 1690
1279
select (20120101123456 * c10) from mul_sb;
1280
select (20120101123456 * c11) from mul_sb;
1281
select (20120101123456 * c12) from mul_sb;
1282
select (20120101123456 * c13) from mul_sb;
1283
select (20120101123456 * c14) from mul_sb;
1284
select (20120101123456 * c15) from mul_sb;
1285
select (20120101123456 * c16) from mul_sb;
1286
select (20120101123456 * NULL) from mul_sb;
1287
select (20120101123456 * 0) from mul_sb;
1288
select (20120101123456 * 1) from mul_sb;
1289
select (20120101123456 * -1) from mul_sb;
1290
select (20120101123456 * 1.0) from mul_sb;
1291
select (20120101123456 * -1.0) from mul_sb;
1292
select (20120101123456 * 0.0) from mul_sb;
1293
select (20120101123456 * 1.1111) from mul_sb;
1294
--error 1690
1295
select (20120101123456 * 1111111111111) from mul_sb;
1296
select (20120101123456 * 111.0) from mul_sb;
1297
select (20120101123456 * 123) from mul_sb;
1298
--error 1690
1299
select (20120101123456 * 20120101123456) from mul_sb;
1300
select (20120101123456 * "20120101123456") from mul_sb;
1301
select (20120101123456 * "helloworld") from mul_sb;
1302
select (20120101123456 * "9999-12-31 23:59:59.9999997") from mul_sb;
1303
select (20120101123456 * "abc") from mul_sb;
1304
select (20120101123456 * "爱拼才会赢") from mul_sb;
1305
select (20120101123456 * "A") from mul_sb;
1306
select (20120101123456 * "a") from mul_sb;
1307
select (20120101123456 * "%y%m%d") from mul_sb;
1308
--error 1690
1309
select (20120101123456 * -9223372036854775808) from mul_sb;
1310
--error 1690
1311
select (20120101123456 * 9223372036854775807) from mul_sb;
1312
--error 1690
1313
select (20120101123456 * 18446744073709551615) from mul_sb;
1314
select ("20120101123456" * c1) from mul_sb;
1315
select ("20120101123456" * c2) from mul_sb;
1316
select ("20120101123456" * c3) from mul_sb;
1317
select ("20120101123456" * c4) from mul_sb;
1318
select ("20120101123456" * c5) from mul_sb;
1319
select ("20120101123456" * c6) from mul_sb;
1320
select ("20120101123456" * c7) from mul_sb;
1321
select ("20120101123456" * c8) from mul_sb;
1322
select ("20120101123456" * c9) from mul_sb;
1323
select ("20120101123456" * c10) from mul_sb;
1324
select ("20120101123456" * c11) from mul_sb;
1325
select ("20120101123456" * c12) from mul_sb;
1326
select ("20120101123456" * c13) from mul_sb;
1327
select ("20120101123456" * c14) from mul_sb;
1328
select ("20120101123456" * c15) from mul_sb;
1329
select ("20120101123456" * c16) from mul_sb;
1330
select ("20120101123456" * NULL) from mul_sb;
1331
select ("20120101123456" * 0) from mul_sb;
1332
select ("20120101123456" * 1) from mul_sb;
1333
select ("20120101123456" * -1) from mul_sb;
1334
select ("20120101123456" * 1.0) from mul_sb;
1335
select ("20120101123456" * -1.0) from mul_sb;
1336
select ("20120101123456" * 0.0) from mul_sb;
1337
select ("20120101123456" * 1.1111) from mul_sb;
1338
select ("20120101123456" * 1111111111111) from mul_sb;
1339
select ("20120101123456" * 111.0) from mul_sb;
1340
select ("20120101123456" * 123) from mul_sb;
1341
select ("20120101123456" * 20120101123456) from mul_sb;
1342
select ("20120101123456" * "20120101123456") from mul_sb;
1343
select ("20120101123456" * "helloworld") from mul_sb;
1344
select ("20120101123456" * "9999-12-31 23:59:59.9999997") from mul_sb;
1345
select ("20120101123456" * "abc") from mul_sb;
1346
select ("20120101123456" * "爱拼才会赢") from mul_sb;
1347
select ("20120101123456" * "A") from mul_sb;
1348
select ("20120101123456" * "a") from mul_sb;
1349
select ("20120101123456" * "%y%m%d") from mul_sb;
1350
select ("20120101123456" * -9223372036854775808) from mul_sb;
1351
select ("20120101123456" * 9223372036854775807) from mul_sb;
1352
select ("20120101123456" * 18446744073709551615) from mul_sb;
1353
select ("helloworld" * c1) from mul_sb;
1354
select ("helloworld" * c2) from mul_sb;
1355
select ("helloworld" * c3) from mul_sb;
1356
select ("helloworld" * c4) from mul_sb;
1357
select ("helloworld" * c5) from mul_sb;
1358
select ("helloworld" * c6) from mul_sb;
1359
select ("helloworld" * c7) from mul_sb;
1360
select ("helloworld" * c8) from mul_sb;
1361
select ("helloworld" * c9) from mul_sb;
1362
select ("helloworld" * c10) from mul_sb;
1363
select ("helloworld" * c11) from mul_sb;
1364
select ("helloworld" * c12) from mul_sb;
1365
select ("helloworld" * c13) from mul_sb;
1366
select ("helloworld" * c14) from mul_sb;
1367
select ("helloworld" * c15) from mul_sb;
1368
select ("helloworld" * c16) from mul_sb;
1369
select ("helloworld" * NULL) from mul_sb;
1370
select ("helloworld" * 0) from mul_sb;
1371
select ("helloworld" * 1) from mul_sb;
1372
select ("helloworld" * -1) from mul_sb;
1373
select ("helloworld" * 1.0) from mul_sb;
1374
select ("helloworld" * -1.0) from mul_sb;
1375
select ("helloworld" * 0.0) from mul_sb;
1376
select ("helloworld" * 1.1111) from mul_sb;
1377
select ("helloworld" * 1111111111111) from mul_sb;
1378
select ("helloworld" * 111.0) from mul_sb;
1379
select ("helloworld" * 123) from mul_sb;
1380
select ("helloworld" * 20120101123456) from mul_sb;
1381
select ("helloworld" * "20120101123456") from mul_sb;
1382
select ("helloworld" * "helloworld") from mul_sb;
1383
select ("helloworld" * "9999-12-31 23:59:59.9999997") from mul_sb;
1384
select ("helloworld" * "abc") from mul_sb;
1385
select ("helloworld" * "爱拼才会赢") from mul_sb;
1386
select ("helloworld" * "A") from mul_sb;
1387
select ("helloworld" * "a") from mul_sb;
1388
select ("helloworld" * "%y%m%d") from mul_sb;
1389
select ("helloworld" * -9223372036854775808) from mul_sb;
1390
select ("helloworld" * 9223372036854775807) from mul_sb;
1391
select ("helloworld" * 18446744073709551615) from mul_sb;
1392
select ("9999-12-31 23:59:59.9999997" * c1) from mul_sb;
1393
select ("9999-12-31 23:59:59.9999997" * c2) from mul_sb;
1394
select ("9999-12-31 23:59:59.9999997" * c3) from mul_sb;
1395
select ("9999-12-31 23:59:59.9999997" * c4) from mul_sb;
1396
select ("9999-12-31 23:59:59.9999997" * c5) from mul_sb;
1397
select ("9999-12-31 23:59:59.9999997" * c6) from mul_sb;
1398
select ("9999-12-31 23:59:59.9999997" * c7) from mul_sb;
1399
select ("9999-12-31 23:59:59.9999997" * c8) from mul_sb;
1400
select ("9999-12-31 23:59:59.9999997" * c9) from mul_sb;
1401
select ("9999-12-31 23:59:59.9999997" * c10) from mul_sb;
1402
select ("9999-12-31 23:59:59.9999997" * c11) from mul_sb;
1403
select ("9999-12-31 23:59:59.9999997" * c12) from mul_sb;
1404
select ("9999-12-31 23:59:59.9999997" * c13) from mul_sb;
1405
select ("9999-12-31 23:59:59.9999997" * c14) from mul_sb;
1406
select ("9999-12-31 23:59:59.9999997" * c15) from mul_sb;
1407
select ("9999-12-31 23:59:59.9999997" * c16) from mul_sb;
1408
select ("9999-12-31 23:59:59.9999997" * NULL) from mul_sb;
1409
select ("9999-12-31 23:59:59.9999997" * 0) from mul_sb;
1410
select ("9999-12-31 23:59:59.9999997" * 1) from mul_sb;
1411
select ("9999-12-31 23:59:59.9999997" * -1) from mul_sb;
1412
select ("9999-12-31 23:59:59.9999997" * 1.0) from mul_sb;
1413
select ("9999-12-31 23:59:59.9999997" * -1.0) from mul_sb;
1414
select ("9999-12-31 23:59:59.9999997" * 0.0) from mul_sb;
1415
select ("9999-12-31 23:59:59.9999997" * 1.1111) from mul_sb;
1416
select ("9999-12-31 23:59:59.9999997" * 1111111111111) from mul_sb;
1417
select ("9999-12-31 23:59:59.9999997" * 111.0) from mul_sb;
1418
select ("9999-12-31 23:59:59.9999997" * 123) from mul_sb;
1419
select ("9999-12-31 23:59:59.9999997" * 20120101123456) from mul_sb;
1420
select ("9999-12-31 23:59:59.9999997" * "20120101123456") from mul_sb;
1421
select ("9999-12-31 23:59:59.9999997" * "helloworld") from mul_sb;
1422
select ("9999-12-31 23:59:59.9999997" * "9999-12-31 23:59:59.9999997") from mul_sb;
1423
select ("9999-12-31 23:59:59.9999997" * "abc") from mul_sb;
1424
select ("9999-12-31 23:59:59.9999997" * "爱拼才会赢") from mul_sb;
1425
select ("9999-12-31 23:59:59.9999997" * "A") from mul_sb;
1426
select ("9999-12-31 23:59:59.9999997" * "a") from mul_sb;
1427
select ("9999-12-31 23:59:59.9999997" * "%y%m%d") from mul_sb;
1428
select ("9999-12-31 23:59:59.9999997" * -9223372036854775808) from mul_sb;
1429
select ("9999-12-31 23:59:59.9999997" * 9223372036854775807) from mul_sb;
1430
select ("9999-12-31 23:59:59.9999997" * 18446744073709551615) from mul_sb;
1431
select ("abc" * c1) from mul_sb;
1432
select ("abc" * c2) from mul_sb;
1433
select ("abc" * c3) from mul_sb;
1434
select ("abc" * c4) from mul_sb;
1435
select ("abc" * c5) from mul_sb;
1436
select ("abc" * c6) from mul_sb;
1437
select ("abc" * c7) from mul_sb;
1438
select ("abc" * c8) from mul_sb;
1439
select ("abc" * c9) from mul_sb;
1440
select ("abc" * c10) from mul_sb;
1441
select ("abc" * c11) from mul_sb;
1442
select ("abc" * c12) from mul_sb;
1443
select ("abc" * c13) from mul_sb;
1444
select ("abc" * c14) from mul_sb;
1445
select ("abc" * c15) from mul_sb;
1446
select ("abc" * c16) from mul_sb;
1447
select ("abc" * NULL) from mul_sb;
1448
select ("abc" * 0) from mul_sb;
1449
select ("abc" * 1) from mul_sb;
1450
select ("abc" * -1) from mul_sb;
1451
select ("abc" * 1.0) from mul_sb;
1452
select ("abc" * -1.0) from mul_sb;
1453
select ("abc" * 0.0) from mul_sb;
1454
select ("abc" * 1.1111) from mul_sb;
1455
select ("abc" * 1111111111111) from mul_sb;
1456
select ("abc" * 111.0) from mul_sb;
1457
select ("abc" * 123) from mul_sb;
1458
select ("abc" * 20120101123456) from mul_sb;
1459
select ("abc" * "20120101123456") from mul_sb;
1460
select ("abc" * "helloworld") from mul_sb;
1461
select ("abc" * "9999-12-31 23:59:59.9999997") from mul_sb;
1462
select ("abc" * "abc") from mul_sb;
1463
select ("abc" * "爱拼才会赢") from mul_sb;
1464
select ("abc" * "A") from mul_sb;
1465
select ("abc" * "a") from mul_sb;
1466
select ("abc" * "%y%m%d") from mul_sb;
1467
select ("abc" * -9223372036854775808) from mul_sb;
1468
select ("abc" * 9223372036854775807) from mul_sb;
1469
select ("abc" * 18446744073709551615) from mul_sb;
1470
select ("爱拼才会赢" * c1) from mul_sb;
1471
select ("爱拼才会赢" * c2) from mul_sb;
1472
select ("爱拼才会赢" * c3) from mul_sb;
1473
select ("爱拼才会赢" * c4) from mul_sb;
1474
select ("爱拼才会赢" * c5) from mul_sb;
1475
select ("爱拼才会赢" * c6) from mul_sb;
1476
select ("爱拼才会赢" * c7) from mul_sb;
1477
select ("爱拼才会赢" * c8) from mul_sb;
1478
select ("爱拼才会赢" * c9) from mul_sb;
1479
select ("爱拼才会赢" * c10) from mul_sb;
1480
select ("爱拼才会赢" * c11) from mul_sb;
1481
select ("爱拼才会赢" * c12) from mul_sb;
1482
select ("爱拼才会赢" * c13) from mul_sb;
1483
select ("爱拼才会赢" * c14) from mul_sb;
1484
select ("爱拼才会赢" * c15) from mul_sb;
1485
select ("爱拼才会赢" * c16) from mul_sb;
1486
select ("爱拼才会赢" * NULL) from mul_sb;
1487
select ("爱拼才会赢" * 0) from mul_sb;
1488
select ("爱拼才会赢" * 1) from mul_sb;
1489
select ("爱拼才会赢" * -1) from mul_sb;
1490
select ("爱拼才会赢" * 1.0) from mul_sb;
1491
select ("爱拼才会赢" * -1.0) from mul_sb;
1492
select ("爱拼才会赢" * 0.0) from mul_sb;
1493
select ("爱拼才会赢" * 1.1111) from mul_sb;
1494
select ("爱拼才会赢" * 1111111111111) from mul_sb;
1495
select ("爱拼才会赢" * 111.0) from mul_sb;
1496
select ("爱拼才会赢" * 123) from mul_sb;
1497
select ("爱拼才会赢" * 20120101123456) from mul_sb;
1498
select ("爱拼才会赢" * "20120101123456") from mul_sb;
1499
select ("爱拼才会赢" * "helloworld") from mul_sb;
1500
select ("爱拼才会赢" * "9999-12-31 23:59:59.9999997") from mul_sb;
1501
select ("爱拼才会赢" * "abc") from mul_sb;
1502
select ("爱拼才会赢" * "爱拼才会赢") from mul_sb;
1503
select ("爱拼才会赢" * "A") from mul_sb;
1504
select ("爱拼才会赢" * "a") from mul_sb;
1505
select ("爱拼才会赢" * "%y%m%d") from mul_sb;
1506
select ("爱拼才会赢" * -9223372036854775808) from mul_sb;
1507
select ("爱拼才会赢" * 9223372036854775807) from mul_sb;
1508
select ("爱拼才会赢" * 18446744073709551615) from mul_sb;
1509
select ("A" * c1) from mul_sb;
1510
select ("A" * c2) from mul_sb;
1511
select ("A" * c3) from mul_sb;
1512
select ("A" * c4) from mul_sb;
1513
select ("A" * c5) from mul_sb;
1514
select ("A" * c6) from mul_sb;
1515
select ("A" * c7) from mul_sb;
1516
select ("A" * c8) from mul_sb;
1517
select ("A" * c9) from mul_sb;
1518
select ("A" * c10) from mul_sb;
1519
select ("A" * c11) from mul_sb;
1520
select ("A" * c12) from mul_sb;
1521
select ("A" * c13) from mul_sb;
1522
select ("A" * c14) from mul_sb;
1523
select ("A" * c15) from mul_sb;
1524
select ("A" * c16) from mul_sb;
1525
select ("A" * NULL) from mul_sb;
1526
select ("A" * 0) from mul_sb;
1527
select ("A" * 1) from mul_sb;
1528
select ("A" * -1) from mul_sb;
1529
select ("A" * 1.0) from mul_sb;
1530
select ("A" * -1.0) from mul_sb;
1531
select ("A" * 0.0) from mul_sb;
1532
select ("A" * 1.1111) from mul_sb;
1533
select ("A" * 1111111111111) from mul_sb;
1534
select ("A" * 111.0) from mul_sb;
1535
select ("A" * 123) from mul_sb;
1536
select ("A" * 20120101123456) from mul_sb;
1537
select ("A" * "20120101123456") from mul_sb;
1538
select ("A" * "helloworld") from mul_sb;
1539
select ("A" * "9999-12-31 23:59:59.9999997") from mul_sb;
1540
select ("A" * "abc") from mul_sb;
1541
select ("A" * "爱拼才会赢") from mul_sb;
1542
select ("A" * "A") from mul_sb;
1543
select ("A" * "a") from mul_sb;
1544
select ("A" * "%y%m%d") from mul_sb;
1545
select ("A" * -9223372036854775808) from mul_sb;
1546
select ("A" * 9223372036854775807) from mul_sb;
1547
select ("A" * 18446744073709551615) from mul_sb;
1548
select ("a" * c1) from mul_sb;
1549
select ("a" * c2) from mul_sb;
1550
select ("a" * c3) from mul_sb;
1551
select ("a" * c4) from mul_sb;
1552
select ("a" * c5) from mul_sb;
1553
select ("a" * c6) from mul_sb;
1554
select ("a" * c7) from mul_sb;
1555
select ("a" * c8) from mul_sb;
1556
select ("a" * c9) from mul_sb;
1557
select ("a" * c10) from mul_sb;
1558
select ("a" * c11) from mul_sb;
1559
select ("a" * c12) from mul_sb;
1560
select ("a" * c13) from mul_sb;
1561
select ("a" * c14) from mul_sb;
1562
select ("a" * c15) from mul_sb;
1563
select ("a" * c16) from mul_sb;
1564
select ("a" * NULL) from mul_sb;
1565
select ("a" * 0) from mul_sb;
1566
select ("a" * 1) from mul_sb;
1567
select ("a" * -1) from mul_sb;
1568
select ("a" * 1.0) from mul_sb;
1569
select ("a" * -1.0) from mul_sb;
1570
select ("a" * 0.0) from mul_sb;
1571
select ("a" * 1.1111) from mul_sb;
1572
select ("a" * 1111111111111) from mul_sb;
1573
select ("a" * 111.0) from mul_sb;
1574
select ("a" * 123) from mul_sb;
1575
select ("a" * 20120101123456) from mul_sb;
1576
select ("a" * "20120101123456") from mul_sb;
1577
select ("a" * "helloworld") from mul_sb;
1578
select ("a" * "9999-12-31 23:59:59.9999997") from mul_sb;
1579
select ("a" * "abc") from mul_sb;
1580
select ("a" * "爱拼才会赢") from mul_sb;
1581
select ("a" * "A") from mul_sb;
1582
select ("a" * "a") from mul_sb;
1583
select ("a" * "%y%m%d") from mul_sb;
1584
select ("a" * -9223372036854775808) from mul_sb;
1585
select ("a" * 9223372036854775807) from mul_sb;
1586
select ("a" * 18446744073709551615) from mul_sb;
1587
select ("%y%m%d" * c1) from mul_sb;
1588
select ("%y%m%d" * c2) from mul_sb;
1589
select ("%y%m%d" * c3) from mul_sb;
1590
select ("%y%m%d" * c4) from mul_sb;
1591
select ("%y%m%d" * c5) from mul_sb;
1592
select ("%y%m%d" * c6) from mul_sb;
1593
select ("%y%m%d" * c7) from mul_sb;
1594
select ("%y%m%d" * c8) from mul_sb;
1595
select ("%y%m%d" * c9) from mul_sb;
1596
select ("%y%m%d" * c10) from mul_sb;
1597
select ("%y%m%d" * c11) from mul_sb;
1598
select ("%y%m%d" * c12) from mul_sb;
1599
select ("%y%m%d" * c13) from mul_sb;
1600
select ("%y%m%d" * c14) from mul_sb;
1601
select ("%y%m%d" * c15) from mul_sb;
1602
select ("%y%m%d" * c16) from mul_sb;
1603
select ("%y%m%d" * NULL) from mul_sb;
1604
select ("%y%m%d" * 0) from mul_sb;
1605
select ("%y%m%d" * 1) from mul_sb;
1606
select ("%y%m%d" * -1) from mul_sb;
1607
select ("%y%m%d" * 1.0) from mul_sb;
1608
select ("%y%m%d" * -1.0) from mul_sb;
1609
select ("%y%m%d" * 0.0) from mul_sb;
1610
select ("%y%m%d" * 1.1111) from mul_sb;
1611
select ("%y%m%d" * 1111111111111) from mul_sb;
1612
select ("%y%m%d" * 111.0) from mul_sb;
1613
select ("%y%m%d" * 123) from mul_sb;
1614
select ("%y%m%d" * 20120101123456) from mul_sb;
1615
select ("%y%m%d" * "20120101123456") from mul_sb;
1616
select ("%y%m%d" * "helloworld") from mul_sb;
1617
select ("%y%m%d" * "9999-12-31 23:59:59.9999997") from mul_sb;
1618
select ("%y%m%d" * "abc") from mul_sb;
1619
select ("%y%m%d" * "爱拼才会赢") from mul_sb;
1620
select ("%y%m%d" * "A") from mul_sb;
1621
select ("%y%m%d" * "a") from mul_sb;
1622
select ("%y%m%d" * "%y%m%d") from mul_sb;
1623
select ("%y%m%d" * -9223372036854775808) from mul_sb;
1624
select ("%y%m%d" * 9223372036854775807) from mul_sb;
1625
select ("%y%m%d" * 18446744073709551615) from mul_sb;
1626
--error 1690
1627
select (-9223372036854775808 * c1) from mul_sb;
1628
--error 1690
1629
select (-9223372036854775808 * c2) from mul_sb;
1630
--error 1690
1631
select (-9223372036854775808 * c3) from mul_sb;
1632
--error 1690
1633
select (-9223372036854775808 * c4) from mul_sb;
1634
--error 1690
1635
select (-9223372036854775808 * c5) from mul_sb;
1636
select (-9223372036854775808 * c6) from mul_sb;
1637
select (-9223372036854775808 * c7) from mul_sb;
1638
select (-9223372036854775808 * c8) from mul_sb;
1639
select (-9223372036854775808 * c9) from mul_sb;
1640
--error 1690
1641
select (-9223372036854775808 * c10) from mul_sb;
1642
select (-9223372036854775808 * c11) from mul_sb;
1643
select (-9223372036854775808 * c12) from mul_sb;
1644
--error 1690
1645
select (-9223372036854775808 * c13) from mul_sb;
1646
select (-9223372036854775808 * c14) from mul_sb;
1647
select (-9223372036854775808 * c15) from mul_sb;
1648
select (-9223372036854775808 * c16) from mul_sb;
1649
select (-9223372036854775808 * NULL) from mul_sb;
1650
select (-9223372036854775808 * 0) from mul_sb;
1651
select (-9223372036854775808 * 1) from mul_sb;
1652
--error 1690
1653
select (-9223372036854775808 * -1) from mul_sb;
1654
select (-9223372036854775808 * 1.0) from mul_sb;
1655
select (-9223372036854775808 * -1.0) from mul_sb;
1656
select (-9223372036854775808 * 0.0) from mul_sb;
1657
select (-9223372036854775808 * 1.1111) from mul_sb;
1658
--error 1690
1659
select (-9223372036854775808 * 1111111111111) from mul_sb;
1660
select (-9223372036854775808 * 111.0) from mul_sb;
1661
--error 1690
1662
select (-9223372036854775808 * 123) from mul_sb;
1663
--error 1690
1664
select (-9223372036854775808 * 20120101123456) from mul_sb;
1665
select (-9223372036854775808 * "20120101123456") from mul_sb;
1666
select (-9223372036854775808 * "helloworld") from mul_sb;
1667
select (-9223372036854775808 * "9999-12-31 23:59:59.9999997") from mul_sb;
1668
select (-9223372036854775808 * "abc") from mul_sb;
1669
select (-9223372036854775808 * "爱拼才会赢") from mul_sb;
1670
select (-9223372036854775808 * "A") from mul_sb;
1671
select (-9223372036854775808 * "a") from mul_sb;
1672
select (-9223372036854775808 * "%y%m%d") from mul_sb;
1673
--error 1690
1674
select (-9223372036854775808 * -9223372036854775808) from mul_sb;
1675
--error 1690
1676
select (-9223372036854775808 * 9223372036854775807) from mul_sb;
1677
--error 1690
1678
select (-9223372036854775808 * 18446744073709551615) from mul_sb;
1679
--error 1690
1680
select (9223372036854775807 * c1) from mul_sb;
1681
--error 1690
1682
select (9223372036854775807 * c2) from mul_sb;
1683
--error 1690
1684
select (9223372036854775807 * c3) from mul_sb;
1685
--error 1690
1686
select (9223372036854775807 * c4) from mul_sb;
1687
--error 1690
1688
select (9223372036854775807 * c5) from mul_sb;
1689
select (9223372036854775807 * c6) from mul_sb;
1690
select (9223372036854775807 * c7) from mul_sb;
1691
select (9223372036854775807 * c8) from mul_sb;
1692
select (9223372036854775807 * c9) from mul_sb;
1693
--error 1690
1694
select (9223372036854775807 * c10) from mul_sb;
1695
select (9223372036854775807 * c11) from mul_sb;
1696
select (9223372036854775807 * c12) from mul_sb;
1697
--error 1690
1698
select (9223372036854775807 * c13) from mul_sb;
1699
select (9223372036854775807 * c14) from mul_sb;
1700
select (9223372036854775807 * c15) from mul_sb;
1701
select (9223372036854775807 * c16) from mul_sb;
1702
select (9223372036854775807 * NULL) from mul_sb;
1703
select (9223372036854775807 * 0) from mul_sb;
1704
select (9223372036854775807 * 1) from mul_sb;
1705
select (9223372036854775807 * -1) from mul_sb;
1706
select (9223372036854775807 * 1.0) from mul_sb;
1707
select (9223372036854775807 * -1.0) from mul_sb;
1708
select (9223372036854775807 * 0.0) from mul_sb;
1709
select (9223372036854775807 * 1.1111) from mul_sb;
1710
--error 1690
1711
select (9223372036854775807 * 1111111111111) from mul_sb;
1712
select (9223372036854775807 * 111.0) from mul_sb;
1713
--error 1690
1714
select (9223372036854775807 * 123) from mul_sb;
1715
--error 1690
1716
select (9223372036854775807 * 20120101123456) from mul_sb;
1717
select (9223372036854775807 * "20120101123456") from mul_sb;
1718
select (9223372036854775807 * "helloworld") from mul_sb;
1719
select (9223372036854775807 * "9999-12-31 23:59:59.9999997") from mul_sb;
1720
select (9223372036854775807 * "abc") from mul_sb;
1721
select (9223372036854775807 * "爱拼才会赢") from mul_sb;
1722
select (9223372036854775807 * "A") from mul_sb;
1723
select (9223372036854775807 * "a") from mul_sb;
1724
select (9223372036854775807 * "%y%m%d") from mul_sb;
1725
--error 1690
1726
select (9223372036854775807 * -9223372036854775808) from mul_sb;
1727
--error 1690
1728
select (9223372036854775807 * 9223372036854775807) from mul_sb;
1729
--error 1690
1730
select (9223372036854775807 * 18446744073709551615) from mul_sb;
1731
--error 1690
1732
select (18446744073709551615 * c1) from mul_sb;
1733
--error 1690
1734
select (18446744073709551615 * c2) from mul_sb;
1735
--error 1690
1736
select (18446744073709551615 * c3) from mul_sb;
1737
--error 1690
1738
select (18446744073709551615 * c4) from mul_sb;
1739
--error 1690
1740
select (18446744073709551615 * c5) from mul_sb;
1741
select (18446744073709551615 * c6) from mul_sb;
1742
select (18446744073709551615 * c7) from mul_sb;
1743
select (18446744073709551615 * c8) from mul_sb;
1744
select (18446744073709551615 * c9) from mul_sb;
1745
--error 1690
1746
select (18446744073709551615 * c10) from mul_sb;
1747
select (18446744073709551615 * c11) from mul_sb;
1748
select (18446744073709551615 * c12) from mul_sb;
1749
--error 1690
1750
select (18446744073709551615 * c13) from mul_sb;
1751
select (18446744073709551615 * c14) from mul_sb;
1752
select (18446744073709551615 * c15) from mul_sb;
1753
select (18446744073709551615 * c16) from mul_sb;
1754
select (18446744073709551615 * NULL) from mul_sb;
1755
select (18446744073709551615 * 0) from mul_sb;
1756
select (18446744073709551615 * 1) from mul_sb;
1757
--error 1690
1758
select (18446744073709551615 * -1) from mul_sb;
1759
select (18446744073709551615 * 1.0) from mul_sb;
1760
select (18446744073709551615 * -1.0) from mul_sb;
1761
select (18446744073709551615 * 0.0) from mul_sb;
1762
select (18446744073709551615 * 1.1111) from mul_sb;
1763
--error 1690
1764
select (18446744073709551615 * 1111111111111) from mul_sb;
1765
select (18446744073709551615 * 111.0) from mul_sb;
1766
--error 1690
1767
select (18446744073709551615 * 123) from mul_sb;
1768
--error 1690
1769
select (18446744073709551615 * 20120101123456) from mul_sb;
1770
select (18446744073709551615 * "20120101123456") from mul_sb;
1771
select (18446744073709551615 * "helloworld") from mul_sb;
1772
select (18446744073709551615 * "9999-12-31 23:59:59.9999997") from mul_sb;
1773
select (18446744073709551615 * "abc") from mul_sb;
1774
select (18446744073709551615 * "爱拼才会赢") from mul_sb;
1775
select (18446744073709551615 * "A") from mul_sb;
1776
select (18446744073709551615 * "a") from mul_sb;
1777
select (18446744073709551615 * "%y%m%d") from mul_sb;
1778
--error 1690
1779
select (18446744073709551615 * -9223372036854775808) from mul_sb;
1780
--error 1690
1781
select (18446744073709551615 * 9223372036854775807) from mul_sb;
1782
--error 1690
1783
select (18446744073709551615 * 18446744073709551615) from mul_sb;
1784
drop table mul_sb;
1785

1786
--disable_warnings
1787
drop table if exists h1;
1788
CREATE TABLE h1(  
1789
  case_id int,
1790
  c1 BIGINT unsigned,
1791
  c2 BIGINT unsigned);
1792

1793
insert into h1 values(1, 1, 1);
1794
insert into h1 values(2, 4294967297, 4294967295); # (2^32 + 1) * (2^32 - 1)
1795
insert into h1 values(3, 8589934591, 8589934591); # (2^33 - 1) * (2^33 - 1)
1796
insert into h1 values(4, 17179869183, 4294967295); # (2^34 - 1) * (2^32 - 1)
1797
insert into h1 values(5, 4294967295, 17179869183); # (2^32 - 1) * (2^34 - 1)
1798
insert into h1 values(6, 8589934591, 4294967295); # (2^33 - 1) * (2^32 - 1)
1799
insert into h1 values(7, 4294967295, 8589934591); # (2^32 - 1) * (2^33 - 1)
1800

1801
select * from h1;
1802
select c1 * c2 from h1 where case_id = 1;
1803
select c1 * c2 from h1 where case_id = 2;
1804
--error 1690
1805
select c1 * c2 from h1 where case_id = 3;
1806
--error 1690
1807
select c1 * c2 from h1 where case_id = 4;
1808
--error 1690
1809
select c1 * c2 from h1 where case_id = 5;
1810
--error 1690
1811
select c1 * c2 from h1 where case_id = 6;
1812
--error 1690
1813
select c1 * c2 from h1 where case_id = 7;
1814

1815
--disable_warnings
1816
drop table if exists h1;
1817
CREATE TABLE h1(  
1818
  case_id int,
1819
  c1 bigint,
1820
  c2 bigint);
1821

1822
insert into h1 values(1, 1, 1);
1823
insert into h1 values(2, 1, -1);
1824
insert into h1 values(3, -1, 1);
1825
insert into h1 values(4, -1, -1);
1826
insert into h1 values(5, 2147483647, 4294967297);    # (2^31 - 1)  * (2^32 + 1)
1827
insert into h1 values(6, 4294967297, 2147483647);    # (2^32 + 1)  * (2^31 - 1)
1828
insert into h1 values(7, -2147483647, 4294967297);   # (-2^31 + 1) * (2^32 + 1)
1829
insert into h1 values(8, 4294967297, -2147483647);   # (2^32 + 1)  * (-2^31 + 1)
1830
insert into h1 values(9, 2147483647, -4294967297);   # (2^31 - 1)  * (-2^32 - 1)
1831
insert into h1 values(10, -4294967297, 2147483647);  # (-2^32 - 1) * (2^31 - 1)
1832
insert into h1 values(11, -2147483647, -4294967297); # (-2^31 + 1) * (-2^32 - 1)
1833
insert into h1 values(12, -4294967297, -2147483647); # (-2^32 - 1) * (-2^31 + 1)
1834
insert into h1 values(13, 9223372036854775807, 1);   # (2^63 - 1)  * 1
1835
insert into h1 values(14, 1, 9223372036854775807);   # 1           * (2^63 - 1)
1836
insert into h1 values(15, 9223372036854775807, -1);  # (2^63 - 1)  * (-1)
1837
insert into h1 values(16, -1, 9223372036854775807);  # (-1)        * (2^63 - 1)
1838
insert into h1 values(17, -9223372036854775807, 1);  # (-2^63 + 1) * 1
1839
insert into h1 values(18, 1, -9223372036854775807);  # 1           * (-2^63 + 1)
1840
insert into h1 values(19, -9223372036854775808, 1);  # (-2^63)     * 1
1841
insert into h1 values(20, 1, -9223372036854775808);  # 1           * (-2^63)
1842
insert into h1 values(21, 2, -4611686018427387904);  # 2           * (-2^62)
1843
insert into h1 values(22, -4611686018427387904, 2);  # (-2^62)     * 2
1844
insert into h1 values(23, -2, 4611686018427387904);  # -2          * (2^62)
1845
insert into h1 values(24, 4611686018427387904, -2);  # (2^62)      * 2
1846

1847
insert into h1 values(25, 2, 4611686018427387904);   # 2           * (2^62)
1848
insert into h1 values(26, 4611686018427387904, 2);   # (2^62)      * 2
1849
insert into h1 values(27, -2, -4611686018427387904); # -2          * (2^62)
1850
insert into h1 values(28, -4611686018427387904, -2); # (2^62)      * 2
1851
insert into h1 values(29, 9223372036854775807, 2);   # (2^63 - 1)  * 2
1852
insert into h1 values(30, 2, 9223372036854775807);   # 2           * (2^63 - 1)
1853
insert into h1 values(31, -9223372036854775808, -1); # (-2^63)     * (-1)
1854
insert into h1 values(32, -1, -9223372036854775808); # (-1)        * (-2^63)
1855
insert into h1 values(33, 2147483649, 4294967295);    # (2^31 + 1)  * (2^32 - 1)
1856
insert into h1 values(34, 4294967295, 2147483649);    # (2^32 - 1)  * (2^31 + 1)
1857
insert into h1 values(35, -2147483649, 4294967295);   # (-2^31 - 1) * (2^32 - 1)
1858
insert into h1 values(36, 4294967295, -2147483649);   # (2^32 - 1)  * (-2^31 - 1)
1859
insert into h1 values(37, 2147483649, -4294967295);   # (2^31 + 1)  * (-2^32 + 1)
1860
insert into h1 values(38, -4294967295, 2147483649);  # (-2^32 + 1) * (2^31 + 1)
1861
insert into h1 values(39, -2147483649, -4294967295); # (-2^31 - 1) * (-2^32 + 1)
1862
insert into h1 values(40, -4294967295, -2147483649); # (-2^32 + 1) * (-2^31 - 1)
1863

1864
select * from h1;
1865
select c1 * c2 from h1 where case_id = 1;
1866
select c1 * c2 from h1 where case_id = 2;
1867
select c1 * c2 from h1 where case_id = 3;
1868
select c1 * c2 from h1 where case_id = 4;
1869
select c1 * c2 from h1 where case_id = 5;
1870
select c1 * c2 from h1 where case_id = 6;
1871
select c1 * c2 from h1 where case_id = 7;
1872
select c1 * c2 from h1 where case_id = 8;
1873
select c1 * c2 from h1 where case_id = 9;
1874
select c1 * c2 from h1 where case_id = 10;
1875
select c1 * c2 from h1 where case_id = 11;
1876
select c1 * c2 from h1 where case_id = 12;
1877
select c1 * c2 from h1 where case_id = 13;
1878
select c1 * c2 from h1 where case_id = 14;
1879
select c1 * c2 from h1 where case_id = 15;
1880
select c1 * c2 from h1 where case_id = 16;
1881
select c1 * c2 from h1 where case_id = 17;
1882
select c1 * c2 from h1 where case_id = 18;
1883
select c1 * c2 from h1 where case_id = 19;
1884
select c1 * c2 from h1 where case_id = 20;
1885
select c1 * c2 from h1 where case_id = 21;
1886
select c1 * c2 from h1 where case_id = 22;
1887
select c1 * c2 from h1 where case_id = 23;
1888
select c1 * c2 from h1 where case_id = 24;
1889

1890
--error 1690
1891
select c1 * c2 from h1 where case_id = 25;
1892
--error 1690
1893
select c1 * c2 from h1 where case_id = 26;
1894
--error 1690
1895
select c1 * c2 from h1 where case_id = 27;
1896
--error 1690
1897
select c1 * c2 from h1 where case_id = 28;
1898
--error 1690
1899
select c1 * c2 from h1 where case_id = 29;
1900
--error 1690
1901
select c1 * c2 from h1 where case_id = 30;
1902
--error 1690
1903
select c1 * c2 from h1 where case_id = 31;
1904
--error 1690
1905
select c1 * c2 from h1 where case_id = 32;
1906
--error 1690
1907
select c1 * c2 from h1 where case_id = 33;
1908
--error 1690
1909
select c1 * c2 from h1 where case_id = 34;
1910
--error 1690
1911
select c1 * c2 from h1 where case_id = 35;
1912
--error 1690
1913
select c1 * c2 from h1 where case_id = 36;
1914
--error 1690
1915
select c1 * c2 from h1 where case_id = 37;
1916
--error 1690
1917
select c1 * c2 from h1 where case_id = 38;
1918
--error 1690
1919
select c1 * c2 from h1 where case_id = 39;
1920
--error 1690
1921
select c1 * c2 from h1 where case_id = 40;