That happens to me, too. 在 2013年12月25日星期三UTC+8上午1时24分05秒，Ilya Belopolsky写道： > > When I execute the following command: > > (SELECT employee_id FROM employees ORDER BY employee_id) > > union > > (select employee_id FROM job_history ORDER BY job_id); > > > I have attached a sql script to reproduce the schema, tables, and data > > > The result set contains duplicates as if I used the "union all" command. > Even if I use "union disctinct" explicitly, i get duplicates. > > > The issue is related to the ORDER BY clause in the second select. The issue > goes away if I use the column in the select clause (employee_id) as the order > by column, but the same issue is present with any other column in the order > clause. > > > The issue is present regardless of the position of the Select subquery. > > > Is this a bug or am I missing something? > >
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
