diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2014-08-09 12:46:59 +0200 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2014-08-09 12:46:59 +0200 |
| commit | 078c68da6360f0f55acf887b31394ae69553d52e (patch) | |
| tree | 94b55fb8a41276a580dae971f8574d10c74c284e | |
| parent | 12eb993d230e0be0d0c1c70e5ebe6379bacecc0d (diff) | |
| download | forums-078c68da6360f0f55acf887b31394ae69553d52e.tar forums-078c68da6360f0f55acf887b31394ae69553d52e.tar.gz forums-078c68da6360f0f55acf887b31394ae69553d52e.tar.bz2 forums-078c68da6360f0f55acf887b31394ae69553d52e.tar.xz forums-078c68da6360f0f55acf887b31394ae69553d52e.zip | |
[ticket/12710] Can not use upper in oracles where claus
PHPBB3-12710
| -rw-r--r-- | phpBB/phpbb/db/tools.php | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/phpBB/phpbb/db/tools.php b/phpBB/phpbb/db/tools.php index 05bba0ba84..d5b8d4fad7 100644 --- a/phpBB/phpbb/db/tools.php +++ b/phpBB/phpbb/db/tools.php @@ -2652,8 +2652,8 @@ class tools $sql = "SELECT ix.index_name AS phpbb_index_name FROM all_ind_columns ixc, all_indexes ix WHERE ix.index_name = ixc.index_name - AND ixc.table_name = UPPER('{$table_name}') - AND ixc.column_name = UPPER('{$column_name}') + AND ixc.table_name = '" . strtoupper($table_name) . "' + AND ixc.column_name = '" . strtoupper($column_name) . "' AND ix.uniqueness = " . ($unique) ? "'UNIQUE'" : "'NONUNIQUE'"; break; } @@ -2705,7 +2705,7 @@ class tools case 'oracle': $sql = "SELECT index_name AS phpbb_index_name, column_name AS phpbb_column_name FROM all_ind_columns - WHERE table_name = UPPER('{$table_name}') + WHERE table_name = '" . strtoupper($table_name) . "' AND " . $this->db->sql_in_set('index_name', array_keys($existing_indexes)); break; } |