[IGNITE-8125] Returns null on cache querying on column type PGOBJECT (JSONB) superset or @>

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 2.0, 2.1, 2.2, 2.3, 2.4
• Component/s: cache, jdbc, sql
• Labels: documentation fix-by-workaround
• Flags: Patch, Important
• Assignee: Unassigned
• Reporter: Siddarth sreeni
• Created: 03/Apr/18 10:25
• Updated: 06/Apr/18 21:58

Description

Apache Ignite briefly discusses the uses of SQL Cache query. It talks about the different transactional query it can be used to done. Apache Ignite is as said supported on PostGreSQL databases.
For example: In a table of column type JSONB. Querying for a specific object superset in a column returns Null.
Query: Select * from Table where column @> 'Object'