An update to this.
I cant vouch for this exact query - on my system it takes a looonnggg
time to finish due to the 2 million plus files recorded and I gave up
and canceled it, but the following simplified version worked:
mysql> select Name from Filename where LCASE(Name) = 'makedev';
+---------+
| Name |
+---------+
| MAKEDEV |
+---------+
1 row in set (1.15 sec)
So I dont understand why it wouldn't work in the other query - but I'm
not a MySQL Guru.
I am running MySQL Server 3.23.58 tho which could be the difference I
suppose.
Cheers,
Troy.
Cedric Tefft wrote:
Troy Daniels wrote:
Under MySQL you can use the LCASE() (Or UCASE if you prefer) function
to do something like:
SELECT DISTINCT Job.JobId as JobId, Client.Name as Client,
Path.Path,Filename.Name,StartTime,Level,JobFiles,JobBytes
FROM Client,Job,File,Filename,Path WHERE Client.ClientId=Job.ClientId
AND JobStatus='T' AND Job.JobId=File.JobId
AND Path.PathId=File.PathId AND Filename.FilenameId=File.FilenameId
AND LCASE(Filename.Name)='filenameinlowercase.doc'
ORDER BY Job.StartTime LIMIT 20;
Have you actually tried this? It didn't work for me. I suspect this is
because LCASE is designed to operate on text fields and, as Mark pointed
out, the Name field is defined as a binary object.
- Cedric
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live
webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
-------------------------------------------------------
This SF.Net email is sponsored by xPML, a groundbreaking scripting language
that extends applications into web and mobile media. Attend the live webcast
and join the prime developer group breaking into this new coding territory!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=110944&bid=241720&dat=121642
_______________________________________________
Bacula-users mailing list
Bacula-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-users
