[DERBY-4608] Unnecessary conversion of binary values to strings in SQLBinary.compare()

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.5.3.0
• Fix Version/s: 10.6.1.0
• Component/s: SQL
• Bug behavior facts: Performance
• Assignee: Knut Anders Hatlen
• Reporter: Knut Anders Hatlen
• Created: 06/Apr/10 09:04
• Updated: 30/Apr/10 11:45
• Resolved: 06/Apr/10 15:53

Description

SQLBinary.compare(int,DataValueDescriptor,boolean,boolean) converts the values to strings in order to check whether any of them are null. The isNull() method should be used instead to prevent the unnecessary conversion to strings.

See this thread on derby-user: http://mail-archives.apache.org/mod_mbox/db-derby-user/201003.mbox/%3C001801cad09b$09aef650$1d0ce2f0$@ru%3E