Skip to content

PRAGMA table_info throws error #512

@rkreutzer

Description

@rkreutzer

Describe the bug
When executing a query "PRAGMA table_info("xxxx");", it throws error "Error: Run: error code 100: another row available"

While there is a workaround to query sqlite_master for the table name, the synchronize function calls PRAGMA table_xinfo, which also fails with the same error.

To Reproduce
Connect to a database and run 'await db.query('PRAGMA table_info("xxxx");')

Expected behavior
No error message is given and it returns an array

  • OS: [e.g. iOS] Android
  • Browser [e.g. chrome, safari] Brave
  • Version [e.g. 22] 5.5.2

Additional context
This was working in version 5.0.6 and likely in version 5.4

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions