re: SELECT DISTINCT bug MySQL 4.0.3 MAX NT

2002-09-20 Thread Victoria Reznichenko
Glenn, Friday, September 20, 2002, 5:27:01 AM, you wrote: GW> I was able to crash MySQL every time with the following -- it is GW> incorrectly formatted I know and I should be using GROUP BY in this GW> particular case GW> When I do the following query: GW> SELECT DISTINCT * FROM CUSTOMER INNE

SELECT DISTINCT bug MySQL 4.0.3 MAX NT

2002-09-19 Thread Glenn Watson
Hi, I was able to crash MySQL every time with the following -- it is incorrectly formatted I know and I should be using GROUP BY in this particular case When I do the following query: SELECT DISTINCT * FROM CUSTOMER INNER JOIN PRODUCT ON CUSTOMER.CUST_NO = PRODUCT.CUST_NO Without the distinc