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

BLOB/TEXT updates truncated

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.0
    • 1.1.0
    • None
    • None
    • 2017-8

    Description

      PrimProc multi_token reading is breaking when reusing the same token. This causes junk data on a select on a multi-row table using TEXT/BLOB data longer than 8KB. Observed when doing an UPDATE on a constant column. Example:

      MariaDB [test]> update b3 set b = repeat('hello world ', 5000);
      Query OK, 7 rows affected (47.60 sec)
      Rows matched: 0  Changed: 0  Warnings: 0
       
      MariaDB [test]> select a, length(b) from b3;
      +------+-----------+
      | a    | length(b) |
      +------+-----------+
      |    1 |     60000 |
      |    1 |      1192 |
      |    1 |         0 |
      |    1 |     60000 |
      |    1 |     60000 |
      |    1 |     60000 |
      |    1 |     60000 |
      +------+-----------+
      7 rows in set (4.56 sec)
      

      (ignore timings, debugger was running)

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              LinuxJedi Andrew Hutchings (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.