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 set sql_warnings = 1;
17 eval create table t1 ($cols) charset latin1;
18 show create table t1;
19 if ($rows)
20 {
21 # Allow out-of-range errors
22 --error 0,1264,1690,3020
23 eval insert into t1 values ($values1);
24 dec $rows;
25 }
26 if ($rows)
27 {
28 --error 0,1292,1690,3020
29 eval insert into t1 values ($values2);
30 dec $rows;
31 }
32 if ($rows)
33 {
34 --error 0,1690,3020
35 eval insert into t1 values ($values3);
36 dec $rows;
37 }
38 if ($rows)
39 {
40 eval insert into t1 values ($values4);
41 dec $rows;
42 }
43 --sorted_result
44 select * from t1;
45 drop table t1;
46 set sql_warnings = 0;