Commit1508781

Nikita Glukhov

committed

Fix '#' queries on empty arrays

1 parent2539974 commit1508781Copy full SHA for 1508781

File tree

-3

lines changed

-3

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -2682,7 +2682,7 @@ select count(*) from test_jsquery where v @@ '$'::jsquery;`
`2682`	`2682`	`select count(*) from test_jsquery where v @@ 'similar_product_ids.#'::jsquery;`
`2683`	`2683`	`count`
`2684`	`2684`	`-------`
`2685`		`-1001`
	`2685`	`+ 950`
`2686`	`2686`	`(1 row)`
`2687`	`2687`
`2688`	`2688`	`select count(*) from test_jsquery where v @@ '$ . ? (review_votes > 10) . review_rating < 7'::jsquery;`
`@@ -2960,7 +2960,7 @@ select count(*) from test_jsquery where v @@ '$'::jsquery;`
`2960`	`2960`	`select count(*) from test_jsquery where v @@ 'similar_product_ids.#'::jsquery;`
`2961`	`2961`	`count`
`2962`	`2962`	`-------`
`2963`		`-1001`
	`2963`	`+ 950`
`2964`	`2964`	`(1 row)`
`2965`	`2965`
`2966`	`2966`	`select count(*) from test_jsquery where v @@ '$ . ? (review_votes > 10) . review_rating < 7'::jsquery;`

Lines changed: 3 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -604,7 +604,9 @@ recursiveExecute(JsQueryItem jsq, JsonbValue jb, JsQueryItem *jsqLeftArg,`
`604`	`604`
`605`	`605`	`if (hasNext== false)`
`606`	`606`	`{`
`607`		`-res= true;`
	`607`	`+if (jsq->type==jqiAllArray\|\|`
	`608`	`+JsonContainerSize(jb->val.binary.data)>0)`
	`609`	`+res= true;`
`608`	`610`
`609`	`611`	`while(ra&& (r=JsonbIteratorNext(&it,&v, true))!=WJB_DONE)`
`610`	`612`	`if (r==WJB_ELEM)`

Comments

(0)