[MCOL-4490] Add support for session variables and SELECT..INTO into Select Handler Created: 2021-01-11  Updated: 2023-12-15

Status: Open
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 5.4.3
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: Roman Assignee: Max Mether
Resolution: Unresolved Votes: 1
Labels: not-CS0121176


 Description   

As of 5.4.1 MCS quits early from create_columnstore_select_handler() if SELECT..INTO is detected disabling SH for the queries like SELECT c1 INTO @var FROM t or SELECT * INTO OUTFILE '/tmp/some.data' FROM t.
We need to re-evaluate the block and test MCS with the queries that contains SELECT..INTO.

    if (((thd->lex)->result &&
 
        !((select_dumpvar *)(thd->lex)->result)->var_list.is_empty()) &&
 
        (!isPS))
 
    {
 
        return handler;
 
    }


Generated at Thu Feb 08 02:50:44 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.