[
https://issues.apache.org/jira/browse/CASSANDRA-17667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
ANOOP THOMAS updated CASSANDRA-17667:
-------------------------------------
Description:
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.
was:
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.
> /* 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: [email protected]
For additional commands, e-mail: [email protected]
