-- Enables the planner's use of partitionwisejoin plans
RESET ENABLE_PARTITIONWISE;
RESET ENABLE_SEQSCAN;
RESET ENABLE_INDEXSCAN;
RESET ENABLE_INDEXONLYSCAN;
RESET ENABLE_BITMAPSCAN;
RESET ENABLE_TIDSCAN;
RESET ENABLE_SORT;
RESET ENABLE_MATERIAL;
RESET ENABLE_NESTLOOP;
RESET ENABLE_MERGEJOIN;
RESET ENABLE_HASHJOIN;
--CREATE RANGE PARTITION TABLE
CREATE SCHEMA fvt_obj_scan_define;
CREATE TABLE fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1(
C_CHAR_1 CHAR(1),
C_CHAR_2 CHAR(10),
C_CHAR_3 CHAR(102400),
C_VARCHAR_1 VARCHAR(1),
C_VARCHAR_2 VARCHAR(10),
C_VARCHAR_3 VARCHAR(1024),
C_INT INTEGER,
C_BIGINT BIGINT,
C_SMALLINT SMALLINT,
C_FLOAT FLOAT,
C_NUMERIC NUMERIC(10,5),
C_DP DOUBLE PRECISION,
C_DATE DATE,
C_TS_WITHOUT TIMESTAMP WITHOUT TIME ZONE,
C_TS_WITH TIMESTAMP WITH TIME ZONE )
PARTITION BY RANGE (C_CHAR_3,C_VARCHAR_3,C_INT,C_TS_WITHOUT)
(
PARTITION SCAN_PARTITION_000_1_1 VALUES LESS THAN ('D', 'D', 400, '2000-04-01'),
PARTITION SCAN_PARTITION_000_1_2 VALUES LESS THAN ('G', 'G', 700, '2000-07-01'),
PARTITION SCAN_PARTITION_000_1_3 VALUES LESS THAN ('K', 'K',1000, '2000-10-01')
);
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('A','ABC','ABCDEFG','A','ABC','ABCDEFG',111,111111,11,1.1,1.11,1.111,'2000-01-01','2000-01-01 01:01:01','2000-01-01 01:01:01+01');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('B','BCD','BCDEFGH','B','BCD','BCDEFGH',222,222222,22,2.2,2.22,2.222,'2000-02-02','2000-02-02 02:02:02','2000-02-02 02:02:02+02');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('C','CDE','CDEFGHI','C','CDE','CDEFGHI',333,333333,33,3.3,3.33,3.333,'2000-03-03','2000-03-03 03:03:03','2000-03-03 03:03:03+03');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('D','DEF','DEFGHIJ','D','DEF','DEFGHIJ',444,444444,44,4.4,4.44,4.444,'2000-04-04','2000-04-04 04:04:04','2000-04-04 04:04:04+04');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('E','EFG','EFGHIJK','E','EFG','EFGHIJK',555,555555,55,5.5,5.55,5.555,'2000-05-05','2000-05-05 05:05:05','2000-05-05 05:05:05+05');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('F','FGH','FGHIJKL','F','FGH','FGHIJKL',666,666666,66,6.6,6.66,6.666,'2000-06-06','2000-06-06 06:06:06','2000-06-06 06:06:06+06');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('G','GHI','GHIJKLM','G','GHI','GHIJKLM',699,777777,77,7.7,7.77,7.777,'2000-07-07','2000-07-07 07:07:07','2000-07-07 07:07:07+07');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('G','GHI','GHIJKLM','G','GHI','GHIJKLM',777,777777,77,7.7,7.77,7.777,'2000-07-07','2000-07-07 07:07:07','2000-07-07 07:07:07+07');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('H','HIJ','HIJKLMN','H','HIJ','HIJKLMN',888,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('I','IJK','IJKLMNO','I','IJK','IJKLMNO',999,999999,99,9.9,9.99,9.999,'2000-09-09','2000-09-09 09:09:09','2000-09-09 09:09:09+09');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('H','HIJ','HIJKLMN','H','HIJ','HIJKLMN',300,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('H','HIJ','HIJKLMN','H','HIJ','HIJKLMN',600,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('H','HIJ','D','H','HIJ','D',200,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('H','HIJ','D','H','HIJ','D',400,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('H','HIJ','G','H','HIJ','G',200,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('H','HIJ','G','H','HIJ','G',500,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('H','HIJ','G','H','HIJ','G',700,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 VALUES('H','HIJ','K','H','HIJ','G',700,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
CREATE INDEX SCAN_PARTITION_TABLE_INDEX_000_1 ON fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1(C_CHAR_3,C_VARCHAR_3,C_INT,C_TS_WITHOUT) LOCAL(PARTITION SCAN_PARTITION_000_1_1, PARTITION SCAN_PARTITION_000_1_2, PARTITION SCAN_PARTITION_000_1_3);
CREATE VIEW fvt_obj_scan_define.SCAN_PARTITION_TABLE_VIEW_000_1 AS SELECT * FROM fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1;
--CREATE RANGE PARTITION TABLE
CREATE TABLE fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2(
C_CHAR_1 CHAR(1),
C_CHAR_2 CHAR(10),
C_CHAR_3 CHAR(102400),
C_VARCHAR_1 VARCHAR(1),
C_VARCHAR_2 VARCHAR(10),
C_VARCHAR_3 VARCHAR(1024),
C_INT INTEGER,
C_BIGINT BIGINT,
C_SMALLINT SMALLINT,
C_FLOAT FLOAT,
C_NUMERIC NUMERIC(10,5),
C_DP DOUBLE PRECISION,
C_DATE DATE,
C_TS_WITHOUT TIMESTAMP WITHOUT TIME ZONE,
C_TS_WITH TIMESTAMP WITH TIME ZONE )
PARTITION BY RANGE (C_TS_WITHOUT,C_NUMERIC)
(
PARTITION SCAN_PARTITION_000_2_1 VALUES LESS THAN ('2000-05-01', 5),
PARTITION SCAN_PARTITION_000_2_3 VALUES LESS THAN ('2000-10-01', 10)
);
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2 VALUES('A','ABC','ABCDEFG','A','ABC','ABCDEFG',111,111111,11,1.1,1.11,1.111,'2000-01-01','2000-01-01 01:01:01','2000-01-01 01:01:01+01');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2 VALUES('B','BCD','BCDEFGH','B','BCD','BCDEFGH',222,222222,22,2.2,2.22,2.222,'2000-02-02','2000-02-02 02:02:02','2000-02-02 02:02:02+02');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2 VALUES('C','CDE','CDEFGHI','C','CDE','CDEFGHI',333,333333,33,3.3,3.33,3.333,'2000-03-03','2000-03-03 03:03:03','2000-03-03 03:03:03+03');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2 VALUES('D','DEF','DEFGHIJ','D','DEF','DEFGHIJ',444,444444,44,4.4,4.44,4.444,'2000-04-04','2000-04-04 04:04:04','2000-04-04 04:04:04+04');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2 VALUES('E','EFG','EFGHIJK','E','EFG','EFGHIJK',555,555555,55,4.5,4.55,5.555,'2000-05-01','2000-05-01 ','2000-05-05 05:05:05+05');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2 VALUES('E','EFG','EFGHIJK','E','EFG','EFGHIJK',555,555555,55,5.5,5.55,5.555,'2000-05-01','2000-05-01 ','2000-05-05 05:05:05+05');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2 VALUES('F','FGH','FGHIJKL','F','FGH','FGHIJKL',666,666666,66,6.6,6.66,6.666,'2000-06-06','2000-06-06 06:06:06','2000-06-06 06:06:06+06');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2 VALUES('G','GHI','GHIJKLM','G','GHI','GHIJKLM',777,777777,77,7.7,7.77,7.777,'2000-07-07','2000-07-07 07:07:07','2000-07-07 07:07:07+07');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2 VALUES('H','HIJ','HIJKLMN','H','HIJ','HIJKLMN',888,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2 VALUES('I','IJK','IJKLMNO','I','IJK','IJKLMNO',999,999999,99,9.9,9.99,9.999,'2000-09-09','2000-09-09 09:09:09','2000-09-09 09:09:09+09');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2 VALUES('H','HIJ','HIJKLMN','H','HIJ','HIJKLMN',888,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2 VALUES('I','IJK','IJKLMNO','I','IJK','IJKLMNO',999,999999,99,9.9,9.99,9.999,'2000-09-09','2000-09-09 09:09:09','2000-09-09 09:09:09+09');
CREATE INDEX SCAN_PARTITION_TABLE_INDEX_000_2 ON fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2(C_CHAR_3,C_VARCHAR_3,C_INT,C_TS_WITHOUT) LOCAL(PARTITION SCAN_PARTITION_000_2_1, PARTITION SCAN_PARTITION_000_2_3);
CREATE VIEW fvt_obj_scan_define.SCAN_PARTITION_TABLE_VIEW_000_2 AS SELECT * FROM fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_2;
--CREATE RANGE PARTITION TABLE
CREATE TABLE fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3(
C_CHAR_1 CHAR(1),
C_CHAR_2 CHAR(10),
C_CHAR_3 CHAR(102400),
C_VARCHAR_1 VARCHAR(1),
C_VARCHAR_2 VARCHAR(10),
C_VARCHAR_3 VARCHAR(1024),
C_INT INTEGER,
C_BIGINT BIGINT,
C_SMALLINT SMALLINT,
C_FLOAT FLOAT,
C_NUMERIC NUMERIC(10,5),
C_DP DOUBLE PRECISION,
C_DATE DATE,
C_TS_WITHOUT TIMESTAMP WITHOUT TIME ZONE,
C_TS_WITH TIMESTAMP WITH TIME ZONE )
PARTITION BY RANGE (C_INT)
(
PARTITION SCAN_PARTITION_000_3_1 VALUES LESS THAN (500),
PARTITION SCAN_PARTITION_000_3_2 VALUES LESS THAN (1000),
PARTITION SCAN_PARTITION_000_3_3 VALUES LESS THAN (1100),
PARTITION SCAN_PARTITION_000_3_4 VALUES LESS THAN (1200),
PARTITION SCAN_PARTITION_000_3_5 VALUES LESS THAN (1300),
PARTITION SCAN_PARTITION_000_3_6 VALUES LESS THAN (1400),
PARTITION SCAN_PARTITION_000_3_7 VALUES LESS THAN (1500),
PARTITION SCAN_PARTITION_000_3_8 VALUES LESS THAN (1600),
PARTITION SCAN_PARTITION_000_3_9 VALUES LESS THAN (1700)
);
CREATE INDEX SCAN_PARTITION_TABLE_INDEX_000_3 ON fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3(C_CHAR_3,C_VARCHAR_3,C_INT,C_TS_WITHOUT) LOCAL;
CREATE VIEW fvt_obj_scan_define.SCAN_PARTITION_TABLE_VIEW_000_3 AS SELECT * FROM fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3;
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('A','ABC','ABCDEFG','A','ABC','ABCDEFG',111,111111,11,1.1,1.11,1.111,'2000-01-01','2000-01-01 01:01:01','2000-01-01 01:01:01+01');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('B','BCD','BCDEFGH','B','BCD','BCDEFGH',222,222222,22,2.2,2.22,2.222,'2000-02-02','2000-02-02 02:02:02','2000-02-02 02:02:02+02');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('C','CDE','CDEFGHI','C','CDE','CDEFGHI',333,333333,33,3.3,3.33,3.333,'2000-03-03','2000-03-03 03:03:03','2000-03-03 03:03:03+03');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('D','DEF','DEFGHIJ','D','DEF','DEFGHIJ',444,444444,44,4.4,4.44,4.444,'2000-04-04','2000-04-04 04:04:04','2000-04-04 04:04:04+04');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('E','EFG','EFGHIJK','E','EFG','EFGHIJK',555,555555,55,5.5,5.55,5.555,'2000-05-05','2000-05-05 05:05:05','2000-05-05 05:05:05+05');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('F','FGH','FGHIJKL','F','FGH','FGHIJKL',666,666666,66,6.6,6.66,6.666,'2000-06-06','2000-06-06 06:06:06','2000-06-06 06:06:06+06');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('G','GHI','GHIJKLM','G','GHI','GHIJKLM',777,777777,77,7.7,7.77,7.777,'2000-07-07','2000-07-07 07:07:07','2000-07-07 07:07:07+07');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('H','HIJ','HIJKLMN','H','HIJ','HIJKLMN',888,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('I','IJK','IJKLMNO','I','IJK','IJKLMNO',999,999999,99,9.9,9.99,9.999,'2000-09-09','2000-09-09 09:09:09','2000-09-09 09:09:09+09');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('H','HIJ','HIJKLMN','H','HIJ','HIJKLMN',888,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('I','IJK','IJKLMNO','I','IJK','IJKLMNO',999,999999,99,9.9,9.99,9.999,'2000-09-09','2000-09-09 09:09:09','2000-09-09 09:09:09+09');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('I','IJK','IJKLMNO','I','IJK','IJKLMNO',1100,999999,99,9.9,9.99,9.999,'2000-09-09','2000-09-09 09:09:09','2000-09-09 09:09:09+09');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 VALUES('I','IJK','IJKLMNO','I','IJK','IJKLMNO',1600,999999,99,9.9,9.99,9.999,'2000-09-09','2000-09-09 09:09:09','2000-09-09 09:09:09+09');
--CREATE RANGE PARTITION TABLE
CREATE TABLE fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4(
C_CHAR_1 CHAR(1),
C_CHAR_2 CHAR(10),
C_CHAR_3 CHAR(102400),
C_VARCHAR_1 VARCHAR(1),
C_VARCHAR_2 VARCHAR(10),
C_VARCHAR_3 VARCHAR(1024),
C_INT INTEGER,
C_BIGINT BIGINT,
C_SMALLINT SMALLINT,
C_FLOAT FLOAT,
C_NUMERIC NUMERIC(10,5),
C_DP DOUBLE PRECISION,
C_DATE DATE,
C_TS_WITHOUT TIMESTAMP WITHOUT TIME ZONE,
C_TS_WITH TIMESTAMP WITH TIME ZONE )
PARTITION BY RANGE (C_TS_WITHOUT)
(
PARTITION SCAN_PARTITION_000_4_1 VALUES LESS THAN ('2000-04-01'),
PARTITION SCAN_PARTITION_000_4_2 VALUES LESS THAN ('2000-07-01'),
PARTITION SCAN_PARTITION_000_4_3 VALUES LESS THAN ('2000-10-01'),
PARTITION SCAN_PARTITION_000_4_4 VALUES LESS THAN ('2000-12-31')
);
CREATE INDEX SELECT_PARTITION_TABLE_INDEX_000_4 ON fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4(C_CHAR_3,C_VARCHAR_3,C_INT) LOCAL;
CREATE VIEW fvt_obj_scan_define.SCAN_PARTITION_TABLE_VIEW_000_4 AS SELECT * FROM fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4;
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('A','ABC','ABCDEFG','A','ABC','ABCDEFG',111,111111,11,1.1,1.11,1.111,'2000-01-01','2000-01-01 01:01:01','2000-01-01 01:01:01+01');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('B','BCD','BCDEFGH','B','BCD','BCDEFGH',222,222222,22,2.2,2.22,2.222,'2000-02-02','2000-02-02 02:02:02','2000-02-02 02:02:02+02');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('C','CDE','CDEFGHI','C','CDE','CDEFGHI',333,333333,33,3.3,3.33,3.333,'2000-03-03','2000-03-03 03:03:03','2000-03-03 03:03:03+03');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('D','DEF','DEFGHIJ','D','DEF','DEFGHIJ',444,444444,44,4.4,4.44,4.444,'2000-04-04','2000-04-04 04:04:04','2000-04-04 04:04:04+04');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('E','EFG','EFGHIJK','E','EFG','EFGHIJK',555,555555,55,5.5,5.55,5.555,'2000-05-05','2000-05-05 05:05:05','2000-05-05 05:05:05+05');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('F','FGH','FGHIJKL','F','FGH','FGHIJKL',666,666666,66,6.6,6.66,6.666,'2000-06-06','2000-06-06 06:06:06','2000-06-06 06:06:06+06');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('G','GHI','GHIJKLM','G','GHI','GHIJKLM',777,777777,77,7.7,7.77,7.777,'2000-07-07','2000-07-07 07:07:07','2000-07-07 07:07:07+07');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('H','HIJ','HIJKLMN','H','HIJ','HIJKLMN',888,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('I','IJK','IJKLMNO','I','IJK','IJKLMNO',999,999999,99,9.9,9.99,9.999,'2000-09-09','2000-09-09 09:09:09','2000-09-09 09:09:09+09');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('H','HIJ','HIJKLMN','H','HIJ','HIJKLMN',888,888888,88,8.8,8.88,8.888,'2000-08-08','2000-08-08 08:08:08','2000-08-08 08:08:08+08');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('I','IJK','IJKLMNO','I','IJK','IJKLMNO',999,999999,99,9.9,9.99,9.999,'2000-09-09','2000-09-09 09:09:09','2000-09-09 09:09:09+09');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('J','IJK','IJKLMNO','J','JKL','JKLMNOP',1111,111111,111,11.1,11.11,11.111,'2000-09-09','2000-10-02 09:09:09','2000-10-02 09:09:09+09');
INSERT INTO fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_4 VALUES('K','JKL','IJKLMNO','J','JKL','JKLMNOP',1111,111111,111,11.1,11.11,11.111,'2000-09-09','2000-10-06 09:09:09','2000-10-06 09:09:09+09');
SELECT A.C_INT, A.C_TS_WITHOUT, B.C_INT, B.C_TS_WITHOUT, C.C_INT, C.C_TS_WITHOUT, D.C_INT, D.C_TS_WITHOUT FROM fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 A, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 B, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 C, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 D WHERE A.C_INT = B.C_INT AND B.C_INT = C.C_INT AND C.C_INT = D.C_INT AND A.C_TS_WITHOUT < '2000-06-01' ORDER BY 1,2,3,4,5,6,7,8;
SELECT A.C_INT, A.C_TS_WITHOUT, B.C_INT, B.C_TS_WITHOUT, C.C_INT, C.C_TS_WITHOUT, D.C_INT, D.C_TS_WITHOUT FROM fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 A, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 B, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 C, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 D WHERE A.C_INT = B.C_INT AND B.C_INT = C.C_INT AND C.C_INT = D.C_INT AND A.C_TS_WITHOUT < '2000-06-01' ORDER BY 1,2,3,4,5,6,7,8;
SELECT A.C_INT, A.C_TS_WITHOUT, B.C_INT, B.C_TS_WITHOUT, C.C_INT, C.C_TS_WITHOUT, D.C_INT, D.C_TS_WITHOUT FROM fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 A, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 B, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 C, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 D WHERE A.C_INT = B.C_INT AND B.C_INT = C.C_INT AND C.C_INT = D.C_INT AND A.C_TS_WITHOUT < '2000-06-01' ORDER BY A.C_INT, A.C_TS_WITHOUT, B.C_INT, B.C_TS_WITHOUT, C.C_INT, C.C_TS_WITHOUT, D.C_INT, D.C_TS_WITHOUT;
SELECT A.C_INT, A.C_TS_WITHOUT, B.C_INT, B.C_TS_WITHOUT, C.C_INT, C.C_TS_WITHOUT, D.C_INT, D.C_TS_WITHOUT FROM fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 A, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 B, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 C, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 D WHERE A.C_INT = B.C_INT AND B.C_INT = C.C_INT AND C.C_INT = D.C_INT AND A.C_TS_WITHOUT < '2000-06-01' ORDER BY 1;
SELECT A.C_INT, A.C_TS_WITHOUT, B.C_INT, B.C_TS_WITHOUT, C.C_INT, C.C_TS_WITHOUT, D.C_INT, D.C_TS_WITHOUT FROM fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 A, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 B, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 C, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 D WHERE A.C_INT = B.C_INT AND B.C_INT = C.C_INT AND C.C_INT = D.C_INT ORDER BY 1;
SELECT A.C_INT, A.C_TS_WITHOUT, B.C_INT, B.C_TS_WITHOUT, C.C_INT, C.C_TS_WITHOUT, D.C_INT, D.C_TS_WITHOUT FROM fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 A, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 B, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 C, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 D WHERE A.C_INT = B.C_INT AND B.C_INT = C.C_INT ORDER BY 1, 7;
SELECT A.C_INT, A.C_TS_WITHOUT, B.C_INT, B.C_TS_WITHOUT, C.C_INT, C.C_TS_WITHOUT, D.C_INT, D.C_TS_WITHOUT FROM fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 A, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 B, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_1 C, fvt_obj_scan_define.SCAN_PARTITION_TABLE_000_3 D WHERE C.C_INT = D.C_INT ORDER BY 1, 3, 5;
DROP SCHEMA fvt_obj_scan_define CASCADE;