[
https://issues.apache.org/jira/browse/DERBY-3842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12693458#action_12693458
]
Tiago R. Espinha commented on DERBY-3842:
-----------------------------------------
I get that output indeed, but only once I do a SELECT that involves sorting.
I'm doing this test manually now, I'm running the Network Server manually from
my jars/sane/ and then throwing queries at it from ij.
I also found this pretty old Cloudscape documentation:
http://www.dwfa.ca/Library/Java/Cloudscape/v3.6.1/doc/html/coredocs/proper39.htm
and it does say there "This property is static; if you change it while
Cloudscape is running, the change does not take effect until you reboot."
I did try this. I tried setting the value with the
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.storage.sortBufferMax','5');
and then restarted the server. What I found is that the value is kept between
"sessions" but ExternalSortFactory still does not seem to see it.
In a desperate attempt, I also ignored the warning in service.properties and
set the derby.storage.sortBufferMax there manually to 5, also with no luck.
> Convert
> "org.apache.derbyTesting.functionTests.tests.store.holdCursorExternalSortJDBC30.sql"
> to junit.
> ------------------------------------------------------------------------------------------------------
>
> Key: DERBY-3842
> URL: https://issues.apache.org/jira/browse/DERBY-3842
> Project: Derby
> Issue Type: Test
> Components: Test
> Reporter: Junjie Peng
> Assignee: Tiago R. Espinha
> Attachments: derby-3842-1.patch, derby-3842-1.stat,
> derby-3842-tiago.patch
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
