MySQL Bugs: #42872: In MySQL 5.1.31, unrecognized --with-innodb, --with-partition, --with-federated

Bug #42872	In MySQL 5.1.31, unrecognized --with-innodb, --with-partition, --with-federated
Submitted:	16 Feb 2009 8:12	Modified:	15 Oct 2012 14:49
Reporter:	ws lee	Email Updates:
Status:	Unsupported	Impact on me:	None
Category:	MySQL Server: Compiling	Severity:	S3 (Non-critical)
Version:	5.1.31	OS:	Solaris (5.10)
Assigned to:	Kent Boortz	CPU Architecture:	Any

Description:

...

In MySQL 5.1.31, unrecognized --with-innodb --with-partition --with-federated-storage-engine configure option.

How to repeat:
gtar zxvf mysql-5.1.31.tar.gz
cd mysql-5.1.31
./configure --prefix=/usr/local/mysql5.1.31 --with-innodb --with-partition --with-federated-storage-engine
configure: WARNING: unrecognized options: --with-innodb, --with-partition, --with-federated-storage-engine
...
...

This is kind of ok, as these options are undocumented (see ./configure --help) backward compatibility options, the recommended ones are --with-plugin-innodb --with-plugin-federated --with-plugin-partition. But they also result in such a warning :(

Thank you for the report.

As Sergei said options --with-innodb, --with-partition, --with-federated are not supported. Supported options  --with-plugin-innodb --with-plugin-federated --with-plugin-partition don't produce warnings with current development sources anymore, although they did in version 5.1.31. Please wait next release or just ignore these warnings, because options really had effect.

In tar package, was used --with-partition' '--with-innodb' like before.

'--prefix=/usr/local/mysql' '--localstatedir=/usr/local/mysql/data' '--libexecdir=/usr/local/mysql/b
in' '--with-comment=MySQL Community Server (GPL)' '--with-server-suffix=' '--enable-thread-safe-client' '--enable-local-infile' '--b
uild=i386-pc-solaris2.10' '--with-mysqld-libs=-lmtmalloc' '--with-named-curses=-lcurses' '--with-pic' '--with-client-ldflags=-static
' '--with-mysqld-ldflags=-static' '--with-zlib-dir=bundled' '--with-big-tables' '--with-ssl' '--with-readline' '--with-embedded-serv
er' '--with-partition' '--with-innodb' '--without-ndbcluster' '--with-archive-storage-engine' '--with-blackhole-storage-engine' '--w
ith-csv-storage-engine' '--without-example-storage-engine' '--with-federated-storage-engine' '--with-extra-charsets=complex' 'build_
alias=i386-pc-solaris2.10' 'CC=/opt/studio12/SUNWspro/bin/cc' 'CFLAGS=-g -xO2 -mt -fsimple=1 -ftrap=%none -nofstore -xbuiltin=%all -
xlibmil -xlibmopt -xtarget=generic' 'CXX=/opt/studio12/SUNWspro/bin/CC' 'CXXFLAGS=-g -xO2 -mt -fsimple=1 -ftrap=%none -nofstore -xbu
iltin=%all -features=no%except -xlibmil -xlibmopt -xtarget=generic'

Sveta, whether you'll see a warning depends on the autotools you're using. Try autoconf 2.63, for example

Sergei, thank you.

With autoconf 2.63 problem is repeatable for me as well.

Encountered the same problems trying to build on a 64 Sparc. 

Attempting various combinations of --with-PLUGIN or --with-plugin-PLUGIN_NAME always gave warnings like:- 

configure: WARNING: unrecognized options: --with-named-z-libs, --with-archive, --with-innobase, --with-csv

However using the --with-plugins and supplying the plugins as a list worked...

--with-plugins=innobase,csv,archive

This 'bug' is still reported when compiling MySQL 5.1.34.  I have compiled using the --with-innodb flag and it does in fact compile with InnoDB, after I uncomment the InnoDB related stuff in /etc/my.cnf the MySQL server still starts.
Is this configure option going to be dropped, or is it a bug? If it's going to be dropped then what will replace it? If not then please fix the configure script!

bug#45056, bug#46073, bug#46871 were marked as duplicates of this bug

I would also note mysql error messages refers to this deprecated option:

mysql> create table testtbl (i int primary key) partition by key (i) partitions 5;
ERROR 1289 (HY000): The 'partitioning' feature is disabled; you need MySQL built with '--with-partition' to have it working
mysql> select version();
+-----------+
| version() |
+-----------+
| 5.1.38    |
+-----------+
1 row in set (0,00 sec)

Bug#47388 was marked a duplicate of this bug

Still present in 5.1.43

--with-plugins= format will get rid of warnings 

however, there is no feature to do --without-plugins=

I agree with the above commentary. There seems to be 3 ways to do this. I would suggest picking one, removing (don't deprecate) the others and let's clean this up once and for all.

From the autoconf point of view the warning is correct. plugin.m4 indeed checks $with_plugin_foo variables without declaring a --with-plugin-foo option using AC_ARG_WITH() macro. That is, --with-plugin-foo is properly flagged as unrecognized.

Two possible fixes, neither is perfect:

1. add AC_DISABLE_OPTION_CHECKING to configure.in
   this will turn off all warnings about unrecognized --with- or --enable
   including warnings for user mistakes like --with-big-tbales

2. In plugin.m4 add a line to the _MYSQL_PLUGIN macro:

   m4_define([$2], [$1])
+  _AC_ENABLE_IF([with],[plugin-$1])
   _MYSQL_PLUGAPPEND([__mysql_plugin_list__],[$1])

   it will register --with-plugin-XXX options for all plugins, making them recognized. Drawback - it's undocumented internal autoconf macro. Perhaps not portable across autoconf version, best to wrap it in m4_ifdef:

   m4_ifdef([_AC_ENABLE_IF], [AC_ENABLE_IF([with],[plugin-$1])])

Bug #52147 was marked as duplicate of this one.

Hi, 

still present in 5.1.45?

./configure --prefix=/usr/local/mysql --with-charset=latin1 --with-mysqld-user=mysql  --without-debug --enable-thread-safe-client --with-client-ldflags=-all-static --with-mysqld-ldflags=-all-static --disable-shared --with-plugin-heap --with-plugin-innobase --with-plugin-innodb_plugin --with-plugin-myisam --with-plugin-archive

However:
configure: WARNING: unrecognized options: --with-plugin-heap, --with-plugin-innobase, --with-plugin-innodb_plugin, --with-plugin-myisam, --with-plugin-archive

Regards,
Werner

Bug #54237 was marked as duplicate of this one.

This only show in GNU autotools based builds, and from 5.5 and on we use
CMake.