sql - npm Package Compare versions

Comparing version 0.43.0 to 0.43.1

lib/node/where.js

@@ -15,9 +15,13 @@ 'use strict';
 
-    node.forEach(function (subNode) {
-      if (!result) {
-        result = subNode;
-      } else {
-        result = result.and(subNode);
-      }
-    });
+    if (node.length === 0) {
+      result = new TextNode('(1 = 1)');
+    } else {
+      node.forEach(function (subNode) {
+        if (!result) {
+          result = subNode;
+        } else {
+          result = result.and(subNode);
+        }
+      });
+    }
   }
@@ -24,0 +28,0 @@ else if (!node.toNode && typeof node === 'object'){

package.json

@@ -5,3 +5,3 @@ {
   "description": "sql builder",
-  "version": "0.43.0",
+  "version": "0.43.1",
   "homepage": "https://github.com/brianc/node-sql",
@@ -8,0 +8,0 @@ "repository": {

test/dialects/where-clause-tests.js

@@ -55,2 +55,19 @@ 'use strict';
   params: []
+});
+
+Harness.test({
+  query: user.where([]),
+  pg: {
+    text  : 'SELECT * FROM "user" WHERE (1 = 1)',
+    string: 'SELECT * FROM "user" WHERE (1 = 1)'
+  },
+  mysql: {
+    text  : 'SELECT * FROM `user` WHERE (1 = 1)',
+    string: 'SELECT * FROM `user` WHERE (1 = 1)'
+  },
+  sqlite: {
+    text  : 'SELECT * FROM "user" WHERE (1 = 1)',
+    string: 'SELECT * FROM "user" WHERE (1 = 1)'
+  },
+  params: []
 });

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

294257

increased by0.17%

Lines of code

7905

increased by0.25%

No dependency changes