[jira] [Commented] (CASSANDRA-4744) Non-escaped single quotes causes CQL to hang
[ https://issues.apache.org/jira/browse/CASSANDRA-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13467791#comment-13467791 ] Jason Wellonen commented on CASSANDRA-4744: --- The problem is, a client that implemented execute_cql cannot recover from this. My application just pauses indefinitely. Do you have a recommendation to work around this problem? Even the cqlsh utility does not handle this condition gracefully. When you are presented with the ellipses, what do you enter to complete the input? Non-escaped single quotes causes CQL to hang Key: CASSANDRA-4744 URL: https://issues.apache.org/jira/browse/CASSANDRA-4744 Project: Cassandra Issue Type: Improvement Environment: Cassandra 1.1.5, RHEL 6.3 x86_64 Reporter: Jason Wellonen Single quotes in string literals cause CQL to wait indefinitely. This behavior is inherited by clients implementing execute_cql. The end result is a client application that stops responding. For example, the following is entered in cqlsh (notice the ellipses): cqlsh:Keyspace1 INSERT INTO Test1 (testId, test1) VALUES (1566bb5d-9093-4abd-bcaa-e1ac90b94a47, 'This is a test with Cassandra's reserved characters') USING CONSISTENCY LOCAL_QUORUM; ... This continues until ctrl-c is issued. I would expect a Bad Request message returned immediately, which is the behavior here: cqlsh:Keyspace1 INSERT INTO Test1 (testId, test1) VALUES (7dcf9529-b57b-4d1d-a396-cff9bc98abb2, 'This is a test without the closing parenthesis in the values section of the insert statement.' USING CONSISTENCY LOCAL_QUORUM; Bad Request: line 1:176 missing ')' at 'USING' -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4744) Non-escaped single quotes causes CQL to hang
[ https://issues.apache.org/jira/browse/CASSANDRA-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13467799#comment-13467799 ] Sylvain Lebresne commented on CASSANDRA-4744: - bq. The problem is, a client that implemented execute_cql cannot recover from this. My application just pauses indefinitely. Do you have a precise example? Because I'm not able to reproduce that part (I get a Bad Request: line 1:72 mismatched character 'EOF' expecting ''' right away, which describe correctly the problem). To be clear, I'm not contesting that cqlsh does that (have you tried a ctrld-D to complete the input?). Non-escaped single quotes causes CQL to hang Key: CASSANDRA-4744 URL: https://issues.apache.org/jira/browse/CASSANDRA-4744 Project: Cassandra Issue Type: Improvement Environment: Cassandra 1.1.5, RHEL 6.3 x86_64 Reporter: Jason Wellonen Single quotes in string literals cause CQL to wait indefinitely. This behavior is inherited by clients implementing execute_cql. The end result is a client application that stops responding. For example, the following is entered in cqlsh (notice the ellipses): cqlsh:Keyspace1 INSERT INTO Test1 (testId, test1) VALUES (1566bb5d-9093-4abd-bcaa-e1ac90b94a47, 'This is a test with Cassandra's reserved characters') USING CONSISTENCY LOCAL_QUORUM; ... This continues until ctrl-c is issued. I would expect a Bad Request message returned immediately, which is the behavior here: cqlsh:Keyspace1 INSERT INTO Test1 (testId, test1) VALUES (7dcf9529-b57b-4d1d-a396-cff9bc98abb2, 'This is a test without the closing parenthesis in the values section of the insert statement.' USING CONSISTENCY LOCAL_QUORUM; Bad Request: line 1:176 missing ')' at 'USING' -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
[jira] [Commented] (CASSANDRA-4744) Non-escaped single quotes causes CQL to hang
[ https://issues.apache.org/jira/browse/CASSANDRA-4744?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=13467971#comment-13467971 ] Brandon Williams commented on CASSANDRA-4744: - bq. Even the cqlsh utility does not handle this condition gracefully. When you are presented with the ellipses, what do you enter to complete the input? You close the incomplete quoting. Non-escaped single quotes causes CQL to hang Key: CASSANDRA-4744 URL: https://issues.apache.org/jira/browse/CASSANDRA-4744 Project: Cassandra Issue Type: Improvement Environment: Cassandra 1.1.5, RHEL 6.3 x86_64 Reporter: Jason Wellonen Single quotes in string literals cause CQL to wait indefinitely. This behavior is inherited by clients implementing execute_cql. The end result is a client application that stops responding. For example, the following is entered in cqlsh (notice the ellipses): cqlsh:Keyspace1 INSERT INTO Test1 (testId, test1) VALUES (1566bb5d-9093-4abd-bcaa-e1ac90b94a47, 'This is a test with Cassandra's reserved characters') USING CONSISTENCY LOCAL_QUORUM; ... This continues until ctrl-c is issued. I would expect a Bad Request message returned immediately, which is the behavior here: cqlsh:Keyspace1 INSERT INTO Test1 (testId, test1) VALUES (7dcf9529-b57b-4d1d-a396-cff9bc98abb2, 'This is a test without the closing parenthesis in the values section of the insert statement.' USING CONSISTENCY LOCAL_QUORUM; Bad Request: line 1:176 missing ')' at 'USING' -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira
