[jira] [Updated] (DERBY-6879) Engine deadlock between XA timeout handling and cleanupOnError

2016-07-16 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6879: --- Attachment: testFail.zip Hi Brett, While running the overall suite overnight I had a test

[jira] [Commented] (DERBY-6895) Add documentation for new SYSCS_IMPORT_TABLE_BULK, SYSCS_IMPORT_DATA_BULK procedures

2016-07-16 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15380871#comment-15380871 ] Bryan Pendleton commented on DERBY-6895: I think that paragraph is describing how you change

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-15 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15380435#comment-15380435 ] Bryan Pendleton commented on DERBY-6894: However, I'm a little surprised that this test case

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-15 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15380430#comment-15380430 ] Bryan Pendleton commented on DERBY-6894: I spent some time looking at the behavior of these two

[jira] [Updated] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-15 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6894: --- Attachment: readHeadersLoadError.diff Attached readHeadersLoadError.diff suggests that we

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-14 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15378697#comment-15378697 ] Bryan Pendleton commented on DERBY-6894: Excellent, thank you! I will take a look at your latest

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-14 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15376908#comment-15376908 ] Bryan Pendleton commented on DERBY-6894: I anticipated that these three tests would be successful

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-13 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15376327#comment-15376327 ] Bryan Pendleton commented on DERBY-6894: The behavior you describe seems correct to me; as you say

[jira] [Comment Edited] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-10 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15369919#comment-15369919 ] Bryan Pendleton edited comment on DERBY-6894 at 7/10/16 7:48 PM: - I think

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-10 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15369920#comment-15369920 ] Bryan Pendleton commented on DERBY-6894: First, here are a few general comments: - I think we

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-10 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15369919#comment-15369919 ] Bryan Pendleton commented on DERBY-6894: I think the new symbolic error name in SQLState.java

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-10 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15369846#comment-15369846 ] Bryan Pendleton commented on DERBY-6894: I'll try to think about some additional test cases

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-09 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15369348#comment-15369348 ] Bryan Pendleton commented on DERBY-6894: {quote} Whenever the ImportReadData.java class is used

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-09 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15369157#comment-15369157 ] Bryan Pendleton commented on DERBY-6894: A couple other small comments; I didn't want them to get

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-09 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15369155#comment-15369155 ] Bryan Pendleton commented on DERBY-6894: Hi Danoja, thanks for the updated patch. It makes a lot

[jira] [Commented] (DERBY-6879) Engine deadlock between XA timeout handling and cleanupOnError

2016-07-08 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15368860#comment-15368860 ] Bryan Pendleton commented on DERBY-6879: Had to do follow-on commit 1751978 because I forgot

[jira] [Commented] (DERBY-6879) Engine deadlock between XA timeout handling and cleanupOnError

2016-07-08 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15368768#comment-15368768 ] Bryan Pendleton commented on DERBY-6879: I had no further suggestions to offer after re-reading

Proposal for a Derby 10.13 release this fall

2016-07-08 Thread Bryan Pendleton
Hi all, I am volunteering to manage and perform a Derby 10.13 release sometime this fall. Rick has generously offered to mentor and guide me through the release process, as this will be the first release I've attempted to build. There won't be a lot of new features in this release, so far as I

[jira] [Commented] (DERBY-6879) Engine deadlock between XA timeout handling and cleanupOnError

2016-07-08 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15367687#comment-15367687 ] Bryan Pendleton commented on DERBY-6879: Thanks Brett! I'm no fan of brace or whitespace wars

[jira] [Resolved] (DERBY-6893) Create new SYSCS_IMPORT_DATA_BULK procedure

2016-07-07 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton resolved DERBY-6893. Resolution: Fixed Fix Version/s: 10.13.0.0 The latest patch seems ready for commit

[jira] [Commented] (DERBY-6893) Create new SYSCS_IMPORT_DATA_BULK procedure

