[MDEV-4696] Sequence require that a db is selected Created: 2013-06-22  Updated: 2013-12-23  Resolved: 2013-06-24

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.3
Fix Version/s: None

Type: Bug Priority: Trivial
Reporter: Federico Razzoli Assignee: Sergei Golubchik
Resolution: Not a Bug Votes: 0
Labels: None


 Description   

With no default database:

MariaDB [(none)]> SELECT * FROM seq_1_to_3;
 
ERROR 1046 (3D000): No database selected

If this is the correct behavior, maybe it would be better to document it?

 Comments   
Comment by Sergei Golubchik [ 2013-06-24 ]

Yes, it's the correct behavior. sequence tables, while virtual, are still tables, and they can exist only in a database.

Comment by Federico Razzoli [ 2013-12-23 ]

I noticed that even SELECT * FROM db_name.seq_1_to_10 fails, if no db is selected. This seems to me strange, because db_name should be used.
This is not important - I just thought you want to know it.

Generated at Thu Feb 08 06:58:26 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.