Probable regression, Postgresql sequence DDL uses Cache 0 and this is not a valid value

[igorbga]

System information:

• Ubuntu 18.04
• DBeaver CE 21.0.5
• Additional extensions: Non AFAIK

Connection specification:

• Database name and version: PostgreSQL 9.6
• Driver name: PostgreSQL JDBC Driver
• Do you use tunnels or proxies (SSH, SOCKS, etc)? No

Describe the problem you're observing:

The DDL suggested for a sequence sets optional attribute CACHE to 0 which is not valid in PostgreSQL.
This was reported and supposedly fixed a couple of years ago in #5156 .

Steps to reproduce, if exist:

Create a sequence in a PostgreSQL DB and check the DDL that DBeaver shows.

Include any warning/errors/backtraces from the logs

[ShadelessFox]

Hello @igorbga,

Thanks for the report. The problem was occurred in #11177.

[ShadelessFox]

The issue will be fixed in the scope of this ticket. Keep it opened for now.

[igorbga]

A ok, sorry, thought your commit already solved it. Thanks

[ShadelessFox]

The fix should be tested first in order to be closed :)

[kseniiaguzeeva]

verified