Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.9(EOL), 10.10(EOL), 11.0(EOL), 11.1(EOL), 11.2(EOL)
-
None
-
None
Description
Information is incorrectly written when executing queries "SELECT " from table t1.
Testcase:
Options for MTR test (.opt file):
--log-output=table,file --slow-query-log --general-log |
Case:
SET SESSION long_query_time = 0; |
SET GLOBAL slow_query_log = ON; |
FLUSH LOGS;
|
TRUNCATE TABLE mysql.slow_log; |
|
# Let there be three columns, unique, non-unique, and non-indexed: |
CREATE TABLE t1 (f1 SERIAL,f2 INT, f3 INT, PRIMARY KEY(f1), KEY(f2)); |
INSERT INTO t1 VALUES (1,1,1); |
INSERT INTO t1 VALUES (2,2,2); |
INSERT INTO t1 VALUES (3,3,3); |
INSERT INTO t1 VALUES (4,4,4); |
|
SELECT SQL_NO_CACHE 'Bug#31700 - SCAN',f1,f2,f3,SLEEP(1.1) FROM t1 WHERE f3=4; |
SELECT SQL_NO_CACHE 'Bug#31700 - KEY', f1,f2,f3,SLEEP(1.1) FROM t1 WHERE f2=3; |
SELECT SQL_NO_CACHE 'Bug#31700 - PK', f1,f2,f3,SLEEP(1.1) FROM t1 WHERE f1=2; |
|
--replace_column 1 TIMESTAMP
|
SELECT start_time, rows_examined, rows_sent, sql_text FROM mysql.slow_log WHERE sql_text LIKE '%Bug#31700%' ORDER BY start_time; |
|
DROP TABLE t1; |
|
TRUNCATE TABLE mysql.slow_log; |
Expected result:
start_time rows_examined rows_sent sql_text
|
TIMESTAMP 4 1 SELECT SQL_NO_CACHE 'Bug#31700 - SCAN',f1,f2,f3,SLEEP(1.1) FROM t1 WHERE f3=4 |
TIMESTAMP 1 1 SELECT SQL_NO_CACHE 'Bug#31700 - KEY', f1,f2,f3,SLEEP(1.1) FROM t1 WHERE f2=3 |
TIMESTAMP 1 1 SELECT SQL_NO_CACHE 'Bug#31700 - PK', f1,f2,f3,SLEEP(1.1) FROM t1 WHERE f1=2 |
Actual result (v. 10.4, 10.4):
start_time rows_examined rows_sent sql_text
|
TIMESTAMP 4 0 SELECT SQL_NO_CACHE 'Bug#31700 - SCAN',f1,f2,f3,SLEEP(1.1) FROM t1 WHERE f3=4 |
TIMESTAMP 1 0 SELECT SQL_NO_CACHE 'Bug#31700 - KEY', f1,f2,f3,SLEEP(1.1) FROM t1 WHERE f2=3 |
TIMESTAMP 1 0 SELECT SQL_NO_CACHE 'Bug#31700 - PK', f1,f2,f3,SLEEP(1.1) FROM t1 WHERE f1=2 |
Actual result (from v.10.6):
start_time rows_examined rows_sent sql_text
|
Attachments
Issue Links
- relates to
-
MDEV-31005 Make working ./mtr --cursor-protocol
- Stalled