List:General Discussion« Previous MessageNext Message »
From:Terry Brown Date:October 4 1999 8:48am
Subject:Problem doing SELECTs with date fields
View as plain text  
Hi All,

This is a bizarre one and I'm very confused so I thought the list may be 
able to help.

I've been running mysql 3.22.25 for some time now without any problems but 
last week, decided to upgrade some of our system software so I downloaded 
mysql (3.22.26) along with all of our the latest gnu software (fileutils, 
findutils, .... all of the general packages + gcc 2.95.1 (we were running 
2.95)).

After the upgrade, I can retrieve lines from the database with dates in but 
if I ask for something on a specific date (e.g. '1999-10-20') I get a core 
dump and lose the connection to the database.

I can see the core file in /usr/local/var but have no idea how to analyse 
it to see what went wrong (I'm only a baby sys-admin!).  I have since tried 
downgrading to 3.22.25 but the same problem persists so I'm wondering if 
it's been one of the gnu distributions that's messed it up?

Rather than overloading people now with every piece of information I have, 
could people give me some idea as to what they would need to know before I 
can get round to solving the problem?

Many thanks,
Terry
________________________________________________________
Terry Brown				http://numedsun.ncl.ac.uk/
	C&IT Development Officer		
	UNIX System Administrator

Faculty of Medicine Computing Centre, University of Newcastle,
NE2 4HH     Tel: +44 191 222 5116	Fax: +44 191 222 5016
Thread
benchmarkalmir kazazic4 Oct
  • Re: benchmarkLuuk de Boer4 Oct
  • Re: benchmarkMartin Ramsch5 Oct
  • Re: benchmarkMartin Ramsch5 Oct
Re: benchmarkalmir kazazic4 Oct
  • Re: benchmarkLuuk de Boer4 Oct
  • Problem doing SELECTs with date fieldsTerry Brown4 Oct
    • Problem doing SELECTs with date fieldsJani Tolonen4 Oct
      • Re: Problem doing SELECTs with date fieldsTerry Brown6 Oct
        • Re: Problem doing SELECTs with date fieldsMichael Widenius7 Oct