From 8b92b3019821f5f619a95a0b58b62e3bb43dd455 Mon Sep 17 00:00:00 2001 From: Jamie Matthews Date: Sat, 22 Jan 2011 11:08:47 +0000 Subject: Add support for DISTINCT - issue #13 --- test/test_queries.php | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'test') 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; -- cgit v1.2.3