[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16234615#comment-16234615
]
Buğra Gedik commented on DERBY-2212:
Was there an update this. It seems almost 10 year
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16235031#comment-16235031
]
Rick Hillegas commented on DERBY-2212:
--
Can you describe your use case which is not s
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16235856#comment-16235856
]
Buğra Gedik commented on DERBY-2212:
Thanks for the info [~rhlrx]. Here is the problem
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16237007#comment-16237007
]
Rick Hillegas commented on DERBY-2212:
--
Right. The unique index treats NULL as a dist
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16237024#comment-16237024
]
Buğra Gedik commented on DERBY-2212:
I would have used it, but the constraint is being
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16237348#comment-16237348
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
Glad to see that a 10 years old
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16238634#comment-16238634
]
Rick Hillegas commented on DERBY-2212:
--
Yes, a unique constraint can be added after a
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16238804#comment-16238804
]
Buğra Gedik commented on DERBY-2212:
Thanks for the information. I'll check with Hiber
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16239382#comment-16239382
]
Buğra Gedik commented on DERBY-2212:
I filed https://hibernate.atlassian.net/browse/HH
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16239587#comment-16239587
]
Rick Hillegas commented on DERBY-2212:
--
Thanks!
> Add "Unique where not null" to cre
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12561977#action_12561977
]
Anurag Shekhar commented on DERBY-2212:
---
I have created a seperate issue DERBY-3330 t
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512020
]
Anurag Shekhar commented on DERBY-2212:
---
Description of this issue mentions two issues
1. allowing duplicate n
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512021
]
Anurag Shekhar commented on DERBY-2212:
---
There was a mail thread about this issue some time back in developer m
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512186
]
Anurag Shekhar commented on DERBY-2212:
---
One of the approach suggested in the previous discussion was to
elimin
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512198
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
Just for your information - Oracle implements this feature
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512231
]
Anurag Shekhar commented on DERBY-2212:
---
Thanks Mike and Oleksandr for showing interest and inputs.
>From your
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512238
]
Anurag Shekhar commented on DERBY-2212:
---
SQL 2003 doesn't specifically talks about unique index but if we use
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512239
]
Anurag Shekhar commented on DERBY-2212:
---
I tried the scenario you mentioned in postgresql here is the result
i
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12512383
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
Oracle behavior:
(null,null,null) vs (null,null,null) -
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12524439
]
Anurag Shekhar commented on DERBY-2212:
---
I am trying to add duplicate null in unique index by making null
not
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12533912
]
Øystein Grøvlen commented on DERBY-2212:
Thanks for the patch, Anurag. Your approach to solving this seems O
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12534035
]
Anurag Shekhar commented on DERBY-2212:
---
thanks Øystein, for the review and trying out the patch.
1. I do not
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535221
]
Anurag Shekhar commented on DERBY-2212:
---
>3. This code will not be executed for partial key matching. Hence, nu
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535226
]
Øystein Grøvlen commented on DERBY-2212:
Anurag Shekhar (JIRA) wrote:
> Partial key matching is used only for
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535435
]
Anurag Shekhar commented on DERBY-2212:
---
thanks Mike for revisiting the issue.
I felt letting the index remain
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535561
]
Anurag Shekhar commented on DERBY-2212:
---
1) Current code changes B2I so needs upgrade code or else no old datab
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535908
]
Øystein Grøvlen commented on DERBY-2212:
I agree with Mike that it seems a bit complicated an error prone to
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12535982
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
I'm original reporter :)
DB2-like approach I have suggest
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536039
]
Øystein Grøvlen commented on DERBY-2212:
To my previous comment: I was rather confused when I asked whether w
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536362
]
Øystein Grøvlen commented on DERBY-2212:
I do not see how changing the existing create unique index command t
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536255
]
Daniel John Debrunner commented on DERBY-2212:
--
I would recommend implementing the SQL standard behaviou
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536195
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
I guess to change behaviour of existing unique indexes/con
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536184
]
Øystein Grøvlen commented on DERBY-2212:
My previous comment assumed that creation is done in a more efficien
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536186
]
Anurag Shekhar commented on DERBY-2212:
---
Thanks Mike for the detailed input.
I will be attaching a functional s
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536178
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
Hello Mike,
concerning index and unique constraints - I d
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536165
]
Øystein Grøvlen commented on DERBY-2212:
Thank you Mike for taking the time to write down your clear thoughts
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536278
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
Keeping backward compatibility in this case shall be of mu
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536515
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
I may agree as far as we are speaking about single-column
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536931
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
Yes, unique constraint is not the same thing as unique ind
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536960
]
Øystein Grøvlen commented on DERBY-2212:
I agree that we should try to avoid incompatibilities with older rel
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12537001
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
To avoid user confusions current syntax should retain exis
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12537281
]
Anurag Shekhar commented on DERBY-2212:
---
thanks Mike for the comments. I will update the functional spec and up
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12538040
]
Kathey Marsden commented on DERBY-2212:
---
I have not been following this conversation in detail but did look at
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12538063
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
This change not "would" but "may" introduce incompatibilit
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12539048
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
New version of specification looks much better, but still
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12539050
]
Øystein Grøvlen commented on DERBY-2212:
Thanks for the new version of the func spec, Anurag.
In this versio
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12539841
]
Anurag Shekhar commented on DERBY-2212:
---
thanks Øystein, for the review and trying out the patch.
1. I do
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12540704
]
Anurag Shekhar commented on DERBY-2212:
---
sorry about the duplicate comment. Initially I had added the comment b
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12540705
]
Anurag Shekhar commented on DERBY-2212:
---
thanks Oleksandr and Øystein for the feed back. In this new version I
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12540728
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
Anurag,
There are still hordes of typos (both in the func
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12540822
]
Anurag Shekhar commented on DERBY-2212:
---
>In my opinion ithe functional specification must point that for time
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543859
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
>functional spec shouldn't have any reference index specia
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12544013
]
Oleksandr Alesinskyy commented on DERBY-2212:
-
Initial request (filed by me) was to allow "unique when no
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12544809
]
Øystein Grøvlen commented on DERBY-2212:
Thanks, for the updated func spec, Anurag.
I agree with the others
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12658210#action_12658210
]
Uwe Kubosch commented on DERBY-2212:
I have reread the previous comment a dozen times,
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12658480#action_12658480
]
Knut Anders Hatlen commented on DERBY-2212:
---
Uwe,
You can create such a constrai
[
https://issues.apache.org/jira/browse/DERBY-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12658489#action_12658489
]
Uwe Kubosch commented on DERBY-2212:
Thank you for the example! That helps a lot!
I s
57 matches
Mail list logo
