drizzle-team / drizzle-team/drizzle-orm

Introspection doesn't work with pg driver on AWS redshift serverless db

Open
#3,444 0 comments 0 reactions 0 assignees View on GitHub
bug driver/aws-data-api drizzle/kit
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

```txt
[✓] 1 tables fetched
[⣯] 0 columns fetching
[⣯] 0 enums fetching
[⣯] 0 indexes fetching
[⣯] 0 foreign keys fetching

error: syntax error at or near "FROM"

length: 131,
severity: 'ERROR',
code: '42601',
detail: undefined,
hint: undefined,
position: '208',
internalPosition: undefined,
internalQuery: undefined,
where: undefined,
schema: undefined,
table: undefined,
column: undefined,
dataType: undefined,
constraint: undefined,
file: '/home/ec2-user/padb/src/pg/src/backend/parser/parser_scan.l',
line: '821',
routine: 'yyerror'
```

Contributor guide

Open the contributing guide

Research direction

Start by reproducing introspection against an AWS Redshift Serverless database with the pg driver and capture the SQL that produces the syntax error near FROM. Trace the introspection query responsible for columns, enums, indexes, or foreign keys; done means introspection completes without the reported 42601 error and fetches those metadata sections.

Written by the indexing model from the issue text.

Assessment

Tech stack
aws, postgresql, typescript
Domain
backend, databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.