Skip to content

Add proper support for BOOLEAN datatype for Oracle 19c, 21c and 26ai #3801

Description

@loiclefevre

Feature description

BOOLEAN datatype is supported starting from 23ai (version: 23.1.0+). With this support comes:

  • the datatype
  • some functions (TO_BOOLEAN())
  • some new filtering clause: WHERE FALSE, WHERE ACTIVE -- given active is of BOOLEAN datatype, WHERE A IS FALSE, etc.
  • automatic conversions: 't' => TRUE, 'f' => FALSE, 0 => FALSE, 1 => TRUE, etc.

When dealing with BOOLEAN, we should expect these to be possible/managed (including within the unit tests) given we are in 23.1.0+ version.

For pre-23ai versions, such as 19c or 21c, we should consider using the old way.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    Status
    Ready

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions