UNION combined with SERVICE doesn't return correct results
I'm still trying to get queries from GNOME Photos to work. These rely on big UNION statement so it can search through albums and photos using one query.
Attached is a script which demonstrates 3 broken UNION queries. When I run the script, I see the following output:
Opening database at /tmp/db…
New database created. Use the “--dbus-service” option to share this database on a message bus.
Using photo urn:bnode:86a79b7f-d9c9-429b-af05-dbe06899bda4
Done
Testcase 1: should show 1 result
Results:
None
Testcase 2: should show 1 result
Could not run query, no such column: Left.v_file
Testcase 3: should show 1 result
Results:
urn:bnode:86a79b7f-d9c9-429b-af05-dbe06899bda4, v_file, v_filename
Testcase 3 could be considered user error (although Tracker's response seems wrong). The other two are just wrong.