Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-22526

Bad error message upon REPLACE into table with WITHOUT OVERLAPS

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.5
    • 10.5
    • Versioned Tables
    • None

    Description

      10.5 f544a712c8

      		 
      MariaDB [test]> create or replace table t1 (a int, s date, e date, period for p(s,e), primary key(a, p without overlaps));
      		 
      Query OK, 0 rows affected (0.185 sec)
      		 
       
      		 
      MariaDB [test]> replace into t1 () values ();
      		 
      ERROR 1235 (42000): This version of MariaDB doesn't yet support 'WITHOUT OVERLAPS'

      Same with ON DUPLICATE KEY UPDATE.

      We know what it is supposed to mean, but users won't. Besides, it's just embarrassing.

      Attachments

        Issue Links

          relates to

          New Feature - A new feature of the product, which has yet to be developed. MDEV-17395 REPLACE/INSERT ODKU: support WITHOUT OVERLAPS

          • Major - Major loss of function.
          • Stalled

          Activity

            People

              nikitamalyavin Nikita Malyavin
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.