MySQL Bugs: #34833: repeatable is not documented as a valid tx

Bug #34833	repeatable is not documented as a valid tx_isolation level
Submitted:	26 Feb 2008 12:43	Modified:	18 Apr 2008 16:26
Reporter:	Rizwan Maredia	Email Updates:
Status:	Closed
Category:	Server: Docs	Severity:	S3 (Non-critical)
Version:	5.1.22	OS:	Microsoft Windows
Assigned to:	Paul DuBois	Target Version:
Tags:	tx_isolation, REPEATABLE-READ, repeatable
Triage:	D4 (Minor)

Description:
When REPEATABLE is set to tx_isolation it is treated as REPEATABLE-READ and does not give
error.

How to repeat:
Following code snippet shows how to reproduce the bug (using mysql test environment).

Sample Code: 
SET @@global.tx_isolation = 'REPEATABLE';
SELECT @@global.tx_isolation;

Output:
SET @@global.tx_isolation = 'REPEATABLE';
SELECT @@global.tx_isolation;
@@global.tx_isolation
REPEATABLE-READ

Suggested fix:
The alias REPEATABLE for REPEATABLE-READ must be documented or should give error.

Thank you for a problem report. I agree that if this is intended behaviour the following
pages:

http://dev.mysql.com/doc/refman/5.0/en/innodb-transaction-isolation.html
http://dev.mysql.com/doc/refman/5./en/innodb-transaction-isolation.html

should be updated.

Thank you for your bug report. This issue has been addressed in the documentation. The
updated documentation will appear on our website shortly, and will be included in the
next release of the relevant products.

REPEATABLE is not an alias for REPEATABLE-READ. It turns out that what's going on here is
that the value can be set using any unique prefix of a valid value. The same is also true
for query_cache_type and myisam_stats_method.