Opened 18 years ago
Closed 18 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 , 18 years ago
| Attachment: | join_alias_no_as.diff added |
|---|
comment:1 by , 18 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.