E
E
Evgeny Blinov2019-03-18 09:43:00
MariaDB
Evgeny Blinov, 2019-03-18 09:43:00

MariaDB is executing the query incorrectly - why?

I have MariaDB version 5.5.35a
and this magic happens:
SELECT with FROM table WHERE a=7 and b=3;
result:
id
123
234
345
SELECT with FROM table WHERE a=7 and b=3 and c=100;
result:
id
100
i.e. the result 100 should be in the first result, but it's not there.
why? how to fix?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question