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 Quote 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. Quote 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. Quote 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. Quote 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? Quote 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 Quote 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? Quote 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. Quote Link to comment https://forums.phpfreaks.com/topic/54078-mysql-server-crash/#findComment-270332 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.