You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cassandra.apache.org by "Erick Ramirez (Jira)" <ji...@apache.org> on 2022/05/27 08:09:00 UTC
[jira] [Commented] (CASSANDRA-17667) /* string inside CQL statement is considered as start of multiline statement and breaks syntax
[ https://issues.apache.org/jira/browse/CASSANDRA-17667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17542824#comment-17542824 ]
Erick Ramirez commented on CASSANDRA-17667:
-------------------------------------------
[~nixtalker] thanks for logging the ticket. I did see [your question on Stack Overflow|https://stackoverflow.com/questions/72391377/] but I just haven't gotten around to testing it for myself yet.
Can you please confirm your Cassandra version? The reason I'm asking is I'm not familiar with version {{4.0.0.47}} -- note the *{color:#DE350B}.47{color}* at the end. Is it a fork?
> /* string inside CQL statement is considered as start of multiline statement and breaks syntax
> ----------------------------------------------------------------------------------------------
>
> Key: CASSANDRA-17667
> URL: https://issues.apache.org/jira/browse/CASSANDRA-17667
> Project: Cassandra
> Issue Type: Bug
> Components: CQL/Interpreter
> Reporter: ANOOP THOMAS
> Priority: Normal
>
> I use CQLSH command line utility to load some DDLs.
>
> The version of utility I use is this:
>
> {{[cqlsh 6.0.0 | Cassandra 4.0.0.47 | CQL spec 3.4.5 | Native protocol v5]}}
> Command that loads DDL.cql:
>
> {code:java}
> cqlsh -u username -p password cassandra.example.com 65503 --ssl -f DDL.cql{code}
> I have a line in CQL script that breaks the syntax.
> {code:java}
> INSERT into tablename (key,columnname1,columnname2) VALUES ('keyName','value1','/value2/*/value3');{code}
> {{ }}
> `/*` here is interpreted as start of multi-line comment. It used to work on older versions of cqlsh.
>
> The error I see looks like this:
>
> {code:java}
> SyntaxException: line 4:2 mismatched input 'Update' expecting ')' (...,'value1','/value2INSERT into tablename(INSERT into tablename (key,columnname1,columnname2)) VALUES ('[Update]-...) SyntaxException: line 1:0 no viable alternative at input '(' ([(]...)
>
> {code}
>
> Same behavior while running in interactive mode too.
>
> `/*` inside a CQL statement should not be interpreted as start of multi-line comment.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@cassandra.apache.org
For additional commands, e-mail: commits-help@cassandra.apache.org