On Fri, Nov 3, 2017 at 12:28 AM, <jens.troe...@gmail.com> wrote: > Hm. I enabled strict mode, and sure enough the warning turns into an > exception. > > Alas, it seems that the flush() in the above example does not cause the > exception, it happens later when the query executes. I was looking for a way > to preempt that exception: the code runs within a view function of a Pyramid > view handler which commits the transaction outside of the view function.
does it really do that? what happens if you log in to the MySQL console and just SELECT, or check the length of the actual data, is it the 10K * 3 characters you put in? I'm not sure how it would not warn the data is truncated upon storage, but somehow knows upon query that it was, it sounds like that's not what's actually happening here, and it's something else about the query. can you send me a short reproduction script? > > Looks like a manual check is needed :-) > > > On Friday, November 3, 2017 at 12:04:54 PM UTC+10, Mike Bayer wrote: >> >> the most appropriate way is to set strict SQL mode on your MySQL database: >> >> https://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sql-mode-strict >> > > -- > SQLAlchemy - > The Python SQL Toolkit and Object Relational Mapper > > http://www.sqlalchemy.org/ > > To post example code, please provide an MCVE: Minimal, Complete, and > Verifiable Example. See http://stackoverflow.com/help/mcve for a full > description. > --- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to sqlalchemy+unsubscr...@googlegroups.com. > To post to this group, send email to sqlalchemy@googlegroups.com. > Visit this group at https://groups.google.com/group/sqlalchemy. > For more options, visit https://groups.google.com/d/optout. -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.