Opened 10 years ago

Closed 10 years ago

#7055 closed (fixed)

Join alias sql should not use AS keyword

Reported by: Ian 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: UI/UX:


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 Ian Kelly 10 years ago.

Download all attachments as: .zip

Change History (2)

Changed 10 years ago by Ian Kelly

Attachment: join_alias_no_as.diff added

comment:1 Changed 10 years ago by Malcolm Tredinnick

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