sqldelight / sqldelight/sql-psi

fts5vocab is not supported

Open
#235 2 comments 1 reaction 0 assignees View on GitHub

Nobody has claimed this yet.

sqlite
Dominant language
Kotlin
Stars
104
Forks
35
Avg merge
1h 11m
Merged PRs (30d)
14

Description

Dialect: sqlite:3.25

failing sql:

CREATE VIRTUAL TABLE foo_fts_vocab USING fts5vocab(foo_fts, 'row');

where foo_fts is a FTS5 virtual table.

This gives the following error in the build log:

null cannot be cast to non-null type com.squareup.sqldelight.core.lang.psi.ColumnTypeMixin

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing the failing CREATE VIRTUAL TABLE statement from the issue against SQLite 3.25, then trace the parser path for the fts5vocab table definition. Done means this SQL no longer produces the ColumnTypeMixin cast error and has coverage demonstrating the supported behavior.

Written by the indexing model from the issue text.

Assessment

Tech stack
kotlin, sqlite
Domain
databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
35/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.