Return-Path: X-Original-To: apmail-cassandra-commits-archive@www.apache.org Delivered-To: apmail-cassandra-commits-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 2A5B010EF8 for ; Tue, 17 Dec 2013 16:09:04 +0000 (UTC) Received: (qmail 70905 invoked by uid 500); 17 Dec 2013 16:07:36 -0000 Delivered-To: apmail-cassandra-commits-archive@cassandra.apache.org Received: (qmail 70765 invoked by uid 500); 17 Dec 2013 16:07:20 -0000 Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cassandra.apache.org Delivered-To: mailing list commits@cassandra.apache.org Received: (qmail 70706 invoked by uid 99); 17 Dec 2013 16:07:17 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 17 Dec 2013 16:07:17 +0000 Date: Tue, 17 Dec 2013 16:07:16 +0000 (UTC) From: "Sylvain Lebresne (JIRA)" To: commits@cassandra.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (CASSANDRA-4911) Lift limitation that order by columns must be selected for IN queries MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CASSANDRA-4911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sylvain Lebresne updated CASSANDRA-4911: ---------------------------------------- Attachment: 4911.txt Attaching patch on trunk for this. Since no-one complained about this so far and since it's slightly risky, let's target that to 2.1. We do need it a bit more in 2.1 following CASSANDRA-5417 (as explained in this ticket, we have one dtest failure otherwise). > Lift limitation that order by columns must be selected for IN queries > --------------------------------------------------------------------- > > Key: CASSANDRA-4911 > URL: https://issues.apache.org/jira/browse/CASSANDRA-4911 > Project: Cassandra > Issue Type: Improvement > Affects Versions: 1.2.0 beta 1 > Reporter: Sylvain Lebresne > Priority: Minor > Fix For: 2.1 > > Attachments: 4911.txt > > > This is the followup of CASSANDRA-4645. We should remove the limitation that for IN queries, you must have columns on which you have an ORDER BY in the select clause. > For that, we'll need to automatically add the columns on which we have an ORDER BY to the one queried internally, and remove it afterwards (once the sorting is done) from the resultSet. -- This message was sent by Atlassian JIRA (v6.1.4#6159)