[jira] Closed: (DERBY-2370) EXISTS may return the wrong value for sub-queries involving set operations

2007-04-26 Thread Dyre Tjeldvoll (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2370?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dyre Tjeldvoll closed DERBY-2370. - EXISTS may return the wrong value for sub-queries involving set operations

[jira] Commented: (DERBY-2590) error in error message

2007-04-26 Thread Zied Hamdi (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12491887 ] Zied Hamdi commented on DERBY-2590: --- Yes surely Dyre, this issue shouldn't even have been open. I'm sorry again, I

[jira] Updated: (DERBY-2569) The check to see if two DataTypeDescriptors(DTDs) are comparable or not needs to consider collation into decision.

2007-04-26 Thread Mamta A. Satoor (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2569?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mamta A. Satoor updated DERBY-2569: --- Attachment: DERBY2569_change_formatid_checks_to_isXXX_checks_v1_stat.txt

[jira] Updated: (DERBY-2280) DatabaseMetaData.getTypeInfo() UNSIGNED_ATTRIBUTE and AUTO_INCREMENT column returns incorrect information for BLOB CLOB data type

2007-04-26 Thread Saurabh Vyas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2280?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Saurabh Vyas updated DERBY-2280: Attachment: Derby-2280_v2.diff Attached the new patch with comments from Army Kathey

[jira] Closed: (DERBY-2590) error in error message

2007-04-26 Thread Dyre Tjeldvoll (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2590?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dyre Tjeldvoll closed DERBY-2590. - Resolution: Invalid Not a bug in Derby error in error message --

[jira] Updated: (DERBY-2020) Change file option for syncing log file to disk from rws to rwd

2007-04-26 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen updated DERBY-2020: -- Derby Info: (was: [Patch Available]) rwd_pre.diff looks good. Committed revision

[jira] Resolved: (DERBY-2107) Move page latching out of the lock manager

2007-04-26 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2107?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Knut Anders Hatlen resolved DERBY-2107. --- Resolution: Fixed Fix Version/s: 10.3.0.0 Committed 4a with revision 532636.

[jira] Updated: (DERBY-827) Performance can be improved by re-using language ResultSets across Activation executions.

2007-04-26 Thread Dyre Tjeldvoll (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dyre Tjeldvoll updated DERBY-827: - Attachment: resetMembersScrollInsensitive.diff Attaching a patch

[jira] Updated: (DERBY-2222) 'show indexes in SCHEMANAME' does not work with the client driver

2007-04-26 Thread JIRA
[ https://issues.apache.org/jira/browse/DERBY-?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jørgen Løland updated DERBY-: - Derby Info: [Patch Available] 'show indexes in SCHEMANAME' does not work with the client driver

[jira] Updated: (DERBY-2222) 'show indexes in SCHEMANAME' does not work with the client driver

2007-04-26 Thread JIRA
[ https://issues.apache.org/jira/browse/DERBY-?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jørgen Løland updated DERBY-: - Attachment: DERBY--2.stat DERBY--2.diff Thanks for the comments, Knut. I

[jira] Updated: (DERBY-2506) Adding the locator information to FD:OCA descriptor (FDODSC) andFD:OCA data (FDODTA) of the SQLDTA objects

2007-04-26 Thread V.Narayanan (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] V.Narayanan updated DERBY-2506: --- Attachment: PreparedCallable_DRDA_v4.stat PreparedCallable_DRDA_v4.diff Derby-2496

[jira] Updated: (DERBY-2496) Implement Blob support for Locators

2007-04-26 Thread JIRA
[ https://issues.apache.org/jira/browse/DERBY-2496?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Øystein Grøvlen updated DERBY-2496: --- Attachment: blob_v2.diff Uploaded a new version of this patch, blob_v2.diff. The only

[jira] Commented: (DERBY-2549) ArrayIndexOutOfBoundsException in SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE

2007-04-26 Thread Kurt Huwig (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12491955 ] Kurt Huwig commented on DERBY-2549: --- I tweaked the code a bit to use arrays of size 1000 instead of 100 and put

[jira] Updated: (DERBY-2565) BrokeredConnection needs to forward implementations of locator related methods in EngineConnection to the underlying physical connection

2007-04-26 Thread V.Narayanan (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2565?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] V.Narayanan updated DERBY-2565: --- Derby Info: [Patch Available] Setting the Patch available flag. I have run tests on the patch

[jira] Updated: (DERBY-2549) ArrayIndexOutOfBoundsException in SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE

2007-04-26 Thread Kurt Huwig (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kurt Huwig updated DERBY-2549: -- Attachment: 2549-histogram.png Histogram of the frequency of the number of elements in the array. X is

[jira] Commented: (DERBY-2549) ArrayIndexOutOfBoundsException in SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE

2007-04-26 Thread Kurt Huwig (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12491961 ] Kurt Huwig commented on DERBY-2549: --- My patch does not compress the full database. I will limit the case when

[jira] Created: (DERBY-2594) Revoking a privilege from a table should invalidate statements dependent on that table

2007-04-26 Thread Dyre Tjeldvoll (JIRA)
Revoking a privilege from a table should invalidate statements dependent on that table -- Key: DERBY-2594 URL: https://issues.apache.org/jira/browse/DERBY-2594

[jira] Updated: (DERBY-1484) Client and embedded behave differently when the table name is null in DatabaseMetaData methods

2007-04-26 Thread JIRA
[ https://issues.apache.org/jira/browse/DERBY-1484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jørgen Løland updated DERBY-1484: - Attachment: DERBY-1484.stat DERBY-1484.diff I checked all the methods in

[jira] Resolved: (DERBY-2591) DataDictionaryImpl.getSystemSQLName() may generate duplicates

2007-04-26 Thread Bernt M. Johnsen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bernt M. Johnsen resolved DERBY-2591. - Resolution: Fixed Committed revision 532723. DataDictionaryImpl.getSystemSQLName()

[jira] Created: (DERBY-2595) junit tests uses getExportedKeys with table name null

2007-04-26 Thread JIRA
junit tests uses getExportedKeys with table name null - Key: DERBY-2595 URL: https://issues.apache.org/jira/browse/DERBY-2595 Project: Derby Issue Type: Bug Components: Test

[jira] Commented: (DERBY-2594) Revoking a privilege from a table should invalidate statements dependent on that table

2007-04-26 Thread Dyre Tjeldvoll (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12491986 ] Dyre Tjeldvoll commented on DERBY-2594: --- There is a typo in the description. The last sentence should read

Performance regression after check-in on DERBY 2537 (SVN 531971)

2007-04-26 Thread Olav Sandstaa
The two last days I have seen a performance regression in some of the performance tests I run. For some of the tests the reduction in throughput is about 15 percent. It seems like the regression is introduced by the latest check-in on DERBY-2537, svn 531971. I have attached a graph showing

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

2007-04-26 Thread jira
Issue Subscription Filter: Derby: JIRA issues with patch available (18 issues) Subscriber: derby-dev Key Summary DERBY-2565 BrokeredConnection needs to forward implementations of locator related methods in EngineConnection to the underlying physical connection

DRDA spec V4

2007-04-26 Thread Rick Hillegas
Yesterday, the Open Group Board of Directors approved Version 4 of the DRDA spec. This is the new version which includes support for the XML and Boolean datatypes. You can get the spec from the Open Group site: http://www.opengroup.org/bookstore/catalog/select.tpl?text=drda Regards, -Rick

Regression Test Report - Daily 532397 - Sun DBTG

2007-04-26 Thread Henri . Vandescheur
[Auto-generated mail] *Daily* 532397/2007-04-25 18:00:11 CEST Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* lin 0328328 076.53% derbyall 074617461 0 593.79% suitesAll sles 0

[jira] Assigned: (DERBY-2381) ParameterMappingTest fails due to ArrayIndexOutOfBoundsException executing a procedure

2007-04-26 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kathey Marsden reassigned DERBY-2381: - Assignee: Kathey Marsden ParameterMappingTest fails due to

[jira] Updated: (DERBY-2020) Change file option for syncing log file to disk from rws to rwd

2007-04-26 Thread Olav Sandstaa (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Olav Sandstaa updated DERBY-2020: - Derby Info: [Patch Available] Change file option for syncing log file to disk from rws to rwd

[jira] Updated: (DERBY-2020) Change file option for syncing log file to disk from rws to rwd

2007-04-26 Thread Olav Sandstaa (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2020?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Olav Sandstaa updated DERBY-2020: - Attachment: rwd_v2.diff The only change in this patch (rwd_v2.diff) is to do the actual change

[jira] Updated: (DERBY-2594) Revoking a privilege from an SQL Object should invalidate statements dependent on that object

2007-04-26 Thread Dyre Tjeldvoll (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2594?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dyre Tjeldvoll updated DERBY-2594: -- Summary: Revoking a privilege from an SQL Object should invalidate statements dependent on

[jira] Commented: (DERBY-2594) Revoking a privilege from an SQL Object should invalidate statements dependent on that object

2007-04-26 Thread Dyre Tjeldvoll (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492073 ] Dyre Tjeldvoll commented on DERBY-2594: --- My experimental change fails because a TableDescriptor can have other

Re: Question about grant/revoke

2007-04-26 Thread Daniel John Debrunner
[EMAIL PROTECTED] wrote: Daniel John Debrunner [EMAIL PROTECTED] writes: The privilege checking should occur when creating the Activation which is when the plan (shared) gets hooked up to the specific user's java.sql.PreparedStatement. This is what happens today, but then Activations are not

Decimal values larger than (31,0)...should this be an error?

2007-04-26 Thread Army
The Derby reference guide says for decimal data types: The precision must be between 1 and 31. The scale must be less than or equal to the precision. And indeed, if I try to create a table with precision of 32 or more, I get an error: ij connect 'mydb;create=true'; ij create table oops (d

[jira] Updated: (DERBY-2462) org.apache.derby.impl.store.access.BackingStoreHashTableFromScan does not honor ResultSet holdability

2007-04-26 Thread Dag H. Wanvik (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2462?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dag H. Wanvik updated DERBY-2462: - Attachment: DERBY-2462-4.stat DERBY-2462-4.diff This patch (DERBY-2462-4.*)

Re: 0.05% of test fixtures contribute 53% of the total running time!!

2007-04-26 Thread Sunitha Kambhampati
Oystein Grovlen - Sun Norway wrote: I have created DERBY-2586 for the testPositionAgressive problem. DERBY-2586 is fixed and the fix makes the BlobClob4BlobTest go faster. The changes for DERBY-2346 (r530085) slowed it down in the first place and there has not been significant changes to

[jira] Commented: (DERBY-2462) org.apache.derby.impl.store.access.BackingStoreHashTableFromScan does not honor ResultSet holdability

2007-04-26 Thread A B (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492093 ] A B commented on DERBY-2462: Latest patch (version 4) incorporates all previous feedback and I have no other comments

[jira] Updated: (DERBY-2379) provide encryption support for temporary files used by lob if the dara base is encrypted

2007-04-26 Thread Anurag Shekhar (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2379?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Anurag Shekhar updated DERBY-2379: -- Attachment: derby-2379v2.diff Descriptions of path (derby-2379v2.diff) Fixed bugs found in

Re: Regression Test Report - tinderbox_trunk16 532695 - Sun DBTG

2007-04-26 Thread Knut . Hatlen
[EMAIL PROTECTED] writes: [Auto-generated mail] *tinderbox_trunk16* 532695/2007-04-26 12:42:43 CEST Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* SunOS-5.10_i86pc-i386 10324314 093.04% derbyall

Re: DRDA spec V4

2007-04-26 Thread David Van Couvering
Wow, great news. Molasses does move, albeit slowly... Rick Hillegas wrote: Yesterday, the Open Group Board of Directors approved Version 4 of the DRDA spec. This is the new version which includes support for the XML and Boolean datatypes. You can get the spec from the Open Group site:

Re: Regression Test Report - tinderbox_trunk16 532695 - Sun DBTG

2007-04-26 Thread Knut . Hatlen
[EMAIL PROTECTED] writes: [EMAIL PROTECTED] writes: [Auto-generated mail] *tinderbox_trunk16* 532695/2007-04-26 12:42:43 CEST Failed TestsOK Skip Duration Suite --- *Jvm: 1.6* SunOS-5.10_i86pc-i386 10324314

Re: Performance regression after check-in on DERBY 2537 (SVN 531971)

2007-04-26 Thread Mike Matrigali
Are these tests checked in so that I can run them in my environment? Olav Sandstaa wrote: The two last days I have seen a performance regression in some of the performance tests I run. For some of the tests the reduction in throughput is about 15 percent. It seems like the regression is

Re: Performance regression after check-in on DERBY 2537 (SVN 531971)

2007-04-26 Thread Olav Sandstaa
Hi Mike, No, unfortunately these tests are not checked in. But using the test client attached to DERBY-1961 should generate similar load. Olav Mike Matrigali wrote: Are these tests checked in so that I can run them in my environment? Olav Sandstaa wrote: The two last days I have seen a

[jira] Commented: (DERBY-716) Re-enable VTIs

2007-04-26 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492109 ] Rick Hillegas commented on DERBY-716: - Thanks for the great feedback, Army. Your comments will help simplify the

[jira] Commented: (DERBY-716) Re-enable VTIs

2007-04-26 Thread Rick Hillegas (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492110 ] Rick Hillegas commented on DERBY-716: - Continuing with Army's feedback: Under System Tables: You are correct.

Re: Performance regression after check-in on DERBY 2537 (SVN 531971)

2007-04-26 Thread Olav Sandstaa
To see the effect of this in a different environment I started a similar test running with IBM 1.5 VM on Linux. Unfortunately, the machine I decided to use was a shared server so during part of the test run some other testing have been running in parallel. I plan to try to re-run these

[jira] Commented: (DERBY-2381) ParameterMappingTest fails due to ArrayIndexOutOfBoundsException executing a procedure

2007-04-26 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492113 ] Kathey Marsden commented on DERBY-2381: --- The ClassCastException occurs because the client sends the parameter

[jira] Commented: (DERBY-2596) JDBC 4 statement.isClosed throws IllegalAccessError when used with EmbeddedXADataSource40

2007-04-26 Thread Knut Anders Hatlen (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2596?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492129 ] Knut Anders Hatlen commented on DERBY-2596: --- FWIW, I don't see this error in my environment. [EMAIL

[jira] Updated: (DERBY-2596) JDBC 4 statement.isClosed throws IllegalAccessError when used with EmbeddedXADataSource40

2007-04-26 Thread Daniel John Debrunner (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2596?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel John Debrunner updated DERBY-2596: - Affects Version/s: (was: 10.2.2.1) 10.2.2.0 Repro

[jira] Updated: (DERBY-2501) Batch scripts in bin\ report extraneous errors when DERBY_HOME is invalid

2007-04-26 Thread Andrew McIntyre (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Andrew McIntyre updated DERBY-2501: --- Attachment: derby-2501-check-javacmd.diff Attaching a patch which includes the check that

[jira] Commented: (DERBY-2381) ParameterMappingTest fails due to ArrayIndexOutOfBoundsException executing a procedure

2007-04-26 Thread Kathey Marsden (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2381?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492150 ] Kathey Marsden commented on DERBY-2381: --- The number cast seems to work ok for everything but BigDecimal as

[jira] Commented: (DERBY-2582) EmbeddedConnectionPoolDataSource does not implement java.sql.Wrapper but reports JDBC 4 compliance when run with JDK 6

2007-04-26 Thread A B (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492154 ] A B commented on DERBY-2582: I can't say that I fully understand the issue, but from what I gather the application in

[jira] Commented: (DERBY-2582) EmbeddedConnectionPoolDataSource does not implement java.sql.Wrapper but reports JDBC 4 compliance when run with JDK 6

2007-04-26 Thread Daniel John Debrunner (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492159 ] Daniel John Debrunner commented on DERBY-2582: -- Simpler check would be ds instanceof java.sql.Wrapper

[jira] Commented: (DERBY-2582) EmbeddedConnectionPoolDataSource does not implement java.sql.Wrapper but reports JDBC 4 compliance when run with JDK 6

2007-04-26 Thread Daniel John Debrunner (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492161 ] Daniel John Debrunner commented on DERBY-2582: -- or derby specific ds instanceof

[jira] Commented: (DERBY-2582) EmbeddedConnectionPoolDataSource does not implement java.sql.Wrapper but reports JDBC 4 compliance when run with JDK 6

2007-04-26 Thread A B (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492162 ] A B commented on DERBY-2582: Simpler check would be ds instanceof java.sql.Wrapper I don't think this works, as all

[jira] Commented: (DERBY-2582) EmbeddedConnectionPoolDataSource does not implement java.sql.Wrapper but reports JDBC 4 compliance when run with JDK 6

2007-04-26 Thread A B (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-2582?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12492163 ] A B commented on DERBY-2582: Assumes application is running with Java 1.6 Err, meant built, not running. Or is it