From 2099d05dec0cc5de9c86073a2736da3d34766955 Mon Sep 17 00:00:00 2001 From: tjhunt Date: Wed, 14 Mar 2007 21:07:37 +0000 Subject: [PATCH] MDL-8232 - can't use = on TEXT colums with MSSQL - was breaking numerical question type upgrade. --- question/type/numerical/db/upgrade.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/question/type/numerical/db/upgrade.php b/question/type/numerical/db/upgrade.php index d01a86e1a4..b32afbd92f 100644 --- a/question/type/numerical/db/upgrade.php +++ b/question/type/numerical/db/upgrade.php @@ -27,7 +27,7 @@ function xmldb_qtype_numerical_upgrade($oldversion=0) { // from the empty string to *, to be like short answer questions. if ($result && $oldversion < 2006121500) { $result = set_field_select('question_answers', 'answer', '*', - sql_compare_text('answer') . " = '" . sql_empty() . "' AND question IN (SELECT id FROM {$CFG->prefix}question WHERE qtype = '" . NUMERICAL . "')"); + sql_compare_text('answer') . " LIKE '" . sql_empty() . "' AND question IN (SELECT id FROM {$CFG->prefix}question WHERE qtype = '" . NUMERICAL . "')"); } return $result; -- 2.39.5