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

|| and XOR operator fails

Details

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

    Description

      select c1 || c1 from fact;
      ERROR 1178 (42000): The storage engine for the table doesn't support IDB-2030: Predicate and Logic operators can not be used where an expression is expected.

      Attachments

        Activity

          Ascending order - Click to sort in descending order
          jswanhart Justin Swanhart (Inactive) created issue -
          jswanhart Justin Swanhart (Inactive) made changes -
          Field Original Value New Value
          Summary || operator fails || and XOR operator fails
          jswanhart Justin Swanhart (Inactive) added a comment -

          select c1 xor c1 from fact;

          jswanhart Justin Swanhart (Inactive) added a comment - select c1 xor c1 from fact;
          jswanhart Justin Swanhart (Inactive) added a comment -

          git clone https://github.com/greenlion/columnstore_tests
          sudo yum install php-cli php-mysql php-pear
          cd columnstore_tests
          git checkout xor
          php run_tests --record # record results against MyISAM table
          php run_tests --debug | tee out.txt #compare to CS table
          Examine out.txt and you will find that the operator returns wrong results for CS compared to MyISAM in 782 of 2186 tests.

          jswanhart Justin Swanhart (Inactive) added a comment - git clone https://github.com/greenlion/columnstore_tests sudo yum install php-cli php-mysql php-pear cd columnstore_tests git checkout xor php run_tests --record # record results against MyISAM table php run_tests --debug | tee out.txt #compare to CS table Examine out.txt and you will find that the operator returns wrong results for CS compared to MyISAM in 782 of 2186 tests.
          dshjoshi Dipti Joshi (Inactive) made changes -
          Workflow MariaDB v3 [ 76209 ] MariaDB ColumnStore workflow [ 77330 ]
          LinuxJedi Andrew Hutchings (Inactive) made changes -
          LinuxJedi Andrew Hutchings (Inactive) made changes -
          Epic Link MCOL-1049 [ 64464 ]
          LinuxJedi Andrew Hutchings (Inactive) made changes -
          toddstoffel Todd Stoffel (Inactive) made changes -
          Rank Ranked higher
          LinuxJedi Andrew Hutchings (Inactive) made changes -
          Assignee David Hall [ david.hall ]
          LinuxJedi Andrew Hutchings (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          LinuxJedi Andrew Hutchings (Inactive) made changes -
          Status In Progress [ 3 ] In Testing [ 10301 ]
          David.Hall David Hall (Inactive) made changes -
          issue.field.resolutiondate 2019-07-11 21:06:50.0 2019-07-11 21:06:50.423
          David.Hall David Hall (Inactive) made changes -
          Component/s Connector [ 13801 ]
          Fix Version/s 1.2.4 [ 23254 ]
          Resolution Fixed [ 1 ]
          Status In Testing [ 10301 ] Closed [ 6 ]

          People

            David.Hall David Hall (Inactive)
            jswanhart Justin Swanhart (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            3 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.