1921 lines
71 KiB
Plaintext
1921 lines
71 KiB
Plaintext
#### owner: zuojiao.hzj
|
|
#### owner group: sql3
|
|
#### description: test
|
|
# tags: expr, datatype
|
|
|
|
--disable_warnings
|
|
drop table if exists mul_sb;
|
|
create table mul_sb(c1 int,c2 int(255) zerofill,c3 bigint,c4 bigint unsigned,c5 bigint(255) zerofill,c6 decimal,c7 decimal(35, 15),c8 decimal(35, 7) zerofill,c9 varchar(123) collate utf8mb4_general_ci,c10 date,c11 datetime(5),c12 timestamp(5),c13 year(4),c14 char(24),c15 binary(24),c16 varchar(123) collate utf8mb4_bin);
|
|
set @tmp_sql_mode = @@sql_mode;
|
|
set @@sql_mode = '';
|
|
insert into mul_sb(c1) values(NULL);
|
|
insert into mul_sb(c1) values(-2146583648);
|
|
insert into mul_sb(c1) values(0);
|
|
insert into mul_sb(c1) values(-1);
|
|
insert into mul_sb(c1) values(123456);
|
|
insert into mul_sb(c1) values(20120101);
|
|
insert into mul_sb(c1) values(99990101);
|
|
insert into mul_sb(c1) values(2146583647);
|
|
insert into mul_sb(c2) values(NULL);
|
|
insert into mul_sb(c2) values(0);
|
|
insert into mul_sb(c2) values(123456);
|
|
insert into mul_sb(c2) values(20120101);
|
|
insert into mul_sb(c2) values(99990101);
|
|
insert into mul_sb(c2) values(2146583647);
|
|
insert into mul_sb(c3) values(NULL);
|
|
insert into mul_sb(c3) values(-9223372036854775808);
|
|
insert into mul_sb(c3) values(-123456789);
|
|
insert into mul_sb(c3) values(-1);
|
|
insert into mul_sb(c3) values(0);
|
|
insert into mul_sb(c3) values(20120101123456);
|
|
insert into mul_sb(c3) values(99990101123456);
|
|
insert into mul_sb(c3) values(20120101163456);
|
|
insert into mul_sb(c3) values(9223372036854775807);
|
|
insert into mul_sb(c4) values(NULL);
|
|
insert into mul_sb(c4) values(0);
|
|
insert into mul_sb(c4) values(20120101123456);
|
|
insert into mul_sb(c4) values(99990101123456);
|
|
insert into mul_sb(c4) values(20120101163456);
|
|
insert into mul_sb(c4) values(9223372036854775807);
|
|
insert into mul_sb(c4) values(18446744073709551615);
|
|
insert into mul_sb(c5) values(NULL);
|
|
insert into mul_sb(c5) values(0);
|
|
insert into mul_sb(c5) values(123456789);
|
|
insert into mul_sb(c5) values(20120101123456);
|
|
insert into mul_sb(c5) values(99990101123456);
|
|
insert into mul_sb(c5) values(20120101163456);
|
|
insert into mul_sb(c5) values(9223372036854775807);
|
|
insert into mul_sb(c6) values(NULL);
|
|
insert into mul_sb(c6) values(1);
|
|
insert into mul_sb(c6) values(-1);
|
|
insert into mul_sb(c6) values(0);
|
|
insert into mul_sb(c6) values(20120101);
|
|
insert into mul_sb(c6) values(99991231);
|
|
insert into mul_sb(c6) values(1234567);
|
|
insert into mul_sb(c6) values(123);
|
|
insert into mul_sb(c6) values(-123);
|
|
insert into mul_sb(c7) values(NULL);
|
|
insert into mul_sb(c7) values(0);
|
|
insert into mul_sb(c7) values(0.0);
|
|
insert into mul_sb(c7) values(0.00000000000000000001);
|
|
insert into mul_sb(c7) values(1.123456);
|
|
insert into mul_sb(c7) values(1234567);
|
|
insert into mul_sb(c7) values(123.45);
|
|
insert into mul_sb(c7) values(9.999999999999999);
|
|
insert into mul_sb(c7) values(9.999999999);
|
|
insert into mul_sb(c7) values(999999999.9);
|
|
insert into mul_sb(c7) values(9999999999.9);
|
|
insert into mul_sb(c7) values(999999999);
|
|
insert into mul_sb(c7) values(-999999999.9);
|
|
insert into mul_sb(c7) values(-9999999999.9);
|
|
insert into mul_sb(c7) values(-999999999);
|
|
insert into mul_sb(c7) values(-9.99999999999);
|
|
insert into mul_sb(c7) values(20120101123456.99999);
|
|
insert into mul_sb(c7) values(99990101123456);
|
|
insert into mul_sb(c7) values(20120101163456);
|
|
insert into mul_sb(c7) values(1.1234567);
|
|
insert into mul_sb(c7) values(1.0);
|
|
insert into mul_sb(c7) values(1.0000000);
|
|
insert into mul_sb(c7) values(-9.999999999999999);
|
|
insert into mul_sb(c8) values(NULL);
|
|
insert into mul_sb(c8) values(1.123456);
|
|
insert into mul_sb(c8) values(1234567);
|
|
insert into mul_sb(c8) values(123.45);
|
|
insert into mul_sb(c8) values(20120101123456);
|
|
insert into mul_sb(c8) values(99990101123456);
|
|
insert into mul_sb(c8) values(20120101163456);
|
|
insert into mul_sb(c8) values(1.1234567);
|
|
insert into mul_sb(c8) values(1.00000);
|
|
insert into mul_sb(c8) values(1.0000000);
|
|
insert into mul_sb(c9) values(NULL);
|
|
insert into mul_sb(c9) values("0");
|
|
insert into mul_sb(c9) values("-123");
|
|
insert into mul_sb(c9) values("a");
|
|
insert into mul_sb(c9) values("A");
|
|
insert into mul_sb(c9) values("helloworld");
|
|
insert into mul_sb(c9) values("");
|
|
insert into mul_sb(c9) values(" ");
|
|
insert into mul_sb(c9) values("我爱你C++Soupen");
|
|
insert into mul_sb(c9) values("20120101123456");
|
|
insert into mul_sb(c9) values("99990101123456");
|
|
insert into mul_sb(c9) values("20120101163456");
|
|
insert into mul_sb(c9) values("111111111111111111111111111111");
|
|
insert into mul_sb(c9) values("%y%m%d");
|
|
insert into mul_sb(c9) values("%y%m%d HH:MM:SS");
|
|
insert into mul_sb(c9) values("192.168.1.1");
|
|
insert into mul_sb(c10) values(NULL);
|
|
insert into mul_sb(c10) values(20100101);
|
|
insert into mul_sb(c10) values(99991301);
|
|
insert into mul_sb(c11) values(NULL);
|
|
insert into mul_sb(c11) values(20100101123456);
|
|
insert into mul_sb(c11) values(20100101123456.789);
|
|
insert into mul_sb(c11) values(20100101123456.99999);
|
|
insert into mul_sb(c11) values(20101231235959.99999);
|
|
insert into mul_sb(c11) values(20100101000000.99999);
|
|
insert into mul_sb(c11) values(99991301123466);
|
|
insert into mul_sb(c11) values("9999-12-31 23:59:59.9999997");
|
|
insert into mul_sb(c12) values(NULL);
|
|
insert into mul_sb(c12) values(20100101123456);
|
|
insert into mul_sb(c12) values(20100101000000.99999);
|
|
insert into mul_sb(c12) values(20100101123456.99999);
|
|
insert into mul_sb(c12) values(20101231235959.99999);
|
|
insert into mul_sb(c12) values("9999-12-31 23:59:59.9999997");
|
|
insert into mul_sb(c13) values(NULL);
|
|
insert into mul_sb(c13) values(2012);
|
|
insert into mul_sb(c13) values(0000);
|
|
insert into mul_sb(c13) values(9999);
|
|
insert into mul_sb(c13) values(1234567);
|
|
insert into mul_sb(c14) values(NULL);
|
|
insert into mul_sb(c14) values("a");
|
|
insert into mul_sb(c14) values("A");
|
|
insert into mul_sb(c14) values("helloworld");
|
|
insert into mul_sb(c14) values("我爱你C++Soupen");
|
|
insert into mul_sb(c15) values(NULL);
|
|
insert into mul_sb(c15) values("a");
|
|
insert into mul_sb(c15) values("A");
|
|
insert into mul_sb(c15) values("helloworld");
|
|
insert into mul_sb(c15) values("我爱你C++Soupen");
|
|
insert into mul_sb(c16) values(NULL);
|
|
insert into mul_sb(c16) values("a");
|
|
insert into mul_sb(c16) values("A");
|
|
insert into mul_sb(c16) values("helloworld");
|
|
insert into mul_sb(c16) values("我爱你C++Soupen");
|
|
select (c1 * c1) from mul_sb;
|
|
select (c1 * c2) from mul_sb;
|
|
select (c1 * c3) from mul_sb;
|
|
select (c1 * c4) from mul_sb;
|
|
select (c1 * c5) from mul_sb;
|
|
select (c1 * c6) from mul_sb;
|
|
select (c1 * c7) from mul_sb;
|
|
select (c1 * c8) from mul_sb;
|
|
select (c1 * c9) from mul_sb;
|
|
select (c1 * c10) from mul_sb;
|
|
select (c1 * c11) from mul_sb;
|
|
select (c1 * c12) from mul_sb;
|
|
select (c1 * c13) from mul_sb;
|
|
select (c1 * c14) from mul_sb;
|
|
select (c1 * c15) from mul_sb;
|
|
select (c1 * c16) from mul_sb;
|
|
select (c1 * NULL) from mul_sb;
|
|
select (c1 * 0) from mul_sb;
|
|
select (c1 * 1) from mul_sb;
|
|
select (c1 * -1) from mul_sb;
|
|
select (c1 * 1.0) from mul_sb;
|
|
select (c1 * -1.0) from mul_sb;
|
|
select (c1 * 0.0) from mul_sb;
|
|
select (c1 * 1.1111) from mul_sb;
|
|
--error 1690
|
|
select (c1 * 1111111111111) from mul_sb;
|
|
select (c1 * 111.0) from mul_sb;
|
|
select (c1 * 123) from mul_sb;
|
|
--error 1690
|
|
select (c1 * 20120101123456) from mul_sb;
|
|
select (c1 * "20120101123456") from mul_sb;
|
|
select (c1 * "helloworld") from mul_sb;
|
|
select (c1 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c1 * "abc") from mul_sb;
|
|
select (c1 * "爱拼才会赢") from mul_sb;
|
|
select (c1 * "A") from mul_sb;
|
|
select (c1 * "a") from mul_sb;
|
|
select (c1 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (c1 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (c1 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (c1 * 18446744073709551615) from mul_sb;
|
|
select (c2 * c1) from mul_sb;
|
|
select (c2 * c2) from mul_sb;
|
|
select (c2 * c3) from mul_sb;
|
|
select (c2 * c4) from mul_sb;
|
|
select (c2 * c5) from mul_sb;
|
|
select (c2 * c6) from mul_sb;
|
|
select (c2 * c7) from mul_sb;
|
|
select (c2 * c8) from mul_sb;
|
|
select (c2 * c9) from mul_sb;
|
|
select (c2 * c10) from mul_sb;
|
|
select (c2 * c11) from mul_sb;
|
|
select (c2 * c12) from mul_sb;
|
|
select (c2 * c13) from mul_sb;
|
|
select (c2 * c14) from mul_sb;
|
|
select (c2 * c15) from mul_sb;
|
|
select (c2 * c16) from mul_sb;
|
|
select (c2 * NULL) from mul_sb;
|
|
select (c2 * 0) from mul_sb;
|
|
select (c2 * 1) from mul_sb;
|
|
--error 1690
|
|
select (c2 * -1) from mul_sb;
|
|
select (c2 * 1.0) from mul_sb;
|
|
select (c2 * -1.0) from mul_sb;
|
|
select (c2 * 0.0) from mul_sb;
|
|
select (c2 * 1.1111) from mul_sb;
|
|
--error 1690
|
|
select (c2 * 1111111111111) from mul_sb;
|
|
select (c2 * 111.0) from mul_sb;
|
|
select (c2 * 123) from mul_sb;
|
|
--error 1690
|
|
select (c2 * 20120101123456) from mul_sb;
|
|
select (c2 * "20120101123456") from mul_sb;
|
|
select (c2 * "helloworld") from mul_sb;
|
|
select (c2 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c2 * "abc") from mul_sb;
|
|
select (c2 * "爱拼才会赢") from mul_sb;
|
|
select (c2 * "A") from mul_sb;
|
|
select (c2 * "a") from mul_sb;
|
|
select (c2 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (c2 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (c2 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (c2 * 18446744073709551615) from mul_sb;
|
|
select (c3 * c1) from mul_sb;
|
|
select (c3 * c2) from mul_sb;
|
|
--error 1690
|
|
select (c3 * c3) from mul_sb;
|
|
select (c3 * c4) from mul_sb;
|
|
select (c3 * c5) from mul_sb;
|
|
select (c3 * c6) from mul_sb;
|
|
select (c3 * c7) from mul_sb;
|
|
select (c3 * c8) from mul_sb;
|
|
select (c3 * c9) from mul_sb;
|
|
select (c3 * c10) from mul_sb;
|
|
select (c3 * c11) from mul_sb;
|
|
select (c3 * c12) from mul_sb;
|
|
select (c3 * c13) from mul_sb;
|
|
select (c3 * c14) from mul_sb;
|
|
select (c3 * c15) from mul_sb;
|
|
select (c3 * c16) from mul_sb;
|
|
select (c3 * NULL) from mul_sb;
|
|
select (c3 * 0) from mul_sb;
|
|
select (c3 * 1) from mul_sb;
|
|
--error 1690
|
|
select (c3 * -1) from mul_sb;
|
|
select (c3 * 1.0) from mul_sb;
|
|
select (c3 * -1.0) from mul_sb;
|
|
select (c3 * 0.0) from mul_sb;
|
|
select (c3 * 1.1111) from mul_sb;
|
|
--error 1690
|
|
select (c3 * 1111111111111) from mul_sb;
|
|
select (c3 * 111.0) from mul_sb;
|
|
--error 1690
|
|
select (c3 * 123) from mul_sb;
|
|
--error 1690
|
|
select (c3 * 20120101123456) from mul_sb;
|
|
select (c3 * "20120101123456") from mul_sb;
|
|
select (c3 * "helloworld") from mul_sb;
|
|
select (c3 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c3 * "abc") from mul_sb;
|
|
select (c3 * "爱拼才会赢") from mul_sb;
|
|
select (c3 * "A") from mul_sb;
|
|
select (c3 * "a") from mul_sb;
|
|
select (c3 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (c3 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (c3 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (c3 * 18446744073709551615) from mul_sb;
|
|
select (c4 * c1) from mul_sb;
|
|
select (c4 * c2) from mul_sb;
|
|
select (c4 * c3) from mul_sb;
|
|
--error 1690
|
|
select (c4 * c4) from mul_sb;
|
|
select (c4 * c5) from mul_sb;
|
|
select (c4 * c6) from mul_sb;
|
|
select (c4 * c7) from mul_sb;
|
|
select (c4 * c8) from mul_sb;
|
|
select (c4 * c9) from mul_sb;
|
|
select (c4 * c10) from mul_sb;
|
|
select (c4 * c11) from mul_sb;
|
|
select (c4 * c12) from mul_sb;
|
|
select (c4 * c13) from mul_sb;
|
|
select (c4 * c14) from mul_sb;
|
|
select (c4 * c15) from mul_sb;
|
|
select (c4 * c16) from mul_sb;
|
|
select (c4 * NULL) from mul_sb;
|
|
select (c4 * 0) from mul_sb;
|
|
select (c4 * 1) from mul_sb;
|
|
--error 1690
|
|
select (c4 * -1) from mul_sb;
|
|
select (c4 * 1.0) from mul_sb;
|
|
select (c4 * -1.0) from mul_sb;
|
|
select (c4 * 0.0) from mul_sb;
|
|
select (c4 * 1.1111) from mul_sb;
|
|
--error 1690
|
|
select (c4 * 1111111111111) from mul_sb;
|
|
select (c4 * 111.0) from mul_sb;
|
|
--error 1690
|
|
select (c4 * 123) from mul_sb;
|
|
--error 1690
|
|
select (c4 * 20120101123456) from mul_sb;
|
|
select (c4 * "20120101123456") from mul_sb;
|
|
select (c4 * "helloworld") from mul_sb;
|
|
select (c4 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c4 * "abc") from mul_sb;
|
|
select (c4 * "爱拼才会赢") from mul_sb;
|
|
select (c4 * "A") from mul_sb;
|
|
select (c4 * "a") from mul_sb;
|
|
select (c4 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (c4 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (c4 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (c4 * 18446744073709551615) from mul_sb;
|
|
select (c5 * c1) from mul_sb;
|
|
select (c5 * c2) from mul_sb;
|
|
select (c5 * c3) from mul_sb;
|
|
select (c5 * c4) from mul_sb;
|
|
--error 1690
|
|
select (c5 * c5) from mul_sb;
|
|
select (c5 * c6) from mul_sb;
|
|
select (c5 * c7) from mul_sb;
|
|
select (c5 * c8) from mul_sb;
|
|
select (c5 * c9) from mul_sb;
|
|
select (c5 * c10) from mul_sb;
|
|
select (c5 * c11) from mul_sb;
|
|
select (c5 * c12) from mul_sb;
|
|
select (c5 * c13) from mul_sb;
|
|
select (c5 * c14) from mul_sb;
|
|
select (c5 * c15) from mul_sb;
|
|
select (c5 * c16) from mul_sb;
|
|
select (c5 * NULL) from mul_sb;
|
|
select (c5 * 0) from mul_sb;
|
|
select (c5 * 1) from mul_sb;
|
|
--error 1690
|
|
select (c5 * -1) from mul_sb;
|
|
select (c5 * 1.0) from mul_sb;
|
|
select (c5 * -1.0) from mul_sb;
|
|
select (c5 * 0.0) from mul_sb;
|
|
select (c5 * 1.1111) from mul_sb;
|
|
--error 1690
|
|
select (c5 * 1111111111111) from mul_sb;
|
|
select (c5 * 111.0) from mul_sb;
|
|
--error 1690
|
|
select (c5 * 123) from mul_sb;
|
|
--error 1690
|
|
select (c5 * 20120101123456) from mul_sb;
|
|
select (c5 * "20120101123456") from mul_sb;
|
|
select (c5 * "helloworld") from mul_sb;
|
|
select (c5 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c5 * "abc") from mul_sb;
|
|
select (c5 * "爱拼才会赢") from mul_sb;
|
|
select (c5 * "A") from mul_sb;
|
|
select (c5 * "a") from mul_sb;
|
|
select (c5 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (c5 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (c5 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (c5 * 18446744073709551615) from mul_sb;
|
|
select (c6 * c1) from mul_sb;
|
|
select (c6 * c2) from mul_sb;
|
|
select (c6 * c3) from mul_sb;
|
|
select (c6 * c4) from mul_sb;
|
|
select (c6 * c5) from mul_sb;
|
|
select (c6 * c6) from mul_sb;
|
|
select (c6 * c7) from mul_sb;
|
|
select (c6 * c8) from mul_sb;
|
|
select (c6 * c9) from mul_sb;
|
|
select (c6 * c10) from mul_sb;
|
|
select (c6 * c11) from mul_sb;
|
|
select (c6 * c12) from mul_sb;
|
|
select (c6 * c13) from mul_sb;
|
|
select (c6 * c14) from mul_sb;
|
|
select (c6 * c15) from mul_sb;
|
|
select (c6 * c16) from mul_sb;
|
|
select (c6 * NULL) from mul_sb;
|
|
select (c6 * 0) from mul_sb;
|
|
select (c6 * 1) from mul_sb;
|
|
select (c6 * -1) from mul_sb;
|
|
select (c6 * 1.0) from mul_sb;
|
|
select (c6 * -1.0) from mul_sb;
|
|
select (c6 * 0.0) from mul_sb;
|
|
select (c6 * 1.1111) from mul_sb;
|
|
select (c6 * 1111111111111) from mul_sb;
|
|
select (c6 * 111.0) from mul_sb;
|
|
select (c6 * 123) from mul_sb;
|
|
select (c6 * 20120101123456) from mul_sb;
|
|
select (c6 * "20120101123456") from mul_sb;
|
|
select (c6 * "helloworld") from mul_sb;
|
|
select (c6 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c6 * "abc") from mul_sb;
|
|
select (c6 * "爱拼才会赢") from mul_sb;
|
|
select (c6 * "A") from mul_sb;
|
|
select (c6 * "a") from mul_sb;
|
|
select (c6 * "%y%m%d") from mul_sb;
|
|
select (c6 * -9223372036854775808) from mul_sb;
|
|
select (c6 * 9223372036854775807) from mul_sb;
|
|
select (c6 * 18446744073709551615) from mul_sb;
|
|
select (c7 * c1) from mul_sb;
|
|
select (c7 * c2) from mul_sb;
|
|
select (c7 * c3) from mul_sb;
|
|
select (c7 * c4) from mul_sb;
|
|
select (c7 * c5) from mul_sb;
|
|
select (c7 * c6) from mul_sb;
|
|
select (c7 * c7) from mul_sb;
|
|
select (c7 * c8) from mul_sb;
|
|
select (c7 * c9) from mul_sb;
|
|
select (c7 * c10) from mul_sb;
|
|
select (c7 * c11) from mul_sb;
|
|
select (c7 * c12) from mul_sb;
|
|
select (c7 * c13) from mul_sb;
|
|
select (c7 * c14) from mul_sb;
|
|
select (c7 * c15) from mul_sb;
|
|
select (c7 * c16) from mul_sb;
|
|
select (c7 * NULL) from mul_sb;
|
|
select (c7 * 0) from mul_sb;
|
|
select (c7 * 1) from mul_sb;
|
|
select (c7 * -1) from mul_sb;
|
|
select (c7 * 1.0) from mul_sb;
|
|
select (c7 * -1.0) from mul_sb;
|
|
select (c7 * 0.0) from mul_sb;
|
|
select (c7 * 1.1111) from mul_sb;
|
|
select (c7 * 1111111111111) from mul_sb;
|
|
select (c7 * 111.0) from mul_sb;
|
|
select (c7 * 123) from mul_sb;
|
|
select (c7 * 20120101123456) from mul_sb;
|
|
select (c7 * "20120101123456") from mul_sb;
|
|
select (c7 * "helloworld") from mul_sb;
|
|
select (c7 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c7 * "abc") from mul_sb;
|
|
select (c7 * "爱拼才会赢") from mul_sb;
|
|
select (c7 * "A") from mul_sb;
|
|
select (c7 * "a") from mul_sb;
|
|
select (c7 * "%y%m%d") from mul_sb;
|
|
select (c7 * -9223372036854775808) from mul_sb;
|
|
select (c7 * 9223372036854775807) from mul_sb;
|
|
select (c7 * 18446744073709551615) from mul_sb;
|
|
select (c8 * c1) from mul_sb;
|
|
select (c8 * c2) from mul_sb;
|
|
select (c8 * c3) from mul_sb;
|
|
select (c8 * c4) from mul_sb;
|
|
select (c8 * c5) from mul_sb;
|
|
select (c8 * c6) from mul_sb;
|
|
select (c8 * c7) from mul_sb;
|
|
select (c8 * c8) from mul_sb;
|
|
select (c8 * c9) from mul_sb;
|
|
select (c8 * c10) from mul_sb;
|
|
select (c8 * c11) from mul_sb;
|
|
select (c8 * c12) from mul_sb;
|
|
select (c8 * c13) from mul_sb;
|
|
select (c8 * c14) from mul_sb;
|
|
select (c8 * c15) from mul_sb;
|
|
select (c8 * c16) from mul_sb;
|
|
select (c8 * NULL) from mul_sb;
|
|
select (c8 * 0) from mul_sb;
|
|
select (c8 * 1) from mul_sb;
|
|
select (c8 * -1) from mul_sb;
|
|
select (c8 * 1.0) from mul_sb;
|
|
select (c8 * -1.0) from mul_sb;
|
|
select (c8 * 0.0) from mul_sb;
|
|
select (c8 * 1.1111) from mul_sb;
|
|
select (c8 * 1111111111111) from mul_sb;
|
|
select (c8 * 111.0) from mul_sb;
|
|
select (c8 * 123) from mul_sb;
|
|
select (c8 * 20120101123456) from mul_sb;
|
|
select (c8 * "20120101123456") from mul_sb;
|
|
select (c8 * "helloworld") from mul_sb;
|
|
select (c8 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c8 * "abc") from mul_sb;
|
|
select (c8 * "爱拼才会赢") from mul_sb;
|
|
select (c8 * "A") from mul_sb;
|
|
select (c8 * "a") from mul_sb;
|
|
select (c8 * "%y%m%d") from mul_sb;
|
|
select (c8 * -9223372036854775808) from mul_sb;
|
|
select (c8 * 9223372036854775807) from mul_sb;
|
|
select (c8 * 18446744073709551615) from mul_sb;
|
|
select (c9 * c1) from mul_sb;
|
|
select (c9 * c2) from mul_sb;
|
|
select (c9 * c3) from mul_sb;
|
|
select (c9 * c4) from mul_sb;
|
|
select (c9 * c5) from mul_sb;
|
|
select (c9 * c6) from mul_sb;
|
|
select (c9 * c7) from mul_sb;
|
|
select (c9 * c8) from mul_sb;
|
|
select (c9 * c9) from mul_sb;
|
|
select (c9 * c10) from mul_sb;
|
|
select (c9 * c11) from mul_sb;
|
|
select (c9 * c12) from mul_sb;
|
|
select (c9 * c13) from mul_sb;
|
|
select (c9 * c14) from mul_sb;
|
|
select (c9 * c15) from mul_sb;
|
|
select (c9 * c16) from mul_sb;
|
|
select (c9 * NULL) from mul_sb;
|
|
select (c9 * 0) from mul_sb;
|
|
select (c9 * 1) from mul_sb;
|
|
select (c9 * -1) from mul_sb;
|
|
select (c9 * 1.0) from mul_sb;
|
|
select (c9 * -1.0) from mul_sb;
|
|
select (c9 * 0.0) from mul_sb;
|
|
select (c9 * 1.1111) from mul_sb;
|
|
select (c9 * 1111111111111) from mul_sb;
|
|
select (c9 * 111.0) from mul_sb;
|
|
select (c9 * 123) from mul_sb;
|
|
select (c9 * 20120101123456) from mul_sb;
|
|
select (c9 * "20120101123456") from mul_sb;
|
|
select (c9 * "helloworld") from mul_sb;
|
|
select (c9 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c9 * "abc") from mul_sb;
|
|
select (c9 * "爱拼才会赢") from mul_sb;
|
|
select (c9 * "A") from mul_sb;
|
|
select (c9 * "a") from mul_sb;
|
|
select (c9 * "%y%m%d") from mul_sb;
|
|
select (c9 * -9223372036854775808) from mul_sb;
|
|
select (c9 * 9223372036854775807) from mul_sb;
|
|
select (c9 * 18446744073709551615) from mul_sb;
|
|
select (c10 * c1) from mul_sb;
|
|
select (c10 * c2) from mul_sb;
|
|
select (c10 * c3) from mul_sb;
|
|
select (c10 * c4) from mul_sb;
|
|
select (c10 * c5) from mul_sb;
|
|
select (c10 * c6) from mul_sb;
|
|
select (c10 * c7) from mul_sb;
|
|
select (c10 * c8) from mul_sb;
|
|
select (c10 * c9) from mul_sb;
|
|
select (c10 * c10) from mul_sb;
|
|
select (c10 * c11) from mul_sb;
|
|
select (c10 * c12) from mul_sb;
|
|
select (c10 * c13) from mul_sb;
|
|
select (c10 * c14) from mul_sb;
|
|
select (c10 * c15) from mul_sb;
|
|
select (c10 * c16) from mul_sb;
|
|
select (c10 * NULL) from mul_sb;
|
|
select (c10 * 0) from mul_sb;
|
|
select (c10 * 1) from mul_sb;
|
|
select (c10 * -1) from mul_sb;
|
|
select (c10 * 1.0) from mul_sb;
|
|
select (c10 * -1.0) from mul_sb;
|
|
select (c10 * 0.0) from mul_sb;
|
|
select (c10 * 1.1111) from mul_sb;
|
|
--error 1690
|
|
select (c10 * 1111111111111) from mul_sb;
|
|
select (c10 * 111.0) from mul_sb;
|
|
select (c10 * 123) from mul_sb;
|
|
--error 1690
|
|
select (c10 * 20120101123456) from mul_sb;
|
|
select (c10 * "20120101123456") from mul_sb;
|
|
select (c10 * "helloworld") from mul_sb;
|
|
select (c10 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c10 * "abc") from mul_sb;
|
|
select (c10 * "爱拼才会赢") from mul_sb;
|
|
select (c10 * "A") from mul_sb;
|
|
select (c10 * "a") from mul_sb;
|
|
select (c10 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (c10 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (c10 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (c10 * 18446744073709551615) from mul_sb;
|
|
select (c11 * c1) from mul_sb;
|
|
select (c11 * c2) from mul_sb;
|
|
select (c11 * c3) from mul_sb;
|
|
select (c11 * c4) from mul_sb;
|
|
select (c11 * c5) from mul_sb;
|
|
select (c11 * c6) from mul_sb;
|
|
select (c11 * c7) from mul_sb;
|
|
select (c11 * c8) from mul_sb;
|
|
select (c11 * c9) from mul_sb;
|
|
select (c11 * c10) from mul_sb;
|
|
select (c11 * c11) from mul_sb;
|
|
select (c11 * c12) from mul_sb;
|
|
select (c11 * c13) from mul_sb;
|
|
select (c11 * c14) from mul_sb;
|
|
select (c11 * c15) from mul_sb;
|
|
select (c11 * c16) from mul_sb;
|
|
select (c11 * NULL) from mul_sb;
|
|
select (c11 * 0) from mul_sb;
|
|
select (c11 * 1) from mul_sb;
|
|
select (c11 * -1) from mul_sb;
|
|
select (c11 * 1.0) from mul_sb;
|
|
select (c11 * -1.0) from mul_sb;
|
|
select (c11 * 0.0) from mul_sb;
|
|
select (c11 * 1.1111) from mul_sb;
|
|
select (c11 * 1111111111111) from mul_sb;
|
|
select (c11 * 111.0) from mul_sb;
|
|
select (c11 * 123) from mul_sb;
|
|
select (c11 * 20120101123456) from mul_sb;
|
|
select (c11 * "20120101123456") from mul_sb;
|
|
select (c11 * "helloworld") from mul_sb;
|
|
select (c11 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c11 * "abc") from mul_sb;
|
|
select (c11 * "爱拼才会赢") from mul_sb;
|
|
select (c11 * "A") from mul_sb;
|
|
select (c11 * "a") from mul_sb;
|
|
select (c11 * "%y%m%d") from mul_sb;
|
|
select (c11 * -9223372036854775808) from mul_sb;
|
|
select (c11 * 9223372036854775807) from mul_sb;
|
|
select (c11 * 18446744073709551615) from mul_sb;
|
|
select (c12 * c1) from mul_sb;
|
|
select (c12 * c2) from mul_sb;
|
|
select (c12 * c3) from mul_sb;
|
|
select (c12 * c4) from mul_sb;
|
|
select (c12 * c5) from mul_sb;
|
|
select (c12 * c6) from mul_sb;
|
|
select (c12 * c7) from mul_sb;
|
|
select (c12 * c8) from mul_sb;
|
|
select (c12 * c9) from mul_sb;
|
|
select (c12 * c10) from mul_sb;
|
|
select (c12 * c11) from mul_sb;
|
|
select (c12 * c12) from mul_sb;
|
|
select (c12 * c13) from mul_sb;
|
|
select (c12 * c14) from mul_sb;
|
|
select (c12 * c15) from mul_sb;
|
|
select (c12 * c16) from mul_sb;
|
|
select (c12 * NULL) from mul_sb;
|
|
select (c12 * 0) from mul_sb;
|
|
select (c12 * 1) from mul_sb;
|
|
select (c12 * -1) from mul_sb;
|
|
select (c12 * 1.0) from mul_sb;
|
|
select (c12 * -1.0) from mul_sb;
|
|
select (c12 * 0.0) from mul_sb;
|
|
select (c12 * 1.1111) from mul_sb;
|
|
select (c12 * 1111111111111) from mul_sb;
|
|
select (c12 * 111.0) from mul_sb;
|
|
select (c12 * 123) from mul_sb;
|
|
select (c12 * 20120101123456) from mul_sb;
|
|
select (c12 * "20120101123456") from mul_sb;
|
|
select (c12 * "helloworld") from mul_sb;
|
|
select (c12 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c12 * "abc") from mul_sb;
|
|
select (c12 * "爱拼才会赢") from mul_sb;
|
|
select (c12 * "A") from mul_sb;
|
|
select (c12 * "a") from mul_sb;
|
|
select (c12 * "%y%m%d") from mul_sb;
|
|
select (c12 * -9223372036854775808) from mul_sb;
|
|
select (c12 * 9223372036854775807) from mul_sb;
|
|
select (c12 * 18446744073709551615) from mul_sb;
|
|
select (c13 * c1) from mul_sb;
|
|
select (c13 * c2) from mul_sb;
|
|
select (c13 * c3) from mul_sb;
|
|
select (c13 * c4) from mul_sb;
|
|
select (c13 * c5) from mul_sb;
|
|
select (c13 * c6) from mul_sb;
|
|
select (c13 * c7) from mul_sb;
|
|
select (c13 * c8) from mul_sb;
|
|
select (c13 * c9) from mul_sb;
|
|
select (c13 * c10) from mul_sb;
|
|
select (c13 * c11) from mul_sb;
|
|
select (c13 * c12) from mul_sb;
|
|
select (c13 * c13) from mul_sb;
|
|
select (c13 * c14) from mul_sb;
|
|
select (c13 * c15) from mul_sb;
|
|
select (c13 * c16) from mul_sb;
|
|
select (c13 * NULL) from mul_sb;
|
|
select (c13 * 0) from mul_sb;
|
|
select (c13 * 1) from mul_sb;
|
|
--error 1690
|
|
select (c13 * -1) from mul_sb;
|
|
select (c13 * 1.0) from mul_sb;
|
|
select (c13 * -1.0) from mul_sb;
|
|
select (c13 * 0.0) from mul_sb;
|
|
select (c13 * 1.1111) from mul_sb;
|
|
select (c13 * 1111111111111) from mul_sb;
|
|
select (c13 * 111.0) from mul_sb;
|
|
select (c13 * 123) from mul_sb;
|
|
select (c13 * 20120101123456) from mul_sb;
|
|
select (c13 * "20120101123456") from mul_sb;
|
|
select (c13 * "helloworld") from mul_sb;
|
|
select (c13 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c13 * "abc") from mul_sb;
|
|
select (c13 * "爱拼才会赢") from mul_sb;
|
|
select (c13 * "A") from mul_sb;
|
|
select (c13 * "a") from mul_sb;
|
|
select (c13 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (c13 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (c13 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (c13 * 18446744073709551615) from mul_sb;
|
|
select (c14 * c1) from mul_sb;
|
|
select (c14 * c2) from mul_sb;
|
|
select (c14 * c3) from mul_sb;
|
|
select (c14 * c4) from mul_sb;
|
|
select (c14 * c5) from mul_sb;
|
|
select (c14 * c6) from mul_sb;
|
|
select (c14 * c7) from mul_sb;
|
|
select (c14 * c8) from mul_sb;
|
|
select (c14 * c9) from mul_sb;
|
|
select (c14 * c10) from mul_sb;
|
|
select (c14 * c11) from mul_sb;
|
|
select (c14 * c12) from mul_sb;
|
|
select (c14 * c13) from mul_sb;
|
|
select (c14 * c14) from mul_sb;
|
|
select (c14 * c15) from mul_sb;
|
|
select (c14 * c16) from mul_sb;
|
|
select (c14 * NULL) from mul_sb;
|
|
select (c14 * 0) from mul_sb;
|
|
select (c14 * 1) from mul_sb;
|
|
select (c14 * -1) from mul_sb;
|
|
select (c14 * 1.0) from mul_sb;
|
|
select (c14 * -1.0) from mul_sb;
|
|
select (c14 * 0.0) from mul_sb;
|
|
select (c14 * 1.1111) from mul_sb;
|
|
select (c14 * 1111111111111) from mul_sb;
|
|
select (c14 * 111.0) from mul_sb;
|
|
select (c14 * 123) from mul_sb;
|
|
select (c14 * 20120101123456) from mul_sb;
|
|
select (c14 * "20120101123456") from mul_sb;
|
|
select (c14 * "helloworld") from mul_sb;
|
|
select (c14 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c14 * "abc") from mul_sb;
|
|
select (c14 * "爱拼才会赢") from mul_sb;
|
|
select (c14 * "A") from mul_sb;
|
|
select (c14 * "a") from mul_sb;
|
|
select (c14 * "%y%m%d") from mul_sb;
|
|
select (c14 * -9223372036854775808) from mul_sb;
|
|
select (c14 * 9223372036854775807) from mul_sb;
|
|
select (c14 * 18446744073709551615) from mul_sb;
|
|
select (c15 * c1) from mul_sb;
|
|
select (c15 * c2) from mul_sb;
|
|
select (c15 * c3) from mul_sb;
|
|
select (c15 * c4) from mul_sb;
|
|
select (c15 * c5) from mul_sb;
|
|
select (c15 * c6) from mul_sb;
|
|
select (c15 * c7) from mul_sb;
|
|
select (c15 * c8) from mul_sb;
|
|
select (c15 * c9) from mul_sb;
|
|
select (c15 * c10) from mul_sb;
|
|
select (c15 * c11) from mul_sb;
|
|
select (c15 * c12) from mul_sb;
|
|
select (c15 * c13) from mul_sb;
|
|
select (c15 * c14) from mul_sb;
|
|
select (c15 * c15) from mul_sb;
|
|
select (c15 * c16) from mul_sb;
|
|
select (c15 * NULL) from mul_sb;
|
|
select (c15 * 0) from mul_sb;
|
|
select (c15 * 1) from mul_sb;
|
|
select (c15 * -1) from mul_sb;
|
|
select (c15 * 1.0) from mul_sb;
|
|
select (c15 * -1.0) from mul_sb;
|
|
select (c15 * 0.0) from mul_sb;
|
|
select (c15 * 1.1111) from mul_sb;
|
|
select (c15 * 1111111111111) from mul_sb;
|
|
select (c15 * 111.0) from mul_sb;
|
|
select (c15 * 123) from mul_sb;
|
|
select (c15 * 20120101123456) from mul_sb;
|
|
select (c15 * "20120101123456") from mul_sb;
|
|
select (c15 * "helloworld") from mul_sb;
|
|
select (c15 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c15 * "abc") from mul_sb;
|
|
select (c15 * "爱拼才会赢") from mul_sb;
|
|
select (c15 * "A") from mul_sb;
|
|
select (c15 * "a") from mul_sb;
|
|
select (c15 * "%y%m%d") from mul_sb;
|
|
select (c15 * -9223372036854775808) from mul_sb;
|
|
select (c15 * 9223372036854775807) from mul_sb;
|
|
select (c15 * 18446744073709551615) from mul_sb;
|
|
select (c16 * c1) from mul_sb;
|
|
select (c16 * c2) from mul_sb;
|
|
select (c16 * c3) from mul_sb;
|
|
select (c16 * c4) from mul_sb;
|
|
select (c16 * c5) from mul_sb;
|
|
select (c16 * c6) from mul_sb;
|
|
select (c16 * c7) from mul_sb;
|
|
select (c16 * c8) from mul_sb;
|
|
select (c16 * c9) from mul_sb;
|
|
select (c16 * c10) from mul_sb;
|
|
select (c16 * c11) from mul_sb;
|
|
select (c16 * c12) from mul_sb;
|
|
select (c16 * c13) from mul_sb;
|
|
select (c16 * c14) from mul_sb;
|
|
select (c16 * c15) from mul_sb;
|
|
select (c16 * c16) from mul_sb;
|
|
select (c16 * NULL) from mul_sb;
|
|
select (c16 * 0) from mul_sb;
|
|
select (c16 * 1) from mul_sb;
|
|
select (c16 * -1) from mul_sb;
|
|
select (c16 * 1.0) from mul_sb;
|
|
select (c16 * -1.0) from mul_sb;
|
|
select (c16 * 0.0) from mul_sb;
|
|
select (c16 * 1.1111) from mul_sb;
|
|
select (c16 * 1111111111111) from mul_sb;
|
|
select (c16 * 111.0) from mul_sb;
|
|
select (c16 * 123) from mul_sb;
|
|
select (c16 * 20120101123456) from mul_sb;
|
|
select (c16 * "20120101123456") from mul_sb;
|
|
select (c16 * "helloworld") from mul_sb;
|
|
select (c16 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (c16 * "abc") from mul_sb;
|
|
select (c16 * "爱拼才会赢") from mul_sb;
|
|
select (c16 * "A") from mul_sb;
|
|
select (c16 * "a") from mul_sb;
|
|
select (c16 * "%y%m%d") from mul_sb;
|
|
select (c16 * -9223372036854775808) from mul_sb;
|
|
select (c16 * 9223372036854775807) from mul_sb;
|
|
select (c16 * 18446744073709551615) from mul_sb;
|
|
select (NULL * c1) from mul_sb;
|
|
select (NULL * c2) from mul_sb;
|
|
select (NULL * c3) from mul_sb;
|
|
select (NULL * c4) from mul_sb;
|
|
select (NULL * c5) from mul_sb;
|
|
select (NULL * c6) from mul_sb;
|
|
select (NULL * c7) from mul_sb;
|
|
select (NULL * c8) from mul_sb;
|
|
select (NULL * c9) from mul_sb;
|
|
select (NULL * c10) from mul_sb;
|
|
select (NULL * c11) from mul_sb;
|
|
select (NULL * c12) from mul_sb;
|
|
select (NULL * c13) from mul_sb;
|
|
select (NULL * c14) from mul_sb;
|
|
select (NULL * c15) from mul_sb;
|
|
select (NULL * c16) from mul_sb;
|
|
select (NULL * NULL) from mul_sb;
|
|
select (NULL * 0) from mul_sb;
|
|
select (NULL * 1) from mul_sb;
|
|
select (NULL * -1) from mul_sb;
|
|
select (NULL * 1.0) from mul_sb;
|
|
select (NULL * -1.0) from mul_sb;
|
|
select (NULL * 0.0) from mul_sb;
|
|
select (NULL * 1.1111) from mul_sb;
|
|
select (NULL * 1111111111111) from mul_sb;
|
|
select (NULL * 111.0) from mul_sb;
|
|
select (NULL * 123) from mul_sb;
|
|
select (NULL * 20120101123456) from mul_sb;
|
|
select (NULL * "20120101123456") from mul_sb;
|
|
select (NULL * "helloworld") from mul_sb;
|
|
select (NULL * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (NULL * "abc") from mul_sb;
|
|
select (NULL * "爱拼才会赢") from mul_sb;
|
|
select (NULL * "A") from mul_sb;
|
|
select (NULL * "a") from mul_sb;
|
|
select (NULL * "%y%m%d") from mul_sb;
|
|
select (NULL * -9223372036854775808) from mul_sb;
|
|
select (NULL * 9223372036854775807) from mul_sb;
|
|
select (NULL * 18446744073709551615) from mul_sb;
|
|
select (0 * c1) from mul_sb;
|
|
select (0 * c2) from mul_sb;
|
|
select (0 * c3) from mul_sb;
|
|
select (0 * c4) from mul_sb;
|
|
select (0 * c5) from mul_sb;
|
|
select (0 * c6) from mul_sb;
|
|
select (0 * c7) from mul_sb;
|
|
select (0 * c8) from mul_sb;
|
|
select (0 * c9) from mul_sb;
|
|
select (0 * c10) from mul_sb;
|
|
select (0 * c11) from mul_sb;
|
|
select (0 * c12) from mul_sb;
|
|
select (0 * c13) from mul_sb;
|
|
select (0 * c14) from mul_sb;
|
|
select (0 * c15) from mul_sb;
|
|
select (0 * c16) from mul_sb;
|
|
select (0 * NULL) from mul_sb;
|
|
select (0 * 0) from mul_sb;
|
|
select (0 * 1) from mul_sb;
|
|
select (0 * -1) from mul_sb;
|
|
select (0 * 1.0) from mul_sb;
|
|
select (0 * -1.0) from mul_sb;
|
|
select (0 * 0.0) from mul_sb;
|
|
select (0 * 1.1111) from mul_sb;
|
|
select (0 * 1111111111111) from mul_sb;
|
|
select (0 * 111.0) from mul_sb;
|
|
select (0 * 123) from mul_sb;
|
|
select (0 * 20120101123456) from mul_sb;
|
|
select (0 * "20120101123456") from mul_sb;
|
|
select (0 * "helloworld") from mul_sb;
|
|
select (0 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (0 * "abc") from mul_sb;
|
|
select (0 * "爱拼才会赢") from mul_sb;
|
|
select (0 * "A") from mul_sb;
|
|
select (0 * "a") from mul_sb;
|
|
select (0 * "%y%m%d") from mul_sb;
|
|
select (0 * -9223372036854775808) from mul_sb;
|
|
select (0 * 9223372036854775807) from mul_sb;
|
|
select (0 * 18446744073709551615) from mul_sb;
|
|
select (1 * c1) from mul_sb;
|
|
select (1 * c2) from mul_sb;
|
|
select (1 * c3) from mul_sb;
|
|
select (1 * c4) from mul_sb;
|
|
select (1 * c5) from mul_sb;
|
|
select (1 * c6) from mul_sb;
|
|
select (1 * c7) from mul_sb;
|
|
select (1 * c8) from mul_sb;
|
|
select (1 * c9) from mul_sb;
|
|
select (1 * c10) from mul_sb;
|
|
select (1 * c11) from mul_sb;
|
|
select (1 * c12) from mul_sb;
|
|
select (1 * c13) from mul_sb;
|
|
select (1 * c14) from mul_sb;
|
|
select (1 * c15) from mul_sb;
|
|
select (1 * c16) from mul_sb;
|
|
select (1 * NULL) from mul_sb;
|
|
select (1 * 0) from mul_sb;
|
|
select (1 * 1) from mul_sb;
|
|
select (1 * -1) from mul_sb;
|
|
select (1 * 1.0) from mul_sb;
|
|
select (1 * -1.0) from mul_sb;
|
|
select (1 * 0.0) from mul_sb;
|
|
select (1 * 1.1111) from mul_sb;
|
|
select (1 * 1111111111111) from mul_sb;
|
|
select (1 * 111.0) from mul_sb;
|
|
select (1 * 123) from mul_sb;
|
|
select (1 * 20120101123456) from mul_sb;
|
|
select (1 * "20120101123456") from mul_sb;
|
|
select (1 * "helloworld") from mul_sb;
|
|
select (1 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (1 * "abc") from mul_sb;
|
|
select (1 * "爱拼才会赢") from mul_sb;
|
|
select (1 * "A") from mul_sb;
|
|
select (1 * "a") from mul_sb;
|
|
select (1 * "%y%m%d") from mul_sb;
|
|
select (1 * -9223372036854775808) from mul_sb;
|
|
select (1 * 9223372036854775807) from mul_sb;
|
|
select (1 * 18446744073709551615) from mul_sb;
|
|
select (-1 * c1) from mul_sb;
|
|
--error 1690
|
|
select (-1 * c2) from mul_sb;
|
|
--error 1690
|
|
select (-1 * c3) from mul_sb;
|
|
--error 1690
|
|
select (-1 * c4) from mul_sb;
|
|
--error 1690
|
|
select (-1 * c5) from mul_sb;
|
|
select (-1 * c6) from mul_sb;
|
|
select (-1 * c7) from mul_sb;
|
|
select (-1 * c8) from mul_sb;
|
|
select (-1 * c9) from mul_sb;
|
|
select (-1 * c10) from mul_sb;
|
|
select (-1 * c11) from mul_sb;
|
|
select (-1 * c12) from mul_sb;
|
|
--error 1690
|
|
select (-1 * c13) from mul_sb;
|
|
select (-1 * c14) from mul_sb;
|
|
select (-1 * c15) from mul_sb;
|
|
select (-1 * c16) from mul_sb;
|
|
select (-1 * NULL) from mul_sb;
|
|
select (-1 * 0) from mul_sb;
|
|
select (-1 * 1) from mul_sb;
|
|
select (-1 * -1) from mul_sb;
|
|
select (-1 * 1.0) from mul_sb;
|
|
select (-1 * -1.0) from mul_sb;
|
|
select (-1 * 0.0) from mul_sb;
|
|
select (-1 * 1.1111) from mul_sb;
|
|
select (-1 * 1111111111111) from mul_sb;
|
|
select (-1 * 111.0) from mul_sb;
|
|
select (-1 * 123) from mul_sb;
|
|
select (-1 * 20120101123456) from mul_sb;
|
|
select (-1 * "20120101123456") from mul_sb;
|
|
select (-1 * "helloworld") from mul_sb;
|
|
select (-1 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (-1 * "abc") from mul_sb;
|
|
select (-1 * "爱拼才会赢") from mul_sb;
|
|
select (-1 * "A") from mul_sb;
|
|
select (-1 * "a") from mul_sb;
|
|
select (-1 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (-1 * -9223372036854775808) from mul_sb;
|
|
select (-1 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (-1 * 18446744073709551615) from mul_sb;
|
|
select (1.0 * c1) from mul_sb;
|
|
select (1.0 * c2) from mul_sb;
|
|
select (1.0 * c3) from mul_sb;
|
|
select (1.0 * c4) from mul_sb;
|
|
select (1.0 * c5) from mul_sb;
|
|
select (1.0 * c6) from mul_sb;
|
|
select (1.0 * c7) from mul_sb;
|
|
select (1.0 * c8) from mul_sb;
|
|
select (1.0 * c9) from mul_sb;
|
|
select (1.0 * c10) from mul_sb;
|
|
select (1.0 * c11) from mul_sb;
|
|
select (1.0 * c12) from mul_sb;
|
|
select (1.0 * c13) from mul_sb;
|
|
select (1.0 * c14) from mul_sb;
|
|
select (1.0 * c15) from mul_sb;
|
|
select (1.0 * c16) from mul_sb;
|
|
select (1.0 * NULL) from mul_sb;
|
|
select (1.0 * 0) from mul_sb;
|
|
select (1.0 * 1) from mul_sb;
|
|
select (1.0 * -1) from mul_sb;
|
|
select (1.0 * 1.0) from mul_sb;
|
|
select (1.0 * -1.0) from mul_sb;
|
|
select (1.0 * 0.0) from mul_sb;
|
|
select (1.0 * 1.1111) from mul_sb;
|
|
select (1.0 * 1111111111111) from mul_sb;
|
|
select (1.0 * 111.0) from mul_sb;
|
|
select (1.0 * 123) from mul_sb;
|
|
select (1.0 * 20120101123456) from mul_sb;
|
|
select (1.0 * "20120101123456") from mul_sb;
|
|
select (1.0 * "helloworld") from mul_sb;
|
|
select (1.0 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (1.0 * "abc") from mul_sb;
|
|
select (1.0 * "爱拼才会赢") from mul_sb;
|
|
select (1.0 * "A") from mul_sb;
|
|
select (1.0 * "a") from mul_sb;
|
|
select (1.0 * "%y%m%d") from mul_sb;
|
|
select (1.0 * -9223372036854775808) from mul_sb;
|
|
select (1.0 * 9223372036854775807) from mul_sb;
|
|
select (1.0 * 18446744073709551615) from mul_sb;
|
|
select (-1.0 * c1) from mul_sb;
|
|
select (-1.0 * c2) from mul_sb;
|
|
select (-1.0 * c3) from mul_sb;
|
|
select (-1.0 * c4) from mul_sb;
|
|
select (-1.0 * c5) from mul_sb;
|
|
select (-1.0 * c6) from mul_sb;
|
|
select (-1.0 * c7) from mul_sb;
|
|
select (-1.0 * c8) from mul_sb;
|
|
select (-1.0 * c9) from mul_sb;
|
|
select (-1.0 * c10) from mul_sb;
|
|
select (-1.0 * c11) from mul_sb;
|
|
select (-1.0 * c12) from mul_sb;
|
|
select (-1.0 * c13) from mul_sb;
|
|
select (-1.0 * c14) from mul_sb;
|
|
select (-1.0 * c15) from mul_sb;
|
|
select (-1.0 * c16) from mul_sb;
|
|
select (-1.0 * NULL) from mul_sb;
|
|
select (-1.0 * 0) from mul_sb;
|
|
select (-1.0 * 1) from mul_sb;
|
|
select (-1.0 * -1) from mul_sb;
|
|
select (-1.0 * 1.0) from mul_sb;
|
|
select (-1.0 * -1.0) from mul_sb;
|
|
select (-1.0 * 0.0) from mul_sb;
|
|
select (-1.0 * 1.1111) from mul_sb;
|
|
select (-1.0 * 1111111111111) from mul_sb;
|
|
select (-1.0 * 111.0) from mul_sb;
|
|
select (-1.0 * 123) from mul_sb;
|
|
select (-1.0 * 20120101123456) from mul_sb;
|
|
select (-1.0 * "20120101123456") from mul_sb;
|
|
select (-1.0 * "helloworld") from mul_sb;
|
|
select (-1.0 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (-1.0 * "abc") from mul_sb;
|
|
select (-1.0 * "爱拼才会赢") from mul_sb;
|
|
select (-1.0 * "A") from mul_sb;
|
|
select (-1.0 * "a") from mul_sb;
|
|
select (-1.0 * "%y%m%d") from mul_sb;
|
|
select (-1.0 * -9223372036854775808) from mul_sb;
|
|
select (-1.0 * 9223372036854775807) from mul_sb;
|
|
select (-1.0 * 18446744073709551615) from mul_sb;
|
|
select (0.0 * c1) from mul_sb;
|
|
select (0.0 * c2) from mul_sb;
|
|
select (0.0 * c3) from mul_sb;
|
|
select (0.0 * c4) from mul_sb;
|
|
select (0.0 * c5) from mul_sb;
|
|
select (0.0 * c6) from mul_sb;
|
|
select (0.0 * c7) from mul_sb;
|
|
select (0.0 * c8) from mul_sb;
|
|
select (0.0 * c9) from mul_sb;
|
|
select (0.0 * c10) from mul_sb;
|
|
select (0.0 * c11) from mul_sb;
|
|
select (0.0 * c12) from mul_sb;
|
|
select (0.0 * c13) from mul_sb;
|
|
select (0.0 * c14) from mul_sb;
|
|
select (0.0 * c15) from mul_sb;
|
|
select (0.0 * c16) from mul_sb;
|
|
select (0.0 * NULL) from mul_sb;
|
|
select (0.0 * 0) from mul_sb;
|
|
select (0.0 * 1) from mul_sb;
|
|
select (0.0 * -1) from mul_sb;
|
|
select (0.0 * 1.0) from mul_sb;
|
|
select (0.0 * -1.0) from mul_sb;
|
|
select (0.0 * 0.0) from mul_sb;
|
|
select (0.0 * 1.1111) from mul_sb;
|
|
select (0.0 * 1111111111111) from mul_sb;
|
|
select (0.0 * 111.0) from mul_sb;
|
|
select (0.0 * 123) from mul_sb;
|
|
select (0.0 * 20120101123456) from mul_sb;
|
|
select (0.0 * "20120101123456") from mul_sb;
|
|
select (0.0 * "helloworld") from mul_sb;
|
|
select (0.0 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (0.0 * "abc") from mul_sb;
|
|
select (0.0 * "爱拼才会赢") from mul_sb;
|
|
select (0.0 * "A") from mul_sb;
|
|
select (0.0 * "a") from mul_sb;
|
|
select (0.0 * "%y%m%d") from mul_sb;
|
|
select (0.0 * -9223372036854775808) from mul_sb;
|
|
select (0.0 * 9223372036854775807) from mul_sb;
|
|
select (0.0 * 18446744073709551615) from mul_sb;
|
|
select (1.1111 * c1) from mul_sb;
|
|
select (1.1111 * c2) from mul_sb;
|
|
select (1.1111 * c3) from mul_sb;
|
|
select (1.1111 * c4) from mul_sb;
|
|
select (1.1111 * c5) from mul_sb;
|
|
select (1.1111 * c6) from mul_sb;
|
|
select (1.1111 * c7) from mul_sb;
|
|
select (1.1111 * c8) from mul_sb;
|
|
select (1.1111 * c9) from mul_sb;
|
|
select (1.1111 * c10) from mul_sb;
|
|
select (1.1111 * c11) from mul_sb;
|
|
select (1.1111 * c12) from mul_sb;
|
|
select (1.1111 * c13) from mul_sb;
|
|
select (1.1111 * c14) from mul_sb;
|
|
select (1.1111 * c15) from mul_sb;
|
|
select (1.1111 * c16) from mul_sb;
|
|
select (1.1111 * NULL) from mul_sb;
|
|
select (1.1111 * 0) from mul_sb;
|
|
select (1.1111 * 1) from mul_sb;
|
|
select (1.1111 * -1) from mul_sb;
|
|
select (1.1111 * 1.0) from mul_sb;
|
|
select (1.1111 * -1.0) from mul_sb;
|
|
select (1.1111 * 0.0) from mul_sb;
|
|
select (1.1111 * 1.1111) from mul_sb;
|
|
select (1.1111 * 1111111111111) from mul_sb;
|
|
select (1.1111 * 111.0) from mul_sb;
|
|
select (1.1111 * 123) from mul_sb;
|
|
select (1.1111 * 20120101123456) from mul_sb;
|
|
select (1.1111 * "20120101123456") from mul_sb;
|
|
select (1.1111 * "helloworld") from mul_sb;
|
|
select (1.1111 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (1.1111 * "abc") from mul_sb;
|
|
select (1.1111 * "爱拼才会赢") from mul_sb;
|
|
select (1.1111 * "A") from mul_sb;
|
|
select (1.1111 * "a") from mul_sb;
|
|
select (1.1111 * "%y%m%d") from mul_sb;
|
|
select (1.1111 * -9223372036854775808) from mul_sb;
|
|
select (1.1111 * 9223372036854775807) from mul_sb;
|
|
select (1.1111 * 18446744073709551615) from mul_sb;
|
|
--error 1690
|
|
select (1111111111111 * c1) from mul_sb;
|
|
--error 1690
|
|
select (1111111111111 * c2) from mul_sb;
|
|
--error 1690
|
|
select (1111111111111 * c3) from mul_sb;
|
|
--error 1690
|
|
select (1111111111111 * c4) from mul_sb;
|
|
--error 1690
|
|
select (1111111111111 * c5) from mul_sb;
|
|
select (1111111111111 * c6) from mul_sb;
|
|
select (1111111111111 * c7) from mul_sb;
|
|
select (1111111111111 * c8) from mul_sb;
|
|
select (1111111111111 * c9) from mul_sb;
|
|
--error 1690
|
|
select (1111111111111 * c10) from mul_sb;
|
|
select (1111111111111 * c11) from mul_sb;
|
|
select (1111111111111 * c12) from mul_sb;
|
|
select (1111111111111 * c13) from mul_sb;
|
|
select (1111111111111 * c14) from mul_sb;
|
|
select (1111111111111 * c15) from mul_sb;
|
|
select (1111111111111 * c16) from mul_sb;
|
|
select (1111111111111 * NULL) from mul_sb;
|
|
select (1111111111111 * 0) from mul_sb;
|
|
select (1111111111111 * 1) from mul_sb;
|
|
select (1111111111111 * -1) from mul_sb;
|
|
select (1111111111111 * 1.0) from mul_sb;
|
|
select (1111111111111 * -1.0) from mul_sb;
|
|
select (1111111111111 * 0.0) from mul_sb;
|
|
select (1111111111111 * 1.1111) from mul_sb;
|
|
--error 1690
|
|
select (1111111111111 * 1111111111111) from mul_sb;
|
|
select (1111111111111 * 111.0) from mul_sb;
|
|
select (1111111111111 * 123) from mul_sb;
|
|
--error 1690
|
|
select (1111111111111 * 20120101123456) from mul_sb;
|
|
select (1111111111111 * "20120101123456") from mul_sb;
|
|
select (1111111111111 * "helloworld") from mul_sb;
|
|
select (1111111111111 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (1111111111111 * "abc") from mul_sb;
|
|
select (1111111111111 * "爱拼才会赢") from mul_sb;
|
|
select (1111111111111 * "A") from mul_sb;
|
|
select (1111111111111 * "a") from mul_sb;
|
|
select (1111111111111 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (1111111111111 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (1111111111111 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (1111111111111 * 18446744073709551615) from mul_sb;
|
|
select (111.0 * c1) from mul_sb;
|
|
select (111.0 * c2) from mul_sb;
|
|
select (111.0 * c3) from mul_sb;
|
|
select (111.0 * c4) from mul_sb;
|
|
select (111.0 * c5) from mul_sb;
|
|
select (111.0 * c6) from mul_sb;
|
|
select (111.0 * c7) from mul_sb;
|
|
select (111.0 * c8) from mul_sb;
|
|
select (111.0 * c9) from mul_sb;
|
|
select (111.0 * c10) from mul_sb;
|
|
select (111.0 * c11) from mul_sb;
|
|
select (111.0 * c12) from mul_sb;
|
|
select (111.0 * c13) from mul_sb;
|
|
select (111.0 * c14) from mul_sb;
|
|
select (111.0 * c15) from mul_sb;
|
|
select (111.0 * c16) from mul_sb;
|
|
select (111.0 * NULL) from mul_sb;
|
|
select (111.0 * 0) from mul_sb;
|
|
select (111.0 * 1) from mul_sb;
|
|
select (111.0 * -1) from mul_sb;
|
|
select (111.0 * 1.0) from mul_sb;
|
|
select (111.0 * -1.0) from mul_sb;
|
|
select (111.0 * 0.0) from mul_sb;
|
|
select (111.0 * 1.1111) from mul_sb;
|
|
select (111.0 * 1111111111111) from mul_sb;
|
|
select (111.0 * 111.0) from mul_sb;
|
|
select (111.0 * 123) from mul_sb;
|
|
select (111.0 * 20120101123456) from mul_sb;
|
|
select (111.0 * "20120101123456") from mul_sb;
|
|
select (111.0 * "helloworld") from mul_sb;
|
|
select (111.0 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (111.0 * "abc") from mul_sb;
|
|
select (111.0 * "爱拼才会赢") from mul_sb;
|
|
select (111.0 * "A") from mul_sb;
|
|
select (111.0 * "a") from mul_sb;
|
|
select (111.0 * "%y%m%d") from mul_sb;
|
|
select (111.0 * -9223372036854775808) from mul_sb;
|
|
select (111.0 * 9223372036854775807) from mul_sb;
|
|
select (111.0 * 18446744073709551615) from mul_sb;
|
|
select (123 * c1) from mul_sb;
|
|
select (123 * c2) from mul_sb;
|
|
--error 1690
|
|
select (123 * c3) from mul_sb;
|
|
--error 1690
|
|
select (123 * c4) from mul_sb;
|
|
--error 1690
|
|
select (123 * c5) from mul_sb;
|
|
select (123 * c6) from mul_sb;
|
|
select (123 * c7) from mul_sb;
|
|
select (123 * c8) from mul_sb;
|
|
select (123 * c9) from mul_sb;
|
|
select (123 * c10) from mul_sb;
|
|
select (123 * c11) from mul_sb;
|
|
select (123 * c12) from mul_sb;
|
|
select (123 * c13) from mul_sb;
|
|
select (123 * c14) from mul_sb;
|
|
select (123 * c15) from mul_sb;
|
|
select (123 * c16) from mul_sb;
|
|
select (123 * NULL) from mul_sb;
|
|
select (123 * 0) from mul_sb;
|
|
select (123 * 1) from mul_sb;
|
|
select (123 * -1) from mul_sb;
|
|
select (123 * 1.0) from mul_sb;
|
|
select (123 * -1.0) from mul_sb;
|
|
select (123 * 0.0) from mul_sb;
|
|
select (123 * 1.1111) from mul_sb;
|
|
select (123 * 1111111111111) from mul_sb;
|
|
select (123 * 111.0) from mul_sb;
|
|
select (123 * 123) from mul_sb;
|
|
select (123 * 20120101123456) from mul_sb;
|
|
select (123 * "20120101123456") from mul_sb;
|
|
select (123 * "helloworld") from mul_sb;
|
|
select (123 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (123 * "abc") from mul_sb;
|
|
select (123 * "爱拼才会赢") from mul_sb;
|
|
select (123 * "A") from mul_sb;
|
|
select (123 * "a") from mul_sb;
|
|
select (123 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (123 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (123 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (123 * 18446744073709551615) from mul_sb;
|
|
--error 1690
|
|
select (20120101123456 * c1) from mul_sb;
|
|
--error 1690
|
|
select (20120101123456 * c2) from mul_sb;
|
|
--error 1690
|
|
select (20120101123456 * c3) from mul_sb;
|
|
--error 1690
|
|
select (20120101123456 * c4) from mul_sb;
|
|
--error 1690
|
|
select (20120101123456 * c5) from mul_sb;
|
|
select (20120101123456 * c6) from mul_sb;
|
|
select (20120101123456 * c7) from mul_sb;
|
|
select (20120101123456 * c8) from mul_sb;
|
|
select (20120101123456 * c9) from mul_sb;
|
|
--error 1690
|
|
select (20120101123456 * c10) from mul_sb;
|
|
select (20120101123456 * c11) from mul_sb;
|
|
select (20120101123456 * c12) from mul_sb;
|
|
select (20120101123456 * c13) from mul_sb;
|
|
select (20120101123456 * c14) from mul_sb;
|
|
select (20120101123456 * c15) from mul_sb;
|
|
select (20120101123456 * c16) from mul_sb;
|
|
select (20120101123456 * NULL) from mul_sb;
|
|
select (20120101123456 * 0) from mul_sb;
|
|
select (20120101123456 * 1) from mul_sb;
|
|
select (20120101123456 * -1) from mul_sb;
|
|
select (20120101123456 * 1.0) from mul_sb;
|
|
select (20120101123456 * -1.0) from mul_sb;
|
|
select (20120101123456 * 0.0) from mul_sb;
|
|
select (20120101123456 * 1.1111) from mul_sb;
|
|
--error 1690
|
|
select (20120101123456 * 1111111111111) from mul_sb;
|
|
select (20120101123456 * 111.0) from mul_sb;
|
|
select (20120101123456 * 123) from mul_sb;
|
|
--error 1690
|
|
select (20120101123456 * 20120101123456) from mul_sb;
|
|
select (20120101123456 * "20120101123456") from mul_sb;
|
|
select (20120101123456 * "helloworld") from mul_sb;
|
|
select (20120101123456 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (20120101123456 * "abc") from mul_sb;
|
|
select (20120101123456 * "爱拼才会赢") from mul_sb;
|
|
select (20120101123456 * "A") from mul_sb;
|
|
select (20120101123456 * "a") from mul_sb;
|
|
select (20120101123456 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (20120101123456 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (20120101123456 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (20120101123456 * 18446744073709551615) from mul_sb;
|
|
select ("20120101123456" * c1) from mul_sb;
|
|
select ("20120101123456" * c2) from mul_sb;
|
|
select ("20120101123456" * c3) from mul_sb;
|
|
select ("20120101123456" * c4) from mul_sb;
|
|
select ("20120101123456" * c5) from mul_sb;
|
|
select ("20120101123456" * c6) from mul_sb;
|
|
select ("20120101123456" * c7) from mul_sb;
|
|
select ("20120101123456" * c8) from mul_sb;
|
|
select ("20120101123456" * c9) from mul_sb;
|
|
select ("20120101123456" * c10) from mul_sb;
|
|
select ("20120101123456" * c11) from mul_sb;
|
|
select ("20120101123456" * c12) from mul_sb;
|
|
select ("20120101123456" * c13) from mul_sb;
|
|
select ("20120101123456" * c14) from mul_sb;
|
|
select ("20120101123456" * c15) from mul_sb;
|
|
select ("20120101123456" * c16) from mul_sb;
|
|
select ("20120101123456" * NULL) from mul_sb;
|
|
select ("20120101123456" * 0) from mul_sb;
|
|
select ("20120101123456" * 1) from mul_sb;
|
|
select ("20120101123456" * -1) from mul_sb;
|
|
select ("20120101123456" * 1.0) from mul_sb;
|
|
select ("20120101123456" * -1.0) from mul_sb;
|
|
select ("20120101123456" * 0.0) from mul_sb;
|
|
select ("20120101123456" * 1.1111) from mul_sb;
|
|
select ("20120101123456" * 1111111111111) from mul_sb;
|
|
select ("20120101123456" * 111.0) from mul_sb;
|
|
select ("20120101123456" * 123) from mul_sb;
|
|
select ("20120101123456" * 20120101123456) from mul_sb;
|
|
select ("20120101123456" * "20120101123456") from mul_sb;
|
|
select ("20120101123456" * "helloworld") from mul_sb;
|
|
select ("20120101123456" * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select ("20120101123456" * "abc") from mul_sb;
|
|
select ("20120101123456" * "爱拼才会赢") from mul_sb;
|
|
select ("20120101123456" * "A") from mul_sb;
|
|
select ("20120101123456" * "a") from mul_sb;
|
|
select ("20120101123456" * "%y%m%d") from mul_sb;
|
|
select ("20120101123456" * -9223372036854775808) from mul_sb;
|
|
select ("20120101123456" * 9223372036854775807) from mul_sb;
|
|
select ("20120101123456" * 18446744073709551615) from mul_sb;
|
|
select ("helloworld" * c1) from mul_sb;
|
|
select ("helloworld" * c2) from mul_sb;
|
|
select ("helloworld" * c3) from mul_sb;
|
|
select ("helloworld" * c4) from mul_sb;
|
|
select ("helloworld" * c5) from mul_sb;
|
|
select ("helloworld" * c6) from mul_sb;
|
|
select ("helloworld" * c7) from mul_sb;
|
|
select ("helloworld" * c8) from mul_sb;
|
|
select ("helloworld" * c9) from mul_sb;
|
|
select ("helloworld" * c10) from mul_sb;
|
|
select ("helloworld" * c11) from mul_sb;
|
|
select ("helloworld" * c12) from mul_sb;
|
|
select ("helloworld" * c13) from mul_sb;
|
|
select ("helloworld" * c14) from mul_sb;
|
|
select ("helloworld" * c15) from mul_sb;
|
|
select ("helloworld" * c16) from mul_sb;
|
|
select ("helloworld" * NULL) from mul_sb;
|
|
select ("helloworld" * 0) from mul_sb;
|
|
select ("helloworld" * 1) from mul_sb;
|
|
select ("helloworld" * -1) from mul_sb;
|
|
select ("helloworld" * 1.0) from mul_sb;
|
|
select ("helloworld" * -1.0) from mul_sb;
|
|
select ("helloworld" * 0.0) from mul_sb;
|
|
select ("helloworld" * 1.1111) from mul_sb;
|
|
select ("helloworld" * 1111111111111) from mul_sb;
|
|
select ("helloworld" * 111.0) from mul_sb;
|
|
select ("helloworld" * 123) from mul_sb;
|
|
select ("helloworld" * 20120101123456) from mul_sb;
|
|
select ("helloworld" * "20120101123456") from mul_sb;
|
|
select ("helloworld" * "helloworld") from mul_sb;
|
|
select ("helloworld" * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select ("helloworld" * "abc") from mul_sb;
|
|
select ("helloworld" * "爱拼才会赢") from mul_sb;
|
|
select ("helloworld" * "A") from mul_sb;
|
|
select ("helloworld" * "a") from mul_sb;
|
|
select ("helloworld" * "%y%m%d") from mul_sb;
|
|
select ("helloworld" * -9223372036854775808) from mul_sb;
|
|
select ("helloworld" * 9223372036854775807) from mul_sb;
|
|
select ("helloworld" * 18446744073709551615) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c1) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c2) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c3) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c4) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c5) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c6) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c7) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c8) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c9) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c10) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c11) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c12) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c13) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c14) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c15) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * c16) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * NULL) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * 0) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * 1) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * -1) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * 1.0) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * -1.0) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * 0.0) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * 1.1111) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * 1111111111111) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * 111.0) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * 123) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * 20120101123456) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * "20120101123456") from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * "helloworld") from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * "abc") from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * "爱拼才会赢") from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * "A") from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * "a") from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * "%y%m%d") from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * -9223372036854775808) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * 9223372036854775807) from mul_sb;
|
|
select ("9999-12-31 23:59:59.9999997" * 18446744073709551615) from mul_sb;
|
|
select ("abc" * c1) from mul_sb;
|
|
select ("abc" * c2) from mul_sb;
|
|
select ("abc" * c3) from mul_sb;
|
|
select ("abc" * c4) from mul_sb;
|
|
select ("abc" * c5) from mul_sb;
|
|
select ("abc" * c6) from mul_sb;
|
|
select ("abc" * c7) from mul_sb;
|
|
select ("abc" * c8) from mul_sb;
|
|
select ("abc" * c9) from mul_sb;
|
|
select ("abc" * c10) from mul_sb;
|
|
select ("abc" * c11) from mul_sb;
|
|
select ("abc" * c12) from mul_sb;
|
|
select ("abc" * c13) from mul_sb;
|
|
select ("abc" * c14) from mul_sb;
|
|
select ("abc" * c15) from mul_sb;
|
|
select ("abc" * c16) from mul_sb;
|
|
select ("abc" * NULL) from mul_sb;
|
|
select ("abc" * 0) from mul_sb;
|
|
select ("abc" * 1) from mul_sb;
|
|
select ("abc" * -1) from mul_sb;
|
|
select ("abc" * 1.0) from mul_sb;
|
|
select ("abc" * -1.0) from mul_sb;
|
|
select ("abc" * 0.0) from mul_sb;
|
|
select ("abc" * 1.1111) from mul_sb;
|
|
select ("abc" * 1111111111111) from mul_sb;
|
|
select ("abc" * 111.0) from mul_sb;
|
|
select ("abc" * 123) from mul_sb;
|
|
select ("abc" * 20120101123456) from mul_sb;
|
|
select ("abc" * "20120101123456") from mul_sb;
|
|
select ("abc" * "helloworld") from mul_sb;
|
|
select ("abc" * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select ("abc" * "abc") from mul_sb;
|
|
select ("abc" * "爱拼才会赢") from mul_sb;
|
|
select ("abc" * "A") from mul_sb;
|
|
select ("abc" * "a") from mul_sb;
|
|
select ("abc" * "%y%m%d") from mul_sb;
|
|
select ("abc" * -9223372036854775808) from mul_sb;
|
|
select ("abc" * 9223372036854775807) from mul_sb;
|
|
select ("abc" * 18446744073709551615) from mul_sb;
|
|
select ("爱拼才会赢" * c1) from mul_sb;
|
|
select ("爱拼才会赢" * c2) from mul_sb;
|
|
select ("爱拼才会赢" * c3) from mul_sb;
|
|
select ("爱拼才会赢" * c4) from mul_sb;
|
|
select ("爱拼才会赢" * c5) from mul_sb;
|
|
select ("爱拼才会赢" * c6) from mul_sb;
|
|
select ("爱拼才会赢" * c7) from mul_sb;
|
|
select ("爱拼才会赢" * c8) from mul_sb;
|
|
select ("爱拼才会赢" * c9) from mul_sb;
|
|
select ("爱拼才会赢" * c10) from mul_sb;
|
|
select ("爱拼才会赢" * c11) from mul_sb;
|
|
select ("爱拼才会赢" * c12) from mul_sb;
|
|
select ("爱拼才会赢" * c13) from mul_sb;
|
|
select ("爱拼才会赢" * c14) from mul_sb;
|
|
select ("爱拼才会赢" * c15) from mul_sb;
|
|
select ("爱拼才会赢" * c16) from mul_sb;
|
|
select ("爱拼才会赢" * NULL) from mul_sb;
|
|
select ("爱拼才会赢" * 0) from mul_sb;
|
|
select ("爱拼才会赢" * 1) from mul_sb;
|
|
select ("爱拼才会赢" * -1) from mul_sb;
|
|
select ("爱拼才会赢" * 1.0) from mul_sb;
|
|
select ("爱拼才会赢" * -1.0) from mul_sb;
|
|
select ("爱拼才会赢" * 0.0) from mul_sb;
|
|
select ("爱拼才会赢" * 1.1111) from mul_sb;
|
|
select ("爱拼才会赢" * 1111111111111) from mul_sb;
|
|
select ("爱拼才会赢" * 111.0) from mul_sb;
|
|
select ("爱拼才会赢" * 123) from mul_sb;
|
|
select ("爱拼才会赢" * 20120101123456) from mul_sb;
|
|
select ("爱拼才会赢" * "20120101123456") from mul_sb;
|
|
select ("爱拼才会赢" * "helloworld") from mul_sb;
|
|
select ("爱拼才会赢" * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select ("爱拼才会赢" * "abc") from mul_sb;
|
|
select ("爱拼才会赢" * "爱拼才会赢") from mul_sb;
|
|
select ("爱拼才会赢" * "A") from mul_sb;
|
|
select ("爱拼才会赢" * "a") from mul_sb;
|
|
select ("爱拼才会赢" * "%y%m%d") from mul_sb;
|
|
select ("爱拼才会赢" * -9223372036854775808) from mul_sb;
|
|
select ("爱拼才会赢" * 9223372036854775807) from mul_sb;
|
|
select ("爱拼才会赢" * 18446744073709551615) from mul_sb;
|
|
select ("A" * c1) from mul_sb;
|
|
select ("A" * c2) from mul_sb;
|
|
select ("A" * c3) from mul_sb;
|
|
select ("A" * c4) from mul_sb;
|
|
select ("A" * c5) from mul_sb;
|
|
select ("A" * c6) from mul_sb;
|
|
select ("A" * c7) from mul_sb;
|
|
select ("A" * c8) from mul_sb;
|
|
select ("A" * c9) from mul_sb;
|
|
select ("A" * c10) from mul_sb;
|
|
select ("A" * c11) from mul_sb;
|
|
select ("A" * c12) from mul_sb;
|
|
select ("A" * c13) from mul_sb;
|
|
select ("A" * c14) from mul_sb;
|
|
select ("A" * c15) from mul_sb;
|
|
select ("A" * c16) from mul_sb;
|
|
select ("A" * NULL) from mul_sb;
|
|
select ("A" * 0) from mul_sb;
|
|
select ("A" * 1) from mul_sb;
|
|
select ("A" * -1) from mul_sb;
|
|
select ("A" * 1.0) from mul_sb;
|
|
select ("A" * -1.0) from mul_sb;
|
|
select ("A" * 0.0) from mul_sb;
|
|
select ("A" * 1.1111) from mul_sb;
|
|
select ("A" * 1111111111111) from mul_sb;
|
|
select ("A" * 111.0) from mul_sb;
|
|
select ("A" * 123) from mul_sb;
|
|
select ("A" * 20120101123456) from mul_sb;
|
|
select ("A" * "20120101123456") from mul_sb;
|
|
select ("A" * "helloworld") from mul_sb;
|
|
select ("A" * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select ("A" * "abc") from mul_sb;
|
|
select ("A" * "爱拼才会赢") from mul_sb;
|
|
select ("A" * "A") from mul_sb;
|
|
select ("A" * "a") from mul_sb;
|
|
select ("A" * "%y%m%d") from mul_sb;
|
|
select ("A" * -9223372036854775808) from mul_sb;
|
|
select ("A" * 9223372036854775807) from mul_sb;
|
|
select ("A" * 18446744073709551615) from mul_sb;
|
|
select ("a" * c1) from mul_sb;
|
|
select ("a" * c2) from mul_sb;
|
|
select ("a" * c3) from mul_sb;
|
|
select ("a" * c4) from mul_sb;
|
|
select ("a" * c5) from mul_sb;
|
|
select ("a" * c6) from mul_sb;
|
|
select ("a" * c7) from mul_sb;
|
|
select ("a" * c8) from mul_sb;
|
|
select ("a" * c9) from mul_sb;
|
|
select ("a" * c10) from mul_sb;
|
|
select ("a" * c11) from mul_sb;
|
|
select ("a" * c12) from mul_sb;
|
|
select ("a" * c13) from mul_sb;
|
|
select ("a" * c14) from mul_sb;
|
|
select ("a" * c15) from mul_sb;
|
|
select ("a" * c16) from mul_sb;
|
|
select ("a" * NULL) from mul_sb;
|
|
select ("a" * 0) from mul_sb;
|
|
select ("a" * 1) from mul_sb;
|
|
select ("a" * -1) from mul_sb;
|
|
select ("a" * 1.0) from mul_sb;
|
|
select ("a" * -1.0) from mul_sb;
|
|
select ("a" * 0.0) from mul_sb;
|
|
select ("a" * 1.1111) from mul_sb;
|
|
select ("a" * 1111111111111) from mul_sb;
|
|
select ("a" * 111.0) from mul_sb;
|
|
select ("a" * 123) from mul_sb;
|
|
select ("a" * 20120101123456) from mul_sb;
|
|
select ("a" * "20120101123456") from mul_sb;
|
|
select ("a" * "helloworld") from mul_sb;
|
|
select ("a" * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select ("a" * "abc") from mul_sb;
|
|
select ("a" * "爱拼才会赢") from mul_sb;
|
|
select ("a" * "A") from mul_sb;
|
|
select ("a" * "a") from mul_sb;
|
|
select ("a" * "%y%m%d") from mul_sb;
|
|
select ("a" * -9223372036854775808) from mul_sb;
|
|
select ("a" * 9223372036854775807) from mul_sb;
|
|
select ("a" * 18446744073709551615) from mul_sb;
|
|
select ("%y%m%d" * c1) from mul_sb;
|
|
select ("%y%m%d" * c2) from mul_sb;
|
|
select ("%y%m%d" * c3) from mul_sb;
|
|
select ("%y%m%d" * c4) from mul_sb;
|
|
select ("%y%m%d" * c5) from mul_sb;
|
|
select ("%y%m%d" * c6) from mul_sb;
|
|
select ("%y%m%d" * c7) from mul_sb;
|
|
select ("%y%m%d" * c8) from mul_sb;
|
|
select ("%y%m%d" * c9) from mul_sb;
|
|
select ("%y%m%d" * c10) from mul_sb;
|
|
select ("%y%m%d" * c11) from mul_sb;
|
|
select ("%y%m%d" * c12) from mul_sb;
|
|
select ("%y%m%d" * c13) from mul_sb;
|
|
select ("%y%m%d" * c14) from mul_sb;
|
|
select ("%y%m%d" * c15) from mul_sb;
|
|
select ("%y%m%d" * c16) from mul_sb;
|
|
select ("%y%m%d" * NULL) from mul_sb;
|
|
select ("%y%m%d" * 0) from mul_sb;
|
|
select ("%y%m%d" * 1) from mul_sb;
|
|
select ("%y%m%d" * -1) from mul_sb;
|
|
select ("%y%m%d" * 1.0) from mul_sb;
|
|
select ("%y%m%d" * -1.0) from mul_sb;
|
|
select ("%y%m%d" * 0.0) from mul_sb;
|
|
select ("%y%m%d" * 1.1111) from mul_sb;
|
|
select ("%y%m%d" * 1111111111111) from mul_sb;
|
|
select ("%y%m%d" * 111.0) from mul_sb;
|
|
select ("%y%m%d" * 123) from mul_sb;
|
|
select ("%y%m%d" * 20120101123456) from mul_sb;
|
|
select ("%y%m%d" * "20120101123456") from mul_sb;
|
|
select ("%y%m%d" * "helloworld") from mul_sb;
|
|
select ("%y%m%d" * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select ("%y%m%d" * "abc") from mul_sb;
|
|
select ("%y%m%d" * "爱拼才会赢") from mul_sb;
|
|
select ("%y%m%d" * "A") from mul_sb;
|
|
select ("%y%m%d" * "a") from mul_sb;
|
|
select ("%y%m%d" * "%y%m%d") from mul_sb;
|
|
select ("%y%m%d" * -9223372036854775808) from mul_sb;
|
|
select ("%y%m%d" * 9223372036854775807) from mul_sb;
|
|
select ("%y%m%d" * 18446744073709551615) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * c1) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * c2) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * c3) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * c4) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * c5) from mul_sb;
|
|
select (-9223372036854775808 * c6) from mul_sb;
|
|
select (-9223372036854775808 * c7) from mul_sb;
|
|
select (-9223372036854775808 * c8) from mul_sb;
|
|
select (-9223372036854775808 * c9) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * c10) from mul_sb;
|
|
select (-9223372036854775808 * c11) from mul_sb;
|
|
select (-9223372036854775808 * c12) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * c13) from mul_sb;
|
|
select (-9223372036854775808 * c14) from mul_sb;
|
|
select (-9223372036854775808 * c15) from mul_sb;
|
|
select (-9223372036854775808 * c16) from mul_sb;
|
|
select (-9223372036854775808 * NULL) from mul_sb;
|
|
select (-9223372036854775808 * 0) from mul_sb;
|
|
select (-9223372036854775808 * 1) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * -1) from mul_sb;
|
|
select (-9223372036854775808 * 1.0) from mul_sb;
|
|
select (-9223372036854775808 * -1.0) from mul_sb;
|
|
select (-9223372036854775808 * 0.0) from mul_sb;
|
|
select (-9223372036854775808 * 1.1111) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * 1111111111111) from mul_sb;
|
|
select (-9223372036854775808 * 111.0) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * 123) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * 20120101123456) from mul_sb;
|
|
select (-9223372036854775808 * "20120101123456") from mul_sb;
|
|
select (-9223372036854775808 * "helloworld") from mul_sb;
|
|
select (-9223372036854775808 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (-9223372036854775808 * "abc") from mul_sb;
|
|
select (-9223372036854775808 * "爱拼才会赢") from mul_sb;
|
|
select (-9223372036854775808 * "A") from mul_sb;
|
|
select (-9223372036854775808 * "a") from mul_sb;
|
|
select (-9223372036854775808 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (-9223372036854775808 * 18446744073709551615) from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * c1) from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * c2) from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * c3) from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * c4) from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * c5) from mul_sb;
|
|
select (9223372036854775807 * c6) from mul_sb;
|
|
select (9223372036854775807 * c7) from mul_sb;
|
|
select (9223372036854775807 * c8) from mul_sb;
|
|
select (9223372036854775807 * c9) from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * c10) from mul_sb;
|
|
select (9223372036854775807 * c11) from mul_sb;
|
|
select (9223372036854775807 * c12) from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * c13) from mul_sb;
|
|
select (9223372036854775807 * c14) from mul_sb;
|
|
select (9223372036854775807 * c15) from mul_sb;
|
|
select (9223372036854775807 * c16) from mul_sb;
|
|
select (9223372036854775807 * NULL) from mul_sb;
|
|
select (9223372036854775807 * 0) from mul_sb;
|
|
select (9223372036854775807 * 1) from mul_sb;
|
|
select (9223372036854775807 * -1) from mul_sb;
|
|
select (9223372036854775807 * 1.0) from mul_sb;
|
|
select (9223372036854775807 * -1.0) from mul_sb;
|
|
select (9223372036854775807 * 0.0) from mul_sb;
|
|
select (9223372036854775807 * 1.1111) from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * 1111111111111) from mul_sb;
|
|
select (9223372036854775807 * 111.0) from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * 123) from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * 20120101123456) from mul_sb;
|
|
select (9223372036854775807 * "20120101123456") from mul_sb;
|
|
select (9223372036854775807 * "helloworld") from mul_sb;
|
|
select (9223372036854775807 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (9223372036854775807 * "abc") from mul_sb;
|
|
select (9223372036854775807 * "爱拼才会赢") from mul_sb;
|
|
select (9223372036854775807 * "A") from mul_sb;
|
|
select (9223372036854775807 * "a") from mul_sb;
|
|
select (9223372036854775807 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (9223372036854775807 * 18446744073709551615) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * c1) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * c2) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * c3) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * c4) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * c5) from mul_sb;
|
|
select (18446744073709551615 * c6) from mul_sb;
|
|
select (18446744073709551615 * c7) from mul_sb;
|
|
select (18446744073709551615 * c8) from mul_sb;
|
|
select (18446744073709551615 * c9) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * c10) from mul_sb;
|
|
select (18446744073709551615 * c11) from mul_sb;
|
|
select (18446744073709551615 * c12) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * c13) from mul_sb;
|
|
select (18446744073709551615 * c14) from mul_sb;
|
|
select (18446744073709551615 * c15) from mul_sb;
|
|
select (18446744073709551615 * c16) from mul_sb;
|
|
select (18446744073709551615 * NULL) from mul_sb;
|
|
select (18446744073709551615 * 0) from mul_sb;
|
|
select (18446744073709551615 * 1) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * -1) from mul_sb;
|
|
select (18446744073709551615 * 1.0) from mul_sb;
|
|
select (18446744073709551615 * -1.0) from mul_sb;
|
|
select (18446744073709551615 * 0.0) from mul_sb;
|
|
select (18446744073709551615 * 1.1111) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * 1111111111111) from mul_sb;
|
|
select (18446744073709551615 * 111.0) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * 123) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * 20120101123456) from mul_sb;
|
|
select (18446744073709551615 * "20120101123456") from mul_sb;
|
|
select (18446744073709551615 * "helloworld") from mul_sb;
|
|
select (18446744073709551615 * "9999-12-31 23:59:59.9999997") from mul_sb;
|
|
select (18446744073709551615 * "abc") from mul_sb;
|
|
select (18446744073709551615 * "爱拼才会赢") from mul_sb;
|
|
select (18446744073709551615 * "A") from mul_sb;
|
|
select (18446744073709551615 * "a") from mul_sb;
|
|
select (18446744073709551615 * "%y%m%d") from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * -9223372036854775808) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * 9223372036854775807) from mul_sb;
|
|
--error 1690
|
|
select (18446744073709551615 * 18446744073709551615) from mul_sb;
|
|
drop table mul_sb;
|
|
|
|
--disable_warnings
|
|
drop table if exists h1;
|
|
CREATE TABLE h1(
|
|
case_id int,
|
|
c1 BIGINT unsigned,
|
|
c2 BIGINT unsigned);
|
|
|
|
insert into h1 values(1, 1, 1);
|
|
insert into h1 values(2, 4294967297, 4294967295); # (2^32 + 1) * (2^32 - 1)
|
|
insert into h1 values(3, 8589934591, 8589934591); # (2^33 - 1) * (2^33 - 1)
|
|
insert into h1 values(4, 17179869183, 4294967295); # (2^34 - 1) * (2^32 - 1)
|
|
insert into h1 values(5, 4294967295, 17179869183); # (2^32 - 1) * (2^34 - 1)
|
|
insert into h1 values(6, 8589934591, 4294967295); # (2^33 - 1) * (2^32 - 1)
|
|
insert into h1 values(7, 4294967295, 8589934591); # (2^32 - 1) * (2^33 - 1)
|
|
|
|
select * from h1;
|
|
select c1 * c2 from h1 where case_id = 1;
|
|
select c1 * c2 from h1 where case_id = 2;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 3;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 4;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 5;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 6;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 7;
|
|
|
|
--disable_warnings
|
|
drop table if exists h1;
|
|
CREATE TABLE h1(
|
|
case_id int,
|
|
c1 bigint,
|
|
c2 bigint);
|
|
|
|
insert into h1 values(1, 1, 1);
|
|
insert into h1 values(2, 1, -1);
|
|
insert into h1 values(3, -1, 1);
|
|
insert into h1 values(4, -1, -1);
|
|
insert into h1 values(5, 2147483647, 4294967297); # (2^31 - 1) * (2^32 + 1)
|
|
insert into h1 values(6, 4294967297, 2147483647); # (2^32 + 1) * (2^31 - 1)
|
|
insert into h1 values(7, -2147483647, 4294967297); # (-2^31 + 1) * (2^32 + 1)
|
|
insert into h1 values(8, 4294967297, -2147483647); # (2^32 + 1) * (-2^31 + 1)
|
|
insert into h1 values(9, 2147483647, -4294967297); # (2^31 - 1) * (-2^32 - 1)
|
|
insert into h1 values(10, -4294967297, 2147483647); # (-2^32 - 1) * (2^31 - 1)
|
|
insert into h1 values(11, -2147483647, -4294967297); # (-2^31 + 1) * (-2^32 - 1)
|
|
insert into h1 values(12, -4294967297, -2147483647); # (-2^32 - 1) * (-2^31 + 1)
|
|
insert into h1 values(13, 9223372036854775807, 1); # (2^63 - 1) * 1
|
|
insert into h1 values(14, 1, 9223372036854775807); # 1 * (2^63 - 1)
|
|
insert into h1 values(15, 9223372036854775807, -1); # (2^63 - 1) * (-1)
|
|
insert into h1 values(16, -1, 9223372036854775807); # (-1) * (2^63 - 1)
|
|
insert into h1 values(17, -9223372036854775807, 1); # (-2^63 + 1) * 1
|
|
insert into h1 values(18, 1, -9223372036854775807); # 1 * (-2^63 + 1)
|
|
insert into h1 values(19, -9223372036854775808, 1); # (-2^63) * 1
|
|
insert into h1 values(20, 1, -9223372036854775808); # 1 * (-2^63)
|
|
insert into h1 values(21, 2, -4611686018427387904); # 2 * (-2^62)
|
|
insert into h1 values(22, -4611686018427387904, 2); # (-2^62) * 2
|
|
insert into h1 values(23, -2, 4611686018427387904); # -2 * (2^62)
|
|
insert into h1 values(24, 4611686018427387904, -2); # (2^62) * 2
|
|
|
|
insert into h1 values(25, 2, 4611686018427387904); # 2 * (2^62)
|
|
insert into h1 values(26, 4611686018427387904, 2); # (2^62) * 2
|
|
insert into h1 values(27, -2, -4611686018427387904); # -2 * (2^62)
|
|
insert into h1 values(28, -4611686018427387904, -2); # (2^62) * 2
|
|
insert into h1 values(29, 9223372036854775807, 2); # (2^63 - 1) * 2
|
|
insert into h1 values(30, 2, 9223372036854775807); # 2 * (2^63 - 1)
|
|
insert into h1 values(31, -9223372036854775808, -1); # (-2^63) * (-1)
|
|
insert into h1 values(32, -1, -9223372036854775808); # (-1) * (-2^63)
|
|
insert into h1 values(33, 2147483649, 4294967295); # (2^31 + 1) * (2^32 - 1)
|
|
insert into h1 values(34, 4294967295, 2147483649); # (2^32 - 1) * (2^31 + 1)
|
|
insert into h1 values(35, -2147483649, 4294967295); # (-2^31 - 1) * (2^32 - 1)
|
|
insert into h1 values(36, 4294967295, -2147483649); # (2^32 - 1) * (-2^31 - 1)
|
|
insert into h1 values(37, 2147483649, -4294967295); # (2^31 + 1) * (-2^32 + 1)
|
|
insert into h1 values(38, -4294967295, 2147483649); # (-2^32 + 1) * (2^31 + 1)
|
|
insert into h1 values(39, -2147483649, -4294967295); # (-2^31 - 1) * (-2^32 + 1)
|
|
insert into h1 values(40, -4294967295, -2147483649); # (-2^32 + 1) * (-2^31 - 1)
|
|
|
|
select * from h1;
|
|
select c1 * c2 from h1 where case_id = 1;
|
|
select c1 * c2 from h1 where case_id = 2;
|
|
select c1 * c2 from h1 where case_id = 3;
|
|
select c1 * c2 from h1 where case_id = 4;
|
|
select c1 * c2 from h1 where case_id = 5;
|
|
select c1 * c2 from h1 where case_id = 6;
|
|
select c1 * c2 from h1 where case_id = 7;
|
|
select c1 * c2 from h1 where case_id = 8;
|
|
select c1 * c2 from h1 where case_id = 9;
|
|
select c1 * c2 from h1 where case_id = 10;
|
|
select c1 * c2 from h1 where case_id = 11;
|
|
select c1 * c2 from h1 where case_id = 12;
|
|
select c1 * c2 from h1 where case_id = 13;
|
|
select c1 * c2 from h1 where case_id = 14;
|
|
select c1 * c2 from h1 where case_id = 15;
|
|
select c1 * c2 from h1 where case_id = 16;
|
|
select c1 * c2 from h1 where case_id = 17;
|
|
select c1 * c2 from h1 where case_id = 18;
|
|
select c1 * c2 from h1 where case_id = 19;
|
|
select c1 * c2 from h1 where case_id = 20;
|
|
select c1 * c2 from h1 where case_id = 21;
|
|
select c1 * c2 from h1 where case_id = 22;
|
|
select c1 * c2 from h1 where case_id = 23;
|
|
select c1 * c2 from h1 where case_id = 24;
|
|
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 25;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 26;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 27;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 28;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 29;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 30;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 31;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 32;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 33;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 34;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 35;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 36;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 37;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 38;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 39;
|
|
--error 1690
|
|
select c1 * c2 from h1 where case_id = 40; |