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

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

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration