[jira] Created: (DERBY-1558) include ConcurrencyTest into a suite

2006-07-21 Thread Andreas Korneliussen (JIRA)
include ConcurrencyTest into a suite Key: DERBY-1558 URL: http://issues.apache.org/jira/browse/DERBY-1558 Project: Derby Issue Type: Test Components: Test Affects Versions: 10.2.0.0

Regression Test Failure! - Derby 424001 - Sun DBTG

2006-07-21 Thread Ole . Solberg
[Auto-generated mail] *Derby* 424001/2006-07-20 19:46:12 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.6* NA NA NANA SunOS-5.10_i86pc-i386 Details in

Re: Is jdbcapi.ConcurrencyTest Junit test run anywhere

2006-07-21 Thread Andreas Korneliussen
Daniel John Debrunner wrote: I couldn't see that the JUnit test org.apache.derbyTesting.functionTests.tests.jdbcapi.ConcurrencyTest is run anywhere. Seems to work fine for me, is it meant to be in the jdbcapi.runall suite list as are the other JUnit tests in that package? Hi, The

[jira] Created: (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-07-21 Thread Andreas Korneliussen (JIRA)
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 Key:

[jira] Commented: (DERBY-147) ERROR 42X79 not consistant ? - same column name specified twice

2006-07-21 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-147?page=comments#action_12422627 ] Knut Anders Hatlen commented on DERBY-147: -- Hi Bernd, Thank you for providing the patch. I'm sorry no one has picked it up yet. I had a brief look at it,

[jira] Updated: (DERBY-1535) Trial 2 for DERBY-550, improve use of Engine from NetworkServer and reduce memory usage

2006-07-21 Thread Tomohito Nakayama (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1535?page=all ] Tomohito Nakayama updated DERBY-1535: - Attachment: DERBY-1513_1535_2.patch Description of the patch: * Avoid expanding data into memory twice when NetworkServer receive binary

[jira] Commented: (DERBY-528) Support for DRDA Strong User ID and Password Substitute Authentication (USRSSBPWD) scheme

2006-07-21 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-528?page=comments#action_12422633 ] Rick Hillegas commented on DERBY-528: - I am far from being an expert on this area of the code. The changes, however, are very well commented and, coupled with

[jira] Commented: (DERBY-528) Support for DRDA Strong User ID and Password Substitute Authentication (USRSSBPWD) scheme

2006-07-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-528?page=comments#action_12422636 ] Kathey Marsden commented on DERBY-528: -- My functional concerns about 10.2 client not working with 10.1 server have been taken care of by reverting to the

One of the highest complements possible on derby-dev

2006-07-21 Thread Kathey Marsden
In DERBY-528 Rick said about Francois' patch: I am far from being an expert on this area of the code. The changes, however, are very well commented and, coupled with the extensive notes in this JIRA, allow me to understand the patch. Thanks Francois and others for striving for this standard

[jira] Commented: (DERBY-1539) As per the functional spec attached to DERBY-1330, a trigger should be dropped when a privilege required by the trigger is revoked.

2006-07-21 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1539?page=comments#action_12422643 ] Daniel John Debrunner commented on DERBY-1539: -- WIll a Permissions descriptor now change its hashCode during its lifetime? From the code it looks

[jira] Commented: (DERBY-147) ERROR 42X79 not consistant ? - same column name specified twice

2006-07-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-147?page=comments#action_12422647 ] Kathey Marsden commented on DERBY-147: -- Hi Bernd, When you resubmit your patch, please 1) Assign yourself 2) Mark the patch available checkbox. (which

[jira] Created: (DERBY-1560) When receiving EXTDTA object, the client should avoid keeping the entire LOB in memory for large LOBs

2006-07-21 Thread Fernanda Pizzorno (JIRA)
When receiving EXTDTA object, the client should avoid keeping the entire LOB in memory for large LOBs - Key: DERBY-1560 URL:

[jira] Updated: (DERBY-1272) Change sysinfo to print to error log (derby.log) on boot of derby if derby.stream.error.logSeverityLevel=0

2006-07-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1272?page=all ] Kathey Marsden updated DERBY-1272: -- Derby Info: (was: [Patch Available]) Unchecking patch available as more investigation is needed for the security manager issue with sysinfo printing to

[jira] Created: (DERBY-1561) Analyze the existing JDBC JUnit test classes for common methods that should be utilites rather than specific to a test.