2016-07-07 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15366213#comment-15366213 ] Bryan Pendleton commented on DERBY-6893: Excellent! I will have a look in the next day or so

[jira] [Commented] (DERBY-6879) Engine deadlock between XA timeout handling and cleanupOnError

2016-07-06 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15365542#comment-15365542 ] Bryan Pendleton commented on DERBY-6879: Hi Brett, thanks for the patch, and for the detailed

Re: Contribute to Apache Derby

2016-07-05 Thread Bryan Pendleton
On 7/4/2016 11:15 PM, dulanja mallikarachchi wrote: I would like to contribute Derby project . Wonderful! Welcome to Derby! I would like to fix some bugs in your product. How can I Here's a couple resources: - This page has lots of background information about contributing to the

[jira] [Updated] (DERBY-6852) Allow identity columns to cycle (as defined in SQL:2003)

2016-07-04 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6852?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6852: --- Attachment: script.sql Hi Danoja, perhaps the thing that is confusing is that a column which

[jira] [Commented] (DERBY-6893) Create new SYSCS_IMPORT_DATA_BULK procedure

2016-07-03 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6893?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360698#comment-15360698 ] Bryan Pendleton commented on DERBY-6893: It looks like a few of the comments in the new test case

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-03 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360680#comment-15360680 ] Bryan Pendleton commented on DERBY-6894: I believe that the idea of the INSERTCOLUMNS

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-03 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360622#comment-15360622 ] Bryan Pendleton commented on DERBY-6894: I think I've confused myself somewhat. I thought

[jira] [Resolved] (DERBY-6892) Create new SYSCS_IMPORT_TABLE_BULK procedure

2016-07-03 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton resolved DERBY-6892. Resolution: Fixed Fix Version/s: 10.13.0.0 After one more close reading of the patch

[jira] [Commented] (DERBY-6852) Allow identity columns to cycle (as defined in SQL:2003)

2016-07-02 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360393#comment-15360393 ] Bryan Pendleton commented on DERBY-6852: Do you mean: you get the duplicate value exception

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-07-02 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15360389#comment-15360389 ] Bryan Pendleton commented on DERBY-6894: Hi Danoja, I took a very brief look at your patch. I

Re: Can someone comment on my understanding of the code relating to DERBY-6879

2016-06-30 Thread Bryan Pendleton
I see this code in XATransactionState.java: I'm sorry, Brett, I'm really not very familiar with this code, and my knowledge of XA is very theoretical; I've never actually used it for a production app. However, I wanted to suggest that you might find some insight by looking carefully through

[jira] [Commented] (DERBY-6895) Add documentation for new SYSCS_IMPORT_TABLE_BULK, SYSCS_IMPORT_DATA_BULK procedures

2016-06-29 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15355219#comment-15355219 ] Bryan Pendleton commented on DERBY-6895: Hi Danoja, The HTML looks very good. The text

[jira] [Updated] (DERBY-6892) Create new SYSCS_IMPORT_TABLE_BULK procedure

2016-06-28 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6892?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6892: --- Attachment: Derby-6892-whitespaceCleanup.diff Thanks! The new diff seems much cleaner to me

[jira] [Commented] (DERBY-6892) Create new SYSCS_IMPORT_TABLE_BULK procedure

2016-06-28 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15352993#comment-15352993 ] Bryan Pendleton commented on DERBY-6892: I'm still a bit confused as to why it is necessary

[jira] [Commented] (DERBY-6892) Create new SYSCS_IMPORT_TABLE_BULK procedure

2016-06-27 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15350997#comment-15350997 ] Bryan Pendleton commented on DERBY-6892: It sounds like you have finished all the work you had

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-06-26 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15350326#comment-15350326 ] Bryan Pendleton commented on DERBY-6894: A simple approach might be to automatically "join

[jira] [Commented] (DERBY-6879) Engine deadlock between XA timeout handling and cleanupOnError

2016-06-26 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15350325#comment-15350325 ] Bryan Pendleton commented on DERBY-6879: I agree, it's as though the policy isn't being deployed

