Informix auditing and alter table

When altering a table, auditing is lost from a table!

Install Informix as per http://smooth1.co.uk/installs/dbinstalls.html#10.1.1

Run the following:

onaudit -R 2
onaudit -L 1
onaudit -a -u _default -e +INRW
onaudit -o -y
echo “create database x” | dbaccess sysmaster
echo “create table a(b int) with audit ” | dbaccess x
cd $INFORMIXDIR/aaodir
echo “insert into a values(1)” | dbaccess x
ls -lrt
more ol_informix1410.0
ONLN|2023-12-28 01:48:43.000|localhost.localdomain|21341|ol_informix1410|informix|0:INRW:x:100:1049049:257::
dbschema -d x -t a -ss # table has “with audit” clause
echo “alter table a add ( c int)” | dbaccess x
dbschema -d x -t a -ss # table missing “with audit” clause
echo “insert into a values(2,3)” | dbaccess x
more ol_informix1410.0 # 2nd insert was not audited
ONLN|2023-12-28 01:48:43.000|localhost.localdomain|21341|ol_informix1410|informix|0:INRW:x:100:1049049:257::

Auditing is lost from the table!

As per https://community.ibm.com/community/user/datamanagement/discussion/alter-table-removes-it-from-audit-trail-1?ReplyInline=8f8a03e2-f4b7-48b6-8eb8-01867e14e82f this was expected to have been fixed in 14.10.FC10!