2006-07-21 Thread Daniel John Debrunner (JIRA)
Analyze the existing JDBC JUnit test classes for common methods that should be utilites rather than specific to a test. --- Key: DERBY-1561 URL:

[jira] Updated: (DERBY-1561) Analyze the existing JDBC JUnit test classes for common methods that should be utilites rather than specific to a test.

2006-07-21 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1561?page=all ] Daniel John Debrunner updated DERBY-1561: - Component/s: Test Analyze the existing JDBC JUnit test classes for common methods that should be utilites rather than specific to a test.

[jira] Created: (DERBY-1562) Have BaseJDBCTestCase have a Connection field to cover the common case where one connection is used.

2006-07-21 Thread Daniel John Debrunner (JIRA)
Have BaseJDBCTestCase have a Connection field to cover the common case where one connection is used. Key: DERBY-1562 URL:

[jira] Updated: (DERBY-1447) add command line history to ij

2006-07-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1447?page=all ] Kathey Marsden updated DERBY-1447: -- Derby Info: (was: [Patch Available]) I'll uncheck patch available based on John's review. I think instructions on how to do this would be a great

[jira] Commented: (DERBY-1194) Derby Server and Administration Guide - Managing the Derby Network Server

2006-07-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1194?page=comments#action_12422658 ] Kathey Marsden commented on DERBY-1194: --- Halley, are you actively working on this issue? Do you still need more reviews of the patch after John's review?

[jira] Updated: (DERBY-482) GENERATED BY DEFAULT option should be documented in Derby Tools and Utilities guide under Importing into tables with identity columns section.

2006-07-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-482?page=all ] Kathey Marsden updated DERBY-482: - Derby Info: (was: [Patch Available]) Unchecking Patch Available after Mamta's comments. Jeff has unassigned himself from this issue so probably it is

[jira] Commented: (DERBY-402) INTERSECT/EXCEPT/UNION operators don't agree with documented behavior.

2006-07-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-402?page=comments#action_12422663 ] Kathey Marsden commented on DERBY-402: -- This patch posted in February, looks like it is ready for review but is currently unassigned. Jeff submitted a patch

[jira] Created: (DERBY-1563) derbynet/ShutDownDBWhenNSShutsDownTest.junit fails on Solaris sparc

2006-07-21 Thread Fernanda Pizzorno (JIRA)
derbynet/ShutDownDBWhenNSShutsDownTest.junit fails on Solaris sparc --- Key: DERBY-1563 URL: http://issues.apache.org/jira/browse/DERBY-1563 Project: Derby Issue Type: Test

Re: [jira] Commented: (DERBY-1438) Text written by SQLException.toString differs between client and embedded driver

2006-07-21 Thread Knut Anders Hatlen
David Van Couvering [EMAIL PROTECTED] writes: Hi, Knut. Yes, it's true, this works, but I thought the whole point of rewriting the client so that client.am.SqlException doesn't extend java.sql.SQLException was so that we could directly use and throw the java.sql exceptions rather than our

[jira] Created: (DERBY-1564) wisconsin.sql test failed in DerbyNet framework, VM for network server got OutOfMemoryError

2006-07-21 Thread Andreas Korneliussen (JIRA)
wisconsin.sql test failed in DerbyNet framework, VM for network server got OutOfMemoryError --- Key: DERBY-1564 URL: http://issues.apache.org/jira/browse/DERBY-1564

[jira] Updated: (DERBY-1564) wisconsin.sql test failed in DerbyNet framework, VM for network server got OutOfMemoryError

2006-07-21 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1564?page=all ] Andreas Korneliussen updated DERBY-1564: Attachment: wisconsin.tar.gz Attaching log from test (wisconsin.tar.gz) wisconsin.sql test failed in DerbyNet framework, VM for network

[jira] Commented: (DERBY-1564) wisconsin.sql test failed in DerbyNet framework, VM for network server got OutOfMemoryError

2006-07-21 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1564?page=comments#action_12422684 ] Andreas Korneliussen commented on DERBY-1564: - Do note that that there was not output in the outfile, and the diff file is therefore the entire master

[jira] Commented: (DERBY-815) Prevent unneeded object creation and excessive decoding in parseSQLDTA_work()

2006-07-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-815?page=comments#action_12422686 ] Kathey Marsden commented on DERBY-815: -- Should we uncheck patch available on this issue since it needs to be updated to apply? Prevent unneeded object

