Created
May 19, 2024 16:41
-
-
Save fantix/3bc1bf2e666b3971c97aece65bd182d1 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ================================================================================ | |
| Input graphql | |
| ================================================================================ | |
| mutation update_RangeTest( | |
| $rval: RangeOfFloat, | |
| $mval: [RangeOfFloat!], | |
| $rdate: RangeOfString, | |
| $mdate: [RangeOfString!] | |
| ) { | |
| update_RangeTest( | |
| filter: {name: {eq: "Update RangeTest02"}}, | |
| data: { | |
| rval: {set: $rval}, | |
| mval: {set: $mval}, | |
| rdate: {set: $rdate}, | |
| mdate: {set: $mdate} | |
| } | |
| ) { | |
| name | |
| rval | |
| mval | |
| rdate | |
| mdate | |
| } | |
| } | |
| variables: {'rval': {'lower': 5.6, 'upper': 7.8, 'inc_lower': True, 'inc_upper': True}, 'mval': [{'lower': 0, 'upper': 1.2, 'inc_lower': True, 'inc_upper': False}], 'rdate': {'lower': '2018-12-10', 'upper': '2022-10-20', 'inc_lower': True, 'inc_upper': False}, 'mdate': [{'lower': None, 'upper': '2019-02-13', 'inc_lower': True, 'inc_upper': False}, {'lower': '2023-08-29', 'upper': '2026-10-20', 'inc_lower': True, 'inc_upper': False}]} | |
| ================================================================================ | |
| GraphQL optimized query | |
| ================================================================================ | |
| <builtins.Entry object at 0x10b39ddf0> | |
| key_vars: [] | |
| variables: {'_edb_arg__0': 'Update RangeTest02', 'rval': {'lower': 5.6, 'upper': 7.8, 'inc_lower': True, 'inc_upper': True}, 'mval': [{'lower': 0, 'upper': 1.2, 'inc_lower': True, 'inc_upper': False}], 'rdate': {'lower': '2018-12-10', 'upper': '2022-10-20', 'inc_lower': True, 'inc_upper': False}, 'mdate': [{'lower': None, 'upper': '2019-02-13', 'inc_lower': True, 'inc_upper': False}, {'lower': '2023-08-29', 'upper': '2026-10-20', 'inc_lower': True, 'inc_upper': False}]} | |
| == operationName: 'update_RangeTest' ============= | |
| select | |
| { | |
| multi update_RangeTest := (with | |
| x0 := | |
| (update | |
| default::RangeTest | |
| filter | |
| (default::RangeTest.name = <str>$_edb_arg__0) | |
| set { | |
| rval := <range<std::float64>><optional json>$rval, | |
| mval := multirange(<array<range<std::float64>>><optional array<range<std::float64>>>$mval), | |
| rdate := <range<cal::local_date>><optional json>$rdate, | |
| mdate := multirange(<array<range<cal::local_date>>><optional array<range<cal::local_date>>>$mdate) | |
| }) | |
| select | |
| x0 { | |
| name, | |
| rval, | |
| mval, | |
| rdate, | |
| mdate | |
| } | |
| ) | |
| } | |
| ================================================================================ | |
| EdgeQL Text | |
| ================================================================================ | |
| select | |
| { | |
| multi update_RangeTest := (with | |
| x0 := | |
| (update | |
| default::RangeTest | |
| filter | |
| (default::RangeTest.name = <str>$_edb_arg__0) | |
| set { | |
| rval := <range<std::float64>><optional json>$rval, | |
| mval := multirange(<array<range<std::float64>>><optional array<range<std::float64>>>$mval), | |
| rdate := <range<cal::local_date>><optional json>$rdate, | |
| mdate := multirange(<array<range<cal::local_date>>><optional array<range<cal::local_date>>>$mdate) | |
| }) | |
| select | |
| x0 { | |
| name, | |
| rval, | |
| mval, | |
| rdate, | |
| mdate | |
| } | |
| ) | |
| } | |
| ================================================================================ | |
| Scope Tree | |
| ================================================================================ | |
| "FENCE 0x1154d8d10": { | |
| "FENCE uid:56 0x115c20620": { | |
| "ns~1@@(std::FreeObject) 0x115c20140", | |
| "(__derived__::expr~1) 0x115c23da0", | |
| "FENCE no-unnest 0x11507c770": { | |
| "FENCE uid:55 ns~2 0x11507f980": { | |
| "FENCE 0x11507e240": { | |
| "FENCE uid:54 no-factor 0x11507d4f0": { | |
| "ns~2@@(default::RangeTest) 0x11507eae0", | |
| "FENCE uid:1 no-unnest 0x11507f3e0": { | |
| "ns~2@@(default::RangeTest).>name[IS std::str] 0x11632c110" | |
| }, | |
| "FENCE no-unnest 0x11632e3f0": { | |
| "FENCE uid:11 0x11632dbe0": { | |
| "ns~2@@(__derived__::expr~6) 0x11632e540", | |
| "BRANCH [OPT] uid:2 0x11632d910", | |
| "ns~2@@(__derived__::e~1) [OPT] 0x11632f170", | |
| "ns~2@@(__derived__::expr~7) 0x11632eae0", | |
| "BRANCH [OPT] uid:3 0x11632deb0", | |
| "ns~2@@(__derived__::e~2) [OPT] 0x11632ec60", | |
| "BRANCH [OPT] uid:4 0x11632f470", | |
| "ns~2@@(__derived__::e~3) [OPT] 0x11632e0c0", | |
| "BRANCH [OPT] uid:5 0x11632eab0", | |
| "ns~2@@(__derived__::e~4) [OPT] 0x11632fb60", | |
| "BRANCH [OPT] uid:6 0x11632f2f0", | |
| "ns~2@@(__derived__::expr~16) 0x11632cc80", | |
| "BRANCH [OPT] uid:7 0x11632cce0", | |
| "ns~2@@(__derived__::expr~21) 0x11509c4a0", | |
| "BRANCH [OPT] uid:8 0x11509e960", | |
| "ns~2@@(__derived__::expr~26) 0x115286a80", | |
| "BRANCH [OPT] uid:9 0x115286ab0", | |
| "ns~2@@(__derived__::expr~10) [OPT] 0x1152850d0", | |
| "BRANCH [OPT] uid:10 0x115286390", | |
| "ns~2@@(__derived__::expr~13) [OPT] 0x115284380", | |
| "ns~2@@(__derived__::expr~18) 0x115285ac0", | |
| "ns~2@@(__derived__::expr~23) 0x115285b20", | |
| "ns~2@@(__derived__::expr~28) 0x115286c00" | |
| } | |
| }, | |
| "FENCE no-unnest 0x11632c6e0": { | |
| "FENCE uid:27 0x115286e10": { | |
| "FENCE uid:12 0x115285d30": { | |
| "ns~2@@(__derived__::expr~34) 0x11509c6b0" | |
| }, | |
| "FENCE uid:26 0x115287950": { | |
| "BRANCH uid:25 0x1152879e0": { | |
| "ns~2@@(__derived__::expr~34) 0x1152864e0", | |
| "FENCE uid:24 0x1152874a0": { | |
| "FENCE uid:23 0x1153a2e70": { | |
| "ns~2@@(__derived__::expr~37).>1[IS std::json] 0x1153a12e0", | |
| "ns~2@@(__derived__::expr~37) 0x1153a1400", | |
| "BRANCH [OPT] uid:13 0x1153a0b30", | |
| "ns~2@@(__derived__::e~6) [OPT] 0x116378590", | |
| "ns~2@@(__derived__::expr~38) 0x1153a2ea0", | |
| "BRANCH [OPT] uid:14 0x116378fe0", | |
| "ns~2@@(__derived__::e~7) [OPT] 0x11637a3c0", | |
| "BRANCH [OPT] uid:15 0x11637af90", | |
| "ns~2@@(__derived__::e~8) [OPT] 0x11637ade0", | |
| "BRANCH [OPT] uid:16 0x11637a900", | |
| "ns~2@@(__derived__::e~9) [OPT] 0x11637acf0", | |
| "BRANCH [OPT] uid:17 0x11637b260", | |
| "ns~2@@(__derived__::expr~47) 0x11637b980", | |
| "BRANCH [OPT] uid:18 0x11637ba40", | |
| "ns~2@@(__derived__::expr~52) 0x11637bf20", | |
| "BRANCH [OPT] uid:19 0x11637b1a0", | |
| "ns~2@@(__derived__::expr~57) 0x11637b800", | |
| "BRANCH [OPT] uid:20 0x11637a630", | |
| "ns~2@@(__derived__::expr~41) [OPT] 0x115b2eed0", | |
| "BRANCH [OPT] uid:21 0x11637b1d0", | |
| "ns~2@@(__derived__::expr~44) [OPT] 0x115b2f1d0", | |
| "ns~2@@(__derived__::expr~49) 0x115b2f260", | |
| "ns~2@@(__derived__::expr~54) 0x115b2f200", | |
| "ns~2@@(__derived__::expr~59) 0x115b2eab0", | |
| "ns~2@@(__derived__::expr~60) 0x1153a2390", | |
| "FENCE uid:22 no-unnest 0x1153a0aa0": { | |
| "ns~2@@(__derived__::expr~37).>0[IS std::int64] 0x1153a24e0" | |
| } | |
| } | |
| } | |
| }, | |
| "ns~2@@(__derived__::expr~67).>1[IS array<range<std||float64>>] 0x115287d70", | |
| "ns~2@@(__derived__::expr~67) 0x115285d00" | |
| } | |
| } | |
| }, | |
| "FENCE no-unnest 0x115b2ec30": { | |
| "FENCE uid:37 0x115b2ea20": { | |
| "ns~2@@(__derived__::expr~71) 0x115b2d4c0", | |
| "BRANCH [OPT] uid:28 0x115b2e2d0", | |
| "ns~2@@(__derived__::e~10) [OPT] 0x115b2e150", | |
| "ns~2@@(__derived__::expr~72) 0x115b2e1b0", | |
| "BRANCH [OPT] uid:29 0x115b2e0c0", | |
| "ns~2@@(__derived__::e~11) [OPT] 0x115b2d970", | |
| "BRANCH [OPT] uid:30 0x115b2f440", | |
| "ns~2@@(__derived__::e~12) [OPT] 0x115b2cd70", | |
| "BRANCH [OPT] uid:31 0x115b2ef00", | |
| "ns~2@@(__derived__::e~13) [OPT] 0x115b2c5c0", | |
| "BRANCH [OPT] uid:32 0x115b2cb60", | |
| "ns~2@@(__derived__::expr~81) 0x115b2c890", | |
| "BRANCH [OPT] uid:33 0x115b2c7d0", | |
| "ns~2@@(__derived__::expr~86) 0x115b2d2e0", | |
| "BRANCH [OPT] uid:34 0x115b2c2c0", | |
| "ns~2@@(__derived__::expr~91) 0x115b2f800", | |
| "BRANCH [OPT] uid:35 0x115b2c920", | |
| "ns~2@@(__derived__::expr~75) [OPT] 0x115b2f530", | |
| "BRANCH [OPT] uid:36 0x115b2ea80", | |
| "ns~2@@(__derived__::expr~78) [OPT] 0x1163b02c0", | |
| "ns~2@@(__derived__::expr~83) 0x1163b02f0", | |
| "ns~2@@(__derived__::expr~88) 0x1163b0290", | |
| "ns~2@@(__derived__::expr~93) 0x1163b0200" | |
| } | |
| }, | |
| "FENCE no-unnest 0x115b2d790": { | |
| "FENCE uid:53 0x115b2d580": { | |
| "FENCE uid:38 0x115b2e8a0": { | |
| "ns~2@@(__derived__::expr~99) 0x11637ac90" | |
| }, | |
| "FENCE uid:52 0x1163b0380": { | |
| "BRANCH uid:51 0x1163b0800": { | |
| "ns~2@@(__derived__::expr~99) 0x1163b0650", | |
| "FENCE uid:50 0x1163b0ad0": { | |
| "FENCE uid:49 0x1163b08c0": { | |
| "ns~2@@(__derived__::expr~102).>1[IS std::json] 0x1163b1070", | |
| "ns~2@@(__derived__::expr~102) 0x1163b1100", | |
| "BRANCH [OPT] uid:39 0x1163b19a0", | |
| "ns~2@@(__derived__::e~15) [OPT] 0x1163b18b0", | |
| "ns~2@@(__derived__::expr~103) 0x1163b1ac0", | |
| "BRANCH [OPT] uid:40 0x1163b1850", | |
| "ns~2@@(__derived__::e~16) [OPT] 0x1163b0ec0", | |
| "BRANCH [OPT] uid:41 0x1163b1af0", | |
| "ns~2@@(__derived__::e~17) [OPT] 0x1163b1c40", | |
| "BRANCH [OPT] uid:42 0x1163b2390", | |
| "ns~2@@(__derived__::e~18) [OPT] 0x1163b2300", | |
| "BRANCH [OPT] uid:43 0x1163b27b0", | |
| "ns~2@@(__derived__::expr~112) 0x1163b25a0", | |
| "BRANCH [OPT] uid:44 0x115b2db20", | |
| "ns~2@@(__derived__::expr~117) 0x1163b26c0", | |
| "BRANCH [OPT] uid:45 0x1163b28a0", | |
| "ns~2@@(__derived__::expr~122) 0x1163b2930", | |
| "BRANCH [OPT] uid:46 0x1163b3170", | |
| "ns~2@@(__derived__::expr~106) [OPT] 0x1163b3260", | |
| "BRANCH [OPT] uid:47 0x1163b2d50", | |
| "ns~2@@(__derived__::expr~109) [OPT] 0x1163b2cc0", | |
| "ns~2@@(__derived__::expr~114) 0x1163b3140", | |
| "ns~2@@(__derived__::expr~119) 0x1163b2ba0", | |
| "ns~2@@(__derived__::expr~124) 0x1163b31a0", | |
| "ns~2@@(__derived__::expr~125) 0x1163b12b0", | |
| "FENCE uid:48 no-unnest 0x1163b11f0": { | |
| "ns~2@@(__derived__::expr~102).>0[IS std::int64] 0x1163b2780" | |
| } | |
| } | |
| } | |
| }, | |
| "ns~2@@(__derived__::expr~132).>1[IS array<range<cal||local_date>>] 0x1163b06e0", | |
| "ns~2@@(__derived__::expr~132) 0x1163b0710" | |
| } | |
| } | |
| }, | |
| "ns~3@@(default::RangeTest) 0x1163b3cb0" | |
| } | |
| }, | |
| "(__derived__::x0@w~1) 0x11507f230", | |
| "(__derived__::expr~1).>update_RangeTest[IS default::RangeTest] 0x115c21010" | |
| } | |
| } | |
| } | |
| } | |
| { | |
| 1: {ns~2@@(__derived__::expr~5)}, | |
| 2: {ns~2@@(__derived__::e~1)}, | |
| 3: {ns~2@@(__derived__::e~2)}, | |
| 4: {ns~2@@(__derived__::e~3)}, | |
| 5: {ns~2@@(__derived__::e~4)}, | |
| 6: {ns~2@@(__derived__::expr~16)}, | |
| 7: {ns~2@@(__derived__::expr~21)}, | |
| 8: {ns~2@@(__derived__::expr~26)}, | |
| 9: {ns~2@@(__derived__::expr~10)}, | |
| 10: {ns~2@@(__derived__::expr~13)}, | |
| 11: {ns~2@@(default::RangeTest).>rval[IS range<std|float64>]}, | |
| 12: {ns~2@@(__derived__::expr~36)}, | |
| 13: {ns~2@@(__derived__::e~6)}, | |
| 14: {ns~2@@(__derived__::e~7)}, | |
| 15: {ns~2@@(__derived__::e~8)}, | |
| 16: {ns~2@@(__derived__::e~9)}, | |
| 17: {ns~2@@(__derived__::expr~47)}, | |
| 18: {ns~2@@(__derived__::expr~52)}, | |
| 19: {ns~2@@(__derived__::expr~57)}, | |
| 20: {ns~2@@(__derived__::expr~41)}, | |
| 21: {ns~2@@(__derived__::expr~44)}, | |
| 22: {ns~2@@(__derived__::expr~61)}, | |
| 23: {ns~2@@(__derived__::expr~62)}, | |
| 24: {ns~2@@(__derived__::expr~63)}, | |
| 25: {ns~2@@(__derived__::expr~67)}, | |
| 26: {ns~2@@(__derived__::expr~68)}, | |
| 27: {ns~2@@(default::RangeTest).>mval[IS multirange<std|float64>]}, | |
| 28: {ns~2@@(__derived__::e~10)}, | |
| 29: {ns~2@@(__derived__::e~11)}, | |
| 30: {ns~2@@(__derived__::e~12)}, | |
| 31: {ns~2@@(__derived__::e~13)}, | |
| 32: {ns~2@@(__derived__::expr~81)}, | |
| 33: {ns~2@@(__derived__::expr~86)}, | |
| 34: {ns~2@@(__derived__::expr~91)}, | |
| 35: {ns~2@@(__derived__::expr~75)}, | |
| 36: {ns~2@@(__derived__::expr~78)}, | |
| 37: {ns~2@@(default::RangeTest).>rdate[IS range<cal|local_date>]}, | |
| 38: {ns~2@@(__derived__::expr~101)}, | |
| 39: {ns~2@@(__derived__::e~15)}, | |
| 40: {ns~2@@(__derived__::e~16)}, | |
| 41: {ns~2@@(__derived__::e~17)}, | |
| 42: {ns~2@@(__derived__::e~18)}, | |
| 43: {ns~2@@(__derived__::expr~112)}, | |
| 44: {ns~2@@(__derived__::expr~117)}, | |
| 45: {ns~2@@(__derived__::expr~122)}, | |
| 46: {ns~2@@(__derived__::expr~106)}, | |
| 47: {ns~2@@(__derived__::expr~109)}, | |
| 48: {ns~2@@(__derived__::expr~126)}, | |
| 49: {ns~2@@(__derived__::expr~127)}, | |
| 50: {ns~2@@(__derived__::expr~128)}, | |
| 51: {ns~2@@(__derived__::expr~132)}, | |
| 52: {ns~2@@(__derived__::expr~133)}, | |
| 53: {ns~2@@(default::RangeTest).>mdate[IS multirange<cal|local_date>]}, | |
| 54: {(__derived__::x0@w~1)}, | |
| 55: {(__derived__::expr~1).>update_RangeTest[IS default::RangeTest]}, | |
| 56: {(__derived__::expr~138)} | |
| } | |
| ================================================================================ | |
| SQL | |
| ================================================================================ | |
| WITH | |
| "range~1" AS | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x1163dc650>*/ | |
| "RangeTest~3".id AS "RangeTest_identity~1" | |
| FROM | |
| edgedbpub."3a6ecca4-15fd-11ef-976b-575f9467c82e_t" AS "RangeTest~3" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163de8d0>*/ | |
| ("RangeTest~3"."3a728d94-15fd-11ef-8be8-21e0df54676e" = "expr-4~2"."expr~4_value~1") AS "expr~5_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163de720>*/ | |
| edgedbstd."std|cast@std|json@std|str_f"(($5)::jsonb) AS "expr~4_value~1" | |
| ) AS "expr-4~2" | |
| ) AS "expr-5~2" | |
| WHERE | |
| "expr-5~2"."expr~5_value~1" | |
| )), | |
| "upd_contents~1" AS | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x1163dd670>*/ | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x1163ded20>*/ | |
| "expr-29~2"."range_value~1" AS "range_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163df0e0>*/ | |
| (CASE WHEN ((("expr-28~2"."expr~28_value~1" IS NULL) OR | |
| ("expr-23~2"."expr~23_value~1" IS NULL)) OR | |
| ("expr-18~2"."expr~18_value~1" IS NULL)) THEN NULL | |
| WHEN edgedb.range_validate("expr-10~2"."expr~10_value~5", "expr-13~2"."expr~13_value~5", "expr-18~2"."expr~18_value~1", "expr-23~2"."expr~23_value~1", "expr-28~2"."expr~28_value~1") THEN ('empty')::edgedb.float64_range_t | |
| ELSE edgedb.float64_range_t("expr-10~2"."expr~10_value~5", "expr-13~2"."expr~13_value~5", (ARRAY[['()', '(]'], ['[)', '[]']])[(("expr-18~2"."expr~18_value~1")::int4 + 1)][(("expr-23~2"."expr~23_value~1")::int4 + 1)]) | |
| END) AS "range_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163dec00>*/ | |
| edgedbstd."std|cast@std|json@std|bool_f"("expr-27~2"."expr~27_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<std::float64>'', in range parameter ''empty'', "}') AS "expr~28_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163df650>*/ | |
| "q~4"."expr~27_value~1" AS "expr~27_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163df470>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("expr-26~2"."expr~26_value~2", "expr-7~2"."expr~7_value~2", ('empty')::text) AS "expr~27_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163df320>*/ | |
| "q~2"."expr~26_value~1" AS "expr~26_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163df740>*/ | |
| edgedbstd."f1101ffb-b0ae-550f-b001-db284b49bfaf"(('false')::text) AS "expr~26_value~1" | |
| ) AS "q~2" | |
| ) AS "expr-26~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163df4d0>*/ | |
| "q~3"."expr~7_value~1" AS "expr~7_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163df3b0>*/ | |
| edgedbstd."e1e556ca-3fd9-5d26-b4f6-738df42108b8"(($1)::jsonb) AS "expr~7_value~1" | |
| WHERE | |
| (($1)::jsonb IS NOT NULL) | |
| ) AS "q~3" | |
| ) AS "expr-7~2" | |
| WHERE | |
| ("expr-7~2"."expr~7_value~2" IS NOT NULL) | |
| ) AS "q~4" | |
| ) AS "expr-27~2" | |
| ) AS "expr-28~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163dfe90>*/ | |
| edgedbstd."std|cast@std|json@std|bool_f"("expr-17~2"."expr~17_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<std::float64>'', in range parameter ''inc_lower'', "}') AS "expr~18_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163dfe30>*/ | |
| "q~7"."expr~17_value~1" AS "expr~17_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163dd040>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("expr-16~2"."expr~16_value~2", "expr-7~4"."expr~7_value~4", ('inc_lower')::text) AS "expr~17_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1164083b0>*/ | |
| "q~5"."expr~16_value~1" AS "expr~16_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1164082c0>*/ | |
| edgedbstd."f1101ffb-b0ae-550f-b001-db284b49bfaf"(('true')::text) AS "expr~16_value~1" | |
| ) AS "q~5" | |
| ) AS "expr-16~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11554b680>*/ | |
| "q~6"."expr~7_value~3" AS "expr~7_value~4" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11554abd0>*/ | |
| edgedbstd."e1e556ca-3fd9-5d26-b4f6-738df42108b8"(($1)::jsonb) AS "expr~7_value~3" | |
| WHERE | |
| (($1)::jsonb IS NOT NULL) | |
| ) AS "q~6" | |
| ) AS "expr-7~4" | |
| WHERE | |
| ("expr-7~4"."expr~7_value~4" IS NOT NULL) | |
| ) AS "q~7" | |
| ) AS "expr-17~2" | |
| ) AS "expr-18~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11554b980>*/ | |
| edgedbstd."std|cast@std|json@std|bool_f"("expr-22~2"."expr~22_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<std::float64>'', in range parameter ''inc_upper'', "}') AS "expr~23_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11554b530>*/ | |
| "q~10"."expr~22_value~1" AS "expr~22_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11554bec0>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("expr-21~2"."expr~21_value~2", "expr-7~6"."expr~7_value~6", ('inc_upper')::text) AS "expr~22_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11554b890>*/ | |
| "q~8"."expr~21_value~1" AS "expr~21_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556d430>*/ | |
| edgedbstd."f1101ffb-b0ae-550f-b001-db284b49bfaf"(('false')::text) AS "expr~21_value~1" | |
| ) AS "q~8" | |
| ) AS "expr-21~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556ca10>*/ | |
| "q~9"."expr~7_value~5" AS "expr~7_value~6" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556dd30>*/ | |
| edgedbstd."e1e556ca-3fd9-5d26-b4f6-738df42108b8"(($1)::jsonb) AS "expr~7_value~5" | |
| WHERE | |
| (($1)::jsonb IS NOT NULL) | |
| ) AS "q~9" | |
| ) AS "expr-7~6" | |
| WHERE | |
| ("expr-7~6"."expr~7_value~6" IS NOT NULL) | |
| ) AS "q~10" | |
| ) AS "expr-22~2" | |
| ) AS "expr-23~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556cbf0>*/ | |
| "q~15"."expr~10_value~4" AS "expr~10_value~5" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556cc80>*/ | |
| ("m~3" = first_value("m~3") OVER ()) AS "m~3", | |
| "q~14"."expr~10_value~2" AS "expr~10_value~4" | |
| FROM | |
| LATERAL | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x11556caa0>*/ | |
| 1 AS "m~3", | |
| "q~13"."expr~10_value~1" AS "expr~10_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556d370>*/ | |
| edgedbstd."std|cast@std|json@std|float64_f"("expr-9~2"."expr~9_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<std::float64>'', in range parameter ''lower'', "}') AS "expr~10_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556cd10>*/ | |
| "q~12"."expr~9_value~1" AS "expr~9_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556cfb0>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("v~2"."v~3", "expr-7~8"."expr~7_value~8", ('lower')::text) AS "expr~9_value~1" | |
| FROM | |
| (SELECT (NULL)::jsonb AS "v~3") AS "v~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556d700>*/ | |
| "q~11"."expr~7_value~7" AS "expr~7_value~8" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556e360>*/ | |
| edgedbstd."e1e556ca-3fd9-5d26-b4f6-738df42108b8"(($1)::jsonb) AS "expr~7_value~7" | |
| WHERE | |
| (($1)::jsonb IS NOT NULL) | |
| ) AS "q~11" | |
| ) AS "expr-7~8" | |
| WHERE | |
| ("expr-7~8"."expr~7_value~8" IS NOT NULL) | |
| ) AS "q~12" | |
| ) AS "expr-9~2" | |
| ) AS "q~13" | |
| WHERE | |
| ("q~13"."expr~10_value~1" IS NOT NULL) | |
| ) UNION ALL | |
| (SELECT/*<pg.SelectStmt at 0x11556cad0>*/ | |
| 2 AS "m~3", | |
| "v~1"."v~4" AS "expr~10_value~3" | |
| FROM | |
| (SELECT (NULL)::float8 AS "v~4") AS "v~1" | |
| ) | |
| ) AS "q~14" | |
| ) AS "q~15" | |
| WHERE | |
| "q~15"."m~3" | |
| ) AS "expr-10~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556e990>*/ | |
| "q~20"."expr~13_value~4" AS "expr~13_value~5" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556eb70>*/ | |
| ("m~4" = first_value("m~4") OVER ()) AS "m~4", | |
| "q~19"."expr~13_value~2" AS "expr~13_value~4" | |
| FROM | |
| LATERAL | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x11556d9d0>*/ | |
| 1 AS "m~4", | |
| "q~18"."expr~13_value~1" AS "expr~13_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556db50>*/ | |
| edgedbstd."std|cast@std|json@std|float64_f"("expr-12~2"."expr~12_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<std::float64>'', in range parameter ''upper'', "}') AS "expr~13_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556d850>*/ | |
| "q~17"."expr~12_value~1" AS "expr~12_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556fc80>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("v~6"."v~7", "expr-7~10"."expr~7_value~10", ('upper')::text) AS "expr~12_value~1" | |
| FROM | |
| (SELECT (NULL)::jsonb AS "v~7") AS "v~6" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556fb30>*/ | |
| "q~16"."expr~7_value~9" AS "expr~7_value~10" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556fec0>*/ | |
| edgedbstd."e1e556ca-3fd9-5d26-b4f6-738df42108b8"(($1)::jsonb) AS "expr~7_value~9" | |
| WHERE | |
| (($1)::jsonb IS NOT NULL) | |
| ) AS "q~16" | |
| ) AS "expr-7~10" | |
| WHERE | |
| ("expr-7~10"."expr~7_value~10" IS NOT NULL) | |
| ) AS "q~17" | |
| ) AS "expr-12~2" | |
| ) AS "q~18" | |
| WHERE | |
| ("q~18"."expr~13_value~1" IS NOT NULL) | |
| ) UNION ALL | |
| (SELECT/*<pg.SelectStmt at 0x11556dd60>*/ | |
| 2 AS "m~4", | |
| "v~5"."v~8" AS "expr~13_value~3" | |
| FROM | |
| (SELECT (NULL)::float8 AS "v~8") AS "v~5" | |
| ) | |
| ) AS "q~19" | |
| ) AS "q~20" | |
| WHERE | |
| "q~20"."m~4" | |
| ) AS "expr-13~2" | |
| ) AS "expr-29~2" | |
| ))::edgedb.float64_range_t AS "3a72f964-15fd-11ef-85c4-ff221f9bc21a", | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x11556c320>*/ | |
| "expr-69~2"."multirange_value~1" AS "multirange_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11556c0b0>*/ | |
| edgedb.float64_multirange_t(VARIADIC "expr-68~2"."1_value~4") AS "multirange_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x113bc41d0>*/ | |
| "expr-67~2"."1_value~3" AS "1_value~4" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163dfe60>*/ | |
| "q~39"."array_value~5" AS "1_value~3" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115643b60>*/ | |
| edgedbstd."std|cast@std|json@array<std||json>_f"(($2)::jsonb) AS "array_value~1" | |
| ) AS "expr-34~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163dcbf0>*/ | |
| "expr-34~2"."array_value~1" AS "array_value~2" | |
| ) AS "q~21" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115640770>*/ | |
| "expr-66~3"."array_value~4" AS "array_value~5" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1156406e0>*/ | |
| COALESCE("q~38"."array_value~3", (ARRAY[])::edgedb.float64_range_t[]) AS "array_value~4" | |
| FROM | |
| (SELECT/*<pg.SelectStmt at 0x1156405f0>*/ | |
| array_agg("expr-63~2"."range_value~5") AS "array_value~3" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1156422a0>*/ | |
| "expr-62~2"."range_value~4" AS "range_value~5" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115640cb0>*/ | |
| "expr-60~2"."range_value~3" AS "range_value~4" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115641be0>*/ | |
| "q~22"."expr~57_value~1" AS "expr~57_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1156419a0>*/ | |
| edgedbstd."f1101ffb-b0ae-550f-b001-db284b49bfaf"(('false')::text) AS "expr~57_value~1" | |
| ) AS "q~22" | |
| ) AS "expr-57~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115641f10>*/ | |
| "q~23"."1_value~1" AS "1_value~2", | |
| "q~23"."0_value~1" AS "0_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115640140>*/ | |
| "f~1"."v~9" AS "1_value~1", | |
| ("f~1"._i - 1) AS "0_value~1" | |
| FROM | |
| LATERAL ROWS FROM (unnest("expr-34~2"."array_value~1")) WITH ORDINALITY AS "f~1"("v~9", _i) | |
| ) AS "q~23" | |
| ) AS "expr-37~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115640dd0>*/ | |
| "q~24"."expr~38_value~1" AS "expr~38_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115641340>*/ | |
| edgedbstd."e1e556ca-3fd9-5d26-b4f6-738df42108b8"("expr-37~2"."1_value~2") AS "expr~38_value~1" | |
| WHERE | |
| ("expr-37~2"."1_value~2" IS NOT NULL) | |
| ) AS "q~24" | |
| ) AS "expr-38~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115641400>*/ | |
| edgedbstd."std|cast@std|json@std|bool_f"("expr-58~2"."expr~58_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<std::float64>'', in range parameter ''empty'', "}') AS "expr~59_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1156424e0>*/ | |
| "q~25"."expr~58_value~1" AS "expr~58_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115642360>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("expr-57~2"."expr~57_value~2", "expr-38~2"."expr~38_value~2", ('empty')::text) AS "expr~58_value~1" | |
| WHERE | |
| ("expr-38~2"."expr~38_value~2" IS NOT NULL) | |
| ) AS "q~25" | |
| ) AS "expr-58~2" | |
| ) AS "expr-59~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1156429c0>*/ | |
| "q~26"."expr~47_value~1" AS "expr~47_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115643560>*/ | |
| edgedbstd."f1101ffb-b0ae-550f-b001-db284b49bfaf"(('true')::text) AS "expr~47_value~1" | |
| ) AS "q~26" | |
| ) AS "expr-47~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115642ab0>*/ | |
| edgedbstd."std|cast@std|json@std|bool_f"("expr-48~2"."expr~48_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<std::float64>'', in range parameter ''inc_lower'', "}') AS "expr~49_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115643200>*/ | |
| "q~27"."expr~48_value~1" AS "expr~48_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115643140>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("expr-47~2"."expr~47_value~2", "expr-38~2"."expr~38_value~2", ('inc_lower')::text) AS "expr~48_value~1" | |
| WHERE | |
| ("expr-38~2"."expr~38_value~2" IS NOT NULL) | |
| ) AS "q~27" | |
| ) AS "expr-48~2" | |
| ) AS "expr-49~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11632f050>*/ | |
| "q~28"."expr~52_value~1" AS "expr~52_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11632e8d0>*/ | |
| edgedbstd."f1101ffb-b0ae-550f-b001-db284b49bfaf"(('false')::text) AS "expr~52_value~1" | |
| ) AS "q~28" | |
| ) AS "expr-52~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11637ab10>*/ | |
| edgedbstd."std|cast@std|json@std|bool_f"("expr-53~2"."expr~53_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<std::float64>'', in range parameter ''inc_upper'', "}') AS "expr~54_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11632e2d0>*/ | |
| "q~29"."expr~53_value~1" AS "expr~53_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11632f770>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("expr-52~2"."expr~52_value~2", "expr-38~2"."expr~38_value~2", ('inc_upper')::text) AS "expr~53_value~1" | |
| WHERE | |
| ("expr-38~2"."expr~38_value~2" IS NOT NULL) | |
| ) AS "q~29" | |
| ) AS "expr-53~2" | |
| ) AS "expr-54~2" | |
| CROSS JOIN (SELECT (NULL)::jsonb AS "v~12") AS "v~11" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1136dd6a0>*/ | |
| "q~33"."expr~41_value~4" AS "expr~41_value~5" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x113bdb710>*/ | |
| ("m~5" = first_value("m~5") OVER ()) AS "m~5", | |
| "q~32"."expr~41_value~2" AS "expr~41_value~4" | |
| FROM | |
| LATERAL | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x113bda7b0>*/ | |
| 1 AS "m~5", | |
| "q~31"."expr~41_value~1" AS "expr~41_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x113bda1b0>*/ | |
| edgedbstd."std|cast@std|json@std|float64_f"("expr-40~2"."expr~40_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<std::float64>'', in range parameter ''lower'', "}') AS "expr~41_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x113bdb5f0>*/ | |
| "q~30"."expr~40_value~1" AS "expr~40_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x113c85df0>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("v~11"."v~12", "expr-38~2"."expr~38_value~2", ('lower')::text) AS "expr~40_value~1" | |
| WHERE | |
| ("expr-38~2"."expr~38_value~2" IS NOT NULL) | |
| ) AS "q~30" | |
| ) AS "expr-40~2" | |
| ) AS "q~31" | |
| WHERE | |
| ("q~31"."expr~41_value~1" IS NOT NULL) | |
| ) UNION ALL | |
| (SELECT/*<pg.SelectStmt at 0x113bda7e0>*/ | |
| 2 AS "m~5", | |
| "v~10"."v~13" AS "expr~41_value~3" | |
| FROM | |
| (SELECT (NULL)::float8 AS "v~13") AS "v~10" | |
| ) | |
| ) AS "q~32" | |
| ) AS "q~33" | |
| WHERE | |
| "q~33"."m~5" | |
| ) AS "expr-41~2" | |
| CROSS JOIN (SELECT (NULL)::jsonb AS "v~16") AS "v~15" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115429730>*/ | |
| "q~37"."expr~44_value~4" AS "expr~44_value~5" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11542b5f0>*/ | |
| ("m~6" = first_value("m~6") OVER ()) AS "m~6", | |
| "q~36"."expr~44_value~2" AS "expr~44_value~4" | |
| FROM | |
| LATERAL | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x11542ae10>*/ | |
| 1 AS "m~6", | |
| "q~35"."expr~44_value~1" AS "expr~44_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1154288c0>*/ | |
| edgedbstd."std|cast@std|json@std|float64_f"("expr-43~2"."expr~43_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<std::float64>'', in range parameter ''upper'', "}') AS "expr~44_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11542a480>*/ | |
| "q~34"."expr~43_value~1" AS "expr~43_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11542bcb0>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("v~15"."v~16", "expr-38~2"."expr~38_value~2", ('upper')::text) AS "expr~43_value~1" | |
| WHERE | |
| ("expr-38~2"."expr~38_value~2" IS NOT NULL) | |
| ) AS "q~34" | |
| ) AS "expr-43~2" | |
| ) AS "q~35" | |
| WHERE | |
| ("q~35"."expr~44_value~1" IS NOT NULL) | |
| ) UNION ALL | |
| (SELECT/*<pg.SelectStmt at 0x11542b3b0>*/ | |
| 2 AS "m~6", | |
| "v~14"."v~17" AS "expr~44_value~3" | |
| FROM | |
| (SELECT (NULL)::float8 AS "v~17") AS "v~14" | |
| ) | |
| ) AS "q~36" | |
| ) AS "q~37" | |
| WHERE | |
| "q~37"."m~6" | |
| ) AS "expr-44~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115641670>*/ | |
| (CASE WHEN ((("expr-59~2"."expr~59_value~1" IS NULL) OR | |
| ("expr-54~2"."expr~54_value~1" IS NULL)) OR | |
| ("expr-49~2"."expr~49_value~1" IS NULL)) THEN NULL | |
| WHEN edgedb.range_validate("expr-41~2"."expr~41_value~5", "expr-44~2"."expr~44_value~5", "expr-49~2"."expr~49_value~1", "expr-54~2"."expr~54_value~1", "expr-59~2"."expr~59_value~1") THEN ('empty')::edgedb.float64_range_t | |
| ELSE edgedb.float64_range_t("expr-41~2"."expr~41_value~5", "expr-44~2"."expr~44_value~5", (ARRAY[['()', '(]'], ['[)', '[]']])[(("expr-49~2"."expr~49_value~1")::int4 + 1)][(("expr-54~2"."expr~54_value~1")::int4 + 1)]) | |
| END) AS "range_value~3" | |
| ) AS "expr-60~2" | |
| ORDER BY | |
| "expr-37~2"."0_value~2" ASC NULLS FIRST | |
| ) AS "expr-62~2" | |
| ) AS "expr-63~2" | |
| WHERE | |
| ("expr-63~2"."range_value~5" IS NOT NULL) | |
| ) AS "q~38" | |
| ) AS "expr-66~3" | |
| ) AS "q~39" | |
| WHERE | |
| ("q~21"."array_value~2" IS NOT NULL) | |
| ) AS "expr-67~2" | |
| ) AS "expr-68~2" | |
| ) AS "expr-69~2" | |
| ))::edgedb.float64_multirange_t AS "3a724e1a-15fd-11ef-bb68-6938f29cfbd5", | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x11556c680>*/ | |
| "expr-94~2"."range_value~6" AS "range_value~7" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163decf0>*/ | |
| (CASE WHEN ((("expr-93~2"."expr~93_value~1" IS NULL) OR | |
| ("expr-88~2"."expr~88_value~1" IS NULL)) OR | |
| ("expr-83~2"."expr~83_value~1" IS NULL)) THEN NULL | |
| WHEN edgedb.range_validate("expr-75~2"."expr~75_value~5", "expr-78~2"."expr~78_value~5", "expr-83~2"."expr~83_value~1", "expr-88~2"."expr~88_value~1", "expr-93~2"."expr~93_value~1") THEN ('empty')::daterange | |
| ELSE daterange("expr-75~2"."expr~75_value~5", "expr-78~2"."expr~78_value~5", (ARRAY[['()', '(]'], ['[)', '[]']])[(("expr-83~2"."expr~83_value~1")::int4 + 1)][(("expr-88~2"."expr~88_value~1")::int4 + 1)]) | |
| END) AS "range_value~6" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163deb40>*/ | |
| edgedbstd."std|cast@std|json@std|bool_f"("expr-92~2"."expr~92_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<cal::local_date>'', in range parameter ''empty'', "}') AS "expr~93_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163dfd40>*/ | |
| "q~42"."expr~92_value~1" AS "expr~92_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115640800>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("expr-91~2"."expr~91_value~2", "expr-72~2"."expr~72_value~2", ('empty')::text) AS "expr~92_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1156420f0>*/ | |
| "q~40"."expr~91_value~1" AS "expr~91_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115640b90>*/ | |
| edgedbstd."f1101ffb-b0ae-550f-b001-db284b49bfaf"(('false')::text) AS "expr~91_value~1" | |
| ) AS "q~40" | |
| ) AS "expr-91~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115642120>*/ | |
| "q~41"."expr~72_value~1" AS "expr~72_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115641220>*/ | |
| edgedbstd."e1e556ca-3fd9-5d26-b4f6-738df42108b8"(($3)::jsonb) AS "expr~72_value~1" | |
| WHERE | |
| (($3)::jsonb IS NOT NULL) | |
| ) AS "q~41" | |
| ) AS "expr-72~2" | |
| WHERE | |
| ("expr-72~2"."expr~72_value~2" IS NOT NULL) | |
| ) AS "q~42" | |
| ) AS "expr-92~2" | |
| ) AS "expr-93~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115429cd0>*/ | |
| edgedbstd."std|cast@std|json@std|bool_f"("expr-82~2"."expr~82_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<cal::local_date>'', in range parameter ''inc_lower'', "}') AS "expr~83_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11542ab40>*/ | |
| "q~45"."expr~82_value~1" AS "expr~82_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11542a990>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("expr-81~2"."expr~81_value~2", "expr-72~4"."expr~72_value~4", ('inc_lower')::text) AS "expr~82_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11542a300>*/ | |
| "q~43"."expr~81_value~1" AS "expr~81_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11542b1d0>*/ | |
| edgedbstd."f1101ffb-b0ae-550f-b001-db284b49bfaf"(('true')::text) AS "expr~81_value~1" | |
| ) AS "q~43" | |
| ) AS "expr-81~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11542be00>*/ | |
| "q~44"."expr~72_value~3" AS "expr~72_value~4" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115428950>*/ | |
| edgedbstd."e1e556ca-3fd9-5d26-b4f6-738df42108b8"(($3)::jsonb) AS "expr~72_value~3" | |
| WHERE | |
| (($3)::jsonb IS NOT NULL) | |
| ) AS "q~44" | |
| ) AS "expr-72~4" | |
| WHERE | |
| ("expr-72~4"."expr~72_value~4" IS NOT NULL) | |
| ) AS "q~45" | |
| ) AS "expr-82~2" | |
| ) AS "expr-83~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11542baa0>*/ | |
| edgedbstd."std|cast@std|json@std|bool_f"("expr-87~2"."expr~87_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<cal::local_date>'', in range parameter ''inc_upper'', "}') AS "expr~88_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115429220>*/ | |
| "q~48"."expr~87_value~1" AS "expr~87_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115429820>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("expr-86~2"."expr~86_value~2", "expr-72~6"."expr~72_value~6", ('inc_upper')::text) AS "expr~87_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11542bda0>*/ | |
| "q~46"."expr~86_value~1" AS "expr~86_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11542a5d0>*/ | |
| edgedbstd."f1101ffb-b0ae-550f-b001-db284b49bfaf"(('false')::text) AS "expr~86_value~1" | |
| ) AS "q~46" | |
| ) AS "expr-86~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153edc10>*/ | |
| "q~47"."expr~72_value~5" AS "expr~72_value~6" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153ede20>*/ | |
| edgedbstd."e1e556ca-3fd9-5d26-b4f6-738df42108b8"(($3)::jsonb) AS "expr~72_value~5" | |
| WHERE | |
| (($3)::jsonb IS NOT NULL) | |
| ) AS "q~47" | |
| ) AS "expr-72~6" | |
| WHERE | |
| ("expr-72~6"."expr~72_value~6" IS NOT NULL) | |
| ) AS "q~48" | |
| ) AS "expr-87~2" | |
| ) AS "expr-88~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153ed670>*/ | |
| "q~53"."expr~75_value~4" AS "expr~75_value~5" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153edbb0>*/ | |
| ("m~7" = first_value("m~7") OVER ()) AS "m~7", | |
| "q~52"."expr~75_value~2" AS "expr~75_value~4" | |
| FROM | |
| LATERAL | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x1153efb30>*/ | |
| 1 AS "m~7", | |
| "q~51"."expr~75_value~1" AS "expr~75_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153ef9e0>*/ | |
| edgedbstd."std|cast@std|json@cal|local_date_f"("expr-74~2"."expr~74_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<cal::local_date>'', in range parameter ''lower'', "}') AS "expr~75_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153ec7a0>*/ | |
| "q~50"."expr~74_value~1" AS "expr~74_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153efb00>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("v~19"."v~20", "expr-72~8"."expr~72_value~8", ('lower')::text) AS "expr~74_value~1" | |
| FROM | |
| (SELECT (NULL)::jsonb AS "v~20") AS "v~19" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153efdd0>*/ | |
| "q~49"."expr~72_value~7" AS "expr~72_value~8" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153eea20>*/ | |
| edgedbstd."e1e556ca-3fd9-5d26-b4f6-738df42108b8"(($3)::jsonb) AS "expr~72_value~7" | |
| WHERE | |
| (($3)::jsonb IS NOT NULL) | |
| ) AS "q~49" | |
| ) AS "expr-72~8" | |
| WHERE | |
| ("expr-72~8"."expr~72_value~8" IS NOT NULL) | |
| ) AS "q~50" | |
| ) AS "expr-74~2" | |
| ) AS "q~51" | |
| WHERE | |
| ("q~51"."expr~75_value~1" IS NOT NULL) | |
| ) UNION ALL | |
| (SELECT/*<pg.SelectStmt at 0x1153ee390>*/ | |
| 2 AS "m~7", | |
| "v~18"."v~21" AS "expr~75_value~3" | |
| FROM | |
| (SELECT (NULL)::edgedb.date_t AS "v~21") AS "v~18" | |
| ) | |
| ) AS "q~52" | |
| ) AS "q~53" | |
| WHERE | |
| "q~53"."m~7" | |
| ) AS "expr-75~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153ef740>*/ | |
| "q~58"."expr~78_value~4" AS "expr~78_value~5" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153ecad0>*/ | |
| ("m~8" = first_value("m~8") OVER ()) AS "m~8", | |
| "q~57"."expr~78_value~2" AS "expr~78_value~4" | |
| FROM | |
| LATERAL | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x1153edf10>*/ | |
| 1 AS "m~8", | |
| "q~56"."expr~78_value~1" AS "expr~78_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153eca40>*/ | |
| edgedbstd."std|cast@std|json@cal|local_date_f"("expr-77~2"."expr~77_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<cal::local_date>'', in range parameter ''upper'', "}') AS "expr~78_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153ee420>*/ | |
| "q~55"."expr~77_value~1" AS "expr~77_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153ed280>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("v~23"."v~24", "expr-72~10"."expr~72_value~10", ('upper')::text) AS "expr~77_value~1" | |
| FROM | |
| (SELECT (NULL)::jsonb AS "v~24") AS "v~23" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153ee4e0>*/ | |
| "q~54"."expr~72_value~9" AS "expr~72_value~10" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153edb50>*/ | |
| edgedbstd."e1e556ca-3fd9-5d26-b4f6-738df42108b8"(($3)::jsonb) AS "expr~72_value~9" | |
| WHERE | |
| (($3)::jsonb IS NOT NULL) | |
| ) AS "q~54" | |
| ) AS "expr-72~10" | |
| WHERE | |
| ("expr-72~10"."expr~72_value~10" IS NOT NULL) | |
| ) AS "q~55" | |
| ) AS "expr-77~2" | |
| ) AS "q~56" | |
| WHERE | |
| ("q~56"."expr~78_value~1" IS NOT NULL) | |
| ) UNION ALL | |
| (SELECT/*<pg.SelectStmt at 0x1153ec1d0>*/ | |
| 2 AS "m~8", | |
| "v~22"."v~25" AS "expr~78_value~3" | |
| FROM | |
| (SELECT (NULL)::edgedb.date_t AS "v~25") AS "v~22" | |
| ) | |
| ) AS "q~57" | |
| ) AS "q~58" | |
| WHERE | |
| "q~58"."m~8" | |
| ) AS "expr-78~2" | |
| ) AS "expr-94~2" | |
| ))::daterange AS "3a72c818-15fd-11ef-a039-a1877e5d8769", | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x1163debd0>*/ | |
| "expr-134~2"."multirange_value~3" AS "multirange_value~4" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1153ec0b0>*/ | |
| datemultirange(VARIADIC "expr-133~2"."1_value~8") AS "multirange_value~3" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11558b6b0>*/ | |
| "expr-132~2"."1_value~7" AS "1_value~8" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11558b1d0>*/ | |
| "q~77"."array_value~10" AS "1_value~7" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1155886b0>*/ | |
| edgedbstd."std|cast@std|json@array<std||json>_f"(($4)::jsonb) AS "array_value~6" | |
| ) AS "expr-99~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11558b710>*/ | |
| "expr-99~2"."array_value~6" AS "array_value~7" | |
| ) AS "q~59" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11558b950>*/ | |
| "expr-131~3"."array_value~9" AS "array_value~10" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115588800>*/ | |
| COALESCE("q~76"."array_value~8", (ARRAY[])::daterange[]) AS "array_value~9" | |
| FROM | |
| (SELECT/*<pg.SelectStmt at 0x11558bec0>*/ | |
| array_agg("expr-128~2"."range_value~10") AS "array_value~8" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11558b200>*/ | |
| "expr-127~2"."range_value~9" AS "range_value~10" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1154d8f50>*/ | |
| "expr-125~2"."range_value~8" AS "range_value~9" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3c0b0>*/ | |
| "q~60"."expr~122_value~1" AS "expr~122_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3c170>*/ | |
| edgedbstd."f1101ffb-b0ae-550f-b001-db284b49bfaf"(('false')::text) AS "expr~122_value~1" | |
| ) AS "q~60" | |
| ) AS "expr-122~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3e0c0>*/ | |
| "q~61"."1_value~5" AS "1_value~6", | |
| "q~61"."0_value~4" AS "0_value~5" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3d520>*/ | |
| "f~2"."v~26" AS "1_value~5", | |
| ("f~2"._i - 1) AS "0_value~4" | |
| FROM | |
| LATERAL ROWS FROM (unnest("expr-99~2"."array_value~6")) WITH ORDINALITY AS "f~2"("v~26", _i) | |
| ) AS "q~61" | |
| ) AS "expr-102~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3fbc0>*/ | |
| "q~62"."expr~103_value~1" AS "expr~103_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3d460>*/ | |
| edgedbstd."e1e556ca-3fd9-5d26-b4f6-738df42108b8"("expr-102~2"."1_value~6") AS "expr~103_value~1" | |
| WHERE | |
| ("expr-102~2"."1_value~6" IS NOT NULL) | |
| ) AS "q~62" | |
| ) AS "expr-103~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x11386ae10>*/ | |
| edgedbstd."std|cast@std|json@std|bool_f"("expr-123~2"."expr~123_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<cal::local_date>'', in range parameter ''empty'', "}') AS "expr~124_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3f260>*/ | |
| "q~63"."expr~123_value~1" AS "expr~123_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3ea50>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("expr-122~2"."expr~122_value~2", "expr-103~2"."expr~103_value~2", ('empty')::text) AS "expr~123_value~1" | |
| WHERE | |
| ("expr-103~2"."expr~103_value~2" IS NOT NULL) | |
| ) AS "q~63" | |
| ) AS "expr-123~2" | |
| ) AS "expr-124~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3c7d0>*/ | |
| "q~64"."expr~112_value~1" AS "expr~112_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3eff0>*/ | |
| edgedbstd."f1101ffb-b0ae-550f-b001-db284b49bfaf"(('true')::text) AS "expr~112_value~1" | |
| ) AS "q~64" | |
| ) AS "expr-112~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3f290>*/ | |
| edgedbstd."std|cast@std|json@std|bool_f"("expr-113~2"."expr~113_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<cal::local_date>'', in range parameter ''inc_lower'', "}') AS "expr~114_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3f110>*/ | |
| "q~65"."expr~113_value~1" AS "expr~113_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3cc80>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("expr-112~2"."expr~112_value~2", "expr-103~2"."expr~103_value~2", ('inc_lower')::text) AS "expr~113_value~1" | |
| WHERE | |
| ("expr-103~2"."expr~103_value~2" IS NOT NULL) | |
| ) AS "q~65" | |
| ) AS "expr-113~2" | |
| ) AS "expr-114~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3dee0>*/ | |
| "q~66"."expr~117_value~1" AS "expr~117_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3cd70>*/ | |
| edgedbstd."f1101ffb-b0ae-550f-b001-db284b49bfaf"(('false')::text) AS "expr~117_value~1" | |
| ) AS "q~66" | |
| ) AS "expr-117~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3e900>*/ | |
| edgedbstd."std|cast@std|json@std|bool_f"("expr-118~2"."expr~118_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<cal::local_date>'', in range parameter ''inc_upper'', "}') AS "expr~119_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3e540>*/ | |
| "q~67"."expr~118_value~1" AS "expr~118_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3e6f0>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("expr-117~2"."expr~117_value~2", "expr-103~2"."expr~103_value~2", ('inc_upper')::text) AS "expr~118_value~1" | |
| WHERE | |
| ("expr-103~2"."expr~103_value~2" IS NOT NULL) | |
| ) AS "q~67" | |
| ) AS "expr-118~2" | |
| ) AS "expr-119~2" | |
| CROSS JOIN (SELECT (NULL)::jsonb AS "v~29") AS "v~28" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3ca10>*/ | |
| "q~71"."expr~106_value~4" AS "expr~106_value~5" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3eb10>*/ | |
| ("m~9" = first_value("m~9") OVER ()) AS "m~9", | |
| "q~70"."expr~106_value~2" AS "expr~106_value~4" | |
| FROM | |
| LATERAL | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x115a3d2e0>*/ | |
| 1 AS "m~9", | |
| "q~69"."expr~106_value~1" AS "expr~106_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3f860>*/ | |
| edgedbstd."std|cast@std|json@cal|local_date_f"("expr-105~2"."expr~105_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<cal::local_date>'', in range parameter ''lower'', "}') AS "expr~106_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3edb0>*/ | |
| "q~68"."expr~105_value~1" AS "expr~105_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x115a3ee10>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("v~28"."v~29", "expr-103~2"."expr~103_value~2", ('lower')::text) AS "expr~105_value~1" | |
| WHERE | |
| ("expr-103~2"."expr~103_value~2" IS NOT NULL) | |
| ) AS "q~68" | |
| ) AS "expr-105~2" | |
| ) AS "q~69" | |
| WHERE | |
| ("q~69"."expr~106_value~1" IS NOT NULL) | |
| ) UNION ALL | |
| (SELECT/*<pg.SelectStmt at 0x115a3f4d0>*/ | |
| 2 AS "m~9", | |
| "v~27"."v~30" AS "expr~106_value~3" | |
| FROM | |
| (SELECT (NULL)::edgedb.date_t AS "v~30") AS "v~27" | |
| ) | |
| ) AS "q~70" | |
| ) AS "q~71" | |
| WHERE | |
| "q~71"."m~9" | |
| ) AS "expr-106~2" | |
| CROSS JOIN (SELECT (NULL)::jsonb AS "v~33") AS "v~32" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x113d56b70>*/ | |
| "q~75"."expr~109_value~4" AS "expr~109_value~5" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x113d559a0>*/ | |
| ("m~10" = first_value("m~10") OVER ()) AS "m~10", | |
| "q~74"."expr~109_value~2" AS "expr~109_value~4" | |
| FROM | |
| LATERAL | |
| ( | |
| (SELECT/*<pg.SelectStmt at 0x113d57770>*/ | |
| 1 AS "m~10", | |
| "q~73"."expr~109_value~1" AS "expr~109_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x113d4f650>*/ | |
| edgedbstd."std|cast@std|json@cal|local_date_f"("expr-108~2"."expr~108_value~2", '{"error_message_context": "while casting ''std::json'' to ''range<cal::local_date>'', in range parameter ''upper'', "}') AS "expr~109_value~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x113d550d0>*/ | |
| "q~72"."expr~108_value~1" AS "expr~108_value~2" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x113d4ef90>*/ | |
| edgedbstd."47e3264c-8091-5a3c-b2c5-b55df212c73c"("v~32"."v~33", "expr-103~2"."expr~103_value~2", ('upper')::text) AS "expr~108_value~1" | |
| WHERE | |
| ("expr-103~2"."expr~103_value~2" IS NOT NULL) | |
| ) AS "q~72" | |
| ) AS "expr-108~2" | |
| ) AS "q~73" | |
| WHERE | |
| ("q~73"."expr~109_value~1" IS NOT NULL) | |
| ) UNION ALL | |
| (SELECT/*<pg.SelectStmt at 0x113d55e20>*/ | |
| 2 AS "m~10", | |
| "v~31"."v~34" AS "expr~109_value~3" | |
| FROM | |
| (SELECT (NULL)::edgedb.date_t AS "v~34") AS "v~31" | |
| ) | |
| ) AS "q~74" | |
| ) AS "q~75" | |
| WHERE | |
| "q~75"."m~10" | |
| ) AS "expr-109~2" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1154d9ac0>*/ | |
| (CASE WHEN ((("expr-124~2"."expr~124_value~1" IS NULL) OR | |
| ("expr-119~2"."expr~119_value~1" IS NULL)) OR | |
| ("expr-114~2"."expr~114_value~1" IS NULL)) THEN NULL | |
| WHEN edgedb.range_validate("expr-106~2"."expr~106_value~5", "expr-109~2"."expr~109_value~5", "expr-114~2"."expr~114_value~1", "expr-119~2"."expr~119_value~1", "expr-124~2"."expr~124_value~1") THEN ('empty')::daterange | |
| ELSE daterange("expr-106~2"."expr~106_value~5", "expr-109~2"."expr~109_value~5", (ARRAY[['()', '(]'], ['[)', '[]']])[(("expr-114~2"."expr~114_value~1")::int4 + 1)][(("expr-119~2"."expr~119_value~1")::int4 + 1)]) | |
| END) AS "range_value~8" | |
| ) AS "expr-125~2" | |
| ORDER BY | |
| "expr-102~2"."0_value~5" ASC NULLS FIRST | |
| ) AS "expr-127~2" | |
| ) AS "expr-128~2" | |
| WHERE | |
| ("expr-128~2"."range_value~10" IS NOT NULL) | |
| ) AS "q~76" | |
| ) AS "expr-131~3" | |
| ) AS "q~77" | |
| WHERE | |
| ("q~59"."array_value~7" IS NOT NULL) | |
| ) AS "expr-132~2" | |
| ) AS "expr-133~2" | |
| ) AS "expr-134~2" | |
| ))::datemultirange AS "3a722160-15fd-11ef-9151-d7edb66caa63", | |
| "RangeTest~4".id AS "RangeTest_identity~2" | |
| FROM | |
| edgedbpub."3a6ecca4-15fd-11ef-976b-575f9467c82e" AS "RangeTest~4", | |
| "range~1" AS "range~2" | |
| WHERE | |
| ("RangeTest~4".id = "range~2"."RangeTest_identity~1") | |
| )), | |
| "m~1" AS | |
| (UPDATE | |
| edgedbpub."3a6ecca4-15fd-11ef-976b-575f9467c82e" AS "RangeTest~4" | |
| SET | |
| ("3a72f964-15fd-11ef-85c4-ff221f9bc21a", "3a724e1a-15fd-11ef-bb68-6938f29cfbd5", "3a72c818-15fd-11ef-a039-a1877e5d8769", "3a722160-15fd-11ef-9151-d7edb66caa63") = | |
| (SELECT/*<pg.SelectStmt at 0x11558b380>*/ | |
| "upd_contents~2"."3a72f964-15fd-11ef-85c4-ff221f9bc21a", | |
| "upd_contents~2"."3a724e1a-15fd-11ef-bb68-6938f29cfbd5", | |
| "upd_contents~2"."3a72c818-15fd-11ef-a039-a1877e5d8769", | |
| "upd_contents~2"."3a722160-15fd-11ef-9151-d7edb66caa63" | |
| ) | |
| FROM | |
| "upd_contents~1" AS "upd_contents~2" | |
| WHERE | |
| ("RangeTest~4".id = "upd_contents~2"."RangeTest_identity~2") | |
| RETURNING | |
| "RangeTest~4".id AS "RangeTest_value~1", | |
| "RangeTest~4"."3a728d94-15fd-11ef-8be8-21e0df54676e" AS "name_value~1", | |
| "RangeTest~4"."3a72f964-15fd-11ef-85c4-ff221f9bc21a" AS "rval_serialized~1", | |
| "RangeTest~4"."3a724e1a-15fd-11ef-bb68-6938f29cfbd5" AS "mval_serialized~1", | |
| "RangeTest~4"."3a72c818-15fd-11ef-a039-a1877e5d8769" AS "rdate_serialized~1", | |
| "RangeTest~4"."3a722160-15fd-11ef-9151-d7edb66caa63" AS "mdate_serialized~1") | |
| SELECT/*<pg.SelectStmt at 0x1163b3d40>*/ | |
| to_json(json_build_object('update_RangeTest', | |
| (SELECT/*<pg.SelectStmt at 0x1163ddfa0>*/ | |
| COALESCE(array_agg("aggw~1"."update_RangeTest_serialized~1"), (ARRAY[])::json[]) AS "v~35" | |
| FROM | |
| (SELECT/*<pg.SelectStmt at 0x1163dd460>*/ | |
| to_json("RangeTest_update_RangeTest~2"."RangeTest_serialized~1") AS "update_RangeTest_serialized~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163dc9e0>*/ | |
| "RangeTest~5"."RangeTest_value~2" AS "RangeTest_value~3", | |
| json_build_object('name', "RangeTest~5"."name_value~2", 'rval', | |
| (SELECT/*<pg.SelectStmt at 0x11558afc0>*/ | |
| (edgedb.range_to_jsonb("RangeTest~5"."rval_serialized~2"))::json AS "rval_serialized~3" | |
| ), 'mval', | |
| (SELECT/*<pg.SelectStmt at 0x1154d8ce0>*/ | |
| (edgedb.multirange_to_jsonb("RangeTest~5"."mval_serialized~2"))::json AS "mval_serialized~3" | |
| ), 'rdate', | |
| (SELECT/*<pg.SelectStmt at 0x1154dab70>*/ | |
| (edgedb.range_to_jsonb("RangeTest~5"."rdate_serialized~2"))::json AS "rdate_serialized~3" | |
| ), 'mdate', | |
| (SELECT/*<pg.SelectStmt at 0x115285940>*/ | |
| (edgedb.multirange_to_jsonb("RangeTest~5"."mdate_serialized~2"))::json AS "mdate_serialized~3" | |
| )) AS "RangeTest_serialized~1" | |
| FROM | |
| LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163dda00>*/ | |
| "m~2"."RangeTest_value~1" AS "RangeTest_value~2", | |
| "m~2"."name_value~1" AS "name_value~2", | |
| "m~2"."rval_serialized~1" AS "rval_serialized~2", | |
| "m~2"."mval_serialized~1" AS "mval_serialized~2", | |
| "m~2"."rdate_serialized~1" AS "rdate_serialized~2", | |
| "m~2"."mdate_serialized~1" AS "mdate_serialized~2" | |
| FROM | |
| "m~1" AS "m~2" | |
| ) AS "RangeTest~5" | |
| ) AS "RangeTest_update_RangeTest~2" | |
| ) AS "aggw~1" | |
| ))) AS "expr~1_serialized~1" | |
| FROM | |
| (SELECT/*<pg.SelectStmt at 0x1163dc290>*/ | |
| ('3b741934-07ef-5b95-b7d6-cdc864fd2ae8')::uuid AS "FreeObject_value~1" | |
| ) AS "q~1" | |
| CROSS JOIN LATERAL | |
| (SELECT/*<pg.SelectStmt at 0x1163ddd30>*/ | |
| "q~1"."FreeObject_value~1" AS "FreeObject_value~2" | |
| ) AS "expr-1~2" | |
| ------------------------------------------------------------------------------------------ Exception occurred: subquery in FROM must have an alias ------------------------------------------------------------------------------------------- | |
| 1. edb.server.pgcon.errors.BackendError: subquery in FROM must have an alias | |
| ----------------------------------------------------------------------------------------------------------------- Traceback ------------------------------------------------------------------------------------------------------------------ | |
| edb/graphql/extension.pyx, line 205, in edb.graphql.extension.handle_request | |
| > result = await _execute( | |
| edb/graphql/extension.pyx, line 388, in _execute | |
| > return await execute.execute_json( | |
| edb/server/protocol/execute.pyx, line 756, in execute_json | |
| > data = await execute( | |
| edb/server/protocol/execute.pyx, line 370, in execute | |
| > raise | |
| edb/server/protocol/execute.pyx, line 290, in edb.server.protocol.execute.execute | |
| > data = await be_conn.parse_execute( | |
| edb/server/pgcon/pgcon.pyx, line 1431, in parse_execute | |
| > return await self._parse_execute( | |
| edb/server/pgcon/pgcon.pyx, line 1384, in _parse_execute | |
| > raise er_cls(fields=er_fields) | |
| edb.server.pgcon.errors.BackendError: subquery in FROM must have an alias | |
| test_graphql_mutation_update_range_02 (test_http_graphql_mutation.TestGraphQLMutation.test_graphql_mutation_update_range_02): ERROR |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment