|
Contents
Index
<< Previous
Next >>
PDF
Known Bugs
|
|
Are there any errors known to exist in MySQL-Front?
| · | Date values are supported up from the 02/Jan/0001 only.
|
| · | Unsigned Bigint values are supported up to 63 bit only (values > 9223372036854775807 are not supported).
|
| · | SET NAMES CharacterSet; statements inside the SQL Editor will not be used to handle the encoding between the MySQL-Front and the MySQL database.
|
| · | 2147483647 records per table are supported only.
|
| Inside the MySQL database / tools there are some bugs which are not implemented in MySQL-Front:
|
| · | MySQL-Front does not support this invalid values (f. e. '00' as month or day, '2000-02-31').
|
| · | The MySQL client (mysql.exe) is not able to handle CREATE PROCEDURE / CREATE FUNCTION / CREATE TRIGGER / CREATE EVENT queries with a the delimiter ";" inside the body. Because of this the MySQL client needs to use the work-a-round with a DELIMITER statement. This DELIMITER statement is a statement for the MySQL client only - it's not a valid SQL statement. MySQL-Front does not have this problem and it does not implement this work-a-round with the DELIMTER statement.
|
| · | The MySQL client (mysql.exe) uses the pseudo statement SET NAMES to configure the character set communication between itself and the database. Since MySQL-Front is able to configure this setting like a standard application handle settings this pseudo statement is not implemented completely to speedup the program.
|
| Some wrong handlings seems to be program bugs - but they are problems of handling only:
|
| · | Error while importing SQL files: Please check the content of the SQL file. Maybe this SQL file is not written for the MySQL database or not for the used MySQL database version.
|
| · | All changes sent to the database by using the SQL Editor will not be overtaken automaticly inside MySQL-Front. The Refresh All feature has to be called to update MySQL-Front.
|
Should you detect any further errors or problems, please inform the developer via the forum - he will try to correct the problem as soon as possible.
|
|