Patch List update

2006-07-21 Thread Kathey Marsden
I did a little PatchListMaintenance this morning and we currently have dropped down below the 20 patch mark. To help keep the patch list a small fast moving list, please check your patches are ready for review and up to date [1]. You can also look at the full patch list [2] for issues you

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

2006-07-21 Thread David Van Couvering
That's quite a title for a Wiki page :) 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 DanDebrunner: http://wiki.apache.org/db-derby/KillDerbyTestHarness New page: =

Re: [jira] Commented: (DERBY-1438) Text written by SQLException.toString differs between client and embedded driver

2006-07-21 Thread David Van Couvering
Thanks, Knut. I was unaware that part of the intention was to reduce the number of master files. My patch simply updates existing master files with new output. Are you saying that master files that are currently in DerbyNetClient could be removed because the master files in the top-level

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

2006-07-21 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1521?page=all ] Deepa Remesh updated DERBY-1521: Attachment: d1521-patch1-v1.diff d1521-patch1-v1.status Attaching a patch 'd1521-patch1-v1.diff' which modifies UpgradeTester to test the

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

2006-07-21 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1521?page=all ] Deepa Remesh updated DERBY-1521: Derby Info: [Patch Available] Upgrade test needs to be enhanced to test grant revoke --

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

2006-07-21 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-688?page=all ] A B updated DERBY-688: -- Attachment: d688_phase1_v3.patch Attaching an updated patch synced with the latest codeline. The only difference between _v2 and _v3 is that the client master file for

Re: [jira] Commented: (DERBY-528) Support for DRDA Strong User ID and Password Substitute Authentication (USRSSBPWD) scheme

2006-07-21 Thread Sunitha Kambhampati
Hi Francois, Thanks for the great explanation for the patch. I'll review it in detail and hope to post comments in a day or two. Thanks, Sunitha.

Re: JUnit testing moving forward

2006-07-21 Thread Myrna van Lunteren
On 7/20/06, Daniel John Debrunner [EMAIL PROTECTED] wrote: Manish Khettry wrote: And on the issue of using ant-- why not have ant targets in java/testing to run standard suites? much easier to get a developer to type ant derbyall and have it do the needful (setup classpath, invoke the

[jira] Updated: (DERBY-1373) Encrypted databases cannot be booted using the jar subprotocol (and possibly also using http/https/classpath)

2006-07-21 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1373?page=all ] Sunitha Kambhampati updated DERBY-1373: --- Attachment: 10.1_derby1373.diff.txt I would like this fix to go into 10.1 branch. The below merge command to put this fix to 10.1 does not

[jira] Resolved: (DERBY-1357) Short-circuit logic in optimizer appears to be incorrect...

2006-07-21 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1357?page=all ] A B resolved DERBY-1357. Resolution: Fixed Derby Info: [Release Note Needed] (was: [Patch Available, Release Note Needed]) Resolving issue as the patch was committed by Satheesh with svn

[jira] Resolved: (DERBY-781) Materialize union subqueries in select list where possible to avoid creating invariant resultsets many times.

2006-07-21 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-781?page=all ] A B resolved DERBY-781. --- Resolution: Fixed Derby Info: [Existing Application Impact, Release Note Needed] (was: [Existing Application Impact, Patch Available, Release Note Needed]) Resolving issue

[jira] Created: (DERBY-1565) Adjust documentation to comply with latest Apache copyright/license requirements

2006-07-21 Thread David Van Couvering (JIRA)
Adjust documentation to comply with latest Apache copyright/license requirements Key: DERBY-1565 URL: http://issues.apache.org/jira/browse/DERBY-1565 Project: Derby

Re: JUnit testing moving forward

2006-07-21 Thread Daniel John Debrunner
Myrna van Lunteren wrote: And I think the name for the Wiki (killDerbyTestHarness) is just perfect. :-) It's just my way to change the mindset of everyone. It may not be a surprise, but I'm very interested in this. :-) Excellent! Re 3, I think we should start with converting tests where the

Re: [jira] Updated: (DERBY-1373) Encrypted databases cannot be booted using the jar subprotocol (and possibly also using http/https/classpath)

2006-07-21 Thread Deepa Remesh
On 7/21/06, Sunitha Kambhampati (JIRA) derby-dev@db.apache.org wrote: So, I am attaching a patch 10.1_derby1373.diff.txt for 10.1 codeline. Please note, it is the same changes as derby1373.diff.txt. svn stat: M java\engine\org\apache\derby\impl\services\jce\JCECipherFactory.java M

