Bug #42872 In MySQL 5.1.31, unrecognized --with-innodb, --with-partition, --with-federated
Submitted: 16 Feb 9:12 Modified: 16 Feb 10:49
Reporter: Lee Wonseok
Status: Verified
Category:Server: Compiling Severity:S3 (Non-critical)
Version:5.1.31 OS:Sun Solaris (5.10)
Assigned to: Kent Boortz Target Version:5.1+
Triage: Triaged: D3 (Medium)

[16 Feb 9:12] Lee Wonseok
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
...
...
[16 Feb 9:57] Sergei Golubchik
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
:(
[16 Feb 10:10] Sveta Smirnova
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.
[16 Feb 10:15] Lee Wonseok
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'
[16 Feb 10:49] Sergei Golubchik
Sveta, whether you'll see a warning depends on the autotools you're using. Try autoconf
2.63, for example
[16 Feb 11:15] Sveta Smirnova
Sergei, thank you.

With autoconf 2.63 problem is repeatable for me as well.
[23 Mar 13:01] Max von Seibold
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
[13 May 3:05] Iain Kay
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!
[23 Aug 18:25] Sergei Golubchik
bug#45056, bug#46073, bug#46871 were marked as duplicates of this bug
[15 Sep 8:21] Alexey Kishkin
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)
[18 Sep 10:39] Sergei Golubchik
Bug#47388 was marked a duplicate of this bug