Failed tests in the 001 suite in 1.4
(MCOL-3594)
|
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | ExeMgr |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Sub-Task | Priority: | Minor |
| Reporter: | Roman | Assignee: | David Hall (Inactive) |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Sprint: | 2020-1, 2020-2, 2020-3, 2020-4, 2020-5, 2020-6, 2020-7 | ||||||||
| Description |
|
bit_count(), charset() and unhex() doesn't exist in CS thus couldn't be used in the query. CS used to utilize MDB functions for this in 1.2. |
| Comments |
| Comment by Gagan Goel (Inactive) [ 2020-03-11 ] |
|
BIT_COUNT(), UNHEX(), MINUTE() functions already exist in ColumnStore. Here are the passing tests: working_tpch1/qa_fe_cnxFunctions/unhex.sql The reason MINUTE() function is wrongly included in this ticket is because the following test fails: The issue here is not the MINUTE() function, but the SLEEP() function which is wrapped around MINUTE(). ColumnStore does not yet support SLEEP(). For CHARSET() and COLLATION(), ColumnStore does not currently support setting character set and collation at the column level. However, the PR https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/951 enabled support for CHARSET() and COLLATION() in the plugin code, which gets these values from the metadata of the table field. Associated passing test for these functions is: Setting CHARSET() and COLLATION() in the plugin code should suffice since for a given field, all rows should have the same value for these functions, and therefore there should be no need to implement these functions in ColumnStore. |
| Comment by Gagan Goel (Inactive) [ 2020-03-11 ] |
|
Please review the above comment. |
[MCOL-3600]