[jira] Resolved: (DERBY-1702) j9 canon update needed for SQLException string (outparams, parameterMapping, iepnegativetests_ES)

2006-09-02 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1702?page=all ] Myrna van Lunteren resolved DERBY-1702. --- Resolution: Fixed Derby Info: [Regression] (was: [Patch Available, Regression]) Fixes for this issue went in to trunk with: 439209

[jira] Updated: (DERBY-804) test lang/floattypes fails with jdk 1.3 based jvms

2006-09-02 Thread Myrna van Lunteren (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-804?page=all ] Myrna van Lunteren updated DERBY-804: - Derby Info: (was: [Patch Available]) test lang/floattypes fails with jdk 1.3 based jvms --

Info provided in SQLException ExceptionSeverity.

2006-09-02 Thread Sunitha Kambhampati
I was reviewing the dev guide and in http://db.apache.org/derby/docs/10.2/devguide/cdevconcepts844813.html pg63: Section 'Information provided in SQLExceptions there is Use the /getSQLState/ and /getMessage/ methods to view the /SQLState/ and error messages. Use /getErrorCode/ to see the error

Dev guide: sections - upgrades to controlling derby application behavior.

2006-09-02 Thread Sunitha Kambhampati
I reviewed some sections from the developer guide and I am posting my comments here: Note: the page number is the pdf page number that is printed on the page. I'll update the wiki with the link to this mail, after it hits the archives. (1)Section 'Preparing to Upgrade' , pg 7: We talk about

[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-09-02 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12432276 ] Yip Ng commented on DERBY-1686: --- My apology. I will clean up the comments and use consistent terminology in the next patch. I wrote the patch summary really fast

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

2006-09-02 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1784?page=all ] Yip Ng updated DERBY-1784: -- Attachment: derby1784-trunk-stat01.txt derby1784-trunk-diff01.txt Attaching patch for DERBY-1784 for trunk. derbyall passes. The patch fixes the problem

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

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

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

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

Derby 10.2 Reference Manual and section Prepared statements and streaming columns

2006-09-02 Thread Mamta Satoor
Hi, I have been reviewing Derby 10.2 Reference Manual and putting my feedback at http://wiki.apache.org/db-derby/ReferenceManualTenTwo. I came across section Prepared statements and streaming columns and have to admit that I haven't kept up with any streaming column related changes in Derby 10.2

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

2006-09-02 Thread Mike Matrigali (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1784?page=all ] Mike Matrigali updated DERBY-1784: -- I took a quick look at this patch. Looks like it fixes the problem. I have not looked at bind code before, so just looking for info. I was sort of

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

2006-09-02 Thread jira
Issue Subscription Filter: Derby: JIRA issues with patch available (21 issues) Subscriber: derby-dev Key Summary DERBY-1784 When qualifying a column name with its synonym name in the select list, Derby throws SQLSTATE 42X04. http://issues.apache.org/jira/browse/DERBY-1784

[jira] Created: (DERBY-1808) [PATCH] Inbuilt functions SIGN, SQRT, RAND, RANDOM, COSH, SINH and TANH

2006-09-02 Thread Richard Wheeldon (JIRA)
[PATCH] Inbuilt functions SIGN, SQRT, RAND, RANDOM, COSH, SINH and TANH --- Key: DERBY-1808 URL: http://issues.apache.org/jira/browse/DERBY-1808 Project: Derby Issue Type:

[jira] Resolved: (DERBY-1724) Executing grant statement within a transaction leads to a NPE later when the db owner attempts to update a table

2006-09-02 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1724?page=all ] Bryan Pendleton resolved DERBY-1724. Fix Version/s: 10.3.0.0 (was: 10.2.1.0) Resolution: Duplicate Assignee: Bryan Pendleton I believe that this bug

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

2006-09-02 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1583?page=comments#action_12432292 ] Bryan Pendleton commented on DERBY-1583: I've tried to expand upon the rough notes above in the wiki, at http://wiki.apache.org/db-derby/DataDictionary

Re: ALTER TABLE NULL-NOT NULL not merged WAS Re: 10.2 status

2006-09-02 Thread Bryan Pendleton
In the open source world however, by releasing the code and allowing others to use it, the more eyes syndrome means that the testing by chance becomes the significant factor, thus the quality increases by releasing it. I completely agree. Release early, release often, get real feedback from

[jira] Commented: (DERBY-1808) [PATCH] Inbuilt functions SIGN, SQRT, RAND, RANDOM, COSH, SINH and TANH

2006-09-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1808?page=comments#action_12432293 ] Daniel John Debrunner commented on DERBY-1808: -- Thanks Richard, I'll review the patch, but as a quick note Derby already supports SQRTand ABS (also

[jira] Commented: (DERBY-1802) JUnit tests for DERBY-475 and DERBY-592, Built-in and JDBC escape functions

2006-09-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1802?page=comments#action_12432294 ] Daniel John Debrunner commented on DERBY-1802: -- Thanks for the comprehensive test Susan (much better than the minimal testing I submitted with the

Bugs in inbuilt functions (was Re: [jira] Commented: (DERBY-1808) [PATCH] Inbuilt functions SIGN, SQRT, RAND, RANDOM, COSH, SINH and TANH)

2006-09-02 Thread richard
Daniel John Debrunner (JIRA) writes: Thanks Richard, I'll review the patch, but as a quick note Derby already supports SQRTand ABS (also added in your patch). I think all the others are new to Derby. Yes, these are implemented in a different section to the others which is why I didn't

Re: 10.2.1.2 beta now available

