Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
Issue seen in gcol.gcol_ins_upd_innodb
Issue:
---------
Difference in explain output
How to repro
source [^capture.txt]
|
source context1.txt
|
First Explain:
+------+-------------+-------+-------+---------------+---------+---------+-------+------+--------------------------------+ |
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | |
+------+-------------+-------+-------+---------------+---------+---------+-------+------+--------------------------------+ |
| 1 | PRIMARY | OUTR1 | const | PRIMARY | PRIMARY | 4 | const | 1 | | |
| 1 | PRIMARY | INNR1 | ALL | NULL | NULL | NULL | NULL | 2 | Using where; FirstMatch(OUTR1) | |
| 1 | PRIMARY | OUTR2 | ALL | NULL | NULL | NULL | NULL | 2 | | |
+------+-------------+-------+-------+---------------+---------+---------+-------+------+--------------------------------+ |
[code}
|
 |
h6.Replay:
|
{code:sql}
|
+------+-------------+-------+------+---------------+------+---------+------+------+-----------------------------------------------------+ |
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | |
+------+-------------+-------+------+---------------+------+---------+------+------+-----------------------------------------------------+ |
| 1 | PRIMARY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables | |
+------+-------------+-------+------+---------------+------+---------+------+------+---------------------------------------------------- |