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

Some functions return "The maximum row size" error when TEXT/LONGTEXT is used in a table

    XMLWordPrintable

Details

    Description

      Build tested: Github source 1.1.0

      [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 03c62656b3750fd5f9759897f048bda8423c4aae
      Author: david hill <david.hill@mariadb.com>
      Date: Wed May 10 10:35:56 2017 -0500

      update post-install

      removed test lines of echo adn early exit

      diff --git a/oam/install_scripts/post-install b/oam/install_scripts/post-install
      index c09e7d5..69dfb58 100755
      — a/oam/install_scripts/post-install
      +++ b/oam/install_scripts/post-install
      @@ -36,10 +36,6 @@ for arg in "$@"; do
      echo "post-install: ignoring unknown argument: $arg" 1>&2
      fi
      done
      -
      -echo $installdir
      -echo $prefix
      -exit 0

      if [ $user != "root" ]; then
      export COLUMNSTORE_INSTALL_DIR=$installdir

      This issue makes there functions unusable on a table with TEXT/LONGTEXT column(s).

      MariaDB [mytest]> desc t1;
      ---------------------------------+

      Field Type Null Key Default Extra

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

      cidx int(11) YES   NULL  
      ctext text YES   NULL  

      ---------------------------------+
      2 rows in set (0.01 sec)

      MariaDB [mytest]> select upper(ctext) from t1;
      ERROR 1118 (42000): Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

      The following functions are affected by this error:

      ELT
      INSERT
      LCASE
      LOWER
      LTRIM
      REPEAT
      REPLACE
      REVERSE
      RTRIM
      SUBSTRING
      SUBSTR
      TRIM
      UCASE
      UPPER

      Attachments

        Issue Links

          Activity

            People

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