|
From: SourceForge.net <no...@so...> - 2006-08-24 15:38:54
|
Bugs item #1516394, was opened at 2006-07-03 18:56 Message generated for change (Comment added) made by phd You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1516394&group_id=74338 Please note that this message will contain a full copy of the comment thread, including the initial issue submission, for this request, not just the latest update. Category: Firebird/Interbase Group: SQLObject release (specify) >Status: Closed >Resolution: Fixed Priority: 5 Submitted By: Henrik Weber (hweber) >Assigned to: Oleg Broytmann (phd) Summary: SQLbuilder aliases fail for Firebird Initial Comment: 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. ---------------------------------------------------------------------- >Comment By: Oleg Broytmann (phd) Date: 2006-08-24 19:38 Message: 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. ---------------------------------------------------------------------- Comment By: Henrik Weber (hweber) Date: 2006-07-04 22:37 Message: Logged In: YES user_id=121229 Forgot to mention: this is with SQLobject 0.7.0 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=540672&aid=1516394&group_id=74338 |
