[jira] Commented: (DERBY-1417) Add new, lengthless overloads to the streaming api

2006-08-29 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1417?page=comments#action_12431146 ] Knut Anders Hatlen commented on DERBY-1417: --- Thanks Kristian, your latest patch addresses all my concerns. I have verified that inserting a 100MB blob

[jira] Commented: (DERBY-418) outofmemory error when running large query in autocommit=false mode

2006-08-29 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-418?page=comments#action_12431148 ] Knut Anders Hatlen commented on DERBY-418: -- Thanks Mayuresh. I think the patch looks good. If there are no more comments, I will run some tests and commit

[jira] Commented: (DERBY-1292) ClassCastException in ClientDriver when using CLOB columns and batch updates

2006-08-29 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1292?page=comments#action_12431150 ] Knut Anders Hatlen commented on DERBY-1292: --- I am running tests on 10.2 and will merge the fix into the 10.2 branch when they have completed

[jira] Commented: (DERBY-1767) insertRow(), updateRow() and deleteRow() cannot handle table names and column names containing double quotes

2006-08-29 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1767?page=comments#action_12431153 ] Knut Anders Hatlen commented on DERBY-1767: --- I believe updateRow() and deleteRow() have the same problem with cursor names that contain double quotes.

[jira] Commented: (DERBY-1771) Doc title in browser for html pages is Web sample

2006-08-29 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1771?page=comments#action_12431154 ] Kristian Waagan commented on DERBY-1771: Is this a duplicate of DERBY-502, or should these two issues just be linked together? Doc title in browser for

[jira] Updated: (DERBY-1417) Add new, lengthless overloads to the streaming api

2006-08-29 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1417?page=all ] Kristian Waagan updated DERBY-1417: --- Derby Info: (was: [Patch Available]) Add new, lengthless overloads to the streaming api --

[jira] Resolved: (DERBY-1417) Add new, lengthless overloads to the streaming api

2006-08-29 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1417?page=all ] Kristian Waagan resolved DERBY-1417. Resolution: Fixed Resolving this. I don't expect to do more on work on this, and plan to close the issue in a few days. Add new, lengthless

[jira] Created: (DERBY-1773) insertRow() and updateRow() fail with syntax error when column has an alias

2006-08-29 Thread Knut Anders Hatlen (JIRA)
insertRow() and updateRow() fail with syntax error when column has an alias --- Key: DERBY-1773 URL: http://issues.apache.org/jira/browse/DERBY-1773 Project: Derby

[jira] Closed: (DERBY-1473) Add cut-off and truncation logic to streaming classes in the embedded driver

2006-08-29 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1473?page=all ] Kristian Waagan closed DERBY-1473. -- Closing. Initial functionality added, associated problems should be handled by separate Jiras. Add cut-off and truncation logic to streaming classes in the

[jira] Commented: (DERBY-1559) when receiving a single EXTDTA object representing a BLOB, the server do not need to read it into memory before inserting it into the DB

2006-08-29 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1559?page=comments#action_12431227 ] Andreas Korneliussen commented on DERBY-1559: - Thanks for the review. I will run some tests, and then commit the patch on the trunk. when receiving a

[jira] Created: (DERBY-1774) NullPointerException when using COALESCE

2006-08-29 Thread Robert Enyedi (JIRA)
NullPointerException when using COALESCE Key: DERBY-1774 URL: http://issues.apache.org/jira/browse/DERBY-1774 Project: Derby Issue Type: Bug Components: Network Server Affects Versions:

[jira] Commented: (DERBY-1727) Test lang/streams.java fails with ArrayIndexOutOfBoundsException using IBM JDK 1.3.1 SR10

2006-08-29 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1727?page=comments#action_12431242 ] Kristian Waagan commented on DERBY-1727: I checked this out, since I have worked in the area of the code showing the error. My conclusion is that this is

[jira] Commented: (DERBY-1774) NullPointerException when using COALESCE

2006-08-29 Thread Robert Enyedi (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1774?page=comments#action_12431243 ] Robert Enyedi commented on DERBY-1774: -- Correction: The problem DOES also appear on JRE 1.4.2_06 NullPointerException when using COALESCE

[jira] Created: (DERBY-1775) Error 2200M is defined in the SQL standard as 'invalid XML document' and can be used in multiple situations, not just XMLPARSE

2006-08-29 Thread Daniel John Debrunner (JIRA)
Error 2200M is defined in the SQL standard as 'invalid XML document' and can be used in multiple situations, not just XMLPARSE -- Key: DERBY-1775

[jira] Updated: (DERBY-1583) With grant revoke enabled, defining a trigger whose actions updates a table (from different schema) results in NPE

2006-08-29 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1583?page=all ] Bryan Pendleton updated DERBY-1583: --- Derby Info: (was: [Patch Available]) Thanks, Mamta! These are good ideas. I will submit a revised patch. With grant revoke enabled, defining a

[jira] Updated: (DERBY-1776) ERROR 42Z72: XML syntax error; missing keyword(s): 'AS'. - Misleading text

2006-08-29 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1776?page=all ] Daniel John Debrunner updated DERBY-1776: - Description: create table t (i int, x xml); select xmlserialize(x) from t; ERROR 42Z72: XML syntax error; missing keyword(s): 'AS'. This is

[jira] Created: (DERBY-1776) ERROR 42Z72: XML syntax error; missing keyword(s): 'AS'. - Misleading text

2006-08-29 Thread Daniel John Debrunner (JIRA)
ERROR 42Z72: XML syntax error; missing keyword(s): 'AS'. - Misleading text -- Key: DERBY-1776 URL: http://issues.apache.org/jira/browse/DERBY-1776 Project: Derby Issue

[jira] Commented: (DERBY-1771) Doc title in browser for html pages is Web sample

2006-08-29 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1771?page=comments#action_12431252 ] Kim Haase commented on DERBY-1771: -- It's a duplicate of half of DERBY-502 -- that bug complains both about Web Sample in the index.html files and about XSL FO

[jira] Closed: (DERBY-1771) Doc title in browser for html pages is Web sample

2006-08-29 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1771?page=all ] Daniel John Debrunner closed DERBY-1771. Resolution: Duplicate Doc title in browser for html pages is Web sample --

[jira] Updated: (DERBY-1774) NullPointerException when using COALESCE

2006-08-29 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1774?page=all ] Kristian Waagan updated DERBY-1774: --- Attachment: derby.log-proper Attaching a proper derby.log, generated by using Derby 10.1.3.1 (debug). I could not see the mentioned error in the original

Re: Question on the lib 10.2.1.1beta layout

2006-08-29 Thread Rick Hillegas
Hi Andrew, If you unzip the bin distribution, then the test directory appears parallel to bin and lib: rick_sun junk (1.4) ls binUnpacked/db-derby-10.2.1.1-bin/ CHANGES KEYS LICENSE NOTICE bin demo docs frameworks index.html javadoc lib test If you unzip the lib distribution,

[jira] Created: (DERBY-1777) Regression: query works in 10.1.2.1 but fails with NullPointerException in 10.2.1.1

2006-08-29 Thread Prasenjit Sarkar (JIRA)
Regression: query works in 10.1.2.1 but fails with NullPointerException in 10.2.1.1 --- Key: DERBY-1777 URL: http://issues.apache.org/jira/browse/DERBY-1777 Project:

[jira] Updated: (DERBY-1774) NullPointerException when using COALESCE

2006-08-29 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1774?page=all ] Kristian Waagan updated DERBY-1774: --- Component/s: SQL (was: Network Server) NullPointerException when using COALESCE

[jira] Updated: (DERBY-1559) when receiving a single EXTDTA object representing a BLOB, the server do not need to read it into memory before inserting it into the DB

2006-08-29 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1559?page=all ] Andreas Korneliussen updated DERBY-1559: Attachment: DERBY-1559v6.diff Found a bug while testing the patch DERBY-1559v5.diff: In case of an DRDAProtoclException while doing the

[jira] Updated: (DERBY-1774) NullPointerException when using COALESCE

