-- validtime modications article
-- proposed SQL3

-- Populate General

DROP TABLE LOT

CREATE TABLE LOT(
   LOT_ID_NUM INT,
   GNDR_CODE CHAR(1)
) AS VALIDTIME PERIOD(DATE)

VALIDTIME PERIOD '[1998-01-01 - 1998-03-23)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (101, 'c')

VALIDTIME PERIOD '[1998-03-23 - 9999-12-31)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (101, 's')

VALIDTIME PERIOD '[1998-02-17 - 1998-03-22)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (234, 'c')

VALIDTIME PERIOD '[1998-03-22 - 1998-04-01)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (234, 'c')

VALIDTIME PERIOD '[1998-04-01 - 1998-05-10)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (234, 'c')

VALIDTIME PERIOD '[1998-05-10 - 1998-06-29)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (234, 'c')

VALIDTIME PERIOD '[1998-06-29 - 1998-10-17)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (234, 'c')

VALIDTIME PERIOD '[1998-10-17 - 1998-10-19)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (234, 'c')

VALIDTIME PERIOD '[1998-10-19 - 9999-12-31)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (234, 'c')

VALIDTIME PERIOD '[1998-02-27 - 1998-03-12)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (799, 'c')

VALIDTIME PERIOD '[1998-03-12 - 1998-04-09)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (799, 'c')

VALIDTIME PERIOD '[1998-04-09 - 1998-05-21)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (799, 'c')

VALIDTIME PERIOD '[1998-05-21 - 1998-09-13)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (799, 'c')

VALIDTIME PERIOD '[1998-09-13 - 9999-12-31)'
INSERT INTO LOT(LOT_ID_NUM, GNDR_CODE)
VALUES (799, 'c')

SELECT * FROM LOT