1# 2# Test mysqltest in --ps-protocol mode. 3# 4 5if (`SELECT $PS_PROTOCOL = 0`) 6{ 7 --skip Need ps-protocol 8} 9 10# 11# Test the --enable_prepare_warnings command. 12# Test default value (off), enabling, and disabling. 13# 14 15--enable_warnings 16 17select 1 + "2 a"; 18create table t (a int primary key, b blob default ''); 19# This statement gives warning both during prepare and execute. 20# So gives double warnings when --enable_prepare_warnings. 21select a, (2*a) AS a from t group by a; 22drop table t; 23 24--enable_prepare_warnings 25select 1 + "2 a"; 26create table t (a int primary key, b blob default ''); 27select a, (2*a) AS a from t group by a; 28drop table t; 29 30--disable_prepare_warnings 31select 1 + "2 a"; 32create table t (a int primary key, b blob default ''); 33select a, (2*a) AS a from t group by a; 34drop table t; 35