Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1733

COMMENT='schema sync only' fails silently

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Not a Bug
    • 1.1.6
    • Icebox
    • MDB Plugin
    • None
    • 2PM system on Docker Ubuntu 18.04.1 LTS

    Description

      This works as expected:

      create table t2 (c1 int) engine=columnstore;
      Query OK, 0 rows affected (0.21 sec)
       
      MariaDB [test]> select count(*) from t2;
      +----------+
      | count(*) |
      +----------+
      |        0 |
      +----------+
      1 row in set (0.05 sec)
       
      select * from calpontsys.systable where tablename='t2';
      +-----------+--------+----------+------------+------------+------+------+-----------+-----------+-------------+---------------+
      | tablename | schema | objectid | createdate | lastupdate | init | next | numofrows | avgrowlen | numofblocks | autoincrement |
      +-----------+--------+----------+------------+------------+------+------+-----------+-----------+-------------+---------------+
      | t2        | test   |     3292 | 2018-09-20 | NULL       | NULL | NULL |      NULL |      NULL |        NULL |             0 |
      +-----------+--------+----------+------------+------------+------+------+-----------+-----------+-------------+---------------+
      1 row in set (0.01 sec)
      
      

      This does not work as expected:

      create table t3 (c1 int) engine=columnstore COMMENT='schema sync only';
      Query OK, 0 rows affected (0.01 sec)
       
      MariaDB [test]> select count(*) from t3;
      ERROR 1815 (HY000): Internal error: IDB-2006: 'test.t3' does not exist in Columnstore.
       
      select * from calpontsys.systable where tablename='t3';
      Empty set (0.02 sec)
       
      show create table t3\G
      *************************** 1. row ***************************
             Table: t3
      Create Table: CREATE TABLE `t3` (
        `c1` int(11) DEFAULT NULL
      ) ENGINE=Columnstore DEFAULT CHARSET=latin1 COMMENT='schema sync only'
      1 row in set (0.00 sec)
      

      Attachments

        Activity

          People

            LinuxJedi Andrew Hutchings (Inactive)
            sasha Sasha V
            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.