False positives on KustoCode.ParseAndAnalyze (countif() does not recognize bool fields)

[jkindwall]

Our team stores a fairly large library of .kql files in source control that are used to ensure the schema of our main database is properly in sync with the rest of our code. We frequently run into deployment failures due to errors in these kql files that were not caught during code review and we don't find out about them until we are attempting to deploy the changes to our database.

I would like to use this library and specifically the KustoCode.ParseAndAnalyze method in a validation step as part of our PR builds to try and catch these types of errors before they are merged into our main branch. However, I'm currently running into far too many false positives in kql code that actually executes without issue against the actual database.

I am using this library: https://github.com/mattwar/Kusto.Toolkit to automatically generate the GlobalState object based on the current state of our test environment database, then running each command through the ParseAndAnalyze() method to detect errors.

One such error is that the countif() aggregate function on a summarize clause does not recognize bool fields.

| summarize FooCount = countif(IsFoo) by EntityCHUri

KS107 - A value of type bool expected. The data fed into this summarize expression includes a bool "IsFoo" field but it is not recognized.

[mattwar]

This example works fine:

datatable(IsFoo: bool)[true, false]
| summarize FooCount = countif(IsFoo)

It is possible that the column is not correctly typed as bool.