Skip to content

Instantly share code, notes, and snippets.

@xtender
Created July 29, 2020 15:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save xtender/afa5ffc01753d9473afead56da4e557a to your computer and use it in GitHub Desktop.
Save xtender/afa5ffc01753d9473afead56da4e557a to your computer and use it in GitHub Desktop.
Bug with different parameters
with t(a,b) as (select * from table(ku$_objnumpairlist(ku$_objnumpair(1,null))))
select
json_object(
KEY 'a' VALUE a,
KEY 'b' VALUE b absent on null
) c2,
json_object(
KEY 'a' VALUE a+0,
KEY 'b' VALUE b null on null
) c1,
json_object(
KEY 'a' VALUE a+0+0,
KEY 'b' VALUE b absent on null
) c3
from t;
C2 C1 C3
---------------------------------------- ---------------------------------------- ----------------------------------------
{"a":1} {"a":1,"b":null} {"a":1}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment