oracle / quicksql

A library for generating DDL SQL and entity-relationship-diagrams from Quick SQL code
Universal Permissive License v1.0
53 stars 11 forks source link

Generated PL/SQL Table API Lists Foreign Key Columns Twice, Producing Error #39

Closed stevemuench closed 9 months ago

stevemuench commented 11 months ago

Reporting an issue from APEX discussion forum thread:

https://forums.oracle.com/ords/apexds/post/quick-sql-bug-in-api-generation-4298

Quick SQL Testcase:

feature_masters
    name

app_feature_items
   feature_master_id number /fk feature_masters
   name vc255 /nn

#api:y

Bug is that this produces PL/SQL APIs with the feature_master_id column repeated twice as follows:

    procedure get_row (
        p_id        in  number,
        p_feature_master_id   out  number,
        p_feature_master_id   out  number,
        p_name   out  varchar2
    );

    procedure insert_row (
        p_id        in  number default null,
        p_feature_master_id    in  number default null,
        p_feature_master_id    in  number default null,
        p_name    in  varchar2 default null
    );

    procedure update_row (
        p_id        in  number default null,
        p_feature_master_id    in  number default null,
        p_feature_master_id    in  number default null,
        p_name    in  varchar2 default null
    );
vadim-tropashko commented 9 months ago

1.2.1