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

'insert into table select' syntax not working in 1.4.2

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Not a Bug
    • Affects Version/s: 1.4.2
    • Fix Version/s: 1.4.3
    • Component/s: writeengine
    • Labels:
      None
    • Sprint:
      2020-1

      Description

      Reported by customer..

      Is there a plan to re-implement the 'insert into table select' syntax with the newest release of Columnstore? We utilized this quite often with Columnstore tables in the 1.2.5 and earlier versions.

      SQL statement will be in the followup comments with Eng only permissions

      MariaDB [assay_archive]> insert into ....
      ERROR 1815 (HY000): Internal error: load failed. The detailed error information is listed in err.log.

      Select Handler lacks support for some vtable features, including:
      Cartesian JOIN
      Non-Equi JOIN
      INSERT .. SELECT
      SELECT INTO OUTFILE

      nothing in the error logs, this in the debug log

      Where the query returned to check the err.log, the log is actually completely empty and the debug.log just states that there is an error.

      Jan 20 10:34:35 mdb-cs2 dbcon[578022]: 35.694801 |34|0|0| D 24 CAL0001: Start SQL statement: insert into beef_batch_col_1 select * from beef_batch_2; |assay_archive|
      Jan 20 10:34:35 mdb-cs2 ExeMgr[577173]: 35.700284 |2147483682|0|0| D 16 CAL0041: Start SQL statement: select objectid from systable where schema='assay_archive' and tablename='beef_batch_col_1' --tableRID/; ||
      Jan 20 10:34:35 mdb-cs2 ExeMgr[577173]: 35.706849 |2147483682|0|0| D 16 CAL0042: End SQL statement
      Jan 20 10:34:35 mdb-cs2 dbcon[578022]: 35.893247 |34|0|0| D 24 CAL0001: End SQL statement with error

        Attachments

          Activity

            People

            Assignee:
            pleblanc Patrick LeBlanc (Inactive)
            Reporter:
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 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.