List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:November 25 1999 7:09pm
Subject:3.23.6a Bug Report
View as plain text  
Hi!

>>>>> "Stephen" == Stephen Taranto <staranto@stripped> writes:

Stephen> From: staranto@stripped
Stephen> To: mysql@stripped
Stephen> Subject: First time query fails 3.23.6-a

>> Description:
Stephen> Refer to the following session trace.  The first time 
Stephen> this query is executed through the mysql monitor it 
Stephen> fails.  All subsequent times in the monitor session 
Stephen> work properly.

Stephen> *****
Stephen> PLEASE reply back to staranto@stripped.  My regular 
Stephen> account (staranto@stripped) is unable to send/receive
Stephen> mail to/from the mysql.com doamin.  Any idea why?

<cut>

mysql> select m.id, start_time, club_home,
Stephen> h.abbrev_name, club_away, a.abbrev_name from
Stephen> matches=m,
Stephen> weeks, clubs=h, clubs=a where week=15 and start_time
Stephen> between start1 and end1 and h.id=club_home
Stephen> and a.id=club_away order by start_time;
Stephen> Empty set (0.01 sec)

mysql> select m.id, start_time, club_home,
Stephen> h.abbrev_name, club_away, a.abbrev_name from
Stephen> matches=m,
Stephen> weeks, clubs=h, clubs=a where week=15 and start_time
Stephen> between start1 and end1 and h.id=club_home
Stephen>  and a.id=club_away order by start_time;
Stephen>
> +----+---------------------+-----------+-------------+-----------+-------------+
Stephen> | id | start_time          | club_home | abbrev_name |
Stephen> club_away | abbrev_name |
Stephen>
> +----+---------------------+-----------+-------------+-----------+-------------+
Stephen> | 84 | 1999-06-26 07:30:00 |         3 | DCU         |

<cut>

Hi!

The above problem is probably something that is very data dependent;
To fix and find this quickly I would need a copy of the tables in
question.

If possible, please ftp them, and a copy of this mail, to
ftp://www.mysql.com/pub/mysql/secret and I will take a look at this
before the next MySQL release!

Regards,
Monty

Thread
3.23.6a Bug ReportStephen Taranto25 Nov
  • Re: 3.23.6a Bug Reportsinisa25 Nov
  • 3.23.6a Bug ReportMichael Widenius25 Nov
  • Re: 3.23.6a Bug ReportJoe Kislo25 Nov
    • Re: 3.23.6a Bug ReportMichael Widenius26 Nov
    • Re: 3.23.6a Bug ReportMichael Widenius26 Nov