[jira] Updated: (DERBY-3198) Using setQueryTimeout will leak sections

2007-12-05 Thread Dyre Tjeldvoll (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dyre Tjeldvoll updated DERBY-3198: -- Derby Info: [Patch Available] Using setQueryTimeout will leak sections

[jira] Commented: (DERBY-2998) Add support for ROW_NUMBER() window function

2007-12-05 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548648 ] Knut Anders Hatlen commented on DERBY-2998: --- Thanks Thomas. Committed revision 601309. I made a small

[jira] Updated: (DERBY-3198) Using setQueryTimeout will leak sections

2007-12-05 Thread Dyre Tjeldvoll (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dyre Tjeldvoll updated DERBY-3198: -- Attachment: derby-3198.v4.diff Reading Knut's comment again I realized that he was talking

[jira] Commented: (DERBY-2998) Add support for ROW_NUMBER() window function

2007-12-05 Thread Thomas Nielsen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548661 ] Thomas Nielsen commented on DERBY-2998: --- Thanks Knut - also for spotting that one... Add support for

[jira] Commented: (DERBY-3064) Implement the LogShipper that will enable the shipping of Log records from the master to the slave

2007-12-05 Thread JIRA
[ https://issues.apache.org/jira/browse/DERBY-3064?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548660 ] Øystein Grøvlen commented on DERBY-3064: Thanks for the new patch Narayanan and for fixing all the minor

[jira] Updated: (DERBY-3198) Using setQueryTimeout will leak sections

2007-12-05 Thread Dyre Tjeldvoll (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dyre Tjeldvoll updated DERBY-3198: -- Attachment: derby-3198.v5.diff Attaching v5 to address the latest comments. Using

[jira] Updated: (DERBY-3246) Minor cleanup in the Derby JUnit classes

2007-12-05 Thread Kristian Waagan (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kristian Waagan updated DERBY-3246: --- Fix Version/s: 10.4.0.0 10.3.2.2 I split removal of unused imports from

[jira] Commented: (DERBY-3238) When table contains large LOB values ( ~32K) trigger execution fails for that row with ERROR XCL30: An IOException was thrown when reading a 'BLOB'

2007-12-05 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548742 ] Kathey Marsden commented on DERBY-3238: --- The problem on 10.1 looks different than on 10.2,10.3, and 10.4 It

Regression Test Report - tinderbox_trunk16 601309 - Sun DBTG

2007-12-05 Thread Ole . Solberg
[Auto-generated mail] *tinderbox_trunk16* 601309/2007-12-05 13:12:15 CET Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* SunOS-5.10_i86pc-i386 1274273 083.95% derbyall 01012910129 0

[jira] Updated: (DERBY-3129) Create Demo code, showing how to create and use table functions.

2007-12-05 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3129?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-3129: - Attachment: derby-3129-03-lineList.diff Attaching derby-3129-03-lineList.diff and committing it

[jira] Updated: (DERBY-3217) ErrorStreamTest failing on ibm j9 jvm

2007-12-05 Thread Dyre Tjeldvoll (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dyre Tjeldvoll updated DERBY-3217: -- Derby Info: (was: [Patch Available]) Committed revision 601361 ErrorStreamTest failing on

[jira] Subscription: Derby: JIRA issues with patch available

2007-12-05 Thread jira
Issue Subscription Filter: Derby: JIRA issues with patch available (14 issues) Subscriber: derby-dev Key Summary DERBY-3198 Using setQueryTimeout will leak sections https://issues.apache.org/jira/browse/DERBY-3198 DERBY-3064 Implement the LogShipper that will enable the

[jira] Created: (DERBY-3256) Derby's reserved keyword list does not agree with either the SQL 92 or SQL 2003 standards

2007-12-05 Thread Rick Hillegas (JIRA)
Derby's reserved keyword list does not agree with either the SQL 92 or SQL 2003 standards - Key: DERBY-3256 URL: https://issues.apache.org/jira/browse/DERBY-3256

[jira] Updated: (DERBY-3256) Derby's reserved keyword list does not agree with either the SQL 92 or SQL 2003 standards

2007-12-05 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rick Hillegas updated DERBY-3256: - Attachment: keywords.tar Attaching keywords.tar. This tarball contains files which list the

[jira] Resolved: (DERBY-3049) Remove (Language) ResultSet.getResultDescription() method

2007-12-05 Thread Daniel John Debrunner (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel John Debrunner resolved DERBY-3049. -- Resolution: Fixed Fix Version/s: 10.4.0.0 Revision 601395 in trunk

[jira] Commented: (DERBY-3185) SET (TRANSACTION) ISOLATION (LEVEL) is not SQL compliant

2007-12-05 Thread Daniel John Debrunner (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548858 ] Daniel John Debrunner commented on DERBY-3185: -- Maybe a different new feature issue could be entered to

[jira] Updated: (DERBY-1585) derbylang/procedureInTrigger: not able to create trigger due to an open ResultSet

2007-12-05 Thread Daniel John Debrunner (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-1585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel John Debrunner updated DERBY-1585: - Derby Info: [Patch Available] derbylang/procedureInTrigger: not able to create

Re: [VOTE] 10.3.2.1 release candidate

2007-12-05 Thread Mamta Satoor
I did some ad-hoc testing on the release candidate using Sun's jdk142 on Windows XP and didn't find any issues. +1 from me to go ahead with the release candidate. Mamta On 11/28/07, Kathey Marsden [EMAIL PROTECTED] wrote: Please test and vote on the 10.3.2.1 release candidate, available at:

[jira] Closed: (DERBY-3245) 'java.lang.OutOfMemoryError: Java heap space' on 'SELECT count(*) FROM BID' at end of Large Datavolume test ATCJ4

2007-12-05 Thread Ole Solberg (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Ole Solberg closed DERBY-3245. -- Resolution: Invalid Confirmed being a test configuration issue. Run successfully with previous jvm

[jira] Updated: (DERBY-3206) Replication: Add functionality to send various commands from master to slave using the replication network connection

2007-12-05 Thread JIRA
[ https://issues.apache.org/jira/browse/DERBY-3206?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Øystein Grøvlen updated DERBY-3206: --- Derby Info: (was: [Patch Available]) Patch Derby3206.diff committed as revision 601331.

[jira] Resolved: (DERBY-3247) Activation for a dynamic ResultSet created from an Prepared/CallableStatement will not be closed until garbage collection indicates it is unused to the LCC and the LCC cl

2007-12-05 Thread Daniel John Debrunner (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel John Debrunner resolved DERBY-3247. -- Resolution: Fixed Fix Version/s: 10.4.0.0 Derby Info: (was:

[jira] Commented: (DERBY-3198) Using setQueryTimeout will leak sections

2007-12-05 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3198?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548655 ] Knut Anders Hatlen commented on DERBY-3198: --- The new test case looks fine. You might consider if you want

[jira] Commented: (DERBY-1585) derbylang/procedureInTrigger: not able to create trigger due to an open ResultSet

2007-12-05 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-1585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548867 ] Knut Anders Hatlen commented on DERBY-1585: --- I have a machine on which I'm able to reproduce this failure

[jira] Updated: (DERBY-3246) Minor cleanup in the Derby JUnit classes

2007-12-05 Thread Kristian Waagan (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kristian Waagan updated DERBY-3246: --- Attachment: derby-3246-1a_unused-imports.diff 'derby-3246-1a_unused-imports.diff' removes

[jira] Commented: (DERBY-2998) Add support for ROW_NUMBER() window function

2007-12-05 Thread Thomas Nielsen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2998?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548598 ] Thomas Nielsen commented on DERBY-2998: --- Thanks Dyre. Yes, it's still work in progress. I'll look into the

[jira] Updated: (DERBY-3203) Convert jdbcapi/statementJdbc20.java to JUnit

2007-12-05 Thread Dyre Tjeldvoll (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dyre Tjeldvoll updated DERBY-3203: -- Attachment: DERBY-3203v3.diff Hi Ramin, I think Dan is making a very good point about the

[jira] Created: (DERBY-3255) Defer installation of TestConfiguration in junit tests until tests are run to avoid suite setup methods using configuration information.

2007-12-05 Thread Daniel John Debrunner (JIRA)
Defer installation of TestConfiguration in junit tests until tests are run to avoid suite setup methods using configuration information. Key:

[jira] Assigned: (DERBY-3242) ij doesn't understand bracketed comments

2007-12-05 Thread James F. Adams (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3242?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] James F. Adams reassigned DERBY-3242: - Assignee: James F. Adams ij doesn't understand bracketed comments

[jira] Updated: (DERBY-3253) NullPointer Exception (NPE) from query with IN predicate containing two values and joining a view with a large table. ERROR 38000: The exception 'java.lang.NullPointerExc

2007-12-05 Thread A B (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3253?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] A B updated DERBY-3253: --- Derby Info: [Regression] Based on a quick test it looks like this is a regression caused by DERBY-47. NullPointer

reserved keywords

2007-12-05 Thread Rick Hillegas
55 of Derby's reserved keywords are not reserved keywords in the ANSI 2003 standard. These include keywords like key and collation, which are non-reserved keywords in ANSI 2003. Keeping these as reserved keywords creates migration problems when people try to port their applications from other

[jira] Updated: (DERBY-3238) When table contains large LOB values ( ~32K) trigger execution fails for that row with ERROR XCL30: An IOException was thrown when reading a 'BLOB'

2007-12-05 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden updated DERBY-3238: -- Fix Version/s: 10.4.0.0 10.3.2.2 10.2.2.1 fixed in

[jira] Commented: (DERBY-3231) Sorting on COUNT with OR and GROUP BY delivers wrong results.

2007-12-05 Thread A B (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3231?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548715 ] A B commented on DERBY-3231: A.B, did this query work before svn revision 516454 and fail after this commit? Yes,

[jira] Updated: (DERBY-2998) Add support for ROW_NUMBER() window function

2007-12-05 Thread Thomas Nielsen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Thomas Nielsen updated DERBY-2998: -- Attachment: d2998-test2.stat d2998-test2.diff 'd2998-test2.diff' is a patch

ok to add optional timeout/sleep property for junit framework?

2007-12-05 Thread Myrna van Lunteren
Hi, The junit networkserver tests run with a setting that's specified in - at least - NetworkServerTestSetup. I find that this may not be applicable for all machines; I ran on some slower machines and the setting wasn't enough. I remember that one of the detractors for the old test harness was

[jira] Created: (DERBY-3257) SELECT with HAVING clause containing OR conditional incorrectly return 1 row - should return 2 rows - works correctly with 10.2 DB

2007-12-05 Thread Stan Bradbury (JIRA)
SELECT with HAVING clause containing OR conditional incorrectly return 1 row - should return 2 rows - works correctly with 10.2 DB -- Key: DERBY-3257

[jira] Updated: (DERBY-3257) SELECT with HAVING clause containing OR conditional incorrectly return 1 row - should return 2 rows - works correctly with 10.2 DB

2007-12-05 Thread Stan Bradbury (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3257?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Stan Bradbury updated DERBY-3257: - Attachment: TestHaving.java SELECT with HAVING clause containing OR conditional incorrectly

[jira] Updated: (DERBY-1585) derbylang/procedureInTrigger: not able to create trigger due to an open ResultSet

2007-12-05 Thread Daniel John Debrunner (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-1585?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel John Debrunner updated DERBY-1585: - Attachment: derby1585_diff.txt Patch that closes dynamic result sets in the

Re: Problem accessing IBM test results.

2007-12-05 Thread Andrew McIntyre
On Dec 5, 2007 3:55 PM, Kathey Marsden [EMAIL PROTECTED] wrote: I am having trouble accessing the IBM public test results at: http://people.apache.org/~fuzzylogic/derby_test_results/main/derbymain/index.html For example at:

Re: ok to add optional timeout/sleep property for junit framework?

2007-12-05 Thread Daniel John Debrunner
Myrna van Lunteren wrote: Hi, The junit networkserver tests run with a setting that's specified in - at least - NetworkServerTestSetup. I find that this may not be applicable for all machines; I ran on some slower machines and the setting wasn't enough. I remember that one of the detractors

Re: [VOTE] 10.3.2.1 release candidate

2007-12-05 Thread Kathey Marsden
Kathey Marsden wrote: Please test and vote on the 10.3.2.1 release candidate, available at: http://people.apache.org/~kmarsden/derby10.3.2.1.599110/ +1 I ran derbyall and suites.All with Sun JDK 1.6 on Windows and browsed the documentation briefly. Based on the other platform results I

Re: JUnit problem

2007-12-05 Thread Dyre . Tjeldvoll
Daniel John Debrunner [EMAIL PROTECTED] writes: Does this help: http://wiki.apache.org/db-derby/DerbyJunitTestConfiguration Basically you need to define in the suite method how you want your test fixtures to be run. There is no outside agent at setup time saying it's running in client or

Re: reserved keywords

2007-12-05 Thread Thomas Nielsen
Rick Hillegas wrote: 55 of Derby's reserved keywords are not reserved keywords in the ANSI 2003 standard. These include keywords like key and collation, which are non-reserved keywords in ANSI 2003. Keeping these as reserved keywords creates migration problems when people try to port their

Re: JUnit problem

2007-12-05 Thread Knut Anders Hatlen
[EMAIL PROTECTED] writes: Daniel John Debrunner [EMAIL PROTECTED] writes: Does this help: http://wiki.apache.org/db-derby/DerbyJunitTestConfiguration Basically you need to define in the suite method how you want your test fixtures to be run. There is no outside agent at setup time saying

Problem accessing IBM test results.

2007-12-05 Thread Kathey Marsden
I am having trouble accessing the IBM public test results at: http://people.apache.org/~fuzzylogic/derby_test_results/main/derbymain/index.html For example at: http://people.apache.org/~fuzzylogic/derby_test_results/main/derbymain/testSummary-601192.html I get: Forbidden You don't have

Re: JUnit problem

2007-12-05 Thread Dyre . Tjeldvoll
[EMAIL PROTECTED] writes: Daniel John Debrunner [EMAIL PROTECTED] writes: Does this help: http://wiki.apache.org/db-derby/DerbyJunitTestConfiguration Basically you need to define in the suite method how you want your test fixtures to be run. There is no outside agent at setup time saying

[jira] Updated: (DERBY-3238) When table contains large LOB values ( ~32K) trigger execution fails for that row with ERROR XCL30: An IOException was thrown when reading a 'BLOB'

2007-12-05 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3238?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden updated DERBY-3238: -- Attachment: derby-3238_10_1_diff.txt Attached is a patch for version 10.1 for this issue. In

Regression Test Report - Daily 600998 - Sun DBTG

2007-12-05 Thread Henri . Vandescheur
[Auto-generated mail] *Daily* 600998/2007-12-04 18:00:11 CET Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* lin 0274274 071.86% derbyall 01011910119 0 1168.07% suitesAll linN+1

[jira] Commented: (DERBY-1585) derbylang/procedureInTrigger: not able to create trigger due to an open ResultSet

2007-12-05 Thread Daniel John Debrunner (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-1585?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12548904 ] Daniel John Debrunner commented on DERBY-1585: -- Thanks Knut Anders, I neglected the information you

[jira] Assigned: (DERBY-2457) Use of column aliases in group by / having clauses can cause queries to fail

2007-12-05 Thread Manish Khettry (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2457?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Manish Khettry reassigned DERBY-2457: - Assignee: (was: Manish Khettry) Don't have the time to look into this right now.