[DERBY-582] Dynamic parameter should be allowed to be the operand of unary operator "-". Derby throws exception 42X36: The '-' operator is not allowed to take a ? parameter as an operand."

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.1.6
• Fix Version/s: 10.2.1.6
• Component/s: JDBC
• Assignee: Mamta A. Satoor
• Reporter: Mamta A. Satoor
• Created: 21/Sep/05 15:18
• Updated: 01/Nov/05 04:14
• Resolved: 01/Nov/05 04:14

Description

A simple test program which uses dynamic parameter for unary operator "-" fails with an exception. Following is the snippet of the code
ps = con.prepareStatement("select * from t1 where c11 = -?");
ps.setInt(1,1);
rs = ps.executeQuery();
The prepareStatement call fails with following exception
SQLSTATE(42X36):ERROR 42X36: The '-' operator is not allowed to take a ? parameter as an operand.