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

Joining two text/longtext/blob/longblob columns returns an internal error.

    XMLWordPrintable

Details

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

    Description

      Build tested:

      [root@localhost mariadb-columnstore-server]# git show
      commit 5a090c64bced6532578dd8910f15530fd37fce2c
      Merge: 9efb0a7 b062156
      Author: david hill <david.hill@mariadb.com>
      Date: Thu Apr 27 16:13:15 2017 -0500

      Merge pull request #45 from mariadb-corporation/FixPackageName

      Change the package name to match engines format

      [root@localhost mariadb-columnstore-server]# cd mariadb-columnstore-engine/
      [root@localhost mariadb-columnstore-engine]# git show
      commit cb788c0be215ad30e77e35298142fef43c61e70e
      Merge: 775c605 de06c48
      Author: dhall-InfiniDB <david.hall@mariadb.com>
      Date: Wed May 3 09:43:29 2017 -0500

      Merge pull request #163 from mariadb-corporation/MCOL-697

      MCOL-697 Remove 64KB VARCHAR response limit

      MariaDB [mytest]> truncate text1;
      Query OK, 0 rows affected (0.10 sec)

      MariaDB [mytest]> truncate text2;
      Query OK, 0 rows affected (0.08 sec)

      MariaDB [mytest]> insert into text1 values (1, "this is a test");
      Query OK, 1 row affected (0.09 sec)

      MariaDB [mytest]> insert into text2 values (1, "this is a test");
      Query OK, 1 row affected (0.09 sec)

      MariaDB [mytest]> select 'text1' as tableName, length(t1.c2) from text1 t1, text2 t2 where t1.c2 = t2.c2;
      ERROR 1815 (HY000): Internal error: IDB-2035: An internal error occurred. Check the error log file & contact support.
      MariaDB [mytest]> desc text1;
      ---------------------------------+

      Field Type Null Key Default Extra

      ---------------------------------+

      c1 int(11) YES   NULL  
      c2 text YES   NULL  

      ---------------------------------+

      Attachments

        Issue Links

          Activity

            People

              dleeyh Daniel Lee (Inactive)
              dleeyh Daniel Lee (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.