[prev in list] [next in list] [prev in thread] [next in thread] 

List:       turbine-torque-dev
Subject:    [jira] Resolved: (TORQUE-33) Order By Clauses with non function
From:       "Thomas Fischer (JIRA)" <jira () apache ! org>
Date:       2006-06-21 19:36:32
Message-ID: 18943511.1150918592093.JavaMail.jira () brutus
[Download RAW message or body]

     [ http://issues.apache.org/jira/browse/TORQUE-33?page=all ]
     
Thomas Fischer resolved TORQUE-33:
----------------------------------

    Fix Version: 3.2.1
     Resolution: Fixed
      Assign To: Thomas Fischer

Applied modified patch. The original patch would not have worked for the first \
example "table.column < 100" and also not for  "table.column<100"

> Order By Clauses with non function operands fail
> ------------------------------------------------
> 
> Key: TORQUE-33
> URL: http://issues.apache.org/jira/browse/TORQUE-33
> Project: Torque
> Type: Bug

> Components: Runtime
> Versions: 3.2
> Environment: Any.
> Reporter: Scott Eade
> Assignee: Thomas Fischer
> Fix For: 3.2.1
> Attachments: patch.txt
> 
> Many types of order by clauses no longer work
> in 3.2-rc1, they worked fine in 3.1.1 .  For example:
> ORDER BY table.column < 100
> ORDER BY table.column IN (1, 2, 3)
> ORDER BY 100 > table.column
> The cause of this is the new 
> SQLBuilder.removeSQLFunction()
> which only removes takes table.column name from inside parens.
> Migrated Scarab issue raised by Jacob Champlin (jchamplin at emocorp dot com)

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org
For additional commands, e-mail: torque-dev-help@db.apache.org


[prev in list] [next in list] [prev in thread] [next in thread]