Add support for DISTINCT - issue #13

1 files changed, 4 insertions, 0 deletions

diff --git a/test/test_queries.php b/test/test_queries.php
index fa3bb2e..2dca817 100644
--- a/test/test_queries.php
+++ b/test/test_queries.php
@@ -179,6 +179,10 @@
     $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON widget_handle.widget_id = widget.id";
     Tester::check_equal("Join with string constraint", $expected);
 
+    ORM::for_table('widget')->distinct()->select('name')->find_many();
+    $expected = "SELECT DISTINCT `name` FROM `widget`";
+    Tester::check_equal("Select with DISTINCT", $expected);
+
     $widget = ORM::for_table('widget')->create();
     $widget->name = "Fred";
     $widget->age = 10;