Topic on Talk:Quarry

MarioGom (talkcontribs)

I've got two queries stuck for 20 hours. They show up as "running", but clicking "explain" shows "Hmm... Is the SQL actually running?!". These are: query:26180 and query:25311.

Zhuyifei1999 (talkcontribs)

I didn't check the fist query, but the second has 11298269 rows in set, 3816 warnings (11 min 55.68 sec). Quarry simply can't store so many results.

MarioGom (talkcontribs)

Thanks! I'll fix the number of records problem by adding a HAVING clause. What about the warnings? Are they related to any error in the query?

MarioGom (talkcontribs)

Nevermind. There were multiple errors in the query. These are fixed now.