#184 SQLbuilder aliases fail for Firebird

closed-fixed
Oleg Broytman
5
2006-08-24
2006-07-03
Henrik Weber
No

Creating a table alias with SQLBuilder will alway
create alias clauses of the form:

orig_table AS alias_name

SQLbuilder does not discriminate between different SQL
dialects here.

For Firebird this syntax variant fails, because
aliases are defined without the AS keyword there:

orig_table alias_name

The AS keyword will generate a syntax error with
Firebird.

Discussion

  • Henrik Weber
    Henrik Weber
    2006-07-04

    Logged In: YES
    user_id=121229

    Forgot to mention: this is with SQLobject 0.7.0

     
  • Oleg Broytman
    Oleg Broytman
    2006-08-24

    Logged In: YES
    user_id=4799

    I found most database (I tested MySQL, PostgreSQL and
    SQLite) ignore that noisy "AS" so I just removed it from the
    queries for all backends. Committed in the revision 1883 to
    the trunk, rev. 1884 to the 0.7-branch.

     
  • Oleg Broytman
    Oleg Broytman
    2006-08-24

    • assigned_to: nobody --> phd
    • status: open --> closed-fixed