[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

[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12430941 ] Yip Ng commented on DERBY-1686: --- Please refer to SQL 2003 standard, section 12.1 grant statement, item 4 and 5 under general rules and section 12.2 grant privilege

[jira] Created: (DERBY-1766) Make test jdbcapi/batachUpdate run in client/server framework

Make test jdbcapi/batachUpdate run in client/server framework - Key: DERBY-1766 URL: http://issues.apache.org/jira/browse/DERBY-1766 Project: Derby Issue Type: Test

Re: [jira] Commented: (DERBY-1292) ClassCastException in ClientDriver when using CLOB columns and batch updates

Bryan Pendleton wrote: Oystein Grovlen - Sun Norway wrote: Oh, I did not notice this. I tried to run batchUpdate with DerbyNetClient, but this still fails. I guess that means that beetle 5561 is still an issue Perhaps this is worthy of a JIRA issue of its own, something along the lines

Regression Test Failure! - Derby 437427 - Sun DBTG

[Auto-generated mail] *Derby* 437427/2006-08-27 19:47:32 CEST *derbyall* Failed TestsOK Skip Duration Platform --- *Jvm: 1.6* NA NA NANA SunOS-5.10_i86pc-i386 Details in

[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

[ http://issues.apache.org/jira/browse/DERBY-1559?page=all ] Andreas Korneliussen updated DERBY-1559: Attachment: DERBY-1559v5.diff Attached patch makes DDMReader handle the DRDAProtocolException, and throws IOException from it, instead of

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

Mike Matrigali wrote: Andreas Korneliussen (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-1696?page=all ] Andreas Korneliussen updated DERBY-1696: Component/s: Store To fix this issue, I need a mechanism to notify the store

[jira] Created: (DERBY-1767) insertRow(), updateRow() and deleteRow() cannot handle table names and column names containing double quotes

insertRow(), updateRow() and deleteRow() cannot handle table names and column names containing double quotes Key: DERBY-1767 URL:

[jira] Created: (DERBY-1768) Remove JDBC 4.0 RowId classes

Remove JDBC 4.0 RowId classes - Key: DERBY-1768 URL: http://issues.apache.org/jira/browse/DERBY-1768 Project: Derby Issue Type: Improvement Affects Versions: 10.2.1.0 Reporter: Knut Anders Hatlen

[jira] Updated: (DERBY-1768) Remove JDBC 4.0 RowId classes

[ http://issues.apache.org/jira/browse/DERBY-1768?page=all ] Knut Anders Hatlen updated DERBY-1768: -- Attachment: rowid.diff rowid.stat Attached a patch which removes org.apache.derby.impl.jdbc.EmbedRowId and

[jira] Updated: (DERBY-1768) Remove JDBC 4.0 RowId classes

[ http://issues.apache.org/jira/browse/DERBY-1768?page=all ] Knut Anders Hatlen updated DERBY-1768: -- Assignee: Knut Anders Hatlen Derby Info: [Patch Available] Remove JDBC 4.0 RowId classes -

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

Can you just close the scan if you don't need it positioned anymore? I'll check if that works The problem is that we need it re-positioned later, i.e if the user moves to the afterLast() position and then scrolls to any other row, we need to lock that row. If the scan has been closed with

[jira] Commented: (DERBY-1533) ArrayIndexOutOfBoundsException in DDMReader, on a specific data size

[ http://issues.apache.org/jira/browse/DERBY-1533?page=comments#action_12430970 ] Wiktor Lisowicz commented on DERBY-1533: OK, works for me. ArrayIndexOutOfBoundsException in DDMReader, on a specific data size

RE: [jira] Resolved: (DERBY-1533) ArrayIndexOutOfBoundsException in DDMReader, on a specific data size

Hi, I would like to close the bug, but I'm afraid I don;t have the privileges, so maybe you could do it yourself? And I have one question: do you plan any official release, with the fix of this bug, in the nearest future? regards, Wiktor -Original Message- From: Bryan Pendleton (JIRA)

Re: are there any publicly available test results for the 10.2 branch?

Thanks, Ole! Ole Solberg wrote: Rick Hillegas wrote: Hi Mike, The good news is that Ole is now running regular regression tests against the head of the 10.2 branch now. However, those results aren't publicly visible yet. I expect them to appear publicly soon. Now available at

[jira] Commented: (DERBY-1767) insertRow(), updateRow() and deleteRow() cannot handle table names and column names containing double quotes

[ http://issues.apache.org/jira/browse/DERBY-1767?page=comments#action_12430972 ] Knut Anders Hatlen commented on DERBY-1767: --- Also, when this error is observed, subsequent calls to Connection.rollback() will fail with:

[jira] Updated: (DERBY-1766) Make test jdbcapi/batchUpdate run in client/server framework

[ http://issues.apache.org/jira/browse/DERBY-1766?page=all ] John H. Embretsen updated DERBY-1766: - Summary: Make test jdbcapi/batchUpdate run in client/server framework (was: Make test jdbcapi/batachUpdate run in client/server framework) Make

[jira] Assigned: (DERBY-1767) insertRow(), updateRow() and deleteRow() cannot handle table names and column names containing double quotes

[ http://issues.apache.org/jira/browse/DERBY-1767?page=all ] Fernanda Pizzorno reassigned DERBY-1767: Assignee: Fernanda Pizzorno insertRow(), updateRow() and deleteRow() cannot handle table names and column names containing double quotes

[jira] Updated: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4

[ http://issues.apache.org/jira/browse/DERBY-1633?page=all ] Mike Matrigali updated DERBY-1633: -- Fix Version/s: 10.1.4.0 10.3.0.0 committed d1633_10_1_merge.patch to the 10.1 branch. m101_142:48svn commit Sending

[jira] Commented: (DERBY-1744) ResultSet.rowInserted(), rowUpdated() and rowDeleted() don't throw exception on read-only result sets

[ http://issues.apache.org/jira/browse/DERBY-1744?page=comments#action_12430986 ] Dag H. Wanvik commented on DERBY-1744: -- I raised this with Lance, and the JDBC Expert Group has now added the support optional wording to rowUpdated and

[jira] Created: (DERBY-1769) Add mention that Derby supports rowUpdated, rowDeleted with a result set concurrency of CONCUR_READ_ONLY

Add mention that Derby supports rowUpdated, rowDeleted with a result set concurrency of CONCUR_READ_ONLY - Key: DERBY-1769 URL:

Re: [jira] Resolved: (DERBY-1533) ArrayIndexOutOfBoundsException in DDMReader, on a specific data size

I would like to close the bug, but I'm afraid I don;t have the privileges, so maybe you could do it yourself? Hi Wiktor, thanks for testing the fix! If you send a message to the derby-dev@db.apache.org mailing list, asking for developer access to JIRA, somebody will grant you the appropriate

[jira] Commented: (DERBY-1740) Change error message to indicate encryptionkey length to be atleast 16 characters instead of 8 characters

[ http://issues.apache.org/jira/browse/DERBY-1740?page=comments#action_12430991 ] Kristian Waagan commented on DERBY-1740: I think my previous comment is incorrect. Can anyone help my out here? It seems the concepts of 'bootPassword'

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

The current interface to reopen a heap scan at the beginning is reopenScan(), I think it is confusing to change positionAtRowLocation(null) to also do this. Does your usage want the table level intent lock released or not? Because previously this code was never triggered by user code the heap

for each row mode db2sql

In order to declare a Derby trigger, you need to include the phrase mode db2sql. I can't find this phrase in the ANSI SQL spec--trigger declaration is described in volume 2, section 11.39. The phrase does turn up in the DB2 reference manual, where it has this explanation: This clause is used

[jira] Commented: (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/DERBY-1583?page=comments#action_12430997 ] Mamta A. Satoor commented on DERBY-1583: Bryan, looking at the stack track, it seems that we are trying to add a column privilege requirement in the

[jira] Resolved: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4

[ http://issues.apache.org/jira/browse/DERBY-1633?page=all ] A B resolved DERBY-1633. Fix Version/s: 10.1.3.2 (was: 10.1.4.0) Resolution: Fixed Derby Info: [Existing Application Impact, Regression] (was: [Patch Available,

[jira] Commented: (DERBY-1681) Regression (wrong results): Join predicate can be ignored for left-most child in a chain of nested unions.

[ http://issues.apache.org/jira/browse/DERBY-1681?page=comments#action_12431007 ] A B commented on DERBY-1681: Thanks for commiting the new test case to trunk and 10.2, Mike. Since the changes for DERBY-1633 have now been ported to 10.1 (thank you

[jira] Updated: (DERBY-1417) Add new, lengthless overloads to the streaming api

[ http://issues.apache.org/jira/browse/DERBY-1417?page=all ] Kristian Waagan updated DERBY-1417: --- Attachment: derby-1417-9a-blobstream-newapproach.diff derby-1417-9a-blobstream-newapproach.stat Knut Anders, Your worries make sense.

[jira] Closed: (DERBY-1744) ResultSet.rowInserted(), rowUpdated() and rowDeleted() don't throw exception on read-only result sets

[ http://issues.apache.org/jira/browse/DERBY-1744?page=all ] Knut Anders Hatlen closed DERBY-1744. - Resolution: Invalid Thanks to Dag and Lance for clearing this up. Closing the issue as invalid. ResultSet.rowInserted(), rowUpdated() and

[jira] Commented: (DERBY-1768) Remove JDBC 4.0 RowId classes

[ http://issues.apache.org/jira/browse/DERBY-1768?page=comments#action_12431020 ] Daniel John Debrunner commented on DERBY-1768: -- Could the classes be left in the codeline and just excluded by the build? Do they even show up in the

Re: for each row mode db2sql

Rick Hillegas wrote: In order to declare a Derby trigger, you need to include the phrase mode db2sql. I can't find this phrase in the ANSI SQL spec--trigger declaration is described in volume 2, section 11.39. The phrase does turn up in the DB2 reference manual, where it has this explanation:

[jira] Commented: (DERBY-606) SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE fails on (very) large tables

[ http://issues.apache.org/jira/browse/DERBY-606?page=comments#action_12431025 ] Sunitha Kambhampati commented on DERBY-606: --- I can reproduce this failure in one of my test scenarios on a very large table: ij call

[jira] Commented: (DERBY-1768) Remove JDBC 4.0 RowId classes

[ http://issues.apache.org/jira/browse/DERBY-1768?page=comments#action_12431023 ] Knut Anders Hatlen commented on DERBY-1768: --- EmbedRowId is in derby.jar because RowIdNotImplementedTest and Driver40 have a direct reference to it. The

[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

[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431026 ] Mamta A. Satoor commented on DERBY-1686: Yip, I am still looking through the patch but have a question after a quick look at the patch. In new method

[jira] Commented: (DERBY-1746) upgrade tests should start using 10.1.3 released builds

[ http://issues.apache.org/jira/browse/DERBY-1746?page=comments#action_12431034 ] Myrna van Lunteren commented on DERBY-1746: --- I experimented and found the following: - the problem appears to be with 10.1.3.1 derby.jar. Using the other

[jira] Commented: (DERBY-1746) upgrade tests should start using 10.1.3 released builds

[ http://issues.apache.org/jira/browse/DERBY-1746?page=comments#action_12431037 ] Myrna van Lunteren commented on DERBY-1746: --- For the record, this is the 'full' stack trace from the .tmp file (no derby.log appears to get created)

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

[ http://issues.apache.org/jira/browse/DERBY-883?page=all ] Daniel John Debrunner updated DERBY-883: Fix Version/s: 10.3.0.0 (was: 10.2.1.0) Change was commited to trunk (10.3) Enhance GROUP BY clause to support

[jira] Updated: (DERBY-1130) Client should not allow databaseName to be set with setConnectionAttributes

[ http://issues.apache.org/jira/browse/DERBY-1130?page=all ] Mike Matrigali updated DERBY-1130: -- Derby Info: [Patch Available, Existing Application Impact, Release Note Needed] (was: [Patch Available, Release Note Needed, Existing Application

Re: [jira] Commented: (DERBY-1292) ClassCastException in ClientDriver when using CLOB columns and batch updates

Øystein Grøvlen (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-1292?page=comments#action_12431049 ] Øystein Grøvlen commented on DERBY-1292: I have reviewed the new version of the patch and the code looks fine

[jira] Closed: (DERBY-1609) Add a runScript method to ij that takes a script as an InputStream and returns the output to a stream.

[ http://issues.apache.org/jira/browse/DERBY-1609?page=all ] Daniel John Debrunner closed DERBY-1609. Add a runScript method to ij that takes a script as an InputStream and returns the output to a stream.

[jira] Commented: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4

[ http://issues.apache.org/jira/browse/DERBY-1633?page=comments#action_12431066 ] Prasenjit Sarkar commented on DERBY-1633: - I dont think this issue is resolved yet: I got a SQL error (same as above) for the following query that works

[jira] Commented: (DERBY-1575) document full syntax of CASE expression

[ http://issues.apache.org/jira/browse/DERBY-1575?page=comments#action_12431067 ] Kim Haase commented on DERBY-1575: -- This issue is marked as major, and it looks like a relatively simple fix. I can take it on. document full syntax of CASE

[jira] Assigned: (DERBY-1575) document full syntax of CASE expression

[ http://issues.apache.org/jira/browse/DERBY-1575?page=all ] Kim Haase reassigned DERBY-1575: Assignee: Kim Haase document full syntax of CASE expression --- Key: DERBY-1575 URL:

[jira] Commented: (DERBY-1686) Grant/Revoke: Attempt to GRANT access to another user on a VIEW, created by the current user with only SELECT privilege on the base table does not fail

[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431068 ] Yip Ng commented on DERBY-1686: --- Mamta, are you referring to the statement cache? I thought there is a statement cache per connection. So the DBA and the schema

[jira] Commented: (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

[ http://issues.apache.org/jira/browse/DERBY-1555?page=comments#action_12431069 ] Daniel John Debrunner commented on DERBY-1555: -- Patch derby-1555-removecomment.diff Committed revision 437832 - Thanks Kristian API for

[jira] Commented: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4

[ http://issues.apache.org/jira/browse/DERBY-1633?page=comments#action_12431073 ] A B commented on DERBY-1633: Thanks for continuing to test this particular fix, Prasenjit. I assume the query in the above comment is supposed to be run agains the

Re: [jira] Commented: (DERBY-1746) upgrade tests should start using 10.1.3 released builds

Myrna van Lunteren (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-1746?page=comments#action_12431034 ] Myrna van Lunteren commented on DERBY-1746: --- I experimented and found the following: - the problem appears to be with

Re: [jira] Commented: (DERBY-1746) upgrade tests should start using 10.1.3 released builds

On 8/28/06, Kristian Waagan [EMAIL PROTECTED] wrote: Myrna van Lunteren (JIRA) wrote: [ http://issues.apache.org/jira/browse/DERBY-1746?page=comments#action_12431034 ] Myrna van Lunteren commented on DERBY-1746: --- I experimented and found the

[jira] Commented: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4

[ http://issues.apache.org/jira/browse/DERBY-1633?page=comments#action_12431091 ] A B commented on DERBY-1633: Does the above query work if you run it against Derby embedded instead of client/server? If it works in embedded but not with

[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

[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431095 ] Yip Ng commented on DERBY-1686: --- Hmm... I probably should not make any assumptions for the equals method since it could changed in the future and not rely on the

[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

[ http://issues.apache.org/jira/browse/DERBY-1686?page=all ] Yip Ng updated DERBY-1686: -- Attachment: derby1686-trunk-stat03.txt derby1686-trunk-diff03.txt Attaching derby1686-trunk-diff03.txt. This patch removes the dba check at bind time and

[jira] Assigned: (DERBY-1702) lang/outparams.java and jdbcapi/parameterMapping.java fail on J9 ibm 131 jvm .

[ http://issues.apache.org/jira/browse/DERBY-1702?page=all ] Myrna van Lunteren reassigned DERBY-1702: - Assignee: Myrna van Lunteren lang/outparams.java and jdbcapi/parameterMapping.java fail on J9 ibm 131 jvm .

Question on the lib 10.2.1.1beta layout

I downloaded db-derby-10.2.1.1-lib.zip from http://people.apache.org/~rhillegas/10.2.1.1-beta/ The layout wasn't what I was expecting, the top level had two folders: db-derby-10.2.1.1-bin db-derby-10.2.1.1-lib The bin folder had the test folder and the bin had the lib folder. Is this

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

[ http://issues.apache.org/jira/browse/DERBY-1566?page=all ] Jean T. Anderson updated DERBY-1566: Attachment: ErrorMessageGenerator.java rrefexcept71493.html ErrorMessageGenerator.java is a copy of DERBY-296's app modified as

[jira] Updated: (DERBY-1702) lang/outparams.java and jdbcapi/parameterMapping.java fail on J9 ibm 131 jvm .

[ http://issues.apache.org/jira/browse/DERBY-1702?page=all ] Myrna van Lunteren updated DERBY-1702: -- Attachment: DERBY-1702-main_20060828.diff DERBY-1702_102_20060828.diff 2 patches - 1 for the trunk 1 for 10.2 - with relevant

[jira] Created: (DERBY-1771) Doc title in browser for html pages is Web sample

Doc title in browser for html pages is Web sample -- Key: DERBY-1771 URL: http://issues.apache.org/jira/browse/DERBY-1771 Project: Derby Issue Type: Bug Reporter: Daniel John

[jira] Updated: (DERBY-1702) lang/outparams.java and jdbcapi/parameterMapping.java fail on J9 ibm 131 jvm .

[ http://issues.apache.org/jira/browse/DERBY-1702?page=all ] Myrna van Lunteren updated DERBY-1702: -- Derby Info: [Patch Available, Regression] (was: [Regression]) lang/outparams.java and jdbcapi/parameterMapping.java fail on J9 ibm 131 jvm .

[jira] Updated: (DERBY-1771) Doc title in browser for html pages is Web sample

[ http://issues.apache.org/jira/browse/DERBY-1771?page=all ] Daniel John Debrunner updated DERBY-1771: - Description: Loadin this page in the broswer shows the title: docs/html/ref/index.html Also seen on the docs on the web-site.

[jira] Commented: (DERBY-1633) Regression: The fields of views are not being calculated properly since 10.1.2.4

[ http://issues.apache.org/jira/browse/DERBY-1633?page=comments#action_12431123 ] Prasenjit Sarkar commented on DERBY-1633: - Our application is too network-server centric to run in embedded mode. I would like to help you in any other

XML type description - possible changes?

The XML type has this description in the reference manual: http://db.apache.org/derby/docs/dev/ref/rrefsqljtypexml.html An XML column is used to store Unicode character-based data, such as large documents in any character set, that conform to the SQL/XML definition of a well-formed

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

[ http://issues.apache.org/jira/browse/DERBY-1566?page=comments#action_12431128 ] Jean T. Anderson commented on DERBY-1566: - Compare rrefexcept71493.html uploaded to this issue to

[jira] Created: (DERBY-1772) Error 42Z78 Failed to locate 'Xalan' API classes should not have sqlstate class '42'

Error 42Z78 Failed to locate 'Xalan' API classes should not have sqlstate class '42' --- Key: DERBY-1772 URL: http://issues.apache.org/jira/browse/DERBY-1772

[jira] Updated: (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/DERBY-1583?page=all ] Bryan Pendleton updated DERBY-1583: --- Attachment: skipAddPriv.diff Attached is an alternate proposal for a patch to this issue. skipAddPriv.diff is based on the idea that if a particular

[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

[ http://issues.apache.org/jira/browse/DERBY-1686?page=comments#action_12431141 ] Mamta A. Satoor commented on DERBY-1686: Yip, I thought more about this issue and I think we might be able to get away with an easier solution. With SQL

[jira] Commented: (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/DERBY-1583?page=comments#action_12431143 ] Mamta A. Satoor commented on DERBY-1583: Bryan, the patch looks good to me. Just couple minor comments 1)Can you please put a comment for if (td == nulll)