[MCOL-192] || and XOR operator fails Created: 2016-06-24  Updated: 2019-07-11  Resolved: 2019-07-11

Status: Closed
Project: MariaDB ColumnStore
Component/s: MDB Plugin
Affects Version/s: None
Fix Version/s: 1.2.4

Type: Bug Priority: Major
Reporter: Justin Swanhart (Inactive) Assignee: David Hall (Inactive)
Resolution: Fixed Votes: 1
Labels: None

Epic Link: ColumnStore Compatibility Improvements

 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.

 Comments   
Comment by Justin Swanhart (Inactive) [ 2016-06-24 ]

select c1 xor c1 from fact;

Comment by Justin Swanhart (Inactive) [ 2016-06-24 ]

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.

Generated at Thu Feb 08 02:19:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.