summaryrefslogtreecommitdiff
path: root/mysql-test/suite/perfschema/t/dml_file_instances.test
diff options
context:
space:
mode:
authorMarc Alff <marc.alff@oracle.com>2010-12-01 09:01:04 +0100
committerMarc Alff <marc.alff@oracle.com>2010-12-01 09:01:04 +0100
commitb1f25ee9f79548ac941a0d2ad285f3994c47723f (patch)
tree56217607963f0b4399130c6195160508e20f610d /mysql-test/suite/perfschema/t/dml_file_instances.test
parent45e17739d441f418fc0727ac3cc10f17c17b341e (diff)
downloadmariadb-git-b1f25ee9f79548ac941a0d2ad285f3994c47723f.tar.gz
Bug#58621 perfschema.dml_ews_by_thread_by_event_name test failure
This fix affects the test suite only. Before this fix, performance schema tests dml_*.test could fail with spurious failure, depending on the table content. This fix simplifies the SELECT tests in the dml_*.test scripts, to only verify that the SELECT operation passed the security checks and succeeded, which was the original intent of the test. Usage of --replace_column 1 # 2 # 3 # 4 # ... to discard the test output was replaced by a simpler and more maintainable --disable_result_log which also work for empty tables.
Diffstat (limited to 'mysql-test/suite/perfschema/t/dml_file_instances.test')
-rw-r--r--mysql-test/suite/perfschema/t/dml_file_instances.test3
1 files changed, 2 insertions, 1 deletions
diff --git a/mysql-test/suite/perfschema/t/dml_file_instances.test b/mysql-test/suite/perfschema/t/dml_file_instances.test
index f3a13eaee32..d7a1002b040 100644
--- a/mysql-test/suite/perfschema/t/dml_file_instances.test
+++ b/mysql-test/suite/perfschema/t/dml_file_instances.test
@@ -18,11 +18,12 @@
--source include/not_embedded.inc
--source include/have_perfschema.inc
---replace_column 1 # 2 # 3 #
+--disable_result_log
select * from performance_schema.file_instances limit 1;
select * from performance_schema.file_instances
where file_name='FOO';
+--enable_result_log
--error ER_TABLEACCESS_DENIED_ERROR
insert into performance_schema.file_instances