Bug #32211 Test 'windows' and 'windows_shm' failed for embedded server

• Submitted: 9 Nov 2007 7:52
• Modified: 14 Dec 2007 15:56
• Reporter: Zhenxing He
• Status: Closed
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.1.22-rc
• OS: Windows
• Assigned to: Alexey Botchkov
• CPU Architecture: Any
• Tags: embedded, test, windows

[9 Nov 2007 7:52] Zhenxing He

Description:
Test 'windows' and 'windows_shm' would fail with --embedded-server option for mysql-5.1.22-rc

How to repeat:
run ./mysql-test-run.pl --embedded-server windows windows_shm

Suggested fix:
windows_shm.test should be disabled for embedded server, windows.test should be splitted into tow tests, statements need dlopen support should be moved to another test, the following is a patch for this:

--- mysql-5.1.22-rc/mysql-test/t/windows.test.orig      2007-11-09 14:43:10.000000000 +0800
+++ mysql-5.1.22-rc/mysql-test/t/windows.test   2007-11-09 14:49:26.000000000 +0800
@@ -35,25 +35,3 @@
 EXPLAIN SELECT * FROM t1 WHERE b =  (SELECT max(2));
 
 --echo End of 5.0 tests.
-
-#
-# Bug #20665: All commands supported in Stored Procedures should work in
-# Prepared Statements
-#
-
-create procedure proc_1() install plugin my_plug soname '\\root\\some_plugin.dll';
---error ER_UDF_NO_PATHS
-call proc_1();
---error ER_UDF_NO_PATHS
-call proc_1();
---error ER_UDF_NO_PATHS
-call proc_1();
-drop procedure proc_1;
-
-prepare abc from "install plugin my_plug soname '\\\\root\\\\some_plugin.dll'";
---error ER_UDF_NO_PATHS
-execute abc;
---error ER_UDF_NO_PATHS
-execute abc;
-deallocate prepare abc;
-
--- mysql-5.1.22-rc/mysql-test/t/windows_shm.test.orig  2007-11-09 14:43:24.000000000 +0800
+++ mysql-5.1.22-rc/mysql-test/t/windows_shm.test       2007-11-09 14:47:50.000000000 +0800
@@ -1,5 +1,6 @@
 # Windows-specific tests
 --source include/windows.inc
+--source include/not_embedded.inc
 
 #
 # Bug #24924: shared-memory-base-name that is too long causes buffer overflow
--- mysql-5.1.22-rc/mysql-test/t/windows_notembedded.test.orig  2007-11-09 15:07:40.000000000 +0800
+++ mysql-5.1.22-rc/mysql-test/t/windows_notembedded.test       2007-11-09 14:49:12.000000000 +0800
@@ -0,0 +1,20 @@
+# Windows-specific tests
+--source include/windows.inc
+--source include/not_embedded.inc
+
+create procedure proc_1() install plugin my_plug soname '\\root\\some_plugin.dll';
+--error ER_UDF_NO_PATHS
+call proc_1();
+--error ER_UDF_NO_PATHS
+call proc_1();
+--error ER_UDF_NO_PATHS
+call proc_1();
+drop procedure proc_1;
+
+prepare abc from "install plugin my_plug soname '\\\\root\\\\some_plugin.dll'";
+--error ER_UDF_NO_PATHS
+execute abc;
+--error ER_UDF_NO_PATHS
+execute abc;
+deallocate prepare abc;
+

[9 Nov 2007 11:37] MySQL Verification Team

Thank you for the bug report.

[17 Nov 2007 20:37] Bugs System

A patch for this bug has been committed. After review, it may
be pushed to the relevant source trees for release in the next
version. You can access the patch from:

  http://lists.mysql.com/commits/38001

ChangeSet@1.2621, 2007-11-18 00:32:06+04:00, [e-mail] +3 -0
  Bug #32211 Test 'windows' and 'windows_shm' failed for embedded server
  
  failing 'INSTALL PLUGIN' statement doesn't work in embedded server
  as we disable library loading there.
  Fixed by enabling loading libraries (#define HAVE_DLOPEN), what also
  makes UDF working in the embedded server.

[14 Dec 2007 8:18] Bugs System

Pushed into 5.1.23-rc

[14 Dec 2007 8:21] Bugs System

Pushed into 6.0.5-alpha

[14 Dec 2007 15:56] Paul DuBois

Test suite change. No changelog entry needed.