Hey guys,I'm getting this error when I run a query on the signature table
"constraint failed"the error from the log on my host shows
Table signature was queried without a required column in the WHERE clauseeven though I have a column specified in the WHERE clause, any idea why it's happening ?
07/11/2022, 7:02 PM
Hi, @Tarek Talaat! Are you including the
column in your
clause? If you could send over the query with any identifying info removed, that would be helpful for diagnosing the issue.
07/11/2022, 7:03 PM
oh I don't include the path in the WHERE. ok, one sec
SELECT path, signed, team_identifier from signature
where team_identifier like "%abcd%";
it works without any errors if I include the path, but what if I don't know the path and I want to get it?
07/11/2022, 7:24 PM
You could use wildcards in
SELECT path, signed, team_identifier from signature WHERE team_identifier like "%abcd%" AND path LIKE '/Applications/%'
07/11/2022, 8:58 PM
I'm trying to identify a malware, and it could be downloaded some where else other than /Applications/, but I'll try a wild card to include anything and see if that would help.
07/11/2022, 9:06 PM
That makes sense. What are you trying to hunt down? Someone here might have already started down the path to hunting it down or have some other knowledge to drop!