[Maria-developers] Different results from UNION and UNION DISTINCT
![](https://secure.gravatar.com/avatar/d3671c61c0c2525f834ac21430711e3d.jpg?s=120&d=mm&r=g)
According to this post at Stack Overflow, MariaDB 10.1.10 gives wrong results (duplicate rows) for UNION DISTINCT while the UNION version gives correct ones. (notice the comment: http://dba.stackexchange.com/questions/141799/select-distinct-values-of-two-... ) The query in question is very simple: SELECT a AS result FROM tableXUNION DISTINCTSELECT b FROM tableX ; I couldn't find a related bug in the MDEV. Is this a known (or fixed) issue or should I go and add a bug report/ Pantelis Theodosiou
![](https://secure.gravatar.com/avatar/2cf3bcc01767a358bf4ec20df6dc8dec.jpg?s=120&d=mm&r=g)
Hi Pantelis, On 06/21/2016 06:28 PM, Pantelis Theodosiou wrote:
According to this post at Stack Overflow, MariaDB 10.1.10 gives wrong results (duplicate rows) for UNION DISTINCT while the UNION version gives correct ones.
(notice the comment: http://dba.stackexchange.com/questions/141799/select-distinct-values-of-two-... )
The query in question is very simple:
|SELECTa ASresult FROMtableX UNIONDISTINCTSELECTb FROMtableX ;|
I couldn't find a related bug in the MDEV.
Is this a known (or fixed) issue or should I go and add a bug report/
Yes, please create a bug report. Importantly, please put there the exact table definition (output of SHOW CREATE TABLE tableX) and output of SHOW VARIABLES from the session where the problem occurs. If you have access to the database via a command-line client, please also paste the unabridged output of executing the following: show table status like 'tableX'; check table tableX; select * from tableX; SELECT SQL_NO_CACHE a AS result FROM tableX UNION DISTINCT SELECT b FROM tableX; If you don't have the command-line client, please just provide results of the queries in any form. Thanks, Elena Stepanova
Pantelis Theodosiou
_______________________________________________ Mailing list: https://launchpad.net/~maria-developers Post to : maria-developers@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-developers More help : https://help.launchpad.net/ListHelp
participants (2)
-
Elena Stepanova
-
Pantelis Theodosiou