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