test for schema with aggregation

Di Wu · Di Wu · commit fb59d6bd07f4 · 2013-08-23T17:05:24.000-07:00
diff --git a/test/dialects/schema-tests.js b/test/dialects/schema-tests.js
@@ -27,6 +27,23 @@ Harness.test({
   params: []
 });
 
+Harness.test({
+  query: userWithSchema.select(userWithSchema.id.count()).from(userWithSchema),
+  pg: {
+    text  : 'SELECT COUNT("staging"."user"."id") AS "id_count" FROM "staging"."user"',
+    string: 'SELECT COUNT("staging"."user"."id") AS "id_count" FROM "staging"."user"'
+  },
+  sqlite: {
+    text  : 'SELECT COUNT("staging"."user"."id") AS "id_count" FROM "staging"."user"',
+    string: 'SELECT COUNT("staging"."user"."id") AS "id_count" FROM "staging"."user"'
+  },
+  mysql: {
+    text  : 'SELECT COUNT(`staging`.`user`.`id`) AS `id_count` FROM `staging`.`user`',
+    string: 'SELECT COUNT(`staging`.`user`.`id`) AS `id_count` FROM `staging`.`user`'
+  },
+  params: []
+});
+
 Harness.test({
   query: userWithSchema.select(userWithSchema.id, userWithSchema.name).from(userWithSchema),
   pg: {
