Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Wed, 10 Feb 2016 18:56:18 +0000 (UTC)
From: "sequoyha pelletier (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.12938255.1455126273000.19029.1455130578077@Atlassian.JIRA>
In-Reply-To: <JIRA.12938255.1455126273000@Atlassian.JIRA>
References: <JIRA.12938255.1455126273000@Atlassian.JIRA>
 <JIRA.12938255.1455126273460@arcas>
Subject: [jira] [Updated] (CASSANDRA-11152) SOURCE command in CQLSH 3.2
 requires that "use keyspace" is in the cql file that you are sourcing
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


     [ https://issues.apache.org/jira/browse/CASSANDRA-11152?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

sequoyha pelletier updated CASSANDRA-11152:
-------------------------------------------
    Labels:   (was: patch)

> SOURCE command in CQLSH 3.2 requires that "use keyspace" is in the cql file that you are sourcing
> -------------------------------------------------------------------------------------------------
>
>                 Key: CASSANDRA-11152
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-11152
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL
>         Environment: CQLSH 3.2.1
>            Reporter: Francesco Animali
>
> a difference in behaviour between SOURCE command in CQLSH 3.1 and 3.2. 
> In CQLSH 3.1 SOURCE will NOT require "use keyspace" in the cql file that you execute: the "keyspace" directive in the qlshrc file will work and the cql file will be executed.
> In CQLSH 3.2.1, SOURCE command requires that "use keyspace" is in the cql file that you are sourcing, otherwise it throws this error:
> "No keyspace has been specified. USE a keyspace, or explicitly specify keyspace.tablename". 
> The "keyspace" directive in cqlshrc is overridden by source command.
> steps to reproduce:
> create a file called select.cql in your home directory:
> {noformat}
> echo "CONSISTENCY ONE;" > select.cql
> echo "select * from tab;" >> select.cql
> {noformat}
> in cqlsh:
> {noformat}
> create KEYSPACE kspace WITH replication = {'class': 'SimpleStrategy', 'replication_factor': 1};
> create TABLE tab ( id int primary key);
> insert into tab (id) VALUES ( 1);
> {noformat}
> Add this to cqlsgrc:
> {noformat}
> [authentication]
> keyspace = kspace
> {noformat}
> Then exit cqlsh and rerun cqlsh using the cqlshrc just modified.
> Note that you are in keyspace "kspace".
> execute:
> {noformat}
> source 'select.cql' 
> {noformat}
> this will have different behaviour in CQLSH 3.2 and 3.1


--
This message was sent by Atlassian JIRA
(v6.3.4#6332)