[MCOL-188] % and MOD operators fails on 463 of 958 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.git
sudo yum install php-cli php-mysql php-pear
cd columnstore_tests
git checkout mod
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 463 of 958 tests.

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

Tested against 1.2.4. Failed 926 of 1868, so it looks like the issue became worse for some reason.

Comment by David Hall (Inactive) [ 2020-01-03 ]

0.0 != -0.0 (may be fixed in 1.4)
Also NULL and EMPTY bits

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:10 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.