[MDEV-12385] Bundling insert with group concat with create statement for memory table fails to cast properly - Jira

XML

Word

Printable

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)

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.