If we assume that the employee table, created by the following SQL statement:
CREATE MULTISET TABLE employee( id INTEGER, name VARCHAR(50), dept INTEGER, tt PERIOD(TIMESTAMP(6)WITH TIME ZONE) NOT NULL AS TRANSACTIONTIME ) PRIMARY INDEX(id);
contains the following row, a real period:
INSERT INTO employee(102, 'John', 222);
The following SELECT statement:
SELECT * FROM employee WHERE END(tt) IS UNTIL_CLOSED;
returns:
id name dept -------------------- 102 John 222