[ https://issues.jboss.org/browse/TEIID-5074?page=com.atlassian.jira.plugin... ] Steven Hawkins commented on TEIID-5074: --------------------------------------- Did you check if getSelectSequenceNextValString is used? It needs to be a valid expression, which would be something like: {code} @Override public String getSequenceNextValString(String sequenceName) { return "select __x.return from " + getSelectSequenceNextValString( sequenceName ) +" as __x"; } @Override public String getSelectSequenceNextValString(String sequenceName) { return "(call " + getSelectSequenceNextValString( sequenceName ) +"())"; } {code} However if it can be used in a multi-row situation, there will be an issue in that a non-correlated subquery will be evaluated as deteministic. To make that work correctly would require the usage of a function that is marked as non-deterministic. -- This message was sent by Atlassian JIRA (v7.2.3#72005)