Re: DERBY-1566: "SQL error messages and exceptions" doc

2006-08-30 Thread David Van Couvering
I had earlier suggested derbyBuild and Andrew concurred. No, I'm not going to try and find the email :). Another round of discussions can occur, but I had assumed lazy majority with that last go-round and was planning to check it into derbyBuild. David Jean T. Anderson wrote: Rick Hillegas

Re: Integrating a JUnit test into the test harness was: Re: [Db-derby Wiki] Update of "IntroToJUnit" by SusanCline

2006-08-30 Thread Myrna van Lunteren
On 8/30/06, Daniel John Debrunner <[EMAIL PROTECTED]> wrote: Susan Cline wrote: > But when I try to run the entire derbylang suite the only test that fails is _Suite, > but I'm wondering if it really failed: > > java org.apache.derbyTesting.functionTests.harness.RunSuite derbylang > > derbylan

Re: Making 10.2 doc available (Was Re: Upcoming 10.2 candidates)

2006-08-30 Thread Jean T. Anderson
Andrew McIntyre wrote: > On 8/24/06, Jean T. Anderson <[EMAIL PROTECTED]> wrote: > >> ok, when the 10.2 docs get added to the nightly build, I'll add a 10.2 >> section with links to http://db.apache.org/derby/manuals . > > I've added the 10.2.1.1 beta documentation to > http://db.apache.org/derby

[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-30 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431769 ] Yip Ng commented on DERBY-1686: --- "The applicable privileges shall include a privilege identifying O." "O" is defined in 12.2 under Syntax Rules item 1 and "Identifi

Re: DERBY-1566: "SQL error messages and exceptions" doc

2006-08-30 Thread Jean T. Anderson
Jean T. Anderson wrote: > Daniel John Debrunner wrote: >>Jean T. Anderson wrote: > ... >>>1) 10.2 severity column. I bet there's a story why that column didn't >>>make it into 10.1, but I sure don't remember. ... >>The severity by definition (SQLException.getErrorCode) is a non-standard >>piece o

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

2006-08-30 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1566?page=all ] Jean T. Anderson updated DERBY-1566: Attachment: derby-1566-3.diff ErrorMessageGenerator.david.diffs3 rrefexcept-3.html The third time is a charm after

Re: Integrating a JUnit test into the test harness was: Re: [Db-derby Wiki] Update of "IntroToJUnit" by SusanCline

2006-08-30 Thread Daniel John Debrunner
Susan Cline wrote: > But when I try to run the entire derbylang suite the only test that fails is > _Suite, > but I'm wondering if it really failed: > > java org.apache.derbyTesting.functionTests.harness.RunSuite derbylang > > derbylang_fail.txt: > derbylang/derbylang.fail:lang/_Suite.junit >

Re: Integrating a JUnit test into the test harness was: Re: [Db-derby Wiki] Update of "IntroToJUnit" by SusanCline

2006-08-30 Thread Susan Cline
--- Daniel John Debrunner <[EMAIL PROTECTED]> wrote: > [EMAIL PROTECTED] wrote: > > > As Dan mentioned below my example about integrating a JUnit test into the > > Derby test harness > > was not accurate. I've changed the wiki page IntroToJUnit to point to the > > other JUnit wiki > > pages wh

Re: Making 10.2 doc available (Was Re: Upcoming 10.2 candidates)

2006-08-30 Thread Andrew McIntyre
On 8/24/06, Jean T. Anderson <[EMAIL PROTECTED]> wrote: ok, when the 10.2 docs get added to the nightly build, I'll add a 10.2 section with links to http://db.apache.org/derby/manuals . I've added the 10.2.1.1 beta documentation to http://db.apache.org/derby/docs/10.2/, but it is not a nightly

[jira] Commented: (DERBY-1786) a crash during re-encryption of an existing database with lot of tables can make database unrecoverable on a next boot.

2006-08-30 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1786?page=comments#action_12431756 ] Suresh Thalamati commented on DERBY-1786: - Hi Rick, This is related to new feature (re-encryption(DERBY-1156)). not a regression. User will hit this iss

