mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 02:46:29 +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
33 lines
798 B
Text
33 lines
798 B
Text
# Tests will be skipped for the view protocol because the view protocol creates
|
|
# an additional util connection and other statistics data
|
|
-- source include/no_view_protocol.inc
|
|
|
|
--disable_warnings
|
|
DROP TABLE IF EXISTS t1;
|
|
--enable_warnings
|
|
|
|
CREATE TABLE t1 (a INT, INDEX (a));
|
|
INSERT INTO t1 VALUES (),(),(),(),(),(),(),(),(),();
|
|
|
|
--disable_cursor_protocol
|
|
--disable_ps2_protocol
|
|
FLUSH STATUS;
|
|
SELECT a FROM t1 ORDER BY a LIMIT 1;
|
|
SHOW STATUS LIKE 'HANDLER_READ%';
|
|
|
|
FLUSH STATUS;
|
|
SELECT a FROM t1 ORDER BY a DESC LIMIT 1;
|
|
SHOW STATUS LIKE 'HANDLER_READ%';
|
|
|
|
FLUSH STATUS;
|
|
SELECT a FROM t1 ORDER BY a LIMIT 3;
|
|
SHOW STATUS LIKE 'HANDLER_READ%';
|
|
|
|
FLUSH STATUS;
|
|
SELECT a FROM t1 ORDER BY a DESC LIMIT 3;
|
|
SHOW STATUS LIKE 'HANDLER_READ%';
|
|
--enable_ps2_protocol
|
|
--enable_cursor_protocol
|
|
|
|
DROP TABLE t1;
|
|
|