Re: [jira] Commented: (DERBY-528) Support for DRDA Strong User ID and Password Substitute Authentication (USRSSBPWD) scheme

2006-07-21 Thread Francois Orsini
Thank you Guys for all the help with this. Knut, thank you for pointing to DERBY-1545.On 7/21/06, Sunitha Kambhampati [EMAIL PROTECTED] wrote: Hi Francois,Thanks for the great explanation for the patch.I'll review it in detail and hope to post comments in a day or two. Thanks,Sunitha.

svn merge does not add the new files, the stat will show A + which is just the property change for newfiles. ( was Re: [jira] Updated: (DERBY-1373) Encrypted databases cannot be booted using the jar

2006-07-21 Thread Sunitha Kambhampati
Deepa Remesh wrote: I just took a look at this patch when I saw A + mentioned in the svn status. When merging and creating a new patch for a branch, I have seen that A + in svn status indicates only property change for new files. The contents of the new files are not added to the patch

[jira] Commented: (DERBY-1377) Update copyright headers to comply with new ASF policy

2006-07-21 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1377?page=comments#action_12422723 ] David Van Couvering commented on DERBY-1377: From the FAQ at http://www.apache.org/legal/src-headers.html With few exceptions, all human-readable

remaining 10.2 blocker

2006-07-21 Thread Rick Hillegas
Thanks to David for taking DERBY-1377. That leaves one last unassigned blocker: DERBY-936. DERBY-936 is a Documentation issue. Recently, there was some discussion about how to identify outstanding 10.2 documentation issues. This one is definitely at the top of the list. Regards, -Rick

[jira] Commented: (DERBY-1377) Update copyright headers to comply with new ASF policy

2006-07-21 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1377?page=comments#action_12422725 ] David Van Couvering commented on DERBY-1377: The COPYRIGHT file in our root directory contains copyrights for IBM. Does anyone know if this needs to

[jira] Commented: (DERBY-1565) Adjust documentation to comply with latest Apache copyright/license requirements

2006-07-21 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1565?page=comments#action_12422726 ] Jean T. Anderson commented on DERBY-1565: - I think two changes are needed: 1) Update the DITA source files to include the ASF header in comments 2) Update

Re: [jira] Created: (DERBY-1555) API for configuration information in Derby's JUnit tests should through instance methods of the base classes, not static methods and static fields

2006-07-21 Thread Myrna van Lunteren
On 7/20/06, Daniel John Debrunner (JIRA) derby-dev@db.apache.org wrote: API for configuration information in Derby's JUnit tests should through instance methods of the base classes, not static methods and static fields

[jira] Commented: (DERBY-1377) Update copyright headers to comply with new ASF policy

2006-07-21 Thread Jean T. Anderson (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1377?page=comments#action_12422727 ] Jean T. Anderson commented on DERBY-1377: - I think the IBM copyright belongs in the NOTICE file -- http://www.apache.org/legal/src-headers.html#notice

[jira] Updated: (DERBY-1373) Encrypted databases cannot be booted using the jar subprotocol (and possibly also using http/https/classpath)

2006-07-21 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1373?page=all ] Sunitha Kambhampati updated DERBY-1373: --- Attachment: 10.1_explicitsvnadd_derby1373.diff.txt In the earlier patch 10.1_derby1373.diff.txt' the new files didnt get added to the patch

[jira] Commented: (DERBY-1539) As per the functional spec attached to DERBY-1330, a trigger should be dropped when a privilege required by the trigger is revoked.

2006-07-21 Thread Mamta A. Satoor (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1539?page=comments#action_12422730 ] Mamta A. Satoor commented on DERBY-1539: I want to start out by saying that this is my first time ever working with hashCode so I am new to this part of

[jira] Updated: (DERBY-1271) Release documentation for JDBC4 release

2006-07-21 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1271?page=all ] Rick Hillegas updated DERBY-1271: - Attachment: derby-1271_devGuide_v01.diff devGuide_v01.tar Attaching patch derby-1271_devGuide_v01.diff and tar of corresponding html and

Re: [jira] Created: (DERBY-1548) Document builtin functions - ACOS, ASIN, ATAN, COS, SIN, TAN, PI, DEGREES, RADIANS, EXP, LN, LOG, LOG10, CEIL, CEILING, FLOOR

2006-07-21 Thread Laura Stewart
Also, should these be added to the list in the SQL reserved words section in the Reference Manual? On 7/20/06, Laura Stewart [EMAIL PROTECTED] wrote: The JIRA issue that added these functions (DERBY-475) does not list any information that describes the functions. What do you recommend as a

[jira] Commented: (DERBY-1517) Derby Network Client to handle list of SECMEC(s) returned by existing/released DRDA Derby Network Servers

2006-07-21 Thread Francois Orsini (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1517?page=comments#action_12422733 ] Francois Orsini commented on DERBY-1517: I know you figured it out already Kathey - am just adding a comment here for the record. You're right that there

[jira] Assigned: (DERBY-1517) Derby Network Client to handle list of SECMEC(s) returned by existing/released DRDA Derby Network Servers

2006-07-21 Thread Francois Orsini (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1517?page=all ] Francois Orsini reassigned DERBY-1517: -- Assignee: Francois Orsini Derby Network Client to handle list of SECMEC(s) returned by existing/released DRDA Derby Network Servers

Re: [jira] Created: (DERBY-1520) Document new SYSCS_DIAG tables

2006-07-21 Thread Stanley Bradbury
Laura Stewart wrote: Which derby docs need this change? Developers Guide? Reference Guide? On 7/17/06, *Stan Bradbury (JIRA)* derby-dev@db.apache.org mailto:derby-dev@db.apache.org wrote: Document new SYSCS_DIAG tables --- Key:

Re: Issue with using dependency manager for table level permission tracking

2006-07-21 Thread Mamta Satoor
Hi, After working on much of the ground work for revoke, I have finally come to implement the revoke privilege such that only the objects that depend on the specific permission type being revoked should drop themselves. I thought I could do that by having dependency manager sendspecific action

[jira] Updated: (DERBY-1271) Release documentation for JDBC4 release

2006-07-21 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1271?page=all ] Rick Hillegas updated DERBY-1271: - Attachment: derby-1271_toolsGuide_v01.diff toolsGuide_v01.tar Attaching patch derby-1271_toolsGuide_v01.diff and the correponding html and

[jira] Closed: (DERBY-1029) Backout boolean work from the 10.2 branch immediately after the branch is created

2006-07-21 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1029?page=all ] Rick Hillegas closed DERBY-1029. Resolution: Fixed Backout boolean work from the 10.2 branch immediately after the branch is created

