[MDEV-25695] Strange error message when using unknown JSON function with default database Created: 2021-05-17  Updated: 2021-05-27  Resolved: 2021-05-27

Status: Closed
Project: MariaDB Server
Component/s: N/A
Affects Version/s: 10.5.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Johan Wikman Assignee: Johan Wikman
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

Consider this

MariaDB [(none)]> select json_unique("abcd");
 
ERROR 1305 (42000): FUNCTION json_unique does not exist

Not surprising as that function does not exist. But then

MariaDB [(none)]> use test;
 
Reading table information for completion of table and column names
 
You can turn off this feature to get a quicker startup with -A
 
 
 
Database changed
 
MariaDB [test]> select json_unique("abcd");
 
ERROR 1728 (HY000): Cannot load from mysql.proc. The table is probably corrupted

That is, with a default database the error message leads you astray.

 Comments   
Comment by Johan Wikman [ 2021-05-27 ]

The behavior is a consequence of not having run mariadb-upgrade.

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