PopSQL and Command Line Client returns different result

Asked May 01 '20 at 14:45

Active May 01 '20 at 16:45

Viewed 74 times

So originally my question was - 'How to prevent duplicates between two columns, using one table?' I tried to check the same query via Command Line and it returned different result. Maybe I need to change the SQL editor? What is the problem here in general and how can I fix it? Thanks in advance!

Query:

SELECT 
    c1.city,
    c1.customerName,
    c2.customerName
FROM
    customers c1
INNER JOIN
    customers c2
    ON c1.city = c2.city 
    AND c1.customerName > c2.customerName
WHERE c1.city = 'Auckland'
ORDER BY
    c1.city;

Command Line Result

PopSQL Result

Edit: fixed the tables results

edited May 01 '20 at 14:55

nbk

45,398
8
30
47

asked May 01 '20 at 14:45

Anton Ionov

PopSQL returns the same result @nbk – Anton Ionov May 01 '20 at 15:00
sorry i posted a new answer. – nbk May 01 '20 at 15:26
@nbk I forgot to mention that I tried different operators including `<>` still duplicates there https://imgur.com/Hhmchf3 – Anton Ionov May 01 '20 at 15:34
then show me the original data, because you see in the example that works with <> – nbk May 01 '20 at 15:38
[DB Fiddle](https://www.db-fiddle.com/f/2sHwH5Bv8VtwouhJqViGp6/0) using MySQL 8 – Anton Ionov May 01 '20 at 16:17
Ok and what is the result you want? – nbk May 01 '20 at 16:26
Both databases works perfectly on DB Fiddle. I want to understand whether something wrong with my SQL editor or there's something else needed to be fixed – Anton Ionov May 01 '20 at 16:29
you are right seems like a bug, popsql seems to make out a >to a = – nbk May 01 '20 at 17:23
yeah... gotta look into new GUI thanks so much for your time! – Anton Ionov May 01 '20 at 17:25

PopSQL and Command Line Client returns different result

0 Answers0