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

CONNECT temporary table created

    XMLWordPrintable

    Details

      Description

      If I try to create a file-based CONNECT table, an error message tells me that temp CONNECT tables are not supported. But I was able to create a MYSQL table, which returns junk results when queried:

      MariaDB [test]> CREATE TABLE t SELECT 10, 'test', 'prova';
      Query OK, 1 row affected (0.42 sec)
      Records: 1  Duplicates: 0  Warnings: 0
       
      MariaDB [test]> CREATE TEMPORARY TABLE tempmy ENGINE=CONNECT, TABLE_TYPE=MYSQL, CONNECTION='mysql://root:root@127.0.0.1/test/t';
      Query OK, 0 rows affected (0.28 sec)
       
      MariaDB [test]> SELECT * FROM tempmy;
      +----+------+-------+
      | 10 | test | prova |
      +----+------+-------+
      |  0 |      |       |
      +----+------+-------+
      1 row in set (0.00 sec)

      Instead, I would expect to see an error after CREATE TABLE.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved: