bzr commit into mysql-5.4 branch (horst:2845) WL#4939

[Horst Hunger]

#At file:///work/bzr/mysql-azalea-wl4939/ based on revid:horst@stripped

 2845 Horst Hunger	2009-08-04
      WL#4939: Tests of load/unload, show engines and show plugins for TSE.

    added:
      mysql-test/r/tse_err_load_plugin.result
      mysql-test/r/tse_load_unload_plugin.result
      mysql-test/t/tse_err_load_plugin-master.opt
      mysql-test/t/tse_err_load_plugin.test
      mysql-test/t/tse_load_unload_plugin-master.opt
      mysql-test/t/tse_load_unload_plugin.test
=== added file 'mysql-test/r/tse_err_load_plugin.result'
--- a/mysql-test/r/tse_err_load_plugin.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/r/tse_err_load_plugin.result	2009-08-04 10:57:19 +0000
@@ -0,0 +1,14 @@
+INSTALL PLUGIN tse SONAME 'hatse.so';
+ERROR HY000: Can't open shared library '/work/bzr/mysql-azalea-wl4939/mysql-test/../storage/tse/.libs/hatse.so' (errno: 2 cannot open shared object file: No such file or directory)
+INSTALL PLUGIN tse SONAME 'ha_tse.a';
+ERROR HY000: Can't open shared library '/work/bzr/mysql-azalea-wl4939/mysql-test/../storage/tse/.libs/ha_tse.a' (errno: 0 invalid ELF header)
+INSTALL PLUGIN tse SONAME 'ha_tse.o';
+ERROR HY000: Can't open shared library '/work/bzr/mysql-azalea-wl4939/mysql-test/../storage/tse/.libs/ha_tse.o' (errno: 0 cannot open shared object file: No such file or directory)
+INSTALL PLUGIN te SONAME 'ha_tse.so';
+ERROR HY000: Can't find symbol 'te' in library
+UNINSTALL PLUGIN tse ;
+ERROR 42000: PLUGIN tse does not exist
+INSTALL PLUGIN tse SONAME 'ha_tse.so';
+INSTALL PLUGIN tse SONAME 'ha_tse.so';
+ERROR HY000: Function 'tse' already exists
+UNINSTALL PLUGIN tse;

=== added file 'mysql-test/r/tse_load_unload_plugin.result'
--- a/mysql-test/r/tse_load_unload_plugin.result	1970-01-01 00:00:00 +0000
+++ b/mysql-test/r/tse_load_unload_plugin.result	2009-08-04 10:57:19 +0000
@@ -0,0 +1,67 @@
+SELECT plugin_name,plugin_library FROM information_schema.plugins;
+plugin_name	plugin_library
+binlog	NULL
+CSV	NULL
+MEMORY	NULL
+MyISAM	NULL
+MRG_MYISAM	NULL
+INSTALL PLUGIN tse SONAME 'ha_tse.so';
+SELECT plugin_name,plugin_library,plugin_status FROM information_schema.plugins;
+plugin_name	plugin_library	plugin_status
+binlog	NULL	ACTIVE
+CSV	NULL	ACTIVE
+MEMORY	NULL	ACTIVE
+MyISAM	NULL	ACTIVE
+MRG_MYISAM	NULL	ACTIVE
+TSE	ha_tse.so	ACTIVE
+SHOW ENGINES;
+Engine	Support	Comment	Transactions	XA	Savepoints
+TSE	YES	Test Storage Engine	NO	NO	NO
+MRG_MYISAM	YES	Collection of identical MyISAM tables	NO	NO	NO
+MEMORY	YES	Hash based, stored in memory, useful for temporary tables	NO	NO	NO
+MyISAM	DEFAULT	Default engine as of MySQL 3.23 with great performance	NO	NO	NO
+CSV	YES	CSV storage engine	NO	NO	NO
+DROP TABLE IF EXISTS t1;
+CREATE TABLE `t1` (
+`id` int(11) default NULL
+) ENGINE=TSE DEFAULT CHARSET=latin1 ;
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `id` int(11) DEFAULT NULL
+) ENGINE=TSE DEFAULT CHARSET=latin1
+SELECT * FROM t1;
+id
+DROP TABLE t1;
+UNINSTALL PLUGIN tse ;
+SHOW PLUGINS;
+Name	Status	Type	Library	License
+binlog	ACTIVE	STORAGE ENGINE	NULL	GPL
+CSV	ACTIVE	STORAGE ENGINE	NULL	GPL
+MEMORY	ACTIVE	STORAGE ENGINE	NULL	GPL
+MyISAM	ACTIVE	STORAGE ENGINE	NULL	GPL
+MRG_MYISAM	ACTIVE	STORAGE ENGINE	NULL	GPL
+SHOW ENGINES;
+Engine	Support	Comment	Transactions	XA	Savepoints
+CSV	YES	CSV storage engine	NO	NO	NO
+MRG_MYISAM	YES	Collection of identical MyISAM tables	NO	NO	NO
+MEMORY	YES	Hash based, stored in memory, useful for temporary tables	NO	NO	NO
+MyISAM	DEFAULT	Default engine as of MySQL 3.23 with great performance	NO	NO	NO
+DROP TABLE IF EXISTS t1;
+CREATE TABLE `t1` (
+`id` int(11) default NULL
+) ENGINE=TSE DEFAULT CHARSET=latin1 ;
+Warnings:
+Warning	1286	Unknown storage engine 'TSE'
+Warning	1266	Using storage engine MyISAM for table 't1'
+SHOW CREATE TABLE t1;
+Table	Create Table
+t1	CREATE TABLE `t1` (
+  `id` int(11) DEFAULT NULL
+) ENGINE=MyISAM DEFAULT CHARSET=latin1
+INSERT INTO t1 VALUES (1),(2);
+SELECT * FROM t1;
+id
+1
+2
+DROP TABLE t1;

