mariadb/mysql-test/main/mysqltest_ps.test

#
# Test mysqltest in --ps-protocol mode.
#

if (`SELECT $PS_PROTOCOL = 0`)
{
   --skip Need ps-protocol
}

#
# Test the --enable_prepare_warnings command.
# Test default value (off), enabling, and disabling.
#

--enable_warnings

select 1 + "2 a";
create table t (a int primary key, b blob default '');
# This statement gives warning both during prepare and execute.
# So gives double warnings when --enable_prepare_warnings.
select a, (2*a) AS a from t group by a;
drop table t;

--enable_prepare_warnings
select 1 + "2 a";
create table t (a int primary key, b blob default '');
select a, (2*a) AS a from t group by a;
drop table t;

--disable_prepare_warnings
select 1 + "2 a";
create table t (a int primary key, b blob default '');
select a, (2*a) AS a from t group by a;
drop table t;