[MDEV-4477] Why this columns? Created: 2013-05-03  Updated: 2013-05-03  Resolved: 2013-05-03

Status: Closed
Project: MariaDB Server
Component/s: None
Fix Version/s: None

Type: Epic Priority: Trivial
Reporter: roberto spadim Assignee: Unassigned
Resolution: Not a Bug Votes: 0
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



 Comments   
Comment by Sergei Golubchik [ 2013-05-03 ]

This is neither a bug nor a feature request. Please ask your questions on the maria-discuss@lists.launchpad.net mailing list.

Generated at Thu Feb 08 06:56:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.