[MDEV-22526] Bad error message upon REPLACE into table with WITHOUT OVERLAPS Created: 2020-05-11  Updated: 2020-10-22

Status: Open
Project: MariaDB Server
Component/s: Versioned Tables
Affects Version/s: 10.5
Fix Version/s: 10.5

Type: Bug Priority: Minor
Reporter: Elena Stepanova Assignee: Nikita Malyavin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-17395 REPLACE/INSERT ODKU: support WITHOUT ... Stalled

 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.



 Comments   
Comment by Nikita Malyavin [ 2020-10-22 ]

elenst I can change it to "REPLACE + WITHOUT OVERLAPS" for example

Generated at Thu Feb 08 09:15:24 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.