Changeset: 4ea8ecd5b6dc for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/4ea8ecd5b6dc
Modified Files:
sql/server/sql_parser.y
Branch: default
Log Message:
added ifnull
diffs (33 lines):
diff --git a/sql/server/sql_parser.y b/sql/server/sql_parser.y
--- a/sql/server/sql_parser.y
+++ b/sql/server/sql_parser.y
@@ -726,7 +726,7 @@ SQLCODE SQLERROR UNDER WHENEVER
%token<sval> sqlDATE TIME TIMESTAMP INTERVAL
%token CENTURY DECADE YEAR QUARTER DOW DOY MONTH WEEK DAY HOUR MINUTE SECOND
EPOCH ZONE
%token LIMIT OFFSET SAMPLE SEED FETCH
-%token CASE WHEN THEN ELSE NULLIF COALESCE IF ELSEIF WHILE DO
+%token CASE WHEN THEN ELSE NULLIF COALESCE IFNULL IF ELSEIF WHILE DO
%token ATOMIC BEGIN END
%token COPY RECORDS DELIMITERS STDIN STDOUT FWF CLIENT SERVER
%token INDEX REPLACE
@@ -737,7 +737,7 @@ SQLCODE SQLERROR UNDER WHENEVER
%token X_BODY
%token MAX_MEMORY MAX_WORKERS OPTIMIZER
/* odbc tokens */
-%token DAYNAME MONTHNAME TIMESTAMPADD TIMESTAMPDIFF IFNULL
+%token DAYNAME MONTHNAME TIMESTAMPADD TIMESTAMPDIFF
/* odbc data type tokens */
%token <sval>
SQL_BIGINT
@@ -5284,6 +5284,11 @@ case_exp:
append_symbol(
append_symbol(
L(), $3), $5)); }
+ | IFNULL '(' search_condition ',' search_condition ')'
+ { $$ = _symbol_create_list(SQL_COALESCE,
+ append_symbol(
+ append_symbol(
+ L(), $3), $5)); }
| COALESCE '(' case_search_condition_commalist ')'
{ $$ = _symbol_create_list(SQL_COALESCE, $3); }
| CASE search_condition when_value_list case_opt_else END
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
