Bug #30934 example storage engine included in windows build
Submitted: 10 Sep 2007 14:54 Modified: 14 Sep 2007 9:09
Reporter: Shane Bester Email Updates:
Status: Closed
Category:Server: Docs Severity:S3 (Non-critical)
Version:5.0.48 OS:Microsoft Windows (5.0.48-enterprise-gpl-nt)
Assigned to: MC Brown Target Version:
Triage: D4 (Minor)

[10 Sep 2007 14:54] Shane Bester
Description:
Seems there's an (undocumented) change in 5.0.48 on Windows.

mysql> select version();
+--------------------------+
| version()                |
+--------------------------+
| 5.0.48-enterprise-gpl-nt |
+--------------------------+
1 row in set (0.00 sec)

mysql> show engines;
+------------+---------+------------------------
| Engine     | Support | Comment
+------------+---------+------------------------
| MyISAM     | DEFAULT | Default engine as of My
| MEMORY     | YES     | Hash based, stored in m
| InnoDB     | YES     | Supports transactions,
| BerkeleyDB | NO      | Supports transactions a
| BLACKHOLE  | YES     | /dev/null storage engin
| EXAMPLE    | YES     | Example storage engine  <----
| ARCHIVE    | YES     | Archive storage engine
| CSV        | NO      | CSV storage engine
| ndbcluster | NO      | Clustered, fault-tolera
| FEDERATED  | YES     | Federated MySQL storage
| MRG_MYISAM | YES     | Collection of identical
| ISAM       | NO      | Obsolete storage engine
+------------+---------+------------------------
12 rows in set (0.00 sec)

mysql> select version();
+--------------------------+
| version()                |
+--------------------------+
| 5.0.46-enterprise-gpl-nt |
+--------------------------+
1 row in set (0.00 sec)

mysql> show engines;
+------------+---------+--------------------------------
| Engine     | Support | Comment
+------------+---------+--------------------------------
| MyISAM     | DEFAULT | Default engine as of MySQL 3.23
| MEMORY     | YES     | Hash based, stored in memory, u
| InnoDB     | YES     | Supports transactions, row-leve
| BerkeleyDB | NO      | Supports transactions and page-
| BLACKHOLE  | YES     | /dev/null storage engine (anyth
| EXAMPLE    | NO      | Example storage engine 
| ARCHIVE    | YES     | Archive storage engine
| CSV        | NO      | CSV storage engine
| ndbcluster | NO      | Clustered, fault-tolerant, memo
| FEDERATED  | YES     | Federated MySQL storage engine
| MRG_MYISAM | YES     | Collection of identical MyISAM
| ISAM       | NO      | Obsolete storage engine
+------------+---------+--------------------------------
12 rows in set (0.00 sec)

How to repeat:
show engines;

try to find the change in
http://dev.mysql.com/doc/refman/5.0/en/releasenotes-es-5-0-48.html

Suggested fix:
add note to http://dev.mysql.com/doc/refman/5.0/en/releasenotes-es-5-0-48.html if
additional engines are available.
[10 Sep 2007 15:53] Miguel Solorzano
Thank you for the bug report.
[14 Sep 2007 9:09] MC Brown
A note has been added to the documentation to note that the EXMAPLE engine is now enbaled
by default.