Debian Codegraph @

mysql-test/suite/funcs_1/t/row_count_func.test

raw
1 --echo
2 --echo # --
3 --echo # -- Test case for Bug#21818.
4 --echo # --
5 --echo
6
7 CREATE TABLE t1(a INT);
8 INSERT INTO t1 VALUES (1), (2), (3);
9
10 --echo
11 --echo # -- Check 1.
12
13 --disable_warnings
14 --enable_info
15 --echo SELECT * FROM t1 INTO OUTFILE "MYSQL_TMP_DIR/bug21818.txt";
16 --disable_query_log # to avoid $MYSQL_TMP_DIR in query log
17 --eval SELECT * FROM t1 INTO OUTFILE "$MYSQL_TMP_DIR/bug21818.txt"
18 --enable_query_log
19 --disable_info
20
21 --echo
22 --disable_ps2_protocol
23 SELECT ROW_COUNT();
24 --enable_ps2_protocol
25
26 --echo
27 --echo # -- Check 2.
28
29 --enable_info
30 SELECT a FROM t1 LIMIT 1 INTO @a;
31 --disable_info
32
33 --echo
34 --disable_ps2_protocol
35 SELECT ROW_COUNT();
36 --enable_ps2_protocol
37
38 --enable_warnings
39 --echo
40 --echo # -- Check 3.
41
42 --disable_warnings
43 DROP DATABASE IF EXISTS mysqltest1;
44 --enable_warnings
45
46 --enable_info
47 CREATE DATABASE mysqltest1;
48 --disable_info
49
50 --echo
51 --disable_ps2_protocol
52 SELECT ROW_COUNT();
53 --enable_ps2_protocol
54
55 DROP DATABASE mysqltest1;
56
57 --echo
58 --echo # -- Check 4.
59
60 DELETE FROM t1;
61
62 --enable_info
63 --echo LOAD DATA INFILE 'MYSQL_TMP_DIR/bug21818.txt' INTO TABLE t1(a);
64 --disable_query_log # to avoid $MYSQL_TMP_DIR in query log
65 --eval LOAD DATA INFILE '$MYSQL_TMP_DIR/bug21818.txt' INTO TABLE t1(a)
66 --enable_query_log
67 --disable_info
68
69 --echo
70 --disable_ps2_protocol
71 SELECT ROW_COUNT();
72 --enable_ps2_protocol
73
74 --remove_file $MYSQL_TMP_DIR/bug21818.txt
75
76 --echo
77 --echo # -- Check 5.
78
79 --enable_info
80 ALTER TABLE t1 ADD COLUMN b VARCHAR(255);
81 --disable_info
82
83 --echo
84 --disable_ps2_protocol
85 SELECT ROW_COUNT();
86 --enable_ps2_protocol
87
88 --echo
89 DROP TABLE t1;
90
91 --echo
92 --echo # -- Check 6.
93
94 --disable_warnings
95 DROP TABLE IF EXISTS t2;
96 --enable_warnings
97
98 CREATE TABLE t1(a INT);
99 CREATE TABLE t2(a INT);
100
101 INSERT INTO t1 VALUES (1), (2), (3);
102 INSERT INTO t2 VALUES (ROW_COUNT());
103
104 SELECT * FROM t2;
105
106 DROP TABLE t1;
107 DROP TABLE t2;
108
109 --echo
110 --echo # -- Check 7 (check that SQL errors reset row_count to -1).
111
112 CREATE TABLE t1(a INT);
113
114 INSERT INTO t1 VALUES (1), (2), (3);
115 --error ER_SP_DOES_NOT_EXIST
116 SELECT f1();
117
118 --disable_ps2_protocol
119 SELECT ROW_COUNT();
120 --enable_ps2_protocol
121
122 DROP TABLE t1;
123
124 --echo
125 --echo # -- End of test case for Bug#21818.