[jira] Commented: (DERBY-754) Push ON clause predicates down when optimizing SELECT queries.

[ http://issues.apache.org/jira/browse/DERBY-754?page=comments#action_12363086 ] Rick Hillegas commented on DERBY-754: - I spent a little time looking for cases which this patch breaks and didn't find any. That's a hopeful sign that this patch may very

[jira] Created: (DERBY-821) Client driver: Implicitly close exhausted result sets on the server

Client driver: Implicitly close exhausted result sets on the server - Key: DERBY-821 URL: http://issues.apache.org/jira/browse/DERBY-821 Project: Derby Type: Improvement Components: Network

[jira] Created: (DERBY-822) Client driver: Pre-fetch data on executeQuery()

Client driver: Pre-fetch data on executeQuery() --- Key: DERBY-822 URL: http://issues.apache.org/jira/browse/DERBY-822 Project: Derby Type: Improvement Components: Network Client, Network Server, Performance

Re: [jira] Commented: (DERBY-810) intermittent diff for store/RecoveryAfterBackup.java test

DVC( == David Van Couvering (JIRA) derby-dev@db.apache.org writes: DVC( [ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12363024 ] DVC( David Van Couvering commented on DERBY-810: DVC( --- DVC( I applied this

Re: Tests hanging - any hints?

DWVC == David W Van Couvering [EMAIL PROTECTED] writes: DWVC Hi, all. I've been running tests with the new i18n framework, which DWVC included having all public methods throw SQLException instead of DWVC org.apache.derby.client.am.SqlException. DWVC For reasons that are

[jira] Commented: (DERBY-326) Improve streaming of large objects for network server and client

[ http://issues.apache.org/jira/browse/DERBY-326?page=comments#action_12363096 ] Tomohito Nakayama commented on DERBY-326: - I tried ClobTest from Sunitha. Next is the result. before patch: [EMAIL PROTECTED]:~/derby/test/20060118/ClobTest$ ./run.ksh

[jira] Commented: (DERBY-823) Minor patches to client/net/(Reply|Request).java to use System.arrayCopy and java.util.Arrays

[ http://issues.apache.org/jira/browse/DERBY-823?page=comments#action_12363111 ] Anders Morken commented on DERBY-823: - Modified by the above patch: M java/client/org/apache/derby/client/net/Request.java M

Re: [jira] Updated: (DERBY-816) In DDMWriter and DDMReader, use system routines in java.util.Arrays and System.arrayCopy

Anders Morken: Bryan Pendleton: Knut Anders Hatlen (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-816?page=all ] I believe there are also some places in the client code where it could be beneficial to use System.arraycopy and/or Arrays.fill. For example, in

Re: Tests hanging - any hints?

Thanks, great tips, I'll check this out. David Bryan Pendleton wrote: David W. Van Couvering wrote: For reasons that are mystifying me, in tests that prepare a statement which deal with stored procedures/functions (either to create or to drop), the client hangs waiting for a description of

Re: [jira] Updated: (DERBY-816) In DDMWriter and DDMReader, use system routines in java.util.Arrays and System.arrayCopy

On Jan 18, 2006, at 7:57 AM, Anders Morken wrote:Created a sub-task of DERBY-212 in JIRA for these patches, DERBY-823. For some reason it's flagged as a "Major" priority, which is obviously wrong, but I can't change it. Hi Anders,This is because you had not yet requested to be a member of the

Re: [jira] Commented: (DERBY-810) intermittent diff for store/RecoveryAfterBackup.java test

Øystein Grøvlen wrote: DVC( == David Van Couvering (JIRA) derby-dev@db.apache.org writes: DVC( [ http://issues.apache.org/jira/browse/DERBY-810?page=comments#action_12363024 ] DVC( David Van Couvering commented on DERBY-810: DVC( ---

[jira] Updated: (DERBY-823) Minor patches to client/net/(Reply|Request).java to use System.arrayCopy and java.util.Arrays

[ http://issues.apache.org/jira/browse/DERBY-823?page=all ] Anders Morken updated DERBY-823: Component: Newcomer Description: Environment: Assign To: Anders Morken Priority: Trivial (was: Major) Minor patches to

Re: [jira] Commented: (DERBY-398) Exclude tests for J2ME/CDC/Foundation platform

On 1/17/06, Kathey Marsden (JIRA) derby-dev@db.apache.org wrote: [ http://issues.apache.org/jira/browse/DERBY-398?page=comments#action_12363075 ] Kathey Marsden commented on DERBY-398: -- I committed this patch except the wisconsin changes.

[jira] Commented: (DERBY-326) Improve streaming of large objects for network server and client

[ http://issues.apache.org/jira/browse/DERBY-326?page=comments#action_12363121 ] Sunitha Kambhampati commented on DERBY-326: --- Thanks Tomohito for trying out the test. Too many short lived objects will slow down performance and I dont think it

[jira] Resolved: (DERBY-810) intermittent diff for store/RecoveryAfterBackup.java test

[ http://issues.apache.org/jira/browse/DERBY-810?page=all ] David Van Couvering resolved DERBY-810: --- Resolution: Fixed Committed revision 370195 intermittent diff for store/RecoveryAfterBackup.java test

Re: [jira] Updated: (DERBY-823) Minor patches to client/net/(Reply|Request).java to use System.arrayCopy and java.util.Arrays

The patch looks good, I'm building and will run some basic sanity tests and will check it in. David Anders Morken (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-823?page=all ] Anders Morken updated DERBY-823: Attachment:

[jira] Assigned: (DERBY-700) Derby does not prevent dual boot of database from different classloaders on Linux

[ http://issues.apache.org/jira/browse/DERBY-700?page=all ] Suresh Thalamati reassigned DERBY-700: -- Assign To: Suresh Thalamati Derby does not prevent dual boot of database from different classloaders on Linux

[jira] Commented: (DERBY-808) PreparedStatements can take longer to execute than Statements. There seem to be a problem with searchClauseTransitiveClosure method in PredicateList.java

[ http://issues.apache.org/jira/browse/DERBY-808?page=comments#action_12363131 ] Satheesh Bandaram commented on DERBY-808: - Sounds like a good advise. I will open a new enhancement to improve this search clause transitive closure method. Note I

[jira] Commented: (DERBY-808) PreparedStatements can take longer to execute than Statements. There seem to be a problem with searchClauseTransitiveClosure method in PredicateList.java

[ http://issues.apache.org/jira/browse/DERBY-808?page=comments#action_12363136 ] Satheesh Bandaram commented on DERBY-808: - Submitted this fix to trunk. Sendingjava\engine\org\apache\derby\impl\sql\compile\PredicateList.java Transmitting

[jira] Resolved: (DERBY-808) PreparedStatements can take longer to execute than Statements. There seem to be a problem with searchClauseTransitiveClosure method in PredicateList.java

[ http://issues.apache.org/jira/browse/DERBY-808?page=all ] Satheesh Bandaram resolved DERBY-808: - Fix Version: 10.1.2.2 Resolution: Fixed Fix has been submitted to trunk and 10.1 branches. PreparedStatements can take longer to execute

[jira] Closed: (DERBY-808) PreparedStatements can take longer to execute than Statements. There seem to be a problem with searchClauseTransitiveClosure method in PredicateList.java

[ http://issues.apache.org/jira/browse/DERBY-808?page=all ] Satheesh Bandaram closed DERBY-808: --- I have verified the fix addresses customer issue reported, so closing this. Not able to share their test case though. PreparedStatements can take

[jira] Commented: (DERBY-815) Prevent unneeded object creation and excessive decoding in parseSQLDTA_work()

[ http://issues.apache.org/jira/browse/DERBY-815?page=comments#action_12363142 ] Dyre Tjeldvoll commented on DERBY-815: -- From profiling I have seen that this method has some sub-optimal use of Vectors, and I am close to submitting a patch for this.

Re: [jira] Commented: (DERBY-754) Push ON clause predicates down when optimizing SELECT queries.

Rick Hillegas (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-754?page=comments#action_12363086 ] Rick Hillegas commented on DERBY-754: - I spent a little time looking for cases which this patch breaks and didn't find any. That's a hopeful

[jira] Commented: (DERBY-754) Push ON clause predicates down when optimizing SELECT queries.

[ http://issues.apache.org/jira/browse/DERBY-754?page=comments#action_12363143 ] A B commented on DERBY-754: --- Thanks for the review, Rick. As indicated here: http://article.gmane.org/gmane.comp.apache.db.derby.devel/12239 I think it might be good to

[jira] Updated: (DERBY-210) Network Server will leak prepared statements if not explicitly closed by the user until the connection is closed

[ http://issues.apache.org/jira/browse/DERBY-210?page=all ] Deepa Remesh updated DERBY-210: --- Attachment: (was: derby-210_10.1.diff) Network Server will leak prepared statements if not explicitly closed by the user until the connection is closed

[jira] Updated: (DERBY-210) Network Server will leak prepared statements if not explicitly closed by the user until the connection is closed

[ http://issues.apache.org/jira/browse/DERBY-210?page=all ] Deepa Remesh updated DERBY-210: --- Attachment: (was: derby-210_10.1.status) Network Server will leak prepared statements if not explicitly closed by the user until the connection is closed

[jira] Created: (DERBY-824) Enhance logic in PredicateList to use variant type of expression while determining search clauses or predicates, instead of using ConstantNode or ParameterNodes directly.

Enhance logic in PredicateList to use variant type of expression while determining search clauses or predicates, instead of using ConstantNode or ParameterNodes directly.

[jira] Commented: (DERBY-491) Protocol exception when Network Server tries to return ~32K of data or greater in a result set for a Java stored procedure.

[ http://issues.apache.org/jira/browse/DERBY-491?page=comments#action_12363145 ] Kathey Marsden commented on DERBY-491: -- The change looks good. When you sync up, it would be good to add some comments about the changes to the code and include a

[jira] Commented: (DERBY-210) Network Server will leak prepared statements if not explicitly closed by the user until the connection is closed

[ http://issues.apache.org/jira/browse/DERBY-210?page=comments#action_12363147 ] Deepa Remesh commented on DERBY-210: This patch is causing a regression in the nightlies with Sun JDK1.5. The test lang/updatableResultset.java is failing in

Failures in latest revisions

I got some test failures in derbynetclient mats, so I checked the tinderbox. We have quite a number of failures on the latest revision that ran tests, 370061, running on Solaris 10 x86: http://www.multinet.no/~solberg/public/Apache/TinderBox_Derby/Limited/testSummary-370061.html derbylang: 1

[jira] Resolved: (DERBY-823) Minor patches to client/net/(Reply|Request).java to use System.arrayCopy and java.util.Arrays

[ http://issues.apache.org/jira/browse/DERBY-823?page=all ] David Van Couvering resolved DERBY-823: --- Fix Version: 10.2.0.0 Resolution: Fixed Committed revision 370240 Minor patches to client/net/(Reply|Request).java to use

[jira] Closed: (DERBY-823) Minor patches to client/net/(Reply|Request).java to use System.arrayCopy and java.util.Arrays

[ http://issues.apache.org/jira/browse/DERBY-823?page=all ] Anders Morken closed DERBY-823: --- Thank you, guys, for finding me a nice newcomer task and accepting the patch. =) Minor patches to client/net/(Reply|Request).java to use System.arrayCopy and

Re: Failures in latest revisions

David W. Van Couvering wrote: I got some test failures in derbynetclient mats, so I checked the tinderbox. We have quite a number of failures on the latest revision that ran tests, 370061, running on Solaris 10 x86:

[jira] Commented: (DERBY-649) Useful indexes not used in UNION ALL

[ http://issues.apache.org/jira/browse/DERBY-649?page=comments#action_12363153 ] Satheesh Bandaram commented on DERBY-649: - Fix ported from 10.1 branch to trunk. Sendingjava\engine\org\apache\derby\impl\sql\compile\PredicateList.java

[jira] Commented: (DERBY-772) Handle pushing IN predicates into UNIONs. This would allow use of index if present improving performance.

[ http://issues.apache.org/jira/browse/DERBY-772?page=comments#action_12363154 ] Satheesh Bandaram commented on DERBY-772: - Ported this fix to 10.2, now that Dan's failing test case has been fixed for DERBY-649. Sending

[jira] Resolved: (DERBY-772) Handle pushing IN predicates into UNIONs. This would allow use of index if present improving performance.

[ http://issues.apache.org/jira/browse/DERBY-772?page=all ] Satheesh Bandaram resolved DERBY-772: - Fix Version: 10.1.3.0 Resolution: Fixed Fix in both 10.1 and trunk. Handle pushing IN predicates into UNIONs. This would allow use of

[jira] Closed: (DERBY-772) Handle pushing IN predicates into UNIONs. This would allow use of index if present improving performance.

[ http://issues.apache.org/jira/browse/DERBY-772?page=all ] Satheesh Bandaram closed DERBY-772: --- Verified customer problem is fixed in 10.2. Fix already present in 10.1 branch. Handle pushing IN predicates into UNIONs. This would allow use of index

[jira] Closed: (DERBY-649) Useful indexes not used in UNION ALL

[ http://issues.apache.org/jira/browse/DERBY-649?page=all ] Satheesh Bandaram closed DERBY-649: --- Fix has been verified against customer database and query on 10.2 and 10.1. Useful indexes not used in UNION ALL

[jira] Resolved: (DERBY-649) Useful indexes not used in UNION ALL

[ http://issues.apache.org/jira/browse/DERBY-649?page=all ] Satheesh Bandaram resolved DERBY-649: - Fix Version: 10.2.0.0 10.1.3.0 10.1.2.2 Resolution: Fixed Fix checked into both 10.1 and trunk. Useful

[jira] Updated: (DERBY-398) Exclude tests for J2ME/CDC/Foundation platform

[ http://issues.apache.org/jira/browse/DERBY-398?page=all ] Deepa Remesh updated DERBY-398: --- Attachment: wisc_rename_patch.diff wisc_rename_patch.status Attaching 'wisc_rename_patch.diff'. Test lang/wisconsin.java was failing in all

[jira] Updated: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

[ http://issues.apache.org/jira/browse/DERBY-819?page=all ] Anurag Shekhar updated DERBY-819: - Attachment: (was: embedexception.diff) Provide JDBC4 SQLException subclasses support in Embedded driver

[jira] Updated: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

[ http://issues.apache.org/jira/browse/DERBY-819?page=all ] Anurag Shekhar updated DERBY-819: - Attachment: stat.out Provide JDBC4 SQLException subclasses support in Embedded driver

[jira] Updated: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

[ http://issues.apache.org/jira/browse/DERBY-819?page=all ] Anurag Shekhar updated DERBY-819: - Attachment: (was: stat.out) Provide JDBC4 SQLException subclasses support in Embedded driver

[jira] Updated: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

[ http://issues.apache.org/jira/browse/DERBY-819?page=all ] Anurag Shekhar updated DERBY-819: - Attachment: derby-819.diff changes from last patch moved SQLException method (getSQLException) to InternalDriver moved JDBC40ExceptionFactory metod to

[jira] Commented: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

[ http://issues.apache.org/jira/browse/DERBY-819?page=comments#action_12363186 ] David Van Couvering commented on DERBY-819: --- Quick question: what tests did you run, and what were the results? For future patches, it's great to provide this

documenting DERBY -783: Enhancements to ALTER TABLE

Can you please confirm or correct my assumption about what is needed to document the enhancements to ALTER TABLE syntax.Is the only change to update the ALTER TABLE syntax in the Reference Guide to includeRESTART WITH integer-constant:ALTER TABLE table-Name { ADD COLUMN

[jira] Commented: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

[ http://issues.apache.org/jira/browse/DERBY-819?page=comments#action_12363187 ] David Van Couvering commented on DERBY-819: --- Hi, Anurag, Thanksk for this patch. In general this looks pretty straightforward. Here are some comments - It would

Re: documenting GRANT/REVOKE

Hi Eric, Thanks for attempting to document GRANT/REVOKE. I think there should be two topics in the reference manual... one for Grant and another for Revoke. There are other changes that need to go into reference manual as well, like the new system tables and their schema. Let me know if you

Re: [jira] Commented: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

Hi David I executed derbyall on solaris10-x86. There were 10 failures. But none of them were related to ExbeddedException or Exception message The failed tests on the non netwerk side are derbyall/derbyall.fail:lang/wisconsin.java derbyall/derbyall.fail:tools/iepnegativetests.sql

Re: [jira] Commented: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

Hi David I will made the changes. please see inline thanks anurag David Van Couvering (JIRA) wrote: - Why do you set the territory to en_US? I am printing the message so in case the default locale is not the same as I used to generate the original out file it will fail. So I am setting

Re: [jira] Commented: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

Anurag, go to bed! :) David Anurag Shekhar wrote: Hi David I executed derbyall on solaris10-x86. There were 10 failures. But none of them were related to ExbeddedException or Exception message The failed tests on the non netwerk side are derbyall/derbyall.fail:lang/wisconsin.java

[jira] Commented: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

[ http://issues.apache.org/jira/browse/DERBY-819?page=comments#action_12363193 ] Daniel John Debrunner commented on DERBY-819: - The method Driver40.getJDBC40Exception() can never return null but its caller checks for a null return. This

Re: Failures in latest revisions

David W. Van Couvering wrote: in- one e-mail: derbyall: 12 failures and then a follow up Personally, if more than three to five tests are failing in derbyall then I think we have a problem. Or if we are seeing a general increase in failures rather than a decrease. So as a committer you

[jira] Commented: (DERBY-398) Exclude tests for J2ME/CDC/Foundation platform

[ http://issues.apache.org/jira/browse/DERBY-398?page=comments#action_12363197 ] Kathey Marsden commented on DERBY-398: -- Checked in the patch to rename the wisconsin.sql file. ran lang/wisconsin.java for all frameworks. Date: Wed Jan 18 17:35:27 2006

Re: Failures in latest revisions

How does a committer stop all further checkins? By backing out every checkin that comes in? Or is there a way to do this through svn? Not that I'm ready to do that, I'd like to see how things go. But it would be good to know how this is done. David Daniel John Debrunner wrote: David W.

Re: Failures in latest revisions

Is there anyone who's got the power of locking the trunk? ;-)On 1/18/06, David W. Van Couvering [EMAIL PROTECTED] wrote:How does a committer stop all further checkins?By backing out every checkin that comes in?Or is there a way to do this through svn?Not that I'm ready to do that, I'd like to see

Re: [jira] Commented: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

Anurag Shekhar wrote: Hi David I will made the changes. please see inline thanks anurag David Van Couvering (JIRA) wrote: - Why do you set the territory to en_US? I am printing the message so in case the default locale is not the same as I used to generate the original out file it will

Re: Failures in latest revisions

Francois Orsini wrote: Is there anyone who's got the power of locking the trunk? ;-) Any committer through a veto. Dan.

[jira] Commented: (DERBY-819) Provide JDBC4 SQLException subclasses support in Embedded driver

[ http://issues.apache.org/jira/browse/DERBY-819?page=comments#action_12363205 ] Daniel John Debrunner commented on DERBY-819: - Index: java/testing/org/apache/derbyTesting/functionTests/tests/jdbc4/TestException_app.properties