Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Andreas Legner — source: IBM Community (ConnectedCommunity.org) Informix forum
Good question ... looking like a defect (can you report this in a support case?)
There's also this:
select id from decode_test where data_json is null;
id
1
1 row(s) retrieved.
vs.
select NVL(data_json, 'NULL') from decode_test;
(U0001) - JSON Syntax error at character 1
Error in line 34Near character position 45
while this does work:
select NVL(data_json::lvarchar, 'NULL') from decode_test;
(expression) NULL
HTH,
Andreas
You are subscribed to "Informix" as paul.cdi@oninit.com. To change your subscriptions, go to http://community.ibm.com/community/user/preferences?section=Subscriptions. To unsubscribe from this community discussion, go to [link removed]
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.