Mailing-List: contact commits-help@cassandra.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@cassandra.apache.org
Date: Sun, 17 Sep 2017 04:47:00 +0000 (UTC)
From: "Haim Raman (JIRA)" <jira@apache.org>
To: commits@cassandra.apache.org
Message-ID: <JIRA.13101869.1505286245000.131224.1505623620188@Atlassian.JIRA>
In-Reply-To: <JIRA.13101869.1505286245000@Atlassian.JIRA>
References: <JIRA.13101869.1505286245000@Atlassian.JIRA> <JIRA.13101869.1505286245178@jira-lw-us.apache.org>
Subject: [jira] [Commented] (CASSANDRA-13864) Failure to execute cql script
  using cqlsh with nested SOURCE on cassandra 3.11.0
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
archived-at: Sun, 17 Sep 2017 04:47:05 -0000


    [ https://issues.apache.org/jira/browse/CASSANDRA-13864?page=3Dcom.atla=
ssian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=
=3D16169190#comment-16169190 ]=20

Haim Raman commented on CASSANDRA-13864:
----------------------------------------

Thanks Joel
You are right it was not reproducible in Apache Cassandra.=20


> Failure to execute cql script  using cqlsh with nested SOURCE on cassandr=
a 3.11.0
> -------------------------------------------------------------------------=
--------
>
>                 Key: CASSANDRA-13864
>                 URL: https://issues.apache.org/jira/browse/CASSANDRA-1386=
4
>             Project: Cassandra
>          Issue Type: Bug
>          Components: CQL
>         Environment: SUSE Linux Enterprise Server 12
> Python 2.7.7
>            Reporter: Haim Raman
>         Attachments: test.zip
>
>
> I have a script I used to execute queries and DDL on cassandra 2.1.15 (ba=
sed on DSE 4.8.10).
> The script include nested use of the SOURCE command.
> {code:title=3D1.sql|borderStyle=3Dsolid}
> USE test;
> SOURCE '2.sql'
> exit;
> {code}
> {code:title=3D2.sql|borderStyle=3Dsolid}
> SELECT count(1) FROM user;
> SOURCE '3.sql';
> {code}
> {code:title=3D3.sql|borderStyle=3Dsolid}
> SELECT count(1) FROM user;
> {code}
> When executing this script with DSE 4.8.10 it runs correctly and output
> {code:title=3Dcassandra  2.1.15|borderStyle=3Dnone}
> cqlsh =E2=80=93f  1.sql
> count
> --------
>  0
> (1 rows)
> count
> --------
>  0
> (1 rows)
> {code}
> Running the same script with cassandra 3.11.0 (based on DSE 5.1.2).
> {code:title=3Dcassandra  3.11.0|borderStyle=3Dnone}
> cqlsh =E2=80=93f  1.sql
>  count
> -------
>      0
> (1 rows)
> Warnings :
> Aggregation query used without partition key
> 2.sql:3:DSEShell instance has no attribute 'execution_profiles'
> {code}
> *The actual issue is that the script in 3.sql is not executed.*
> I did some additional investigations
> # With DSE-5.1.2 I switch the off to authenticator: AllowAllAuthenticator=
 authorizer: AllowAllAuthorizer, but I am still experiencing the issue
> # With DSE-5.0.9 (Cassandra 3.0.13.1735) it works
> h4.Steps to reproduce:=20
> Use the attached test.zip
> execute
> cqlsh -f  create_keyspace.sql
> cqlsh -f 1.sql


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org