[jira] Commented: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12581994#action_12581994 ] Craig Russell commented on DERBY-3301: -- Thanks for the update, Thomas. I could feel

[jira] Updated: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Craig Russell updated DERBY-3301: - Attachment: Derby-3301.html I've tried to summarize the issue with the attached release note.

[jira] Updated: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Craig Russell updated DERBY-3301: - Attachment: releaseNote.html I've changed the description to address the tense issue, and

[jira] Commented: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12580155#action_12580155 ] Craig Russell commented on DERBY-3301: -- Seems like a release note might be

[jira] Commented: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12569506#action_12569506 ] Craig Russell commented on DERBY-3301: -- I'm convinced that this issue is resolved. I

[jira] Commented: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12565805#action_12565805 ] Craig Russell commented on DERBY-3301: -- Hooray. Thanks everyone for your efforts on

[jira] Commented: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12564256#action_12564256 ] Craig Russell commented on DERBY-3301: -- and with that change (everything else the

[jira] Commented: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12564312#action_12564312 ] Craig Russell commented on DERBY-3301: -- I've applied the patch derby-3301-5.diff and

[jira] Commented: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12563575#action_12563575 ] Craig Russell commented on DERBY-3301: -- I'd like to summarize my understanding of the

[jira] Commented: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12563660#action_12563660 ] Craig Russell commented on DERBY-3301: -- Here are more queries, just slightly modified

[jira] Commented: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12561054#action_12561054 ] Craig Russell commented on DERBY-3301: -- Bryan This slight variation of the query seems

[jira] Commented: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12561141#action_12561141 ] Craig Russell commented on DERBY-3301: -- Great! I'm looking forward to trying the

[jira] Commented: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12560902#action_12560902 ] Craig Russell commented on DERBY-3301: -- Too late to keep working - EXIST should

[jira] Updated: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Craig Russell updated DERBY-3301: - Attachment: derby-3301.sql The attached patch demonstrates the problem. The expected result of

[jira] Updated: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Craig Russell updated DERBY-3301: - Affects Version/s: 10.1.3.1 Reproduced also on 10.1.3.1. There is a slight difference in

[jira] Issue Comment Edited: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12556033#action_12556033 ] clr edited comment on DERBY-3301 at 1/4/08 11:43 AM: --- There

[jira] Commented: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=12556033#action_12556033 ] Craig Russell commented on DERBY-3301: -- There is a similar query that sometimes

[jira] Created: (DERBY-3301) Incorrect result from query with nested EXIST

Incorrect result from query with nested EXIST - Key: DERBY-3301 URL: https://issues.apache.org/jira/browse/DERBY-3301 Project: Derby Issue Type: Bug Components: SQL Reporter:

[jira] Updated: (DERBY-3301) Incorrect result from query with nested EXIST

[ https://issues.apache.org/jira/browse/DERBY-3301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Craig Russell updated DERBY-3301: - Affects Version/s: 10.2.1.6 10.3.2.1 Fix Version/s: (was:

[jira] Commented: (DERBY-2020) Change file option for syncing log file to disk from rws to rwd

[ https://issues.apache.org/jira/browse/DERBY-2020?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12494073 ] Craig Russell commented on DERBY-2020: -- IIRC, the reason this was changed just a few years ago from rwd to rws

[jira] Closed: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ https://issues.apache.org/jira/browse/DERBY-1516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Craig Russell closed DERBY-1516. Inconsistent behavior for getBytes and getSubString for embedded versus network

[jira] Commented: (DERBY-1691) jdbcapi/blobclob4BLOB.java fails under DerbyNet framework with JCC 2.6

[ http://issues.apache.org/jira/browse/DERBY-1691?page=comments#action_12428209 ] Craig Russell commented on DERBY-1691: -- There is a tiny difference in the message text for: com.ibm.db2.jcc.c.SqlException com.ibm.db2.jcc.a.SqlException Is

[jira] Commented: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12427294 ] Craig Russell commented on DERBY-1516: -- Hi David, From my comments 31-Jul-2006: I did not update master/DerbyNet/blobclob4BLOB.out canon because this canon

[jira] Updated: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=all ] Craig Russell updated DERBY-1516: - Attachment: DERBY-1516.patch I've updated the Derby workspace as of this morning. I've removed the formatting changes from blobclob4BLOB.java. They would

[jira] Commented: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12426647 ] Craig Russell commented on DERBY-1516: -- Dan observes: Since this has been a tricky area to get correct, it seems that adding Javadoc comments to the

[jira] Commented: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12426674 ] Craig Russell commented on DERBY-1516: -- Here's a proposed javadoc comment for EmbedClob.getSubString: * Valid pos values require that 0 pos clob.length

[jira] Commented: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12426707 ] Craig Russell commented on DERBY-1516: -- Hi Dan, Thanks for your comments. I mean comments clarifying the length position arguments passed in and the