2006-09-02 Thread Rajesh Kartha
Rick Hillegas wrote: I have posted the latest Derby beta, 10.2.1.2, at http://people.apache.org/~rhillegas/10.2.1.1-beta/. You can reach the beta from the 10.2 wiki page (http://wiki.apache.org/db-derby/TenTwoRelease) and from the 10.2 snapshot description

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

2006-09-02 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1784?page=comments#action_12432297 ] Yip Ng commented on DERBY-1784: --- Yes, the resolution code may be move up to its caller ColumnReference's bindExpression() instead. This method will eventually

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

2006-09-02 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1784?page=all ] Yip Ng updated DERBY-1784: -- Attachment: derby1784-trunk-stat02.txt derby1784-trunk-diff02.txt Submitting derby1784-trunk-diff02.txt, moved the resolution logic for column references

[jira] Commented: (DERBY-889) with client getTimestamp on a TIME column will print the date 1900-01-01 instead of the current date

2006-09-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-889?page=comments#action_12432299 ] Daniel John Debrunner commented on DERBY-889: - I will look at this patch since I think I might need it before I can write a test for changes in

Re: Bugs in inbuilt functions (was Re: [jira] Commented: (DERBY-1808) [PATCH] Inbuilt functions SIGN, SQRT, RAND, RANDOM, COSH, SINH and TANH)

2006-09-02 Thread Daniel John Debrunner
[EMAIL PROTECTED] wrote: Daniel John Debrunner (JIRA) writes: Thanks Richard, I'll review the patch, but as a quick note Derby already supports SQRTand ABS (also added in your patch). I think all the others are new to Derby. Yes, these are implemented in a different section to the

[jira] Created: (DERBY-1809) Built-in functions not working in views.

2006-09-02 Thread Richard Wheeldon (JIRA)
Built-in functions not working in views. Key: DERBY-1809 URL: http://issues.apache.org/jira/browse/DERBY-1809 Project: Derby Issue Type: Bug Components: SQL Affects Versions: 10.3.0.0

Re: [jira] Commented: (DERBY-1387) Add JMX extensions to Derby

2006-09-02 Thread Sanket Sharma
Hi, You need to have the following to build it successfully: 1. You need to have jdk1.6 or jdk1.5 2. You need to download JMX RI 1.2.1 and set your classpath accordingly Please not that you need to have the JMX RI even if you are using JDK 1.6 . You may download the JMX RI from

Re: Broken link on the web site papers page?

2006-09-02 Thread Jean T. Anderson
Bryan Pendleton wrote: Hi All, On the Resources page of the web site, http://db.apache.org/derby/integrate/index.html, in the Papers section, in the Derby Engine subsection, there is a link entitled Type System. The Type System link is a link to:

substring/concat/curdate/curtime

2006-09-02 Thread richard
Are these supposed to work? They're declared in the grammar, appear to have useful code associated with them, but none of them seem to do anything: ij select substring('s',2) from simple_tab; ERROR 42X01: Syntax error: Encountered substring at line 1, column 8. ij select substring('s',1,2) from

Re: substring/concat/curdate/curtime

2006-09-02 Thread Daniel John Debrunner
[EMAIL PROTECTED] wrote: Are these supposed to work? They're declared in the grammar, appear to have useful code associated with them, but none of them seem to do anything: The grammer is not the definition of the functionality, the documentation is: All of these are the names for JDBC

[jira] Commented: (DERBY-889) with client getTimestamp on a TIME column will print the date 1900-01-01 instead of the current date

2006-09-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-889?page=comments#action_12432311 ] Daniel John Debrunner commented on DERBY-889: - Regardless of any Derby implementation details, it's not clear that we have agreement on the expected

[jira] Commented: (DERBY-889) with client getTimestamp on a TIME column will print the date 1900-01-01 instead of the current date

2006-09-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-889?page=comments#action_12432312 ] Daniel John Debrunner commented on DERBY-889: - I think this is in-line with the current documented handling of the DATE-java.sql.Date,

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

2006-09-02 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1583?page=all ] Bryan Pendleton resolved DERBY-1583. Fix Version/s: 10.2.2.0 (was: 10.2.1.0) Resolution: Fixed Derby Info: (was: [Patch Available]) Merged the fix to

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

2006-09-02 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1784?page=comments#action_12432314 ] Yip Ng commented on DERBY-1784: --- Just noticed that my previous comments got cut off for some reason. Here is the original comment: Yes, the resolution code may be

[jira] Created: (DERBY-1810) derbynet/testProperties fails when timeout set to low.

2006-09-02 Thread Mike Matrigali (JIRA)
derbynet/testProperties fails when timeout set to low. -- Key: DERBY-1810 URL: http://issues.apache.org/jira/browse/DERBY-1810 Project: Derby Issue Type: Bug Components:

[jira] Created: (DERBY-1811) Embedded ResultSet.getTimestamp on a TIME column returns a java.sql.Timestamp with a date portion that can be incorrect.

2006-09-02 Thread Daniel John Debrunner (JIRA)
Embedded ResultSet.getTimestamp on a TIME column returns a java.sql.Timestamp with a date portion that can be incorrect. Key: DERBY-1811 URL:

[jira] Commented: (DERBY-889) with client getTimestamp on a TIME column will print the date 1900-01-01 instead of the current date

2006-09-02 Thread Daniel John Debrunner (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-889?page=comments#action_12432323 ] Daniel John Debrunner commented on DERBY-889: - I entered DERBY-1811 for the problem with the embedded driver, the code in the patch is incorrect for