Re: collation/territory info -- where is it stored?

2016-06-05 Thread Rick Hillegas
Hi Bryan, I find that for a connection url like this... connect 'jdbc:derby:db;create=true;territory=es_MX;collation=TERRITORY_BASED:PRIMARY'; ...the territory is stored in service.properties. Looking at DataDictionaryImpl.boot(), it appears that the collation property is set in the propert

[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&focusedCommentId=15316073#comment-15316073 ] Bryan Pendleton commented on DERBY-6890: The patch isn't completely viable; the te

[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. It

[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 sh

[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=/territory=" info

[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&focusedCommentId=15315971#comment-15315971 ] Bryan Pendleton commented on DERBY-6890: OK, I think I see the problem now, though

Re: collation/territory info -- where is it stored?

2016-06-05 Thread mike matrigali
there is a set of stuff needed to boot stored as properties. Things like the id of table with the table info, table with the attribute info, ... , maybe it is there. should be a file either in top level or in seg0 i think. On 6/4/2016 9:34 AM, Bryan Pendleton wrote: In the context of DERBY-689