[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-30 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431755 ] Daniel John Debrunner commented on DERBY-1686: -- I'm guess the requirement to fail comes from the Access Rules for 12.2 which state: "The applicable p

Re: Doc reviews: should the internal links for the PDFs work?

2006-08-30 Thread Andrew McIntyre
On 8/30/06, Laura Stewart <[EMAIL PROTECTED]> wrote: > When I click on those links with the HTML pages version of the doc they do work. > Is this a general (known) problem? Or is this a problem with this specific section > that I need to report in the doc review? Susan - this is a problem wi

Re: DERBY-1566: "SQL error messages and exceptions" doc

2006-08-30 Thread Jean T. Anderson
Daniel John Debrunner wrote: > Jean T. Anderson wrote: ... >>But I'll point out two differences between the 10.1 and 10.2 docs: >> >>1) 10.2 severity column. I bet there's a story why that column didn't >>make it into 10.1, but I sure don't remember. Anyone should feel free to >>provide that info.

[jira] Updated: (DERBY-1646) Documentation to address Grant/Revoke Authorization for views/triggers/constraints/routines(DERBY-1330)

2006-08-30 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1646?page=all ] Laura Stewart updated DERBY-1646: - Attachment: derby1646_1.diff derby1646_html1.zip Updated the following files: Filename Title

Re: DERBY-1566: "SQL error messages and exceptions" doc

2006-08-30 Thread Jean T. Anderson
Rick Hillegas wrote: > Hi Jean and David, > > Thanks for all this great, painstaking work! Here's where I hope we can > end up: > > A) David's tool is checked into the codeline. > > B) Just before building the docs, the release manager can run the tool > in order to generate the latest and great

[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-30 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431751 ] Daniel John Debrunner commented on DERBY-1686: -- Thanks Yip - I finally understood the logic in section 12.1, sorry for being so slow. Next question i

[jira] Commented: (DERBY-1521) Upgrade test needs to be enhanced to test grant revoke

2006-08-30 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1521?page=comments#action_12431750 ] Deepa Remesh commented on DERBY-1521: - Current state of this issue - after upgrade, we test basic grant/revoke works and system tables are updated correctly.

[jira] Created: (DERBY-1788) Using secmec 8(USRSSSBPWD) on 141 vms, fails with java.security.NoSuchAlgorithmException : SHA1PRNG.

2006-08-30 Thread Sunitha Kambhampati (JIRA)
Using secmec 8(USRSSSBPWD) on 141 vms, fails with java.security.NoSuchAlgorithmException : SHA1PRNG. Key: DERBY-1788 URL: http://issues.apache.org/jira/browse/DER

Re: DERBY-1566: "SQL error messages and exceptions" doc

2006-08-30 Thread Rick Hillegas
Hi Jean and David, Thanks for all this great, painstaking work! Here's where I hope we can end up: A) David's tool is checked into the codeline. B) Just before building the docs, the release manager can run the tool in order to generate the latest and greatest version. So I have a question

[jira] Commented: (DERBY-1786) a crash during re-encryption of an existing database with lot of tables can make database unrecoverable on a next boot.

2006-08-30 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1786?page=comments#action_12431749 ] Rick Hillegas commented on DERBY-1786: -- Hi Suresh, Do you think this is a regression from 10.1.3? Thanks-Rick > a crash during re-encryption of an existing

[jira] Commented: (DERBY-502) Browser title for manuals in HTML format is a non-sense default value

2006-08-30 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-502?page=comments#action_12431748 ] Andrew McIntyre commented on DERBY-502: --- Committed to trunk with revision 438714. Note that I did not update the Brazilian Portuguese manuals with their corre

[jira] Resolved: (DERBY-502) Browser title for manuals in HTML format is a non-sense default value

2006-08-30 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-502?page=all ] Andrew McIntyre resolved DERBY-502. --- Fix Version/s: 10.3.0.0 Resolution: Fixed > Browser title for manuals in HTML format is a non-sense default value >

Re: DERBY-1566: "SQL error messages and exceptions" doc

2006-08-30 Thread Daniel John Debrunner
Jean T. Anderson wrote: > A lot changed between 10.1.3 and 10.2.1.1. Six sqlstates dropped out, > 170 were added, and the current doc file for the Reference Guide isn't > up to date. > > Adding all the sqlstates in manually would be an effort for which I > don't believe we have time and it would

