[MCOL-4254] Funtion INSERT is not working correctly Created: 2020-08-19  Updated: 2020-09-21  Resolved: 2020-09-01

Status: Closed
Project: MariaDB ColumnStore
Component/s: PrimProc
Affects Version/s: 1.0.0
Fix Version/s: 5.4.1

Type: Bug Priority: Major
Reporter: David Hall (Inactive) Assignee: David Hall (Inactive)
Resolution: Duplicate Votes: 0
Labels: None


 Description   

The function INSERT isn't always behaving properly.

working_tpch1/qa_fe_cnxFunctions/insert.sql has regressions.

Correct:

MariaDB [tpch1]> select cidx, CCHAR2, INSERT(CCHAR2,2,4,'a') from datatypetestm;
 
+------+--------+------------------------+
 
| cidx | CCHAR2 | INSERT(CCHAR2,2,4,'a') |
 
+------+--------+------------------------+
 
|    1 | aa     | aa                     |
 
|    2 | b      | b                      |
 
|    3 | bb     | ba                     |
 
|    4 | bb     | ba                     |
 
|    5 | bb     | ba                     |
 
|    6 | yy     | ya                     |
 
|    7 | yy     | ya                     |
 
|    8 | yy     | ya                     |
 
|    9 | yy     | ya                     |
 
|   10 | zz     | za                     |
 
|   11 | NULL   | NULL                   |
 
+------+--------+------------------------+

Incorrect:

MariaDB [tpch1]> select cidx, CCHAR2, INSERT(CCHAR2,2,4,'a') from datatypetestm;
 
+------+--------+------------------------+
 
| cidx | CCHAR2 | INSERT(CCHAR2,2,4,'a') |
 
+------+--------+------------------------+
 
|    1 | aa     | aa                     |
 
|    2 | b      | b                      |
 
|    3 | bb     | bb                     |
 
|    4 | bb     | bb                     |
 
|    5 | bb     | bb                     |
 
|    6 | yy     | yy                     |
 
|    7 | yy     | yy                     |
 
|    8 | yy     | yy                     |
 
|    9 | yy     | yy                     |
 
|   10 | zz     | zz                     |
 
|   11 | NULL   | NULL                   |
 
+------+--------+------------------------+



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

Is a duplicate of MCOL-4099

Generated at Thu Feb 08 02:48:58 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.