From 0198c36c9067d23db4733f9d69b5e7ed2f80f5b1 Mon Sep 17 00:00:00 2001 From: Jakub Vrana Date: Sat, 16 Oct 2010 16:38:20 +0200 Subject: [PATCH] Information_schema can be case sensitive (bug #3088228) --- adminer/drivers/mssql.inc.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/adminer/drivers/mssql.inc.php b/adminer/drivers/mssql.inc.php index 03369a5a..5d850a36 100644 --- a/adminer/drivers/mssql.inc.php +++ b/adminer/drivers/mssql.inc.php @@ -285,7 +285,7 @@ if (isset($_GET["mssql"])) { $return = array(); foreach ($databases as $db) { $connection->select_db($db); - $return[$db] = $connection->result("SELECT COUNT(*) FROM information_schema.TABLES"); + $return[$db] = $connection->result("SELECT COUNT(*) FROM INFORMATION_SCHEMA.TABLES"); } return $return; } @@ -358,7 +358,7 @@ WHERE OBJECT_NAME(i.object_id) = " . q($table) function view($name) { global $connection; - return array("select" => preg_replace('~^(?:[^[]|\\[[^]]*])*\\s+AS\\s+~isU', '', $connection->result("SELECT view_definition FROM information_schema.views WHERE table_schema = SCHEMA_NAME() AND table_name = " . q($name)))); + return array("select" => preg_replace('~^(?:[^[]|\\[[^]]*])*\\s+AS\\s+~isU', '', $connection->result("SELECT VIEW_DEFINITION FROM INFORMATION_SCHEMA.VIEWS WHERE TABLE_SCHEMA = SCHEMA_NAME() AND TABLE_NAME = " . q($name)))); } function collations() { -- 2.39.5