Debian Codegraph @

mysql-test/suite/funcs_1/r/row_count_func.result

raw
1
2 # --
3 # -- Test case for Bug#21818.
4 # --
5
6 CREATE TABLE t1(a INT);
7 INSERT INTO t1 VALUES (1), (2), (3);
8
9 # -- Check 1.
10 SELECT * FROM t1 INTO OUTFILE "MYSQL_TMP_DIR/bug21818.txt";
11 affected rows: 3
12
13 SELECT ROW_COUNT();
14 ROW_COUNT()
15 3
16
17 # -- Check 2.
18 SELECT a FROM t1 LIMIT 1 INTO @a;
19 affected rows: 1
20
21 SELECT ROW_COUNT();
22 ROW_COUNT()
23 1
24
25 # -- Check 3.
26 DROP DATABASE IF EXISTS mysqltest1;
27 CREATE DATABASE mysqltest1;
28 affected rows: 1
29
30 SELECT ROW_COUNT();
31 ROW_COUNT()
32 1
33 DROP DATABASE mysqltest1;
34
35 # -- Check 4.
36 DELETE FROM t1;
37 LOAD DATA INFILE 'MYSQL_TMP_DIR/bug21818.txt' INTO TABLE t1(a);
38 affected rows: 3
39 info: Records: 3 Deleted: 0 Skipped: 0 Warnings: 0
40
41 SELECT ROW_COUNT();
42 ROW_COUNT()
43 3
44
45 # -- Check 5.
46 ALTER TABLE t1 ADD COLUMN b VARCHAR(255);
47 affected rows: 3
48 info: Records: 3 Duplicates: 0 Warnings: 0
49
50 SELECT ROW_COUNT();
51 ROW_COUNT()
52 3
53
54 DROP TABLE t1;
55
56 # -- Check 6.
57 DROP TABLE IF EXISTS t2;
58 CREATE TABLE t1(a INT);
59 CREATE TABLE t2(a INT);
60 INSERT INTO t1 VALUES (1), (2), (3);
61 INSERT INTO t2 VALUES (ROW_COUNT());
62 SELECT * FROM t2;
63 a
64 3
65 DROP TABLE t1;
66 DROP TABLE t2;
67
68 # -- Check 7 (check that SQL errors reset row_count to -1).
69 CREATE TABLE t1(a INT);
70 INSERT INTO t1 VALUES (1), (2), (3);
71 SELECT f1();
72 ERROR 42000: FUNCTION test.f1 does not exist
73 SELECT ROW_COUNT();
74 ROW_COUNT()
75 -1
76 DROP TABLE t1;
77
78 # -- End of test case for Bug#21818.