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

Sequence require that a db is selected

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Trivial
        • Resolution: Not a Bug
        • Affects Version/s: 10.0.3
        • Fix Version/s: None
        • Component/s: None
        • 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?

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

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

                Show
                serg Sergei Golubchik added a comment - Yes, it's the correct behavior. sequence tables, while virtual, are still tables, and they can exist only in a database.
                Hide
                Permalink
                f_razzoli Federico Razzoli added a comment -

                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.

                Show
                f_razzoli Federico Razzoli added a comment - 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.

                  People

                  • Assignee:
                    serg Sergei Golubchik
                    Reporter:
                    f_razzoli Federico Razzoli
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: