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

Information schema queries return empty result set

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3.14, 10.3.15, 10.3, 10.4
    • 10.4
    • Information Schema
    • None
    • Windows 10 64 bit

    Description

      For some reason following query returns empty result set in 10.3.14 and 10.3.15 version.

      SELECT table_name,table_name, ordinal_position
      FROM information_schema.table_constraints t
      JOIN information_schema.key_column_usage k
      USING(constraint_name,table_name)
      WHERE t.constraint_type='PRIMARY KEY'
      AND t.table_schema= 'demodb'
      AND k.table_schema= 'demodb'

      order by table_name,ordinal_position;

      But following does work:

      SELECT * FROM (SELECT t.table_name, k.column_name, ordinal_position
      FROM information_schema.table_constraints t
      JOIN information_schema.key_column_usage k
      USING(constraint_name,table_name)
      WHERE t.constraint_type='PRIMARY KEY'
      AND t.table_schema= 'demodb'
      AND k.table_schema= 'demodb') tmp

      order by table_name,ordinal_position

      Attachments

        Activity

          People

            sanja Oleksandr Byelkin
            Blockman Petri Luukkonen
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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