Bug #17905 More flexibel show syntacs
Submitted: 3 Mar 2006 19:45 Modified: 10 Mar 2006 18:49
Reporter: Andre Timmer Email Updates:
Status: Won't fix Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:MySQL 5.0.18 OS:Any (all)
Assigned to: CPU Architecture:Any

[3 Mar 2006 19:45] Andre Timmer 
Description:
Result of show syntacs is uncustomizable.

How to repeat:
Example:
- show index from <table> or any other show command

Suggested fix:
Allow for alle non statements that are not customizable the following syntacs:
- select * from (<statement>) aa where ...

The idea is that the result of these statements can be treated as virtuable tables.

Statements that apply:
- show ...
- explain ...
[3 Mar 2006 19:50] Andre Timmer 
Example: 
  
  select * 
  from   (show engines) aa
  where support = 'YES'
  order by engine;
[5 Mar 2006 8:50] Valeriy Kravchuk 
Thank you for a feature request. I am not sure it will be ever implemented, though. We have INFORMATION_SCHEMA now, just for that purpose: to get metadata in a flexible and customizable way.
[10 Mar 2006 18:49] Andre Timmer 
Thanks, yes i admit this request is a strange one.