github/codeql

demo work fine on LGTM,but error on cli, INVALID_RESULT_PATTERNS

Opened this issue · 7 comments

aqnaruto commented

here is my project ,just simply copy the offical demo
https://github.com/aqnaruto/testCodeql

jsdb is my database file dir, i am using this command

codeql database analyze jsdb ql/ --format=sarif-latest --output=jsdb-10086.csv

it's works fine on lgtm ,however error on cli .

here is my codeql cli error message
image

here is lgtm project,works fine
https://lgtm.com/query/2479023459922754191/
image

aibaars commented

The query looks all fine to me. The output says No need to re-run ... . I suspect CodeQL is still using the results of a run of an earlier version of the query. Could you re-try with the --rerun flag?

  • 👍2
github-actions commented

This issue is stale because it has been open 14 days with no activity. Comment or remove the stale label in order to avoid having this issue closed in 7 days.

aqnaruto commented

@aibaars thank you reply,
so , did you run the sample, and make sure it work fine by using codeql cli latest version

xssssrf commented

Hava the same problem.

thepurpleowl commented

You'll get the same error when try to use example snippets, after adding @kind and a dummy string in the result. Any idea why?

@RasmusWL

RasmusWL commented

@thepurpleowl I've been able to reproduce, if I ran the query before fixing it up (adding @kind problem and a second column in the select), then it would not run the query again when invoking codeql database analyze after I fixed it up (but insist on reusing the results).

I found that using codeql database analyze --rerun <...> would solve the problem for me 👍

(I'll open an issues so we can fix this behavior -- see github/codeql-cli-binaries#64)

  • 👍1
thepurpleowl commented

Yes, --rerun option solves the issue in my setup.

@RasmusWL Thanks for taking it to development.

  • 👍1