Re: [Sqlalchemy-tickets] [sqlalchemy] #1917: When column identifier is quoted in Oracle query, the table alias is missing

[sqlalchemy <mi...@zz...>]

#1917: When column identifier is quoted in Oracle query, the table alias is
missing
--------------------+-------------------------------------------------------
 Reporter:  guest   |          Owner:  zzzeek                  
     Type:  defect  |         Status:  new                     
 Priority:  medium  |      Milestone:  0.6.5                   
Component:  oracle  |       Severity:  minor - half an hour    
 Keywords:          |   Status_field:  needs questions answered
--------------------+-------------------------------------------------------
Changes (by zzzeek):

  * status_field:  awaiting triage => needs questions answered
  * severity:  no triage selected yet => minor - half an hour
  * milestone:  => 0.6.5


Comment:

 yup....sorry, the rule still stands, need a test case, I just took the
 time and it works fine:

 {{{
 #!python
 from sqlalchemy import *
 from sqlalchemy.dialects import oracle
 m = MetaData()
 t = Table("t", m,
     Column("x", Integer),
     Column("group", Integer)
 )
 print
 t.select().where(t.c.group==5).order_by(t.c.group).compile(dialect=oracle.dialect())

 }}}

 {{{
 SELECT t.x, t."group"
 FROM t
 WHERE t."group" = :group_1 ORDER BY t."group"
 }}}

-- 
Ticket URL: <http://www.sqlalchemy.org/trac/ticket/1917#comment:2>
sqlalchemy <http://www.sqlalchemy.org/>
The Database Toolkit for Python