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

Regression test005 fails after nullString patch

    XMLWordPrintable

Details

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

    Description

      On all the distros in CI, the result of running full regression test suit gives this:

      Working DML Test scripts that failed:
      Compare failed - working_dml/misc/notnullconstraint.negative.sql
       
      Details from queryTester:
      Total Local Passed   = 81
      Total Local Failed   = 0
      Total Ref Passed     = 0
      Total Fef Failed     = 0
      Total Compare Passed = 80
      Total Compare Failed = 1
      Total Selects        = 1251
      Total Inserts        = 558
      Total Updates        = 142
      Total Deletes        = 34
      Total Creates        = 361
      Total Drops          = 484
      

      The diff in the test itself is the following:

      Failing requests in: working_dml/misc/notnullconstraint.negative.sql
      --- ../../working_dml/misc/notnullconstraint.negative.sql.ref.log	2023-04-05 22:02:23.000000000 +0000
      +++ ../../working_dml/misc/notnullconstraint.negative.sql.bad.log	2023-04-05 22:52:21.951571441 +0000
      @@ -3,9 +3,11 @@
       ERROR 1048 (23000) at line 32: Column 'col1' cannot be null
       ERROR 1048 (23000) at line 34: Column 'col2' cannot be null
       ERROR 1815 (HY000) at line 36: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col1' cannot be null.
      -ERROR 1815 (HY000) at line 38: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col1' cannot be null.
      +ERROR 1815 (HY000) at line 38: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.
      +ERROR 1815 (HY000) at line 42: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.
      +ERROR 1815 (HY000) at line 53: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.
       ERROR 1815 (HY000) at line 55: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col2' cannot be null.
      -ERROR 1815 (HY000) at line 57: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col2' cannot be null.
      +ERROR 1815 (HY000) at line 57: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.
       col_1
       1
       2
      Failing requests in: working_dml/misc/notnullconstraint.negative.sql
      --- ../../working_dml/misc/notnullconstraint.negative.sql.ref.log	2023-04-05 22:02:23.000000000 +0000
      +++ ../../working_dml/misc/notnullconstraint.negative.sql.bad.log	2023-04-05 22:52:21.951571441 +0000
      @@ -3,9 +3,11 @@
       ERROR 1048 (23000) at line 32: Column 'col1' cannot be null
       ERROR 1048 (23000) at line 34: Column 'col2' cannot be null
       ERROR 1815 (HY000) at line 36: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col1' cannot be null.
      -ERROR 1815 (HY000) at line 38: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col1' cannot be null.
      +ERROR 1815 (HY000) at line 38: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.
      +ERROR 1815 (HY000) at line 42: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.
      +ERROR 1815 (HY000) at line 53: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.
       ERROR 1815 (HY000) at line 55: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col2' cannot be null.
      -ERROR 1815 (HY000) at line 57: Internal error: CAL0002: Update Failed:  MCS-4015: Column 'col2' cannot be null.
      +ERROR 1815 (HY000) at line 57: Internal error: CAL0002: Update Failed:  MCS-2013: Not able to convert the input data; Data value '' does not match data type.
       col_1
       1
       2
      

      Attachments

        Activity

          People

            sergey.zefirov Sergey Zefirov
            Andrey Andrey Piskunov (Inactive)
            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.