Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-4477

Why this columns?

    XMLWordPrintable

Details

    • Epic
    • Status: Closed (View Workflow)
    • Trivial
    • Resolution: Not a Bug
    • None
    • None
    • None
    • 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

      Attachments

        Activity

          People

            Unassigned Unassigned
            rspadim roberto spadim
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.