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

2006-09-04 Thread Knut Anders Hatlen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1610?page=comments#action_12432568 ] Knut Anders Hatlen commented on DERBY-1610: --- LANG_DATA_TYPE_GET_MISMATCH is not the only exception with SQLState 22005. From SQLState.java: Stri

[jira] Updated: (DERBY-1489) Provide ALTER TABLE DROP COLUMN functionality

2006-09-04 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1489?page=all ] Bryan Pendleton updated DERBY-1489: --- Attachment: dropColumn_v4_grant_tests.diff Attached is drop_column_v4_grant_tests.diff. This patch proposal is updated to the latest trunk, to resolve som

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

2006-09-04 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1784?page=comments#action_12432553 ] Yip Ng commented on DERBY-1784: --- derbyall passes with patch derby1784-trunk-diff02.txt. > When qualifying a column name with its synonym name in the select list, Der

Re: [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-04 Thread Daniel John Debrunner
Bernt M. Johnsen wrote: > BTW: What about client and server in different timezones? See http://db.apache.org/derby/papers/JDBCImplementation.html#Date+Handling When it talks about timezone of the virtual machine it means virtual machine of the client. Dan.

Re: Options for syncing of log to disk

2006-09-04 Thread Suresh Thalamati
Knut Anders Hatlen wrote: Mike Matrigali <[EMAIL PROTECTED]> writes: I actually don't even know if we have ever run a set of tests on freebsd. I wonder if anyone in the comunity has tried out the 10.2 beta on feebsd? Just the results of a nightly test run would be interesting. I frequently

[jira] Commented: (DERBY-1729) Invoking Java stored procedure that contains GRANT or REVOKE statement with CONTAINS SQL from a trigger should fail.

2006-09-04 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1729?page=comments#action_12432552 ] Yip Ng commented on DERBY-1729: --- derbyall passes. > Invoking Java stored procedure that contains GRANT or REVOKE statement with > CONTAINS SQL from a trigger shoul

Re: 10.2 status

2006-09-04 Thread Bryan Pendleton
Rick Hillegas wrote: This time around, the following patches were not merged. r437215 | bpendleton | 2006-08-26 12:42:02 -0700 (Sat, 26 Aug 2006) | 18 lines DERBY-119: Add ALTER TABLE option to change column from NULL to NOT NULL r438942 | mikem | 2006-08-31 07:39:55 -0700 (Thu, 31 Aug 2006)

[jira] Commented: (DERBY-119) Add ALTER TABLE option to change column from NULL to NOT NULL

2006-09-04 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-119?page=comments#action_12432551 ] Bryan Pendleton commented on DERBY-119: --- Changes merged to the 10.2 branch. Merge was clean, derbyall was troublefree. Committed to subversion as revision 4402

[jira] Commented: (DERBY-80) RFE: System Function for Diagnostic Info

2006-09-04 Thread Christian d'Heureuse (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-80?page=comments#action_12432546 ] Christian d'Heureuse commented on DERBY-80: --- see http://issues.apache.org/jira/browse/DERBY-571 and http://db.apache.org/derby/javadoc/engine/org/apache/de

[jira] Updated: (DERBY-1729) Invoking Java stored procedure that contains GRANT or REVOKE statement with CONTAINS SQL from a trigger should fail.

2006-09-04 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1729?page=all ] Yip Ng updated DERBY-1729: -- Derby Info: [Patch Available] > Invoking Java stored procedure that contains GRANT or REVOKE statement with > CONTAINS SQL from a trigger should fail. > -

[jira] Updated: (DERBY-1729) Invoking Java stored procedure that contains GRANT or REVOKE statement with CONTAINS SQL from a trigger should fail.

2006-09-04 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1729?page=all ] Yip Ng updated DERBY-1729: -- Attachment: derby1729-trunk-stat01.txt derby1729-trunk-diff01.txt Attaching patch derby1729-trunk-diff01.txt for DERBY-1729. This patch applies what I sta

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

2006-09-04 Thread Tomohito Nakayama (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1610?page=comments#action_12432531 ] Tomohito Nakayama commented on DERBY-1610: -- Now, I'm adding type checking code to org.apache.derby.client.am.PreparedStatement, and found what is questio

Re: Derby and ASF Logo

2006-09-04 Thread Jean T. Anderson
Sanket Sharma wrote: > Hi, > I was wondering if it is "okay" to use Derby and ASF logo on my > personal web/blog, t-shirts, caps etc? > I'm a Google summer of code participant and worked on adding JMX to > derby as part of my project. Hi, Sanket, First ask for permission from the Apache Public Re

[jira] Updated: (DERBY-1491) Provide ALTER TABLE functionality to change a column's default value

2006-09-04 Thread Bryan Pendleton (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1491?page=all ] Bryan Pendleton updated DERBY-1491: --- Attachment: alterDefaultTests.diff Proposed patch "alterDefaultTests.diff" is attached. This patch proposal supercedes the previous attachments. Note th

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

2006-09-04 Thread jira
Issue Subscription Filter: Derby: JIRA issues with patch available (19 issues) Subscriber: derby-dev Key Summary DERBY-1798 Document Update: Tools Guide - Added derbyrun.jar information and clarified / corrected info on IJ and database loading classes http://issues.apache.or

Derby and ASF Logo

2006-09-04 Thread Sanket Sharma
Hi, I was wondering if it is "okay" to use Derby and ASF logo on my personal web/blog, t-shirts, caps etc? I'm a Google summer of code participant and worked on adding JMX to derby as part of my project. Best Regards, Sanket Sharma

[jira] Updated: (DERBY-1713) Memory do not return to the system after Shuting down derby 10.2.1.0, following an out of memory event

2006-09-04 Thread John H. Embretsen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1713?page=all ] John H. Embretsen updated DERBY-1713: - Component/s: SQL Urgency: Normal (was: Urgent) Priority: Major (was: Critical) This issue is seen when executing certain kinds of que

Re: [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-04 Thread Bernt M. Johnsen
BTW: What about client and server in different timezones? Bernt M. Johnsen wrote: > Bryan Pendleton (JIRA) wrote: >> [ >> http://issues.apache.org/jira/browse/DERBY-889?page=comments#action_12432344 >> ] >> >> Bryan Pendleton commented on DERBY-889: >> ---

Re: [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-04 Thread Bernt M. Johnsen
Bryan Pendleton (JIRA) wrote: > [ > http://issues.apache.org/jira/browse/DERBY-889?page=comments#action_12432344 ] > > Bryan Pendleton commented on DERBY-889: > --- > > Hi Dan, thanks for the feedback and pointers. > > Yes, behavior (C): the current date at

Re: Reference Manual: Built-in Functions, null arguments and time duration

2006-09-04 Thread Bernt M. Johnsen
FYI The SQL standard says that null argument should give null result. See also http://issues.apache.org/jira/browse/DERBY-729 Susan Cline wrote: > I'm reviewing some of the Built-in functions in the reference manual and have > found these > things which I believe are incorrect: > > 1) SECOND fu

[jira] Resolved: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

2006-09-04 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1800?page=all ] Andreas Korneliussen resolved DERBY-1800. - Fix Version/s: 10.3.0.0 Resolution: Fixed Committed revision 440062. > testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpec

[jira] Updated: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

2006-09-04 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1800?page=all ] Andreas Korneliussen updated DERBY-1800: Component/s: Network Server > testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. > expected:<22001> but was:<58009>'

[jira] Commented: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

2006-09-04 Thread Andreas Korneliussen (JIRA)
: Sun Microsystems Inc. Java home: /usr/local/java/jdk1.6.0_b98/jre Java classpath: /export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derby.jar:/export/home/tmp/ak136785/derbyall-20060904-1131-438476-438489M/jars/derbyLocale_de_DE.jar:/export/home/tmp/ak136785/derbyall

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

2006-09-04 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1696?page=all ] Andreas Korneliussen updated DERBY-1696: Derby Info: (was: [Patch Available]) Removing patch available flag, since the second patch makes SURQueryMixTest fail. > transaction may som

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

2006-09-04 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1696?page=all ] Andreas Korneliussen updated DERBY-1696: Attachment: DERBY-1696v2.diff The attached patch also releases the lock on indexed scans. Additionally extended tests. > transaction may someti

[jira] Closed: (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-09-04 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1559?page=all ] Andreas Korneliussen closed 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 > --

[jira] Resolved: (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-09-04 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1559?page=all ] Andreas Korneliussen resolved DERBY-1559. - Fix Version/s: 10.2.2.0 Resolution: Fixed > when receiving a single EXTDTA object representing a BLOB, the server do not > need to rea

Re: Running a Derby JUnit test using JUnit directly

2006-09-04 Thread Vemund Ostgaard
Daniel John Debrunner wrote: Vemund Ostgaard wrote: For the jobs doing nightly testing on the 10.2 branch we did a short term workaround by copying derbyTesting.jar to its old location, to avoid other changes. So, thats why it hasn't failed in those tests. It's good to report such pr

Regression Test Failure! - Derby 439809 - Sun DBTG

2006-09-04 Thread Ole . Solberg
[Auto-generated mail] *Derby* 439809/2006-09-03 19:46:08 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.6* 3686683 0 141.86% SunOS-5.10_i86pc-i386 Details in http://www.multinet.no/~s

[jira] Updated: (DERBY-1800) testSetBinaryStreamLengthLessOnBlobTooLong fails with 'Unexpected SQL state. expected:<22001> but was:<58009>'

2006-09-04 Thread Andreas Korneliussen (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1800?page=all ] Andreas Korneliussen updated DERBY-1800: Attachment: DERBY-1800.diff The problem is caused by not flushing the blob data after an exception occurs. Attached patch makes the test pass. I

[jira] Assigned: (DERBY-1729) Invoking Java stored procedure that contains GRANT or REVOKE statement with CONTAINS SQL from a trigger should fail.

2006-09-04 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1729?page=all ] Yip Ng reassigned DERBY-1729: - Assignee: Yip Ng > Invoking Java stored procedure that contains GRANT or REVOKE statement with > CONTAINS SQL from a trigger should fail. >

[jira] Commented: (DERBY-1729) Invoking Java stored procedure that contains GRANT or REVOKE statement with CONTAINS SQL from a trigger should fail.

2006-09-04 Thread Yip Ng (JIRA)
[ http://issues.apache.org/jira/browse/DERBY-1729?page=comments#action_12432444 ] Yip Ng commented on DERBY-1729: --- Yes, the GrantNode and RevokeNode should have derived from DDLStatementNode instead of MiscellaneousStatementNode. Subclassing DDLS