beliefer edited a comment on issue #25001: [SPARK-28083][SQL] Support LIKE ... ESCAPE syntax URL: https://github.com/apache/spark/pull/25001#issuecomment-512091129 > Also, could you check the query below? Then, plz add some tests in `SQLQueryTestSuite`. > > ``` > scala> sql("""select * from t8 where a like b escape '"' """).show > org.apache.spark.sql.catalyst.parser.ParseException: > Invalid escape string.Escape string must be empty or one character.(line 1, pos 25) > > == SQL == > select * from t8 where a like b escape '"' > -------------------------^^^ > ``` > > ``` > postgres=# select * from t8 where a like b escape '"'; > a | b > ---+--- > (0 rows) > ``` Yes. there exists this issue indeed. I will repair it.
---------------------------------------------------------------- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