[jira] Updated: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=all ] Craig Russell updated DERBY-1516: - Attachment: DERBY-1516.patch I've updated the javadoc for the getBytes in EmbedBlob; and getSubString in EmbedClob. I've created javadoc for the methods

[jira] Commented: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12426397 ] Craig Russell commented on DERBY-1516: -- I have run derby-all with these changes, and no errors were reported. Any other comments before I check this in?

[jira] Updated: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=all ] Craig Russell updated DERBY-1516: - Derby Info: [Patch Available] Inconsistent behavior for getBytes and getSubString for embedded versus network

[jira] Commented: (DERBY-1639) Include early-draft notice required by JDBC 4 spec license in NOTICES, release notes and documentation

[ http://issues.apache.org/jira/browse/DERBY-1639?page=comments#action_12425901 ] Craig Russell commented on DERBY-1639: -- IANAL, but I don't think there is a problem. Derby is not an application. The only way you can run Derby that exposes

[jira] Commented: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12425588 ] Craig Russell commented on DERBY-1516: -- Hi Dag, You know, I read this a hundred times and did not read it as allowing t2.substring(1,1), since clearly 1 is

[jira] Updated: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=all ] Craig Russell updated DERBY-1516: - Attachment: DERBY-1516.patch This patch incorporates all of the comments (thank you, Kathey and Dag) and therefore the logic is simpler for detecting

[jira] Commented: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12425340 ] Craig Russell commented on DERBY-1516: -- There is different behavior between embedded and network in other areas as well as the one I'm looking at here. I'd

[jira] Updated: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=all ] Craig Russell updated DERBY-1516: - Attachment: DERBY-1516.patch This patch solves the discrepancy between the treatment of getBytes and getSubString where the requested length is zero. This

[jira] Commented: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12424887 ] Craig Russell commented on DERBY-1516: -- Thanks for the feedback. I'll make some positive and negative test cases and update the patch. Yes, I'm suggesting

[jira] Updated: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=all ] Craig Russell updated DERBY-1516: - Attachment: DERBY-1516.patch I've updated the patch with changes to the master/DerbyNetClient/blobclob4BLOB.out canon. I did not update

[jira] Assigned: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=all ] Craig Russell reassigned DERBY-1516: Assignee: Craig Russell Inconsistent behavior for getBytes and getSubString for embedded versus network

[jira] Created: (DERBY-1617) Re-enable blobclob4BLOB clobTest6 that was disabled for an old bug

Re-enable blobclob4BLOB clobTest6 that was disabled for an old bug -- Key: DERBY-1617 URL: http://issues.apache.org/jira/browse/DERBY-1617 Project: Derby Issue Type: Test

[jira] Commented: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12424673 ] Craig Russell commented on DERBY-1516: -- Including the discussion from the alias referenced immediately above: One interesting test with 0 length is the case

[jira] Commented: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=comments#action_12424448 ] Craig Russell commented on DERBY-1516: -- Hi Kathey, Thanks for the feedback on the patch. A few notes: 1. I've added myself to the derby-developers list so I

[jira] Updated: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

[ http://issues.apache.org/jira/browse/DERBY-1516?page=all ] Craig Russell updated DERBY-1516: - Attachment: DERBY-1516.patch This patch applies to the trunk. I've updated the tests and canon for this change as well. Inconsistent behavior for

[jira] Created: (DERBY-1516) Inconsistent behavior for getBytes and getSubString for embedded versus network

Inconsistent behavior for getBytes and getSubString for embedded versus network --- Key: DERBY-1516 URL: http://issues.apache.org/jira/browse/DERBY-1516 Project: Derby

[jira] Commented: (DERBY-587) Providing JDBC 4.0 support for derby

[ http://issues.apache.org/jira/browse/DERBY-587?page=comments#action_12356471 ] Craig Russell commented on DERBY-587: - I recognize that this is an internal project issue, but: Doesn't the grant Apache license check box on the patch upload mean

[jira] Commented: (DERBY-587) Providing JDBC 4.0 support for derby

[ http://issues.apache.org/jira/browse/DERBY-587?page=comments#action_12356473 ] Craig Russell commented on DERBY-587: - I have just a few comments. 1. The code does not appear to be consistent with regard to spaces, tabs, indents, and which line the {

[jira] Created: (DERBY-581) Modify SQL to skip N rows of the result and return the next M rows

Modify SQL to skip N rows of the result and return the next M rows -- Key: DERBY-581 URL: http://issues.apache.org/jira/browse/DERBY-581 Project: Derby Type: New Feature Components: Unknown

[jira] Commented: (DERBY-214) Remove System.exit() calls from the DB2jServerImpl.java

[ http://issues.apache.org/jira/browse/DERBY-214?page=comments#action_64106 ] Craig Russell commented on DERBY-214: - Hi, I agree that main() should only be used from the command line, and is the only place in the code where System.exit() should