Skip to content

Exception Rendering ER Diagram Using /auditcols if audit column also explicitly mentioned #76

@stevemuench

Description

@stevemuench

APEX 24.2 (as well as the latest QuickSQL main) build throws a JavaScript exception in the ER "Diagram" tab of the QuickSQL functionality when a user (or the new "Create Data Model Using AI" feature) generates a table like this:

sp_products /auditcols
    id /pk
    name vc255 /not null
    description vc4000
    created_on date /not null
    created_by vc255 /not null
    updated_on date /not null
    updated_by vc255 /not null

The fact that columns like updated_by and created_by are implicitly added by /auditcols as well as their being explicitly mentioned yields the following JavaScript call stack exception:

rappid.min.js:14 Uncaught (in promise) Error: shapes.standard.Record: Duplicated item id.
    at dl (rappid.min.js:14:563033)
    at r.buildMarkup (rappid.min.js:14:551629)
    at r.onChange (rappid.min.js:14:550855)
    at v (backbone.js:2136:10)
    at d (backbone.js:2136:10)
    at u (backbone.js:2136:10)
    at r.trigger (backbone.js:2136:10)
    at r.set (backbone.js:2136:10)
    at r.setColumns (quick-erd.js:111:14)
    at T.addTable (quick-erd.js:226:30)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions