12
12
create table t1(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
13
13
engine = <engine_to_be_tested>;
14
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' into table t1;
14
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' into table t1;
15
15
create table t2(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
16
16
engine = <engine_to_be_tested>;
17
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' into table t2;
17
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' into table t2;
18
18
create table t3(f1 char(20),f2 char(20),f3 integer) engine = <engine_to_be_tested>;
19
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t3.txt' into table t3;
19
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t3.txt' into table t3;
20
20
create table t4(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
21
21
engine = <engine_to_be_tested>;
22
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' into table t4;
22
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' into table t4;
23
23
USE db_storedproc_1;
24
24
create table t6(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
25
25
engine = <engine_to_be_tested>;
26
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' into table t6;
26
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' into table t6;
28
28
create table t7 (f1 char(20), f2 char(25), f3 date, f4 int)
29
29
engine = <engine_to_be_tested>;
30
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t7.txt' into table t7;
30
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' into table t7;
32
32
Warning 1265 Data truncated for column 'f3' at row 1
33
33
Warning 1265 Data truncated for column 'f3' at row 2
41
41
Warning 1265 Data truncated for column 'f3' at row 10
42
42
create table t8 (f1 char(20), f2 char(25), f3 date, f4 int)
43
43
engine = <engine_to_be_tested>;
44
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t7.txt' into table t8;
44
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t7.txt' into table t8;
46
46
Warning 1265 Data truncated for column 'f3' at row 1
47
47
Warning 1265 Data truncated for column 'f3' at row 2
54
54
Warning 1265 Data truncated for column 'f3' at row 9
55
55
Warning 1265 Data truncated for column 'f3' at row 10
56
56
create table t9(f1 int, f2 char(25), f3 int) engine = <engine_to_be_tested>;
57
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t9.txt' into table t9;
57
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t9.txt' into table t9;
58
58
create table t10(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
59
59
engine = <engine_to_be_tested>;
60
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' into table t10;
60
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' into table t10;
61
61
create table t11(f1 char(20),f2 char(25),f3 date,f4 int,f5 char(25),f6 int)
62
62
engine = <engine_to_be_tested>;
63
load data infile '<MYSQLTEST_VARDIR>/std_data_ln/funcs_1/t4.txt' into table t11;
63
load data infile '<MYSQLTEST_VARDIR>/std_data/funcs_1/t4.txt' into table t11;
65
65
Section 3.1.1 - Syntax checks for the CREATE PROCEDURE, CREATE
66
66
FUNCTION, ALTER PROCEDURE, ALTER FUNCTION, DROP PROCEDURE, DROP FUNCTION, SHOW
92
92
ERROR 42000: Identifier name 'sp1_thisisaveryverylongname234872934_thisisaveryverylongnameabcde' is too long
93
93
CALL sp1_thisisaveryverylongname234872934_thisisaveryverylongnameabcde( 'abc' );
94
94
ERROR 42000: Identifier name 'sp1_thisisaveryverylongname234872934_thisisaveryverylongnameabcde' is too long
95
SHOW PROCEDURE STATUS;
95
SHOW PROCEDURE STATUS WHERE db = 'db_storedproc';
96
96
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
97
97
DROP PROCEDURE IF EXISTS sp1;
98
98
CREATE PROCEDURE sp1( f1 BINARY )
108
108
Warning 1265 Data truncated for column 'f1' at row 1
109
SHOW PROCEDURE STATUS;
109
SHOW PROCEDURE STATUS WHERE db = 'db_storedproc';
110
110
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
111
111
db_storedproc sp1 PROCEDURE root@localhost <modified> <created> INVOKER this is simple latin1 latin1_swedish_ci latin1_swedish_ci
112
112
DROP PROCEDURE IF EXISTS sp1;
122
SHOW PROCEDURE STATUS;
122
SHOW PROCEDURE STATUS WHERE db = 'db_storedproc';
123
123
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
124
124
db_storedproc sp1 PROCEDURE root@localhost <modified> <created> INVOKER this is simple latin1 latin1_swedish_ci latin1_swedish_ci
125
125
DROP PROCEDURE IF EXISTS sp1;
135
SHOW PROCEDURE STATUS;
135
SHOW PROCEDURE STATUS WHERE db = 'db_storedproc';
136
136
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
137
137
db_storedproc sp1 PROCEDURE root@localhost <modified> <created> INVOKER this is simple latin1 latin1_swedish_ci latin1_swedish_ci
138
138
DROP PROCEDURE IF EXISTS sp1;
176
SHOW PROCEDURE STATUS;
176
SHOW PROCEDURE STATUS WHERE db = 'db_storedproc';
177
177
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
178
178
db_storedproc sproc_1 PROCEDURE root@localhost <modified> <created> INVOKER this is simple latin1 latin1_swedish_ci latin1_swedish_ci
179
SHOW FUNCTION STATUS;
179
SHOW FUNCTION STATUS WHERE db = 'db_storedproc';
180
180
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
181
181
db_storedproc func_1 FUNCTION root@localhost <modified> <created> INVOKER this is simple latin1 latin1_swedish_ci latin1_swedish_ci
182
182
UPDATE t1_aux SET f1 = NULL;
1418
1418
Note 1291 Column '' has duplicated value 'value1' in ENUM
1419
SHOW PROCEDURE STATUS;
1419
SHOW PROCEDURE STATUS WHERE db = 'db_storedproc';
1420
1420
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
1421
1421
db_storedproc sp1 PROCEDURE root@localhost <modified> <created> INVOKER this is simple latin1 latin1_swedish_ci latin1_swedish_ci
1422
1422
DROP PROCEDURE IF EXISTS sp1;
1434
1434
Note 1291 Column '' has duplicated value 'value1' in SET
1435
1435
Warning 1265 Data truncated for column 'f1' at row 1
1436
SHOW PROCEDURE STATUS;
1436
SHOW PROCEDURE STATUS WHERE db = 'db_storedproc';
1437
1437
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
1438
1438
db_storedproc sp1 PROCEDURE root@localhost <modified> <created> INVOKER this is simple latin1 latin1_swedish_ci latin1_swedish_ci
1439
1439
DROP PROCEDURE IF EXISTS sp1;
1451
1451
Note 1291 Column '' has duplicated value 'value1' in ENUM
1452
SHOW PROCEDURE STATUS;
1452
SHOW PROCEDURE STATUS WHERE db = 'db_storedproc';
1453
1453
Db Name Type Definer Modified Created Security_type Comment character_set_client collation_connection Database Collation
1454
1454
db_storedproc sp1 PROCEDURE root@localhost <modified> <created> INVOKER this is simple latin1 latin1_swedish_ci latin1_swedish_ci
1455
1455
DROP PROCEDURE IF EXISTS sp1;