[jira] Commented: (DERBY-147) ERROR 42X79 not consistant ? - same column name specified twice

2006-07-21 Thread Bernd Ruehlicke (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-147?page=comments#action_12422745 ] Bernd Ruehlicke commented on DERBY-147: --- Simple question: Is most of the source checked in from Linux /Unix ? It seems to me when I checout the code it gets

[jira] Assigned: (DERBY-887) Select statement returns wrong number of rows if you compare an integer column with a boolean expression in the where clause

2006-07-21 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-887?page=all ] Rick Hillegas reassigned DERBY-887: --- Assignee: (was: Rick Hillegas) Unassigning myself from this issue. We have moved out the timeframe for fixing this bug. Select statement returns

[jira] Updated: (DERBY-887) Select statement returns wrong number of rows if you compare an integer column with a boolean expression in the where clause

2006-07-21 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-887?page=all ] Rick Hillegas updated DERBY-887: Fix Version/s: (was: 10.3.0.0) Detaching this issue from 10.3. Fixing it seems to require changing the non-ANSI behavior of implicit and explicit casts.

Re: [jira] Created: (DERBY-1555) API for configuration information in Derby's JUnit tests should through instance methods of the base classes, not static methods and static fields

2006-07-21 Thread Daniel John Debrunner
Myrna van Lunteren wrote: On 7/20/06, Daniel John Debrunner (JIRA) derby-dev@db.apache.org wrote: API for configuration information in Derby's JUnit tests should through instance methods of the base classes, not static methods and static fields Hi Dan, I dimly grasp what you mean, but

[jira] Commented: (DERBY-147) ERROR 42X79 not consistant ? - same column name specified twice

2006-07-21 Thread Satheesh Bandaram (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-147?page=comments#action_12422749 ] Satheesh Bandaram commented on DERBY-147: - Last time this patch was reviewed, there was also another concern about truely ambigious columns, like: Select

[jira] Assigned: (DERBY-499) Expose BOOLEAN datatype to end users

2006-07-21 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-499?page=all ] Rick Hillegas reassigned DERBY-499: --- Assignee: (was: Rick Hillegas) Unassigning myself from this issue. If someone wants to tackle this in the future, please consult DERBY-1029. In order

