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

PROCEDURE ANALYSE() is silently ignored on INFORMATION_SCHEMA.TABLES

    XMLWordPrintable

Details

    • Not for Release Notes

    Description

      PROCEDURE ANALYSE() is silently ignored on INFORMATION_SCHEMA.TABLES

      SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='mysql' AND TABLE_NAME='user' PROCEDURE ANALYSE();
      

      CLI Output

      13.1.0-opt>SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='mysql' AND TABLE_NAME='user' PROCEDURE ANALYSE();
      +------------+
      | TABLE_NAME |
      +------------+
      | user       |
      +------------+
      1 row in set (0.000 sec)
       
      13.1.0-opt>
      

      Expected output

      13.1.1-opt>SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='mysql' AND TABLE_NAME='user' PROCEDURE ANALYSE();
      +--------------------------------------+-----------+-----------+------------+------------+------------------+-------+-------------------------+------+-----------------------+
      | Field_name                           | Min_value | Max_value | Min_length | Max_length | Empties_or_zeros | Nulls | Avg_value_or_avg_length | Std  | Optimal_fieldtype     |
      +--------------------------------------+-----------+-----------+------------+------------+------------------+-------+-------------------------+------+-----------------------+
      | information_schema.TABLES.TABLE_NAME | user      | user      |          4 |          4 |                0 |     0 | 4.0000                  | NULL | ENUM('user') NOT NULL |
      +--------------------------------------+-----------+-----------+------------+------------+------------------+-------+-------------------------+------+-----------------------+
      1 row in set (0.001 sec)
       
      13.1.1-opt>
      

      Attachments

        Issue Links

          Activity

            People

              janlindstrom Jan Lindström
              ramesh Ramesh Sivaraman
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0d
                  0d
                  Logged:
                  Time Spent - 0.5h
                  0.5h

                  Git Integration

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