Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Won't Fix
-
1.0.0
-
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)