[MCOL-172] & operator returns wrong results in 4301 out of 21806 tests Created: 2016-06-23  Updated: 2019-07-17  Resolved: 2019-07-17

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr, PrimProc
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: 0
Labels: None

Issue Links:
Blocks
is blocked by MCOL-350 can't select date value of 0000-00-00 Closed
Epic Link: ColumnStore Compatibility Improvements

 Description   

git clone https://github.com/greenlion/columnstore_tests
sudo yum install php-cli php-mysql php-pear
cd columnstore_tests
git checkout only_and
php run_tests --debug | tee only_and.txt

Examine only_and.txt and you will find that the & operator returns wrong results for CS compared to MyISAM in 4301 tests of 21806.

It looks like the operator returns 0 instead of some other correct value in most of these tests.



 Comments   
Comment by David Thompson (Inactive) [ 2016-10-07 ]

Branch is missing test results but this can be created by running:
php run_tests --record

As it stands there are less tests and failures, looks like need to figure out how to fix the test in the branch to correctly run with &.

Comment by David Thompson (Inactive) [ 2016-10-07 ]

this is performed by editing t_operator to comment out everything but the & operator pattern.

Same basic root cause as 174 (linked bugs).

Comment by David Hall (Inactive) [ 2019-07-17 ]

Tested against 1.2.4 and all passed

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