[jira] [Commented] (DERBY-6879) Engine deadlock between XA timeout handling and cleanupOnError

2016-06-26 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15350236#comment-15350236 ] Bryan Pendleton commented on DERBY-6879: I downloaded and applied the patch successfully

[jira] [Commented] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-06-26 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6894?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15350166#comment-15350166 ] Bryan Pendleton commented on DERBY-6894: Thanks Rick, your suggestion seems like a good approach

[jira] [Commented] (DERBY-6892) Create new SYSCS_IMPORT_TABLE_BULK procedure

2016-06-26 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15350162#comment-15350162 ] Bryan Pendleton commented on DERBY-6892: My test runs were clean, also. Danoja, can you summarize

[jira] [Commented] (DERBY-6892) Create new SYSCS_IMPORT_TABLE_BULK procedure

2016-06-25 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15349917#comment-15349917 ] Bryan Pendleton commented on DERBY-6892: Wonderful! I will download your patch and run the tests

[jira] [Commented] (DERBY-6892) Create new SYSCS_IMPORT_TABLE_BULK procedure

2016-06-24 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15349025#comment-15349025 ] Bryan Pendleton commented on DERBY-6892: It's not obvious to me why the order of arguments change

[jira] [Commented] (DERBY-6892) Create new SYSCS_IMPORT_TABLE_BULK procedure

2016-06-24 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6892?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15348995#comment-15348995 ] Bryan Pendleton commented on DERBY-6892: Do you have an idea about what might be causing

Re: How should one handle a test case that when it fails will cause a deadlock in Derby Netwok Server

2016-06-24 Thread Bryan Pendleton
my test that I added to XATest.java causes the deadlock and the watchdog detects the deadlock and then does a System.exit(1) to kill the test for now. Brett, I think that's a wonderful approach! Frankly, I think it is probably more than is strictly-speaking necessary; as I understand your

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-23 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15347596#comment-15347596 ] Bryan Pendleton commented on DERBY-4555: That seems like a reasonable idea. I will try it too

[jira] [Created] (DERBY-6895) Add documentation for new SYSCS_IMPORT_TABLE_BULK, SYSCS_IMPORT_DATA_BULK procedures

2016-06-23 Thread Bryan Pendleton (JIRA)
Bryan Pendleton created DERBY-6895: -- Summary: Add documentation for new SYSCS_IMPORT_TABLE_BULK, SYSCS_IMPORT_DATA_BULK procedures Key: DERBY-6895 URL: https://issues.apache.org/jira/browse/DERBY-6895

[jira] [Created] (DERBY-6894) Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name

2016-06-23 Thread Bryan Pendleton (JIRA)
Bryan Pendleton created DERBY-6894: -- Summary: Enhance COLUMNINDEXES parsing for SYSCS_IMPORT_DATA_BULK to recognize columns by name Key: DERBY-6894 URL: https://issues.apache.org/jira/browse/DERBY-6894

[jira] [Created] (DERBY-6893) Create new SYSCS_IMPORT_DATA_BULK procedure

2016-06-23 Thread Bryan Pendleton (JIRA)
Bryan Pendleton created DERBY-6893: -- Summary: Create new SYSCS_IMPORT_DATA_BULK procedure Key: DERBY-6893 URL: https://issues.apache.org/jira/browse/DERBY-6893 Project: Derby Issue Type

[jira] [Created] (DERBY-6892) Create new SYSCS_IMPORT_TABLE_BULK procedure

2016-06-23 Thread Bryan Pendleton (JIRA)
Bryan Pendleton created DERBY-6892: -- Summary: Create new SYSCS_IMPORT_TABLE_BULK procedure Key: DERBY-6892 URL: https://issues.apache.org/jira/browse/DERBY-6892 Project: Derby Issue Type

Re: Need some help with getting tests to run

