kingbase introspection error

[waterlovevip]

Error:
syntax error at or near "("

---

VSCode Version: 1.122.1
Extension Version: 1.32.3
OS: win32
Arch: x64
Database Version: KingbaseES V009R004C014PS004 - 12.1

[mikeburgh]

That error is coming back from KingbaseES itself while DBCode reads your schema, and the message doesn't say which query tripped it.

Can you run this and tell me what it returns:

SELECT current_setting('database_mode');

That tells me whether your instance is in PostgreSQL or Oracle compatibility mode, which changes how the parser behaves.

Turn on debug logging and grab the failing query from the DBCode output panel. Steps are here: https://dbcode.io/docs/help-support/debug. Once enabled, reconnect/refresh the connection so it errors again, then copy the lines around the error (it logs the actual SQL statement that failed). That statement is what I need.

Finally, other thing to try edit the connection, in the advanced section, expand the introspection option and select the progressive option.. it will delay introspection queries until you touch that item