Would it help to query SYSTEM.SEQUENCE table instead? For ex - "SELECT NEXT value FOR seq FROM SYSTEM.\"SEQUENCE\"".
This way you won't have to worry about rows being present in the table. On Tue, Apr 8, 2014 at 6:26 PM, Dan Di Spaltro <[email protected]>wrote: > So I created a new table and sequence. My typical pattern for that is > selecting from the sequence using a table, but I noticed if the table is > empty it doesn't select anything. While in practice this won't really be a > problem but it's a pain when testing, is this intended behavior? > > Thanks! > > -Dan > > -- > Dan Di Spaltro >
