After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 721199 - Search (upnp:class derivedFrom "object.item.imageItem" and @refID exists false) in "Artist" virtual container fails
Search (upnp:class derivedFrom "object.item.imageItem" and @refID exists fals...
Status: RESOLVED OBSOLETE
Product: rygel
Classification: Applications
Component: MediaExport plugin
git master
Other Linux
: Normal normal
: ---
Assigned To: Jens Georg
rygel-maint
Depends on:
Blocks:
 
 
Reported: 2013-12-29 14:10 UTC by Jens Georg
Modified: 2018-05-22 12:43 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Jens Georg 2013-12-29 14:10:36 UTC 
Search fails with "SQLite error 1: no such column: m.class"
Comment 1 Jens Georg 2013-12-30 22:43:34 UTC 
looks like actually using the sort_criteria lead to removing the hard-coded sorting by m.class which in turn caused an implicit select on that field...

The SQL wasn't right in the first place and only worked by accident.
Comment 2 Jens Georg 2013-12-31 13:49:28 UTC 
eh

Could someone explain me, why 

SELECT 'all_place_holder' AS _column , 1 , 1 UNION SELECT DISTINCT m.album AS _column ,m.class,1 FROM meta_data AS m WHERE _column IS NOT NULL  AND ((m.class = 'object.item.audioItem.musicTrack' ) AND (m.author = 'Dire Straits')) ORDER BY m.class  ASC ,_column ASC LIMIT 0,10;

works in the sqlite3 binary but not in the media-export plugin?
Comment 3 Jens Georg 2014-01-03 11:51:10 UTC 
Seems to be related to that "union"
Comment 4 Jens Georg 2017-05-02 08:36:36 UTC 
This is partially "fixed" by removing the union with commit 48c10b636ef8bd94c164753afd957182019198b8
Comment 5 GNOME Infrastructure Team 2018-05-22 12:43:32 UTC 
-- GitLab Migration Automatic Message --

This bug has been migrated to GNOME's GitLab instance and has been closed from further activity.

You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/rygel/issues/60.