search

akirafreak / dtronix-upload

Automatically exported from code.google.com/p/dtronix-upload
0 stars 0 forks source link

Case sentitive file search #31

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
Currently the server is performing a case insensitive search on file request.  
Thus, searching for "1A" will bring up "1a" if it is first.

SELECT * FROM `files`
WHERE `url_id` = '%s'
LIMIT 1;

Needs to be:

SELECT * FROM `files`
WHERE `url_id` like binary '%s'
LIMIT 1;

Original issue reported on code.google.com by DJGosn...@gmail.com on 23 Feb 2011 at 4:29

GoogleCodeExporter commented 9 years ago 
This is also an issue with file deletion!

Original comment by DJGosn...@gmail.com on 23 Feb 2011 at 4:36

GoogleCodeExporter commented 9 years ago 
This issue was closed by revision r54.

Original comment by DJGosn...@gmail.com on 1 Mar 2011 at 10:42