MySQL check for case sensitivity in reflecttable raise ValueError for MySQL 4.0

[Former user]

Currently, to check for case sensitivity, MySQLDialect executes "show variables like 'lower_case_table_names'" and fetches the first row's value. In MySQL 5.0, this will be a string "1" or "0", but in older versions (at least in 4.0, where I am testing) it returns "ON" or "OFF", so the subsequent cast to integer raises a ValueError.

See line 347 in databases/mysql.py.

[Mike Bayer]

wow we keep having to massage that line, for returning numbers, strings, arrays...now "ON" and "OFF" eh ? OK....what exact version of mysql, out of curiousity ?

[Former user]

mysql> select version();
+---------------------+
| version()           |
+---------------------+
| 4.0.15-standard-log |
+---------------------+
1 row in set (0.00 sec)

Pretty sad that we're still using this version...

[jek]

This is addressed in 81f42181f431eb8ea96c94ee8a2d798f11a296e7.

[Mike Bayer]

Removing milestone: 0.3.9 (automated comment)