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

[aqnaruto]

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

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

[aibaars]

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?

[github-actions]

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]

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

[xssssrf]

Hava the same problem.

[thepurpleowl]

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]

@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)

[thepurpleowl]

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

@RasmusWL Thanks for taking it to development.