Debian Codegraph @

mysql-test/suite/gcol/inc/gcol_supported_sql_funcs.inc

raw
1 ################################################################################
2 # inc/gcol_supported_sql_funcs.inc #
3 # #
4 # Purpose: #
5 # Tests frame for allowed sql functions #
6 # #
7 # #
8 #------------------------------------------------------------------------------#
9 # Original Author: Andrey Zhakov #
10 # Original Date: 2008-08-31 #
11 # Change Author: #
12 # Change Date: #
13 # Change: #
14 ################################################################################
15
16 --enable_warnings
17 set sql_warnings = 1;
18 eval create table t1 ($cols);
19 show create table t1;
20 if ($rows)
21 {
22 # Allow out-of-range errors
23 --error 0,1264,1690,3020
24 eval insert into t1 values ($values1);
25 dec $rows;
26 }
27 if ($rows)
28 {
29 --error 0,1292,1690,3020
30 eval insert into t1 values ($values2);
31 dec $rows;
32 }
33 if ($rows)
34 {
35 --error 0,1690,3020
36 eval insert into t1 values ($values3);
37 dec $rows;
38 }
39 if ($rows)
40 {
41 eval insert into t1 values ($values4);
42 dec $rows;
43 }
44 --sorted_result
45 select * from t1;
46 drop table t1;
47 set sql_warnings = 0;