Bug? With date INTERVAL? Just in 10.1.0.5464?

ByterBit's profile image ByterBit posted 5 years ago in General Permalink

This query falsely returns 0.0617:

SELECT SUM(TIME)/3600 FROM idletimehistory WHERE idle =1 and TIMESTAMP >= NOW() - INTERVAL 30 DAY AND vehicleid IN (select id from vehicles where fleetid =2000)

Using MYSQL server on the command line it returns NULL, as it should.

Also Heidi 9.5.0.5196 gives NULL as does a recent install of DBever.

ansgar's profile image ansgar posted 5 years ago Permalink

Without having your idletimehistory and vehicles tables, I am not able to verify that. Probably you can post minimal structure and data here.

Please login to leave a reply, or register at first.