You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@datafusion.apache.org by gi...@apache.org on 2026/09/07 04:43:37 UTC
(datafusion-sqlparser-rs) 01/01: Parse expression-valued LIKE ESCAPE clauses (#2476)
This is an automated email from the ASF dual-hosted git repository.
github-merge-queue[bot] pushed a commit to branch gh-readonly-queue/main/pr-2476-5c974dd1399d9d16cc2924bef1846dbfba91cd49
in repository https://gitbox.apache.org/repos/asf/datafusion-sqlparser-rs.git
commit bd0f36fcfb17f2744352bc493d14e17d596fc21a
Author: Ophir LOJKINE <co...@ophir.dev>
AuthorDate: Mon Sep 7 04:43:12 2026 +0000
Parse expression-valued LIKE ESCAPE clauses (#2476)
---
src/ast/mod.rs | 6 +++---
src/parser/mod.rs | 6 ++++--
tests/sqlparser_common.rs | 23 ++++++++++++++++++-----
3 files changed, 25 insertions(+), 10 deletions(-)
diff --git a/src/ast/mod.rs b/src/ast/mod.rs
index 6e1d3bf9..9077bed2 100644
--- a/src/ast/mod.rs
+++ b/src/ast/mod.rs
@@ -1027,7 +1027,7 @@ pub enum Expr {
/// Pattern expression.
pattern: Box<Expr>,
/// Optional escape character.
- escape_char: Option<ValueWithSpan>,
+ escape_char: Option<Box<Expr>>,
},
/// `ILIKE` (case-insensitive `LIKE`)
ILike {
@@ -1041,7 +1041,7 @@ pub enum Expr {
/// Pattern expression.
pattern: Box<Expr>,
/// Optional escape character.
- escape_char: Option<ValueWithSpan>,
+ escape_char: Option<Box<Expr>>,
},
/// `SIMILAR TO` regex
SimilarTo {
@@ -1052,7 +1052,7 @@ pub enum Expr {
/// Pattern expression.
pattern: Box<Expr>,
/// Optional escape character.
- escape_char: Option<ValueWithSpan>,
+ escape_char: Option<Box<Expr>>,
},
/// MySQL: `RLIKE` regex or `REGEXP` regex
RLike {
diff --git a/src/parser/mod.rs b/src/parser/mod.rs
index e7e5afa0..5edc4371 100644
--- a/src/parser/mod.rs
+++ b/src/parser/mod.rs
@@ -4223,9 +4223,11 @@ impl<'a> Parser<'a> {
}
/// Parse the `ESCAPE CHAR` portion of `LIKE`, `ILIKE`, and `SIMILAR TO`
- pub fn parse_escape_char(&mut self) -> Result<Option<ValueWithSpan>, ParserError> {
+ pub fn parse_escape_char(&mut self) -> Result<Option<Box<Expr>>, ParserError> {
if self.parse_keyword(Keyword::ESCAPE) {
- Ok(Some(self.parse_value()?))
+ Ok(Some(Box::new(self.parse_subexpr(
+ self.dialect.prec_value(Precedence::Like),
+ )?)))
} else {
Ok(None)
}
diff --git a/tests/sqlparser_common.rs b/tests/sqlparser_common.rs
index 4ba803a2..108ec431 100644
--- a/tests/sqlparser_common.rs
+++ b/tests/sqlparser_common.rs
@@ -2341,7 +2341,9 @@ fn parse_ilike() {
pattern: Box::new(Expr::Value(
(Value::SingleQuotedString("%a".to_string())).with_empty_span()
)),
- escape_char: Some(Value::SingleQuotedString('^'.to_string()).with_empty_span()),
+ escape_char: Some(Box::new(Expr::value(
+ Value::SingleQuotedString('^'.to_string()).with_empty_span(),
+ ))),
any: false,
},
select.selection.unwrap()
@@ -2405,7 +2407,9 @@ fn parse_like() {
pattern: Box::new(Expr::Value(
(Value::SingleQuotedString("%a".to_string())).with_empty_span()
)),
- escape_char: Some(Value::SingleQuotedString('^'.to_string()).with_empty_span()),
+ escape_char: Some(Box::new(Expr::value(
+ Value::SingleQuotedString('^'.to_string()).with_empty_span(),
+ ))),
any: false,
},
select.selection.unwrap()
@@ -2435,6 +2439,11 @@ fn parse_like() {
chk(true);
}
+#[test]
+fn parse_like_escape_expression() {
+ verified_expr("'a%' LIKE 'a#%' ESCAPE ('' || '#')");
+}
+
#[test]
fn parse_similar_to() {
fn chk(negated: bool) {
@@ -2468,7 +2477,9 @@ fn parse_similar_to() {
pattern: Box::new(Expr::Value(
(Value::SingleQuotedString("%a".to_string())).with_empty_span()
)),
- escape_char: Some(Value::SingleQuotedString('^'.to_string()).with_empty_span()),
+ escape_char: Some(Box::new(Expr::value(
+ Value::SingleQuotedString('^'.to_string()).with_empty_span(),
+ ))),
},
select.selection.unwrap()
);
@@ -2485,7 +2496,7 @@ fn parse_similar_to() {
pattern: Box::new(Expr::Value(
(Value::SingleQuotedString("%a".to_string())).with_empty_span()
)),
- escape_char: Some(Value::Null.with_empty_span()),
+ escape_char: Some(Box::new(Expr::value(Value::Null.with_empty_span()))),
},
select.selection.unwrap()
);
@@ -2503,7 +2514,9 @@ fn parse_similar_to() {
pattern: Box::new(Expr::Value(
(Value::SingleQuotedString("%a".to_string())).with_empty_span()
)),
- escape_char: Some(Value::SingleQuotedString('^'.to_string()).with_empty_span()),
+ escape_char: Some(Box::new(Expr::value(
+ Value::SingleQuotedString('^'.to_string()).with_empty_span(),
+ ))),
})),
select.selection.unwrap()
);
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@datafusion.apache.org
For additional commands, e-mail: commits-help@datafusion.apache.org