You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Dave Brosius (JIRA)" <ji...@apache.org> on 2012/06/08 01:29:22 UTC
[jira] [Created] (CASSANDRA-4319) ex msg for cql3 order by
constraints says primary filter can be an IN clause which is misleading
Dave Brosius created CASSANDRA-4319:
---------------------------------------
Summary: ex msg for cql3 order by constraints says primary filter can be an IN clause which is misleading
Key: CASSANDRA-4319
URL: https://issues.apache.org/jira/browse/CASSANDRA-4319
Project: Cassandra
Issue Type: Improvement
Components: Core
Affects Versions: 1.2
Reporter: Dave Brosius
Priority: Trivial
Fix For: 1.2
Attachments: better_order_restriction_error_msg.txt
select * from visitor_audit where visitor_id in ('1_172892701', '1_316755431') order by audit_id desc limit 6;
gives error
Bad Request: Ordering is only supported is the first part of the PRIMARY KEY is restricted by an Equal or a IN
which seems to be what the query is doing.
But it only supports Equal, fix error message.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4319) ex msg for cql3 order by
constraints says primary filter can be an IN clause which is misleading
Posted by "Sylvain Lebresne (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13291619#comment-13291619 ]
Sylvain Lebresne commented on CASSANDRA-4319:
---------------------------------------------
Yeah, IN was disallowed "recently" but I forgot to update the error message.
+1 (I believe this affect 1.1 too though).
> ex msg for cql3 order by constraints says primary filter can be an IN clause which is misleading
> -------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-4319
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4319
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.2
> Reporter: Dave Brosius
> Assignee: Dave Brosius
> Priority: Trivial
> Fix For: 1.2
>
> Attachments: better_order_restriction_error_msg.txt
>
>
> select * from visitor_audit where visitor_id in ('1_172892701', '1_316755431') order by audit_id desc limit 6;
> gives error
> Bad Request: Ordering is only supported is the first part of the PRIMARY KEY is restricted by an Equal or a IN
> which seems to be what the query is doing.
> But it only supports Equal, fix error message.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Resolved] (CASSANDRA-4319) ex msg for cql3 order by
constraints says primary filter can be an IN clause which is misleading
Posted by "Dave Brosius (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Brosius resolved CASSANDRA-4319.
-------------------------------------
Resolution: Fixed
> ex msg for cql3 order by constraints says primary filter can be an IN clause which is misleading
> -------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-4319
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4319
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.1.1
> Reporter: Dave Brosius
> Assignee: Dave Brosius
> Priority: Trivial
> Fix For: 1.1.2
>
> Attachments: better_order_restriction_error_msg.txt
>
>
> select * from visitor_audit where visitor_id in ('1_172892701', '1_316755431') order by audit_id desc limit 6;
> gives error
> Bad Request: Ordering is only supported is the first part of the PRIMARY KEY is restricted by an Equal or a IN
> which seems to be what the query is doing.
> But it only supports Equal, fix error message.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-4319) ex msg for cql3 order by
constraints says primary filter can be an IN clause which is misleading
Posted by "Dave Brosius (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Brosius updated CASSANDRA-4319:
------------------------------------
Assignee: Eric Evans
> ex msg for cql3 order by constraints says primary filter can be an IN clause which is misleading
> -------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-4319
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4319
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.2
> Reporter: Dave Brosius
> Assignee: Eric Evans
> Priority: Trivial
> Fix For: 1.2
>
> Attachments: better_order_restriction_error_msg.txt
>
>
> select * from visitor_audit where visitor_id in ('1_172892701', '1_316755431') order by audit_id desc limit 6;
> gives error
> Bad Request: Ordering is only supported is the first part of the PRIMARY KEY is restricted by an Equal or a IN
> which seems to be what the query is doing.
> But it only supports Equal, fix error message.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-4319) ex msg for cql3 order by
constraints says primary filter can be an IN clause which is misleading
Posted by "Dave Brosius (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Brosius updated CASSANDRA-4319:
------------------------------------
Reviewer: urandom
> ex msg for cql3 order by constraints says primary filter can be an IN clause which is misleading
> -------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-4319
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4319
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.2
> Reporter: Dave Brosius
> Assignee: Dave Brosius
> Priority: Trivial
> Fix For: 1.2
>
> Attachments: better_order_restriction_error_msg.txt
>
>
> select * from visitor_audit where visitor_id in ('1_172892701', '1_316755431') order by audit_id desc limit 6;
> gives error
> Bad Request: Ordering is only supported is the first part of the PRIMARY KEY is restricted by an Equal or a IN
> which seems to be what the query is doing.
> But it only supports Equal, fix error message.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4319) ex msg for cql3 order by
constraints says primary filter can be an IN clause which is misleading
Posted by "Dave Brosius (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13292093#comment-13292093 ]
Dave Brosius commented on CASSANDRA-4319:
-----------------------------------------
committed to cassandra-1.1 as commit 8fd3f49e8469f0123a58b37243b3a2e1147fa51f
> ex msg for cql3 order by constraints says primary filter can be an IN clause which is misleading
> -------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-4319
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4319
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.2
> Reporter: Dave Brosius
> Assignee: Dave Brosius
> Priority: Trivial
> Fix For: 1.2
>
> Attachments: better_order_restriction_error_msg.txt
>
>
> select * from visitor_audit where visitor_id in ('1_172892701', '1_316755431') order by audit_id desc limit 6;
> gives error
> Bad Request: Ordering is only supported is the first part of the PRIMARY KEY is restricted by an Equal or a IN
> which seems to be what the query is doing.
> But it only supports Equal, fix error message.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-4319) ex msg for cql3 order by
constraints says primary filter can be an IN clause which is misleading
Posted by "Dave Brosius (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Brosius updated CASSANDRA-4319:
------------------------------------
Reviewer: slebresne (was: urandom)
Affects Version/s: (was: 1.2)
1.1.1
Fix Version/s: (was: 1.2)
1.1.2
> ex msg for cql3 order by constraints says primary filter can be an IN clause which is misleading
> -------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-4319
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4319
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.1.1
> Reporter: Dave Brosius
> Assignee: Dave Brosius
> Priority: Trivial
> Fix For: 1.1.2
>
> Attachments: better_order_restriction_error_msg.txt
>
>
> select * from visitor_audit where visitor_id in ('1_172892701', '1_316755431') order by audit_id desc limit 6;
> gives error
> Bad Request: Ordering is only supported is the first part of the PRIMARY KEY is restricted by an Equal or a IN
> which seems to be what the query is doing.
> But it only supports Equal, fix error message.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Assigned] (CASSANDRA-4319) ex msg for cql3 order by
constraints says primary filter can be an IN clause which is misleading
Posted by "Dave Brosius (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Brosius reassigned CASSANDRA-4319:
---------------------------------------
Assignee: Dave Brosius (was: Eric Evans)
> ex msg for cql3 order by constraints says primary filter can be an IN clause which is misleading
> -------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-4319
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4319
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.2
> Reporter: Dave Brosius
> Assignee: Dave Brosius
> Priority: Trivial
> Fix For: 1.2
>
> Attachments: better_order_restriction_error_msg.txt
>
>
> select * from visitor_audit where visitor_id in ('1_172892701', '1_316755431') order by audit_id desc limit 6;
> gives error
> Bad Request: Ordering is only supported is the first part of the PRIMARY KEY is restricted by an Equal or a IN
> which seems to be what the query is doing.
> But it only supports Equal, fix error message.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Updated] (CASSANDRA-4319) ex msg for cql3 order by
constraints says primary filter can be an IN clause which is misleading
Posted by "Dave Brosius (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/CASSANDRA-4319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Dave Brosius updated CASSANDRA-4319:
------------------------------------
Attachment: better_order_restriction_error_msg.txt
> ex msg for cql3 order by constraints says primary filter can be an IN clause which is misleading
> -------------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-4319
> URL: https://issues.apache.org/jira/browse/CASSANDRA-4319
> Project: Cassandra
> Issue Type: Improvement
> Components: Core
> Affects Versions: 1.2
> Reporter: Dave Brosius
> Priority: Trivial
> Fix For: 1.2
>
> Attachments: better_order_restriction_error_msg.txt
>
>
> select * from visitor_audit where visitor_id in ('1_172892701', '1_316755431') order by audit_id desc limit 6;
> gives error
> Bad Request: Ordering is only supported is the first part of the PRIMARY KEY is restricted by an Equal or a IN
> which seems to be what the query is doing.
> But it only supports Equal, fix error message.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira