Queries fail - no such column

Binary package hint: bacula-director-sqlite

Apparently there is something wrong with quoting when bacula creates the SQL strings to query it's database.

Reproduce: connect to the director via "bconsole" (or gnome-console...), execute the QUERY command. Then choose one of the queries shown below. It seems the SQL is built incorrectly, for example:

    ... WHERE JobMedia.MediaId=STRING ...

STRING should be quoted with single ticmarks, like 'STRING'.

This is bacula-director-sqlite 1.36.3-2ubuntu2 on Dapper.

Choose a query (1-15): 14
Enter MediaId: BAK002L3
Query failed: no such column: BAK002L3
SELECT DISTINCT Job.JobId,Job.Name,Job.StartTime,Job.Type, Job.Level,Job.JobFiles,Job.JobBytes,Job.JobStatus FROM JobMedia,Job WHERE JobMedia.JobId=Job.JobId AND JobMedia.MediaId=BAK002L3 ORDER by Job.StartTime;

Choose a query (1-15): 13
Enter JobId: valar_all
Query failed: no such column: valar_all
SELECT Path.Path,Filename.Name FROM File,Filename,Path WHERE File.JobId=valar_all AND Filename.FilenameId=File.FilenameId AND Path.PathId=File.PathId ORDER BY Path.Path,Filename.Name;

Choose a query (1-15): 8
Enter JobId: valar_all
Query failed: no such column: valar_all
SELECT DISTINCT Job.JobId,VolumeName FROM Job,JobMedia,Media WHERE Job.JobId=valar_all AND Job.JobId=JobMedia.JobId AND JobMedia.MediaId=Media.MediaId;