Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <612284336.1238254850390.JavaMail.jira@brutus>
Date: Sat, 28 Mar 2009 08:40:50 -0700 (PDT)
From: "Tiago R. Espinha (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-3842) Convert
 "org.apache.derbyTesting.functionTests.tests.store.holdCursorExternalSortJDBC30.sql"
 to junit.
In-Reply-To: <627133149.1218961666394.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ 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.