首页 项目目录 关于我们
Sign In
rust
/
Materialize
1
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Branch: master
Branches Tags
Materialize
/
test
/
pgtest
/
range.pt

range.pt 24 KB
Permalink History Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471 
  1. # test that our range types' binary functions have the same implementation/results as PG
    2. 

  2. 

  3. send
    4. 

  4. Parse {"query": "CREATE TABLE int4range_values (a int4range)"}
    5. 

  5. Bind
    6. 

  6. Execute
    7. 

  7. Parse {"query": "INSERT INTO int4range_values VALUES ('[,1)'), ('[,1]'), ('[,)'), ('[,]'), ('(,1)'), ('(,1]'), ('(,)'), ('(,]'), ('[-1,1)'), ('[-1,1]'), ('(-1,1)'), ('(-1,1]'), ('[0,0)'), ('[0,0]'), ('(0,0)'), ('(0,0]'), ('[1,)'), ('[1,]'), ('(1,)'), ('(1,]')"}
    8. 

  8. Bind
    9. 

  9. Execute
    10. 

  10. Parse {"query": "CREATE TABLE int4range_test_values (v int4range)"}
    11. 

  11. Bind
    12. 

  12. Execute
    13. 

  13. Parse {"query": "INSERT INTO int4range_test_values VALUES ('empty'), ('(,)'), ('(,1)'), ('(-1,)'), ('[-1,1)'), ('[-99,-50)'), ('[50,99)')"}
    14. 

  14. Bind
    15. 

  15. Execute
    16. 

  16. Parse {"query": "CREATE TABLE numrange_values (a numrange)"}
    17. 

  17. Bind
    18. 

  18. Execute
    19. 

  19. Parse {"query": "INSERT INTO numrange_values VALUES ('[,1)'), ('[,1]'), ('[,)'), ('[,]'), ('(,1)'), ('(,1]'), ('(,)'), ('(,]'), ('[-1,1)'), ('[-1,1]'), ('(-1,1)'), ('(-1,1]'), ('[0,0)'), ('[0,0]'), ('(0,0)'), ('(0,0]'), ('[1,)'), ('[1,]'), ('(1,)'), ('(1,]')"}
    20. 

  20. Bind
    21. 

  21. Execute
    22. 

  22. Parse {"query": "CREATE TABLE numrange_test_values (v numrange)"}
    23. 

  23. Bind
    24. 

  24. Execute
    25. 

  25. Parse {"query": "INSERT INTO numrange_test_values VALUES ('empty'), ('(,)'), ('(,1)'), ('(-1,)'), ('[-1,1)'), ('[-99,-50)'), ('[50,99)')"}
    26. 

  26. Bind
    27. 

  27. Execute
    28. 

  28. Sync
    29. 

  29. ----
    30. 

  30. 

  31. until
    32. 

  32. ReadyForQuery
    33. 

  33. ----
    34. 

  34. ParseComplete
    35. 

  35. BindComplete
    36. 

  36. CommandComplete {"tag":"CREATE TABLE"}
    37. 

  37. ParseComplete
    38. 

  38. BindComplete
    39. 

  39. CommandComplete {"tag":"INSERT 0 20"}
    40. 

  40. ParseComplete
    41. 

  41. BindComplete
    42. 

  42. CommandComplete {"tag":"CREATE TABLE"}
    43. 

  43. ParseComplete
    44. 

  44. BindComplete
    45. 

  45. CommandComplete {"tag":"INSERT 0 7"}
    46. 

  46. ParseComplete
    47. 

  47. BindComplete
    48. 

  48. CommandComplete {"tag":"CREATE TABLE"}
    49. 

  49. ParseComplete
    50. 

  50. BindComplete
    51. 

  51. CommandComplete {"tag":"INSERT 0 20"}
    52. 

  52. ParseComplete
    53. 

  53. BindComplete
    54. 

  54. CommandComplete {"tag":"CREATE TABLE"}
    55. 

  55. ParseComplete
    56. 

  56. BindComplete
    57. 

  57. CommandComplete {"tag":"INSERT 0 7"}
    58. 

  58. ReadyForQuery {"status":"I"}
    59. 

  59. 

  60. send
    61. 

  61. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM int4range_values WHERE a IS NOT NULL) int4range_values(a), int4range_test_values WHERE a @> v GROUP BY a ORDER BY a;"}
    62. 

  62. Bind
    63. 

  63. Execute
    64. 

  64. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM int4range_values WHERE a IS NOT NULL ) int4range_values(a), int4range_test_values WHERE a <@ v GROUP BY a ORDER BY a;"}
    65. 

  65. Bind
    66. 

  66. Execute
    67. 

  67. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM int4range_values WHERE a IS NOT NULL ) int4range_values(a), int4range_test_values WHERE a && v GROUP BY a ORDER BY a;"}
    68. 

  68. Bind
    69. 

  69. Execute
    70. 

  70. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM int4range_values WHERE a IS NOT NULL ) int4range_values(a), int4range_test_values WHERE a << v GROUP BY a ORDER BY a;"}
    71. 

  71. Bind
    72. 

  72. Execute
    73. 

  73. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM int4range_values WHERE a IS NOT NULL ) int4range_values(a), int4range_test_values WHERE a >> v GROUP BY a ORDER BY a;"}
    74. 

  74. Bind
    75. 

  75. Execute
    76. 

  76. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM int4range_values WHERE a IS NOT NULL ) int4range_values(a), int4range_test_values WHERE a &< v GROUP BY a ORDER BY a;"}
    77. 

  77. Bind
    78. 

  78. Execute
    79. 

  79. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM int4range_values WHERE a IS NOT NULL ) int4range_values(a), int4range_test_values WHERE a &> v GROUP BY a ORDER BY a;"}
    80. 

  80. Bind
    81. 

  81. Execute
    82. 

  82. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM int4range_values WHERE a IS NOT NULL ) int4range_values(a), int4range_test_values WHERE a -|- v GROUP BY a ORDER BY a;"}
    83. 

  83. Bind
    84. 

  84. Execute
    85. 

  85. Parse {"query": "SELECT DISTINCT l.v, r.v, l.v < r.v, l.v <= r.v, l.v > r.v, l.v >= r.v, l.v = r.v, l.v <> r.v FROM int4range_test_values AS l, int4range_test_values AS r ORDER BY 1, 2;"}
    86. 

  86. Bind
    87. 

  87. Execute
    88. 

  88. Sync
    89. 

  89. ----
    90. 

  90. 

  91. until
    92. 

  92. ReadyForQuery
    93. 

  93. ----
    94. 

  94. ParseComplete
    95. 

  95. BindComplete
    96. 

  96. DataRow {"fields":["empty","{empty}"]}
    97. 

  97. DataRow {"fields":["(,1)","{empty,\"(,1)\",\"[-99,-50)\",\"[-1,1)\"}"]}
    98. 

  98. DataRow {"fields":["(,2)","{empty,\"(,1)\",\"[-99,-50)\",\"[-1,1)\"}"]}
    99. 

  99. DataRow {"fields":["(,)","{empty,\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"[0,)\",\"[50,99)\"}"]}
    100. 

  100. DataRow {"fields":["[-1,1)","{empty,\"[-1,1)\"}"]}
    101. 

  101. DataRow {"fields":["[-1,2)","{empty,\"[-1,1)\"}"]}
    102. 

  102. DataRow {"fields":["[0,1)","{empty}"]}
    103. 

  103. DataRow {"fields":["[0,2)","{empty}"]}
    104. 

  104. DataRow {"fields":["[1,)","{empty,\"[50,99)\"}"]}
    105. 

  105. DataRow {"fields":["[2,)","{empty,\"[50,99)\"}"]}
    106. 

  106. CommandComplete {"tag":"SELECT 10"}
    107. 

  107. ParseComplete
    108. 

  108. BindComplete
    109. 

  109. DataRow {"fields":["empty","{empty,\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"[0,)\",\"[50,99)\"}"]}
    110. 

  110. DataRow {"fields":["(,1)","{\"(,1)\",\"(,)\"}"]}
    111. 

  111. DataRow {"fields":["(,2)","{\"(,)\"}"]}
    112. 

  112. DataRow {"fields":["(,)","{\"(,)\"}"]}
    113. 

  113. DataRow {"fields":["[-1,1)","{\"(,1)\",\"(,)\",\"[-1,1)\"}"]}
    114. 

  114. DataRow {"fields":["[-1,2)","{\"(,)\"}"]}
    115. 

  115. DataRow {"fields":["[0,1)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"[0,)\"}"]}
    116. 

  116. DataRow {"fields":["[0,2)","{\"(,)\",\"[0,)\"}"]}
    117. 

  117. DataRow {"fields":["[1,)","{\"(,)\",\"[0,)\"}"]}
    118. 

  118. DataRow {"fields":["[2,)","{\"(,)\",\"[0,)\"}"]}
    119. 

  119. CommandComplete {"tag":"SELECT 10"}
    120. 

  120. ParseComplete
    121. 

  121. BindComplete
    122. 

  122. DataRow {"fields":["(,1)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"[0,)\"}"]}
    123. 

  123. DataRow {"fields":["(,2)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"[0,)\"}"]}
    124. 

  124. DataRow {"fields":["(,)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"[0,)\",\"[50,99)\"}"]}
    125. 

  125. DataRow {"fields":["[-1,1)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"[0,)\"}"]}
    126. 

  126. DataRow {"fields":["[-1,2)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"[0,)\"}"]}
    127. 

  127. DataRow {"fields":["[0,1)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"[0,)\"}"]}
    128. 

  128. DataRow {"fields":["[0,2)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"[0,)\"}"]}
    129. 

  129. DataRow {"fields":["[1,)","{\"(,)\",\"[0,)\",\"[50,99)\"}"]}
    130. 

  130. DataRow {"fields":["[2,)","{\"(,)\",\"[0,)\",\"[50,99)\"}"]}
    131. 

  131. CommandComplete {"tag":"SELECT 9"}
    132. 

  132. ParseComplete
    133. 

  133. BindComplete
    134. 

  134. DataRow {"fields":["(,1)","{\"[50,99)\"}"]}
    135. 

  135. DataRow {"fields":["(,2)","{\"[50,99)\"}"]}
    136. 

  136. DataRow {"fields":["[-1,1)","{\"[50,99)\"}"]}
    137. 

  137. DataRow {"fields":["[-1,2)","{\"[50,99)\"}"]}
    138. 

  138. DataRow {"fields":["[0,1)","{\"[50,99)\"}"]}
    139. 

  139. DataRow {"fields":["[0,2)","{\"[50,99)\"}"]}
    140. 

  140. CommandComplete {"tag":"SELECT 6"}
    141. 

  141. ParseComplete
    142. 

  142. BindComplete
    143. 

  143. DataRow {"fields":["[-1,1)","{\"[-99,-50)\"}"]}
    144. 

  144. DataRow {"fields":["[-1,2)","{\"[-99,-50)\"}"]}
    145. 

  145. DataRow {"fields":["[0,1)","{\"[-99,-50)\"}"]}
    146. 

  146. DataRow {"fields":["[0,2)","{\"[-99,-50)\"}"]}
    147. 

  147. DataRow {"fields":["[1,)","{\"(,1)\",\"[-99,-50)\",\"[-1,1)\"}"]}
    148. 

  148. DataRow {"fields":["[2,)","{\"(,1)\",\"[-99,-50)\",\"[-1,1)\"}"]}
    149. 

  149. CommandComplete {"tag":"SELECT 6"}
    150. 

  150. ParseComplete
    151. 

  151. BindComplete
    152. 

  152. DataRow {"fields":["(,1)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"[0,)\",\"[50,99)\"}"]}
    153. 

  153. DataRow {"fields":["(,2)","{\"(,)\",\"[0,)\",\"[50,99)\"}"]}
    154. 

  154. DataRow {"fields":["(,)","{\"(,)\",\"[0,)\"}"]}
    155. 

  155. DataRow {"fields":["[-1,1)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"[0,)\",\"[50,99)\"}"]}
    156. 

  156. DataRow {"fields":["[-1,2)","{\"(,)\",\"[0,)\",\"[50,99)\"}"]}
    157. 

  157. DataRow {"fields":["[0,1)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"[0,)\",\"[50,99)\"}"]}
    158. 

  158. DataRow {"fields":["[0,2)","{\"(,)\",\"[0,)\",\"[50,99)\"}"]}
    159. 

  159. DataRow {"fields":["[1,)","{\"(,)\",\"[0,)\"}"]}
    160. 

  160. DataRow {"fields":["[2,)","{\"(,)\",\"[0,)\"}"]}
    161. 

  161. CommandComplete {"tag":"SELECT 9"}
    162. 

  162. ParseComplete
    163. 

  163. BindComplete
    164. 

  164. DataRow {"fields":["(,1)","{\"(,1)\",\"(,)\"}"]}
    165. 

  165. DataRow {"fields":["(,2)","{\"(,1)\",\"(,)\"}"]}
    166. 

  166. DataRow {"fields":["(,)","{\"(,1)\",\"(,)\"}"]}
    167. 

  167. DataRow {"fields":["[-1,1)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\"}"]}
    168. 

  168. DataRow {"fields":["[-1,2)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\"}"]}
    169. 

  169. DataRow {"fields":["[0,1)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"[0,)\"}"]}
    170. 

  170. DataRow {"fields":["[0,2)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"[0,)\"}"]}
    171. 

  171. DataRow {"fields":["[1,)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"[0,)\"}"]}
    172. 

  172. DataRow {"fields":["[2,)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"[0,)\"}"]}
    173. 

  173. CommandComplete {"tag":"SELECT 9"}
    174. 

  174. ParseComplete
    175. 

  175. BindComplete
    176. 

  176. DataRow {"fields":["[1,)","{\"(,1)\",\"[-1,1)\"}"]}
    177. 

  177. CommandComplete {"tag":"SELECT 1"}
    178. 

  178. ParseComplete
    179. 

  179. BindComplete
    180. 

  180. DataRow {"fields":["empty","empty","f","t","f","t","t","f"]}
    181. 

  181. DataRow {"fields":["empty","(,1)","t","t","f","f","f","t"]}
    182. 

  182. DataRow {"fields":["empty","(,)","t","t","f","f","f","t"]}
    183. 

  183. DataRow {"fields":["empty","[-99,-50)","t","t","f","f","f","t"]}
    184. 

  184. DataRow {"fields":["empty","[-1,1)","t","t","f","f","f","t"]}
    185. 

  185. DataRow {"fields":["empty","[0,)","t","t","f","f","f","t"]}
    186. 

  186. DataRow {"fields":["empty","[50,99)","t","t","f","f","f","t"]}
    187. 

  187. DataRow {"fields":["(,1)","empty","f","f","t","t","f","t"]}
    188. 

  188. DataRow {"fields":["(,1)","(,1)","f","t","f","t","t","f"]}
    189. 

  189. DataRow {"fields":["(,1)","(,)","t","t","f","f","f","t"]}
    190. 

  190. DataRow {"fields":["(,1)","[-99,-50)","t","t","f","f","f","t"]}
    191. 

  191. DataRow {"fields":["(,1)","[-1,1)","t","t","f","f","f","t"]}
    192. 

  192. DataRow {"fields":["(,1)","[0,)","t","t","f","f","f","t"]}
    193. 

  193. DataRow {"fields":["(,1)","[50,99)","t","t","f","f","f","t"]}
    194. 

  194. DataRow {"fields":["(,)","empty","f","f","t","t","f","t"]}
    195. 

  195. DataRow {"fields":["(,)","(,1)","f","f","t","t","f","t"]}
    196. 

  196. DataRow {"fields":["(,)","(,)","f","t","f","t","t","f"]}
    197. 

  197. DataRow {"fields":["(,)","[-99,-50)","t","t","f","f","f","t"]}
    198. 

  198. DataRow {"fields":["(,)","[-1,1)","t","t","f","f","f","t"]}
    199. 

  199. DataRow {"fields":["(,)","[0,)","t","t","f","f","f","t"]}
    200. 

  200. DataRow {"fields":["(,)","[50,99)","t","t","f","f","f","t"]}
    201. 

  201. DataRow {"fields":["[-99,-50)","empty","f","f","t","t","f","t"]}
    202. 

  202. DataRow {"fields":["[-99,-50)","(,1)","f","f","t","t","f","t"]}
    203. 

  203. DataRow {"fields":["[-99,-50)","(,)","f","f","t","t","f","t"]}
    204. 

  204. DataRow {"fields":["[-99,-50)","[-99,-50)","f","t","f","t","t","f"]}
    205. 

  205. DataRow {"fields":["[-99,-50)","[-1,1)","t","t","f","f","f","t"]}
    206. 

  206. DataRow {"fields":["[-99,-50)","[0,)","t","t","f","f","f","t"]}
    207. 

  207. DataRow {"fields":["[-99,-50)","[50,99)","t","t","f","f","f","t"]}
    208. 

  208. DataRow {"fields":["[-1,1)","empty","f","f","t","t","f","t"]}
    209. 

  209. DataRow {"fields":["[-1,1)","(,1)","f","f","t","t","f","t"]}
    210. 

  210. DataRow {"fields":["[-1,1)","(,)","f","f","t","t","f","t"]}
    211. 

  211. DataRow {"fields":["[-1,1)","[-99,-50)","f","f","t","t","f","t"]}
    212. 

  212. DataRow {"fields":["[-1,1)","[-1,1)","f","t","f","t","t","f"]}
    213. 

  213. DataRow {"fields":["[-1,1)","[0,)","t","t","f","f","f","t"]}
    214. 

  214. DataRow {"fields":["[-1,1)","[50,99)","t","t","f","f","f","t"]}
    215. 

  215. DataRow {"fields":["[0,)","empty","f","f","t","t","f","t"]}
    216. 

  216. DataRow {"fields":["[0,)","(,1)","f","f","t","t","f","t"]}
    217. 

  217. DataRow {"fields":["[0,)","(,)","f","f","t","t","f","t"]}
    218. 

  218. DataRow {"fields":["[0,)","[-99,-50)","f","f","t","t","f","t"]}
    219. 

  219. DataRow {"fields":["[0,)","[-1,1)","f","f","t","t","f","t"]}
    220. 

  220. DataRow {"fields":["[0,)","[0,)","f","t","f","t","t","f"]}
    221. 

  221. DataRow {"fields":["[0,)","[50,99)","t","t","f","f","f","t"]}
    222. 

  222. DataRow {"fields":["[50,99)","empty","f","f","t","t","f","t"]}
    223. 

  223. DataRow {"fields":["[50,99)","(,1)","f","f","t","t","f","t"]}
    224. 

  224. DataRow {"fields":["[50,99)","(,)","f","f","t","t","f","t"]}
    225. 

  225. DataRow {"fields":["[50,99)","[-99,-50)","f","f","t","t","f","t"]}
    226. 

  226. DataRow {"fields":["[50,99)","[-1,1)","f","f","t","t","f","t"]}
    227. 

  227. DataRow {"fields":["[50,99)","[0,)","f","f","t","t","f","t"]}
    228. 

  228. DataRow {"fields":["[50,99)","[50,99)","f","t","f","t","t","f"]}
    229. 

  229. CommandComplete {"tag":"SELECT 49"}
    230. 

  230. ReadyForQuery {"status":"I"}
    231. 

  231. 

  232. send
    233. 

  233. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM numrange_values WHERE a IS NOT NULL ) numrange_values(a), numrange_test_values WHERE a @> v GROUP BY a ORDER BY a;"}
    234. 

  234. Bind
    235. 

  235. Execute
    236. 

  236. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM numrange_values WHERE a IS NOT NULL ) numrange_values(a), numrange_test_values WHERE a <@ v GROUP BY a ORDER BY a;"}
    237. 

  237. Bind
    238. 

  238. Execute
    239. 

  239. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM numrange_values WHERE a IS NOT NULL ) numrange_values(a), numrange_test_values WHERE a && v GROUP BY a ORDER BY a;"}
    240. 

  240. Bind
    241. 

  241. Execute
    242. 

  242. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM numrange_values WHERE a IS NOT NULL ) numrange_values(a), numrange_test_values WHERE a << v GROUP BY a ORDER BY a;"}
    243. 

  243. Bind
    244. 

  244. Execute
    245. 

  245. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM numrange_values WHERE a IS NOT NULL ) numrange_values(a), numrange_test_values WHERE a >> v GROUP BY a ORDER BY a;"}
    246. 

  246. Bind
    247. 

  247. Execute
    248. 

  248. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM numrange_values WHERE a IS NOT NULL ) numrange_values(a), numrange_test_values WHERE a &< v GROUP BY a ORDER BY a;"}
    249. 

  249. Bind
    250. 

  250. Execute
    251. 

  251. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM numrange_values WHERE a IS NOT NULL ) numrange_values(a), numrange_test_values WHERE a &> v GROUP BY a ORDER BY a;"}
    252. 

  252. Bind
    253. 

  253. Execute
    254. 

  254. Parse {"query": "SELECT a t, array_agg(v ORDER BY v) FROM ( SELECT DISTINCT a FROM numrange_values WHERE a IS NOT NULL ) numrange_values(a), numrange_test_values WHERE a -|- v GROUP BY a ORDER BY a;"}
    255. 

  255. Bind
    256. 

  256. Execute
    257. 

  257. Parse {"query": "SELECT DISTINCT l.v, r.v, l.v < r.v, l.v <= r.v, l.v > r.v, l.v >= r.v, l.v = r.v, l.v <> r.v FROM numrange_test_values AS l, numrange_test_values AS r ORDER BY 1, 2;"}
    258. 

  258. Bind
    259. 

  259. Execute
    260. 

  260. Sync
    261. 

  261. ----
    262. 

  262. 

  263. until
    264. 

  264. ReadyForQuery
    265. 

  265. ----
    266. 

  266. ParseComplete
    267. 

  267. BindComplete
    268. 

  268. DataRow {"fields":["empty","{empty}"]}
    269. 

  269. DataRow {"fields":["(,1)","{empty,\"(,1)\",\"[-99,-50)\",\"[-1,1)\"}"]}
    270. 

  270. DataRow {"fields":["(,1]","{empty,\"(,1)\",\"[-99,-50)\",\"[-1,1)\"}"]}
    271. 

  271. DataRow {"fields":["(,)","{empty,\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"(-1,)\",\"[50,99)\"}"]}
    272. 

  272. DataRow {"fields":["[-1,1)","{empty,\"[-1,1)\"}"]}
    273. 

  273. DataRow {"fields":["[-1,1]","{empty,\"[-1,1)\"}"]}
    274. 

  274. DataRow {"fields":["(-1,1)","{empty}"]}
    275. 

  275. DataRow {"fields":["(-1,1]","{empty}"]}
    276. 

  276. DataRow {"fields":["[0,0]","{empty}"]}
    277. 

  277. DataRow {"fields":["[1,)","{empty,\"[50,99)\"}"]}
    278. 

  278. DataRow {"fields":["(1,)","{empty,\"[50,99)\"}"]}
    279. 

  279. CommandComplete {"tag":"SELECT 11"}
    280. 

  280. ParseComplete
    281. 

  281. BindComplete
    282. 

  282. DataRow {"fields":["empty","{empty,\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"(-1,)\",\"[50,99)\"}"]}
    283. 

  283. DataRow {"fields":["(,1)","{\"(,1)\",\"(,)\"}"]}
    284. 

  284. DataRow {"fields":["(,1]","{\"(,)\"}"]}
    285. 

  285. DataRow {"fields":["(,)","{\"(,)\"}"]}
    286. 

  286. DataRow {"fields":["[-1,1)","{\"(,1)\",\"(,)\",\"[-1,1)\"}"]}
    287. 

  287. DataRow {"fields":["[-1,1]","{\"(,)\"}"]}
    288. 

  288. DataRow {"fields":["(-1,1)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"(-1,)\"}"]}
    289. 

  289. DataRow {"fields":["(-1,1]","{\"(,)\",\"(-1,)\"}"]}
    290. 

  290. DataRow {"fields":["[0,0]","{\"(,1)\",\"(,)\",\"[-1,1)\",\"(-1,)\"}"]}
    291. 

  291. DataRow {"fields":["[1,)","{\"(,)\",\"(-1,)\"}"]}
    292. 

  292. DataRow {"fields":["(1,)","{\"(,)\",\"(-1,)\"}"]}
    293. 

  293. CommandComplete {"tag":"SELECT 11"}
    294. 

  294. ParseComplete
    295. 

  295. BindComplete
    296. 

  296. DataRow {"fields":["(,1)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"(-1,)\"}"]}
    297. 

  297. DataRow {"fields":["(,1]","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"(-1,)\"}"]}
    298. 

  298. DataRow {"fields":["(,)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"(-1,)\",\"[50,99)\"}"]}
    299. 

  299. DataRow {"fields":["[-1,1)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"(-1,)\"}"]}
    300. 

  300. DataRow {"fields":["[-1,1]","{\"(,1)\",\"(,)\",\"[-1,1)\",\"(-1,)\"}"]}
    301. 

  301. DataRow {"fields":["(-1,1)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"(-1,)\"}"]}
    302. 

  302. DataRow {"fields":["(-1,1]","{\"(,1)\",\"(,)\",\"[-1,1)\",\"(-1,)\"}"]}
    303. 

  303. DataRow {"fields":["[0,0]","{\"(,1)\",\"(,)\",\"[-1,1)\",\"(-1,)\"}"]}
    304. 

  304. DataRow {"fields":["[1,)","{\"(,)\",\"(-1,)\",\"[50,99)\"}"]}
    305. 

  305. DataRow {"fields":["(1,)","{\"(,)\",\"(-1,)\",\"[50,99)\"}"]}
    306. 

  306. CommandComplete {"tag":"SELECT 10"}
    307. 

  307. ParseComplete
    308. 

  308. BindComplete
    309. 

  309. DataRow {"fields":["(,1)","{\"[50,99)\"}"]}
    310. 

  310. DataRow {"fields":["(,1]","{\"[50,99)\"}"]}
    311. 

  311. DataRow {"fields":["[-1,1)","{\"[50,99)\"}"]}
    312. 

  312. DataRow {"fields":["[-1,1]","{\"[50,99)\"}"]}
    313. 

  313. DataRow {"fields":["(-1,1)","{\"[50,99)\"}"]}
    314. 

  314. DataRow {"fields":["(-1,1]","{\"[50,99)\"}"]}
    315. 

  315. DataRow {"fields":["[0,0]","{\"[50,99)\"}"]}
    316. 

  316. CommandComplete {"tag":"SELECT 7"}
    317. 

  317. ParseComplete
    318. 

  318. BindComplete
    319. 

  319. DataRow {"fields":["[-1,1)","{\"[-99,-50)\"}"]}
    320. 

  320. DataRow {"fields":["[-1,1]","{\"[-99,-50)\"}"]}
    321. 

  321. DataRow {"fields":["(-1,1)","{\"[-99,-50)\"}"]}
    322. 

  322. DataRow {"fields":["(-1,1]","{\"[-99,-50)\"}"]}
    323. 

  323. DataRow {"fields":["[0,0]","{\"[-99,-50)\"}"]}
    324. 

  324. DataRow {"fields":["[1,)","{\"(,1)\",\"[-99,-50)\",\"[-1,1)\"}"]}
    325. 

  325. DataRow {"fields":["(1,)","{\"(,1)\",\"[-99,-50)\",\"[-1,1)\"}"]}
    326. 

  326. CommandComplete {"tag":"SELECT 7"}
    327. 

  327. ParseComplete
    328. 

  328. BindComplete
    329. 

  329. DataRow {"fields":["(,1)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"(-1,)\",\"[50,99)\"}"]}
    330. 

  330. DataRow {"fields":["(,1]","{\"(,)\",\"(-1,)\",\"[50,99)\"}"]}
    331. 

  331. DataRow {"fields":["(,)","{\"(,)\",\"(-1,)\"}"]}
    332. 

  332. DataRow {"fields":["[-1,1)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"(-1,)\",\"[50,99)\"}"]}
    333. 

  333. DataRow {"fields":["[-1,1]","{\"(,)\",\"(-1,)\",\"[50,99)\"}"]}
    334. 

  334. DataRow {"fields":["(-1,1)","{\"(,1)\",\"(,)\",\"[-1,1)\",\"(-1,)\",\"[50,99)\"}"]}
    335. 

  335. DataRow {"fields":["(-1,1]","{\"(,)\",\"(-1,)\",\"[50,99)\"}"]}
    336. 

  336. DataRow {"fields":["[0,0]","{\"(,1)\",\"(,)\",\"[-1,1)\",\"(-1,)\",\"[50,99)\"}"]}
    337. 

  337. DataRow {"fields":["[1,)","{\"(,)\",\"(-1,)\"}"]}
    338. 

  338. DataRow {"fields":["(1,)","{\"(,)\",\"(-1,)\"}"]}
    339. 

  339. CommandComplete {"tag":"SELECT 10"}
    340. 

  340. ParseComplete
    341. 

  341. BindComplete
    342. 

  342. DataRow {"fields":["(,1)","{\"(,1)\",\"(,)\"}"]}
    343. 

  343. DataRow {"fields":["(,1]","{\"(,1)\",\"(,)\"}"]}
    344. 

  344. DataRow {"fields":["(,)","{\"(,1)\",\"(,)\"}"]}
    345. 

  345. DataRow {"fields":["[-1,1)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\"}"]}
    346. 

  346. DataRow {"fields":["[-1,1]","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\"}"]}
    347. 

  347. DataRow {"fields":["(-1,1)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"(-1,)\"}"]}
    348. 

  348. DataRow {"fields":["(-1,1]","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"(-1,)\"}"]}
    349. 

  349. DataRow {"fields":["[0,0]","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"(-1,)\"}"]}
    350. 

  350. DataRow {"fields":["[1,)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"(-1,)\"}"]}
    351. 

  351. DataRow {"fields":["(1,)","{\"(,1)\",\"(,)\",\"[-99,-50)\",\"[-1,1)\",\"(-1,)\"}"]}
    352. 

  352. CommandComplete {"tag":"SELECT 10"}
    353. 

  353. ParseComplete
    354. 

  354. BindComplete
    355. 

  355. DataRow {"fields":["[1,)","{\"(,1)\",\"[-1,1)\"}"]}
    356. 

  356. CommandComplete {"tag":"SELECT 1"}
    357. 

  357. ParseComplete
    358. 

  358. BindComplete
    359. 

  359. DataRow {"fields":["empty","empty","f","t","f","t","t","f"]}
    360. 

  360. DataRow {"fields":["empty","(,1)","t","t","f","f","f","t"]}
    361. 

  361. DataRow {"fields":["empty","(,)","t","t","f","f","f","t"]}
    362. 

  362. DataRow {"fields":["empty","[-99,-50)","t","t","f","f","f","t"]}
    363. 

  363. DataRow {"fields":["empty","[-1,1)","t","t","f","f","f","t"]}
    364. 

  364. DataRow {"fields":["empty","(-1,)","t","t","f","f","f","t"]}
    365. 

  365. DataRow {"fields":["empty","[50,99)","t","t","f","f","f","t"]}
    366. 

  366. DataRow {"fields":["(,1)","empty","f","f","t","t","f","t"]}
    367. 

  367. DataRow {"fields":["(,1)","(,1)","f","t","f","t","t","f"]}
    368. 

  368. DataRow {"fields":["(,1)","(,)","t","t","f","f","f","t"]}
    369. 

  369. DataRow {"fields":["(,1)","[-99,-50)","t","t","f","f","f","t"]}
    370. 

  370. DataRow {"fields":["(,1)","[-1,1)","t","t","f","f","f","t"]}
    371. 

  371. DataRow {"fields":["(,1)","(-1,)","t","t","f","f","f","t"]}
    372. 

  372. DataRow {"fields":["(,1)","[50,99)","t","t","f","f","f","t"]}
    373. 

  373. DataRow {"fields":["(,)","empty","f","f","t","t","f","t"]}
    374. 

  374. DataRow {"fields":["(,)","(,1)","f","f","t","t","f","t"]}
    375. 

  375. DataRow {"fields":["(,)","(,)","f","t","f","t","t","f"]}
    376. 

  376. DataRow {"fields":["(,)","[-99,-50)","t","t","f","f","f","t"]}
    377. 

  377. DataRow {"fields":["(,)","[-1,1)","t","t","f","f","f","t"]}
    378. 

  378. DataRow {"fields":["(,)","(-1,)","t","t","f","f","f","t"]}
    379. 

  379. DataRow {"fields":["(,)","[50,99)","t","t","f","f","f","t"]}
    380. 

  380. DataRow {"fields":["[-99,-50)","empty","f","f","t","t","f","t"]}
    381. 

  381. DataRow {"fields":["[-99,-50)","(,1)","f","f","t","t","f","t"]}
    382. 

  382. DataRow {"fields":["[-99,-50)","(,)","f","f","t","t","f","t"]}
    383. 

  383. DataRow {"fields":["[-99,-50)","[-99,-50)","f","t","f","t","t","f"]}
    384. 

  384. DataRow {"fields":["[-99,-50)","[-1,1)","t","t","f","f","f","t"]}
    385. 

  385. DataRow {"fields":["[-99,-50)","(-1,)","t","t","f","f","f","t"]}
    386. 

  386. DataRow {"fields":["[-99,-50)","[50,99)","t","t","f","f","f","t"]}
    387. 

  387. DataRow {"fields":["[-1,1)","empty","f","f","t","t","f","t"]}
    388. 

  388. DataRow {"fields":["[-1,1)","(,1)","f","f","t","t","f","t"]}
    389. 

  389. DataRow {"fields":["[-1,1)","(,)","f","f","t","t","f","t"]}
    390. 

  390. DataRow {"fields":["[-1,1)","[-99,-50)","f","f","t","t","f","t"]}
    391. 

  391. DataRow {"fields":["[-1,1)","[-1,1)","f","t","f","t","t","f"]}
    392. 

  392. DataRow {"fields":["[-1,1)","(-1,)","t","t","f","f","f","t"]}
    393. 

  393. DataRow {"fields":["[-1,1)","[50,99)","t","t","f","f","f","t"]}
    394. 

  394. DataRow {"fields":["(-1,)","empty","f","f","t","t","f","t"]}
    395. 

  395. DataRow {"fields":["(-1,)","(,1)","f","f","t","t","f","t"]}
    396. 

  396. DataRow {"fields":["(-1,)","(,)","f","f","t","t","f","t"]}
    397. 

  397. DataRow {"fields":["(-1,)","[-99,-50)","f","f","t","t","f","t"]}
    398. 

  398. DataRow {"fields":["(-1,)","[-1,1)","f","f","t","t","f","t"]}
    399. 

  399. DataRow {"fields":["(-1,)","(-1,)","f","t","f","t","t","f"]}
    400. 

  400. DataRow {"fields":["(-1,)","[50,99)","t","t","f","f","f","t"]}
    401. 

  401. DataRow {"fields":["[50,99)","empty","f","f","t","t","f","t"]}
    402. 

  402. DataRow {"fields":["[50,99)","(,1)","f","f","t","t","f","t"]}
    403. 

  403. DataRow {"fields":["[50,99)","(,)","f","f","t","t","f","t"]}
    404. 

  404. DataRow {"fields":["[50,99)","[-99,-50)","f","f","t","t","f","t"]}
    405. 

  405. DataRow {"fields":["[50,99)","[-1,1)","f","f","t","t","f","t"]}
    406. 

  406. DataRow {"fields":["[50,99)","(-1,)","f","f","t","t","f","t"]}
    407. 

  407. DataRow {"fields":["[50,99)","[50,99)","f","t","f","t","t","f"]}
    408. 

  408. CommandComplete {"tag":"SELECT 49"}
    409. 

  409. ReadyForQuery {"status":"I"}
    410. 

  410. 

  411. # test range binary encodings
    412. 

  412. send
    413. 

  413. Parse {"query": "SELECT * FROM int4range_values ORDER BY a;"}
    414. 

  414. Bind {"result_formats": [1]}
    415. 

  415. Execute
    416. 

  416. Parse {"query": "SELECT * FROM numrange_values ORDER BY a;"}
    417. 

  417. Bind {"result_formats": [1]}
    418. 

  418. Execute
    419. 

  419. Sync
    420. 

  420. ----
    421. 

  421. 

  422. until
    423. 

  423. ReadyForQuery
    424. 

  424. ----
    425. 

  425. ParseComplete
    426. 

  426. BindComplete
    427. 

  427. DataRow {"fields":["\u0001"]}
    428. 

  428. DataRow {"fields":["\u0001"]}
    429. 

  429. DataRow {"fields":["\u0001"]}
    430. 

  430. DataRow {"fields":["\b\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0001"]}
    431. 

  431. DataRow {"fields":["\b\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0001"]}
    432. 

  432. DataRow {"fields":["\b\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0002"]}
    433. 

  433. DataRow {"fields":["\b\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0002"]}
    434. 

  434. DataRow {"fields":["\u0018"]}
    435. 

  435. DataRow {"fields":["\u0018"]}
    436. 

  436. DataRow {"fields":["\u0018"]}
    437. 

  437. DataRow {"fields":["\u0018"]}
    438. 

  438. DataRow {"fields":["[2, 0, 0, 0, 4, 255, 255, 255, 255, 0, 0, 0, 4, 0, 0, 0, 1]"]}
    439. 

  439. DataRow {"fields":["[2, 0, 0, 0, 4, 255, 255, 255, 255, 0, 0, 0, 4, 0, 0, 0, 2]"]}
    440. 

  440. DataRow {"fields":["\u0002\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0001"]}
    441. 

  441. DataRow {"fields":["\u0002\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0001"]}
    442. 

  442. DataRow {"fields":["\u0002\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0002"]}
    443. 

  443. DataRow {"fields":["\u0012\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0001"]}
    444. 

  444. DataRow {"fields":["\u0012\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0001"]}
    445. 

  445. DataRow {"fields":["\u0012\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0002"]}
    446. 

  446. DataRow {"fields":["\u0012\u0000\u0000\u0000\u0004\u0000\u0000\u0000\u0002"]}
    447. 

  447. CommandComplete {"tag":"SELECT 20"}
    448. 

  448. ParseComplete
    449. 

  449. BindComplete
    450. 

  450. DataRow {"fields":["\u0001"]}
    451. 

  451. DataRow {"fields":["\u0001"]}
    452. 

  452. DataRow {"fields":["\u0001"]}
    453. 

  453. DataRow {"fields":["\b\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001"]}
    454. 

  454. DataRow {"fields":["\b\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001"]}
    455. 

  455. DataRow {"fields":["\f\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001"]}
    456. 

  456. DataRow {"fields":["\f\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001"]}
    457. 

  457. DataRow {"fields":["\u0018"]}
    458. 

  458. DataRow {"fields":["\u0018"]}
    459. 

  459. DataRow {"fields":["\u0018"]}
    460. 

  460. DataRow {"fields":["\u0018"]}
    461. 

  461. DataRow {"fields":["\u0002\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000@\u0000\u0000\u0000\u0000\u0001\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001"]}
    462. 

  462. DataRow {"fields":["\u0006\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000@\u0000\u0000\u0000\u0000\u0001\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001"]}
    463. 

  463. DataRow {"fields":["\u0000\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000@\u0000\u0000\u0000\u0000\u0001\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001"]}
    464. 

  464. DataRow {"fields":["\u0004\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000@\u0000\u0000\u0000\u0000\u0001\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001"]}
    465. 

  465. DataRow {"fields":["\u0006\u0000\u0000\u0000\b\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000\b\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0000"]}
    466. 

  466. DataRow {"fields":["\u0012\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001"]}
    467. 

  467. DataRow {"fields":["\u0012\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001"]}
    468. 

  468. DataRow {"fields":["\u0010\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001"]}
    469. 

  469. DataRow {"fields":["\u0010\u0000\u0000\u0000\n\u0000\u0001\u0000\u0000\u0000\u0000\u0000\u0000\u0000\u0001"]}
    470. 

  470. CommandComplete {"tag":"SELECT 20"}
    471. 

  471. ReadyForQuery {"status":"I"}
    472.