CATALOG.ASSOCIATIONS table missing from catalog

[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

• docs: add manual test case documentation for all MDL command areas #386 (test case documentation — entity test 19.2)

[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

[retran]

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