postgrespro
diff --git a/‎expected/jsquery.out
Copy file name to clipboardExpand all lines: expected/jsquery.out
+31-1Lines changed: 31 additions & 1 deletion b/‎expected/jsquery.out
Copy file name to clipboardExpand all lines: expected/jsquery.out
+31-1Lines changed: 31 additions & 1 deletion
diff --git a/‎jsonb_gin_ops.c
Copy file name to clipboardExpand all lines: jsonb_gin_ops.c
+2-2Lines changed: 2 additions & 2 deletions b/‎jsonb_gin_ops.c
Copy file name to clipboardExpand all lines: jsonb_gin_ops.c
+2-2Lines changed: 2 additions & 2 deletions
diff --git a/‎jsquery.h
Copy file name to clipboardExpand all lines: jsquery.h
+4-2Lines changed: 4 additions & 2 deletions b/‎jsquery.h
Copy file name to clipboardExpand all lines: jsquery.h
+4-2Lines changed: 4 additions & 2 deletions
diff --git a/‎jsquery_constr.c
Copy file name to clipboardExpand all lines: jsquery_constr.c
+1Lines changed: 1 addition & 0 deletions b/‎jsquery_constr.c
Copy file name to clipboardExpand all lines: jsquery_constr.c
+1Lines changed: 1 addition & 0 deletions
diff --git a/‎jsquery_extract.c
Copy file name to clipboardExpand all lines: jsquery_extract.c
+6Lines changed: 6 additions & 0 deletions b/‎jsquery_extract.c
Copy file name to clipboardExpand all lines: jsquery_extract.c
+6Lines changed: 6 additions & 0 deletions
@@ -354,7 +354,7 @@ select 'a in (0,1,2)'::jsquery;
  "a" IN (0, 1, 2)
 (1 row)
 
-select 'a in (0,null, "null", xxx, "zzz", 2)'::jsquery;
+select 'a IN (0,null, "null", xxx, "zzz", 2)'::jsquery;
                   jsquery                  
 -------------------------------------------
  "a" IN (0, null, "null", "xxx", "zzz", 2)
@@ -786,3 +786,33 @@ select '[1,2,3]'::jsonb @@ '#($ = 2)';
  t
 (1 row)
 
+select '{"a": {"b": 3, "c": "hey"}, "x": [5,6]}'::jsonb @@ '%.b=3';
+ ?column? 
+----------
+ t
+(1 row)
+
+select '{"a": {"b": 3, "c": "hey"}, "x": [5,6]}'::jsonb @@ 'a.%=3';
+ ?column? 
+----------
+ t
+(1 row)
+
+select '{"a": {"b": 3, "c": "hey"}, "x": [5,6]}'::jsonb @@ '%.%="hey"';
+ ?column? 
+----------
+ t
+(1 row)
+
+select '{"a": {"b": 3, "c": "hey"}, "x": [5,6]}'::jsonb @@ '%="hey"';
+ ?column? 
+----------
+ f
+(1 row)
+
+select '{"a": {"b": 3, "c": "hey"}, "x": [5,6]}'::jsonb @@ '%=[5,6]';
+ ?column? 
+----------
+ t
+(1 row)
+
@@ -179,7 +179,7 @@ get_query_path_bloom(PathItem *pathItem, bool *lossy)
 			val = get_bloom_value(hash);
 			res |= val;
 		}
-		else if (pathItem->type == iAny)
+		else if (pathItem->type == iAny || pathItem->type == iAnyKey)
 		{
 			*lossy = true;
 		}
@@ -783,7 +783,7 @@ get_query_path_hash(PathItem *pathItem, uint32 *hash)
 	}
 	else
 	{
-		if (pathItem->type == iAny)
+		if (pathItem->type == iAny || pathItem->type == iAnyKey)
 		{
 			return false;
 		}
 
@@ -49,9 +49,10 @@ struct JsQueryItem {
 		jqiGreaterOrEqual = '}',
 		jqiContains = '@',
 		jqiContained = '^',
-		jqiOverlap = '%',
+		jqiOverlap = 'O',
 		jqiAny = '*',
 		jqiAnyArray = '#',
+		jqiAnyKey = '%',
 		jqiKey = 'K',
 		jqiCurrent = '$',
 		jqiIn = 'I'
@@ -108,7 +109,8 @@ typedef enum
 {
 	iAny = 1,
 	iAnyArray,
-	iKey
+	iKey,
+	iAnyKey
 } PathItemType;
 
 typedef struct PathItem PathItem;
 
@@ -118,6 +118,7 @@ copyJsQuery(StringInfo buf, char *jqBase, int32 jqPos)
 		case jqiAny:
 		case jqiCurrent:
 		case jqiAnyArray:
+		case jqiAnyKey:
 			break;
 		default:
 			elog(ERROR, "Unknown JsQueryItem type: %d", type);
 
@@ -109,6 +109,12 @@ recursiveExtract(char *jqBase, int32 jqPos,	bool indirect, PathItem *path)
 			pathItem->type = iAnyArray;
 			pathItem->parent = path;
 			return recursiveExtract(jqBase, nextPos, true, pathItem);
+		case jqiAnyKey:
+			Assert(nextPos != 0);
+			pathItem = (PathItem *)palloc(sizeof(PathItem));
+			pathItem->type = iAnyKey;
+			pathItem->parent = path;
+			return recursiveExtract(jqBase, nextPos, true, pathItem);
 		case jqiCurrent:
 			return recursiveExtract(jqBase, nextPos, indirect, path);
 		case jqiEqual:
Original file line number	Diff line number	Diff line change
`@@ -179,7 +179,7 @@ get_query_path_bloom(PathItem pathItem, bool lossy)`
`179`	`179`	`val = get_bloom_value(hash);`
`180`	`180`	`res \|= val;`
`181`	`181`	`}`
`182`		`- else if (pathItem->type == iAny)`
	`182`	`+ else if (pathItem->type == iAny \|\| pathItem->type == iAnyKey)`
`183`	`183`	`{`
`184`	`184`	`*lossy = true;`
`185`	`185`	`}`
`@@ -783,7 +783,7 @@ get_query_path_hash(PathItem pathItem, uint32 hash)`
`783`	`783`	`}`
`784`	`784`	`else`
`785`	`785`	`{`
`786`		`- if (pathItem->type == iAny)`
	`786`	`+ if (pathItem->type == iAny \|\| pathItem->type == iAnyKey)`
`787`	`787`	`{`
`788`	`788`	`return false;`
`789`	`789`	`}`