Details
-
Type:
Epic
-
Status: Closed
-
Priority:
Trivial
-
Resolution: Not a Bug
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
-
Epic Name:SHOW queries
Description
Hi guys, i was asking to some friends and they couldn't answer me...
why some queries have 'standard' results, and why use these results?
example...
SHOW PROCESSLIST
why it result in like?
SELECT
ID AS Id, USER AS User, HOST AS Host, DB AS Db, COMMAND AS Command, TIME AS Time,
STATE AS State, SUBSTRING(INFO,1,100) AS Info, PROGRESS AS Progress
FROM information_schema.PROCESSLIST
Inside code, is it hardcoded to rewrite query?
Could i change this 'default query'?
the same for
SHOW TABLES
SHOW DATABASES
....
could they be rewrite in another 'style'?
for example, i run don't run show processlist because it return time without microseconds and return just 100bytes of query string
could i rewrite the 'internal query' of show processlist? what about others 'shows' queries?
just a question, anyone told me a reason why this results are used
maybe a old mysql 1.0 standard? be compatible with tools of year 1987?
bye 
Gliffy Diagrams
Attachments
Issues in Epic
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
This is neither a bug nor a feature request. Please ask your questions on the maria-discuss@lists.launchpad.net mailing list.