[MDEV-19943] Incorrect error message, when with VALUES table construction used empty value Created: 2019-07-03  Updated: 2023-04-27

Status: Open
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.3, 10.4
Fix Version/s: 10.4

Type: Bug Priority: Minor
Reporter: Alice Sherepa Assignee: Igor Babaev
Resolution: Unresolved Votes: 0
Labels: None


 Description   

MariaDB [test]> values (1), (2), () ;
ERROR 4099 (HY000): The used table value constructor has a different number of values
 
MariaDB [test]> values (1), (((2))), (1) ;
+---+
| 1 |
+---+
| 1 |
| 2 |
| 1 |
+---+
3 rows in set (0.000 sec)
 
MariaDB [test]> values (1), (((2))), (()) ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '))' at line 1


Generated at Thu Feb 08 08:55:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.