[Druid-users] problem w/ MySQL module's table type option

[Ben F. <be...@au...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

[Not sure if this would be better suited to the druid-devel list, but I
won't cross-post just yet]

Hey folks,

I'm having a problem w/ the Druid (v3.8) MySQL module's "Table type"
option. I found the problem while investigating warnings I saw while
creating my MySQL tables using the Druid generated script.

You can find this option by clicking on a (MySQL) table, selecting the
"Option" tab along the top tab list, then selecting the "Modules" tab
along the lower tab list.  At the bottom of the frame is a box titled
"General" w/ a combo box title "Table type".  The possible options are
"InnoDB" and "MyISAM".  This option controls the generation of the MySQL
"TYPE=storage_engine" directive at the close of the table create statement

I am using MySQL server v5.0.22.  It appears that in v5.0.22 or before
the "TYPE=storage_engine" directive was deprecated in favor of the new
"ENGINE=storage_engine" directive. I get the following warnings from my
Druid-generated table create statements:

Warning (Code 1287): 'TYPE=storage_engine' is deprecated; use
'ENGINE=storage_engine' instead

Is there a way to configure the Druid MySQL module to use "ENGINE" in
place of "TYPE"?  If not, could this be made configurable in a future
release of the MySQL module?

Even better (but more involved) would be to create a MySQL module
setting at the database-level for the MySQL version.  Then based on the
version specified, the MySQL syntax generated by the module could be
tweaked.

I know the iptables output module of Firewall Builder
<http://www.sourceforge.net/projects/fwbuilder/> does something like
this by using an simple iptables version setting ["1.2.9 or later",
"1.2.6 to 1.2.8", "1.2.5 or earlier"] to determine the supported
iptables syntax for generation.

Regards,
Ben

- --
Ben Feinstein, CISSP
CTO & Vice President
Audiun, Inc.
227 Peachtree Circle NE
Suite B
Atlanta, GA 30309
404-474-1199 (Voice)
404-474-7689 (FAX)
be...@au...

CONFIDENTIALITY NOTICE: This e-mail transmission and the attachments
accompanying it may contain confidential information.  The information
is intended only for the use of the intended recipient.  If you are not
the intended recipient, you are hereby notified that any disclosure,
copying, distribution, or the taking of any action in reliance on the
contents of this information is strictly prohibited.  Any unauthorized
interception of this transmission is illegal under the law.  If you have
received this transmission in error, please promptly notify the sender
by reply e-mail and destroy all copies of the transmission.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.4 (GNU/Linux)

iD8DBQFEz8tCPy7Lg/DIKQgRAn5LAKDC1ZLBXhKKg6o0sdd5V/wwnMMdLgCfWf/T
VeUk3sTu0IGhC3qvf3GqqVo=
=dPOy
-----END PGP SIGNATURE-----