Bug #65538 Crash when making the difference between dates
Submitted: 6 Jun 2012 14:40 Modified: 7 Jun 2012 13:53
Reporter: François Robben Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:5.2.37 CE :8576 OS:Microsoft Windows
Assigned to: CPU Architecture:Any

[6 Jun 2012 14:40] François Robben
My program run "select year(current_date)-year(four_date) from fournisseurs;" and should return my the difference between the two date. Instead of this, I got a CTD...

Running "select four_name, year(current_date)-years(four_date) from fournisseurs;" or "select year(current_date)-years(four_date) as 'difference' from fournisseurs;" or with both instruction don't cause the CDT and return me what I expect.

How to repeat:
Just asking for the difference between two dates...
[6 Jun 2012 14:47] Valeriy Kravchuk
Please, check if the same problem still happens with a newer version, 5.2.40. If it does, please, provide complete test case, with CREATE TABLE and some data for the table to reproduce the problem.
[7 Jun 2012 12:32] François Robben
It's ok with 5.2.40...

Sorry for disturbing
[7 Jun 2012 13:53] Valeriy Kravchuk
Not repeatable with 5.2.40.