Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.2.5
-
None
-
2021-7
Description
Inserting into a Columnstore table from a view used to work in 1.2 and below. A customer noticed that in 5.x and above that it no longer functions. See this example:
CREATE DATABASE monty; |
USE monty; |
CREATE TABLE foo (id INT, fname VARCHAR(20)); |
INSERT INTO foo VALUES (1,'Greg'); |
CREATE VIEW view_foo as SELECT * FROM foo; |
SELECT * FROM view_foo; |
CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; |
INSERT INTO bar SELECT * FROM view_foo; |
– ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported.
However, if we use the wrapper trick, it does work:
INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; |
– OK: 1 row affected
Attachments
Issue Links
Activity
Field | Original Value | New Value |
---|---|---|
Description |
CREATE DATABASE monty;
USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; -- OK: 1 row affected |
{noformat}
CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {noformat} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} {noformat} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {noformat} {color:green} -- OK: 1 row affected {color} |
Description |
{noformat}
CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {noformat} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} {noformat} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {noformat} {color:green} -- OK: 1 row affected {color} |
{code:sql}
CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {code} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} {code:sql} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {code} {color:green} -- OK: 1 row affected {color} |
Description |
{code:sql}
CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {code} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} {code:sql} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {code} {color:green} -- OK: 1 row affected {color} |
{code:sql}
CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {code} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} {code:sql} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {code} {color:green} -- OK: 1 row affected {color} |
Description |
{code:sql}
CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {code} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} {code:sql} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {code} {color:green} -- OK: 1 row affected {color} |
{code:sql}
CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {code} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} {code:sql} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {code} {color:green} -- OK: 1 row affected {color} |
Description |
{code:sql}
CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {code} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} {code:sql} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {code} {color:green} -- OK: 1 row affected {color} |
{code:sql}
CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {code} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} {code:sql} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {code} {color:green} -- OK: 1 row affected {color} |
Description |
{code:sql}
CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {code} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} {code:sql} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {code} {color:green} -- OK: 1 row affected {color} |
Inserting into a Columnstore table from a view used to work in 1.2 and below. A customer noticed that in 5.x and above that it no longer functions. See this example:
{code:sql} CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {code} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} {code:sql} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {code} {color:green} -- OK: 1 row affected {color} |
Description |
Inserting into a Columnstore table from a view used to work in 1.2 and below. A customer noticed that in 5.x and above that it no longer functions. See this example:
{code:sql} CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {code} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} {code:sql} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {code} {color:green} -- OK: 1 row affected {color} |
Inserting into a Columnstore table from a view used to work in 1.2 and below. A customer noticed that in 5.x and above that it no longer functions. See this example:
{code:sql} CREATE DATABASE monty; USE monty; CREATE TABLE foo (id INT, fname VARCHAR(20)); INSERT INTO foo VALUES (1,'Greg'); CREATE VIEW view_foo as SELECT * FROM foo; SELECT * FROM view_foo; CREATE TABLE bar (id INT, fname VARCHAR(20)) ENGINE=Columnstore; INSERT INTO bar SELECT * FROM view_foo; {code} {color:red} -- ERROR: The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported. {color} However, if we use the wrapper trick, it does work: {code:sql} INSERT INTO bar SELECT * FROM (SELECT * FROM view_foo) t; {code} {color:green} -- OK: 1 row affected {color} |
Sprint | 2021-7 [ 514 ] |
Rank | Ranked higher |
Affects Version/s | 5.6.1 [ 25031 ] |
Assignee | Gregory Dorman [ gdorman ] | Alexander Barkov [ bar ] |
Affects Version/s | 5.6.1 [ 25031 ] |
Affects Version/s | 1.2.5 [ 23613 ] | |
Affects Version/s | 5.5.2 [ 25601 ] |
Rank | Ranked higher |
Status | Open [ 1 ] | In Progress [ 3 ] |
Assignee | Alexander Barkov [ bar ] | Gagan Goel [ tntnatbry ] |
Status | In Progress [ 3 ] | In Review [ 10002 ] |
Status | In Review [ 10002 ] | In Testing [ 10301 ] |
Assignee | Gagan Goel [ tntnatbry ] | Daniel Lee [ dleeyh ] |
Labels | tech_debt |
Resolution | Fixed [ 1 ] | |
Status | In Testing [ 10301 ] | Closed [ 6 ] |
Rank | Ranked lower |
Confirmed with the following script:
+------+-------+
| id | fname |
+------+-------+
| 1 | Greg |
+------+-------+
ERROR 1178 (42000): The storage engine for the table doesn't support IDB-1011: Insert on VIEW is currently not supported.