8000 Add support for BOOLEAN, JSON, VECTOR data types introduced in Oracle Database 23ai · Issue #1284 · utPLSQL/utPLSQL · GitHub
[go: up one dir, main page]

Skip to content
Add support for BOOLEAN, JSON, VECTOR data types introduced in Oracle Database 23ai #1284
Open
@PhilippSalvisberg

Description

@PhilippSalvisberg

Is your feature request related to a problem? Please describe.

I'm also using Oracle Database 23ai and would like to assert the new data types provided in this version. For that the documented support of data types needs to be extend by the following data types:

Describe the solution you'd like

The supported data types should be extended as follows

Data Type Matchers Similar to
boolean be_not_null, be_null, be_false, be_true, equal PL/SQL boolean
json be_not_null, be_null, equal, be_empty, have_count JSON Data Structures in PL/SQL
vector be_not_null, be_null, equal, contain, be_empty, have_count nested table / varray

For the json data type the contain matcher might be sensible when the JSON is an array. Furthermore, I can imagine some additional matchers for vector. However, I'd start with a shorter list and handle new matchers in a dedicated issue when needed.

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

    0