Re: Doc reviews: should the internal links for the PDFs work?

2006-08-30 Thread Laura Stewart
On 8/30/06, Susan Cline <[EMAIL PROTECTED]> wrote: When reviewing the PDF version of the alpha manuals, specifically this page: Page 248 (number printed on the page), Entitled J2EE Compliance: Java Transaction API and javax.sql Extensions, when I click on the URL's that link to other pages or

[jira] Assigned: (DERBY-1634) Documented syntax for storing jar files in a db has syntax errors

2006-08-30 Thread Stan Bradbury (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1634?page=all ] Stan Bradbury reassigned DERBY-1634: Assignee: Stan Bradbury > Documented syntax for storing jar files in a db has syntax errors > -

DERBY-1566: "SQL error messages and exceptions" doc

2006-08-30 Thread Jean T. Anderson
A lot changed between 10.1.3 and 10.2.1.1. Six sqlstates dropped out, 170 were added, and the current doc file for the Reference Guide isn't up to date. Adding all the sqlstates in manually would be an effort for which I don't believe we have time and it would be error prone. This is where David's

[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-30 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431743 ] Yip Ng commented on DERBY-1686: --- To address Dan's comment before a committer commits this jira. Dan stated: "Disallowing the grant as indicated would not provide an

Question on Grant/Revoke

2006-08-30 Thread Manjula G Kutty
Hi, I was testing the new grant/revoke feature and now have this question. Here is what I did ij> connect 'jdbc:derby:testdb;create=true' user 'DBADMIN' password 'admin'; ij> create table t1 (id int, name char(100)); 0 rows inserted/updated/deleted ij> insert into t1 values (1,'sss'),(2, 'bbb')

Re: Integrating a JUnit test into the test harness was: Re: [Db-derby Wiki] Update of "IntroToJUnit" by SusanCline

2006-08-30 Thread Daniel John Debrunner
[EMAIL PROTECTED] wrote: > As Dan mentioned below my example about integrating a JUnit test into the > Derby test harness > was not accurate. I've changed the wiki page IntroToJUnit to point to the > other JUnit wiki > pages which are more relevant to Derby for information about this. > > How

[jira] Created: (DERBY-1787) The database owner is incorrectly referred to as dba in the code comments that were checked in Derby 10.2 for grant revoke work. We should clean this up at some point.

2006-08-30 Thread Mamta A. Satoor (JIRA)
The database owner is incorrectly referred to as dba in the code comments that were checked in Derby 10.2 for grant revoke work. We should clean this up at some point. -

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

2006-08-30 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1566?page=all ] Jean T. Anderson updated DERBY-1566: Attachment: ErrorMessageGenerator.david.diffs2 derby-1566-2.diff rrefexcept-2.html I spotted one more problem with the a

[jira] Created: (DERBY-1786) a crash during re-encryption of an existing database with lot of tables can make database unrecoverable on a next boot.

2006-08-30 Thread Suresh Thalamati (JIRA)
a crash during re-encryption of an existing database with lot of tables can make database unrecoverable on a next boot. -- Key: DERBY-1786 U

[jira] Commented: (DERBY-1694) derbynet/testProperties.java hangs

2006-08-30 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1694?page=comments#action_12431739 ] Daniel John Debrunner commented on DERBY-1694: -- Just realized I didn't put all the info I learnt here. Increasing the wait time for booting the server

[jira] Commented: (DERBY-1646) Documentation to address Grant/Revoke Authorization for views/triggers/constraints/routines(DERBY-1330)

2006-08-30 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1646?page=comments#action_12431738 ] Mamta A. Satoor commented on DERBY-1646: Laura, that's great. Now, you just have to do your magic for column level privileges. > Documentation to address

[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-30 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431737 ] Mamta A. Satoor commented on DERBY-1686: OK, In that case, we are good to go. I will make a jira entry for changing "dba" to "database owner" whereever ap

[jira] Commented: (DERBY-1646) Documentation to address Grant/Revoke Authorization for views/triggers/constraints/routines(DERBY-1330)

