#184 SQLbuilder aliases fail for Firebird

closed-fixed
5
2006-08-24
2006-07-03
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
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:





No, thanks