Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-4254

Funtion INSERT is not working correctly

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.0.0
    • Fix Version/s: 5.4.1
    • Component/s: PrimProc
    • 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                   |
      +------+--------+------------------------+
      

        Attachments

          Activity

            People

            Assignee:
            David.Hall David Hall
            Reporter:
            David.Hall David Hall
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: