[MCOL-174] | operator returns wrong results in 712 of 2186 tests Created: 2016-06-23 Updated: 2019-12-10 Resolved: 2019-12-10 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 1.2.6 |
| Type: | Bug | Priority: | Major |
| Reporter: | Justin Swanhart (Inactive) | Assignee: | Daniel Lee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||||||||||
| Epic Link: | ColumnStore Compatibility Improvements | ||||||||||||||||
| Sprint: | 2019-06 | ||||||||||||||||
| Description |
|
git clone https://github.com/greenlion/columnstore_tests |
| Comments |
| Comment by Richard Stracke [ 2019-04-18 ] | ||||||||||
With Columnstore 1.2.3 and InnoDB as comparing engine. | ||||||||||
| Comment by David Hall (Inactive) [ 2019-07-17 ] | ||||||||||
|
This appears to only break on the edge, such as i1 = max(type) – Columnstore max, that is. In the following, you can see using i1 results in NULL, while using a constant gives the correct result.
-----
----- MariaDB [test]> select i1, -126 | 126 from fact where i1 = 126;
-----
----- | ||||||||||
| Comment by David Hall (Inactive) [ 2019-07-31 ] | ||||||||||
|
A goodly number of these are caused by maxing out the integer field. Any value that happens to be our magic NULL number gets reported as NULL, rather than that value. Other issues include: 1) Not handling string constants containing numbers correctly. Corrected. | ||||||||||
| Comment by David Hall (Inactive) [ 2019-07-31 ] | ||||||||||
|
Fixed some things, but not all. This can be closed, but I don't know how to handle a partial fix. | ||||||||||
| Comment by Andrew Hutchings (Inactive) [ 2019-08-09 ] | ||||||||||
|
Changes won't compile | ||||||||||
| Comment by David Hall (Inactive) [ 2019-08-22 ] | ||||||||||
|
Fixed compile errors | ||||||||||
| Comment by David Hall (Inactive) [ 2019-12-10 ] | ||||||||||
|
1) For Decimal Constants too large, this will be handled by | ||||||||||
| Comment by Daniel Lee (Inactive) [ 2019-12-10 ] | ||||||||||
|
Build verified: 1.2.6-1 engine commit: Verified the fix for NULL output. Micro variance for float are expected. |