2006-08-30 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1646?page=comments#action_12431735 ] Laura Stewart commented on DERBY-1646: -- Hi Mamta - I ahve drafted the text for the table-level limitation. Please look it over and see if I have captured wh

[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-30 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431734 ] Yip Ng commented on DERBY-1686: --- Mamta, thanks for taking the time for reviewing the patch. I apprecate your comments. Mamta wrote: >>1)In code comments, I saw ref

[jira] Commented: (DERBY-502) Browser title for manuals in HTML format is a non-sense default value

2006-08-30 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-502?page=comments#action_12431733 ] Andrew McIntyre commented on DERBY-502: --- I have fixes for both of these issues. Ant should replace the default Web Sample with the name of the manual while co

[jira] Assigned: (DERBY-502) Browser title for manuals in HTML format is a non-sense default value

2006-08-30 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-502?page=all ] Andrew McIntyre reassigned DERBY-502: - Assignee: Andrew McIntyre > Browser title for manuals in HTML format is a non-sense default value > ---

[jira] Updated: (DERBY-1694) derbynet/testProperties.java hangs

2006-08-30 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1694?page=all ] Mike Matrigali updated DERBY-1694: -- Urgency: Urgent Fix Version/s: 10.2.1.0 I have now seen the test hang against sun jdk 1.4.2 in a 10.2 client branch. What I see outside is the t

[jira] Updated: (DERBY-1618) store/BootAllTest.junit fails on with jdk13 based jvms

2006-08-30 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1618?page=all ] Myrna van Lunteren updated DERBY-1618: -- Summary: store/BootAllTest.junit fails on with jdk13 based jvms (was: store/BootAllTest.junit fails on ibm131, wctme5.7) modifying the title to mo

Integrating a JUnit test into the test harness was: Re: [Db-derby Wiki] Update of "IntroToJUnit" by SusanCline

2006-08-30 Thread home4slc
As Dan mentioned below my example about integrating a JUnit test into the Derby test harness was not accurate. I've changed the wiki page IntroToJUnit to point to the other JUnit wiki pages which are more relevant to Derby for information about this. However, I've spent some time trying to get

[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-30 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431728 ] Mamta A. Satoor commented on DERBY-1686: Yip, the latest patch looks pretty good to me. Just 2 minor comments 1)In code comments, I saw references to "dba".

Re: [jira] Commented: (DERBY-1551) Update documentation to indicate procedures can be called from triggers (DERBY-551)

2006-08-30 Thread Jean T. Anderson
Deepa Remesh wrote: > On 8/30/06, Jean T. Anderson <[EMAIL PROTECTED]> wrote: > >> Deepa Remesh (JIRA) wrote: >> > [ >> http://issues.apache.org/jira/browse/DERBY-1551?page=comments#action_12431671 >> ] >> > >> > Deepa Remesh commented on DERBY-1551: >> > -

[jira] Closed: (DERBY-1551) Update documentation to indicate procedures can be called from triggers (DERBY-551)

2006-08-30 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1551?page=all ] Deepa Remesh closed DERBY-1551. --- Patch has been applied to trunk and 10.2 branch. > Update documentation to indicate procedures can be called from triggers > (DERBY-551) > -

[jira] Updated: (DERBY-1551) Update documentation to indicate procedures can be called from triggers (DERBY-551)

2006-08-30 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1551?page=all ] Deepa Remesh updated DERBY-1551: Fix Version/s: 10.2.1.0 > Update documentation to indicate procedures can be called from triggers > (DERBY-551) > -

Doc reviews: should the internal links for the PDFs work?

2006-08-30 Thread Susan Cline
When reviewing the PDF version of the alpha manuals, specifically this page: Page 248 (number printed on the page), Entitled J2EE Compliance: Java Transaction API and javax.sql Extensions, when I click on the URL's that link to other pages or sections in the documentation, they do not work.

[jira] Commented: (DERBY-1646) Documentation to address Grant/Revoke Authorization for views/triggers/constraints/routines(DERBY-1330)

2006-08-30 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1646?page=comments#action_12431715 ] Mamta A. Satoor commented on DERBY-1646: That sounds fine, Laura. > Documentation to address Grant/Revoke Authorization for > views/triggers/constraints/r

