The left-most of the first select? Or the second? Maybe I don't understand 'left-most?'
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp Sent: Thursday, September 05, 2013 9:36 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Collating sequences. Was: Query problems On Thu, Sep 5, 2013 at 9:31 AM, Igor Tandetnik <i...@tandetnik.org> wrote: > On 9/5/2013 7:31 AM, Richard Hipp wrote: > >> There seems to be some misinformation circulating in this thread. >> Please let me try to clear up a few points. >> > > While we are at it, an interesting question was raised upthread. What > happens here: > > create table t1(x text collate c1); > create table t2(x text collate c2); > > select x from t1 > union > select x from t2 > order by x; > > Which collation is used by UNION to deduplicate? Which collation is > used by ORDER BY to sort? > The left-most. http://www.sqlite.org/src/artifact/8b148eb851f?ln=1582-1602 -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users This email and any attachments are only for use by the intended recipient(s) and may contain legally privileged, confidential, proprietary or otherwise private information. Any unauthorized use, reproduction, dissemination, distribution or other disclosure of the contents of this e-mail or its attachments is strictly prohibited. If you have received this email in error, please notify the sender immediately and delete the original. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users