2006-08-29 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1774?page=all ] Kristian Waagan updated DERBY-1774: --- Affects Version/s: 10.2.1.0 Note that the error also happens with Derby 10.1.3.1 embedded, and with Derby 10.2.1.1 (alpha snapshot). However, the bug

Recent work on COALESCE?

2006-08-29 Thread Kristian Waagan
Hi, Can anyone remember doing some work on COALESCE lately? A user is seeing a bug in versions earlier than 10.3/trunk, but in trunk the problem is gone. We should consider backporting this fix. Jira DERBY-1774 tracks the bug. Thanks, -- Kristian

Re: [jira] Updated: (DERBY-1696) transaction may sometimes keep lock on a row after moving off the resultset in scrollable updatable resultset

2006-08-29 Thread Andreas Korneliussen
Mike Matrigali wrote: The current interface to reopen a heap scan at the beginning is reopenScan(), I think it is confusing to change positionAtRowLocation(null) to also do this. Does your usage want the table level intent lock released or not? The usage requires that the table level

doc reviews question

2006-08-29 Thread Daniel John Debrunner
For the on-going documentation reviews I have two questions: http://wiki.apache.org/db-derby/TenTwoDocReview 1) How would anyone mark an item as addressed, or conversely how do I tell if an item was addressed? 2) If someone raises an item that they are not sure about, should it really go to the

Performance regression with 10.2.1.0, oddly throughput drops with fix for derby-1543

2006-08-29 Thread Sunitha Kambhampati
I ran some simple performance tests with the 10.2.1.0 beta jars and one of the tests ( lets just say the name of the test is ScanCoveredIdxInt), the throughput is about *56%* of the 10.1.3 release. BRIEF DESCRIPTION OF TEST: The test has a setup phase, runtest phase and then the cleanup phase.

[jira] Commented: (DERBY-1774) NullPointerException when using COALESCE

2006-08-29 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1774?page=comments#action_12431273 ] Dag H. Wanvik commented on DERBY-1774: -- As part of fixing DERBY-1574, I added a missing preprocess implementation for COALESCE to the compiler

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

2006-08-29 Thread jira
Issue Subscription Filter: Derby: JIRA issues with patch available (15 issues) Subscriber: derby-dev Key Summary DERBY-1559 when receiving a single EXTDTA object representing a BLOB, the server do not need to read it into memory before inserting it into the DB

Re: doc reviews question

2006-08-29 Thread Laura Stewart
Good questions. 1. When the list of reviewers and sections were added, something got dropped from the main table. After the comment column, there needs to be a Status column. That is where the person who addresses the comment indicates the status of the documentation for the comment. I see

[jira] Updated: (DERBY-1696) transaction may sometimes keep lock on a row after moving off the resultset in scrollable updatable resultset

2006-08-29 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1696?page=all ] Andreas Korneliussen updated DERBY-1696: Attachment: DERBY-1696.diff DERBY-1696.stat The attached patch addresses this bug by having the SQL-execution layer use

[jira] Commented: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4

2006-08-29 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1633?page=comments#action_12431277 ] A B commented on DERBY-1633: Our application is too network-server centric to run in embedded mode. Actually, you wouldn't need to change your application at all.

Re: [jira] Updated: (DERBY-1566) Document SQLStates in 10.2

2006-08-29 Thread David Van Couvering
Guess you gave up on me Jean :) This was something I was going to work on this week. We should figure out how we want to collaborate. I do have to admit I am majorly swamped with some other projects right now, so if you have the time and inclination... Anyway, let me know if you need

[jira] Commented: (DERBY-1682) Add documentation for derby.drda.securityMechanism.

2006-08-29 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1682?page=comments#action_12431278 ] Laura Stewart commented on DERBY-1682: -- Kim - Are you going to update the topic to add the security mechanism info? Add documentation for

[jira] Commented: (DERBY-1772) Error 42Z78 Failed to locate 'Xalan' API classes should not have sqlstate class '42'

2006-08-29 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1772?page=comments#action_12431279 ] A B commented on DERBY-1772: This is a run-time error but it has the SQL state '42' for compile error, I guess that depends on what you mean by run-time error. In

XML in Derby - WAS : [jira] Updated: (DERBY-688) Enhancements to XML functionality to move toward XPath/XQuery support...

2006-08-29 Thread Daniel John Debrunner
David Van Couvering wrote: Wow, great work Army, and thanks for the careful review and effort by Brian and Yip! It's great to have this in. If I could only grok exactly what the feature is and how I might use it :) I am telling people we have XML features and I know it's something to do

[jira] Commented: (DERBY-606) SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE fails on (very) large tables

2006-08-29 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-606?page=comments#action_12431280 ] Sunitha Kambhampati commented on DERBY-606: --- Here is the stacktrace: ij version 10.2 ij connect 'jdbc:derby:dbtpcc'; ij call

[jira] Commented: (DERBY-1772) Error 42Z78 Failed to locate 'Xalan' API classes should not have sqlstate class '42'

2006-08-29 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1772?page=comments#action_12431281 ] Daniel John Debrunner commented on DERBY-1772: -- Yes it's an error at compile time, but I was wrong on '42' meaning compile time, it's more specific

[jira] Commented: (DERBY-1686) Grant/Revoke: Attempt to GRANT access to another user on a VIEW, created by the current user with only SELECT privilege on the base table does not fail

2006-08-29 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431284 ] Yip Ng commented on DERBY-1686: --- Mamta, I also thought about 2 alternative solutions before this patch. One was your proposed idea and the other one was setting a

[jira] Created: (DERBY-1778) Document ij.exceptionTrace=true property in tools guide.

2006-08-29 Thread Sunitha Kambhampati (JIRA)
Document ij.exceptionTrace=true property in tools guide. Key: DERBY-1778 URL: http://issues.apache.org/jira/browse/DERBY-1778 Project: Derby Issue Type: Improvement

[jira] Closed: (DERBY-1695) testSecMec.java fails with JCC 2.6 and JCC 2.8

2006-08-29 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1695?page=all ] Sunitha Kambhampati closed DERBY-1695. -- Resolution: Fixed Verified that the test passes now. with jcc2.6 and jcc2.8, so closing this issue. testSecMec.java fails with JCC 2.6 and JCC

Re: [Db-derby Wiki] Update of ReferenceManualTenTwo by DanDebrunner

2006-08-29 Thread Army
Apache Wiki wrote: - Notes on the changes (bold), a) no need to use Derby b) The old word ing had the use of 'might' and 'empty sequence', I think it wanted to describe a sequence and the result is always a sequence, not that it might be. I agree, with one small addition: instinctively I

[jira] Commented: (DERBY-1686) Grant/Revoke: Attempt to GRANT access to another user on a VIEW, created by the current user with only SELECT privilege on the base table does not fail

2006-08-29 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431291 ] Yip Ng commented on DERBY-1686: --- How about if we still keep the logic of building the provider list instead of the flag and applied the proposed logic at execution

Re: [jira] Updated: (DERBY-1566) Document SQLStates in 10.2

2006-08-29 Thread Jean T. Anderson
David Van Couvering wrote: Guess you gave up on me Jean :) This was something I was going to work on this week. We should figure out how we want to collaborate. I do have to admit I am majorly swamped with some other projects right now, so if you have the time and inclination... I have a

[jira] Updated: (DERBY-1566) Document SQLStates in 10.2

2006-08-29 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1566?page=all ] Jean T. Anderson updated DERBY-1566: Attachment: (was: rrefexcept71493.html) Document SQLStates in 10.2 -- Key: DERBY-1566

[jira] Commented: (DERBY-1566) Document SQLStates in 10.2

2006-08-29 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1566?page=comments#action_12431294 ] Jean T. Anderson commented on DERBY-1566: - I removed the rrefexcept71493.html file I uploaded yesterday -- I had inadvertently generated it on a 10.1.3

Re: XML type description - possible changes?

2006-08-29 Thread Army
Daniel John Debrunner wrote: snip old XML type text That seems wrong to me, the use of store Unicode character-based, any implementation details are not important here. Also the use of large is not relevant, what about small XML documents? I have to admit, I'm guilty of copy-paste here. The

[jira] Updated: (DERBY-1130) Client should not allow databaseName to be set with setConnectionAttributes

2006-08-29 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1130?page=all ] Mike Matrigali updated DERBY-1130: -- Derby Info: [Patch Available, Existing Application Impact, Release Note Needed] (was: [Release Note Needed, Patch Available, Existing Application

Re: XML type description - possible changes?

2006-08-29 Thread Daniel John Debrunner
Army wrote: Daniel John Debrunner wrote: snip old XML type text That seems wrong to me, the use of store Unicode character-based, any implementation details are not important here. Also the use of large is not relevant, what about small XML documents? I have to admit, I'm guilty of

[jira] Updated: (DERBY-1575) document full syntax of CASE expression

2006-08-29 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1575?page=all ] Kim Haase updated DERBY-1575: - Attachment: DERBY-1575.diff Here is a patch that I hope fixes the CASE syntax. I noticed that the formatting in general was inconsistent with the formatting for

[jira] Updated: (DERBY-1575) document full syntax of CASE expression

2006-08-29 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1575?page=all ] Kim Haase updated DERBY-1575: - Derby Info: [Patch Available] document full syntax of CASE expression --- Key: DERBY-1575

Re: [jira] Updated: (DERBY-1566) Document SQLStates in 10.2

2006-08-29 Thread David Van Couvering
It's not the severity code. What you are seeing are the SQL State classes (the first two characters of the SQL State) that are new in 10.2. Most of these are related to DRDA, as part of the client work. I will attach to the JIRA a version of the ErrorMessageGenerator which added

[jira] Updated: (DERBY-1566) Document SQLStates in 10.2

2006-08-29 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1566?page=all ] David Van Couvering updated DERBY-1566: --- Attachment: ErrorMessageGenerator.david.java This version adds elements for the new SQL State classes that have been added as part of the client

[jira] Commented: (DERBY-1686) Grant/Revoke: Attempt to GRANT access to another user on a VIEW, created by the current user with only SELECT privilege on the base table does not fail

2006-08-29 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431307 ] Mamta A. Satoor commented on DERBY-1686: Yip, even when we support WITH GRANT OPTION, we can modify the compile time privilege dependency rows check to

[jira] Updated: (DERBY-1681) Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

2006-08-29 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1681?page=all ] Mike Matrigali updated DERBY-1681: -- merged test case from trunk to 10.1 branch: 437380 m101_142:9svn commit Sending

[jira] Reopened: (DERBY-1681) Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

2006-08-29 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1681?page=all ] A B reopened DERBY-1681: Reopening to update Fixin to include trunk (10.3) Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

[jira] Resolved: (DERBY-1681) Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

2006-08-29 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1681?page=all ] A B resolved DERBY-1681. Fix Version/s: 10.3.0.0 Resolution: Fixed Derby Info: [Existing Application Impact, Regression] (was: [Patch Available, Existing Application Impact,

[jira] Commented: (DERBY-1681) Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

2006-08-29 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1681?page=comments#action_12431315 ] A B commented on DERBY-1681: oops, typo: have not been committed to... should be have now been committed to... Regression (wrong results): Join predicate can be

[jira] Updated: (DERBY-1681) Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

2006-08-29 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1681?page=all ] Mike Matrigali updated DERBY-1681: -- Fix Version/s: (was: 10.3.0.0) Derby Info: [Patch Available, Existing Application Impact, Regression] (was: [Regression, Existing Application

Re: XML type description - possible changes?

2006-08-29 Thread Laura Stewart
On 8/29/06, Daniel John Debrunner [EMAIL PROTECTED] wrote: Army wrote: Daniel John Debrunner wrote: snip old XML type text That seems wrong to me, the use of store Unicode character-based, any implementation details are not important here. Also the use of large is not relevant, what

[jira] Closed: (DERBY-1681) Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

2006-08-29 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1681?page=all ] A B closed DERBY-1681. -- Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

Re: doc reviews question

2006-08-29 Thread Rajesh Kartha
Laura Stewart wrote: Good questions. 1. When the list of reviewers and sections were added, something got dropped from the main table. After the comment column, there needs to be a Status column. That is where the person who addresses the comment indicates the status of the documentation for

[jira] Reopened: (DERBY-1681) Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

2006-08-29 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1681?page=all ] A B reopened DERBY-1681: Looks like I was making changes the same time Mike was, and our changes clashed. So I'm reopening (again) to correct fix-in and uncheck patch available...

[jira] Resolved: (DERBY-1681) Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

2006-08-29 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1681?page=all ] A B resolved DERBY-1681. Fix Version/s: 10.3.0.0 Resolution: Fixed Derby Info: [Existing Application Impact, Regression] (was: [Regression, Patch Available, Existing Application

[jira] Closed: (DERBY-1681) Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

2006-08-29 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1681?page=all ] A B closed DERBY-1681. -- Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

[jira] Updated: (DERBY-1777) Regression: query works in 10.1.2.1 but fails with NullPointerException in 10.2.1.1

2006-08-29 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1777?page=all ] Rick Hillegas updated DERBY-1777: - Fix Version/s: 10.2.1.0 Assign this regression to 10.2. Regression: query works in 10.1.2.1 but fails with NullPointerException in 10.2.1.1

[jira] Updated: (DERBY-1777) Regression: query works in 10.1.2.1 but fails with NullPointerException in 10.2.1.1

2006-08-29 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1777?page=all ] Rick Hillegas updated DERBY-1777: - Urgency: Urgent (was: Blocker) Regression: query works in 10.1.2.1 but fails with NullPointerException in 10.2.1.1

Re: doc reviews question

2006-08-29 Thread Laura Stewart
On 8/29/06, Rajesh Kartha [EMAIL PROTECTED] wrote: The Status field on the main section table was added to mark reviews of respective sections as Complete, when done. However, I do agree we need another field corresponding to each comment under the subsection to indicate if it was resolved

[jira] Assigned: (DERBY-1675) Network Server should not send to client that it supports EUSRIDPWD when running against Sun JVM

2006-08-29 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1675?page=all ] Sunitha Kambhampati reassigned DERBY-1675: -- Assignee: Sunitha Kambhampati Network Server should not send to client that it supports EUSRIDPWD when running against Sun JVM

[jira] Commented: (DERBY-1686) Grant/Revoke: Attempt to GRANT access to another user on a VIEW, created by the current user with only SELECT privilege on the base table does not fail

2006-08-29 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431335 ] Daniel John Debrunner commented on DERBY-1686: -- Was there any reference to the SQL spec ever found to ensure we are handling the issue correctly?

[jira] Commented: (DERBY-1682) Add documentation for derby.drda.securityMechanism.

2006-08-29 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1682?page=comments#action_12431337 ] Kim Haase commented on DERBY-1682: -- Yes, I'll do that. Add documentation for derby.drda.securityMechanism. ---

[jira] Reopened: (DERBY-1682) Add documentation for derby.drda.securityMechanism.

2006-08-29 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1682?page=all ] Kim Haase reopened DERBY-1682: -- I'll provide a patch file to add the new security mechanism. Add documentation for derby.drda.securityMechanism.

Re: XML type description - possible changes?

2006-08-29 Thread Jean T. Anderson
Laura Stewart wrote: ... FYI - I would prefer to keep the phrase data type in the title and first paragraph of this file as a qualifier. In the near future (post 10.2) I intend to update all of the other files that describe data types to add this qualifier. There are many files in Derby that

[jira] Commented: (DERBY-1686) Grant/Revoke: Attempt to GRANT access to another user on a VIEW, created by the current user with only SELECT privilege on the base table does not fail

2006-08-29 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431346 ] Mamta A. Satoor commented on DERBY-1686: I think Yip has a reference to SQL specification section about the handling of this issue. It is part of the

[jira] Updated: (DERBY-1682) Add documentation for derby.drda.securityMechanism.

2006-08-29 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1682?page=all ] Kim Haase updated DERBY-1682: - Attachment: derby1682_update.diff radmindrdasecmechanism_update.html Here is a patch that adds the new security mechanism to the syntax. It's an

[jira] Commented: (DERBY-1682) Add documentation for derby.drda.securityMechanism.

2006-08-29 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1682?page=comments#action_12431349 ] Kim Haase commented on DERBY-1682: -- Sorry, I meant to add that the new files have _update in the file names. Add documentation for derby.drda.securityMechanism.

[jira] Updated: (DERBY-1682) Add documentation for derby.drda.securityMechanism.

2006-08-29 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1682?page=all ] Kim Haase updated DERBY-1682: - Derby Info: [Patch Available] Add documentation for derby.drda.securityMechanism. --- Key:

[jira] Commented: (DERBY-1575) document full syntax of CASE expression

2006-08-29 Thread Christian d'Heureuse (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1575?page=comments#action_12431350 ] Christian d'Heureuse commented on DERBY-1575: - The patch contains the following lines that are not correct: codeblockbCASE WHEN

Re: [jira] Updated: (DERBY-1566) Document SQLStates in 10.2

2006-08-29 Thread Jean T. Anderson
David Van Couvering (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-1566?page=all ] David Van Couvering updated DERBY-1566: --- Attachment: ErrorMessageGenerator.david.java This version adds elements for the new SQL State classes

[jira] Updated: (DERBY-1583) With grant revoke enabled, defining a trigger whose actions updates a table (from different schema) results in NPE

2006-08-29 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1583?page=all ] Bryan Pendleton updated DERBY-1583: --- Attachment: skipAddPriv_v2.diff Attached is skipAddPriv_v2.diff. This patch proposal includes improved comments in the code, as well as additional tests.

[jira] Updated: (DERBY-1583) With grant revoke enabled, defining a trigger whose actions updates a table (from different schema) results in NPE

2006-08-29 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1583?page=all ] Bryan Pendleton updated DERBY-1583: --- Derby Info: [Patch Available] With grant revoke enabled, defining a trigger whose actions updates a table (from different schema) results in NPE

[jira] Commented: (DERBY-1686) Grant/Revoke: Attempt to GRANT access to another user on a VIEW, created by the current user with only SELECT privilege on the base table does not fail

2006-08-29 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431356 ] Daniel John Debrunner commented on DERBY-1686: -- I guess I'm a little lost from all the comments in this issue as to what exactly the proposed

Re: XML type description - possible changes?

2006-08-29 Thread Laura Stewart
On 8/29/06, Jean T. Anderson [EMAIL PROTECTED] wrote: Laura Stewart wrote: ... FYI - I would prefer to keep the phrase data type in the title and first paragraph of this file as a qualifier. In the near future (post 10.2) I intend to update all of the other files that describe data types to

[jira] Reopened: (DERBY-1747) Documentation for 10.2 Strong Password Substitute feature

2006-08-29 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1747?page=all ] Kim Haase reopened DERBY-1747: -- Discovered that the contents of cadminappsclientsecurity.dita now overflow the boundaries of the middle table column in PDF. Reopening to fix this

[jira] Commented: (DERBY-1583) With grant revoke enabled, defining a trigger whose actions updates a table (from different schema) results in NPE

2006-08-29 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1583?page=comments#action_12431363 ] Mamta A. Satoor commented on DERBY-1583: Bryan, thanks for taking care of my comments. I will take a look at the new patch later tonight. I wondered

Re: XML type description - possible changes?

2006-08-29 Thread Jean T. Anderson
This sounds like a larger style issue that should be tackled post 10.2. In the meantime, let's be consistent with current usage. -jean Laura Stewart wrote: On 8/29/06, Jean T. Anderson [EMAIL PROTECTED] wrote: Laura Stewart wrote: ... FYI - I would prefer to keep the phrase data type in

[jira] Updated: (DERBY-1747) Documentation for 10.2 Strong Password Substitute feature

2006-08-29 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1747?page=all ] Kim Haase updated DERBY-1747: - Derby Info: [Patch Available] Documentation for 10.2 Strong Password Substitute feature -

[jira] Updated: (DERBY-1747) Documentation for 10.2 Strong Password Substitute feature

2006-08-29 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1747?page=all ] Kim Haase updated DERBY-1747: - Attachment: derby1747_update.diff cadminappsclientsecurity_update.html Attaching derby1747_update.diff and cadminappsclientsecurity_update.html to

[jira] Commented: (DERBY-1583) With grant revoke enabled, defining a trigger whose actions updates a table (from different schema) results in NPE

2006-08-29 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1583?page=comments#action_12431365 ] Bryan Pendleton commented on DERBY-1583: I will have a look at DERBY-1724. With grant revoke enabled, defining a trigger whose actions updates a table

Re: Recent work on COALESCE?

2006-08-29 Thread Mamta Satoor
Kristian, I did a search on COALESCE and found recent activity related to it as part of DERBY-1574. This jira entry may have nothing to do with issue at hand but I thought I would share. Mamta On 8/29/06, Kristian Waagan [EMAIL PROTECTED] wrote: Hi,Can anyone remember doing some work on COALESCE

[jira] Commented: (DERBY-1686) Grant/Revoke: Attempt to GRANT access to another user on a VIEW, created by the current user with only SELECT privilege on the base table does not fail

2006-08-29 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431370 ] Yip Ng commented on DERBY-1686: --- Yes, in the case of some objects referenced in the view V that are not owned by the grantor A, the following statement should fail

[jira] Commented: (DERBY-1618) store/BootAllTest.junit fails on ibm131, wctme5.7

2006-08-29 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1618?page=comments#action_12431379 ] Myrna van Lunteren commented on DERBY-1618: --- There are actually 2 failing behaviors with this test - jdk131/ibm131: 3 databases expected, was 3 (stack 1

[jira] Commented: (DERBY-1686) Grant/Revoke: Attempt to GRANT access to another user on a VIEW, created by the current user with only SELECT privilege on the base table does not fail

2006-08-29 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431377 ] Daniel John Debrunner commented on DERBY-1686: -- I'm still confused, please bear with me, some detailed reference to the specs and quotes would help.

[jira] Updated: (DERBY-1583) With grant revoke enabled, defining a trigger whose actions updates a table (from different schema) results in NPE

2006-08-29 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1583?page=all ] Bryan Pendleton updated DERBY-1583: --- Attachment: skipAddPriv_v3.diff Mamta, thanks for the suggestion about DERBY-1724. I think it is definitely another manifestation of the same bug.

[jira] Updated: (DERBY-1575) document full syntax of CASE expression

2006-08-29 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1575?page=all ] Kim Haase updated DERBY-1575: - Attachment: DERBY-1575_fix.diff rrefcasenullif.html I'm really sorry I garbled the syntax. I've attached a corrected patch (DERBY-1575_fix.diff) and

Re: [Db-derby Wiki] Update of IntroToJUnit by SusanCline

2006-08-29 Thread Daniel John Debrunner
Apache Wiki wrote: Dear Wiki user, You have subscribed to a wiki page or wiki category on Db-derby Wiki for change notification. The following page has been changed by SusanCline: http://wiki.apache.org/db-derby/IntroToJUnit This is good stuff Susan, Thanks. The section on JUnit tests

[jira] Commented: (DERBY-1575) document full syntax of CASE expression

2006-08-29 Thread Christian d'Heureuse (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1575?page=comments#action_12431389 ] Christian d'Heureuse commented on DERBY-1575: - The new patch looks fine. Thanks for your work. document full syntax of CASE expression

Re: svn commit: r438211 - in /db/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests: master/basetab.out master/schema1.out master/schema5.out tests/nist/basetab.sql tests/nist/schema1

2006-08-29 Thread Myrna van Lunteren
On 8/29/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Author: djd Date: Tue Aug 29 13:59:44 2006 New Revision: 438211 URL: http://svn.apache.org/viewvc?rev=438211view=rev Log: Minor fix to nist scripts basetab, schema1 and schema5 not to call exit at the end as it is not required. Modified:

  1   2   >