Re: Table name aliases in FULLTEXT and table locking

2004-10-18 Thread Sergei Golubchik
Hi! On Oct 05, Ville Mattila wrote: > Hi there, > > I have noticed a few things that cause problems when using table aliases > (SELECT ... FROM table1 t1, table2 t2): > > 1) Fulltext index queries don't work. I tried to complete a following query: > > a) > SELECT p.*, c.name AS categoryname FR

Table name aliases in FULLTEXT and table locking

2004-10-05 Thread Ville Mattila
Hi there, I have noticed a few things that cause problems when using table aliases (SELECT ... FROM table1 t1, table2 t2): 1) Fulltext index queries don't work. I tried to complete a following query: a) SELECT p.*, c.name AS categoryname FROM products p, categories c WHERE MATCH(p.name,p.descrip