MySQL Bugs: #80991: Wrong variable documented on mysql 5.1

Bug #80991	Wrong variable documented on mysql 5.1
Submitted:	7 Apr 2016 8:26	Modified:	7 Apr 2016 10:17
Reporter:	Ivan Garcia	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server: Documentation	Severity:	S3 (Non-critical)
Version:	5.1.73	OS:	Red Hat
Assigned to:		CPU Architecture:	Any
Tags:	innodb_strict_mode, MySQL5.1, variable

Description:
Found that on the docu for MySQL 5.1 exists the variable innodb_stric_mode although it's impossible to set it up:

Docu: http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_strict_mode

Variable:
mysql> show global variables like '%stri%';
Empty set (0.00 sec)

Config file:
# cat /etc/my.cnf | grep -i strict
innodb_strict_mode=ON

Log error:
Log:
160407 09:24:36 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160407  9:24:36  InnoDB: Initializing buffer pool, size = 2.0G
160407  9:24:36  InnoDB: Completed initialization of buffer pool
160407  9:24:36  InnoDB: Started; log sequence number 0 44556
160407  9:24:36 [ERROR] /usr/libexec/mysqld: unknown variable 'innodb_strict_mode=ON'
160407  9:24:36 [ERROR] Aborting

160407  9:24:36  InnoDB: Starting shutdown...
160407  9:24:42  InnoDB: Shutdown completed; log sequence number 0 44556
160407  9:24:42 [Note] /usr/libexec/mysqld: Shutdown complete

160407 09:24:42 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

How to repeat:
Set the option on the my.cnf:

# cat /etc/my.cnf | grep -i strict
innodb_strict_mode=ON

Suggested fix:
Remove the variable from the documentation for mysql-server version 5.1

Hello Ivan,

Thank you for the report.
Imho in 5.1, innodb_strict_mode was available when using innodb plugin and not with the in-built innodb. 

-- With in-built innodb

160407 12:00:25 [ERROR] libexec/mysqld: unknown option '--innodb_strict_mode'
160407 12:00:25 [ERROR] Aborting

-- With innodb plugin (needed --ignore-builtin-innodb --plugin-load=innodb=ha_innodb_plugin.so)

[umshastr@hod03]/export/umesh/server/binaries/mysql-5.1.77: libexec/mysqld --basedir=/export/umesh/server/binaries/mysql-5.1.77 --datadir=/export/umesh/server/binaries/mysql-5.1.77/80990 --core-file --socket=/tmp/mysql_ushastry.sock  --port=15000 --log-error=/export/umesh/server/binaries/mysql-5.1.77/80990/log.err --ignore-builtin-innodb --plugin-load=innodb=ha_innodb_plugin.so --innodb_strict_mode 2>&1 &
[1] 20731
[umshastr@hod03]/export/umesh/server/binaries/mysql-5.1.77:
[umshastr@hod03]/export/umesh/server/binaries/mysql-5.1.77:
[umshastr@hod03]/export/umesh/server/binaries/mysql-5.1.77: bin/mysql -uroot -S /tmp/mysql_ushastry.sock
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.77 Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show global variables like '%stri%';
+--------------------+-------+
| Variable_name      | Value |
+--------------------+-------+
| innodb_strict_mode | ON    |
+--------------------+-------+
1 row in set (0.00 sec)

Thanks,
Umesh