Bug 124373 (DEFECT000308612) - SUM() in query failing
Summary: SUM() in query failing
Status: VERIFIED FIXED
Alias: DEFECT000308612
Product: NDS SDK
Classification: Novell Products
Component: JDBC (show other bugs)
Version: OCT 2006 NDK
Hardware: Other Other
: P5 - None : Critical
Target Milestone: ---
Assignee: Parameswaran S
QA Contact: Sundar Swamy
URL:
Whiteboard:
Keywords: English
Depends on:
Blocks:
 
Reported: 2002-07-30 18:44 UTC by Susan Perrin
Modified: 2007-06-14 16:02 UTC (History)
1 user (show)

See Also:
Found By: Customer
Services Priority:
Business Priority:
Blocker: ---
Marketing QA Status: ---
IT Deployment: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Rajkumar V 2005-10-10 22:54:45 UTC 


------- Bug moved to this database by vrajkumar@novell.com 2005-10-10 16:54 -------

This bug previously known as bug DEFECT000308612 at remedy/
remedy/show_bug.cgi?id=DEFECT000308612
Originally filed under the NDS SDK product and JDBC component.

---------
<remedy_version_found_in> Sept NDK </remedy_version_found_in>
---------
<remedy_milestone> BLANK </remedy_milestone>
---------
<remedy_details> select sum(integer_type_attribute) FROM object

fails with
SQLException: SQLState(S0000) vendor code(1023)
java.sql.SQLException: [Novell][LDAP JDBC Driver] Invalid
operand for operator: SUM
        at com.novell.sql.Errors.sqlException(Errors.java)
        at com.novell.sql.LDAPStatement.executeQuery

According to the doc, you handle integer types as integers, so I'm submitting
this as a bug. </remedy_details>