|
Replies:
1
-
Pages:
1
-
Last Post:
Aug 10, 2011 10:53 AM
by: Mauritz
|
|
|
Posts:
1
Registered:
7/1/11
|
|
|
|
Explain plan display error.
Posted:
Aug 10, 2011 1:25 AM
|
|
|
Toad can't display explain plan with ID column NULL.
Error "Error
Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."
Problem row from MySQL console
+----+--------------+-------------------+--------+-----------------------------+---------+---------+----------------------------------------------------+---------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+--------------+-------------------+--------+-----------------------------+---------+---------+----------------------------------------------------+---------+---------------------------------+
| NULL | UNION RESULT | <union2,6> | ALL | NULL | NULL | NULL | NULL | NULL | |
|
|
|
Posts:
314
Registered:
8/23/07
|
|
|
|
Re: Explain plan display error.
Posted:
Aug 10, 2011 10:53 AM
in response to: bfs_921
|
|
|
Any chance that you could post the create table script of the table(s) and the query you are trying to describe so that we can replicate this issue?
|
|
|
|
Legend
|
|
Guru: 2001
+
pts
|
|
Expert: 751
- 2000
pts
|
|
Enthusiast: 31
- 750
pts
|
|
Novice: 0
- 30
pts
|
|
Moderators
|
|
Helpful answer
(5 pts)
|
|
Answered
(10 pts)
|
|
