[MCOL-1371] compound begin...end behavior Created: 2018-04-26  Updated: 2023-11-21  Resolved: 2022-11-05

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: Icebox

Type: New Feature Priority: Major
Reporter: patrice Assignee: Todd Stoffel (Inactive)
Resolution: Won't Do Votes: 0
Labels: None


 Description   

Trying to use the following syntax, while there is no error, the query does not seem to do the right thing ( 2-3s normally, way to long ) when using begin ... end compound.

delimiter //
begin not atomic
select count(distinct a) from a where a is not null;
end //
delimiter ;



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2018-04-27 ]

This will definitely be disabling vtable mode to execute, hence the poor performance.

Comment by patrice [ 2018-04-27 ]

Is this related to any other previous issues in jira ?

Comment by Andrew Hutchings (Inactive) [ 2018-05-01 ]

I'm not aware of any for this specific syntax. But there are a few edge cases where this behaviour can be observed.

Comment by Todd Stoffel (Inactive) [ 2022-11-05 ]

Item is out of date. Closing due to inactivity. If you feel this was done in error please open a new ticket.

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