bubblegum.anarchy Posted June 3, 2007 Share Posted June 3, 2007 Anyone know why the following crashes mysql server version 4.1.21-community-nt SELECT '2007-06-02' - INTERVAL 1 DAY BETWEEN '2007-06-02' AND '2007-06-03'; WARNING: the above line will most likey crash mysql server Link to comment https://forums.phpfreaks.com/topic/54078-mysql-server-crash/ Share on other sites More sharing options...
binindex Posted June 3, 2007 Share Posted June 3, 2007 just tried it in 5.0.41 and everything was fine. returned 0. Link to comment https://forums.phpfreaks.com/topic/54078-mysql-server-crash/#findComment-267516 Share on other sites More sharing options...
unidox Posted June 4, 2007 Share Posted June 4, 2007 Update your sql server. Either download it if the db is on your computer, or have your host update it for you. Link to comment https://forums.phpfreaks.com/topic/54078-mysql-server-crash/#findComment-267528 Share on other sites More sharing options...
bubblegum.anarchy Posted June 4, 2007 Author Share Posted June 4, 2007 Unfortunately I am stuck on 4.1.21 until work updates there's, likely never. Thanks for confirming that the issue is likely version related, binindex. Link to comment https://forums.phpfreaks.com/topic/54078-mysql-server-crash/#findComment-267920 Share on other sites More sharing options...
fenway Posted June 6, 2007 Share Posted June 6, 2007 What if you rewrite that to move the interval part to the between? Link to comment https://forums.phpfreaks.com/topic/54078-mysql-server-crash/#findComment-269115 Share on other sites More sharing options...
bubblegum.anarchy Posted June 7, 2007 Author Share Posted June 7, 2007 What if you rewrite that to move the interval part to the between? First of all, allow me to confirm that the original line of code still crashes mysql. ... and the INTERVAL beside any constant date value crashes mysql and so does the following: SELECT subdate('2007-06-02', 1) BETWEEN '2007-06-02' AND '2007-06-03'; SELECT adddate('2007-06-02', 1) BETWEEN '2007-06-02' AND '2007-06-03'; version = 4.1.21-community-nt Link to comment https://forums.phpfreaks.com/topic/54078-mysql-server-crash/#findComment-269649 Share on other sites More sharing options...
fenway Posted June 7, 2007 Share Posted June 7, 2007 No kidding... have you check the mysql bugs list to see if this is mentioned? Link to comment https://forums.phpfreaks.com/topic/54078-mysql-server-crash/#findComment-269937 Share on other sites More sharing options...
bubblegum.anarchy Posted June 7, 2007 Author Share Posted June 7, 2007 No kidding... have you check the mysql bugs list to see if this is mentioned? nope, I am lazy like that - and have moved on in code since discovering the error... also, binindex confirmed that later versions are fine. Link to comment https://forums.phpfreaks.com/topic/54078-mysql-server-crash/#findComment-270332 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.