[drill-site] branch master updated: Document the need to quote calls to ILIKE with backticks.

[dzamo]

This is an automated email from the ASF dual-hosted git repository.

dzamo pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/drill-site.git


The following commit(s) were added to refs/heads/master by this push:
     new aab46384d Document the need to quote calls to ILIKE with backticks.
aab46384d is described below

commit aab46384d82548d544370ba2cb2f59f87bba8cca
Author: James Turton <ja...@somecomputer.xyz>
AuthorDate: Thu Oct 20 15:17:59 2022 +0200

    Document the need to quote calls to ILIKE with backticks.
---
 _docs/en/sql-reference/sql-functions/040-string-manipulation.md | 9 ++++++---
 1 file changed, 6 insertions(+), 3 deletions(-)

diff --git a/_docs/en/sql-reference/sql-functions/040-string-manipulation.md 
b/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
index 7a5d62a31..7a6356b2c 100644
--- a/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
+++ b/_docs/en/sql-reference/sql-functions/040-string-manipulation.md
@@ -122,14 +122,17 @@ true in the case of a match.
 
 ### ILIKE Syntax
 
+Note that it necessary quote ILIKE function calls using backticks because ILIKE
+is also a SQL keyword.
+
 ```
-ILIKE(string, pattern)
+`ILIKE`(string, pattern)
 ```
 
 ### ILIKE Examples
 
 ```
-SELECT ILIKE('abcde', 'ABC%') FROM (VALUES(1));
+SELECT `ILIKE`('abcde', 'ABC%') FROM (VALUES(1));
 |--------|
 | EXPR$0 |
 |--------|
@@ -138,7 +141,7 @@ SELECT ILIKE('abcde', 'ABC%') FROM (VALUES(1));
 1 row selected (0.185 seconds)
 ```
 ```
-SELECT ILIKE(last_name, 'Spence') FROM cp.`employee.json` limit 3;
+SELECT `ILIKE`(last_name, 'Spence') FROM cp.`employee.json` limit 3;
 |--------|
 | EXPR$0 |
 |--------|