[jira] [Commented] (CASSANDRA-12654) Query Validation Error : CQL IN operator over last partitioning|clustering column (valid) is rejected if a query fetches collection columns
[ https://issues.apache.org/jira/browse/CASSANDRA-12654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16857812#comment-16857812 ] Konstantin Voznesenskiy commented on CASSANDRA-12654: - Hello guys, Is there any chance this fix will make it to 3.11.5 instead of 4.0 ? It seems rather straight-forward. > Query Validation Error : CQL IN operator over last partitioning|clustering > column (valid) is rejected if a query fetches collection columns > --- > > Key: CASSANDRA-12654 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12654 > Project: Cassandra > Issue Type: Improvement > Components: Legacy/CQL >Reporter: Samba Siva Rao Kolusu >Assignee: Alex Petrov >Priority: Low > Labels: easyfix > Fix For: 4.0 > > > although IN operator is allowed over the last clustering or partitioning > columns, the CQL Query Validator is rejecting queries when they attempt to > fetch collection columns in their result set. > It seems a similar bug (CASSANDRA-5376) was raised some time ago, and a fix > (rather mask) was provided to give a better error message to such queries in > 1.2.4. > Considering that Cassandra & CQL has evolved a great deal from that period, > it now seems possible to provide an actual fix to this problem, i.e. allowing > queries to fetch collection columns even when IN operator is used. > please read the following mail thread to understand the context : > https://lists.apache.org/thread.html/8e1765d14bd9798bf9c0938a793f1dbc9c9349062a8705db2e28d291@%3Cuser.cassandra.apache.org%3E -- This message was sent by Atlassian JIRA (v7.6.3#76005) - To unsubscribe, e-mail: commits-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org
[jira] [Commented] (CASSANDRA-12654) Query Validation Error : CQL IN operator over last partitioning|clustering column (valid) is rejected if a query fetches collection columns
[
https://issues.apache.org/jira/browse/CASSANDRA-12654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15761358#comment-15761358
]
Benjamin Lerer commented on CASSANDRA-12654:
+1
Thanks for the patch. I just removed {{Selection::containsAComplexColumn}} as
it was not used anymore and modified the unit test to also test {{frozen}}
collections.
> Query Validation Error : CQL IN operator over last partitioning|clustering
> column (valid) is rejected if a query fetches collection columns
> ---
>
> Key: CASSANDRA-12654
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12654
> Project: Cassandra
> Issue Type: Bug
> Components: CQL
>Reporter: Samba Siva Rao Kolusu
>Assignee: Alex Petrov
>Priority: Minor
> Labels: easyfix
> Fix For: 3.0.x, 3.x, 4.x
>
>
> although IN operator is allowed over the last clustering or partitioning
> columns, the CQL Query Validator is rejecting queries when they attempt to
> fetch collection columns in their result set.
> It seems a similar bug (CASSANDRA-5376) was raised some time ago, and a fix
> (rather mask) was provided to give a better error message to such queries in
> 1.2.4.
> Considering that Cassandra & CQL has evolved a great deal from that period,
> it now seems possible to provide an actual fix to this problem, i.e. allowing
> queries to fetch collection columns even when IN operator is used.
> please read the following mail thread to understand the context :
> https://lists.apache.org/thread.html/8e1765d14bd9798bf9c0938a793f1dbc9c9349062a8705db2e28d291@%3Cuser.cassandra.apache.org%3E
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12654) Query Validation Error : CQL IN operator over last partitioning|clustering column (valid) is rejected if a query fetches collection columns
[
https://issues.apache.org/jira/browse/CASSANDRA-12654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15741564#comment-15741564
]
Benjamin Lerer commented on CASSANDRA-12654:
The ticket is still marked as {{Unresolved}}. It means that the problem as not
been fixed yet in any C* version.
Alex has summitted a patch which is why the ticket is marked has "Patch
Available". Once the reviewer will have reviewed the patch and agreed with it
the patch will be committed and the resolution as well as the fix version will
be updated.
> Query Validation Error : CQL IN operator over last partitioning|clustering
> column (valid) is rejected if a query fetches collection columns
> ---
>
> Key: CASSANDRA-12654
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12654
> Project: Cassandra
> Issue Type: Bug
> Components: CQL
>Reporter: Samba Siva Rao Kolusu
>Assignee: Alex Petrov
>Priority: Minor
> Labels: easyfix
> Fix For: 3.0.x, 3.x, 4.x
>
>
> although IN operator is allowed over the last clustering or partitioning
> columns, the CQL Query Validator is rejecting queries when they attempt to
> fetch collection columns in their result set.
> It seems a similar bug (CASSANDRA-5376) was raised some time ago, and a fix
> (rather mask) was provided to give a better error message to such queries in
> 1.2.4.
> Considering that Cassandra & CQL has evolved a great deal from that period,
> it now seems possible to provide an actual fix to this problem, i.e. allowing
> queries to fetch collection columns even when IN operator is used.
> please read the following mail thread to understand the context :
> https://lists.apache.org/thread.html/8e1765d14bd9798bf9c0938a793f1dbc9c9349062a8705db2e28d291@%3Cuser.cassandra.apache.org%3E
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12654) Query Validation Error : CQL IN operator over last partitioning|clustering column (valid) is rejected if a query fetches collection columns
[ https://issues.apache.org/jira/browse/CASSANDRA-12654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15741157#comment-15741157 ] Dhruv commented on CASSANDRA-12654: --- i am using cassandra 3.9 and still facing this issue. Can you please tell which cassandra version this issue has been fixed? Is there any seperate patch that I need to install. > Query Validation Error : CQL IN operator over last partitioning|clustering > column (valid) is rejected if a query fetches collection columns > --- > > Key: CASSANDRA-12654 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12654 > Project: Cassandra > Issue Type: Bug > Components: CQL >Reporter: Samba Siva Rao Kolusu >Assignee: Alex Petrov >Priority: Minor > Labels: easyfix > Fix For: 3.0.x, 3.x, 4.x > > > although IN operator is allowed over the last clustering or partitioning > columns, the CQL Query Validator is rejecting queries when they attempt to > fetch collection columns in their result set. > It seems a similar bug (CASSANDRA-5376) was raised some time ago, and a fix > (rather mask) was provided to give a better error message to such queries in > 1.2.4. > Considering that Cassandra & CQL has evolved a great deal from that period, > it now seems possible to provide an actual fix to this problem, i.e. allowing > queries to fetch collection columns even when IN operator is used. > please read the following mail thread to understand the context : > https://lists.apache.org/thread.html/8e1765d14bd9798bf9c0938a793f1dbc9c9349062a8705db2e28d291@%3Cuser.cassandra.apache.org%3E -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12654) Query Validation Error : CQL IN operator over last partitioning|clustering column (valid) is rejected if a query fetches collection columns
[ https://issues.apache.org/jira/browse/CASSANDRA-12654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15627987#comment-15627987 ] Samba Siva Rao Kolusu commented on CASSANDRA-12654: --- This is what Tyler Hobbs said: However, it seems like this would be possible to support in Cassandra 3.x. We probably just need to remove the check and verify that it actually works. Can you open a new JIRA ticket for this? seems like the 'code limitation' mentioned in CASSANDRA-5230 or CASSANDRA-4762 has gone away. could you please verify if it is really not possible 'at the moment' for 3.x branch, and if possible could you also identify what needs to be changed/added/removed to allow this 'feature'? Thanks, Samba > Query Validation Error : CQL IN operator over last partitioning|clustering > column (valid) is rejected if a query fetches collection columns > --- > > Key: CASSANDRA-12654 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12654 > Project: Cassandra > Issue Type: Bug > Components: CQL >Reporter: Samba Siva Rao Kolusu >Assignee: Alex Petrov >Priority: Minor > Labels: easyfix > Fix For: 3.x > > > although IN operator is allowed over the last clustering or partitioning > columns, the CQL Query Validator is rejecting queries when they attempt to > fetch collection columns in their result set. > It seems a similar bug (CASSANDRA-5376) was raised some time ago, and a fix > (rather mask) was provided to give a better error message to such queries in > 1.2.4. > Considering that Cassandra & CQL has evolved a great deal from that period, > it now seems possible to provide an actual fix to this problem, i.e. allowing > queries to fetch collection columns even when IN operator is used. > please read the following mail thread to understand the context : > https://lists.apache.org/thread.html/8e1765d14bd9798bf9c0938a793f1dbc9c9349062a8705db2e28d291@%3Cuser.cassandra.apache.org%3E -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12654) Query Validation Error : CQL IN operator over last partitioning|clustering column (valid) is rejected if a query fetches collection columns
[ https://issues.apache.org/jira/browse/CASSANDRA-12654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15601775#comment-15601775 ] Benjamin Lerer commented on CASSANDRA-12654: CASSANDRA-5376 -> it seems that the problem was due to a code limitation. That is why Tyler suggested in its email to try to see if it now works (after CASSANDRA-8099). > Query Validation Error : CQL IN operator over last partitioning|clustering > column (valid) is rejected if a query fetches collection columns > --- > > Key: CASSANDRA-12654 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12654 > Project: Cassandra > Issue Type: Bug > Components: CQL >Reporter: Samba Siva Rao Kolusu >Assignee: Alex Petrov >Priority: Minor > Labels: easyfix > Fix For: 3.x > > > although IN operator is allowed over the last clustering or partitioning > columns, the CQL Query Validator is rejecting queries when they attempt to > fetch collection columns in their result set. > It seems a similar bug (CASSANDRA-5376) was raised some time ago, and a fix > (rather mask) was provided to give a better error message to such queries in > 1.2.4. > Considering that Cassandra & CQL has evolved a great deal from that period, > it now seems possible to provide an actual fix to this problem, i.e. allowing > queries to fetch collection columns even when IN operator is used. > please read the following mail thread to understand the context : > https://lists.apache.org/thread.html/8e1765d14bd9798bf9c0938a793f1dbc9c9349062a8705db2e28d291@%3Cuser.cassandra.apache.org%3E -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12654) Query Validation Error : CQL IN operator over last partitioning|clustering column (valid) is rejected if a query fetches collection columns
[
https://issues.apache.org/jira/browse/CASSANDRA-12654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15601766#comment-15601766
]
DOAN DuyHai commented on CASSANDRA-12654:
-
Because we need to understand the *rationale* to forbid selecting collections
when using {{IN}} clause with _clustering columns_
> Query Validation Error : CQL IN operator over last partitioning|clustering
> column (valid) is rejected if a query fetches collection columns
> ---
>
> Key: CASSANDRA-12654
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12654
> Project: Cassandra
> Issue Type: Bug
> Components: CQL
>Reporter: Samba Siva Rao Kolusu
>Assignee: Alex Petrov
>Priority: Minor
> Labels: easyfix
> Fix For: 3.x
>
>
> although IN operator is allowed over the last clustering or partitioning
> columns, the CQL Query Validator is rejecting queries when they attempt to
> fetch collection columns in their result set.
> It seems a similar bug (CASSANDRA-5376) was raised some time ago, and a fix
> (rather mask) was provided to give a better error message to such queries in
> 1.2.4.
> Considering that Cassandra & CQL has evolved a great deal from that period,
> it now seems possible to provide an actual fix to this problem, i.e. allowing
> queries to fetch collection columns even when IN operator is used.
> please read the following mail thread to understand the context :
> https://lists.apache.org/thread.html/8e1765d14bd9798bf9c0938a793f1dbc9c9349062a8705db2e28d291@%3Cuser.cassandra.apache.org%3E
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12654) Query Validation Error : CQL IN operator over last partitioning|clustering column (valid) is rejected if a query fetches collection columns
[ https://issues.apache.org/jira/browse/CASSANDRA-12654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15601761#comment-15601761 ] Benjamin Lerer commented on CASSANDRA-12654: [~doanduyhai] I am not sure why you want to find the commit that introduced that check. > Query Validation Error : CQL IN operator over last partitioning|clustering > column (valid) is rejected if a query fetches collection columns > --- > > Key: CASSANDRA-12654 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12654 > Project: Cassandra > Issue Type: Bug > Components: CQL >Reporter: Samba Siva Rao Kolusu >Assignee: Alex Petrov >Priority: Minor > Labels: easyfix > Fix For: 3.x > > > although IN operator is allowed over the last clustering or partitioning > columns, the CQL Query Validator is rejecting queries when they attempt to > fetch collection columns in their result set. > It seems a similar bug (CASSANDRA-5376) was raised some time ago, and a fix > (rather mask) was provided to give a better error message to such queries in > 1.2.4. > Considering that Cassandra & CQL has evolved a great deal from that period, > it now seems possible to provide an actual fix to this problem, i.e. allowing > queries to fetch collection columns even when IN operator is used. > please read the following mail thread to understand the context : > https://lists.apache.org/thread.html/8e1765d14bd9798bf9c0938a793f1dbc9c9349062a8705db2e28d291@%3Cuser.cassandra.apache.org%3E -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12654) Query Validation Error : CQL IN operator over last partitioning|clustering column (valid) is rejected if a query fetches collection columns
[ https://issues.apache.org/jira/browse/CASSANDRA-12654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15601618#comment-15601618 ] DOAN DuyHai commented on CASSANDRA-12654: - Ok so we need to dig further in the Git history to find the original commit > Query Validation Error : CQL IN operator over last partitioning|clustering > column (valid) is rejected if a query fetches collection columns > --- > > Key: CASSANDRA-12654 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12654 > Project: Cassandra > Issue Type: Bug > Components: CQL >Reporter: Samba Siva Rao Kolusu >Assignee: Alex Petrov >Priority: Minor > Labels: easyfix > Fix For: 3.x > > > although IN operator is allowed over the last clustering or partitioning > columns, the CQL Query Validator is rejecting queries when they attempt to > fetch collection columns in their result set. > It seems a similar bug (CASSANDRA-5376) was raised some time ago, and a fix > (rather mask) was provided to give a better error message to such queries in > 1.2.4. > Considering that Cassandra & CQL has evolved a great deal from that period, > it now seems possible to provide an actual fix to this problem, i.e. allowing > queries to fetch collection columns even when IN operator is used. > please read the following mail thread to understand the context : > https://lists.apache.org/thread.html/8e1765d14bd9798bf9c0938a793f1dbc9c9349062a8705db2e28d291@%3Cuser.cassandra.apache.org%3E -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12654) Query Validation Error : CQL IN operator over last partitioning|clustering column (valid) is rejected if a query fetches collection columns
[ https://issues.apache.org/jira/browse/CASSANDRA-12654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15601409#comment-15601409 ] Benjamin Lerer commented on CASSANDRA-12654: The restriction was already there. The refactoring simply moved it. > Query Validation Error : CQL IN operator over last partitioning|clustering > column (valid) is rejected if a query fetches collection columns > --- > > Key: CASSANDRA-12654 > URL: https://issues.apache.org/jira/browse/CASSANDRA-12654 > Project: Cassandra > Issue Type: Bug > Components: CQL >Reporter: Samba Siva Rao Kolusu >Assignee: Alex Petrov >Priority: Minor > Labels: easyfix > Fix For: 3.x > > > although IN operator is allowed over the last clustering or partitioning > columns, the CQL Query Validator is rejecting queries when they attempt to > fetch collection columns in their result set. > It seems a similar bug (CASSANDRA-5376) was raised some time ago, and a fix > (rather mask) was provided to give a better error message to such queries in > 1.2.4. > Considering that Cassandra & CQL has evolved a great deal from that period, > it now seems possible to provide an actual fix to this problem, i.e. allowing > queries to fetch collection columns even when IN operator is used. > please read the following mail thread to understand the context : > https://lists.apache.org/thread.html/8e1765d14bd9798bf9c0938a793f1dbc9c9349062a8705db2e28d291@%3Cuser.cassandra.apache.org%3E -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Commented] (CASSANDRA-12654) Query Validation Error : CQL IN operator over last partitioning|clustering column (valid) is rejected if a query fetches collection columns
[
https://issues.apache.org/jira/browse/CASSANDRA-12654?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15599554#comment-15599554
]
DOAN DuyHai commented on CASSANDRA-12654:
-
This restriction on collections when using {{IN}} clause for clustering columns
has been committed as part of CASSANDRA-7981.
Ping [~blerer] for more details
> Query Validation Error : CQL IN operator over last partitioning|clustering
> column (valid) is rejected if a query fetches collection columns
> ---
>
> Key: CASSANDRA-12654
> URL: https://issues.apache.org/jira/browse/CASSANDRA-12654
> Project: Cassandra
> Issue Type: Bug
> Components: CQL
>Reporter: Samba Siva Rao Kolusu
>Assignee: Alex Petrov
>Priority: Minor
> Labels: easyfix
> Fix For: 3.x
>
>
> although IN operator is allowed over the last clustering or partitioning
> columns, the CQL Query Validator is rejecting queries when they attempt to
> fetch collection columns in their result set.
> It seems a similar bug (CASSANDRA-5376) was raised some time ago, and a fix
> (rather mask) was provided to give a better error message to such queries in
> 1.2.4.
> Considering that Cassandra & CQL has evolved a great deal from that period,
> it now seems possible to provide an actual fix to this problem, i.e. allowing
> queries to fetch collection columns even when IN operator is used.
> please read the following mail thread to understand the context :
> https://lists.apache.org/thread.html/8e1765d14bd9798bf9c0938a793f1dbc9c9349062a8705db2e28d291@%3Cuser.cassandra.apache.org%3E
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
