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

working_tpch1_compareLogOnly/partitionOptimization - store procedure errors

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • None
    • 1.0.0
    • MariaDB Server
    • None
    • nightly regression test

    Description

      I added in the working_tpch1_compareLogOnly into the nightly regression test run today, I didn't even have these set of scripts on my machine.

      A number of failures in this folder : partitionOptimization

      Need to be investigated. log isn't matching the ref log from InfiniDB.

      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/aCreateViews.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/bug5848.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTest001.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch01.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch02.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch03.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch04.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch05.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch06.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch07.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch08.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch09.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch10.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch11.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch12.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch13.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch14.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch15.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch16.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch17.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch18.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch19.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch20.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch21.sql
      Compare failed - working_tpch1_compareLogOnly/partitionOptimization/vTpch22.sql

      here are some examples:

      [root@srvregtest partitionOptimization]# cat aCreateViews.sql.log
      ERROR 1303 (2F003) at line 32: Can't create a PROCEDURE from within another stored routine
      ERROR 1303 (2F003) at line 44: Can't create a PROCEDURE from within another stored routine
      ERROR 1303 (2F003) at line 63: Can't create a PROCEDURE from within another stored routine
      ERROR 1303 (2F003) at line 74: Can't create a PROCEDURE from within another stored routine
      ERROR 1303 (2F003) at line 86: Can't create a PROCEDURE from within another stored routine
      ERROR 1303 (2F003) at line 94: Can't create a PROCEDURE from within another stored routine
      ERROR 1303 (2F003) at line 104: Can't create a PROCEDURE from within another stored routine
      ERROR 1303 (2F003) at line 111: Can't create a PROCEDURE from within another stored routine
      ERROR 1303 (2F003) at line 117: Can't create a PROCEDURE from within another stored routine
      [root@srvregtest partitionOptimization]# cat aCreateViews.sql.ref.log
      lineitem_count
      6001215
      v_lineitem_count
      6001215
      orders_count
      1500000
      v_orders_count
      1500000
      part_count
      200000

      -----------------------------

      cat vTpch22.sql.log
      ERROR 1305 (42000) at line 19: PROCEDURE tpch1.customerColumnsTouched does not exist
      ERROR 1305 (42000) at line 20: PROCEDURE tpch1.ordersColumnsTouched does not exist
      ERROR 1305 (42000) at line 21: PROCEDURE tpch1.eliminatedBlocksGE does not exist

      [root@srvregtest partitionOptimization]# cat vTpch22.sql.ref.log
      calsettrace(1)

      Attachments

        Activity

          People

            David.Hall David Hall (Inactive)
            hill David Hill (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.