Forum Discussion
scalar variable support for matches regex
The following example shows how the binary operator == works with a scalar variable as the right hand side. datatable(a: string, b: string) [
"foo", "blah*",
"bar", "ba*",
"same", "same"
] | where ...
avner
Microsoft
MicrosoftHi Patrick,
The argument to 'matches regex' is a constant as the error message says. This is in order to ensure that the predicate is not calculated for each row something that will result in a very poor performance.
Thanks,
Avner