Testing on 10.2.1.1 beta

2006-08-30 Thread Ole Solberg
Test results for the 10.2.1.1 beta are now available at http://www.multinet.no/~solberg/public/Apache/#TenTwoZeroSnapshots Tests have been run with jvm1.4, jvm1.5 and jvm1.6 on 10 different OS platforms. I will add the "Summary" report and the report for "Additional tests" soon. -- Ole Solb

[jira] Commented: (DERBY-1752) Fix javadoc to account for changes required by new licence header policy.

2006-08-30 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1752?page=comments#action_12431713 ] Daniel John Debrunner commented on DERBY-1752: -- The header text in http://www.apache.org/legal/src-headers.html#header-text is clearly designed for s

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

2006-08-30 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1618?page=comments#action_12431712 ] Myrna van Lunteren commented on DERBY-1618: --- This second problem is now logged as DERBY-1785. > store/BootAllTest.junit fails on ibm131, wctme5.7 > -

[jira] Created: (DERBY-1785) junit tests fail with permission access problems when run with j9 jvms

2006-08-30 Thread Myrna van Lunteren (JIRA)
junit tests fail with permission access problems when run with j9 jvms -- Key: DERBY-1785 URL: http://issues.apache.org/jira/browse/DERBY-1785 Project: Derby Issue Type: Tes

Re: [jira] Commented: (DERBY-1551) Update documentation to indicate procedures can be called from triggers (DERBY-551)

