[MCOL-4244] NULLIF() and COALESCE() functions returned incorrect values Created: 2020-08-12  Updated: 2023-10-27  Resolved: 2023-10-27

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: 1.0.0
Fix Version/s: Icebox

Type: Bug Priority: Major
Reporter: Daniel Lee (Inactive) Assignee: Leonid Fedorov
Resolution: Won't Fix Votes: 0
Labels: None


 Description   

Build tested: 1.5.4-1 (Drone build #417)

MariaDB [tpch1]> select cidx, CFLOAT, CBIGINT, NULLIF(CFLOAT,CBIGINT) from datatypetestm order by cidx;
------------------------------------------------------+

cidx CFLOAT CBIGINT NULLIF(CFLOAT,CBIGINT)

------------------------------------------------------+

1 -3.40287e18 -72036854775806 2
2 -3.40287e18 -72036854775805 -3.68935e19
3 -3.40286e18 -72036854775804 3.68935e19
4 -3.40286e18 -72036854775803 -3.68935e19
5 -3.40286e18 -72036854775802 -0
6 3.40286e18 72036854775803 -0
7 3.40286e18 72036854775804 -3.68935e19
8 3.40286e18 72036854775805 3.68935e19
9 3.40287e18 72036854775806 -3.68935e19
10 3.40287e18 72036854775807 2
11 0 0 NULL

------------------------------------------------------+
11 rows in set (0.023 sec)

MariaDB [tpch1]> select cidx, CFLOAT, CBIGINT, COALESCE(CFLOAT,NULL) from datatypetestm order by cidx;
-----------------------------------------------------+

cidx CFLOAT CBIGINT COALESCE(CFLOAT,NULL)

-----------------------------------------------------+

1 -3.40287e18 -72036854775806 2
2 -3.40287e18 -72036854775805 -3.68935e19
3 -3.40286e18 -72036854775804 3.68935e19
4 -3.40286e18 -72036854775803 -3.68935e19
5 -3.40286e18 -72036854775802 -0
6 3.40286e18 72036854775803 -0
7 3.40286e18 72036854775804 -3.68935e19
8 3.40286e18 72036854775805 3.68935e19
9 3.40287e18 72036854775806 -3.68935e19
10 3.40287e18 72036854775807 2
11 0 0 0

-----------------------------------------------------+
11 rows in set (0.020 sec)
Generated at Thu Feb 08 02:48:53 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.