node-sql-parser - npm Package Compare versions

Comparing version 4.0.0 to 4.0.1

ast/postgresql.ts

@@ -843,3 +843,3 @@
 
-export type window_fun_laglead = { type: 'window_func'; name: string; args: expr_list; consider_nulls: string; over: over_partition };
+export type window_fun_laglead = { type: 'window_func'; name: string; args: expr_list; consider_nulls: null | string; over: over_partition };
 
@@ -891,3 +891,3 @@ export type window_fun_firstlast = window_fun_laglead;
         type: 'cast';
-        expr: expr | literal | aggr_func | func_call | case_expr | interval_expr | column_ref | param
+        expr: literal | aggr_func | func_call | case_expr | interval_expr | column_ref | param
           | expr;
@@ -894,0 +894,0 @@ symbol: '::' | 'as',

lib/func.js

@@ -41,3 +41,4 @@ (function (global, factory) {
       symbol,
-      as: alias
+      as: alias,
+      tail
     } = expr;
@@ -63,2 +64,3 @@ const {
 
+    if (tail) suffix += ` ${tail.operator} ${(0, _expr.exprToSQL)(tail.expr)}`;
     if (alias) suffix += ` AS ${(0, _util.identifierToSql)(alias)}`;
@@ -65,0 +67,0 @@ if (collate) suffix += ` ${(0, _util.commonTypeValue)(collate).join(' ')}`;

lib/window.js

@@ -61,3 +61,3 @@ (function (global, factory) {
     // position of IGNORE/RESPECT NULLS varies by function
-    switch (fnName) {
+    switch ((0, _util.toUpper)(fnName)) {
       case 'NTH_VALUE':
@@ -64,0 +64,0 @@ case 'LEAD':

package.json

 {
   "name": "node-sql-parser",
-  "version": "4.0.0",
+  "version": "4.0.1",
   "description": "simple node sql parser",
@@ -5,0 +5,0 @@ "main": "index.js",

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

39242390

increased by0.4%

Lines of code

22922

increased by0.37%

No dependency changes