Add support for BOOLEAN, JSON, VECTOR data types introduced in Oracle Database 23ai #1284
Description
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.