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

Adding a column failed if the column being added is of TEXT/LONGTEXT/BLOB/LONGBLOB

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 1.1.0
    • 1.1.0
    • DDLProc
    • None
    • 2017-10

    Description

      Build tested: Github source

      [root@localhost mariadb-columnstore-server]# git show
      commit 349cae544b6bc71910267a3b3b0fa3fb57b0a587
      Merge: bd13090 2ecb85c
      Author: benthompson15 <ben.thompson@mariadb.com>
      Date: Thu May 4 16:06:16 2017 -0500

      Merge pull request #50 from mariadb-corporation/10.2-fixes

      10.2 fixes

      [root@localhost mariadb-columnstore-server]# cd mariadb-columnstore-engine/
      [root@localhost mariadb-columnstore-engine]# git show
      commit 9ef603c14aa3cb8e9fe7f21c9965f6cf3f0a11d8
      Merge: 19342ef 82c983e
      Author: dhall-InfiniDB <david.hall@mariadb.com>
      Date: Fri May 5 13:09:34 2017 -0500

      Merge pull request #169 from mariadb-corporation/MCOL-701

      MCOL-701 stop join on BLOB columns

      MariaDB [mytest]> alter table datatypetestm add column ctext integer;
      Query OK, 0 rows affected (0.08 sec)
      Records: 0 Duplicates: 0 Warnings: 0

      MariaDB [mytest]> alter table datatypetestm drop column ctext;
      Query OK, 0 rows affected (0.22 sec)
      Records: 0 Duplicates: 0 Warnings: 0

      MariaDB [mytest]>
      MariaDB [mytest]>
      MariaDB [mytest]>
      MariaDB [mytest]> alter table datatypetestm add column ctext text;
      ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: AlterTableProcessor::addColumn CAL0001: we_readthread caught exception boost::bad_any_cast: failed conversion using boost::any_cast
      MariaDB [mytest]> alter table datatypetestm add column ctext longtext;
      ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: AlterTableProcessor::addColumn CAL0001: we_readthread caught exception boost::bad_any_cast: failed conversion using boost::any_cast
      MariaDB [mytest]> alter table datatypetestm add column ctext blob;
      ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: AlterTableProcessor::addColumn CAL0001: we_readthread caught exception boost::bad_any_cast: failed conversion using boost::any_cast
      MariaDB [mytest]> alter table datatypetestm add column ctext longblob;
      ERROR 1815 (HY000): Internal error: CAL0001: Alter table Failed: AlterTableProcessor::addColumn CAL0001: we_readthread caught exception boost::bad_any_cast: failed conversion using boost::any_cast
      MariaDB [mytest]>

      Attachments

        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.