Message Title

Issue Type:	Bug
Affects Versions:	6.2.6
Assignee:	Unassigned
Components:	hibernate-core
Created:	13/Jul/2023 03:52 AM
Priority:	Major
Reporter:	Christian Beikov

Not sure if the problem is in Hibernate or Oracle 23c. Copying from a conversation with Loic:

A minimal reproducer is:

                              create table JsonHolder (
            id number(19,0) not null,
            aggregate json,
            primary key (id),
            check (aggregate.theInt.number() is not null)
        );
                              

producing ORA-00904: "AGGREGATE"."THEINT"."NUMBER": invalid identifier

The fact is that you're using Oracle SQL dot notation that requires an alias (ideal usage being DML).

So to make your code work, you'd need to use the JSON_VALUE() function instead such as:

                              create table JsonHolder (
            id number(19,0) not null,
            aggregate json,
            primary key (id),
            check (json_value(aggregate, '$.theInt.number()') is not null)
        );
                              

Add Comment

Get Jira notifications on your phone! Download the Jira Cloud app for Android or iOS

This message was sent by Atlassian Jira