Hi,
After upgrading from SQLite 3.8.6 to 3.8.7, I am no longer able to
order group_concat values by using a subselect. For example the
following query with 3.8.6 will give me an ordered string of
items.image values based on items.position (which contains integers):
SELECT products.name, GROUP_CONCAT(items.image) AS item_images
FROM products
INNER JOIN (
SELECT * FROM items ORDER BY position
) AS items ON (items.product_id = products.id)
GROUP BY products.id
ORDER BY products.name
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
