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
