4.0.3-max-beta-nt crashes on simple(?) query

SELECT distinct *
FROM mytable ;

table is very simple:

+-----------------+--------------+------+-----+---------+--- ----+
| Field | Type | Null | Key | Default | Extra |
+-----------------+--------------+------+-----+---------+--- ----+
| id | varchar(100) | | PRI | | |
| large_screen_tv | varchar(100) | | | | |
| game_room | varchar(100) | | | | |
| spa | varchar(100) | | | | |
| jacuzzi | varchar(100) | | | | |
+-----------------+--------------+------+-----+---------+--- ----+

crashes my Win2000 PC (memory cannot be read). Athlon 1400 w/ 512MB RAM
enough disk space etc.

Can send further debuggind Visual studio since it takes over as soon as it
crashes..

I am not even sure select distinct * is the right way to get unique columns
(from a 2 table join for example).

Thanks

Raoul Volpe
Phone (877) 44 SOL EX (Toll Free)
Phone +001 407 396-1341 (outside US)
Fax +001 586 816 7086
raoul.volpe@solarisexpert.com
http://www.solarisexpert.com



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12573@lists.mysql.com
To unsubscribe, e-mail

Re: 4.0.3-max-beta-nt crashes on simple(?) query

On Sunday 22 September 2002 07:53, Raoul Volpe wrote:
> SELECT distinct *
> FROM mytable ;
>
> table is very simple:
>
> +-----------------+--------------+------+-----+---------+--- ----+
>
> | Field | Type | Null | Key | Default | Extra |
>
> +-----------------+--------------+------+-----+---------+--- ----+
>
> | id | varchar(100) | | PRI | | |
> | large_screen_tv | varchar(100) | | | | |
> | game_room | varchar(100) | | | | |
> | spa | varchar(100) | | | | |
> | jacuzzi | varchar(100) | | | | |
>
> +-----------------+--------------+------+-----+---------+--- ----+
>
> crashes my Win2000 PC (memory cannot be read). Athlon 1400 w/ 512MB RAM
> enough disk space etc.
>

Could you please tell if this happens with any table (even empty) of such=
structure or=20
you need to have some data to be in it ?

It is always the best to provide complete example which we could try just=
by

mysql test < example.sql=20

in case it requires large data set you may upload it to ftp://support.mys=
ql.com/pub/mysql/secret


Also I should note we've fixed couple of Windows specific bugs in 4.0.4 w=
hich should be out next week and=20
which may already contain a fix for your problem. This is why it is even =
more important to get
repeatable example from you so we will make sure this bug is fixed as wel=
l.=20


--=20
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Peter Zaitsev
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com M: +7 095 725 4955


------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12574@lists.mysql.com
To unsubscribe, e-mail