[MCOL-181] BINARY operator returns wrong results in 12/84 tests Created: 2016-06-24  Updated: 2023-07-02  Resolved: 2023-07-02

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Justin Swanhart (Inactive) Assignee: alexey vorovich (Inactive)
Resolution: Won't Do Votes: 0
Labels: None

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 binary
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 BINARY(expr) operator returns wrong results for CS compared to MyISAM in 12/84 tests.

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

The ones that break are edge cases, such as -9223372036854775806. Like many other operators, these give correct results with constants.

Comment by Todd Stoffel (Inactive) [ 2023-07-02 ]

Test in description is based on php5 and no longer works.

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