Index: lib/dml/simpletest/testdml.php
===================================================================
RCS file: /cvsroot/moodle/moodle/lib/dml/simpletest/testdml.php,v
retrieving revision 1.129
diff -u -r1.129 testdml.php
--- lib/dml/simpletest/testdml.php	28 Oct 2010 10:53:55 -0000	1.129
+++ lib/dml/simpletest/testdml.php	1 Nov 2010 14:10:51 -0000
@@ -2190,6 +2190,13 @@
         $DB->set_field_select($tablename, 'onebinary', $newblob, 'id = ?', array(1));
         $this->assertEqual($newclob, $DB->get_field($tablename, 'onetext', array('id' => 1)), 'Test "small" CLOB set_field (full contents output disabled)');
         $this->assertEqual($newblob, $DB->get_field($tablename, 'onebinary', array('id' => 1)), 'Test "small" BLOB set_field (full contents output disabled)');
+
+        // This is the failure from MDL-24863. This was giving an error on MSSQL,
+        // which converts the '1' to an integer, which cannot then be compared with
+        // onetext cast to a varchar.
+        $DB->set_field_select($tablename, 'onechar', 'frog',
+                $DB->sql_compare_text('onetext') . ' = ?', array('1'));
+        
     }
 
     public function test_count_records() {