Issue Details (XML | Word | Printable)

Key: DERBY-3741
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Suran Jayathilaka
Reporter: Kathey Marsden
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

SQL LENGTH function materializes CLOB into memory

Created: 27/Jun/08 10:50 PM   Updated: 30/Jun/09 04:02 PM
Return to search
Component/s: SQL
Affects Version/s: 10.3.3.0, 10.4.1.3, 10.5.1.1
Fix Version/s: 10.3.3.1, 10.4.2.0, 10.5.1.1

Time Tracking:
Not Specified

File Attachments:
  File Name Date Attached Attached By Size
Java Source File Licensed for inclusion in ASF works ClobMemTest.java 2008-07-23 02:40 AM Suran Jayathilaka 8 kB
File Licensed for inclusion in ASF works derby-3741-1.diff 2008-07-24 03:28 AM Suran Jayathilaka 11 kB
File Licensed for inclusion in ASF works derby-3741-2.diff 2008-07-27 05:25 PM Suran Jayathilaka 11 kB
File Licensed for inclusion in ASF works derby-3741-mergeto-10.4-new.diff 2008-08-11 07:36 PM Suran Jayathilaka 142 kB
File Licensed for inclusion in ASF works derby-3741-mergeto-10.4.diff 2008-08-11 06:00 PM Suran Jayathilaka 142 kB
File Licensed for inclusion in ASF works derby-3741-multibyte_test.diff 2008-08-02 12:19 PM Suran Jayathilaka 7 kB
Text File Licensed for inclusion in ASF works derby-3741_multibyteclobtest_update_diff.txt 2008-08-04 03:57 PM Kathey Marsden 8 kB
Text File Licensed for inclusion in ASF works derby.log 2008-08-11 07:01 PM Suran Jayathilaka 179 kB
Zip Archive Licensed for inclusion in ASF works LargeLengthClob.zip 2008-07-03 04:56 PM Kathey Marsden 1 kB
Issue Links:
Reference

Issue & fix info: High Value Fix
Resolution Date: 13/Aug/08 04:52 PM


 Description  « Hide
Similar to DERBY-3732, the SQL LENGTH function also materializes CLOB's into memory. See attached repro.

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Repository Revision Date User Message
ASF #680478 Mon Jul 28 20:20:37 UTC 2008 kmarsden DERBY-3741 SQL LENGTH function materializes CLOB into memory

Contributed by Suran Jayathilaka
Files Changed
ADD /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/memory/ClobMemTest.java
MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/memory/_Suite.java
MODIFY /db/derby/code/trunk/java/engine/org/apache/derby/iapi/types/SQLChar.java

Repository Revision Date User Message
ASF #682693 Tue Aug 05 12:37:24 UTC 2008 kmarsden DERBY-3741 SQL LENGTH function materializes CLOB into memory

Add test for multibyte characters. Enabled test for embedded only as client test takes an extremely long time to run.
Files Changed
ADD /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/memory/MultiByteClobTest.java
MODIFY /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/memory/_Suite.java

Repository Revision Date User Message
ASF #685028 Tue Aug 12 03:50:57 UTC 2008 kmarsden DERBY-3741 SQL LENGTH function materializes CLOB into memory

Contributed by Suran Jayathilaka
Files Changed
ADD /db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/tests/memory/MultiByteClobTest.java
ADD /db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/tests/memory/ClobMemTest.java
MODIFY /db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/tests/memory/_Suite.java
MODIFY /db/derby/code/branches/10.4/java/engine/org/apache/derby/iapi/types/SQLChar.java

Repository Revision Date User Message
ASF #692118 Thu Sep 04 15:48:25 UTC 2008 kmarsden DERBY-3741 SQL LENGTH function materializes CLOB into memory
Contributed by Suran Jayathilaka

DERBY-3213 SQLChar.trim method is unused and could be removed
Contributed by Deepthi Devaki
Files Changed
ADD /db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/memory/MultiByteClobTest.java (from /db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/tests/memory/MultiByteClobTest.java)
MODIFY /db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/memory/_Suite.java
MODIFY /db/derby/code/branches/10.3/java/engine/org/apache/derby/iapi/types/StringDataValue.java
ADD /db/derby/code/branches/10.3/java/testing/org/apache/derbyTesting/functionTests/tests/memory/ClobMemTest.java (from /db/derby/code/branches/10.4/java/testing/org/apache/derbyTesting/functionTests/tests/memory/ClobMemTest.java)
MODIFY /db/derby/code/branches/10.3/java/engine/org/apache/derby/iapi/types/SQLChar.java


Powered by a free Atlassian JIRA open source license for Apache Software Foundation. Try JIRA - bug tracking software for your team.
Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13.2-#335) - Bug/feature request - Atlassian news - Contact Administrators