Re: [sqlalchemy] Forcing filters to use same type as field

2017-02-22 Thread mike bayer
On 02/22/2017 04:23 PM, Chris Frey wrote: Hi, We're using MySQL, and we have tables that use a GUID as the ID. Unfortunately, if the GUID starts with a number, and if you select using an integer, mysql will helpfully convert for you: mysql> select id from table where id = 2;

[sqlalchemy] Forcing filters to use same type as field

2017-02-22 Thread Chris Frey
Hi, We're using MySQL, and we have tables that use a GUID as the ID. Unfortunately, if the GUID starts with a number, and if you select using an integer, mysql will helpfully convert for you: mysql> select id from table where id = 2; +-+ | id