Skip to content
Advertisement

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

Advertisement

Answer

One workaround might be to wrap the entire thing in a dummy MULTISET like this, which seems to work:

Though, when unnesting the auxiliary multiset again, the old error appears. This doesn’t work:

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement