[tdavis]

As much as anything else, this is another great example of MySQL letting you shoot yourself in the face by default. I also love that you can save "y" to an integer field without complaint. It seems obvious that accurate data validation and comparison would be the cornerstone of a successful relational database, yet MySQL defaults fail to provide any domain-relevant value whatsoever.

[ars]

bin is not an integer field. It's a binary field - it can save anything.

And no, you can not save 'y' to an integer field, so your rant is misplaced.

[mbrubeck]

I think tdavis is referring to this example from maciej's post, where inserting 'y' into a tinyint field silently converts it to 0 instead of throwing an error:

     mysql> create table demo(int tinyint(1), bin binary(1));
     mysql> insert into demo(int, bin) values ('y', 'y');
     mysql> select * from demo;

     +------+------+
     | int  | bin  | 
     +------+------+
     |    0 | y    |
     +------+------+

[ars]

It's not silent:

    mysql> insert into demo values ('y', 'y');
    Query OK, 1 row affected, 1 warning (0.01 sec)

    mysql> show warnings;
    +---------+------+------------------------------------------------------+
    | Level   | Code | Message                                              |
    +---------+------+------------------------------------------------------+
    | Warning | 1366 | Incorrect integer value: 'y' for column 'n' at row 1 |
    +---------+------+------------------------------------------------------+

If you want this type of warning to be treated as an error then adjust the setting:

    mysql> SET sql_mode = 'TRADITIONAL';
    mysql> insert into demo values ('y', 'y');
    ERROR 1366 (HY000): Incorrect integer value: 'y' for column 'n' at row 1

[msbarnett]

Which brings us right back to what tdavis said in the first place: "As much as anything else, this is another great example of MySQL letting you shoot yourself in the face by default."

[ars]

You are aware that this whole thing is theoretical since he set the field to bin (i.e. binary)? No database at all would have prevented this.

MySQL chose to coerce fields to fit the type. You don't like that choice, but other people find it useful. And MySQL gives you a choice to change it if you wish.

Judging by how popular and successful they are I think those chose correctly.

[brlewis]

This article is a success story for MySQL because maciej is using MySQL.

This article is a failure story for maciej. MySQL may have chosen correctly for its own popularity (although that's debatable; this choice might not be a success factor) but it did not choose correctly for the success of its users, with this article being a clear example.

[drivebyacct2]

It's not theoretical. MySQL by default allowed type coercion out-of-box that is nonsensical. Sure, type coercion can be nice, but I'd prefer none over if it not failing and coercing bin('y') to 0.

Attributing their success to their choice of DB is insulting at best.

[obtu]

MySQL's warnings are silent, in the sense that the web application will never act on them. Guessing instead of failing early is a poor choice for a relational database, and is only explained by MySQL favouring ease of use and porting over data integrity.