Commitbf8884a

committed

teach gin extract to ignore length of array

1 parent94fe153 commitbf8884aCopy full SHA for bf8884a

File tree

+21

-1

lines changed

+21

-1

lines changed

Lines changed: 14 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -1974,6 +1974,20 @@ SELECT gin_debug_query_value_path('NOT #:(NOT x=1) AND NOT %:(NOT y=1) AND NOT *`
`1974`	`1974`
`1975`	`1975`	`(1 row)`
`1976`	`1976`
	`1977`	`+SELECT gin_debug_query_value_path('(@# > 0 and #: = 16)');`
	`1978`	`+ gin_debug_query_value_path`
	`1979`	`+----------------------------`
	`1980`	`+ NULL +`
	`1981`	`+`
	`1982`	`+(1 row)`
	`1983`	`+`
	`1984`	`+SELECT gin_debug_query_value_path('*.@# ($ = 4 or $ = 2)');`
	`1985`	`+ gin_debug_query_value_path`
	`1986`	`+----------------------------`
	`1987`	`+ NULL +`
	`1988`	`+`
	`1989`	`+(1 row)`
	`1990`	`+`
`1977`	`1991`	`---table and index`
`1978`	`1992`	`select count(*) from test_jsquery where (v->>'review_helpful_votes')::int4 > 0;`
`1979`	`1993`	`count`

Lines changed: 5 additions & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -50,7 +50,8 @@ recursiveExtract(JsQueryItem jsq, bool not, bool indirect, PathItem path)`
`50`	`50`
`51`	`51`	`check_stack_depth();`
`52`	`52`
`53`		`-switch(jsq->type) {`
	`53`	`+switch(jsq->type)`
	`54`	`+{`
`54`	`55`	`casejqiAnd:`
`55`	`56`	`casejqiOr:`
`56`	`57`	`type= ((jsq->type==jqiAnd)==not) ?eOr :eAnd;`
`@@ -240,9 +241,12 @@ recursiveExtract(JsQueryItem jsq, bool not, bool indirect, PathItem path)`
`240`	`241`	`result->indirect=indirect;`
`241`	`242`	`result->isType=jsqGetIsType(jsq);`
`242`	`243`	`returnresult;`
	`244`	`+casejqiLength:`
	`245`	`+returnNULL;`
`243`	`246`	`default:`
`244`	`247`	`elog(ERROR,"Wrong state: %d",jsq->type);`
`245`	`248`	`}`
	`249`	`+`
`246`	`250`	`returnNULL;`
`247`	`251`	`}`
`248`	`252`

Lines changed: 2 additions & 0 deletions

Original file line number	Diff line number	Diff line change
`@@ -371,6 +371,8 @@ SELECT gin_debug_query_value_path('x is object');`
`371`	`371`	`SELECT gin_debug_query_value_path('#:(x=1) AND %:(y=1) AND *:(z=1)');`
`372`	`372`	`SELECT gin_debug_query_value_path('#:(NOT x=1) AND %:(NOT y=1) AND *:(NOT z=1)');`
`373`	`373`	`SELECT gin_debug_query_value_path('NOT #:(NOT x=1) AND NOT %:(NOT y=1) AND NOT *:(NOT z=1)');`
	`374`	`+SELECT gin_debug_query_value_path('(@# > 0 and #: = 16)');`
	`375`	`+SELECT gin_debug_query_value_path('*.@# ($ = 4 or $ = 2)');`
`374`	`376`
`375`	`377`	`---table and index`
`376`	`378`

Comments

(0)