Toad World® Forums

Alter Sequence - leaving Cache blank for NOCACHE does not work


#1

The tool-tip on the Cache box says “Leave blank for no cache”

However, if you leave it blank, the generate SQL is incorrect:

ALTER SEQUENCE CHX_COMMON.MB_TOPIC_CONFIGURATION_ID
INCREMENT BY N
MINVALUE 1
MAXVALUE 9999999999999999999999999999
CACHE 1
NOCYCLE
NOORDER;

If you enter 0, the generated SQL is correct and specifies NOCACHE.

Found this in 12 GA, but also a problem in 12.1.0.2


#2

Thanks. This is fixed for next beta.