AnsweredAssumed Answered

Bug in ExecuteSQL?

Question asked by astelix on Feb 5, 2013
Latest reply on Feb 5, 2013 by astelix

I have a table with 50k Records. Each record consists of the fields "TextID", "WordPos" and "Word".

Field "Word" contains one word for each record and is indexed.

I want a count for each disttinct word with a SQL GOUP BY Clause.

 

ExecuteSQL("SELECT Word FROM txt_table"; "|"; ""¶") returns immediately with the expected result.

ExecuteSQL("SELECT DISTINCT Word FROM txt_table"; "|"; ""¶") returns immediately with the expected result.

ExecuteSQL("SELECT Word FROM txt_table ORDER BY Word"; "|"; ""¶") returns immediately with the expected result.

 

ExecuteSQL("SELECT Word, COUNT(*) FROM txt_table GROUP BY Word"; "|"; ""¶") freezes filemaker. CPU-Usage goes permanently to 100%.

 

Why that?

Outcomes