#11827: Vertica 7.0-Change the cache size when we alter the Sequence

kirtipbankar(*) reported 2014-03-07T06:30:38Z · last modified 2014-04-21T23:07:52Z

Vertica 7.0-Change the cache size when we alter the Sequence

Dev	ivangron
QA	tariqrahiman

Priority	Low
Complexity	Unknown

Component	DB - Vertica
Version	15.0

Database: Vertica 7.0

ADS version :ADS-windows-15.0.0-dev-145

Connect Vertica

Create sequence

CREATE SEQUENCE "public"."test_s2"

INCREMENT BY 1

MINVALUE 1

MAXVALUE 9223372036854775807

START WITH 1

NO CYCLE

Go to Sequence tree node-> Select sequence 'test_s2'-> Right click on 'test_s2'-> Select Alter Sequence option-> Alter Sequence window is opened.

Now you will observe that when we Create sequence cache size 1, but when we alter that sequence change the cache size is 250000.

2 attachments

1.1.jpg

2014-03-07T06:30:38Z

324 KB
2.1.jpg

2014-03-07T06:30:38Z

332 KB

All Comments (2) Change History

ivangron 2014-04-16T19:52:47Z

There is no bug here. If you do not specify the cache size then the default cache size is used. default happens to be 250000. You can query the catalog table to see what the values of the sequence are in the database.

[SELECT * FROM v_catalog.sequences]

tariqrahiman 2014-04-21T23:07:52Z

This works as designed and there is no bug here. Verified in ADS v15.0.0-dev-244

Search Tips

Aqua Data Studio / nhilam

Vertica 7.0-Change the cache size when we alter the Sequence

2 attachments

Issue #11827

Completion

Search Tips

Aqua Data Studio / nhilam

Title

Vertica 7.0-Change the cache size when we alter the Sequence

2 attachments

Issue #11827

Completion