You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
[BUG] View query rewriting issue with LIKE and NOT LIKE #472
Describe the bug
A clear and concise description of what the bug is.
To Reproduce
the following view query:
SELECT
id,
name,
ssl_policy
FROMazure.network.vw_application_gateways
WHERE
subscriptionId ='631d1c6d-2a65-43e7-93c2-688bfe4e1468'AND ssl_policy IS NOT NULLAND ssl_policy NOT LIKE'%TLS12%';
gets.. sql packet preparation error: near "(": syntax error
whereas the query on the base resource works:
SELECT
id,
name,
JSON_EXTRACT(properties, '$.sslPolicy') as ssl_policy
FROMazure.network.application_gateways
WHERE
subscriptionId ='631d1c6d-2a65-43e7-93c2-688bfe4e1468'AND ssl_policy IS NOT NULLAND JSON_EXTRACT(properties, '$.sslPolicy') NOT LIKE'%TLS12%';
Expected behavior
The query on the view should return the same data as the base resource
Activity