Skip to content

SQLite connection with automatically attached databases does not show the correct schema #984

@punkish

Description

@punkish

My connection info

Name: zenodeo
Connection Type: SQLite
Storage Type: File
File: /Users/punkish/Projects/zenodeo3/data/db/zenodeo.sqlite
Post-Connection SQL Source: Inline Script
SQL Script:
    ATTACH DATABASE '/Users/punkish/Projects/zenodeo3/data/db/archive.sqlite' AS arc;
    ATTACH DATABASE '/Users/punkish/Projects/zenodeo3/data/db/geo.sqlite' AS geo;
    ATTACH DATABASE '/Users/punkish/Projects/zenodeo3/data/db/zai.sqlite' AS zai;

Screenshot 1 showing all the dbs

Image

Screenshot 2 showing the main db correctly

Image

Screenshot 3 showing the attached arc db incorrectly (shows identical to the main db)

Image

Screenshot 4 showing the other two attached dbs correctly

Image

Terminal output below showing the arc db schema via the SQLite commandline

zenodeo3 on  usearch [!] is 📦 v3.6.1 took 1m3s sqlite3 data/db/archive.sqlite
-- Loading resources from /Users/punkish/.sqliterc
SQLite version 3.50.4 2025-07-30 19:33:53
Enter ".help" for usage hints.
sqlite> .tables
archives               etlTransactions        transactions         
archivesView           etlView                transactionsView     
etl                    tbArchivesUpdatesView  treatmentsDump    

Environment

  • DBCode version: 1.28
  • VS Code (or fork) version: 1.109.5
  • OS: Mac OS Tahoe 26.3
  • Database: SQLite
  • Connection: direct

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