Genezzo

 view release on metacpan or  search on metacpan

TODO  view on Meta::CPAN

TODO lib/Genezzo/Parse/SQL.pm
    alter table (elcaro MODIFY column NOT NULL) vs (sql3 ALTER COLUMN)...
    Support for DDL, ANSI Interval, Date, Timestamp, etc.
    fix the extra array deref in join rules
    error messages everywhere
    ECOUNT reserved word issues
    TRIM, UPPER, etc in standard function list?
    use of negative lookahead in reserved_word regex?
    table constraint, storage clause
    constraint attributes - deferrable, disable
    delete cascade referential action
    maybe can collapse qualified join with qj_leftop?
    table expr optional column list
    "system" literals like USER, SYSDATE
    better separation of strings and numbers (see concatenate)
    leading NOT
    double colon in function names?
TODO lib/Genezzo/Plan.pm
    SQLWhere2: need to allow rownum in where clause, which means we need a
    rownum rowsource [select * from dual where rownum < 10; ]
    update pod

lib/Genezzo/Parse/SQL.pm  view on Meta::CPAN

=item ECOUNT reserved word issues

=item TRIM, UPPER, etc in standard function list?

=item use of negative lookahead in reserved_word regex?

=item table constraint, storage clause

=item constraint attributes - deferrable, disable

=item delete cascade referential action

=item maybe can collapse qualified join with qj_leftop?

=item table expr optional column list

=item "system" literals like USER, SYSDATE

=item better separation of strings and numbers (see concatenate)

=item leading NOT

lib/Genezzo/Parse/SQLGrammar.pl  view on Meta::CPAN

        }
}

# use to disambiguate column list for FOREIGN KEY and list for REFERENCES
 fkref_column_list: column_list
{$return = $item[1]}

  constraint_name : CONSTRAINT_ big_id
{$return = $item{big_id}}

# XXX XXX: references on delete cascade - referential action
     col_cons     : NOT(?) NULL
{$return = {operator => $item[2],
            cons_type => 'nullable',
            operands => $item{'NOT(?)'}            
            }}
                  | UNIQUE
{$return = {operator => $item[1],
            cons_type => 'unique'
            }}
                  | PRIMARY KEY

lib/Genezzo/Parse/SQLGrammar.pl  view on Meta::CPAN

#=item ECOUNT reserved word issues
#
#=item TRIM, UPPER, etc in standard function list?
#
#=item use of negative lookahead in reserved_word regex?
#
#=item table constraint, storage clause
#
#=item constraint attributes - deferrable, disable
#
#=item delete cascade referential action
#
#=item maybe can collapse qualified join with qj_leftop?
#
#=item table expr optional column list
#
#=item "system" literals like USER, SYSDATE
#
#=item better separation of strings and numbers (see concatenate)
#
#=item leading NOT