You are viewing a plain text version of this content. The canonical link for it is here.
Posted to torque-dev@db.apache.org by "Scott Eade (JIRA)" <ji...@apache.org> on 2006/06/20 05:59:29 UTC
[jira] Created: (TORQUE-33) Order By Clauses with non function
operands fail
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
Environment: Any.
Reporter: Scott Eade
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
[jira] Closed: (TORQUE-33) Order By Clauses with non function
operands fail
Posted by "Thomas Vandahl (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-33?page=all ]
Thomas Vandahl closed TORQUE-33.
--------------------------------
> Order By Clauses with non function operands fail
> ------------------------------------------------
>
> Key: TORQUE-33
> URL: http://issues.apache.org/jira/browse/TORQUE-33
> Project: Torque
> Issue Type: Bug
> Components: Runtime
> Affects Versions: 3.2
> Environment: Any.
> Reporter: Scott Eade
> Assigned To: Thomas Fischer
> Fix For: 3.3
>
> 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
[jira] Updated: (TORQUE-33) Order By Clauses with non function
operands fail
Posted by "Thomas Fischer (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-33?page=all ]
Thomas Fischer updated TORQUE-33:
---------------------------------
Version: 3.2
> 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
[jira] Updated: (TORQUE-33) Order By Clauses with non function
operands fail
Posted by "Scott Eade (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/TORQUE-33?page=all ]
Scott Eade updated TORQUE-33:
-----------------------------
Attachment: patch.txt
> 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
> Environment: Any.
> Reporter: Scott Eade
> 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
[jira] Resolved: (TORQUE-33) Order By Clauses with non function
operands fail
Posted by "Thomas Fischer (JIRA)" <ji...@apache.org>.
[ 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