Bug #72223 -DWITH_EXAMPLE_STORAGE_ENGINE=ON breaks all_vars, mysqld--help-notwin

• Submitted: 3 Apr 2014 15:32
• Modified: 5 Apr 2014 8:11
• Reporter: Laurynas Biveinis (OCA)
• Status: Verified
• Category: MySQL Server: Tests
• Severity: S3 (Non-critical)
• Version: 5.7.4
• OS: Linux
• CPU Architecture: Any
• Tags: example, mtr, regression

[3 Apr 2014 15:32] Laurynas Biveinis

Description:
-DWITH_EXAMPLE_STORAGE_ENGINE=ON breaks all_vars, mysqld--help-notwin

How to repeat:
cmake -DWITH_EXAMPLE_STORAGE_ENGINE=ON
make
./mysql-test-run all_vars
./mysql-test-run mysqld--help-notwin

Suggested fix:
not sure.

[3 Apr 2014 15:32] Laurynas Biveinis

sys_vars.all_vars                        [ fail ]
        Test ended at 2014-04-03 08:18:34

CURRENT_TEST: sys_vars.all_vars
--- /home/laurynas/percona/src/5.7/mysql-test/suite/sys_vars/r/all_vars.result	2014-03-31 20:35:48.933515000 +0300
+++ /home/laurynas/percona/src/5.7/obj-debug/mysql-test/var/log/all_vars.reject	2014-04-03 18:18:33.955911188 +0300
@@ -13,5 +13,13 @@
 select variable_name as `There should be *no* variables listed below:` from t2
 left join t1 on variable_name=test_name where test_name is null ORDER BY variable_name;
 There should be *no* variables listed below:
+EXAMPLE_DOUBLE_THDVAR
+EXAMPLE_DOUBLE_THDVAR
+EXAMPLE_DOUBLE_VAR
+EXAMPLE_DOUBLE_VAR
+EXAMPLE_ENUM_VAR
+EXAMPLE_ENUM_VAR
+EXAMPLE_ULONG_VAR
+EXAMPLE_ULONG_VAR
 drop table t1;
 drop table t2;

[3 Apr 2014 15:33] Laurynas Biveinis

main.mysqld--help-notwin                 [ fail ]
        Test ended at 2014-04-03 08:33:00

CURRENT_TEST: main.mysqld--help-notwin
--- /home/laurynas/percona/src/5.7/mysql-test/r/mysqld--help-notwin.result	2014-03-31 20:46:53.263179000 +0300
+++ /home/laurynas/percona/src/5.7/obj-debug/mysql-test/var/log/mysqld--help-notwin.reject	2014-04-03 18:32:59.983933363 +0300
@@ -199,6 +199,16 @@
  Enable the event scheduler. Possible values are ON, OFF,
  and DISABLED (keep the event scheduler completely
  deactivated, it cannot be activated run-time)
+ --example[=name]    Enable or disable EXAMPLE plugin. Possible values are ON,
+ OFF, FORCE (don't start if the plugin fails to load).
+ --example-double-thdvar=# 
+ 0.500000..1000.500000
+ --example-double-var=# 
+ 0.500000..1000.500000
+ --example-enum-var=name 
+ Sample ENUM system variable.
+ --example-ulong-var=# 
+ 0..1000
  -T, --exit-info[=#] Used for debugging. Use at your own risk.
  --expire-logs-days=# 
  If non-zero, binary logs will be purged after
@@ -1091,6 +1101,11 @@
 enforce-gtid-consistency FALSE
 eq-range-index-dive-limit 200
 event-scheduler OFF
+example ON
+example-double-thdvar 8.5
+example-double-var 8.5
+example-enum-var e1
+example-ulong-var 8
 expire-logs-days 0
 explicit-defaults-for-timestamp FALSE
 external-locking FALSE

[5 Apr 2014 8:11] MySQL Verification Team

Hello Laurynas,

Thank you for the bug report.
Verified as described.

Thanks,
Umesh