Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Minor
-
Resolution: Not a Bug
-
Affects Version/s: 10.0.30
-
Fix Version/s: N/A
-
Component/s: Data Definition - Temporary, Storage Engine - Memory
-
Labels:None
-
Environment:CentOS 7.1
Description
The following Create/Insert statement fails with Error Code 1163
CREATE TEMPORARY TABLE blobtest ( |
`GROUPING` varchar(45) DEFAULT NULL |
) ENGINE=MEMORY
|
select
|
group_concat(ITEM)
|
from |
(
|
select "item1" ITEM |
union |
select "item2" |
) temp; |
The following code, succeeds
CREATE TEMPORARY TABLE blobtest ( |
`GROUPING` varchar(45) DEFAULT NULL |
) ENGINE=MEMORY;
|
insert into blobtest |
select
|
group_concat(ITEM)
|
from |
(
|
select "item1" ITEM |
union |
select "item2" |
) temp; |
It appears the bundled statement is ignoring the DDL of the table creation statement, or failing to cast to varchar(45)