[
https://issues.apache.org/jira/browse/CASSANDRA-17667?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17846493#comment-17846493
]
Brad Schoening edited comment on CASSANDRA-17667 at 5/24/24 6:31 PM:
---------------------------------------------------------------------
[~bereng] I have updated the PR with a test string for */. There already exists
{code:java}
'SELECT FROM "/*MyTable*/";'
'SELECT FROM /*
comment block starts here;
and continues here
*/ "MyTable';
' /* comment block */
/* another comment */ SELECT FROM /*
comment block starts here;
and continues here
*/ "MyTable';
' '
'SELECT FROM /* \n comment block starts here; \n and continues here \n */
"MyTable";'
{code}
I looked up pg-style quoted equivalents means, and see that was added in
CASSANDRA-7769
was (Author: bschoeni):
[~bereng] I have updated the PR with a test string for */. There already exists
{code:java}
'SELECT FROM "/*MyTable*/";'
'SELECT FROM /*
comment block starts here;
and continues here
*/ "MyTable';
' /* comment block */
/* another comment */ SELECT FROM /*
comment block starts here;
and continues here
*/ "MyTable';
' '
'SELECT FROM /* \n comment block starts here; \n and continues here \n */
"MyTable";'
{code}
I looked up pg-style quoted equivalents means, and see that was added in [link
CASSANDRA-7769|https://issues.apache.org/jira/browse/CASSANDRA-7769]
> Text value containing "/*" interpreted as multiline comment in cqlsh
> --------------------------------------------------------------------
>
> Key: CASSANDRA-17667
> URL: https://issues.apache.org/jira/browse/CASSANDRA-17667
> Project: Cassandra
> Issue Type: Bug
> Components: CQL/Interpreter
> Reporter: ANOOP THOMAS
> Assignee: Brad Schoening
> Priority: Normal
> Fix For: 4.0.x, 4.1.x, 5.0.x, 5.x
>
>
> I use CQLSH command line utility to load some DDLs. The version of utility I
> use is this:
> {noformat}
> [cqlsh 6.0.0 | Cassandra 4.0.0.47 | CQL spec 3.4.5 | Native protocol
> v5]{noformat}
> Command that loads DDL.cql:
> {noformat}
> cqlsh -u username -p password cassandra.example.com 65503 --ssl -f DDL.cql
> {noformat}
> I have a line in CQL script that breaks the syntax.
> {noformat}
> INSERT into tablename (key,columnname1,columnname2) VALUES
> ('keyName','value1','/value2/*/value3');{noformat}
> {{/*}} 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:
> {noformat}
> 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 '(' ([(]...)
> {noformat}
> Same behavior while running in interactive mode too. {{/*}} inside a CQL
> statement should not be interpreted as start of multi-line comment.
> With schema:
> {code:java}
> CREATE TABLE tablename ( key text primary key, columnname1 text, columnname2
> text);{code}
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
