Bug #3100 Segmentation fault
Submitted: 7 Mar 2004 17:55 Modified: 8 Mar 2004 10:03
Reporter: Kevin Waterson Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:4.1.1 OS:Linux (linux)
Assigned to: Dean Ellis CPU Architecture:Any

[7 Mar 2004 17:55] Kevin Waterson 
Description:
I tried to run this query..
mysql> SELECT TO_DAYS(seasonDateTo) - TO_DAYS('2004-04-04 00:00:00') AS sumA FROM seasons WHERE '2004-04-04 00:00:00' BETWEEN seasonDateFrom AND seasonDateTo UNION SELECT TO_DAYS(seasonDateTo)-TO_DAYS(seasonDateFrom) FROM seasons WHERE seasonDateFrom >='2004-04-04 00:00:00' AND seasonDateTo <= '2004-08-08 00:00:00

and omitted the trailing ;
I then accidently typed q; and the result was 
    '> Segmentation fault

How to repeat:
mysql> SELECT TO_DAYS(seasonDateTo) - TO_DAYS('2004-04-04 00:00:00') AS sumA FROM seasons WHERE '2004-04-04 00:00:00' BETWEEN seasonDateFrom AND seasonDateTo UNION SELECT TO_DAYS(seasonDateTo)-TO_DAYS(seasonDateFrom) FROM seasons WHERE seasonDateFrom >='2004-04-04 00:00:00' AND seasonDateTo <= '2004-08-08 00:00:00
    '> q;
    '> Segmentation fault
[8 Mar 2004 10:03] Dean Ellis 
I cannot repeat this with 4.1.2.

Are you using our binary or self-compiled (or other)?  Assuming you gave a direct copy/paste, with it "crashing" while you still have an unterminated string constant, it sounds like a bad library/build.
[7 Aug 2004 20:05] Sergey Kostyliov 
Could you please try this patch: http://bugs.mysql.com/file.php?id=468 ?  
It seems possible that it the same issue as for #4696 
Was mysql compiled using bundled libedit?
[25 Aug 2005 7:05] Islam Mayer 
Kevin, why you haven't answered to my note? I think that old bug has been already fixed, so maybe its usefull to change status of this bug to "need feedback"?

Sergey S. Kostyliov <rathamahata@rathamahata.net>
http://www.rathamahata.net/