use test;
drop table if exists t1, t2 ;
create table t1 ( a int, b varchar(30), primary key(a)) ;
insert into t1 values (1,'one');
insert into t1 values (2,'two');
commit ;
select 1 < (select a from t1) ;
ERROR 21000: Subquery returns more than 1 row
select 'here comes a static line' as column_name ;
column_name
here comes a static line
select 1 < (select a from t1) ;
ERROR 21000: Subquery returns more than 1 row
select 1 < (select a from t1) ;
ERROR 21000: Subquery returns more than 1 row
select 'here comes a static line' as column_name ;
column_name
here comes a static line
create table t2 ( a int, b varchar(30), primary key(a)) ;
commit ;
select 1 < (select a from t1) ;
ERROR 21000: Subquery returns more than 1 row
select a as column_name from t2 ;
column_name
drop table t1, t2;