Given this schema: I tried running a query like this: But the output suggests that the inner most nested MULTISET query doesn’t work. The output is: Is this a known limitation or a bug? How can I work around this limitation? I’m using IBM Informix Dynamic Server Version 14.10.FC5DE Answer Just like a similar problem I’ve discovered recently, there seems
Tag: multiset
Internal error when lateral unnesting collection derived table in Informix
I’m playing around with what’s possible in Informix related to collection derived tables and nested collections. Given this schema: I tried the following query: Running it the first time from the Dbeaver SQL editor produces this error: SQL Error [IX000]: The current transaction has been rolled back due to an internal error. Running it the second time produces this error:
How to nest MULTISET in unnamed ROW in Informix?
Given this schema: The following query looks correct to me: But it produces some unspecified internal error: SQL Error [IX000]: User Defined Routine (collectionsend) execution failed. Is this a documented limitation? How can I work around this problem? I’m using IBM Informix Dynamic Server Version 14.10.FC5DE Answer One workaround might be to wrap the entire thing in a dummy MULTISET