Details
-
Bug
-
Status: Stalled (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.4(EOL), 10.5, 10.6, 10.10(EOL), 10.11, 11.0(EOL), 11.1(EOL)
-
None
Description
The test case is not suitable for the regression suite, don't push it as is, create a deterministic one instead!
--source include/have_sequence.inc
|
|
|
--connect(con1,localhost,root,,)
|
--send
|
select * from seq_1_to_10000000 where seq%1000000 = 0; |
|
|
--connection default
|
--let $run= 10
|
while ($run)
|
{
|
--sleep 1 |
query_vertical select * from information_schema.processlist where id != connection_id(); |
--dec $run |
}
|
|
|
--connection con1
|
--reap |
|
10.4 9b5275b8 |
select * from information_schema.processlist where id != connection_id(); |
ID 5
|
USER root |
HOST localhost
|
DB test
|
COMMAND Query
|
TIME 10 |
STATE Sending data
|
INFO select * from seq_1_to_10000000 where seq%1000000 = 0 |
TIME_MS 10031.634
|
STAGE 0
|
MAX_STAGE 0
|
PROGRESS 0.000
|
MEMORY_USED 106424
|
MAX_MEMORY_USED 106424
|
EXAMINED_ROWS 0
|
QUERY_ID 23
|
INFO_BINARY select * from seq_1_to_10000000 where seq%1000000 = 0 |
TID 2218428
|
connection con1; |
seq
|
1000000
|
2000000
|
3000000
|
4000000
|
5000000
|
6000000
|
7000000
|
8000000
|
9000000
|
10000000
|
Reproducible on all existing versions.
Attachments
Issue Links
- relates to
-
MDEV-3953 Add columns for ROWS_EXAMINED & ROWS_SENT to I_S and processlist
-
- Closed
-