Marc Delisle a écrit :

Sebastian Mendel a écrit :

...

Hi,

please can anybody heavily test with MySQL 5 in strict mode, as there are many errors with current PMA!

http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html#id2968483

I'll test this week-end.

Marc

Sebastian, what would you like to happen in PMA? Currently we report the MySQL error message (out of range value, invalid date, etc). Do you feel we should redisplay the screen that produced the error, so user can adjust his values?

Marc

Alexander M. Turek a écrit :

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1

Hi,

Sebastian Mendel schrieb:

...

please can anybody heavily test with MySQL 5 in strict mode, as there are many errors with current PMA!

PMA should be able to witch the SQL mode for its session. Why don't we run PMA that way instead? Making PMA compatible to MySQL 5's strict mode could be painful and could take a bit more time.

Regards,

AMT

Starting with MySQL 4.1, we can switch the mode. In fact, we are already doing it in libraries/export/sql.php. But what if the user or sysadmin really wants to check the behavior in ANSI mode? Forcing the mode to non-script would block users to verify this behavior.

We could even offer in a future version, a "mode switcher" for users!

Marc

Hi there,

Marc Delisle schrieb:

...

Starting with MySQL 4.1, we can switch the mode. In fact, we are already doing it in libraries/export/sql.php. But what if the user or sysadmin really wants to check the behavior in ANSI mode? Forcing the mode to non-script would block users to verify this behavior.

I meant "non-strict"!

You're right, I did not think of this. So maybe, we should add a dropdown box to our SQL input boxes and the file upload dialog, that allows the user to choose the desired SQL mode. The default value should be the actual SQL mode of the current server.

It shouldn't be problematic to switch the SQL mode before and after executing the user's commands.

Regards,

AMT