2016-06-23 Thread Bryan Pendleton
had to search though the ant build script to find the target “cleanjars”. Yes, sorry about that. I guess that I often do ant clobber cleanjars out of habit. Perhaps there is a good place in the db-derby wiki that you can record some of these things? Or suggest somewhere else we could

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-22 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15345713#comment-15345713 ] Bryan Pendleton commented on DERBY-4555: Hi Danoja, I studied your patch for a while, and I ran

Re: Looking at DERBY-3908 (Add a mechanism for cancelling runaway transactions)

2016-06-22 Thread Bryan Pendleton
https://issues.apache.org/jira/browse/DERBY-3908 in network mode... seems to require that the DRDAConnThread be able to receive a message from the network client even while it is waiting for a statement to executed and the result transported back to the client. Hi Brett, Ouch, I agree, this

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-22 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15345504#comment-15345504 ] Bryan Pendleton commented on DERBY-4555: I will try to look at your latest patch soon. Meanwhile

[jira] [Commented] (DERBY-6879) Engine deadlock between XA timeout handling and cleanupOnError

2016-06-22 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6879?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15345486#comment-15345486 ] Bryan Pendleton commented on DERBY-6879: Hi Brett, thanks for all the time and effort

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-20 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15339523#comment-15339523 ] Bryan Pendleton commented on DERBY-4555: Yes, I like the suggested name of SYSCS_IMPORT_TABLE_BULK

[jira] [Updated] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-18 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-4555: --- Attachment: repro.java Thanks, the new diff applied just fine. You could probably delete

[jira] [Commented] (DERBY-6852) Allow identity columns to cycle (as defined in SQL:2003)

2016-06-18 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15338007#comment-15338007 ] Bryan Pendleton commented on DERBY-6852: I'm sorry, Rick, I've confused myself. Are you saying

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-18 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15338001#comment-15338001 ] Bryan Pendleton commented on DERBY-4555: Hi Danoja, can you please double-check your latest

[jira] [Resolved] (DERBY-6890) ALTER TABLE DROP COLUMN corrupts secondary index collation information

2016-06-18 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton resolved DERBY-6890. Resolution: Fixed Fix Version/s: 10.13.0.0 I think this patch is as good as I can

[jira] [Updated] (DERBY-6890) ALTER TABLE DROP COLUMN corrupts secondary index collation information

2016-06-17 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6890: --- Attachment: ready.diff Attached 'ready.diff' is the change I propose to commit. Tests

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-16 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15335290#comment-15335290 ] Bryan Pendleton commented on DERBY-4555: I think that seems like a very nice idea. Thanks

[jira] [Commented] (DERBY-6852) Allow identity columns to cycle (as defined in SQL:2003)

2016-06-16 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15333766#comment-15333766 ] Bryan Pendleton commented on DERBY-6852: Thanks for the clarification. It is important that we

[jira] [Commented] (DERBY-6852) Allow identity columns to cycle (as defined in SQL:2003)

2016-06-15 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6852?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15333083#comment-15333083 ] Bryan Pendleton commented on DERBY-6852: I am not sure I understand. Could you expand a bit about

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-15 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15333081#comment-15333081 ] Bryan Pendleton commented on DERBY-4555: Perhaps we should re-consider this: https

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-15 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15331776#comment-15331776 ] Bryan Pendleton commented on DERBY-4555: I think the problem here is that SYSCS_IMPORT_TABLE

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-12 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15326751#comment-15326751 ] Bryan Pendleton commented on DERBY-4555: If you used an Ant command to run the tests, for example

[jira] [Updated] (DERBY-6890) ALTER TABLE DROP COLUMN corrupts secondary index collation information

2016-06-11 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6890: --- Attachment: CollationTest2.diff Yay! After a few false starts, I was able to modify

[jira] [Updated] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-10 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-4555: --- Attachment: repro.java noHeaderLines.csv Attached is the repro.java that I am

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-10 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15325557#comment-15325557 ] Bryan Pendleton commented on DERBY-4555: Hi Danoja, am I doing the right steps to see the error

[jira] [Commented] (DERBY-6890) ALTER TABLE DROP COLUMN corrupts secondary index collation information

2016-06-09 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15323714#comment-15323714 ] Bryan Pendleton commented on DERBY-6890: I spent some time looking through the test cases

[jira] [Resolved] (DERBY-6550) Bulk-insert causes identity columns to cycle when they shouldn't

2016-06-08 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton resolved DERBY-6550. Resolution: Cannot Reproduce We've tested this against several recent versions and have

[jira] [Commented] (DERBY-6550) Bulk-insert causes identity columns to cycle when they shouldn't

2016-06-08 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15320647#comment-15320647 ] Bryan Pendleton commented on DERBY-6550: Hi Danoja, did you have a chance to run the reproduction

[jira] [Commented] (DERBY-6890) ALTER TABLE DROP COLUMN corrupts secondary index collation information

2016-06-07 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15319985#comment-15319985 ] Bryan Pendleton commented on DERBY-6890: Thanks for the review, Rick. I agree that some additional

[jira] [Updated] (DERBY-6550) Bulk-insert causes identity columns to cycle when they shouldn't

2016-06-07 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6550: --- Attachment: updatedTest.diff I think that, in addition to creating the table

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-06-07 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15318544#comment-15318544 ] Bryan Pendleton commented on DERBY-4555: Hi Danoja, can you please attach your very latest patch

[jira] [Updated] (DERBY-6890) ALTER TABLE DROP COLUMN corrupts secondary index collation information

2016-06-07 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6890: --- Attachment: proposed.diff Attached 'proposed.diff' passes regression tests and is, I think

[jira] [Commented] (DERBY-6890) ALTER TABLE DROP COLUMN corrupts secondary index collation information

2016-06-05 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15316073#comment-15316073 ] Bryan Pendleton commented on DERBY-6890: The patch isn't completely viable; the tests show

[jira] [Updated] (DERBY-6890) ALTER TABLE DROP COLUMN corrupts secondary index collation information

2016-06-05 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6890: --- Attachment: fixIndexCollation.diff Attached 'fixIndexCollation.diff' is a patch proposal

[jira] [Updated] (DERBY-6890) ALTER TABLE DROP COLUMN corrupts secondary index collation information

2016-06-05 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6890: --- Attachment: doesntPassTests.diff Attached 'doesntPassTests.diff' is not for commit, but may

[jira] [Updated] (DERBY-6890) ALTER TABLE DROP COLUMN corrupts secondary index collation information

2016-06-05 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6890: --- Assignee: Bryan Pendleton Description: For a database with "collation=/terr

[jira] [Commented] (DERBY-6890) INSERT error after PK altered to GENERATED

2016-06-05 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15315971#comment-15315971 ] Bryan Pendleton commented on DERBY-6890: OK, I think I see the problem now, though I don't yet

[jira] [Commented] (DERBY-6890) INSERT error after PK altered to GENERATED

2016-06-04 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15315699#comment-15315699 ] Bryan Pendleton commented on DERBY-6890: The support for adjusting the collation identifiers

[jira] [Commented] (DERBY-6890) INSERT error after PK altered to GENERATED

2016-06-04 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15315667#comment-15315667 ] Bryan Pendleton commented on DERBY-6890: Possibly things go wrong in the ALTER TABLE DROP COLUMN

collation/territory info -- where is it stored?

2016-06-04 Thread Bryan Pendleton
In the context of DERBY-6890, I've been trying to understand a little bit more about how and where the 'collation=' and 'territory=' information from the JDBC Connection URL is stored within the database at database creation time. I could use some advice from anyone who has a deeper

[jira] [Commented] (DERBY-6890) INSERT error after PK altered to GENERATED

2016-06-04 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15315563#comment-15315563 ] Bryan Pendleton commented on DERBY-6890: I haven't really developed a good intuitive theory about