2006-08-30 Thread Deepa Remesh
On 8/30/06, Jean T. Anderson <[EMAIL PROTECTED]> wrote: Deepa Remesh (JIRA) wrote: > [ http://issues.apache.org/jira/browse/DERBY-1551?page=comments#action_12431671 ] > > Deepa Remesh commented on DERBY-1551: > - > > I think this change (svn revision 43092

Re: [jira] Commented: (DERBY-1551) Update documentation to indicate procedures can be called from triggers (DERBY-551)

2006-08-30 Thread Jean T. Anderson
Deepa Remesh (JIRA) wrote: > [ > http://issues.apache.org/jira/browse/DERBY-1551?page=comments#action_12431671 > ] > > Deepa Remesh commented on DERBY-1551: > - > > I think this change (svn revision 430925) missed the mega-merge. Can a > com

[jira] Commented: (DERBY-502) Browser title for manuals in HTML format is a non-sense default value

2006-08-30 Thread Kim Haase (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-502?page=comments#action_12431698 ] Kim Haase commented on DERBY-502: - This is actually two separate problems, neither of which I can figure out how to solve. For the HTML frames version, what happen

[jira] Commented: (DERBY-1752) Fix javadoc to account for changes required by new licence header policy.

2006-08-30 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1752?page=comments#action_12431695 ] Andrew McIntyre commented on DERBY-1752: HI Dan, I missed the 'or its licensees,' sorry about that. As for the text Iadded, I was just following the policy

Re: Re: installation issue: problems caused by spaces in path pointed to by DERBY_HOME or DERBY_INSTALL

2006-08-30 Thread Andrew McIntyre
On 8/25/06, Andrew McIntyre <[EMAIL PROTECTED]> wrote: On 8/25/06, Rick Hillegas <[EMAIL PROTECTED]> wrote: > > It does not work correctly on Windows XP SP2. It adds extra characters > that are not the DOS 8.3 format and even changes the name of the db > directory in the PATH to db0. The error me

[jira] Commented: (DERBY-1646) Documentation to address Grant/Revoke Authorization for views/triggers/constraints/routines(DERBY-1330)

2006-08-30 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1646?page=comments#action_12431674 ] Laura Stewart commented on DERBY-1646: -- None of the other SQL statements have separate topics that discuss limitations. Nor do they have sections within the

[jira] Commented: (DERBY-1551) Update documentation to indicate procedures can be called from triggers (DERBY-551)

2006-08-30 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1551?page=comments#action_12431671 ] Deepa Remesh commented on DERBY-1551: - I think this change (svn revision 430925) missed the mega-merge. Can a committer please merge this doc change to 10.2 br

[jira] Created: (DERBY-1784) When qualifying a synonym with its name in the select list, Derby throws SQLSTATE 42X04.

2006-08-30 Thread Yip Ng (JIRA)
When qualifying a synonym with its name in the select list, Derby throws SQLSTATE 42X04. Key: DERBY-1784 URL: http://issues.apache.org/jira/browse/DERBY-1784 Pro

[jira] Updated: (DERBY-1784) When qualifying a column name with its synonym name in the select list, Derby throws SQLSTATE 42X04.

2006-08-30 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1784?page=all ] Yip Ng updated DERBY-1784: -- Summary: When qualifying a column name with its synonym name in the select list, Derby throws SQLSTATE 42X04. (was: When qualifying a synonym with its name in the select

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

2006-08-30 Thread Yip Ng
+1 for commiting Bryan's patch.On 8/30/06, Bryan Pendleton <[EMAIL PROTECTED]> wrote: Mike Matrigali wrote:> Bryan do you think it is a problem checking in your patch for 1583 prior > to doing the 1724 research?  Are you planning to commit, or are you> looking for someone else to commit the patch?H

Re: Accessibility - Documentation checks

2006-08-30 Thread Kim Haase
Laura Stewart wrote On 08/30/06 12:27,: > Has anyone checked the Derby documentation for accessibility? > > Accessibility is important for people who have disabilities. People > who are blind or have low vision use screen readers that use text to > speech to read software or screen magnifiers tha

Re: Options for syncing of log to disk

2006-08-30 Thread Suresh Thalamati
Olav Sandstaa wrote: I have run some simple tests where I have changed mode from "rws" to "rwd" for the Derby log file. When running a small numbers of concurrent client threads the throughput is almost doubled and the response time is almost halved. I am enclosing two graphs that show this whe

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

2006-08-30 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1566?page=all ] Jean T. Anderson updated DERBY-1566: Attachment: newmsgs-10.2.txt Here are some basic stats about what changed between 10.1 and 10.2: - 10.1.3 has 657 sqlstate entries - 10.2.1.1 has 849

[jira] Commented: (DERBY-1646) Documentation to address Grant/Revoke Authorization for views/triggers/constraints/routines(DERBY-1330)

2006-08-30 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1646?page=comments#action_12431655 ] Mamta A. Satoor commented on DERBY-1646: Laura, I feel that it should as a topic in the same page as the exsiting revoke statement. This way, all the perti

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

2006-08-30 Thread Bryan Pendleton
Mike Matrigali wrote: Bryan do you think it is a problem checking in your patch for 1583 prior to doing the 1724 research? Are you planning to commit, or are you looking for someone else to commit the patch? Hi Mike, thanks for the feedback. I don't think it would be a problem to commit the

Re: [junit] Top-level suites added

2006-08-30 Thread Daniel John Debrunner
Vemund Ostgaard wrote: > I have a suggestion, based on the following view: > > * I would avoid creating suites just to handle the various frameworks, > or other configuration related things. This would mean a simpler > structure of suites, easier to understand and maintain. If we want to > have

[jira] Commented: (DERBY-1783) Logical error in code for determining mode for opening of log files

2006-08-30 Thread Suresh Thalamati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1783?page=comments#action_12431642 ] Suresh Thalamati commented on DERBY-1783: - Good Catch Olav. I will review and commit the patch. > Logical error in code for determining mode for opening

[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-30 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=all ] Yip Ng updated DERBY-1686: -- Attachment: derby1686-trunk-stat05.txt derby1686-trunk-diff05.txt Attaching derby1686-trunk-diff05.txt for review. With this patch, the view checking is m

Re: [jira] Commented: (DERBY-883) Enhance GROUP BY clause to support expressions instead of just column references.

2006-08-30 Thread Mike Matrigali
Daniel John Debrunner wrote: Kristian Waagan (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-883?page=comments#action_12431617 ] Kristian Waagan commented on DERBY-883: --- The former; merged without errors. Was this a general q

[jira] Commented: (DERBY-1646) Documentation to address Grant/Revoke Authorization for views/triggers/constraints/routines(DERBY-1330)

2006-08-30 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1646?page=comments#action_12431636 ] Laura Stewart commented on DERBY-1646: -- One place that we could add this information is in the Developers Guide - the "SQL tips" section. Although we might wa

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

2006-08-30 Thread Mike Matrigali
Bryan do you think it is a problem checking in your patch for 1583 prior to doing the 1724 research? Are you planning to commit, or are you looking for someone else to commit the patch? Bryan Pendleton (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-1583?page=comments#action_124

[jira] Commented: (DERBY-1646) Documentation to address Grant/Revoke Authorization for views/triggers/constraints/routines(DERBY-1330)

2006-08-30 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1646?page=comments#action_12431634 ] Laura Stewart commented on DERBY-1646: -- Mamta - I think that a new topic is needed to discuss this behavior. With a title of "Limitations of revoke privilege

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

2006-08-30 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1566?page=all ] Jean T. Anderson updated DERBY-1566: Attachment: derby-1566-1.diff derby-1566-1.diff is the patch for the dita source that goes with the rrefexcept71493.html review copy (forgot to upload

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

2006-08-30 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1566?page=all ] Jean T. Anderson updated DERBY-1566: Derby Info: [Patch Available] > Document SQLStates in 10.2 > -- > > Key: DERBY-1566 > URL: http:

Re: [jira] Commented: (DERBY-883) Enhance GROUP BY clause to support expressions instead of just column references.

2006-08-30 Thread Daniel John Debrunner
Kristian Waagan (JIRA) wrote: > [ > http://issues.apache.org/jira/browse/DERBY-883?page=comments#action_12431617 > ] > > Kristian Waagan commented on DERBY-883: > --- > > The former; merged without errors. > Was this a general question, or i

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

2006-08-30 Thread Prasenjit Sarkar (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1777?page=comments#action_12431623 ] Prasenjit Sarkar commented on DERBY-1777: - All of them fail with the same stack trace. All failures are repeatable and affect only certain queries and not

[jira] Commented: (DERBY-883) Enhance GROUP BY clause to support expressions instead of just column references.

2006-08-30 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-883?page=comments#action_12431617 ] Kristian Waagan commented on DERBY-883: --- The former; merged without errors. Was this a general question, or is there reason to believe a merge will cause prob

Accessibility - Documentation checks

2006-08-30 Thread Laura Stewart
Has anyone checked the Derby documentation for accessibility? Accessibility is important for people who have disabilities. People who are blind or have low vision use screen readers that use text to speech to read software or screen magnifiers that enlarge information on the screen. I know that

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

2006-08-30 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1601?page=all ] Laura Stewart closed DERBY-1601. Closing this issue. Rick merged the patch(es) for this issue to the 10.2 branch on 8/25. > Document (in Tuning Guide) new subquery materialization via hash join

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

2006-08-30 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1622?page=all ] Laura Stewart closed DERBY-1622. Closing this issue. Rick ported the patch(es) for this issue to the 10.2 branch on 8/26. > Add documentation for encrypted database using encryptionKey >

[jira] Closed: (DERBY-1685) The reference manual has wrong procedure name for online bacup

2006-08-30 Thread Laura Stewart (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1685?page=all ] Laura Stewart closed DERBY-1685. Closing this issue. Rick ported the patch(es) for this issue to the 10.2 branch on 8/25. > The reference manual has wrong procedure name for online bacup > --

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

2006-08-30 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1777?page=comments#action_12431609 ] A B commented on DERBY-1777: > There are 15 other queries that fail. Do all of them fail with the same error and same stack trace? Or are the failures different?

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

2006-08-30 Thread jira
Issue Subscription Filter: Derby: JIRA issues with patch available (18 issues) Subscriber: derby-dev Key Summary DERBY-1583 With grant revoke enabled, defining a trigger whose actions updates a table (from different schema) results in NPE http://issues.apache.org/jira/browse

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

2006-08-30 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1583?page=comments#action_12431603 ] Bryan Pendleton commented on DERBY-1583: Thanks Mamta and Yip for the review! I will try to figure out why the DERBY-1724 NPE is related to transaction hand

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

2006-08-30 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1779?page=all ] Daniel John Debrunner resolved DERBY-1779. -- Resolution: Invalid Section 11 from — SQL — Part 13: SQL Routines and Types Using the Java™ Programming Language (SQL/JRT) defines these pr

[jira] Commented: (DERBY-883) Enhance GROUP BY clause to support expressions instead of just column references.

2006-08-30 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-883?page=comments#action_12431598 ] Daniel John Debrunner commented on DERBY-883: - "worked fine" as in merged without errors, or "worked fine" as in derbyall passed on the branch wih the m

Re: Options for syncing of log to disk

2006-08-30 Thread Mike Matrigali
Initial writes to the log are to a preallocated log, but once it is filled it is possible for there to be writes that extend the log and thus it is not safe to not sync metadata that tracks the length of the file. Unfortunately this behavior is hardware, OS and JVM specific, and the exact meaning

Re: Recent work on COALESCE?

2006-08-30 Thread Kristian Waagan
Mamta Satoor wrote: 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. Thanks Mamta, Dag also commented on this issue. I found out that DERBY-1574 itself

[jira] Commented: (DERBY-883) Enhance GROUP BY clause to support expressions instead of just column references.

2006-08-30 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-883?page=comments#action_12431594 ] Kristian Waagan commented on DERBY-883: --- Are there any plans to merge 883.patch6.txt (revision 437070) to 10.2? I found out that it fixes the NPE with COALESCE

[jira] Updated: (DERBY-1782) When a privilege is revoked at table level, Derby should only drop objects that require that particular privilege and not all the objects that require some form of privile

2006-08-30 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1782?page=all ] Rick Hillegas updated DERBY-1782: - Urgency: Urgent Fix Version/s: 10.2.1.0 Assigning to 10.2 since the ANSI spec requires this behavior. > When a privilege is revoked at table level,

Re: Question on the lib 10.2.1.1beta layout

2006-08-30 Thread Rick Hillegas
Thanks, Andrew. I think I can sweep this up with the next pre-build merge. Cheers, -Rick Andrew McIntyre wrote: 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

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

2006-08-30 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1696?page=all ] Andreas Korneliussen updated DERBY-1696: Derby Info: [Patch Available] > transaction may sometimes keep lock on a row after moving off the resultset > in scrollable updatable resultset

