GTT behavior changed in master

19 views
Skip to first unread message

Adriano dos Santos Fernandes

unread,
Apr 5, 2026, 8:47:13 PM (2 days ago) Apr 5
to firebir...@googlegroups.com
Hi!

Test case:
----
set autoddl off;

set list on;

create global temporary table gtt_pub(
    id integer,
    name varchar(20)
) on commit preserve rows;

create table t_drop(
    id integer,
    name varchar(20)
);

commit retain;

insert into gtt_pub(id) values (1);
select count(*) as cnt_before from gtt_pub;

drop table t_drop;
commit retain;

select count(*) as cnt_after from gtt_pub;
select * from gtt_pub;
----

v5 result:
----
CNT_BEFORE                      1
CNT_AFTER                       1
ID                              1
NAME                            <null>
----

master result:
----
CNT_BEFORE                      1
CNT_AFTER                       0
----


Adriano

Alex Peshkoff

unread,
Apr 6, 2026, 9:16:39 AM (yesterday) Apr 6
to firebir...@googlegroups.com
Thank you - I'm working on it.


Reply all
Reply to author
Forward
0 new messages