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

Funtion INSERT is not working correctly

    XMLWordPrintable

Details

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

            David.Hall David Hall (Inactive)
            David.Hall David Hall (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.