mysqltest_ps.result 1.06 KB
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
select 1 + "2 a";
1 + "2 a"
3
Warnings:
Warning	1292	Truncated incorrect DOUBLE value: '2 a'
create table t (a int primary key, b blob default '');
Warnings:
Warning	1101	BLOB/TEXT column 'b' can't have a default value
select a, (2*a) AS a from t group by a;
a	a
Warnings:
Warning	1052	Column 'a' in group statement is ambiguous
drop table t;
select 1 + "2 a";
1 + "2 a"
3
Warnings:
Warning	1292	Truncated incorrect DOUBLE value: '2 a'
create table t (a int primary key, b blob default '');
Warnings:
Warning	1101	BLOB/TEXT column 'b' can't have a default value
select a, (2*a) AS a from t group by a;
a	a
Warnings:
Warning	1052	Column 'a' in group statement is ambiguous
Warning	1052	Column 'a' in group statement is ambiguous
drop table t;
select 1 + "2 a";
1 + "2 a"
3
Warnings:
Warning	1292	Truncated incorrect DOUBLE value: '2 a'
create table t (a int primary key, b blob default '');
Warnings:
Warning	1101	BLOB/TEXT column 'b' can't have a default value
select a, (2*a) AS a from t group by a;
a	a
Warnings:
Warning	1052	Column 'a' in group statement is ambiguous
drop table t;