- this fix don't modify the pgsql nor the mysql query, ONLY the sqlite
query, is modified. The code is duplicated and modified ONLY for sqlite,
- fix the "UNION": syntax error that come when running a VF
- the fix just remove the () and a useless "order by"
- I think this query could be used for pgsql & mysql too.
- tests/virtual-backup-test
12-Aug 11:38 127.0.0.1-dir JobId 8: Error: Query failed: SELECT Path, Filename, FileIndex, JobId, LStat, DeltaSeq , JobTDate FROM ((SELECT Path.Path, T1.Filename, T1.FileIndex, T1.JobId, LStat, DeltaSeq , JobTDate FROM ( SELECT FileId, Job.JobId AS JobId, FileIndex, File.PathId AS PathId,File.Filename AS Filename, LStat , File.DeltaSeq AS DeltaSeq,Job.JobTDate AS JobTDate FROM Job, File, (SELECT MAX(JobTDate) AS JobTDate, PathId, Filename, DeltaSeq FROM (SELECT JobTDate, PathId, Filename, DeltaSeq FROM File JOIN Job USING (JobId) WHERE File.JobId IN (1,2,3,4,5,6) UNION ALL SELECT JobTDate, PathId, Filename, DeltaSeq FROM BaseFiles JOIN File USING (FileId) JOIN Job ON (BaseJobId = Job.JobId) WHERE BaseFiles.JobId IN (1,2,3,4,5,6) ) AS tmp GROUP BY PathId, Filename, DeltaSeq ) AS T1 WHERE (Job.JobId IN ( SELECT DISTINCT BaseJobId FROM BaseFiles WHERE JobId IN (1,2,3,4,5,6)) OR Job.JobId IN (1,2,3,4,5,6)) AND T1.JobTDate = Job.JobTDate AND Job.JobId = File.JobId AND T1.PathId = File.PathId AND T1.Filename = File.Filename ) AS T1 JOIN Path ON (Path.PathId = T1.PathId) WHERE FileIndex > 0 ) UNION (SELECT ObjectName AS Path, PluginName AS Filename, FileIndex, JobId, '' AS LStat, 0 AS DeltaSeq , JobTDate FROM Job JOIN RestoreObject USING (JobId) WHERE JobId IN (1,2,3,4,5,6) ORDER BY JobTDate ASC, FileIndex ASC) ) AS U1 ORDER BY JobTDate, FileIndex ASC: ERR=near "UNION": syntax error