[Sqlalchemy-tickets] Issue #3146: mysql client_flags option cannot be overriden (zzzeek/sqlalchemy)

[Mathieu L. <iss...@bi...>]

New issue 3146: mysql client_flags option cannot be overriden
https://bitbucket.org/zzzeek/sqlalchemy/issue/3146/mysql-client_flags-option-cannot-be

Mathieu Lacage:

Hi,

The mysql connector sets by default the FOUND_ROWS bit in the client_flag set on each connection with the server. The documentation is explicit about this (good): http://docs.sqlalchemy.org/en/rel_0_9/dialects/mysql.html#rowcount-support

However, the documentation also says that it is possible to override this setting through the client_flag url argument. While it is indeed possible to set manually this client_flag argument, the FOUND_ROWS bit is set unconditionally in dialects/mysql/mysqlconnector.py

Hence, the attached patch (generated against git master) to allow callers who know what they are doing to override this default behavior in sqlalchemy