Details
-
Task
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
None
-
None
-
2021-8
Attachments
Issue Links
- split from
-
MCOL-4687 Insert from view regression
-
- Closed
-
MariaDB [monty]> INSERT INTO bar SELECT * FROM view_foo;
Query OK, 1 row affected (1.623 sec)
Records: 1 Duplicates: 0 Warnings: 0
MariaDB [monty]> select * from view_foo;
+------+-------+
| id | fname |
+------+-------+
| 1 | Greg |
+------+-------+
1 row in set (0.001 sec)
MariaDB [monty]> select * from bar;
+------+-------+
| id | fname |
+------+-------+
| 1 | Greg |
+------+-------+
1 row in set (0.067 sec)
MariaDB [monty]> INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t;
Query OK, 1 row affected (1.284 sec)
Records: 1 Duplicates: 0 Warnings: 0
MariaDB [monty]> select * from bar;
+------+-------+
| id | fname |
+------+-------+
| 1 | Greg |
| 1 | Greg |
+------+-------+
2 rows in set (0.018 sec)