diff options
author | gerard sychay <[email protected]> | 2012-11-12 13:36:59 +0000 |
---|---|---|
committer | Simon Holywell <[email protected]> | 2012-11-12 13:36:59 +0000 |
commit | 9f9765dea96855126a21444725d819af4b523865 (patch) | |
tree | 5051f9e993f3b06aadece789de4b40d94273375a /test/test_queries.php | |
parent | 004bfacb21b529f252b2cc22c6c84445280d38ff (diff) |
Handle ambiguous column names when joining two tables
Diffstat (limited to 'test/test_queries.php')
-rw-r--r-- | test/test_queries.php | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/test/test_queries.php b/test/test_queries.php index b0dc88b..1f2acc6 100644 --- a/test/test_queries.php +++ b/test/test_queries.php @@ -192,6 +192,10 @@ $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`"; Tester::check_equal("Simple join", $expected); + ORM::for_table('widget')->join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_one(5); + $expected = "SELECT * FROM `widget` JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id` WHERE `widget`.`id` = '5' LIMIT 1"; + Tester::check_equal("Simple join with where_id_is method", $expected); + ORM::for_table('widget')->inner_join('widget_handle', array('widget_handle.widget_id', '=', 'widget.id'))->find_many(); $expected = "SELECT * FROM `widget` INNER JOIN `widget_handle` ON `widget_handle`.`widget_id` = `widget`.`id`"; Tester::check_equal("Inner join", $expected); |