[ https://issues.apache.org/jira/browse/CASSANDRA-13864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Joel Knighton resolved CASSANDRA-13864. --------------------------------------- Resolution: Invalid This JIRA is for the Apache Cassandra project. I don't believe this issue is reproducible in Apache Cassandra. You should report issues in DataStax products to DataStax. > Failure to execute cql script using cqlsh with nested SOURCE on cassandra > 3.11.0 > --------------------------------------------------------------------------------- > > Key: CASSANDRA-13864 > URL: https://issues.apache.org/jira/browse/CASSANDRA-13864 > 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 (based > on DSE 4.8.10). > The script include nested use of the SOURCE command. > {code:title=1.sql|borderStyle=solid} > USE test; > SOURCE '2.sql' > exit; > {code} > {code:title=2.sql|borderStyle=solid} > SELECT count(1) FROM user; > SOURCE '3.sql'; > {code} > {code:title=3.sql|borderStyle=solid} > SELECT count(1) FROM user; > {code} > When executing this script with DSE 4.8.10 it runs correctly and output > {code:title=cassandra 2.1.15|borderStyle=none} > cqlsh –f 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=cassandra 3.11.0|borderStyle=none} > cqlsh –f 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: > 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-unsubscr...@cassandra.apache.org For additional commands, e-mail: commits-h...@cassandra.apache.org