summaryrefslogtreecommitdiffstats
path: root/system/database
diff options
context:
space:
mode:
authorAndrey Andreev <narf@devilix.net>2020-01-27 18:32:24 +0100
committerGitHub <noreply@github.com>2020-01-27 18:32:24 +0100
commitecc8d4f89dd13a222fa681b19af5f1a07466f290 (patch)
treeff968be1ebe221111fd3ca3a96d3486853a936fd /system/database
parentb977b2d860f84d6e3619174420848ca3c854c5ed (diff)
parente19e0ee4e541f3084fb2f1ce0e8d2afc7ea4508a (diff)
[ci skip] Merge pull request #5881 from InSitu-Software/query_builder_full_join
Added FULL OUTER JOIN to QueryBuilder
Diffstat (limited to 'system/database')
-rw-r--r--system/database/DB_query_builder.php2
1 files changed, 1 insertions, 1 deletions
diff --git a/system/database/DB_query_builder.php b/system/database/DB_query_builder.php
index 78e8018c7..357a2e359 100644
--- a/system/database/DB_query_builder.php
+++ b/system/database/DB_query_builder.php
@@ -526,7 +526,7 @@ abstract class CI_DB_query_builder extends CI_DB_driver {
public function join($table, $cond, $type = '', $escape = NULL)
{
$type = trim(strtoupper($type).' JOIN');
- preg_match('#^(NATURAL\s+)?((LEFT|RIGHT)\s+)?((INNER|OUTER)\s+)?JOIN$#', $type) OR $type = 'JOIN';
+ preg_match('#^(NATURAL\s+)?((LEFT|RIGHT|FULL)\s+)?((INNER|OUTER)\s+)?JOIN$#', $type) OR $type = 'JOIN';
// Extract any aliases that might exist. We use this information
// in the protect_identifiers to know whether to add a table prefix