Need help with creating a sequence with several parameters

[#1]

Hello,

I am trying to create a sequence thus:

CREATE SEQUENCE "stest" START WITH 1, CACHE 32;

but it fails with the error: incorrect syntax near ",": line 1 col 36 (at pos 36).

There is no problem with a single parameter, e.g.:

CREATE SEQUENCE "stest" START WITH 1;
CREATE SEQUENCE "stest" CACHE 32;

According to the SQLScript reference,

<sequence_parameter_list> ::= <sequence_parameter>[{,<sequence_parameter>}...]

What am I doing wrong?

[SreekanthSurampally · Accepted solution]

there should not be , between parameters, can you try that please

[former_member445524 · Accepted solution]

Indeed, it works without the comma. But how did you know that? The documentation specifies the comma as parameter separator. I have quoted the relevant part in the post.

[SreekanthSurampally · Accepted solution]

If I go little below to the syntax part in the documentation, there are examples with multiple parameters use. Actually it avoids confusion around the formats in the syntax if there are any.

[former_member445524 · Accepted solution]

The confusion is stark serious, Sreekanth, for the grammar in the HANA documentation is wrong. Correct examples do not help at all but only make the documentation internally inconsistent.