Bug #2476 Missing description of "unique_subquery" in EXPLAIN documentation
Submitted: 22 Jan 2004 0:36 Modified: 2 Feb 2004 12:34
Reporter: Andrey Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:4.1.1-alpha OS:
Assigned to: Oleksandr Byelkin CPU Architecture:Any

[22 Jan 2004 0:36] Andrey
I've got "unique_subquery" value in "type" column after executing EXPLAIN.
There is no description of this word in documentation.

Does it same the "const" ?

Is it good/normal/bad if it the last line in EXPLAIN result?

How to repeat:
SELECT objects.* FROM objects WHERE class_id 
   IN(SELECT id FROM Class WHERE some_id=121)

All tables are InnoDB.
[2 Feb 2004 5:09] Oleksandr Byelkin
  1.1207 04/02/02 15:03:42 bell@sanja.is.com.ua +1 -0 
  unique_subquery & index_subquery description (BUG#2474)
[2 Feb 2004 12:34] Oleksandr Byelkin
thank you for bugreport, manual is fixed now.