Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-12385

Bundling insert with group concat with create statement for memory table fails to cast properly

    XMLWordPrintable

Details

    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)

      Attachments

        Activity

          People

            Unassigned Unassigned
            MarkP Mark Punak
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

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