passing_exception.sql 369 B

12345678910111213141516
  1. /* syntax version 1 */
  2. /* postgres can not */
  3. /* custom error:Expected data or optional of data, but got: Tuple<Int32,Int32>*/
  4. $json = CAST(@@{
  5. "key": 123
  6. }@@ as Json);
  7. -- Tuple type is not supported for variables
  8. SELECT
  9. JSON_QUERY(
  10. $json, "strict $var"
  11. PASSING
  12. AsTuple(1, 2) as var
  13. WITH UNCONDITIONAL ARRAY WRAPPER
  14. );