summaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--system/database/DB_active_rec.php8
1 files changed, 6 insertions, 2 deletions
diff --git a/system/database/DB_active_rec.php b/system/database/DB_active_rec.php
index 129eaa7b6..5bf0d8f1d 100644
--- a/system/database/DB_active_rec.php
+++ b/system/database/DB_active_rec.php
@@ -336,8 +336,12 @@ class CI_DB_active_record extends CI_DB_driver {
$cond = $match[1].$match[2].$match[3];
}
- // Assemble the JOIN statement
- $join = $type.'JOIN '.$this->_protect_identifiers($table, TRUE, NULL, FALSE).' ON '.$cond;
+ // Assemble the JOIN statement: only use ON if a condition was passed
+ $join = $type.'JOIN '.$this->_protect_identifiers($table, TRUE, NULL, FALSE);
+ if ($cond)
+ {
+ $join .= ' ON '.$cond;
+ }
$this->ar_join[] = $join;
if ($this->ar_caching === TRUE)