[MCOL-4704] Retest MCOL-4687 (Insert from view) regression in 6.1.1 when ready Created: 2021-04-30  Updated: 2021-06-10  Resolved: 2021-05-24

Status: Closed
Project: MariaDB ColumnStore
Component/s: ExeMgr
Affects Version/s: None
Fix Version/s: 6.1.1

Type: Task Priority: Blocker
Reporter: Gregory Dorman (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Issue split
split from MCOL-4687 Insert from view regression Closed
Sprint: 2021-8

 Comments   
Comment by Daniel Lee (Inactive) [ 2021-05-24 ]

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)

Generated at Thu Feb 08 02:52:21 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.