Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
1.0.0
-
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 | |
+------+--------+------------------------+
|