Lets say I created a table with the following DDL, where I specify a starting date (2020-01-01) and end date(2022-12-31) of the partition.

I would like to know what happen if I insert a record where the date is not within the partition start/end date? eg, I insert a record with the date 1990-01-01, or 2050-12-12?

CREATE TABLE "ANALYTICS01" (

"ID" INTEGER NOT NULL,

"ORIGIN_STATE" VARCHAR(100) NOT NULL,

"ORIGIN_DATE" DATE NOT NULL

PRIMARY KEY (ID))

ORGANIZE BY COLUMN

PARTITION BY RANGE(ORIGIN_DATE)

    (STARTING ('2020-01-01') ENDING ('2022-12-31') EVERY 1 MONTH);

------------------------------
LIAK KUAN TAN
------------------------------

Lets say I created a table with the following DDL, where I specify a starting date (2020-01-01) and end date(2022-12-31) of the partition.

I would like to know what happen if I insert a record where the date is not within the partition start/end date? eg, I insert a record with the date 1990-01-01, or 2050-12-12?

CREATE TABLE "ANALYTICS01" (

"ID" INTEGER NOT NULL,

"ORIGIN_STATE" VARCHAR(100) NOT NULL,

"ORIGIN_DATE" DATE NOT NULL

PRIMARY KEY (ID))

ORGANIZE BY COLUMN

PARTITION BY RANGE(ORIGIN_DATE)

    (STARTING ('2020-01-01') ENDING ('2022-12-31') EVERY 1 MONTH);