Gecko [ www.jdcpatala.org ]

Name	Size	Permission
audit_plugin-master.opt	17 B	-rw-r--r--
audit_plugin.test	1.48 KB	-rw-r--r--
audit_plugin_2-master.opt	15 B	-rw-r--r--
audit_plugin_2.test	107.34 KB	-rw-r--r--
audit_plugin_bugs-master.opt	16 B	-rw-r--r--
audit_plugin_bugs.test	4.63 KB	-rw-r--r--
general_error_abort-master.opt	15 B	-rw-r--r--
general_error_abort.test	1.58 KB	-rw-r--r--
general_error_abort_ps-master....	15 B	-rw-r--r--
general_error_abort_ps.test	3.66 KB	-rw-r--r--
general_log_abort-master.opt	15 B	-rw-r--r--
general_log_abort.test	1.16 KB	-rw-r--r--
general_log_abort_ps-master.op...	15 B	-rw-r--r--
general_log_abort_ps.test	6.09 KB	-rw-r--r--

Code Editor : audit_plugin.test

--source include/have_null_audit_plugin.inc
# Test for WL#3771 (audit null plugin)
# Created by HHunger 2009-09-02
#
--source include/not_embedded.inc

# Adjustment to the OS dependent extension of shared libraries.
let $expected_extension= so;
if(`SELECT CONVERT(@@version_compile_os USING latin1)
           IN ("Win32","Win64","Windows")`)
{
   let $expected_extension= dll;
}

# Adjustment to the fact that protocols which lead to the use
# of prepared statements cause that a higher number of
# plugin calls gets counted.
let $expected_calls= 65;
if(`SELECT $PS_PROTOCOL > 0`)
{
   let $expected_calls= 107;
}
if(`SELECT $SP_PROTOCOL > 0`)
{
   let $expected_calls= 65;
}
if(`SELECT $CURSOR_PROTOCOL > 0`)
{
   let $expected_calls= 50;
}
if(`SELECT $VIEW_PROTOCOL > 0`)
{
   let $expected_calls= 94;
}

--replace_result $expected_extension  <expected_extension>
--error ER_CANT_FIND_DL_ENTRY
eval INSTALL PLUGIN audit_null SONAME 'adt_null.$expected_extension';
--replace_result $expected_extension <expected_extension>
eval INSTALL PLUGIN null_audit SONAME 'adt_null.$expected_extension';
CREATE TABLE t1 (c1 INT, c2 CHAR(20));
--error ER_TABLE_EXISTS_ERROR
CREATE TABLE t1 (c1 INT, c2 CHAR(20));
INSERT INTO t1 VALUES (1,'a'),(2,'b'),(3,'c');
SELECT * FROM t1;
--error ER_NO_SUCH_TABLE
SELECT * FROM t2;
DROP TABLE t1;
--replace_result $expected_calls <expected_number_of_calls>
SHOW STATUS LIKE 'audit_null_called';
--error ER_SP_DOES_NOT_EXIST
UNINSTALL PLUGIN audit_null;
UNINSTALL PLUGIN null_audit;

${this.title}

Code Editor : audit_plugin.test