Re: [jira] Created: (DERBY-1548) Document builtin functions - ACOS, ASIN, ATAN, COS, SIN, TAN, PI, DEGREES, RADIANS, EXP, LN, LOG, LOG10, CEIL, CEILING, FLOOR

2006-07-21 Thread Daniel John Debrunner
Laura Stewart wrote: Also, should these be added to the list in the SQL reserved words section in the Reference Manual? No. Dan.

[jira] Closed: (DERBY-1459) Early load of Derby driver with JDBC 4.0 autoloading can lead to derby properties not being processed or derby boot time actions consuming resources when a connection is ma

2006-07-21 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1459?page=all ] Rick Hillegas closed DERBY-1459. Resolution: Fixed Early load of Derby driver with JDBC 4.0 autoloading can lead to derby properties not being processed or derby boot time actions consuming

[jira] Closed: (DERBY-930) Add support for autoloading of Derby client drivers

2006-07-21 Thread Rick Hillegas (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-930?page=all ] Rick Hillegas closed DERBY-930. --- Resolution: Fixed Derby Info: [Existing Application Impact, Release Note Needed] (was: [Release Note Needed, Existing Application Impact]) Closing this

[jira] Commented: (DERBY-781) Materialize union subqueries in select list where possible to avoid creating invariant resultsets many times.

