Skip to content

CATALOG.ASSOCIATIONS table missing from catalog #419

Closed

Description

@retran

Description

REFRESH CATALOG FULL does not create a CATALOG.ASSOCIATIONS table. Querying SELECT * FROM CATALOG.ASSOCIATIONS returns nothing (no error, no results). The table is not listed in SHOW CATALOG TABLES.

Reproduction

REFRESH CATALOG FULL;
SHOW CATALOG TABLES;
-- No CATALOG.ASSOCIATIONS in list (41 tables shown, associations not among them)

SELECT * FROM CATALOG.ASSOCIATIONS LIMIT 5;
-- Returns nothing (empty output, no error)

Meanwhile SHOW ASSOCIATIONS works and returns 272 associations.

Expected

Either:

  • CATALOG.ASSOCIATIONS table exists and is queryable, OR
  • Clear error "table not found" when querying it

Environment

  • mxcli: v0.7.0-257-ga07e7e0
  • Project: EnquiriesManagement (Mendix 11.8.0, 272 associations)

Notes

Previously reported as BUG-003 (not reproduced) in PR #386 initial session. Now confirmed: the table simply doesn't exist in the catalog schema.

Related

Activity

  1. github-actions commented on Apr 30, 2026

    @github-actions

    Issue Triage

    Summary:
    The CATALOG.ASSOCIATIONS table is not created by REFRESH CATALOG FULL, so queries against it return empty results instead of data or an error.

    Checklist (bug report)

    • ✅ mxcli version (v0.7.0-257-ga07e7e0)
    • ✅ Mendix version (11.8.0)
    • ✅ Scenario (running REFRESH CATALOG FULL then querying CATALOG.ASSOCIATIONS)
    • ✅ Expected output (table should exist and be queryable, or give a clear “table not found” error)
    • ✅ Experienced output (table missing from SHOW CATALOG TABLES; query returns no rows, no error)
    • ❌ AI bug report / session log (output of mxcli diag --bundle or at least the session log)

    Missing information:
    Could you please provide the session log or run mxcli diag --bundle and attach the resulting archive? This will help us diagnose why the associations table isn’t being populated. Thank you!


    Automated triage via OpenRouter — workflow source

  2. retran commented on Apr 30, 2026

    @retran
    ContributorAuthor

    Reproducing test cases: entity-test-cases.md §19.2

  3. added a commit that references this issue on Sep 8, 2026
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

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