mirror of
https://github.com/MariaDB/server.git
synced 2025-02-07 06:12:18 +01:00
0a5e4a0191
Updated tests: cases with bugs or which cannot be run with the cursor-protocol were excluded with "--disable_cursor_protocol"/"--enable_cursor_protocol" Fix for v.10.5
135 lines
2.3 KiB
Text
135 lines
2.3 KiB
Text
--echo
|
|
--echo # --
|
|
--echo # -- Test case for Bug#21818.
|
|
--echo # --
|
|
--echo
|
|
|
|
--disable_warnings
|
|
DROP TABLE IF EXISTS t1;
|
|
--enable_warnings
|
|
|
|
CREATE TABLE t1(a INT);
|
|
INSERT INTO t1 VALUES (1), (2), (3);
|
|
|
|
--echo
|
|
--echo # -- Check 1.
|
|
|
|
--disable_warnings
|
|
--enable_info
|
|
--echo SELECT * FROM t1 INTO OUTFILE "MYSQL_TMP_DIR/bug21818.txt";
|
|
--disable_query_log # to avoid $MYSQL_TMP_DIR in query log
|
|
--disable_cursor_protocol
|
|
--disable_ps2_protocol
|
|
--eval SELECT * FROM t1 INTO OUTFILE "$MYSQL_TMP_DIR/bug21818.txt"
|
|
--enable_ps2_protocol
|
|
--enable_cursor_protocol
|
|
--enable_query_log
|
|
--disable_info
|
|
|
|
--echo
|
|
--disable_ps2_protocol
|
|
SELECT ROW_COUNT();
|
|
--enable_ps2_protocol
|
|
|
|
--echo
|
|
--echo # -- Check 2.
|
|
|
|
--disable_cursor_protocol
|
|
--enable_info
|
|
SELECT a FROM t1 LIMIT 1 INTO @a;
|
|
--disable_info
|
|
--enable_cursor_protocol
|
|
|
|
--echo
|
|
--disable_ps2_protocol
|
|
SELECT ROW_COUNT();
|
|
--enable_ps2_protocol
|
|
|
|
--enable_warnings
|
|
--echo
|
|
--echo # -- Check 3.
|
|
|
|
--disable_warnings
|
|
DROP DATABASE IF EXISTS mysqltest1;
|
|
--enable_warnings
|
|
|
|
--enable_info
|
|
CREATE DATABASE mysqltest1;
|
|
--disable_info
|
|
|
|
--echo
|
|
--disable_ps2_protocol
|
|
SELECT ROW_COUNT();
|
|
--enable_ps2_protocol
|
|
|
|
DROP DATABASE mysqltest1;
|
|
|
|
--echo
|
|
--echo # -- Check 4.
|
|
|
|
DELETE FROM t1;
|
|
|
|
--enable_info
|
|
--echo LOAD DATA INFILE 'MYSQL_TMP_DIR/bug21818.txt' INTO TABLE t1(a);
|
|
--disable_query_log # to avoid $MYSQL_TMP_DIR in query log
|
|
--eval LOAD DATA INFILE '$MYSQL_TMP_DIR/bug21818.txt' INTO TABLE t1(a)
|
|
--enable_query_log
|
|
--disable_info
|
|
|
|
--echo
|
|
--disable_ps2_protocol
|
|
SELECT ROW_COUNT();
|
|
--enable_ps2_protocol
|
|
|
|
--remove_file $MYSQL_TMP_DIR/bug21818.txt
|
|
|
|
--echo
|
|
--echo # -- Check 5.
|
|
|
|
--enable_info
|
|
ALTER TABLE t1 ADD COLUMN b VARCHAR(255);
|
|
--disable_info
|
|
|
|
--echo
|
|
--disable_ps2_protocol
|
|
SELECT ROW_COUNT();
|
|
--enable_ps2_protocol
|
|
|
|
--echo
|
|
DROP TABLE t1;
|
|
|
|
--echo
|
|
--echo # -- Check 6.
|
|
|
|
--disable_warnings
|
|
DROP TABLE IF EXISTS t2;
|
|
--enable_warnings
|
|
|
|
CREATE TABLE t1(a INT);
|
|
CREATE TABLE t2(a INT);
|
|
|
|
INSERT INTO t1 VALUES (1), (2), (3);
|
|
INSERT INTO t2 VALUES (ROW_COUNT());
|
|
|
|
SELECT * FROM t2;
|
|
|
|
DROP TABLE t1;
|
|
DROP TABLE t2;
|
|
|
|
--echo
|
|
--echo # -- Check 7 (check that SQL errors reset row_count to -1).
|
|
|
|
CREATE TABLE t1(a INT);
|
|
|
|
INSERT INTO t1 VALUES (1), (2), (3);
|
|
--error ER_SP_DOES_NOT_EXIST
|
|
SELECT f1();
|
|
|
|
--disable_ps2_protocol
|
|
SELECT ROW_COUNT();
|
|
--enable_ps2_protocol
|
|
|
|
DROP TABLE t1;
|
|
|
|
--echo
|
|
--echo # -- End of test case for Bug#21818.
|