Opened 17 years ago

Closed 17 years ago

#7055 closed (fixed)

Join alias sql should not use AS keyword

Reported by: Erin Kelly Owned by: nobody
Component: Core (Other) Version: queryset-refactor
Severity: Keywords: qs-rf
Cc: Triage Stage: Unreviewed
Has patch: yes Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: no UI/UX: no

Description

When specifying aliases for joins, the optional keyword 'AS' should not be used. Oracle doesn't like it.

Attachments (1)

join_alias_no_as.diff (1.1 KB ) - added by Erin Kelly 17 years ago.

Download all attachments as: .zip

Change History (2)

by Erin Kelly, 17 years ago

Attachment: join_alias_no_as.diff added

comment:1 by Malcolm Tredinnick, 17 years ago

Resolution: fixed
Status: newclosed

(In [7439]) queryset-refactor: Don't use the "AS" keyword in the FROM-clause. Fixed #7055.
Patch from Ian Kelly.

This keyword is optional in SQL, but not permitted by Oracle. If we ever need
to support a backend that requires this keyword at some later date, we can make
it a connection.feature option, but that's overkill for now.

Note: See TracTickets for help on using tickets.
Back to Top