sql: inverted index queries with non-top level scalars are incorrect

[jordanlewis]

Expected:

root@:26257/test> select '{"a": [3]}' @> '{"a": 3}';
+----------------------------+
| '{"a": [3]}' @> '{"a": 3}' |
+----------------------------+
|            true            |
+----------------------------+
(1 row)

Actual:

root@:26257/test> insert into j values('{"a": [3]}');
INSERT 1
root@:26257/test> select * from j where j @> '{"a": 3}'::jsonb;
+---+
| j |
+---+
+---+
(0 rows)

root@:26257/test> explain select * from j where j @> '{"a": 3}'::jsonb;
+-----------------+-------+-------------------------+
|      Tree       | Field |       Description       |
+-----------------+-------+-------------------------+
| render          |       |                         |
|  └── index-join |       |                         |
|       ├── scan  |       |                         |
|       │         | table | j@j_j_idx               |
|       │         | spans | /"a"/3-/"a"/3/PrefixEnd |
|       └── scan  |       |                         |
|                 | table | j@primary               |
+-----------------+-------+-------------------------+
(7 rows)

The problem is that the fix applied by #22503 was incomplete - it only applies to top level scalars.