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

LP:930814 - Missing columns in information_schema.COLUMNS for tables with virtual columns

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • None
    • None

    Description

      Developing on Windows XP32 and MariaDB 5.3.3, I needed columns in 'information_schema.COLUMNS' from the table dbw2.s_kunden. But they are missing.

      Normally, when you query
      SELECT * FROM information_schema.COLUMNS
      it should show the columns of all tables in the databases. Instead, from database dbw2 only the columns of the table 'vorgangsartliste' shows up.

      Funny enough, if you create a view named 'v_kunden' with
      SELECT * FROM s_kunden
      the columns of the view show up in information_schema.COLUMNS.

      If you create a clone table 's_kunden2' with the output of
      SHOW CREATE TABLE s_kunden
      the columns of this clone don't show up in information_schema.COLUMNS.

      IF you issue an
      SHOW COLUMNS FROM s_kunden, the result is as expected.

      OS: Windows 32 Bit
      Tested Maria versions: 5.3.3, 5.2.10
      How to repeat:
      1. Unzip archive "data.7z" to the datadir and run mysqld.
      2. Start mysql (root has no pw) and issue following query:
      SELECT * FROM information_schema.COLUMNS WHERE TABLE_SCHEMA='dbw2';
      3. What we should see are all columns of all 3 tables.
      Instead, we only see 3 columns from table vorgangsartliste.

      Hint: In table 's_kunden', columns 'online_rma' and 'aktiv' are both of type 'virtual'. If you remove these 2, the remaining columns show up in information_schema.COLUMNS.

      Attachments

        1. LPexportBug930814.xml
          15 kB
          Rasmus Johansson
        2. LPexportBug930814_data.7z
          119 kB
          Rasmus Johansson

        Activity

          People

            igor Igor Babaev (Inactive)
            nbrnhardt nbrnhardt (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 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.