2006-07-21 Thread Satheesh Bandaram (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-781?page=comments#action_12422753 ] Satheesh Bandaram commented on DERBY-781: - I think it would be good to modify this improvement description, as it will likely be picked up by release notes

Reference Guide: documenting current SQLStates

2006-07-21 Thread Rick Hillegas
The following section of the Reference Guide documents our known SQLStates: Reference Guide-Derby exception messages and SQL states-SQLState and error message reference Do we update this section with each feature release? If so, is there some machinery to automate the drudgery? Thanks,

Re: [jira] Updated: (DERBY-887) Select statement returns wrong number of rows if you compare an integer column with a boolean expression in the where clause

2006-07-21 Thread Andrew McIntyre
On 7/21/06, Rick Hillegas (JIRA) derby-dev@db.apache.org wrote: Detaching this issue from 10.3. Fixing it seems to require changing the non-ANSI behavior of implicit and explicit casts. Changing this behavior probably will affect existing applications and it seems to be the sort of fix which we

Regression Test Failure! - TinderBox_Derby 424368 - Sun DBTG

2006-07-21 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 424368/2006-07-21 18:02:27 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 1679678 2 173.45% SunOS-5.10_i86pc-i386 Details in

Re: Reference Guide: documenting current SQLStates

2006-07-21 Thread Andrew McIntyre
On 7/21/06, Rick Hillegas [EMAIL PROTECTED] wrote: The following section of the Reference Guide documents our known SQLStates: Reference Guide-Derby exception messages and SQL states-SQLState and error message reference Do we update this section with each feature release? If so, is there some

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

2006-07-21 Thread Rick Hillegas (JIRA)
Document SQLStates in 10.2 -- Key: DERBY-1566 URL: http://issues.apache.org/jira/browse/DERBY-1566 Project: Derby Issue Type: Improvement Components: Documentation Affects Versions: 10.2.0.0

Re: Reference Guide: documenting current SQLStates

2006-07-21 Thread Rick Hillegas
Thanks, Andrew. I have create DERBY-1566 to track this issue. Cheers, -Rick Andrew McIntyre wrote: On 7/21/06, Rick Hillegas [EMAIL PROTECTED] wrote: The following section of the Reference Guide documents our known SQLStates: Reference Guide-Derby exception messages and SQL

[jira] Commented: (DERBY-1377) Update copyright headers to comply with new ASF policy

2006-07-21 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1377?page=comments#action_12422760 ] Andrew McIntyre commented on DERBY-1377: Not to complicate things, but there was a big round-about with this in the early days of Derby. The 'resolution'

[jira] Commented: (DERBY-147) ERROR 42X79 not consistant ? - same column name specified twice

2006-07-21 Thread Bernd Ruehlicke (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-147?page=comments#action_12422761 ] Bernd Ruehlicke commented on DERBY-147: --- OK got it perfectly working now. I also refactored the getOrderByColumn(String, TableName) to call the

Re: [jira] Updated: (DERBY-887) Select statement returns wrong number of rows if you compare an integer column with a boolean expression in the where clause

2006-07-21 Thread Daniel John Debrunner
Andrew McIntyre wrote: On 7/21/06, Rick Hillegas (JIRA) derby-dev@db.apache.org wrote: Detaching this issue from 10.3. Fixing it seems to require changing the non-ANSI behavior of implicit and explicit casts. Changing this behavior probably will affect existing applications and it seems to

[jira] Commented: (DERBY-1377) Update copyright headers to comply with new ASF policy

2006-07-21 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1377?page=comments#action_12422762 ] Daniel John Debrunner commented on DERBY-1377: -- This FAQ in http://www.apache.org/legal/src-headers.html is relevant to Andrew's comment:

[jira] Commented: (DERBY-1377) Update copyright headers to comply with new ASF policy

2006-07-21 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1377?page=comments#action_12422764 ] Andrew McIntyre commented on DERBY-1377: The current headers have ASF copyright notices, e.g.: Copyright 1997, 2004 The Apache Software Foundation or its

[jira] Commented: (DERBY-1227) Network Server should not use the underlying embedded prepared statement when accessing a BrokeredPreparedStatement

2006-07-21 Thread Sunitha Kambhampati (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1227?page=comments#action_12422765 ] Sunitha Kambhampati commented on DERBY-1227: Thanks Mike into looking at this. Here is the checkin comment:

[jira] Commented: (DERBY-781) Materialize union subqueries in select list where possible to avoid creating invariant resultsets many times.

2006-07-21 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-781?page=comments#action_12422768 ] A B commented on DERBY-781: --- Oh wait, check that last comment. That was only for the summary; I see now that you were talking about the actual description. Sorry.

[jira] Commented: (DERBY-781) Materialize union subqueries in select list where possible to avoid creating invariant resultsets many times.

2006-07-21 Thread A B (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-781?page=comments#action_12422767 ] A B commented on DERBY-781: --- I think it would be good to modify this improvement description Seems like this could be a simple as removing the word union from the

[jira] Commented: (DERBY-1377) Update copyright headers to comply with new ASF policy

2006-07-21 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1377?page=comments#action_12422770 ] Daniel John Debrunner commented on DERBY-1377: -- Depends on what the defintion of an ASF copyright notice is. Could be: A) A copyright notice

Re: [jira] Created: (DERBY-1548) Document builtin functions - ACOS, ASIN, ATAN, COS, SIN, TAN, PI, DEGREES, RADIANS, EXP, LN, LOG, LOG10, CEIL, CEILING, FLOOR

2006-07-21 Thread Laura Stewart
I am still looking for a recommended source for the descriptions and syntax... On 7/21/06, Daniel John Debrunner [EMAIL PROTECTED] wrote: Laura Stewart wrote: Also, should these be added to the list in the SQL reserved words section in the Reference Manual?No.Dan.-- Laura Stewart

[jira] Commented: (DERBY-1377) Update copyright headers to comply with new ASF policy

2006-07-21 Thread Andrew McIntyre (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1377?page=comments#action_12422776 ] Andrew McIntyre commented on DERBY-1377: B) A copyright notice statement where the copyright is actually held by the Apache Software Foundation Since the

Re: [jira] Created: (DERBY-1520) Document new SYSCS_DIAG tables

2006-07-21 Thread Laura Stewart
***(LS) The file that you name is the in Ref Manual, not the Server and Administration Guide... I see the section in the Reference Manual that you mean. On 7/21/06, Stanley Bradbury [EMAIL PROTECTED] wrote: Laura Stewart wrote: Which derby docs need this change? Developers Guide? Reference

[jira] Updated: (DERBY-1505) Reference Manual - Limitations of triggered-SQL-statement do not match current behaviour

2006-07-21 Thread Deepa Remesh (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1505?page=all ] Deepa Remesh updated DERBY-1505: Fix Version/s: 10.2.0.0 Reference Manual - Limitations of triggered-SQL-statement do not match current behaviour

[jira] Created: (DERBY-1567) generateClientMessageTest.sh is broken

2006-07-21 Thread Dag H. Wanvik (JIRA)
generateClientMessageTest.sh is broken -- Key: DERBY-1567 URL: http://issues.apache.org/jira/browse/DERBY-1567 Project: Derby Issue Type: Bug Components: Test Affects Versions: 10.2.0.0

Re: [jira] Created: (DERBY-1548) Document builtin functions - ACOS, ASIN, ATAN, COS, SIN, TAN, PI, DEGREES, RADIANS, EXP, LN, LOG, LOG10, CEIL, CEILING, FLOOR

2006-07-21 Thread Daniel John Debrunner
Laura Stewart wrote: I am still looking for a recommended source for the descriptions and syntax... I updated DERBY-1548 yesterday. Dan.

[jira] Updated: (DERBY-1567) generateClientMessageTest.sh is broken

2006-07-21 Thread Dag H. Wanvik (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1567?page=all ] Dag H. Wanvik updated DERBY-1567: - Attachment: TestClientMessages.java uploaded the generated file, svn at 423976. generateClientMessageTest.sh is broken

Re: Issue with using dependency manager for table level permission tracking

2006-07-21 Thread Mamta Satoor
BTW, I think the issue is really with just triggers. Views can only depend on select privileges, since we don't allow DML through views. So,when a ViewDescriptor gets an action anything other than REVOKE_SELECT_PRIVILEGE from dependency manager, it can simply ignore them. And for a

Re: [jira] Commented: (DERBY-147) ERROR 42X79 not consistant ? - same column name specified twice

2006-07-21 Thread Bernd Ruehlicke
Point taken. Give me some time to figure out the basic mechanics (testing, orderby.sql/orderby.out, why svn is chekcing out the files with lits of tabs and spaces ... etc. havn't worked with Derby for a year so need to get back to speed.)- Original Message From: Satheesh Bandaram (JIRA)

[jira] Commented: (DERBY-1537) Boot-time exception when running Derby tests with derbytools.jar in front of derby.jar in the classpath.

2006-07-21 Thread Kathey Marsden (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1537?page=comments#action_12422782 ] Kathey Marsden commented on DERBY-1537: --- RegressionSearchAndDestroy hint: This issue looks like low hanging fruit for anyone wishing to participate in the

Regression Test Failure! - TinderBox_Derby 424430 - Sun DBTG

2006-07-21 Thread Ole . Solberg
[Auto-generated mail] *TinderBox_Derby* 424430/2006-07-21 21:43:00 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.5* 6679673 2 146.57% SunOS-5.10_i86pc-i386 Details in

Re: [jira] Commented: (DERBY-1377) Update copyright headers to comply with new ASF policy

2006-07-21 Thread David Van Couvering
I have to say I don't understand where we stand at this point. If anybody can give me a recipe of what I should be doing I would appreciate it... David Daniel John Debrunner (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-1377?page=comments#action_12422783 ]

Re: Reference Guide: documenting current SQLStates

2006-07-21 Thread David Van Couvering
OK, since you've created this, I'll close DERBY-254, as I was keeping it open because of the documentation task. I'll add a note linking to DERBY-1566. David Rick Hillegas wrote: Thanks, Andrew. I have create DERBY-1566 to track this issue. Cheers, -Rick Andrew McIntyre wrote: On

[jira] Resolved: (DERBY-254) SQLStates for SQLExceptions thrown from the client should not be null and should match embedded where possible

2006-07-21 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-254?page=all ] David Van Couvering resolved DERBY-254. --- Resolution: Fixed Derby Info: (was: [Release Note Needed]) Resolving this issue and removing Release Note Needed as DERBY-1566 is tracking

[jira] Commented: (DERBY-1539) As per the functional spec attached to DERBY-1330, a trigger should be dropped when a privilege required by the trigger is revoked.

2006-07-21 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1539?page=comments#action_12422793 ] Daniel John Debrunner commented on DERBY-1539: -- Thanks Mamta for looking into this - I'm still concerned that the object has the ability to change

[jira] Commented: (DERBY-1539) As per the functional spec attached to DERBY-1330, a trigger should be dropped when a privilege required by the trigger is revoked.

2006-07-21 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1539?page=comments#action_12422796 ] Daniel John Debrunner commented on DERBY-1539: -- Could you explain more what you mean by: Hence, when dependency manager works with

[jira] Assigned: (DERBY-1567) generateClientMessageTest.sh is broken

2006-07-21 Thread David Van Couvering (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1567?page=all ] David Van Couvering reassigned DERBY-1567: -- Assignee: David Van Couvering generateClientMessageTest.sh is broken -- Key:

  1   2   >