[Phpmyadmin-devel] strange " bug

Alain Brissaud alain at brissaud.com
Tue Aug 7 19:43:07 CEST 2001


Hello,

Step 1 :
CREATE TABLE `test` (`id` VARCHAR(50) not null, `txt` VARCHAR(50) not null ,
PRIMARY KEY (`id`), INDEX (`id`));
INSERT INTO `test` (`id`, `txt`) VALUES ('1', 'test "test" test');

Step 2 :
Use phpmyadmin to Select id 1 (using tbl_select.php3),
Click Edit (do nothing) then click save.

<phpmyadmin>
SELECT `id`,`txt` FROM `test` WHERE 1 AND `id` LIKE \"1\" LIMIT 0, 30
MySQL said:  You have an error in your SQL syntax near '\"1\" LIMIT 0, 30' at
line 1
</phpmyadmin>

No problem if you key is an int. Yuk.

Regards,

Alain.





More information about the Developers mailing list