oceanbase

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