db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Daniel Butler <dbut...@chemaxon.com>
Subject CURRENTVALUE is not "as expected"
Date Fri, 28 Sep 2012 16:36:51 GMT
Hi there, 


I was trying to access/use: 



SELECT CURRENTVALUE FROM SYS.SYSSEQUENCES WHERE SEQUENCENAME='SOMETHING' 


It appears not to return the expected value, in fact it seem to add 5 to the expected value
or some other number but not what is expected. 


Surely this cannot be considered correct/reasonable ? 
Is there any way to access the real CURRENTVALUE (I don't think ( CURRENTVALUE -X) is a good
solution, since it is not clear what X should be at any one time) 


Thanks, 
Daniel Butler. 
Mime
View raw message