Hi,
I was looking into bug #4527 https://sourceforge.net/p/phpmyadmin/bugs/4527/. While searching in MySQL documentation, I found [0] which clearly states that "Database, table, and column names cannot end with space characters". So what should be done in this case:
Should PMA automatically trim the trailing space characters and resume the import process?
Or
We should leave the scenario as it is i.e. let MySQL throw an error because there are many other constraints on the identifiers which also need to be checked?
[0] - http://dev.mysql.com/doc/refman/5.1/en/identifiers.html
Hi,
On Fri, Aug 29, 2014 at 7:55 PM, Ashutosh Dhundhara < ashutoshdhundhara@yahoo.com> wrote:
Hi,
I was looking into bug #4527 https://sourceforge.net/p/phpmyadmin/bugs/4527/. While searching in MySQL documentation, I found [0] which clearly states that "Database, table, and column names cannot end with space characters". So what should be done in this case:
Should PMA automatically trim the trailing space characters and resume the import process?
I think trimming would be better.
Or
We should leave the scenario as it is i.e. let MySQL throw an error because there are many other constraints on the identifiers which also need to be checked?
[0] - http://dev.mysql.com/doc/refman/5.1/en/identifiers.html
-- Ashutosh Dhundhara
Chirayu Chiripal a écrit :
Hi,
On Fri, Aug 29, 2014 at 7:55 PM, Ashutosh Dhundhara < ashutoshdhundhara@yahoo.com> wrote:
Hi,
I was looking into bug #4527 https://sourceforge.net/p/phpmyadmin/bugs/4527/. While searching in MySQL documentation, I found [0] which clearly states that "Database, table, and column names cannot end with space characters". So what should be done in this case:
Should PMA automatically trim the trailing space characters and resume the import process?
I think trimming would be better.
I confirm.
Or
We should leave the scenario as it is i.e. let MySQL throw an error because there are many other constraints on the identifiers which also need to be checked?
[0] - http://dev.mysql.com/doc/refman/5.1/en/identifiers.html
-
Ashutosh Dhundhara -
Chirayu Chiripal -
Marc Delisle