Marco Greco
2015-03-31 11:53:11 UTC
IBM Informix Dynamic Server Version 12.10.UC4DE
create temp table a(f1 char(3));
begin work;
insert into a values('abc');
select * from a;
rollback work;
select * from a;
I was expecting "abc" to come back for the first select, no rows found for the
second
What I get is "abc" for both ? !
Am I losing it - is this expected - or a bug ?
(FWIW - Using a real table - I get the expected result, I also get my expected
result on older versions of Informix)
Forgive me for asking the obvious - but the temp table isn't going in a tempcreate temp table a(f1 char(3));
begin work;
insert into a values('abc');
select * from a;
rollback work;
select * from a;
I was expecting "abc" to come back for the first select, no rows found for the
second
What I get is "abc" for both ? !
Am I losing it - is this expected - or a bug ?
(FWIW - Using a real table - I get the expected result, I also get my expected
result on older versions of Informix)
dbspace, right?
--
Ciao,
Marco
______________________________________________________________________________
Marco Greco /UK /IBM Standard disclaimers apply!
Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm
Ciao,
Marco
______________________________________________________________________________
Marco Greco /UK /IBM Standard disclaimers apply!
Structured Query Scripting Language http://www.4glworks.com/sqsl.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm