Hi guys, i found a optimization (maybe a bug?) that could be 'easly' optimized, check this query...

CREATE TABLE A (I INT UNSIGNED);

INSERT INTO A VALUES (1),(2),(3),(4)

EXPLAIN

SELECT COUNT(*)FROM A WHERE I<0

this return 4 rows...

but since "I" Column is unsigned it could return IMPOSSIBLE Where, right? (-1 don't exists to unsigned...)

i'm thinking about this optimization, and this other optimization (MDEV-4419) could allow some (many) queries to run faster

in SHOW STATUS LIKE 'handler_re%'
i see 4 rows being read when i execute the <0 query
in other words, it's reading data from disk (maybe a bug in optimizer)