You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Siddarth sreeni (JIRA)" <ji...@apache.org> on 2018/04/06 07:37:00 UTC

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

    [ https://issues.apache.org/jira/browse/IGNITE-8125?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16428067#comment-16428067 ] 

Siddarth sreeni commented on IGNITE-8125:
-----------------------------------------

[~dmagda@apache.org] Can you look on to this. 

> Returns null on cache querying on column type PGOBJECT (JSONB) superset or @>
> -----------------------------------------------------------------------------
>
>                 Key: IGNITE-8125
>                 URL: https://issues.apache.org/jira/browse/IGNITE-8125
>             Project: Ignite
>          Issue Type: Bug
>          Components: cache, jdbc, sql
>    Affects Versions: 2.0, 2.1, 2.2, 2.3, 2.4
>            Reporter: Siddarth sreeni
>            Priority: Critical
>              Labels: documentation, fix-by-workaround
>
> 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' 



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)