You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
select ... from stream with consume not work as expected in non auto commit mode
how to reproduce:
the following test case should return a non-empty result set at the end, but not.
create or replace database poc_databend;
use poc_databend;
create or replace table t_1 (
str varchar
);
create or replace stream s_1 on table t_1 append_only = true;
insert into t_1 (str) values ('a'), ('b');
begin;
select * from s_1 with consume;
select 1/0;
commit;
select * from s_1; -- expects non-empty result set but NOT
The text was updated successfully, but these errors were encountered:
Summary
select ... from stream with consume
not work as expected in non auto commit modehow to reproduce:
the following test case should return a non-empty result set at the end, but not.
The text was updated successfully, but these errors were encountered: