[
https://issues.apache.org/jira/browse/CASSANDRA-10272?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14734835#comment-14734835
]
Sylvain Lebresne commented on CASSANDRA-10272:
----------------------------------------------
bq. Why not? cqlsh is capable to play external scripts and to accept statements
from stdin
Sure, and sorry if it sounded like I pretended otherwise. Using batches in
cqlsh is perfectly fine, and I'm sure this bug affect quite a few users and we
should absolutely fix it. But cqlsh is first an interactive tool and from my
experience is used most often for schema manipulation and simple querying,
which don't involve batches most of the time. I was merely trying to justify
not bumping the priority over 'major'. And truly, the fact there is a simple
work-around is the main argument for that.
> BATCH statement is broken in cqlsh
> ----------------------------------
>
> Key: CASSANDRA-10272
> URL: https://issues.apache.org/jira/browse/CASSANDRA-10272
> Project: Cassandra
> Issue Type: Bug
> Components: Core
> Environment: CentOS 7.1/x64
> Reporter: Vovodroid
> Assignee: Ryan McGuire
> Fix For: 2.2.x, 3.0.0 rc1
>
>
> BEGIN BATCH .... APPLY BATCH is not parsed correctly.
> Steps:
> {code}
> CREATE KEYSPACE Excelsior WITH
> REPLICATION={'class':'SimpleStrategy','replication_factor':1};
> CREATE TABLE excelsior.data (id int primary key);
> BEGIN BATCH INSERT INTO excelsior.data (id) VALUES (0); APPLY BATCH ;
> {code}
> Error
> {code}
> SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query]
> message="line 0:-1 mismatched input '<EOF>' expecting K_APPLY">
> SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query]
> message="line 1:0 no viable alternative at input 'APPLY' ([APPLY]...)">
> {code}
> While
> {code}
> BEGIN BATCH INSERT INTO excelsior.data (id) VALUES (0) APPLY BATCH ;
> {code}
> without *;* after insert works.
> Consequently neither
> {code}
> BEGIN BATCH INSERT INTO excelsior.data (id) VALUES (0);INSERT INTO
> excelsior.data (id) VALUES (0); APPLY BATCH ;
> {code}
> Error:
> {code}
> SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query]
> message="line 0:-1 mismatched input '<EOF>' expecting K_APPLY">
> SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query]
> message="line 1:0 no viable alternative at input 'APPLY' ([APPLY]...)">
> {code}
> nor
> {code}
> BEGIN BATCH INSERT INTO excelsior.data (id) VALUES (0);INSERT INTO
> excelsior.data (id) VALUES (0) APPLY BATCH ;
> {code}
> Error
> {code}
> SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query]
> message="line 0:-1 mismatched input '<EOF>' expecting K_APPLY">
> SyntaxException: <ErrorMessage code=2000 [Syntax error in CQL query]
> message="line 1:43 missing EOF at 'APPLY' (...(id) VALUES (0) [APPLY]
> BATCH...)">
> {code}
> works.
> It was OK in 2.2.0 and 3.0 beta 1.
> 3.0-beta2-tentative also affected.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
