[Bug 120575] Katapult is utilizing non-standard SQL which results in SQL errors in PostgreSQL and other standards compiant DBMS'.

[Michael D. Stemle, Jr.]

Public bug reported:

Set your amarok to use a PostgreSQL database (I'm using 8.2), import
your library, and then try to get katapult to work with a music track.
Notice that it doesn't show anything.

Watch your postgresql logs and you'll see errors such as:

2007-06-15 08:53:38 CDT STATEMENT:  SELECT a.name, t.title, t.deviceid, d.lastmountpoint, t.url, i.path, album.name FROM tags t LEFT JOIN statistics s ON t.url = s.url AND t.deviceid = s.deviceid LEFT JOIN artist a ON t.artist = a.id LEFT JOIN album ON t.album = album.id LEFT JOIN images i ON ( a.name = i.artist AND album.name = i.album) LEFT JOIN devices d ON t.deviceid = d.id WHERE 1 AND (t.title LIKE "%Doc/F%" OR a.name LIKE "%Doc/F%") ORDER BY a.name, t.title, s.percentage DESC
2007-06-15 08:53:39 CDT ERROR:  column "%Doc/F/%" does not exist at character 372

This is because double-quotes are being used in the SQL generated by
Katapult when single-quotes are the standard for string literals in SQL.

** Affects: katapult (Ubuntu)
     Importance: Undecided
         Status: Unconfirmed

-- 
Katapult is utilizing non-standard SQL which results in SQL errors in PostgreSQL and other standards compiant DBMS'.
https://bugs.launchpad.net/bugs/120575
You received this bug notification because you are a member of Kubuntu
Team, which is a bug contact for katapult in ubuntu.