Re: drop table and locks
>Date: Thu, 14 May 92 11:43:38 +0100 >From: uunet!ssf.pt!mm (Manuel Monteiro) >Message-Id: <9205141043.AA01297@gloin.ssf.pt> >Subject: drop table and locks >X-Informix-List-Id: <list.1179> > >Hi there list, > >We have detected a problem when dropping a table (temporary or not) or an >index in a database without transactions. Which version are you using, and which machine? There used to be some problems in this area in the 2.10.00 release of ISQL, and maybe in the .03X releases. I've not seen any similar problems in 4.00 and above. I used the modified version of your code below on a Sun (SunOS 4.1.1) running I4GL-RDS 4.00.UC1 and SE 4.00.UD2 and the program ran through with no errors. If you have a problem on an older version, you will not get any sympathy from Informix if you report the problem -- you will simply be told to upgrade. If it is a more recent version, then we'd want to know. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h> : "@(#)shar.sh 1.8" #! /bin/sh # # This is a shell archive. # Remove everything above this line and run sh on the resulting file. # If this archive is complete, you will see this message at the end: # "All files extracted" # # Created: Thu May 14 20:07:15 GMT 1992 by johnl at Informix Software Ltd. # Files archived in this archive: # testcode.4gl # #-------------------- if [ -f testcode.4gl -a "$1" != "-c" ] then echo shar: testcode.4gl already exists else echo 'x - testcode.4gl (626 characters)' sed -e 's/^X//' >testcode.4gl <<'SHAR-EOF' X Xmain X define c char, X n integer X X create database db_mm_jl X create table t ( a integer, b integer) X create index ixa on t ( a) X create index ixb on t ( b) X X prompt "There is no lock in the table t" for char c X X drop index ixa X X prompt "There is a lock in the table" for char c X X drop index ixb X X prompt "The lock remains in the table" for char c X X select count(*) into n from t X X prompt "There is no lock in the table" for char c X X drop table t X X prompt "There is a lock in the dropped table" for char c X close database X drop database db_mm_jl X Xend main SHAR-EOF chmod 644 testcode.4gl if [ `wc -c <testcode.4gl` -ne 626 ] then echo shar: testcode.4gl unpacked with wrong size fi # end of overwriting check fi echo All files extracted exit 0