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

Improved support for NULL for Varchar

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: In Progress (View Workflow)
    • Priority: Blocker
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: 23.02
    • Component/s: None
    • Labels:

      Description

      I suspect this is related to MCOL-171.

      MariaDB [sakila]> create table t2 (a varchar(255)) engine=columnstore;Query OK, 0 rows affected (0.61 sec)

      MariaDB [sakila]> insert into t2 values ('');
      Query OK, 1 row affected (0.26 sec)

      MariaDB [sakila]> select * from t2;
      ------

      a

      ------

      NULL

      ------
      1 row in set (0.10 sec)

      MariaDB [sakila]> create table t1 (a varchar(255) not null) engine=columnstore;
      Query OK, 0 rows affected (0.53 sec)

      MariaDB [sakila]> insert into t1 values ('');
      ERROR 1815 (HY000): Internal error: CAL0001: Insert Failed: IDB-4015: Column 'a' cannot be null.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              sergey.zefirov Sergey Zefirov
              Reporter:
              LinuxJedi Andrew Hutchings (Inactive)
              Votes:
              1 Vote for this issue
              Watchers:
              11 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration

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