Allow bulk scan of LOB tables with holdable cursors
---------------------------------------------------
Key: DERBY-4800
URL: https://issues.apache.org/jira/browse/DERBY-4800
Project: Derby
Issue Type: Improvement
Affects Versions: 10.7.0.0
Reporter: Knut Anders Hatlen
Priority: Minor
DERBY-1511 disabled bulk scans for tables with LOBs if the cursor was holdable.
This was done to work around a bug, but it had a very negative impact on
queries that scanned tables that contained relatively small LOBs. It would be
good if we could find a safe way to re-enable bulk scans for these queries.
The problem now is that the lob containers are closed on the transaction
boundaries, so the buffered values will be dead on arrival when we call next()
after a commit(). If we could find a way to make the containers survive across
the transaction boundary, or make it possible to reopen the container, it
should be safe to re-enable the bulk scans.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
