Added subquery-tests for MS SqlServer.

danrzeppa · danrzeppa · commit ba24e39f6caa · 2013-09-15T01:54:18.000-04:00
diff --git a/test/dialects/subquery-tests.js b/test/dialects/subquery-tests.js
@@ -40,6 +40,10 @@ Harness.test({
     text  : 'SELECT * FROM (SELECT * FROM `user`)',
     string: 'SELECT * FROM (SELECT * FROM `user`)'
   },
+  sqlserver: {
+    text  : 'SELECT * FROM (SELECT * FROM [user])',
+    string: 'SELECT * FROM (SELECT * FROM [user])'
+  },
   params: []
 });
 
@@ -57,6 +61,10 @@ Harness.test({
     text  : 'SELECT * FROM (SELECT * FROM `customer`) T1 , (SELECT * FROM `user`) T2',
     string: 'SELECT * FROM (SELECT * FROM `customer`) T1 , (SELECT * FROM `user`) T2'
   },
+  sqlserver: {
+    text  : 'SELECT * FROM (SELECT * FROM [customer]) T1 , (SELECT * FROM [user]) T2',
+    string: 'SELECT * FROM (SELECT * FROM [customer]) T1 , (SELECT * FROM [user]) T2'
+  },
   params: []
 });
 
@@ -77,6 +85,10 @@ Harness.test({
     text  : '(`customer`.`name` BETWEEN (SELECT MIN(`customer`.`name`) FROM `customer`) AND (SELECT MAX(`customer`.`name`) FROM `customer`))',
     string: '(`customer`.`name` BETWEEN (SELECT MIN(`customer`.`name`) FROM `customer`) AND (SELECT MAX(`customer`.`name`) FROM `customer`))'
   },
+  sqlserver: {
+    text  : '([customer].[name] BETWEEN (SELECT MIN([customer].[name]) FROM [customer]) AND (SELECT MAX([customer].[name]) FROM [customer]))',
+    string: '([customer].[name] BETWEEN (SELECT MIN([customer].[name]) FROM [customer]) AND (SELECT MAX([customer].[name]) FROM [customer]))'
+  },
   params: []
 });
 
@@ -94,5 +106,9 @@ Harness.test({
     text  : '(EXISTS (SELECT * FROM `user` WHERE (`user`.`name` = `customer`.`name`)))',
     string: '(EXISTS (SELECT * FROM `user` WHERE (`user`.`name` = `customer`.`name`)))'
   },
+  sqlserver: {
+    text  : '(EXISTS (SELECT * FROM [user] WHERE ([user].[name] = [customer].[name])))',
+    string: '(EXISTS (SELECT * FROM [user] WHERE ([user].[name] = [customer].[name])))'
+  },
   params: []
 });
