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