Skip to content

[Bug]: Tables with virtual columns do not match sqlcheck detection #2028

@tonghan-gsh

Description

@tonghan-gsh

ODC version

ODC 4.2.4

OB version

OBOracle430

What happened?

I created a partitioned table with virtual columns, but no sqlcheck detection was found.
image

What did you expect to happen?

image

How can we reproduce it (as minimally and precisely as possible)?

CREATE TABLE ORACLE_RANGE_VARCHAR_2(
    id INT,
    char_column VARCHAR(64),
    char_column_number GENERATED ALWAYS AS (TO_NUMBER(char_column)) VIRTUAL
) PARTITION BY RANGE (char_column_number) (
    PARTITION p20240101 VALUES LESS THAN (20240101),
    PARTITION p20240201 VALUES LESS THAN (20240201),
    PARTITION p20240301 VALUES LESS THAN (20240301),
    PARTITION p20240401 VALUES LESS THAN (20240401)
);

Anything else we need to know?

No response

Cloud

No response

Metadata

Metadata

Assignees

Type

No type
No fields configured for issues without a type.

Projects

Status

Closed

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions