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)
Change History (2)
by , 17 years ago
Attachment: | join_alias_no_as.diff added |
---|
comment:1 by , 17 years ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Note:
See TracTickets
for help on using tickets.
(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.