← Back to team overview

maria-discuss team mailing list archive

Re: Giving up on dynamic columns


May I give you a general suggestion?

By default, MySQL/MariaDB tends to hide problems. Your case is an obvious example: as far as I understand your application doesn't check for warnings, everything seems to work, but data are truncated and dynamic columns are invalid.

I generally suggest to use a strict SQL_MODE. In your case, with STRICT_TRANS_TABLES and/or STRICT_ALL_TABLES, the insertion would fail with an error - and you would notice the problem. And even if your applications doesn't report the error, you could find it using SQL_ERRLOG.


Dom 1/3/15, Tom Worster <fsb@xxxxxxxxxx> ha scritto:

 Oggetto: Re: [Maria-discuss] Giving up on dynamic columns
 A: "maria-discuss email list" <maria-discuss@xxxxxxxxxxxxxxxxxxx>
 Data: Domenica 1 marzo 2015, 21:59
 so it turns out the
 problem is my incompetence. i thought blob allowed
 long values.
 i've been using mysql since 3.something and
 i still don't know much about
 abundance of types.
 retract my comments and crawl back into my hole.
 Mailing list: https://launchpad.net/~maria-discuss
 Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
 Unsubscribe : https://launchpad.net/~maria-discuss
 More help   : https://help.launchpad.net/ListHelp