倉庫指標
- Star
- (19,563 star)
- PR 合併指標
- (平均合併 5天 16小時) (30 天內合併 138 個 PR)
描述
Describe the bug
I'm using CrateDB with Postgres wire protocol. I've found the current implementation of prepareConnection inside PostgresDriver uses this line:
await conn.query(SET TIME ZONE '${this.config.storeTimezone || 'UTC'}');
which for sure works for Postgres but not with compatible ones which needs this one:
await conn.query(SET TIMEZONE = '${this.config.storeTimezone || 'UTC'}');
This latest syntax also works on Postgres and it seems the standard one (from my research).
I propose to just change this line or create a new driver, CrateDBDriver, copy of PostgresDriver with only this line changed.
To Reproduce Steps to reproduce the behavior:
- Connect to a CrateDB Instance
- Try to open Schema from playground
- See error
Expected behavior As CrateDB uses Postgres wire protocol and high compatibility for syntax it should work out of the box
Version: 0.28.52