[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-30 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1559?page=all ] Andreas Korneliussen updated DERBY-1559: Fix Version/s: 10.3.0.0 Derby Info: (was: [Patch Available]) Committed revision 438478 at trunk. > when receiving a single EXTDTA obj

[jira] Commented: (DERBY-1610) Resolve difference of type compatibility between Embedded and NetworkServer/NetworkDriver

2006-08-30 Thread Tomohito Nakayama (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1610?page=comments#action_12431576 ] Tomohito Nakayama commented on DERBY-1610: -- Reading the org.apache.derby.client.am.PreparedStatement, I think each set and setNull method should have type

Re: [junit] Top-level suites added

2006-08-30 Thread Vemund Ostgaard
Daniel John Debrunner wrote: I added some top-level suites that are intended to be run directly by JUnit runners, not via the test harness. They are in the package: org.apache.derbyTesting.functionTests.suites AllPackages - A suite of all the _Suite suites for the function test packages Emb

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

2006-08-30 Thread Kristian Waagan (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1778?page=all ] Kristian Waagan closed DERBY-1778. -- Work on this will be done as part of DERBY-1381. > Document ij.exceptionTrace=true property in tools guide. > -

[jira] Updated: (DERBY-1783) Logical error in code for determining mode for opening of log files

2006-08-30 Thread Olav Sandstaa (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1783?page=all ] Olav Sandstaa updated DERBY-1783: - Fix Version/s: 10.3.0.0 Derby Info: [Patch Available] > Logical error in code for determining mode for opening of log files > -

[jira] Updated: (DERBY-1783) Logical error in code for determining mode for opening of log files

2006-08-30 Thread Olav Sandstaa (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1783?page=all ] Olav Sandstaa updated DERBY-1783: - Attachment: rwsync.diff Patch that fixes the logical code error by adding parentheses around the OR clause. In addition one minor fix to the javadoc for the

  1   2   >