[jira] Created: (DERBY-1779) Move class loading utilities into SYSCS_UTIL with the other system procedures and remove the SQLJ schema.

2006-08-29 Thread Stan Bradbury (JIRA)
Move class loading utilities into SYSCS_UTIL with the other system procedures and remove the SQLJ schema. --- Key: DERBY-1779 URL:

[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_12431393 ] Yip Ng commented on DERBY-1686: --- Yes, I agree that granting select on view V is not the same as granting select on base table. I think I wasn't clear on my

[jira] Commented: (DERBY-1779) Move class loading utilities into SYSCS_UTIL with the other system procedures and remove the SQLJ schema.

2006-08-29 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1779?page=comments#action_12431394 ] Daniel John Debrunner commented on DERBY-1779: -- These are the SQL standard defined names for the procedures including the SQLJ schema name. Move

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 Daniel John Debrunner
Myrna van Lunteren wrote: On 8/29/06, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: When changing the nist tests' files we're supposed to document this in the readme in the directory. Now it caught my eye, I noticed one more change where this probably should've happened - 7 months ago to

[jira] Created: (DERBY-1780) Document all supplied system procedures in the Server and Administration Guide (e.g. class loading utils and import/export)

2006-08-29 Thread Stan Bradbury (JIRA)
Document all supplied system procedures in the Server and Administration Guide (e.g. class loading utils and import/export) --- Key: DERBY-1780

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

2006-08-29 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1778?page=comments#action_12431395 ] Andrew McIntyre commented on DERBY-1778: Duplicate of DERBY-1381? Document ij.exceptionTrace=true property in tools guide.

[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_12431396 ] Daniel John Debrunner commented on DERBY-1686: -- Though user B can create a table T, do insert into T select * from v; grant select on public to T;

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

2006-08-29 Thread Kristian Waagan
Daniel John Debrunner wrote: 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

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

2006-08-29 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1778?page=all ] Sunitha Kambhampati resolved DERBY-1778. Resolution: Duplicate Thanks Andrew for pointing it out. Yes it is duplicate. My bad- I should have searched jira before opening this issue.

[jira] Updated: (DERBY-1636) document encryption of an un-encrypted database and re-encryption with new password/key.

2006-08-29 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1636?page=all ] Laura Stewart updated DERBY-1636: - Attachment: derby1636_devguide5.diff derby1636_devguide_html5.zip Updated the problem with the patch. Also identified problems in the PDF

Re: Question on the lib 10.2.1.1beta layout

2006-08-29 Thread Andrew McIntyre
On 8/29/06, Rick Hillegas [EMAIL PROTECTED] wrote: 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

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

2006-08-29 Thread Daniel John Debrunner
[EMAIL PROTECTED] wrote: Hi Dan, You're right - it worked for me today but then again, I did not update my source tree today! Do you think it's best if I just remove that section and point to DerbyJUnitTesting page instead? That is fine by me ... originally I wrote this information

[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 Rajesh Kartha (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431416 ] Rajesh Kartha commented on DERBY-1686: -- I know DB2 disallows such granting of permissions on a view if the grantor does not own OR does not have the

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

2006-08-29 Thread home4slc
Hum, it sounds to me like it should be on the DerbyJUnitTesting testing page. What I'm thinking of doing is updating the IntroToJUnit page to remove the contents of that section and point to the Derby JUnitTesting page. I'd be happy to add an example to the DerbyJUnitTesting page once I have

[jira] Created: (DERBY-1781) Process handles appear to be leaking in queries using an IN clause during concurrent DB access

2006-08-29 Thread Mark Hellkamp (JIRA)
Process handles appear to be leaking in queries using an IN clause during concurrent DB access -- Key: DERBY-1781 URL: http://issues.apache.org/jira/browse/DERBY-1781

Re: [jira] Created: (DERBY-1781) Process handles appear to be leaking in queries using an IN clause during concurrent DB access

2006-08-29 Thread Mike Matrigali
I am not familar with the terminology here, what kind of thing is a process handle? Any link available to describe it. Mark Hellkamp (JIRA) wrote: Process handles appear to be leaking in queries using an IN clause during concurrent DB access

[jira] Commented: (DERBY-1636) document encryption of an un-encrypted database and re-encryption with new password/key.

2006-08-29 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1636?page=comments#action_12431421 ] Jean T. Anderson commented on DERBY-1636: - Committed patch derby1636_devguide5.diff to the trunk, revision 438307 (did not merge to the 10.2 branch).

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

2006-08-29 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1566?page=comments#action_12431424 ] David Van Couvering commented on DERBY-1566: Diffs look goot to me... Seems like we could fix the lt and gt problem with some kind of parser...

[jira] Commented: (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)
[ http://issues.apache.org/jira/browse/DERBY-1777?page=comments#action_12431425 ] Prasenjit Sarkar commented on DERBY-1777: - There are 15 other queries that fail. Here's one more: 1. SELECT

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

2006-08-29 Thread Francois Orsini
Thanks for running the tests and updating the canon files Sunitha.On 8/29/06, Sunitha Kambhampati (JIRA) derby-dev@db.apache.org wrote: [ http://issues.apache.org/jira/browse/DERBY-1695?page=all ]Sunitha Kambhampati closed DERBY-1695.--Resolution:

[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_12431431 ] Yip Ng commented on DERBY-1686: --- Mamta, I thought about your proposal more with regard to checking SYSDEPENDS count on privilege dependencies. I think there might

Regression Test Failure! - TinderBox_Derby 438220 - Sun DBTG

2006-08-29 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 438220/2006-08-29 23:23:09 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 1672671 2 225.78% SunOS-5.10_i86pc-i386 Details in

[jira] Updated: (DERBY-1215) table elements in documentation need expanse attributes after switch to OASIS DTDs

2006-08-29 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1215?page=all ] Jean T. Anderson updated DERBY-1215: Fix Version/s: 10.3.0.0 table elements in documentation need expanse attributes after switch to OASIS DTDs

[jira] Updated: (DERBY-1601) Document (in Tuning Guide) new subquery materialization via hash join behavior that was introduced with DERBY-781

2006-08-29 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1601?page=all ] Jean T. Anderson updated DERBY-1601: Fix Version/s: 10.2.2.0 Document (in Tuning Guide) new subquery materialization via hash join behavior that was introduced with DERBY-781

[jira] Updated: (DERBY-1655) Document XML functionality for 10.2

2006-08-29 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1655?page=all ] Jean T. Anderson updated DERBY-1655: Fix Version/s: 10.2.2.0 Document XML functionality for 10.2 --- Key: DERBY-1655

[jira] Updated: (DERBY-1622) Add documentation for encrypted database using encryptionKey

2006-08-29 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1622?page=all ] Jean T. Anderson updated DERBY-1622: Fix Version/s: 10.2.2.0 Add documentation for encrypted database using encryptionKey

[jira] Updated: (DERBY-1717) Working With Derby task file twwdactivity4.dita is invalid, results in missing text

2006-08-29 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1717?page=all ] Jean T. Anderson updated DERBY-1717: Fix Version/s: 10.3.0.0 Working With Derby task file twwdactivity4.dita is invalid, results in missing text

[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_12431443 ] Yip Ng commented on DERBY-1686: --- Dan, here are the two references from the SQL:2003 spec that I have read to deduce the grant behavior for the stated problem of

[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_12431456 ] Mamta A. Satoor commented on DERBY-1686: Yip, I think you are right about my logic not working for a view created by the database owner but it references

[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_12431462 ] Mamta A. Satoor commented on DERBY-1583: I reviewed the patch skipAddPriv_v3.diff and looks like it should do the trick and take care of following 3 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 Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431469 ] Yip Ng commented on DERBY-1686: --- Mamta, I had this concern too when I was utilizing the dependency manager's getPersistentProviderInfos(dependable) method but it

[jira] Updated: (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=all ] Yip Ng updated DERBY-1686: -- Attachment: derby1686-trunk-stat04.txt derby1686-trunk-diff04.txt Attaching derby1686-trunk-diff04.txt, this patch fixes a minor problem on the execution

[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 Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1583?page=comments#action_12431473 ] Yip Ng commented on DERBY-1583: --- Mamta, just curious, why did the NPE occurs in transaction mode in DERBY-1724 but not in autocommit mode? With grant revoke

[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_12431474 ] Mamta A. Satoor commented on DERBY-1686: Thanks for your response on how dependency system takes care of chained view dependencies. Is

[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_12431476 ] Mamta A. Satoor commented on DERBY-1583: Yip, I haven't debugged DERBY-1724 yet to know why NPE is only in transaction mode. With grant revoke enabled,

[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_12431477 ] Yip Ng commented on DERBY-1686: --- Yes, please wait till tomorrow. I resubmit it because my laptop keeps on crashing on me today so just to be on the safe side, I

<    1   2