On informix 12.10 and 14.10 can create table as select from.
I used the informix demo DB to test.
But when send two create table as select from two SQL at same request like below PANIC the informix server:
create table itemxx as select * from items; create table custxx as select * from customer
The online log message:
13:01:03 Assert Failed: No Exception Handler
13:01:03 IBM Informix Dynamic Server Version 14.10.FC6WE
13:01:03 Who: Session(99,
informix@192.168.125.103, 18132, 700020000782ab8)
Thread(453, sqlexec, 700020000745680, 1)
File: mtex.c Line: 564
13:01:03 Results: Exception Caught. Type: MT_EX_OS, Context: mem
13:01:03 Action: Please notify IBM Informix Technical Support.
13:01:03 See Also: /home/ids14fc6/tmp/af.5ad5b0e
13:01:18 Thread ID 453 will NOT be suspended because
it is holding a buffer.
13:01:18 See Also: /home/ids14fc6/tmp/af.5ad5b0e
13:01:18 mtex.c, line 564, thread 453, proc id 12911096, No Exception Handler.
13:01:18 The Master Daemon Died
13:01:18 PANIC: Attempting to bring system down
The af.xxxx file is attached.
------------------------------
Regards.
Philip Yeh
------------------------------
#Informix