Unrecoverable error in WHERE clause


Author
Message
haix
haix
New Member (10 reputation)New Member (10 reputation)New Member (10 reputation)New Member (10 reputation)New Member (10 reputation)New Member (10 reputation)New Member (10 reputation)New Member (10 reputation)New Member (10 reputation)
Group: Forum Members
Posts: 1, Visits: 2
Hi all,


I guess this is a reporting a bug and finding out if anyone else experiences the same issue:

Loading a log file 

Given a simple data set from a server log file:
message = path to file accessed
response = HTTP response code


SELECT DISTINCT message, COUNT(message) TheCount, method
FROM CurrentView
WHERE response = '200'
-- AND TheCount > 20 --> LogViewPlus crashes with this
GROUP BY message
ORDER BY TheCount DESC
;

With the addition of AND TheCount > 20 the system crashes.  Error reporting upload not possible due to 404 error.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Login

Explore
Messages
Mentions
Search