=== added file 'mysql-test/t/tse_err_load_plugin-master.opt'
--- a/mysql-test/t/tse_err_load_plugin-master.opt	1970-01-01 00:00:00 +0000
+++ b/mysql-test/t/tse_err_load_plugin-master.opt	2009-08-04 10:57:19 +0000
@@ -0,0 +1 @@
+--plugin_dir=../storage/tse/.libs

=== added file 'mysql-test/t/tse_err_load_plugin.test'
--- a/mysql-test/t/tse_err_load_plugin.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/t/tse_err_load_plugin.test	2009-08-04 10:57:19 +0000
@@ -0,0 +1,21 @@
+# Test of storage engine TSE as plugin, errors.
+#
+# Creation:
+# 2009-08-04 Hunger
+#
+--error ER_CANT_OPEN_LIBRARY
+INSTALL PLUGIN tse SONAME 'hatse.so';
+--error ER_CANT_OPEN_LIBRARY
+INSTALL PLUGIN tse SONAME 'ha_tse.a';
+--error ER_CANT_OPEN_LIBRARY
+INSTALL PLUGIN tse SONAME 'ha_tse.o';
+--error ER_CANT_FIND_DL_ENTRY
+INSTALL PLUGIN te SONAME 'ha_tse.so';
+
+--error ER_SP_DOES_NOT_EXIST
+UNINSTALL PLUGIN tse ;
+INSTALL PLUGIN tse SONAME 'ha_tse.so';
+--error ER_UDF_EXISTS
+INSTALL PLUGIN tse SONAME 'ha_tse.so';
+UNINSTALL PLUGIN tse;
+

=== added file 'mysql-test/t/tse_load_unload_plugin-master.opt'
--- a/mysql-test/t/tse_load_unload_plugin-master.opt	1970-01-01 00:00:00 +0000
+++ b/mysql-test/t/tse_load_unload_plugin-master.opt	2009-08-04 10:57:19 +0000
@@ -0,0 +1 @@
+--plugin_dir=../storage/tse/.libs

=== added file 'mysql-test/t/tse_load_unload_plugin.test'
--- a/mysql-test/t/tse_load_unload_plugin.test	1970-01-01 00:00:00 +0000
+++ b/mysql-test/t/tse_load_unload_plugin.test	2009-08-04 10:57:19 +0000
@@ -0,0 +1,36 @@
+# Test of storage engine TSE as plugin.
+#
+# Creation:
+# 2009-08-04 Hunger
+#
+SELECT plugin_name,plugin_library FROM information_schema.plugins;
+INSTALL PLUGIN tse SONAME 'ha_tse.so';
+--source include/have_tse.inc
+SELECT plugin_name,plugin_library,plugin_status FROM information_schema.plugins;
+SHOW ENGINES;
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+CREATE TABLE `t1` (
+  `id` int(11) default NULL
+) ENGINE=TSE DEFAULT CHARSET=latin1 ;
+# No result as table has not really been created.
+SHOW CREATE TABLE t1;
+SELECT * FROM t1;
+
+DROP TABLE t1;
+UNINSTALL PLUGIN tse ;
+SHOW PLUGINS;
+SHOW ENGINES;
+
+--disable_warnings
+DROP TABLE IF EXISTS t1;
+--enable_warnings
+CREATE TABLE `t1` (
+  `id` int(11) default NULL
+) ENGINE=TSE DEFAULT CHARSET=latin1 ;
+SHOW CREATE TABLE t1;
+INSERT INTO t1 VALUES (1),(2);
+SELECT * FROM t1;
+
+DROP TABLE t1;


Attachment: [text/bzr-bundle] bzr/[e-mail]