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] EXEC rejects a bare boolean literal as an argument value (@flag = true is a syntax error) #924
EXEC rejects a bare boolean literal as an argument value. INSERT and UPDATE accept one, and a quoted 'true' passed to EXEC is coerced to a JSON boolean from the body schema, so the value can be sent; the literal form is a syntax error.
Reproduction
stackql v1.0.888, ovh provider (stackql-registry/stackql-provider-ovh), method cloud.instances.rescue_mode (POST .../instance/{instanceId}/rescueMode, body { "rescue": boolean, "imageId": string }, naive body translation):
EXEC ovh.cloud.instances.rescue_mode @instance_id ='<id>', @rescue = true;
-- error: You have an error in your stackql syntax; parser error: Code: INVALID_ARGUMENT-- syntax error at position 107 near 'true'
EXEC ovh.cloud.instances.rescue_mode @instance_id ='<id>', @rescue ='true';
-- request body: {"rescue":true}
@flag = true and @flag = false parse as EXEC argument values, as they do in SET and in a SELECT projection feeding INSERT. null is worth the same treatment if the grammar change is in the same place.
Notes
The quoted form is a usable workaround and is what the provider docs show. The gap is the inconsistency between the three mutation verbs: a statement that reads naturally fails at parse time with no hint that quoting the value fixes it.
Activity