Menu

#469 Adminer editor search anywhere bug

Git
closed-out-of-date
nobody
None
5
2018-01-24
2015-09-02
No

Search anywhere retun bad result when table has some DATE (DATETIME, etc.) columns.

Search blahblah in Adminer Editor (SQL from html source):
SELECT * FROM abc WHERE (id LIKE 'blahblah' OR some_date IN ('blahblah'))

Search blahblah in Adminer:
SELECT * FROM abc WHERE (id LIKE 'blahblah' OR some_date LIKE 'blahblah')

Adminer Editor returns all rows where some_date is 0000-00-00

Discussion

  • Jakub Vrána

    Jakub Vrána - 2018-01-24
    • status: open --> closed-out-of-date
     
  • Jakub Vrána

    Jakub Vrána - 2018-01-24

    This works now.

     

Log in to post a comment.

MongoDB Logo MongoDB