Debian Codegraph @

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

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