#3798 (ok 4.0) selecting rows using CHAR_LENGTH(keyfield)=keyvalue

[Julian Ladisch]

In 4.0.0-alpha2 (or latest git 0c967a7ee6) execute this in SQL tab:

DROP TABLE IF EXISTS t1;
CREATE TABLE t1 ( id INT NOT NULL, PRIMARY KEY (id) );
INSERT INTO t1 VALUES (2);
SELECT * FROM t1;

Now select that row and after the label "With selected:" click either Change, Delete or Export.

No row is used because of this wrong WHERE-clause:

WHERE CHAR_LENGTH( t1.id ) =2

[Atul Pratap Singh]

Maybe related to
https://github.com/phpmyadmin/phpmyadmin/commit/d9d92dda4670da467c718d6307031894ac9a4ca9

[Dulanja wijethunga]

It seems to be that only copy and edit buttons work....delete button doesn't work correctly.Although it can delete the raw using delete button ,when I refresh the page deleted raw appears again..

[Dulanja wijethunga]

I have worked on this and done a pull request

https://github.com/phpmyadmin/phpmyadmin/pull/156

[Atul Pratap Singh]

Fixed in repository, thanks for reporting.