Bug #15760 fill_help_tables.sql doesn't work in strict mode
Submitted: 14 Dec 2005 22:17 Modified: 24 Jan 2006 15:54
Reporter: Tobias Asplund Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:5.0.16 OS:Windows (Windows)
Assigned to: Paul DuBois CPU Architecture:Any

[14 Dec 2005 22:17] Tobias Asplund
The table structure of the mysql-database help tables are not defined in a way so that they work with the fill_help_tables.sql script in strict mode.

Since this is the recommended way to run MySQL under Windows (comes pre-set if you use the installer) it should work.
In combination with bug #15759 this gets quite serious.

How to repeat:
Make sure your server runs in strict mode.

C:\>mysql mysql < fill_help_tables.sql
Enter password: ****
ERROR 1364 (HY000) at line 27: Field 'url' doesn't have a default value
[14 Dec 2005 22:17] Tobias Asplund
Forgot some information in initial submission.
[15 Dec 2005 16:03] MySQL Verification Team
C:\Arquivos de programas\MySQL\MySQL Server 5.0\bin>mysql -uroot mysql < fill_help_tables.sql
ERROR 1364 (HY000) at line 22: Field 'url' doesn't have a default value
[18 Jan 2006 19:19] Lenz Grimmer
The Help tables SQL file was now fixed to be strict mode compatible. It should be included in future releases (for 5.0.19 and up).
[20 Jan 2006 1:41] Paul DuBois
Note in 5.0.19 changelog.

          The contents of <filename>file_help_tables.sql</filename>
          could not be loaded in strict SQL mode. (Bug #15760)
[24 Jan 2006 13:31] Lenz Grimmer
Actually, the correct file name is "fill_help_tables.sql" - can you please fix the changelog in the manual?
[24 Jan 2006 15:54] Paul DuBois
Fixed, thanks.