bug: select ... from stream with consume not work as expected in non auto commit mode

[dantengsky]

Summary

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