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) 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.

          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.