'key' column name getting interpreted at MySQL keyword KEY

[ecomdev]

'key' column name getting interpreted at MySQL keyword KEY

[jedgalbraith]

From what I've found out so far, this appears to be more of an issue with Magento/Varien core than with EcomDev_PHPUnit directly.

As a temporary workaround I've overridden the file at app/code/local/Varien/Db/Adapter/Pdo/Mysql.php:1901 and added backticks:
$updateFields[] = sprintf('%s = %s', $field, $value);

Feel free to close this if you also agree with my assessment.

[IvanChepurnyi]

Yeap, totally agree. Maybe it is better for you just change the name of column to not conflict with mysql keywords?

[jedgalbraith]

If I changed the name of the column, I'd also have to modify all the references to it in the Mage_Oauth module. But, regardless, not an EcomDev_PHPUnit issue, so I'll close this out. Thanks for the response.