[jira] [Commented] (DERBY-6890) INSERT error after PK altered to GENERATED

2016-06-03 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15315143#comment-15315143 ] Bryan Pendleton commented on DERBY-6890: The Btree code is complaining because it has two objects

[jira] [Commented] (DERBY-6856) Make it possible to build Derby using JDK 9

2016-06-03 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15314185#comment-15314185 ] Bryan Pendleton commented on DERBY-6856: Javadoc build is clean now, thanks! > Make it possi

[jira] [Commented] (DERBY-6550) Bulk-insert causes identity columns to cycle when they shouldn't

2016-06-02 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15313493#comment-15313493 ] Bryan Pendleton commented on DERBY-6550: If none of our additional testing uncovers any evidence

[jira] [Updated] (DERBY-6550) Bulk-insert causes identity columns to cycle when they shouldn't

2016-06-02 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6550: --- Assignee: Danoja Dias > Bulk-insert causes identity columns to cycle when they should

[jira] [Updated] (DERBY-6890) INSERT error after PK altered to GENERATED

2016-06-02 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6890: --- Attachment: CollationTest.diff Since it appears that this problem is related to collation

[jira] [Commented] (DERBY-6890) INSERT error after PK altered to GENERATED

2016-06-02 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15313406#comment-15313406 ] Bryan Pendleton commented on DERBY-6890: Hi Andrei, Thanks very much for the updated Test.java

[jira] [Commented] (DERBY-6550) Bulk-insert causes identity columns to cycle when they shouldn't

2016-06-02 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15312360#comment-15312360 ] Bryan Pendleton commented on DERBY-6550: Another idea is to try the reproduction script against

[jira] [Commented] (DERBY-6550) Bulk-insert causes identity columns to cycle when they shouldn't

2016-06-02 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6550?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15312318#comment-15312318 ] Bryan Pendleton commented on DERBY-6550: Possibly, but it might also mean that, in the 2 years

[jira] [Updated] (DERBY-6890) INSERT error after PK altered to GENERATED

2016-06-01 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6890?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton updated DERBY-6890: --- Attachment: testRepro.diff I tried to edit the reproduction script

[jira] [Commented] (DERBY-6856) Make it possible to build Derby using JDK 9

2016-06-01 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-6856?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15310755#comment-15310755 ] Bryan Pendleton commented on DERBY-6856: Hi Rick, I'm not sure where you're at with this change

[jira] [Resolved] (DERBY-3181) isNullable on ResultSetMetaData from DatabaseMetaData.getBestRowIdentifier values are opposite when there is no rows in ResultSet vs. when there is a row.

2016-06-01 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bryan Pendleton resolved DERBY-3181. Resolution: Fixed Fix Version/s: 10.13.0.0 We've completed the intended work

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-05-29 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15305864#comment-15305864 ] Bryan Pendleton commented on DERBY-4555: Another idea would be to add

[jira] [Updated] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-05-28 Thread Bryan Pendleton
I'm a little bit confused by the description of Skipping columns versus skipping lines, but I believe I understand your idea; it sounds good. I'm not quite certain about the implications of Adding a new argument to the system catalog Procedure. We may have to do something Special to handle

[jira] [Commented] (DERBY-4555) Expand SYSCS_IMPORT_TABLE to accept CSV file with header lines

2016-05-25 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-4555?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15301333#comment-15301333 ] Bryan Pendleton commented on DERBY-4555: Yes that is my understanding too. Perhaps the new

[jira] [Commented] (DERBY-3181) isNullable on ResultSetMetaData from DatabaseMetaData.getBestRowIdentifier values are opposite when there is no rows in ResultSet vs. when there is a row.

2016-05-24 Thread Bryan Pendleton (JIRA)
[ https://issues.apache.org/jira/browse/DERBY-3181?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15299244#comment-15299244 ] Bryan Pendleton commented on DERBY-3181: I think that *should* be all we need to do, but I am

<    3   4   5   6   7   8   9   10   11   12   >