From b713652b33b6eb180528016f81de59451e2e51f1 Mon Sep 17 00:00:00 2001
From: Lionel Elie Mamane <lionel@mamane.lu>
Date: Tue, 17 Jan 2012 15:21:41 +0100
Subject: Also teach "foo IS [NOT] bar" to our SQL parser (when bar is not
 NULL)

Syntax supported by at least SQLite.
---
 connectivity/source/parse/sqlbison.y | 6 ++++++
 1 file changed, 6 insertions(+)

(limited to 'connectivity/source/parse')

diff --git a/connectivity/source/parse/sqlbison.y b/connectivity/source/parse/sqlbison.y
index e32f22d0558e..d77fb1452dec 100755
--- a/connectivity/source/parse/sqlbison.y
+++ b/connectivity/source/parse/sqlbison.y
@@ -1282,6 +1282,12 @@ comparison:
 		  $$->append($3);
 		  $$->append($4);
 		}
+	  | SQL_TOKEN_IS sql_not
+	  	{
+		  $$ = SQL_NEW_RULE;
+		  $$->append($1);
+		  $$->append($2);
+		}
 	;
 between_predicate_part_2:
 	sql_not SQL_TOKEN_BETWEEN row_value_constructor SQL_TOKEN_AND row_value_constructor
-- 
cgit