From d5b3deecba23250e991614f61a64c6acc04a4c40 Mon Sep 17 00:00:00 2001 From: Petr Skoda Date: Sun, 7 Aug 2011 13:19:02 +0200 Subject: [PATCH] MDL-27685 fix pg LIKE escape trouble --- lib/dml/pgsql_native_moodle_database.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lib/dml/pgsql_native_moodle_database.php b/lib/dml/pgsql_native_moodle_database.php index 4f82edaca7e..9fa697f2a03 100644 --- a/lib/dml/pgsql_native_moodle_database.php +++ b/lib/dml/pgsql_native_moodle_database.php @@ -277,12 +277,12 @@ class pgsql_native_moodle_database extends moodle_database { return $this->tables; } $this->tables = array(); - $prefix = str_replace('_', '\\\\_', $this->prefix); + $prefix = str_replace('_', '|_', $this->prefix); // Get them from information_schema instead of catalog as far as // we want to get only own session temp objects (catalog returns all) $sql = "SELECT table_name FROM information_schema.tables - WHERE table_name LIKE '$prefix%' + WHERE table_name LIKE '$prefix%' ESCAPE '|' AND table_type IN ('BASE TABLE', 'LOCAL TEMPORARY')"; $this->query_start($sql, null, SQL_QUERY_AUX); $result = pg_query($this->pgsql, $sql); -- 2.43.0