> After content filtering, the message was empty Ok. I try to send plain text only with no attachments...
SQLite 3.8.6 2014-08-15 11:46:33 SQLite 3.11.0 Android ver. 5.0.2 Dear Sirs, I have problem with ORDER BY UPPER(...) in conjunction with UNION. The following query returns an error "1st ORDER BY term does not match any column in the result set". SELECT 0 as TableType, GroupId as RecordId, Name as Name FROM ProductGroup UNION SELECT 1 as TableType, ProductId as RecordId, Name as Name FROM Product ORDER BY UPPER(Name) When I replace the UPPER (Name) by Name - everything works correctly. Below I attached the database on which the error occurs. On the bug list, I found only simillar bug: http://www.sqlite.org/src/tktview?name=d06a25c844 Lukasz Stela INSOFT sp. z o.o. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users