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

4.0.0
fixed
None
1
2013-06-11
2013-02-03
No

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

Discussion

  • 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..

     
  • Atul Pratap Singh

    • status: open --> open-fixed
    • assigned_to: Atul Pratap Singh
    • priority: 5 --> 1
     
  • Atul Pratap Singh

    Fixed in repository, thanks for reporting.

     
  • Atul Pratap Singh

    • summary: selecting rows using CHAR_LENGTH(keyfield)=keyvalue --> (ok 4.0) selecting rows using CHAR_LENGTH(keyfield)=keyvalue
     
  • Marc Delisle

    Marc Delisle - 2013-05-03
    • Status: open-fixed --> closed-fixed
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-fixed --> fixed