Discussion:
Going mad - rollback work, temp table, Informix 12
(too old to reply)
Marco Greco
2015-03-31 11:53:11 UTC
Permalink
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 temp
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
Doug Lawry
2015-04-01 22:24:31 UTC
Permalink
What setting do you have for TEMPTAB_NOLOG in the $ONCONFIG file?

Regards,
Doug Lawry

Loading...