1748 lines
65 KiB
Plaintext
1748 lines
65 KiB
Plaintext
#### owner: yuchen.wyc
|
|
#### owner group: sql3
|
|
#### description: test
|
|
--disable_warnings
|
|
drop table if exists add_sb;
|
|
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);
|
|
set @tmp_sql_mode = @@sql_mode;
|
|
set @@sql_mode = '';
|
|
insert into add_sb(c1) values(NULL);
|
|
insert into add_sb(c1) values(-2146583648);
|
|
insert into add_sb(c1) values(0);
|
|
insert into add_sb(c1) values(-1);
|
|
insert into add_sb(c1) values(123456);
|
|
insert into add_sb(c1) values(20120101);
|
|
insert into add_sb(c1) values(99990101);
|
|
insert into add_sb(c1) values(2146583647);
|
|
insert into add_sb(c2) values(NULL);
|
|
insert into add_sb(c2) values(0);
|
|
insert into add_sb(c2) values(123456);
|
|
insert into add_sb(c2) values(20120101);
|
|
insert into add_sb(c2) values(99990101);
|
|
insert into add_sb(c2) values(2146583647);
|
|
insert into add_sb(c3) values(NULL);
|
|
insert into add_sb(c3) values(-9223372036854775808);
|
|
insert into add_sb(c3) values(-123456789);
|
|
insert into add_sb(c3) values(-1);
|
|
insert into add_sb(c3) values(0);
|
|
insert into add_sb(c3) values(20120101123456);
|
|
insert into add_sb(c3) values(99990101123456);
|
|
insert into add_sb(c3) values(20120101163456);
|
|
insert into add_sb(c3) values(9223372036854775807);
|
|
insert into add_sb(c4) values(NULL);
|
|
insert into add_sb(c4) values(0);
|
|
insert into add_sb(c4) values(20120101123456);
|
|
insert into add_sb(c4) values(99990101123456);
|
|
insert into add_sb(c4) values(20120101163456);
|
|
insert into add_sb(c4) values(9223372036854775807);
|
|
insert into add_sb(c4) values(18446744073709551615);
|
|
insert into add_sb(c5) values(NULL);
|
|
insert into add_sb(c5) values(0);
|
|
insert into add_sb(c5) values(123456789);
|
|
insert into add_sb(c5) values(20120101123456);
|
|
insert into add_sb(c5) values(99990101123456);
|
|
insert into add_sb(c5) values(20120101163456);
|
|
insert into add_sb(c5) values(9223372036854775807);
|
|
insert into add_sb(c6) values(NULL);
|
|
insert into add_sb(c6) values(1);
|
|
insert into add_sb(c6) values(-1);
|
|
insert into add_sb(c6) values(0);
|
|
insert into add_sb(c6) values(20120101);
|
|
insert into add_sb(c6) values(99991231);
|
|
insert into add_sb(c6) values(1234567);
|
|
insert into add_sb(c6) values(123);
|
|
insert into add_sb(c6) values(-123);
|
|
insert into add_sb(c7) values(NULL);
|
|
insert into add_sb(c7) values(0);
|
|
insert into add_sb(c7) values(0.0);
|
|
insert into add_sb(c7) values(0.00000000000000000001);
|
|
insert into add_sb(c7) values(1.123456);
|
|
insert into add_sb(c7) values(1234567);
|
|
insert into add_sb(c7) values(123.45);
|
|
insert into add_sb(c7) values(9.999999999999999);
|
|
insert into add_sb(c7) values(9.999999999);
|
|
insert into add_sb(c7) values(999999999.9);
|
|
insert into add_sb(c7) values(9999999999.9);
|
|
insert into add_sb(c7) values(999999999);
|
|
insert into add_sb(c7) values(-999999999.9);
|
|
insert into add_sb(c7) values(-9999999999.9);
|
|
insert into add_sb(c7) values(-999999999);
|
|
insert into add_sb(c7) values(-9.99999999999);
|
|
insert into add_sb(c7) values(20120101123456.99999);
|
|
insert into add_sb(c7) values(99990101123456);
|
|
insert into add_sb(c7) values(20120101163456);
|
|
insert into add_sb(c7) values(1.1234567);
|
|
insert into add_sb(c7) values(1.0);
|
|
insert into add_sb(c7) values(1.0000000);
|
|
insert into add_sb(c7) values(-9.999999999999999);
|
|
insert into add_sb(c8) values(NULL);
|
|
insert into add_sb(c8) values(1.123456);
|
|
insert into add_sb(c8) values(1234567);
|
|
insert into add_sb(c8) values(123.45);
|
|
insert into add_sb(c8) values(20120101123456);
|
|
insert into add_sb(c8) values(99990101123456);
|
|
insert into add_sb(c8) values(20120101163456);
|
|
insert into add_sb(c8) values(1.1234567);
|
|
insert into add_sb(c8) values(1.00000);
|
|
insert into add_sb(c8) values(1.0000000);
|
|
insert into add_sb(c9) values(NULL);
|
|
insert into add_sb(c9) values("0");
|
|
insert into add_sb(c9) values("-123");
|
|
insert into add_sb(c9) values("a");
|
|
insert into add_sb(c9) values("A");
|
|
insert into add_sb(c9) values("helloworld");
|
|
insert into add_sb(c9) values("");
|
|
insert into add_sb(c9) values(" ");
|
|
insert into add_sb(c9) values("我爱你C++Soupen");
|
|
insert into add_sb(c9) values("20120101123456");
|
|
insert into add_sb(c9) values("99990101123456");
|
|
insert into add_sb(c9) values("20120101163456");
|
|
insert into add_sb(c9) values("111111111111111111111111111111");
|
|
insert into add_sb(c9) values("%y%m%d");
|
|
insert into add_sb(c9) values("%y%m%d HH:MM:SS");
|
|
insert into add_sb(c9) values("192.168.1.1");
|
|
insert into add_sb(c10) values(NULL);
|
|
insert into add_sb(c10) values(20100101);
|
|
insert into add_sb(c10) values(99991301);
|
|
insert into add_sb(c11) values(NULL);
|
|
insert into add_sb(c11) values(20100101123456);
|
|
insert into add_sb(c11) values(20100101123456.789);
|
|
insert into add_sb(c11) values(20100101123456.99999);
|
|
insert into add_sb(c11) values(20101231235959.99999);
|
|
insert into add_sb(c11) values(20100101000000.99999);
|
|
insert into add_sb(c11) values(99991301123466);
|
|
insert into add_sb(c11) values("9999-12-31 23:59:59.9999997");
|
|
insert into add_sb(c12) values(NULL);
|
|
insert into add_sb(c12) values(20100101123456);
|
|
insert into add_sb(c12) values(20100101000000.99999);
|
|
insert into add_sb(c12) values(20100101123456.99999);
|
|
insert into add_sb(c12) values(20101231235959.99999);
|
|
insert into add_sb(c12) values("9999-12-31 23:59:59.9999997");
|
|
insert into add_sb(c13) values(NULL);
|
|
insert into add_sb(c13) values(2012);
|
|
insert into add_sb(c13) values(0000);
|
|
insert into add_sb(c13) values(9999);
|
|
insert into add_sb(c13) values(1234567);
|
|
insert into add_sb(c14) values(NULL);
|
|
insert into add_sb(c14) values("a");
|
|
insert into add_sb(c14) values("A");
|
|
insert into add_sb(c14) values("helloworld");
|
|
insert into add_sb(c14) values("我爱你C++Soupen");
|
|
insert into add_sb(c15) values(NULL);
|
|
insert into add_sb(c15) values("a");
|
|
insert into add_sb(c15) values("A");
|
|
insert into add_sb(c15) values("helloworld");
|
|
insert into add_sb(c15) values("我爱你C++Soupen");
|
|
insert into add_sb(c16) values(NULL);
|
|
insert into add_sb(c16) values("a");
|
|
insert into add_sb(c16) values("A");
|
|
insert into add_sb(c16) values("helloworld");
|
|
insert into add_sb(c16) values("我爱你C++Soupen");
|
|
select (c1 + c1) from add_sb;
|
|
select (c1 + c2) from add_sb;
|
|
select (c1 + c3) from add_sb;
|
|
select (c1 + c4) from add_sb;
|
|
select (c1 + c5) from add_sb;
|
|
select (c1 + c6) from add_sb;
|
|
select (c1 + c7) from add_sb;
|
|
select (c1 + c8) from add_sb;
|
|
select (c1 + c9) from add_sb;
|
|
select (c1 + c10) from add_sb;
|
|
select (c1 + c11) from add_sb;
|
|
select (c1 + c12) from add_sb;
|
|
select (c1 + c13) from add_sb;
|
|
select (c1 + c14) from add_sb;
|
|
select (c1 + c15) from add_sb;
|
|
select (c1 + c16) from add_sb;
|
|
select (c1 + NULL) from add_sb;
|
|
select (c1 + 0) from add_sb;
|
|
select (c1 + 1) from add_sb;
|
|
select (c1 + -1) from add_sb;
|
|
select (c1 + 1.0) from add_sb;
|
|
select (c1 + -1.0) from add_sb;
|
|
select (c1 + 0.0) from add_sb;
|
|
select (c1 + 1.1111) from add_sb;
|
|
select (c1 + 1111111111111) from add_sb;
|
|
select (c1 + 111.0) from add_sb;
|
|
select (c1 + 123) from add_sb;
|
|
select (c1 + 20120101123456) from add_sb;
|
|
select (c1 + "20120101123456") from add_sb;
|
|
select (c1 + "helloworld") from add_sb;
|
|
select (c1 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c1 + "abc") from add_sb;
|
|
select (c1 + "爱拼才会赢") from add_sb;
|
|
select (c1 + "A") from add_sb;
|
|
select (c1 + "a") from add_sb;
|
|
select (c1 + "%y%m%d") from add_sb;
|
|
--error 1690
|
|
select (c1 + -9223372036854775808) from add_sb;
|
|
--error 1690
|
|
select (c1 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (c1 + 18446744073709551615) from add_sb;
|
|
select (c2 + c1) from add_sb;
|
|
select (c2 + c2) from add_sb;
|
|
select (c2 + c3) from add_sb;
|
|
select (c2 + c4) from add_sb;
|
|
select (c2 + c5) from add_sb;
|
|
select (c2 + c6) from add_sb;
|
|
select (c2 + c7) from add_sb;
|
|
select (c2 + c8) from add_sb;
|
|
select (c2 + c9) from add_sb;
|
|
select (c2 + c10) from add_sb;
|
|
select (c2 + c11) from add_sb;
|
|
select (c2 + c12) from add_sb;
|
|
select (c2 + c13) from add_sb;
|
|
select (c2 + c14) from add_sb;
|
|
select (c2 + c15) from add_sb;
|
|
select (c2 + c16) from add_sb;
|
|
select (c2 + NULL) from add_sb;
|
|
select (c2 + 0) from add_sb;
|
|
select (c2 + 1) from add_sb;
|
|
--error 1690
|
|
select (c2 + -1) from add_sb;
|
|
select (c2 + 1.0) from add_sb;
|
|
select (c2 + -1.0) from add_sb;
|
|
select (c2 + 0.0) from add_sb;
|
|
select (c2 + 1.1111) from add_sb;
|
|
select (c2 + 1111111111111) from add_sb;
|
|
select (c2 + 111.0) from add_sb;
|
|
select (c2 + 123) from add_sb;
|
|
select (c2 + 20120101123456) from add_sb;
|
|
select (c2 + "20120101123456") from add_sb;
|
|
select (c2 + "helloworld") from add_sb;
|
|
select (c2 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c2 + "abc") from add_sb;
|
|
select (c2 + "爱拼才会赢") from add_sb;
|
|
select (c2 + "A") from add_sb;
|
|
select (c2 + "a") from add_sb;
|
|
select (c2 + "%y%m%d") from add_sb;
|
|
--error 1690
|
|
select (c2 + -9223372036854775808) from add_sb;
|
|
select (c2 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (c2 + 18446744073709551615) from add_sb;
|
|
select (c3 + c1) from add_sb;
|
|
select (c3 + c2) from add_sb;
|
|
--error 1690
|
|
select (c3 + c3) from add_sb;
|
|
select (c3 + c4) from add_sb;
|
|
select (c3 + c5) from add_sb;
|
|
select (c3 + c6) from add_sb;
|
|
select (c3 + c7) from add_sb;
|
|
select (c3 + c8) from add_sb;
|
|
select (c3 + c9) from add_sb;
|
|
select (c3 + c10) from add_sb;
|
|
select (c3 + c11) from add_sb;
|
|
select (c3 + c12) from add_sb;
|
|
select (c3 + c13) from add_sb;
|
|
select (c3 + c14) from add_sb;
|
|
select (c3 + c15) from add_sb;
|
|
select (c3 + c16) from add_sb;
|
|
select (c3 + NULL) from add_sb;
|
|
select (c3 + 0) from add_sb;
|
|
--error 1690
|
|
select (c3 + 1) from add_sb;
|
|
--error 1690
|
|
select (c3 + -1) from add_sb;
|
|
select (c3 + 1.0) from add_sb;
|
|
select (c3 + -1.0) from add_sb;
|
|
select (c3 + 0.0) from add_sb;
|
|
select (c3 + 1.1111) from add_sb;
|
|
--error 1690
|
|
select (c3 + 1111111111111) from add_sb;
|
|
select (c3 + 111.0) from add_sb;
|
|
--error 1690
|
|
select (c3 + 123) from add_sb;
|
|
--error 1690
|
|
select (c3 + 20120101123456) from add_sb;
|
|
select (c3 + "20120101123456") from add_sb;
|
|
select (c3 + "helloworld") from add_sb;
|
|
select (c3 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c3 + "abc") from add_sb;
|
|
select (c3 + "爱拼才会赢") from add_sb;
|
|
select (c3 + "A") from add_sb;
|
|
select (c3 + "a") from add_sb;
|
|
select (c3 + "%y%m%d") from add_sb;
|
|
--error 1690
|
|
select (c3 + -9223372036854775808) from add_sb;
|
|
--error 1690
|
|
select (c3 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (c3 + 18446744073709551615) from add_sb;
|
|
select (c4 + c1) from add_sb;
|
|
select (c4 + c2) from add_sb;
|
|
select (c4 + c3) from add_sb;
|
|
--error 1690
|
|
select (c4 + c4) from add_sb;
|
|
select (c4 + c5) from add_sb;
|
|
select (c4 + c6) from add_sb;
|
|
select (c4 + c7) from add_sb;
|
|
select (c4 + c8) from add_sb;
|
|
select (c4 + c9) from add_sb;
|
|
select (c4 + c10) from add_sb;
|
|
select (c4 + c11) from add_sb;
|
|
select (c4 + c12) from add_sb;
|
|
select (c4 + c13) from add_sb;
|
|
select (c4 + c14) from add_sb;
|
|
select (c4 + c15) from add_sb;
|
|
select (c4 + c16) from add_sb;
|
|
select (c4 + NULL) from add_sb;
|
|
select (c4 + 0) from add_sb;
|
|
--error 1690
|
|
select (c4 + 1) from add_sb;
|
|
--error 1690
|
|
select (c4 + -1) from add_sb;
|
|
select (c4 + 1.0) from add_sb;
|
|
select (c4 + -1.0) from add_sb;
|
|
select (c4 + 0.0) from add_sb;
|
|
select (c4 + 1.1111) from add_sb;
|
|
--error 1690
|
|
select (c4 + 1111111111111) from add_sb;
|
|
select (c4 + 111.0) from add_sb;
|
|
--error 1690
|
|
select (c4 + 123) from add_sb;
|
|
--error 1690
|
|
select (c4 + 20120101123456) from add_sb;
|
|
select (c4 + "20120101123456") from add_sb;
|
|
select (c4 + "helloworld") from add_sb;
|
|
select (c4 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c4 + "abc") from add_sb;
|
|
select (c4 + "爱拼才会赢") from add_sb;
|
|
select (c4 + "A") from add_sb;
|
|
select (c4 + "a") from add_sb;
|
|
select (c4 + "%y%m%d") from add_sb;
|
|
--error 1690
|
|
select (c4 + -9223372036854775808) from add_sb;
|
|
--error 1690
|
|
select (c4 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (c4 + 18446744073709551615) from add_sb;
|
|
select (c5 + c1) from add_sb;
|
|
select (c5 + c2) from add_sb;
|
|
select (c5 + c3) from add_sb;
|
|
select (c5 + c4) from add_sb;
|
|
select (c5 + c5) from add_sb;
|
|
select (c5 + c6) from add_sb;
|
|
select (c5 + c7) from add_sb;
|
|
select (c5 + c8) from add_sb;
|
|
select (c5 + c9) from add_sb;
|
|
select (c5 + c10) from add_sb;
|
|
select (c5 + c11) from add_sb;
|
|
select (c5 + c12) from add_sb;
|
|
select (c5 + c13) from add_sb;
|
|
select (c5 + c14) from add_sb;
|
|
select (c5 + c15) from add_sb;
|
|
select (c5 + c16) from add_sb;
|
|
select (c5 + NULL) from add_sb;
|
|
select (c5 + 0) from add_sb;
|
|
select (c5 + 1) from add_sb;
|
|
--error 1690
|
|
select (c5 + -1) from add_sb;
|
|
select (c5 + 1.0) from add_sb;
|
|
select (c5 + -1.0) from add_sb;
|
|
select (c5 + 0.0) from add_sb;
|
|
select (c5 + 1.1111) from add_sb;
|
|
select (c5 + 1111111111111) from add_sb;
|
|
select (c5 + 111.0) from add_sb;
|
|
select (c5 + 123) from add_sb;
|
|
select (c5 + 20120101123456) from add_sb;
|
|
select (c5 + "20120101123456") from add_sb;
|
|
select (c5 + "helloworld") from add_sb;
|
|
select (c5 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c5 + "abc") from add_sb;
|
|
select (c5 + "爱拼才会赢") from add_sb;
|
|
select (c5 + "A") from add_sb;
|
|
select (c5 + "a") from add_sb;
|
|
select (c5 + "%y%m%d") from add_sb;
|
|
--error 1690
|
|
select (c5 + -9223372036854775808) from add_sb;
|
|
select (c5 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (c5 + 18446744073709551615) from add_sb;
|
|
select (c6 + c1) from add_sb;
|
|
select (c6 + c2) from add_sb;
|
|
select (c6 + c3) from add_sb;
|
|
select (c6 + c4) from add_sb;
|
|
select (c6 + c5) from add_sb;
|
|
select (c6 + c6) from add_sb;
|
|
select (c6 + c7) from add_sb;
|
|
select (c6 + c8) from add_sb;
|
|
select (c6 + c9) from add_sb;
|
|
select (c6 + c10) from add_sb;
|
|
select (c6 + c11) from add_sb;
|
|
select (c6 + c12) from add_sb;
|
|
select (c6 + c13) from add_sb;
|
|
select (c6 + c14) from add_sb;
|
|
select (c6 + c15) from add_sb;
|
|
select (c6 + c16) from add_sb;
|
|
select (c6 + NULL) from add_sb;
|
|
select (c6 + 0) from add_sb;
|
|
select (c6 + 1) from add_sb;
|
|
select (c6 + -1) from add_sb;
|
|
select (c6 + 1.0) from add_sb;
|
|
select (c6 + -1.0) from add_sb;
|
|
select (c6 + 0.0) from add_sb;
|
|
select (c6 + 1.1111) from add_sb;
|
|
select (c6 + 1111111111111) from add_sb;
|
|
select (c6 + 111.0) from add_sb;
|
|
select (c6 + 123) from add_sb;
|
|
select (c6 + 20120101123456) from add_sb;
|
|
select (c6 + "20120101123456") from add_sb;
|
|
select (c6 + "helloworld") from add_sb;
|
|
select (c6 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c6 + "abc") from add_sb;
|
|
select (c6 + "爱拼才会赢") from add_sb;
|
|
select (c6 + "A") from add_sb;
|
|
select (c6 + "a") from add_sb;
|
|
select (c6 + "%y%m%d") from add_sb;
|
|
select (c6 + -9223372036854775808) from add_sb;
|
|
select (c6 + 9223372036854775807) from add_sb;
|
|
select (c6 + 18446744073709551615) from add_sb;
|
|
select (c7 + c1) from add_sb;
|
|
select (c7 + c2) from add_sb;
|
|
select (c7 + c3) from add_sb;
|
|
select (c7 + c4) from add_sb;
|
|
select (c7 + c5) from add_sb;
|
|
select (c7 + c6) from add_sb;
|
|
select (c7 + c7) from add_sb;
|
|
select (c7 + c8) from add_sb;
|
|
select (c7 + c9) from add_sb;
|
|
select (c7 + c10) from add_sb;
|
|
select (c7 + c11) from add_sb;
|
|
select (c7 + c12) from add_sb;
|
|
select (c7 + c13) from add_sb;
|
|
select (c7 + c14) from add_sb;
|
|
select (c7 + c15) from add_sb;
|
|
select (c7 + c16) from add_sb;
|
|
select (c7 + NULL) from add_sb;
|
|
select (c7 + 0) from add_sb;
|
|
select (c7 + 1) from add_sb;
|
|
select (c7 + -1) from add_sb;
|
|
select (c7 + 1.0) from add_sb;
|
|
select (c7 + -1.0) from add_sb;
|
|
select (c7 + 0.0) from add_sb;
|
|
select (c7 + 1.1111) from add_sb;
|
|
select (c7 + 1111111111111) from add_sb;
|
|
select (c7 + 111.0) from add_sb;
|
|
select (c7 + 123) from add_sb;
|
|
select (c7 + 20120101123456) from add_sb;
|
|
select (c7 + "20120101123456") from add_sb;
|
|
select (c7 + "helloworld") from add_sb;
|
|
select (c7 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c7 + "abc") from add_sb;
|
|
select (c7 + "爱拼才会赢") from add_sb;
|
|
select (c7 + "A") from add_sb;
|
|
select (c7 + "a") from add_sb;
|
|
select (c7 + "%y%m%d") from add_sb;
|
|
select (c7 + -9223372036854775808) from add_sb;
|
|
select (c7 + 9223372036854775807) from add_sb;
|
|
select (c7 + 18446744073709551615) from add_sb;
|
|
select (c8 + c1) from add_sb;
|
|
select (c8 + c2) from add_sb;
|
|
select (c8 + c3) from add_sb;
|
|
select (c8 + c4) from add_sb;
|
|
select (c8 + c5) from add_sb;
|
|
select (c8 + c6) from add_sb;
|
|
select (c8 + c7) from add_sb;
|
|
select (c8 + c8) from add_sb;
|
|
select (c8 + c9) from add_sb;
|
|
select (c8 + c10) from add_sb;
|
|
select (c8 + c11) from add_sb;
|
|
select (c8 + c12) from add_sb;
|
|
select (c8 + c13) from add_sb;
|
|
select (c8 + c14) from add_sb;
|
|
select (c8 + c15) from add_sb;
|
|
select (c8 + c16) from add_sb;
|
|
select (c8 + NULL) from add_sb;
|
|
select (c8 + 0) from add_sb;
|
|
select (c8 + 1) from add_sb;
|
|
select (c8 + -1) from add_sb;
|
|
select (c8 + 1.0) from add_sb;
|
|
select (c8 + -1.0) from add_sb;
|
|
select (c8 + 0.0) from add_sb;
|
|
select (c8 + 1.1111) from add_sb;
|
|
select (c8 + 1111111111111) from add_sb;
|
|
select (c8 + 111.0) from add_sb;
|
|
select (c8 + 123) from add_sb;
|
|
select (c8 + 20120101123456) from add_sb;
|
|
select (c8 + "20120101123456") from add_sb;
|
|
select (c8 + "helloworld") from add_sb;
|
|
select (c8 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c8 + "abc") from add_sb;
|
|
select (c8 + "爱拼才会赢") from add_sb;
|
|
select (c8 + "A") from add_sb;
|
|
select (c8 + "a") from add_sb;
|
|
select (c8 + "%y%m%d") from add_sb;
|
|
select (c8 + -9223372036854775808) from add_sb;
|
|
select (c8 + 9223372036854775807) from add_sb;
|
|
select (c8 + 18446744073709551615) from add_sb;
|
|
select (c9 + c1) from add_sb;
|
|
select (c9 + c2) from add_sb;
|
|
select (c9 + c3) from add_sb;
|
|
select (c9 + c4) from add_sb;
|
|
select (c9 + c5) from add_sb;
|
|
select (c9 + c6) from add_sb;
|
|
select (c9 + c7) from add_sb;
|
|
select (c9 + c8) from add_sb;
|
|
select (c9 + c9) from add_sb;
|
|
select (c9 + c10) from add_sb;
|
|
select (c9 + c11) from add_sb;
|
|
select (c9 + c12) from add_sb;
|
|
select (c9 + c13) from add_sb;
|
|
select (c9 + c14) from add_sb;
|
|
select (c9 + c15) from add_sb;
|
|
select (c9 + c16) from add_sb;
|
|
select (c9 + NULL) from add_sb;
|
|
select (c9 + 0) from add_sb;
|
|
select (c9 + 1) from add_sb;
|
|
select (c9 + -1) from add_sb;
|
|
select (c9 + 1.0) from add_sb;
|
|
select (c9 + -1.0) from add_sb;
|
|
select (c9 + 0.0) from add_sb;
|
|
select (c9 + 1.1111) from add_sb;
|
|
select (c9 + 1111111111111) from add_sb;
|
|
select (c9 + 111.0) from add_sb;
|
|
select (c9 + 123) from add_sb;
|
|
select (c9 + 20120101123456) from add_sb;
|
|
select (c9 + "20120101123456") from add_sb;
|
|
select (c9 + "helloworld") from add_sb;
|
|
select (c9 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c9 + "abc") from add_sb;
|
|
select (c9 + "爱拼才会赢") from add_sb;
|
|
select (c9 + "A") from add_sb;
|
|
select (c9 + "a") from add_sb;
|
|
select (c9 + "%y%m%d") from add_sb;
|
|
select (c9 + -9223372036854775808) from add_sb;
|
|
select (c9 + 9223372036854775807) from add_sb;
|
|
select (c9 + 18446744073709551615) from add_sb;
|
|
select (c10 + c1) from add_sb;
|
|
select (c10 + c2) from add_sb;
|
|
select (c10 + c3) from add_sb;
|
|
select (c10 + c4) from add_sb;
|
|
select (c10 + c5) from add_sb;
|
|
select (c10 + c6) from add_sb;
|
|
select (c10 + c7) from add_sb;
|
|
select (c10 + c8) from add_sb;
|
|
select (c10 + c9) from add_sb;
|
|
select (c10 + c10) from add_sb;
|
|
select (c10 + c11) from add_sb;
|
|
select (c10 + c12) from add_sb;
|
|
select (c10 + c13) from add_sb;
|
|
select (c10 + c14) from add_sb;
|
|
select (c10 + c15) from add_sb;
|
|
select (c10 + c16) from add_sb;
|
|
select (c10 + NULL) from add_sb;
|
|
select (c10 + 0) from add_sb;
|
|
select (c10 + 1) from add_sb;
|
|
select (c10 + -1) from add_sb;
|
|
select (c10 + 1.0) from add_sb;
|
|
select (c10 + -1.0) from add_sb;
|
|
select (c10 + 0.0) from add_sb;
|
|
select (c10 + 1.1111) from add_sb;
|
|
select (c10 + 1111111111111) from add_sb;
|
|
select (c10 + 111.0) from add_sb;
|
|
select (c10 + 123) from add_sb;
|
|
select (c10 + 20120101123456) from add_sb;
|
|
select (c10 + "20120101123456") from add_sb;
|
|
select (c10 + "helloworld") from add_sb;
|
|
select (c10 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c10 + "abc") from add_sb;
|
|
select (c10 + "爱拼才会赢") from add_sb;
|
|
select (c10 + "A") from add_sb;
|
|
select (c10 + "a") from add_sb;
|
|
select (c10 + "%y%m%d") from add_sb;
|
|
select (c10 + -9223372036854775808) from add_sb;
|
|
--error 1690
|
|
select (c10 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (c10 + 18446744073709551615) from add_sb;
|
|
select (c11 + c1) from add_sb;
|
|
select (c11 + c2) from add_sb;
|
|
select (c11 + c3) from add_sb;
|
|
select (c11 + c4) from add_sb;
|
|
select (c11 + c5) from add_sb;
|
|
select (c11 + c6) from add_sb;
|
|
select (c11 + c7) from add_sb;
|
|
select (c11 + c8) from add_sb;
|
|
select (c11 + c9) from add_sb;
|
|
select (c11 + c10) from add_sb;
|
|
select (c11 + c11) from add_sb;
|
|
select (c11 + c12) from add_sb;
|
|
select (c11 + c13) from add_sb;
|
|
select (c11 + c14) from add_sb;
|
|
select (c11 + c15) from add_sb;
|
|
select (c11 + c16) from add_sb;
|
|
select (c11 + NULL) from add_sb;
|
|
select (c11 + 0) from add_sb;
|
|
select (c11 + 1) from add_sb;
|
|
select (c11 + -1) from add_sb;
|
|
select (c11 + 1.0) from add_sb;
|
|
select (c11 + -1.0) from add_sb;
|
|
select (c11 + 0.0) from add_sb;
|
|
select (c11 + 1.1111) from add_sb;
|
|
select (c11 + 1111111111111) from add_sb;
|
|
select (c11 + 111.0) from add_sb;
|
|
select (c11 + 123) from add_sb;
|
|
select (c11 + 20120101123456) from add_sb;
|
|
select (c11 + "20120101123456") from add_sb;
|
|
select (c11 + "helloworld") from add_sb;
|
|
select (c11 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c11 + "abc") from add_sb;
|
|
select (c11 + "爱拼才会赢") from add_sb;
|
|
select (c11 + "A") from add_sb;
|
|
select (c11 + "a") from add_sb;
|
|
select (c11 + "%y%m%d") from add_sb;
|
|
select (c11 + -9223372036854775808) from add_sb;
|
|
select (c11 + 9223372036854775807) from add_sb;
|
|
select (c11 + 18446744073709551615) from add_sb;
|
|
select (c12 + c1) from add_sb;
|
|
select (c12 + c2) from add_sb;
|
|
select (c12 + c3) from add_sb;
|
|
select (c12 + c4) from add_sb;
|
|
select (c12 + c5) from add_sb;
|
|
select (c12 + c6) from add_sb;
|
|
select (c12 + c7) from add_sb;
|
|
select (c12 + c8) from add_sb;
|
|
select (c12 + c9) from add_sb;
|
|
select (c12 + c10) from add_sb;
|
|
select (c12 + c11) from add_sb;
|
|
select (c12 + c12) from add_sb;
|
|
select (c12 + c13) from add_sb;
|
|
select (c12 + c14) from add_sb;
|
|
select (c12 + c15) from add_sb;
|
|
select (c12 + c16) from add_sb;
|
|
select (c12 + NULL) from add_sb;
|
|
select (c12 + 0) from add_sb;
|
|
select (c12 + 1) from add_sb;
|
|
select (c12 + -1) from add_sb;
|
|
select (c12 + 1.0) from add_sb;
|
|
select (c12 + -1.0) from add_sb;
|
|
select (c12 + 0.0) from add_sb;
|
|
select (c12 + 1.1111) from add_sb;
|
|
select (c12 + 1111111111111) from add_sb;
|
|
select (c12 + 111.0) from add_sb;
|
|
select (c12 + 123) from add_sb;
|
|
select (c12 + 20120101123456) from add_sb;
|
|
select (c12 + "20120101123456") from add_sb;
|
|
select (c12 + "helloworld") from add_sb;
|
|
select (c12 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c12 + "abc") from add_sb;
|
|
select (c12 + "爱拼才会赢") from add_sb;
|
|
select (c12 + "A") from add_sb;
|
|
select (c12 + "a") from add_sb;
|
|
select (c12 + "%y%m%d") from add_sb;
|
|
select (c12 + -9223372036854775808) from add_sb;
|
|
select (c12 + 9223372036854775807) from add_sb;
|
|
select (c12 + 18446744073709551615) from add_sb;
|
|
select (c13 + c1) from add_sb;
|
|
select (c13 + c2) from add_sb;
|
|
select (c13 + c3) from add_sb;
|
|
select (c13 + c4) from add_sb;
|
|
select (c13 + c5) from add_sb;
|
|
select (c13 + c6) from add_sb;
|
|
select (c13 + c7) from add_sb;
|
|
select (c13 + c8) from add_sb;
|
|
select (c13 + c9) from add_sb;
|
|
select (c13 + c10) from add_sb;
|
|
select (c13 + c11) from add_sb;
|
|
select (c13 + c12) from add_sb;
|
|
select (c13 + c13) from add_sb;
|
|
select (c13 + c14) from add_sb;
|
|
select (c13 + c15) from add_sb;
|
|
select (c13 + c16) from add_sb;
|
|
select (c13 + NULL) from add_sb;
|
|
select (c13 + 0) from add_sb;
|
|
select (c13 + 1) from add_sb;
|
|
--error 1690
|
|
select (c13 + -1) from add_sb;
|
|
select (c13 + 1.0) from add_sb;
|
|
select (c13 + -1.0) from add_sb;
|
|
select (c13 + 0.0) from add_sb;
|
|
select (c13 + 1.1111) from add_sb;
|
|
select (c13 + 1111111111111) from add_sb;
|
|
select (c13 + 111.0) from add_sb;
|
|
select (c13 + 123) from add_sb;
|
|
select (c13 + 20120101123456) from add_sb;
|
|
select (c13 + "20120101123456") from add_sb;
|
|
select (c13 + "helloworld") from add_sb;
|
|
select (c13 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c13 + "abc") from add_sb;
|
|
select (c13 + "爱拼才会赢") from add_sb;
|
|
select (c13 + "A") from add_sb;
|
|
select (c13 + "a") from add_sb;
|
|
select (c13 + "%y%m%d") from add_sb;
|
|
--error 1690
|
|
select (c13 + -9223372036854775808) from add_sb;
|
|
select (c13 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (c13 + 18446744073709551615) from add_sb;
|
|
select (c14 + c1) from add_sb;
|
|
select (c14 + c2) from add_sb;
|
|
select (c14 + c3) from add_sb;
|
|
select (c14 + c4) from add_sb;
|
|
select (c14 + c5) from add_sb;
|
|
select (c14 + c6) from add_sb;
|
|
select (c14 + c7) from add_sb;
|
|
select (c14 + c8) from add_sb;
|
|
select (c14 + c9) from add_sb;
|
|
select (c14 + c10) from add_sb;
|
|
select (c14 + c11) from add_sb;
|
|
select (c14 + c12) from add_sb;
|
|
select (c14 + c13) from add_sb;
|
|
select (c14 + c14) from add_sb;
|
|
select (c14 + c15) from add_sb;
|
|
select (c14 + c16) from add_sb;
|
|
select (c14 + NULL) from add_sb;
|
|
select (c14 + 0) from add_sb;
|
|
select (c14 + 1) from add_sb;
|
|
select (c14 + -1) from add_sb;
|
|
select (c14 + 1.0) from add_sb;
|
|
select (c14 + -1.0) from add_sb;
|
|
select (c14 + 0.0) from add_sb;
|
|
select (c14 + 1.1111) from add_sb;
|
|
select (c14 + 1111111111111) from add_sb;
|
|
select (c14 + 111.0) from add_sb;
|
|
select (c14 + 123) from add_sb;
|
|
select (c14 + 20120101123456) from add_sb;
|
|
select (c14 + "20120101123456") from add_sb;
|
|
select (c14 + "helloworld") from add_sb;
|
|
select (c14 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c14 + "abc") from add_sb;
|
|
select (c14 + "爱拼才会赢") from add_sb;
|
|
select (c14 + "A") from add_sb;
|
|
select (c14 + "a") from add_sb;
|
|
select (c14 + "%y%m%d") from add_sb;
|
|
select (c14 + -9223372036854775808) from add_sb;
|
|
select (c14 + 9223372036854775807) from add_sb;
|
|
select (c14 + 18446744073709551615) from add_sb;
|
|
select (c15 + c1) from add_sb;
|
|
select (c15 + c2) from add_sb;
|
|
select (c15 + c3) from add_sb;
|
|
select (c15 + c4) from add_sb;
|
|
select (c15 + c5) from add_sb;
|
|
select (c15 + c6) from add_sb;
|
|
select (c15 + c7) from add_sb;
|
|
select (c15 + c8) from add_sb;
|
|
select (c15 + c9) from add_sb;
|
|
select (c15 + c10) from add_sb;
|
|
select (c15 + c11) from add_sb;
|
|
select (c15 + c12) from add_sb;
|
|
select (c15 + c13) from add_sb;
|
|
select (c15 + c14) from add_sb;
|
|
select (c15 + c15) from add_sb;
|
|
select (c15 + c16) from add_sb;
|
|
select (c15 + NULL) from add_sb;
|
|
select (c15 + 0) from add_sb;
|
|
select (c15 + 1) from add_sb;
|
|
select (c15 + -1) from add_sb;
|
|
select (c15 + 1.0) from add_sb;
|
|
select (c15 + -1.0) from add_sb;
|
|
select (c15 + 0.0) from add_sb;
|
|
select (c15 + 1.1111) from add_sb;
|
|
select (c15 + 1111111111111) from add_sb;
|
|
select (c15 + 111.0) from add_sb;
|
|
select (c15 + 123) from add_sb;
|
|
select (c15 + 20120101123456) from add_sb;
|
|
select (c15 + "20120101123456") from add_sb;
|
|
select (c15 + "helloworld") from add_sb;
|
|
select (c15 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c15 + "abc") from add_sb;
|
|
select (c15 + "爱拼才会赢") from add_sb;
|
|
select (c15 + "A") from add_sb;
|
|
select (c15 + "a") from add_sb;
|
|
select (c15 + "%y%m%d") from add_sb;
|
|
select (c15 + -9223372036854775808) from add_sb;
|
|
select (c15 + 9223372036854775807) from add_sb;
|
|
select (c15 + 18446744073709551615) from add_sb;
|
|
select (c16 + c1) from add_sb;
|
|
select (c16 + c2) from add_sb;
|
|
select (c16 + c3) from add_sb;
|
|
select (c16 + c4) from add_sb;
|
|
select (c16 + c5) from add_sb;
|
|
select (c16 + c6) from add_sb;
|
|
select (c16 + c7) from add_sb;
|
|
select (c16 + c8) from add_sb;
|
|
select (c16 + c9) from add_sb;
|
|
select (c16 + c10) from add_sb;
|
|
select (c16 + c11) from add_sb;
|
|
select (c16 + c12) from add_sb;
|
|
select (c16 + c13) from add_sb;
|
|
select (c16 + c14) from add_sb;
|
|
select (c16 + c15) from add_sb;
|
|
select (c16 + c16) from add_sb;
|
|
select (c16 + NULL) from add_sb;
|
|
select (c16 + 0) from add_sb;
|
|
select (c16 + 1) from add_sb;
|
|
select (c16 + -1) from add_sb;
|
|
select (c16 + 1.0) from add_sb;
|
|
select (c16 + -1.0) from add_sb;
|
|
select (c16 + 0.0) from add_sb;
|
|
select (c16 + 1.1111) from add_sb;
|
|
select (c16 + 1111111111111) from add_sb;
|
|
select (c16 + 111.0) from add_sb;
|
|
select (c16 + 123) from add_sb;
|
|
select (c16 + 20120101123456) from add_sb;
|
|
select (c16 + "20120101123456") from add_sb;
|
|
select (c16 + "helloworld") from add_sb;
|
|
select (c16 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (c16 + "abc") from add_sb;
|
|
select (c16 + "爱拼才会赢") from add_sb;
|
|
select (c16 + "A") from add_sb;
|
|
select (c16 + "a") from add_sb;
|
|
select (c16 + "%y%m%d") from add_sb;
|
|
select (c16 + -9223372036854775808) from add_sb;
|
|
select (c16 + 9223372036854775807) from add_sb;
|
|
select (c16 + 18446744073709551615) from add_sb;
|
|
select (NULL + c1) from add_sb;
|
|
select (NULL + c2) from add_sb;
|
|
select (NULL + c3) from add_sb;
|
|
select (NULL + c4) from add_sb;
|
|
select (NULL + c5) from add_sb;
|
|
select (NULL + c6) from add_sb;
|
|
select (NULL + c7) from add_sb;
|
|
select (NULL + c8) from add_sb;
|
|
select (NULL + c9) from add_sb;
|
|
select (NULL + c10) from add_sb;
|
|
select (NULL + c11) from add_sb;
|
|
select (NULL + c12) from add_sb;
|
|
select (NULL + c13) from add_sb;
|
|
select (NULL + c14) from add_sb;
|
|
select (NULL + c15) from add_sb;
|
|
select (NULL + c16) from add_sb;
|
|
select (NULL + NULL) from add_sb;
|
|
select (NULL + 0) from add_sb;
|
|
select (NULL + 1) from add_sb;
|
|
select (NULL + -1) from add_sb;
|
|
select (NULL + 1.0) from add_sb;
|
|
select (NULL + -1.0) from add_sb;
|
|
select (NULL + 0.0) from add_sb;
|
|
select (NULL + 1.1111) from add_sb;
|
|
select (NULL + 1111111111111) from add_sb;
|
|
select (NULL + 111.0) from add_sb;
|
|
select (NULL + 123) from add_sb;
|
|
select (NULL + 20120101123456) from add_sb;
|
|
select (NULL + "20120101123456") from add_sb;
|
|
select (NULL + "helloworld") from add_sb;
|
|
select (NULL + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (NULL + "abc") from add_sb;
|
|
select (NULL + "爱拼才会赢") from add_sb;
|
|
select (NULL + "A") from add_sb;
|
|
select (NULL + "a") from add_sb;
|
|
select (NULL + "%y%m%d") from add_sb;
|
|
select (NULL + -9223372036854775808) from add_sb;
|
|
select (NULL + 9223372036854775807) from add_sb;
|
|
select (NULL + 18446744073709551615) from add_sb;
|
|
select (0 + c1) from add_sb;
|
|
select (0 + c2) from add_sb;
|
|
select (0 + c3) from add_sb;
|
|
select (0 + c4) from add_sb;
|
|
select (0 + c5) from add_sb;
|
|
select (0 + c6) from add_sb;
|
|
select (0 + c7) from add_sb;
|
|
select (0 + c8) from add_sb;
|
|
select (0 + c9) from add_sb;
|
|
select (0 + c10) from add_sb;
|
|
select (0 + c11) from add_sb;
|
|
select (0 + c12) from add_sb;
|
|
select (0 + c13) from add_sb;
|
|
select (0 + c14) from add_sb;
|
|
select (0 + c15) from add_sb;
|
|
select (0 + c16) from add_sb;
|
|
select (0 + NULL) from add_sb;
|
|
select (0 + 0) from add_sb;
|
|
select (0 + 1) from add_sb;
|
|
select (0 + -1) from add_sb;
|
|
select (0 + 1.0) from add_sb;
|
|
select (0 + -1.0) from add_sb;
|
|
select (0 + 0.0) from add_sb;
|
|
select (0 + 1.1111) from add_sb;
|
|
select (0 + 1111111111111) from add_sb;
|
|
select (0 + 111.0) from add_sb;
|
|
select (0 + 123) from add_sb;
|
|
select (0 + 20120101123456) from add_sb;
|
|
select (0 + "20120101123456") from add_sb;
|
|
select (0 + "helloworld") from add_sb;
|
|
select (0 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (0 + "abc") from add_sb;
|
|
select (0 + "爱拼才会赢") from add_sb;
|
|
select (0 + "A") from add_sb;
|
|
select (0 + "a") from add_sb;
|
|
select (0 + "%y%m%d") from add_sb;
|
|
select (0 + -9223372036854775808) from add_sb;
|
|
select (0 + 9223372036854775807) from add_sb;
|
|
select (0 + 18446744073709551615) from add_sb;
|
|
select (1 + c1) from add_sb;
|
|
select (1 + c2) from add_sb;
|
|
--error 1690
|
|
select (1 + c3) from add_sb;
|
|
--error 1690
|
|
select (1 + c4) from add_sb;
|
|
select (1 + c5) from add_sb;
|
|
select (1 + c6) from add_sb;
|
|
select (1 + c7) from add_sb;
|
|
select (1 + c8) from add_sb;
|
|
select (1 + c9) from add_sb;
|
|
select (1 + c10) from add_sb;
|
|
select (1 + c11) from add_sb;
|
|
select (1 + c12) from add_sb;
|
|
select (1 + c13) from add_sb;
|
|
select (1 + c14) from add_sb;
|
|
select (1 + c15) from add_sb;
|
|
select (1 + c16) from add_sb;
|
|
select (1 + NULL) from add_sb;
|
|
select (1 + 0) from add_sb;
|
|
select (1 + 1) from add_sb;
|
|
select (1 + -1) from add_sb;
|
|
select (1 + 1.0) from add_sb;
|
|
select (1 + -1.0) from add_sb;
|
|
select (1 + 0.0) from add_sb;
|
|
select (1 + 1.1111) from add_sb;
|
|
select (1 + 1111111111111) from add_sb;
|
|
select (1 + 111.0) from add_sb;
|
|
select (1 + 123) from add_sb;
|
|
select (1 + 20120101123456) from add_sb;
|
|
select (1 + "20120101123456") from add_sb;
|
|
select (1 + "helloworld") from add_sb;
|
|
select (1 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (1 + "abc") from add_sb;
|
|
select (1 + "爱拼才会赢") from add_sb;
|
|
select (1 + "A") from add_sb;
|
|
select (1 + "a") from add_sb;
|
|
select (1 + "%y%m%d") from add_sb;
|
|
select (1 + -9223372036854775808) from add_sb;
|
|
--error 1690
|
|
select (1 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (1 + 18446744073709551615) from add_sb;
|
|
select (-1 + c1) from add_sb;
|
|
--error 1690
|
|
select (-1 + c2) from add_sb;
|
|
--error 1690
|
|
select (-1 + c3) from add_sb;
|
|
--error 1690
|
|
select (-1 + c4) from add_sb;
|
|
--error 1690
|
|
select (-1 + c5) from add_sb;
|
|
select (-1 + c6) from add_sb;
|
|
select (-1 + c7) from add_sb;
|
|
select (-1 + c8) from add_sb;
|
|
select (-1 + c9) from add_sb;
|
|
select (-1 + c10) from add_sb;
|
|
select (-1 + c11) from add_sb;
|
|
select (-1 + c12) from add_sb;
|
|
--error 1690
|
|
select (-1 + c13) from add_sb;
|
|
select (-1 + c14) from add_sb;
|
|
select (-1 + c15) from add_sb;
|
|
select (-1 + c16) from add_sb;
|
|
select (-1 + NULL) from add_sb;
|
|
select (-1 + 0) from add_sb;
|
|
select (-1 + 1) from add_sb;
|
|
select (-1 + -1) from add_sb;
|
|
select (-1 + 1.0) from add_sb;
|
|
select (-1 + -1.0) from add_sb;
|
|
select (-1 + 0.0) from add_sb;
|
|
select (-1 + 1.1111) from add_sb;
|
|
select (-1 + 1111111111111) from add_sb;
|
|
select (-1 + 111.0) from add_sb;
|
|
select (-1 + 123) from add_sb;
|
|
select (-1 + 20120101123456) from add_sb;
|
|
select (-1 + "20120101123456") from add_sb;
|
|
select (-1 + "helloworld") from add_sb;
|
|
select (-1 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (-1 + "abc") from add_sb;
|
|
select (-1 + "爱拼才会赢") from add_sb;
|
|
select (-1 + "A") from add_sb;
|
|
select (-1 + "a") from add_sb;
|
|
select (-1 + "%y%m%d") from add_sb;
|
|
--error 1690
|
|
select (-1 + -9223372036854775808) from add_sb;
|
|
select (-1 + 9223372036854775807) from add_sb;
|
|
select (-1 + 18446744073709551615) from add_sb;
|
|
select (1.0 + c1) from add_sb;
|
|
select (1.0 + c2) from add_sb;
|
|
select (1.0 + c3) from add_sb;
|
|
select (1.0 + c4) from add_sb;
|
|
select (1.0 + c5) from add_sb;
|
|
select (1.0 + c6) from add_sb;
|
|
select (1.0 + c7) from add_sb;
|
|
select (1.0 + c8) from add_sb;
|
|
select (1.0 + c9) from add_sb;
|
|
select (1.0 + c10) from add_sb;
|
|
select (1.0 + c11) from add_sb;
|
|
select (1.0 + c12) from add_sb;
|
|
select (1.0 + c13) from add_sb;
|
|
select (1.0 + c14) from add_sb;
|
|
select (1.0 + c15) from add_sb;
|
|
select (1.0 + c16) from add_sb;
|
|
select (1.0 + NULL) from add_sb;
|
|
select (1.0 + 0) from add_sb;
|
|
select (1.0 + 1) from add_sb;
|
|
select (1.0 + -1) from add_sb;
|
|
select (1.0 + 1.0) from add_sb;
|
|
select (1.0 + -1.0) from add_sb;
|
|
select (1.0 + 0.0) from add_sb;
|
|
select (1.0 + 1.1111) from add_sb;
|
|
select (1.0 + 1111111111111) from add_sb;
|
|
select (1.0 + 111.0) from add_sb;
|
|
select (1.0 + 123) from add_sb;
|
|
select (1.0 + 20120101123456) from add_sb;
|
|
select (1.0 + "20120101123456") from add_sb;
|
|
select (1.0 + "helloworld") from add_sb;
|
|
select (1.0 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (1.0 + "abc") from add_sb;
|
|
select (1.0 + "爱拼才会赢") from add_sb;
|
|
select (1.0 + "A") from add_sb;
|
|
select (1.0 + "a") from add_sb;
|
|
select (1.0 + "%y%m%d") from add_sb;
|
|
select (1.0 + -9223372036854775808) from add_sb;
|
|
select (1.0 + 9223372036854775807) from add_sb;
|
|
select (1.0 + 18446744073709551615) from add_sb;
|
|
select (-1.0 + c1) from add_sb;
|
|
select (-1.0 + c2) from add_sb;
|
|
select (-1.0 + c3) from add_sb;
|
|
select (-1.0 + c4) from add_sb;
|
|
select (-1.0 + c5) from add_sb;
|
|
select (-1.0 + c6) from add_sb;
|
|
select (-1.0 + c7) from add_sb;
|
|
select (-1.0 + c8) from add_sb;
|
|
select (-1.0 + c9) from add_sb;
|
|
select (-1.0 + c10) from add_sb;
|
|
select (-1.0 + c11) from add_sb;
|
|
select (-1.0 + c12) from add_sb;
|
|
select (-1.0 + c13) from add_sb;
|
|
select (-1.0 + c14) from add_sb;
|
|
select (-1.0 + c15) from add_sb;
|
|
select (-1.0 + c16) from add_sb;
|
|
select (-1.0 + NULL) from add_sb;
|
|
select (-1.0 + 0) from add_sb;
|
|
select (-1.0 + 1) from add_sb;
|
|
select (-1.0 + -1) from add_sb;
|
|
select (-1.0 + 1.0) from add_sb;
|
|
select (-1.0 + -1.0) from add_sb;
|
|
select (-1.0 + 0.0) from add_sb;
|
|
select (-1.0 + 1.1111) from add_sb;
|
|
select (-1.0 + 1111111111111) from add_sb;
|
|
select (-1.0 + 111.0) from add_sb;
|
|
select (-1.0 + 123) from add_sb;
|
|
select (-1.0 + 20120101123456) from add_sb;
|
|
select (-1.0 + "20120101123456") from add_sb;
|
|
select (-1.0 + "helloworld") from add_sb;
|
|
select (-1.0 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (-1.0 + "abc") from add_sb;
|
|
select (-1.0 + "爱拼才会赢") from add_sb;
|
|
select (-1.0 + "A") from add_sb;
|
|
select (-1.0 + "a") from add_sb;
|
|
select (-1.0 + "%y%m%d") from add_sb;
|
|
select (-1.0 + -9223372036854775808) from add_sb;
|
|
select (-1.0 + 9223372036854775807) from add_sb;
|
|
select (-1.0 + 18446744073709551615) from add_sb;
|
|
select (0.0 + c1) from add_sb;
|
|
select (0.0 + c2) from add_sb;
|
|
select (0.0 + c3) from add_sb;
|
|
select (0.0 + c4) from add_sb;
|
|
select (0.0 + c5) from add_sb;
|
|
select (0.0 + c6) from add_sb;
|
|
select (0.0 + c7) from add_sb;
|
|
select (0.0 + c8) from add_sb;
|
|
select (0.0 + c9) from add_sb;
|
|
select (0.0 + c10) from add_sb;
|
|
select (0.0 + c11) from add_sb;
|
|
select (0.0 + c12) from add_sb;
|
|
select (0.0 + c13) from add_sb;
|
|
select (0.0 + c14) from add_sb;
|
|
select (0.0 + c15) from add_sb;
|
|
select (0.0 + c16) from add_sb;
|
|
select (0.0 + NULL) from add_sb;
|
|
select (0.0 + 0) from add_sb;
|
|
select (0.0 + 1) from add_sb;
|
|
select (0.0 + -1) from add_sb;
|
|
select (0.0 + 1.0) from add_sb;
|
|
select (0.0 + -1.0) from add_sb;
|
|
select (0.0 + 0.0) from add_sb;
|
|
select (0.0 + 1.1111) from add_sb;
|
|
select (0.0 + 1111111111111) from add_sb;
|
|
select (0.0 + 111.0) from add_sb;
|
|
select (0.0 + 123) from add_sb;
|
|
select (0.0 + 20120101123456) from add_sb;
|
|
select (0.0 + "20120101123456") from add_sb;
|
|
select (0.0 + "helloworld") from add_sb;
|
|
select (0.0 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (0.0 + "abc") from add_sb;
|
|
select (0.0 + "爱拼才会赢") from add_sb;
|
|
select (0.0 + "A") from add_sb;
|
|
select (0.0 + "a") from add_sb;
|
|
select (0.0 + "%y%m%d") from add_sb;
|
|
select (0.0 + -9223372036854775808) from add_sb;
|
|
select (0.0 + 9223372036854775807) from add_sb;
|
|
select (0.0 + 18446744073709551615) from add_sb;
|
|
select (1.1111 + c1) from add_sb;
|
|
select (1.1111 + c2) from add_sb;
|
|
select (1.1111 + c3) from add_sb;
|
|
select (1.1111 + c4) from add_sb;
|
|
select (1.1111 + c5) from add_sb;
|
|
select (1.1111 + c6) from add_sb;
|
|
select (1.1111 + c7) from add_sb;
|
|
select (1.1111 + c8) from add_sb;
|
|
select (1.1111 + c9) from add_sb;
|
|
select (1.1111 + c10) from add_sb;
|
|
select (1.1111 + c11) from add_sb;
|
|
select (1.1111 + c12) from add_sb;
|
|
select (1.1111 + c13) from add_sb;
|
|
select (1.1111 + c14) from add_sb;
|
|
select (1.1111 + c15) from add_sb;
|
|
select (1.1111 + c16) from add_sb;
|
|
select (1.1111 + NULL) from add_sb;
|
|
select (1.1111 + 0) from add_sb;
|
|
select (1.1111 + 1) from add_sb;
|
|
select (1.1111 + -1) from add_sb;
|
|
select (1.1111 + 1.0) from add_sb;
|
|
select (1.1111 + -1.0) from add_sb;
|
|
select (1.1111 + 0.0) from add_sb;
|
|
select (1.1111 + 1.1111) from add_sb;
|
|
select (1.1111 + 1111111111111) from add_sb;
|
|
select (1.1111 + 111.0) from add_sb;
|
|
select (1.1111 + 123) from add_sb;
|
|
select (1.1111 + 20120101123456) from add_sb;
|
|
select (1.1111 + "20120101123456") from add_sb;
|
|
select (1.1111 + "helloworld") from add_sb;
|
|
select (1.1111 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (1.1111 + "abc") from add_sb;
|
|
select (1.1111 + "爱拼才会赢") from add_sb;
|
|
select (1.1111 + "A") from add_sb;
|
|
select (1.1111 + "a") from add_sb;
|
|
select (1.1111 + "%y%m%d") from add_sb;
|
|
select (1.1111 + -9223372036854775808) from add_sb;
|
|
select (1.1111 + 9223372036854775807) from add_sb;
|
|
select (1.1111 + 18446744073709551615) from add_sb;
|
|
select (1111111111111 + c1) from add_sb;
|
|
select (1111111111111 + c2) from add_sb;
|
|
--error 1690
|
|
select (1111111111111 + c3) from add_sb;
|
|
--error 1690
|
|
select (1111111111111 + c4) from add_sb;
|
|
select (1111111111111 + c5) from add_sb;
|
|
select (1111111111111 + c6) from add_sb;
|
|
select (1111111111111 + c7) from add_sb;
|
|
select (1111111111111 + c8) from add_sb;
|
|
select (1111111111111 + c9) from add_sb;
|
|
select (1111111111111 + c10) from add_sb;
|
|
select (1111111111111 + c11) from add_sb;
|
|
select (1111111111111 + c12) from add_sb;
|
|
select (1111111111111 + c13) from add_sb;
|
|
select (1111111111111 + c14) from add_sb;
|
|
select (1111111111111 + c15) from add_sb;
|
|
select (1111111111111 + c16) from add_sb;
|
|
select (1111111111111 + NULL) from add_sb;
|
|
select (1111111111111 + 0) from add_sb;
|
|
select (1111111111111 + 1) from add_sb;
|
|
select (1111111111111 + -1) from add_sb;
|
|
select (1111111111111 + 1.0) from add_sb;
|
|
select (1111111111111 + -1.0) from add_sb;
|
|
select (1111111111111 + 0.0) from add_sb;
|
|
select (1111111111111 + 1.1111) from add_sb;
|
|
select (1111111111111 + 1111111111111) from add_sb;
|
|
select (1111111111111 + 111.0) from add_sb;
|
|
select (1111111111111 + 123) from add_sb;
|
|
select (1111111111111 + 20120101123456) from add_sb;
|
|
select (1111111111111 + "20120101123456") from add_sb;
|
|
select (1111111111111 + "helloworld") from add_sb;
|
|
select (1111111111111 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (1111111111111 + "abc") from add_sb;
|
|
select (1111111111111 + "爱拼才会赢") from add_sb;
|
|
select (1111111111111 + "A") from add_sb;
|
|
select (1111111111111 + "a") from add_sb;
|
|
select (1111111111111 + "%y%m%d") from add_sb;
|
|
select (1111111111111 + -9223372036854775808) from add_sb;
|
|
--error 1690
|
|
select (1111111111111 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (1111111111111 + 18446744073709551615) from add_sb;
|
|
select (111.0 + c1) from add_sb;
|
|
select (111.0 + c2) from add_sb;
|
|
select (111.0 + c3) from add_sb;
|
|
select (111.0 + c4) from add_sb;
|
|
select (111.0 + c5) from add_sb;
|
|
select (111.0 + c6) from add_sb;
|
|
select (111.0 + c7) from add_sb;
|
|
select (111.0 + c8) from add_sb;
|
|
select (111.0 + c9) from add_sb;
|
|
select (111.0 + c10) from add_sb;
|
|
select (111.0 + c11) from add_sb;
|
|
select (111.0 + c12) from add_sb;
|
|
select (111.0 + c13) from add_sb;
|
|
select (111.0 + c14) from add_sb;
|
|
select (111.0 + c15) from add_sb;
|
|
select (111.0 + c16) from add_sb;
|
|
select (111.0 + NULL) from add_sb;
|
|
select (111.0 + 0) from add_sb;
|
|
select (111.0 + 1) from add_sb;
|
|
select (111.0 + -1) from add_sb;
|
|
select (111.0 + 1.0) from add_sb;
|
|
select (111.0 + -1.0) from add_sb;
|
|
select (111.0 + 0.0) from add_sb;
|
|
select (111.0 + 1.1111) from add_sb;
|
|
select (111.0 + 1111111111111) from add_sb;
|
|
select (111.0 + 111.0) from add_sb;
|
|
select (111.0 + 123) from add_sb;
|
|
select (111.0 + 20120101123456) from add_sb;
|
|
select (111.0 + "20120101123456") from add_sb;
|
|
select (111.0 + "helloworld") from add_sb;
|
|
select (111.0 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (111.0 + "abc") from add_sb;
|
|
select (111.0 + "爱拼才会赢") from add_sb;
|
|
select (111.0 + "A") from add_sb;
|
|
select (111.0 + "a") from add_sb;
|
|
select (111.0 + "%y%m%d") from add_sb;
|
|
select (111.0 + -9223372036854775808) from add_sb;
|
|
select (111.0 + 9223372036854775807) from add_sb;
|
|
select (111.0 + 18446744073709551615) from add_sb;
|
|
select (123 + c1) from add_sb;
|
|
select (123 + c2) from add_sb;
|
|
--error 1690
|
|
select (123 + c3) from add_sb;
|
|
--error 1690
|
|
select (123 + c4) from add_sb;
|
|
select (123 + c5) from add_sb;
|
|
select (123 + c6) from add_sb;
|
|
select (123 + c7) from add_sb;
|
|
select (123 + c8) from add_sb;
|
|
select (123 + c9) from add_sb;
|
|
select (123 + c10) from add_sb;
|
|
select (123 + c11) from add_sb;
|
|
select (123 + c12) from add_sb;
|
|
select (123 + c13) from add_sb;
|
|
select (123 + c14) from add_sb;
|
|
select (123 + c15) from add_sb;
|
|
select (123 + c16) from add_sb;
|
|
select (123 + NULL) from add_sb;
|
|
select (123 + 0) from add_sb;
|
|
select (123 + 1) from add_sb;
|
|
select (123 + -1) from add_sb;
|
|
select (123 + 1.0) from add_sb;
|
|
select (123 + -1.0) from add_sb;
|
|
select (123 + 0.0) from add_sb;
|
|
select (123 + 1.1111) from add_sb;
|
|
select (123 + 1111111111111) from add_sb;
|
|
select (123 + 111.0) from add_sb;
|
|
select (123 + 123) from add_sb;
|
|
select (123 + 20120101123456) from add_sb;
|
|
select (123 + "20120101123456") from add_sb;
|
|
select (123 + "helloworld") from add_sb;
|
|
select (123 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (123 + "abc") from add_sb;
|
|
select (123 + "爱拼才会赢") from add_sb;
|
|
select (123 + "A") from add_sb;
|
|
select (123 + "a") from add_sb;
|
|
select (123 + "%y%m%d") from add_sb;
|
|
select (123 + -9223372036854775808) from add_sb;
|
|
--error 1690
|
|
select (123 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (123 + 18446744073709551615) from add_sb;
|
|
select (20120101123456 + c1) from add_sb;
|
|
select (20120101123456 + c2) from add_sb;
|
|
--error 1690
|
|
select (20120101123456 + c3) from add_sb;
|
|
--error 1690
|
|
select (20120101123456 + c4) from add_sb;
|
|
select (20120101123456 + c5) from add_sb;
|
|
select (20120101123456 + c6) from add_sb;
|
|
select (20120101123456 + c7) from add_sb;
|
|
select (20120101123456 + c8) from add_sb;
|
|
select (20120101123456 + c9) from add_sb;
|
|
select (20120101123456 + c10) from add_sb;
|
|
select (20120101123456 + c11) from add_sb;
|
|
select (20120101123456 + c12) from add_sb;
|
|
select (20120101123456 + c13) from add_sb;
|
|
select (20120101123456 + c14) from add_sb;
|
|
select (20120101123456 + c15) from add_sb;
|
|
select (20120101123456 + c16) from add_sb;
|
|
select (20120101123456 + NULL) from add_sb;
|
|
select (20120101123456 + 0) from add_sb;
|
|
select (20120101123456 + 1) from add_sb;
|
|
select (20120101123456 + -1) from add_sb;
|
|
select (20120101123456 + 1.0) from add_sb;
|
|
select (20120101123456 + -1.0) from add_sb;
|
|
select (20120101123456 + 0.0) from add_sb;
|
|
select (20120101123456 + 1.1111) from add_sb;
|
|
select (20120101123456 + 1111111111111) from add_sb;
|
|
select (20120101123456 + 111.0) from add_sb;
|
|
select (20120101123456 + 123) from add_sb;
|
|
select (20120101123456 + 20120101123456) from add_sb;
|
|
select (20120101123456 + "20120101123456") from add_sb;
|
|
select (20120101123456 + "helloworld") from add_sb;
|
|
select (20120101123456 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (20120101123456 + "abc") from add_sb;
|
|
select (20120101123456 + "爱拼才会赢") from add_sb;
|
|
select (20120101123456 + "A") from add_sb;
|
|
select (20120101123456 + "a") from add_sb;
|
|
select (20120101123456 + "%y%m%d") from add_sb;
|
|
select (20120101123456 + -9223372036854775808) from add_sb;
|
|
--error 1690
|
|
select (20120101123456 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (20120101123456 + 18446744073709551615) from add_sb;
|
|
select ("20120101123456" + c1) from add_sb;
|
|
select ("20120101123456" + c2) from add_sb;
|
|
select ("20120101123456" + c3) from add_sb;
|
|
select ("20120101123456" + c4) from add_sb;
|
|
select ("20120101123456" + c5) from add_sb;
|
|
select ("20120101123456" + c6) from add_sb;
|
|
select ("20120101123456" + c7) from add_sb;
|
|
select ("20120101123456" + c8) from add_sb;
|
|
select ("20120101123456" + c9) from add_sb;
|
|
select ("20120101123456" + c10) from add_sb;
|
|
select ("20120101123456" + c11) from add_sb;
|
|
select ("20120101123456" + c12) from add_sb;
|
|
select ("20120101123456" + c13) from add_sb;
|
|
select ("20120101123456" + c14) from add_sb;
|
|
select ("20120101123456" + c15) from add_sb;
|
|
select ("20120101123456" + c16) from add_sb;
|
|
select ("20120101123456" + NULL) from add_sb;
|
|
select ("20120101123456" + 0) from add_sb;
|
|
select ("20120101123456" + 1) from add_sb;
|
|
select ("20120101123456" + -1) from add_sb;
|
|
select ("20120101123456" + 1.0) from add_sb;
|
|
select ("20120101123456" + -1.0) from add_sb;
|
|
select ("20120101123456" + 0.0) from add_sb;
|
|
select ("20120101123456" + 1.1111) from add_sb;
|
|
select ("20120101123456" + 1111111111111) from add_sb;
|
|
select ("20120101123456" + 111.0) from add_sb;
|
|
select ("20120101123456" + 123) from add_sb;
|
|
select ("20120101123456" + 20120101123456) from add_sb;
|
|
select ("20120101123456" + "20120101123456") from add_sb;
|
|
select ("20120101123456" + "helloworld") from add_sb;
|
|
select ("20120101123456" + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select ("20120101123456" + "abc") from add_sb;
|
|
select ("20120101123456" + "爱拼才会赢") from add_sb;
|
|
select ("20120101123456" + "A") from add_sb;
|
|
select ("20120101123456" + "a") from add_sb;
|
|
select ("20120101123456" + "%y%m%d") from add_sb;
|
|
select ("20120101123456" + -9223372036854775808) from add_sb;
|
|
select ("20120101123456" + 9223372036854775807) from add_sb;
|
|
select ("20120101123456" + 18446744073709551615) from add_sb;
|
|
select ("helloworld" + c1) from add_sb;
|
|
select ("helloworld" + c2) from add_sb;
|
|
select ("helloworld" + c3) from add_sb;
|
|
select ("helloworld" + c4) from add_sb;
|
|
select ("helloworld" + c5) from add_sb;
|
|
select ("helloworld" + c6) from add_sb;
|
|
select ("helloworld" + c7) from add_sb;
|
|
select ("helloworld" + c8) from add_sb;
|
|
select ("helloworld" + c9) from add_sb;
|
|
select ("helloworld" + c10) from add_sb;
|
|
select ("helloworld" + c11) from add_sb;
|
|
select ("helloworld" + c12) from add_sb;
|
|
select ("helloworld" + c13) from add_sb;
|
|
select ("helloworld" + c14) from add_sb;
|
|
select ("helloworld" + c15) from add_sb;
|
|
select ("helloworld" + c16) from add_sb;
|
|
select ("helloworld" + NULL) from add_sb;
|
|
select ("helloworld" + 0) from add_sb;
|
|
select ("helloworld" + 1) from add_sb;
|
|
select ("helloworld" + -1) from add_sb;
|
|
select ("helloworld" + 1.0) from add_sb;
|
|
select ("helloworld" + -1.0) from add_sb;
|
|
select ("helloworld" + 0.0) from add_sb;
|
|
select ("helloworld" + 1.1111) from add_sb;
|
|
select ("helloworld" + 1111111111111) from add_sb;
|
|
select ("helloworld" + 111.0) from add_sb;
|
|
select ("helloworld" + 123) from add_sb;
|
|
select ("helloworld" + 20120101123456) from add_sb;
|
|
select ("helloworld" + "20120101123456") from add_sb;
|
|
select ("helloworld" + "helloworld") from add_sb;
|
|
select ("helloworld" + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select ("helloworld" + "abc") from add_sb;
|
|
select ("helloworld" + "爱拼才会赢") from add_sb;
|
|
select ("helloworld" + "A") from add_sb;
|
|
select ("helloworld" + "a") from add_sb;
|
|
select ("helloworld" + "%y%m%d") from add_sb;
|
|
select ("helloworld" + -9223372036854775808) from add_sb;
|
|
select ("helloworld" + 9223372036854775807) from add_sb;
|
|
select ("helloworld" + 18446744073709551615) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c1) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c2) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c3) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c4) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c5) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c6) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c7) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c8) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c9) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c10) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c11) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c12) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c13) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c14) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c15) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + c16) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + NULL) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + 0) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + 1) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + -1) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + 1.0) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + -1.0) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + 0.0) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + 1.1111) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + 1111111111111) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + 111.0) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + 123) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + 20120101123456) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + "20120101123456") from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + "helloworld") from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + "abc") from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + "爱拼才会赢") from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + "A") from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + "a") from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + "%y%m%d") from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + -9223372036854775808) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + 9223372036854775807) from add_sb;
|
|
select ("9999-12-31 23:59:59.9999997" + 18446744073709551615) from add_sb;
|
|
select ("abc" + c1) from add_sb;
|
|
select ("abc" + c2) from add_sb;
|
|
select ("abc" + c3) from add_sb;
|
|
select ("abc" + c4) from add_sb;
|
|
select ("abc" + c5) from add_sb;
|
|
select ("abc" + c6) from add_sb;
|
|
select ("abc" + c7) from add_sb;
|
|
select ("abc" + c8) from add_sb;
|
|
select ("abc" + c9) from add_sb;
|
|
select ("abc" + c10) from add_sb;
|
|
select ("abc" + c11) from add_sb;
|
|
select ("abc" + c12) from add_sb;
|
|
select ("abc" + c13) from add_sb;
|
|
select ("abc" + c14) from add_sb;
|
|
select ("abc" + c15) from add_sb;
|
|
select ("abc" + c16) from add_sb;
|
|
select ("abc" + NULL) from add_sb;
|
|
select ("abc" + 0) from add_sb;
|
|
select ("abc" + 1) from add_sb;
|
|
select ("abc" + -1) from add_sb;
|
|
select ("abc" + 1.0) from add_sb;
|
|
select ("abc" + -1.0) from add_sb;
|
|
select ("abc" + 0.0) from add_sb;
|
|
select ("abc" + 1.1111) from add_sb;
|
|
select ("abc" + 1111111111111) from add_sb;
|
|
select ("abc" + 111.0) from add_sb;
|
|
select ("abc" + 123) from add_sb;
|
|
select ("abc" + 20120101123456) from add_sb;
|
|
select ("abc" + "20120101123456") from add_sb;
|
|
select ("abc" + "helloworld") from add_sb;
|
|
select ("abc" + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select ("abc" + "abc") from add_sb;
|
|
select ("abc" + "爱拼才会赢") from add_sb;
|
|
select ("abc" + "A") from add_sb;
|
|
select ("abc" + "a") from add_sb;
|
|
select ("abc" + "%y%m%d") from add_sb;
|
|
select ("abc" + -9223372036854775808) from add_sb;
|
|
select ("abc" + 9223372036854775807) from add_sb;
|
|
select ("abc" + 18446744073709551615) from add_sb;
|
|
select ("爱拼才会赢" + c1) from add_sb;
|
|
select ("爱拼才会赢" + c2) from add_sb;
|
|
select ("爱拼才会赢" + c3) from add_sb;
|
|
select ("爱拼才会赢" + c4) from add_sb;
|
|
select ("爱拼才会赢" + c5) from add_sb;
|
|
select ("爱拼才会赢" + c6) from add_sb;
|
|
select ("爱拼才会赢" + c7) from add_sb;
|
|
select ("爱拼才会赢" + c8) from add_sb;
|
|
select ("爱拼才会赢" + c9) from add_sb;
|
|
select ("爱拼才会赢" + c10) from add_sb;
|
|
select ("爱拼才会赢" + c11) from add_sb;
|
|
select ("爱拼才会赢" + c12) from add_sb;
|
|
select ("爱拼才会赢" + c13) from add_sb;
|
|
select ("爱拼才会赢" + c14) from add_sb;
|
|
select ("爱拼才会赢" + c15) from add_sb;
|
|
select ("爱拼才会赢" + c16) from add_sb;
|
|
select ("爱拼才会赢" + NULL) from add_sb;
|
|
select ("爱拼才会赢" + 0) from add_sb;
|
|
select ("爱拼才会赢" + 1) from add_sb;
|
|
select ("爱拼才会赢" + -1) from add_sb;
|
|
select ("爱拼才会赢" + 1.0) from add_sb;
|
|
select ("爱拼才会赢" + -1.0) from add_sb;
|
|
select ("爱拼才会赢" + 0.0) from add_sb;
|
|
select ("爱拼才会赢" + 1.1111) from add_sb;
|
|
select ("爱拼才会赢" + 1111111111111) from add_sb;
|
|
select ("爱拼才会赢" + 111.0) from add_sb;
|
|
select ("爱拼才会赢" + 123) from add_sb;
|
|
select ("爱拼才会赢" + 20120101123456) from add_sb;
|
|
select ("爱拼才会赢" + "20120101123456") from add_sb;
|
|
select ("爱拼才会赢" + "helloworld") from add_sb;
|
|
select ("爱拼才会赢" + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select ("爱拼才会赢" + "abc") from add_sb;
|
|
select ("爱拼才会赢" + "爱拼才会赢") from add_sb;
|
|
select ("爱拼才会赢" + "A") from add_sb;
|
|
select ("爱拼才会赢" + "a") from add_sb;
|
|
select ("爱拼才会赢" + "%y%m%d") from add_sb;
|
|
select ("爱拼才会赢" + -9223372036854775808) from add_sb;
|
|
select ("爱拼才会赢" + 9223372036854775807) from add_sb;
|
|
select ("爱拼才会赢" + 18446744073709551615) from add_sb;
|
|
select ("A" + c1) from add_sb;
|
|
select ("A" + c2) from add_sb;
|
|
select ("A" + c3) from add_sb;
|
|
select ("A" + c4) from add_sb;
|
|
select ("A" + c5) from add_sb;
|
|
select ("A" + c6) from add_sb;
|
|
select ("A" + c7) from add_sb;
|
|
select ("A" + c8) from add_sb;
|
|
select ("A" + c9) from add_sb;
|
|
select ("A" + c10) from add_sb;
|
|
select ("A" + c11) from add_sb;
|
|
select ("A" + c12) from add_sb;
|
|
select ("A" + c13) from add_sb;
|
|
select ("A" + c14) from add_sb;
|
|
select ("A" + c15) from add_sb;
|
|
select ("A" + c16) from add_sb;
|
|
select ("A" + NULL) from add_sb;
|
|
select ("A" + 0) from add_sb;
|
|
select ("A" + 1) from add_sb;
|
|
select ("A" + -1) from add_sb;
|
|
select ("A" + 1.0) from add_sb;
|
|
select ("A" + -1.0) from add_sb;
|
|
select ("A" + 0.0) from add_sb;
|
|
select ("A" + 1.1111) from add_sb;
|
|
select ("A" + 1111111111111) from add_sb;
|
|
select ("A" + 111.0) from add_sb;
|
|
select ("A" + 123) from add_sb;
|
|
select ("A" + 20120101123456) from add_sb;
|
|
select ("A" + "20120101123456") from add_sb;
|
|
select ("A" + "helloworld") from add_sb;
|
|
select ("A" + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select ("A" + "abc") from add_sb;
|
|
select ("A" + "爱拼才会赢") from add_sb;
|
|
select ("A" + "A") from add_sb;
|
|
select ("A" + "a") from add_sb;
|
|
select ("A" + "%y%m%d") from add_sb;
|
|
select ("A" + -9223372036854775808) from add_sb;
|
|
select ("A" + 9223372036854775807) from add_sb;
|
|
select ("A" + 18446744073709551615) from add_sb;
|
|
select ("a" + c1) from add_sb;
|
|
select ("a" + c2) from add_sb;
|
|
select ("a" + c3) from add_sb;
|
|
select ("a" + c4) from add_sb;
|
|
select ("a" + c5) from add_sb;
|
|
select ("a" + c6) from add_sb;
|
|
select ("a" + c7) from add_sb;
|
|
select ("a" + c8) from add_sb;
|
|
select ("a" + c9) from add_sb;
|
|
select ("a" + c10) from add_sb;
|
|
select ("a" + c11) from add_sb;
|
|
select ("a" + c12) from add_sb;
|
|
select ("a" + c13) from add_sb;
|
|
select ("a" + c14) from add_sb;
|
|
select ("a" + c15) from add_sb;
|
|
select ("a" + c16) from add_sb;
|
|
select ("a" + NULL) from add_sb;
|
|
select ("a" + 0) from add_sb;
|
|
select ("a" + 1) from add_sb;
|
|
select ("a" + -1) from add_sb;
|
|
select ("a" + 1.0) from add_sb;
|
|
select ("a" + -1.0) from add_sb;
|
|
select ("a" + 0.0) from add_sb;
|
|
select ("a" + 1.1111) from add_sb;
|
|
select ("a" + 1111111111111) from add_sb;
|
|
select ("a" + 111.0) from add_sb;
|
|
select ("a" + 123) from add_sb;
|
|
select ("a" + 20120101123456) from add_sb;
|
|
select ("a" + "20120101123456") from add_sb;
|
|
select ("a" + "helloworld") from add_sb;
|
|
select ("a" + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select ("a" + "abc") from add_sb;
|
|
select ("a" + "爱拼才会赢") from add_sb;
|
|
select ("a" + "A") from add_sb;
|
|
select ("a" + "a") from add_sb;
|
|
select ("a" + "%y%m%d") from add_sb;
|
|
select ("a" + -9223372036854775808) from add_sb;
|
|
select ("a" + 9223372036854775807) from add_sb;
|
|
select ("a" + 18446744073709551615) from add_sb;
|
|
select ("%y%m%d" + c1) from add_sb;
|
|
select ("%y%m%d" + c2) from add_sb;
|
|
select ("%y%m%d" + c3) from add_sb;
|
|
select ("%y%m%d" + c4) from add_sb;
|
|
select ("%y%m%d" + c5) from add_sb;
|
|
select ("%y%m%d" + c6) from add_sb;
|
|
select ("%y%m%d" + c7) from add_sb;
|
|
select ("%y%m%d" + c8) from add_sb;
|
|
select ("%y%m%d" + c9) from add_sb;
|
|
select ("%y%m%d" + c10) from add_sb;
|
|
select ("%y%m%d" + c11) from add_sb;
|
|
select ("%y%m%d" + c12) from add_sb;
|
|
select ("%y%m%d" + c13) from add_sb;
|
|
select ("%y%m%d" + c14) from add_sb;
|
|
select ("%y%m%d" + c15) from add_sb;
|
|
select ("%y%m%d" + c16) from add_sb;
|
|
select ("%y%m%d" + NULL) from add_sb;
|
|
select ("%y%m%d" + 0) from add_sb;
|
|
select ("%y%m%d" + 1) from add_sb;
|
|
select ("%y%m%d" + -1) from add_sb;
|
|
select ("%y%m%d" + 1.0) from add_sb;
|
|
select ("%y%m%d" + -1.0) from add_sb;
|
|
select ("%y%m%d" + 0.0) from add_sb;
|
|
select ("%y%m%d" + 1.1111) from add_sb;
|
|
select ("%y%m%d" + 1111111111111) from add_sb;
|
|
select ("%y%m%d" + 111.0) from add_sb;
|
|
select ("%y%m%d" + 123) from add_sb;
|
|
select ("%y%m%d" + 20120101123456) from add_sb;
|
|
select ("%y%m%d" + "20120101123456") from add_sb;
|
|
select ("%y%m%d" + "helloworld") from add_sb;
|
|
select ("%y%m%d" + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select ("%y%m%d" + "abc") from add_sb;
|
|
select ("%y%m%d" + "爱拼才会赢") from add_sb;
|
|
select ("%y%m%d" + "A") from add_sb;
|
|
select ("%y%m%d" + "a") from add_sb;
|
|
select ("%y%m%d" + "%y%m%d") from add_sb;
|
|
select ("%y%m%d" + -9223372036854775808) from add_sb;
|
|
select ("%y%m%d" + 9223372036854775807) from add_sb;
|
|
select ("%y%m%d" + 18446744073709551615) from add_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 + c1) from add_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 + c2) from add_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 + c3) from add_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 + c4) from add_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 + c5) from add_sb;
|
|
select (-9223372036854775808 + c6) from add_sb;
|
|
select (-9223372036854775808 + c7) from add_sb;
|
|
select (-9223372036854775808 + c8) from add_sb;
|
|
select (-9223372036854775808 + c9) from add_sb;
|
|
select (-9223372036854775808 + c10) from add_sb;
|
|
select (-9223372036854775808 + c11) from add_sb;
|
|
select (-9223372036854775808 + c12) from add_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 + c13) from add_sb;
|
|
select (-9223372036854775808 + c14) from add_sb;
|
|
select (-9223372036854775808 + c15) from add_sb;
|
|
select (-9223372036854775808 + c16) from add_sb;
|
|
select (-9223372036854775808 + NULL) from add_sb;
|
|
select (-9223372036854775808 + 0) from add_sb;
|
|
select (-9223372036854775808 + 1) from add_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 + -1) from add_sb;
|
|
select (-9223372036854775808 + 1.0) from add_sb;
|
|
select (-9223372036854775808 + -1.0) from add_sb;
|
|
select (-9223372036854775808 + 0.0) from add_sb;
|
|
select (-9223372036854775808 + 1.1111) from add_sb;
|
|
select (-9223372036854775808 + 1111111111111) from add_sb;
|
|
select (-9223372036854775808 + 111.0) from add_sb;
|
|
select (-9223372036854775808 + 123) from add_sb;
|
|
select (-9223372036854775808 + 20120101123456) from add_sb;
|
|
select (-9223372036854775808 + "20120101123456") from add_sb;
|
|
select (-9223372036854775808 + "helloworld") from add_sb;
|
|
select (-9223372036854775808 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (-9223372036854775808 + "abc") from add_sb;
|
|
select (-9223372036854775808 + "爱拼才会赢") from add_sb;
|
|
select (-9223372036854775808 + "A") from add_sb;
|
|
select (-9223372036854775808 + "a") from add_sb;
|
|
select (-9223372036854775808 + "%y%m%d") from add_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 + -9223372036854775808) from add_sb;
|
|
select (-9223372036854775808 + 9223372036854775807) from add_sb;
|
|
select (-9223372036854775808 + 18446744073709551615) from add_sb;
|
|
--error 1690
|
|
select (9223372036854775807 + c1) from add_sb;
|
|
select (9223372036854775807 + c2) from add_sb;
|
|
--error 1690
|
|
select (9223372036854775807 + c3) from add_sb;
|
|
--error 1690
|
|
select (9223372036854775807 + c4) from add_sb;
|
|
select (9223372036854775807 + c5) from add_sb;
|
|
select (9223372036854775807 + c6) from add_sb;
|
|
select (9223372036854775807 + c7) from add_sb;
|
|
select (9223372036854775807 + c8) from add_sb;
|
|
select (9223372036854775807 + c9) from add_sb;
|
|
--error 1690
|
|
select (9223372036854775807 + c10) from add_sb;
|
|
select (9223372036854775807 + c11) from add_sb;
|
|
select (9223372036854775807 + c12) from add_sb;
|
|
select (9223372036854775807 + c13) from add_sb;
|
|
select (9223372036854775807 + c14) from add_sb;
|
|
select (9223372036854775807 + c15) from add_sb;
|
|
select (9223372036854775807 + c16) from add_sb;
|
|
select (9223372036854775807 + NULL) from add_sb;
|
|
select (9223372036854775807 + 0) from add_sb;
|
|
--error 1690
|
|
select (9223372036854775807 + 1) from add_sb;
|
|
select (9223372036854775807 + -1) from add_sb;
|
|
select (9223372036854775807 + 1.0) from add_sb;
|
|
select (9223372036854775807 + -1.0) from add_sb;
|
|
select (9223372036854775807 + 0.0) from add_sb;
|
|
select (9223372036854775807 + 1.1111) from add_sb;
|
|
--error 1690
|
|
select (9223372036854775807 + 1111111111111) from add_sb;
|
|
select (9223372036854775807 + 111.0) from add_sb;
|
|
--error 1690
|
|
select (9223372036854775807 + 123) from add_sb;
|
|
--error 1690
|
|
select (9223372036854775807 + 20120101123456) from add_sb;
|
|
select (9223372036854775807 + "20120101123456") from add_sb;
|
|
select (9223372036854775807 + "helloworld") from add_sb;
|
|
select (9223372036854775807 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (9223372036854775807 + "abc") from add_sb;
|
|
select (9223372036854775807 + "爱拼才会赢") from add_sb;
|
|
select (9223372036854775807 + "A") from add_sb;
|
|
select (9223372036854775807 + "a") from add_sb;
|
|
select (9223372036854775807 + "%y%m%d") from add_sb;
|
|
select (9223372036854775807 + -9223372036854775808) from add_sb;
|
|
--error 1690
|
|
select (9223372036854775807 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (9223372036854775807 + 18446744073709551615) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + c1) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + c2) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + c3) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + c4) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + c5) from add_sb;
|
|
select (18446744073709551615 + c6) from add_sb;
|
|
select (18446744073709551615 + c7) from add_sb;
|
|
select (18446744073709551615 + c8) from add_sb;
|
|
select (18446744073709551615 + c9) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + c10) from add_sb;
|
|
select (18446744073709551615 + c11) from add_sb;
|
|
select (18446744073709551615 + c12) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + c13) from add_sb;
|
|
select (18446744073709551615 + c14) from add_sb;
|
|
select (18446744073709551615 + c15) from add_sb;
|
|
select (18446744073709551615 + c16) from add_sb;
|
|
select (18446744073709551615 + NULL) from add_sb;
|
|
select (18446744073709551615 + 0) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + 1) from add_sb;
|
|
select (18446744073709551615 + -1) from add_sb;
|
|
select (18446744073709551615 + 1.0) from add_sb;
|
|
select (18446744073709551615 + -1.0) from add_sb;
|
|
select (18446744073709551615 + 0.0) from add_sb;
|
|
select (18446744073709551615 + 1.1111) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + 1111111111111) from add_sb;
|
|
select (18446744073709551615 + 111.0) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + 123) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + 20120101123456) from add_sb;
|
|
select (18446744073709551615 + "20120101123456") from add_sb;
|
|
select (18446744073709551615 + "helloworld") from add_sb;
|
|
select (18446744073709551615 + "9999-12-31 23:59:59.9999997") from add_sb;
|
|
select (18446744073709551615 + "abc") from add_sb;
|
|
select (18446744073709551615 + "爱拼才会赢") from add_sb;
|
|
select (18446744073709551615 + "A") from add_sb;
|
|
select (18446744073709551615 + "a") from add_sb;
|
|
select (18446744073709551615 + "%y%m%d") from add_sb;
|
|
select (18446744073709551615 + -9223372036854775808) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + 9223372036854775807) from add_sb;
|
|
--error 1690
|
|
select (18446744073709551615 + 18446744073709551615) from add_sb;
|
|
drop table add_sb;
|