--- title: 改写导致 where subquery pullup 后 part hint 丢失的正确性问题-OceanBase数据库使用指南 description: 了解OceanBase数据库在实际应用中关于改写导致 where subquery pullup 后 part hint 丢失的正确性问题相关的常见问题和使用技巧，帮助您快速解决改写导致 where subquery pullup 后 part hint 丢失的正确性问题的难题。 --- 切换语言 - 简体中文 - English 划线反馈 # 改写导致 where subquery pullup 后 part hint 丢失的正确性问题 更新时间：2026-05-28 02:06 适用版本： V2.2.x 内容类型：Troubleshoot ## 问题现象 `Where subquery pullup` 改写后 `part hint` 丢失，导致 SQL 结果不正确。 ```shell -- 触发示例 SELECT E.PK FROM outer_3 E WHERE E.COL_NUMBER_KEY <= ANY(SELECT E.COL_NUMBER_KEY FROM outer_8 E,outer_11 partition(p1) P, outer_11 partition(p1) d WHERE E.PK(+) = P.PK AND P.PK(+) = D.PK); ============================================================ |ID|OPERATOR |NAME |EST. ROWS|COST| ------------------------------------------------------------ |0 |NESTED-LOOP SEMI JOIN | |4 |201 | |1 | PX COORDINATOR | |10 |41 | |2 | EXCHANGE OUT DISTR |:EX10000|10 |38 | |3 | PX PARTITION ITERATOR | |10 |38 | |4 | TABLE SCAN |E |10 |38 | |5 | MATERIAL | |8 |120 | |6 | PX COORDINATOR | |8 |103 | |7 | EXCHANGE OUT DISTR |:EX20001|8 |99 | |8 | MERGE JOIN | |8 |99 | |9 | EXCHANGE IN DISTR | |36 |50 | |10| EXCHANGE OUT DISTR (PKEY)|:EX20000|36 |42 | |11| TABLE SCAN |D |36 |42 | |12| PX PARTITION ITERATOR | |8 |38 | |13| TABLE SCAN |E |8 |38 | ============================================================ DROP TABLE outer_3; CREATE TABLE outer_3 ( col_binary_float binary_float, col_date date, col_binary_double_key binary_double, pk int not null, col_ts_with_local_time_zone timestamp with local time zone, col_number number, col_ts_key timestamp, col_nchar_20_key nchar(20), col_nvarchar2_20 nvarchar2(20), col_char_20_key char(20), col_ts timestamp, col_varchar2_20_key varchar2(20), col_ts_with_time_zone timestamp with time zone, col_nvarchar2_20_key nvarchar2(20), col_binary_double binary_double, col_number_key number, col_ts_with_local_time_zone_ke timestamp with local time zone, col_char_20 char(20), col_binary_float_key binary_float, col_nchar_20 nchar(20), col_varchar2_20 varchar2(20), col_date_key date, col_ts_with_time_zone_key timestamp with time zone, /*Indices*/ primary key (pk) ) PARTITION BY hash(pk) (partition p3,partition p4) ; INSERT ALL INTO outer_3 VALUES (NULL, to_date('2008-03-20 22:31:35','yyyy-mm-dd hh24:mi:ss'), NULL, 1, (Timestamp '2001-07-22 12:04:24.007259'), 5, NULL, '2006', '', '2005-08-28 10:27:01', NULL, '2001', (Timestamp '2006-06-27 12:43:28.033198'), '07:17:29', NULL, -17650, to_date('2001-08-07 18:58:08','yyyy-mm-dd hh24:mi:ss'), 'pg', NULL, '2001', 'dpgs', (Timestamp '2000-03-11 07:34:22.043502'), NULL) INTO outer_3 VALUES (NULL, (Timestamp '2004-09-23 15:58:12.039332'), NULL, 2, (Timestamp '2004-03-24 11:42:03.039662'), -47, (Timestamp '2004-09-02 08:55:34.038673'), '', '2005-09-19 04:50:00', '', to_date('2005-07-02 22:41:43','yyyy-mm-dd hh24:mi:ss'), '', (Timestamp '2000-08-24 01:20:38.050373'), '2003-07-24', NULL, -62, to_date('2007-02-08 22:28:55','yyyy-mm-dd hh24:mi:ss'), '2001-12-09', NULL, '2001', '2003-12-17 14:46:47', (Timestamp '2004-09-24 09:19:36.029622'), (Timestamp '2000-07-23 20:02:12.001802')) INTO outer_3 VALUES (NULL, NULL, NULL, 3, (Timestamp '2006-04-26 06:27:00.057233'), -63, to_date('2006-12-23 23:55:47','yyyy-mm-dd hh24:mi:ss'), '2006-01-25 10:22:37', '2004', '', NULL, '2007-10-18', to_date('2003-03-02 14:51:08','yyyy-mm-dd hh24:mi:ss'), 'edpgsjdvhskb', NULL, 125, (Timestamp '2009-05-26 11:17:36.044738'), '13:24:52', NULL, 'nedpgsj', '2002-12-09', to_date('2008-06-15','yyyy-mm-dd'), NULL) INTO outer_3 VALUES (NULL, (Timestamp '2002-08-11 07:47:24.001502'), NULL, 4, (Timestamp '2000-03-17 00:19:43.048426'), 5, (Timestamp '2009-09-28 06:23:28.022299'), NULL, 'jnedpgsjdvhskb', '2001', NULL, NULL, (Timestamp '2000-08-24 11:47:30.052079'), '2006-04-05 20:38:20', NULL, 29, (Timestamp '2000-03-13 20:09:58.065070'), '2007', NULL, '2008', '2007-02-21 00:44:15', to_date('2008-10-21','yyyy-mm-dd'), NULL) INTO outer_3 VALUES (NULL, to_date('2003-04-19','yyyy-mm-dd'), NULL, 5, (Timestamp '2006-01-25 03:20:04.058024'), 3, to_date('2002-10-27 17:33:07','yyyy-mm-dd hh24:mi:ss'), '', '2001-12-22', '2006-06-28', NULL, '', to_date('2006-02-12','yyyy-mm-dd'), '', NULL, NULL, (Timestamp '2007-04-02 22:30:50.038517'), '', NULL, '2007-09-18', 'cjnedpgsjdvhskbtgmx', (Timestamp '2007-08-28 08:52:44.036556'), (Timestamp '2001-03-27 18:09:52.006014')) INTO outer_3 VALUES (NULL, to_date('2004-06-25','yyyy-mm-dd'), NULL, 6, (Timestamp '2005-01-05 07:23:46.016923'), NULL, (Timestamp '2000-11-17 13:18:37.023516'), NULL, '2005-04-26', '2003-11-15 16:37:42', (Timestamp '2006-04-22 02:46:34.012414'), 'qcjne', (Timestamp '2007-04-09 07:14:09.022236'), 'vqcjnedpgs', NULL, NULL, to_date('2003-02-22','yyyy-mm-dd'), NULL, NULL, NULL, '12:39:02', (Timestamp '2002-06-26 11:29:25.001610'), (Timestamp '2004-02-19 18:11:20.038166')) INTO outer_3 VALUES (NULL, to_date('2005-10-27','yyyy-mm-dd'), NULL, 7, to_date('2007-03-05 16:27:44','yyyy-mm-dd hh24:mi:ss'), NULL, to_date('2007-07-13 12:49:33','yyyy-mm-dd hh24:mi:ss'), '', '2000', '', to_date('2000-11-06 13:48:03','yyyy-mm-dd hh24:mi:ss'), '2009', (Timestamp '2009-10-02 14:28:28.006330'), '', NULL, 3, to_date('2001-03-20','yyyy-mm-dd'), '2003', NULL, '2001-11-19', '2009-03-15 03:51:06', to_date('2000-11-12','yyyy-mm-dd'), (Timestamp '2007-12-12 10:58:20.013312')) INTO outer_3 VALUES (NULL, to_date('2007-07-15','yyyy-mm-dd'), NULL, 8, NULL, -19032, to_date('2000-07-06','yyyy-mm-dd'), '2006-09-11', '2006', '17:40:06', (Timestamp '2006-03-05 20:56:46.051665'), NULL, (Timestamp '2007-02-24 23:19:33.049724'), 'gv', NULL, 14582, to_date('2002-04-01','yyyy-mm-dd'), '2006', NULL, '2003-06-21', '2000-11-04', NULL, (Timestamp '2001-07-14 06:26:35.031659')) INTO outer_3 VALUES (NULL, to_date('2004-03-01 10:08:54','yyyy-mm-dd hh24:mi:ss'), NULL, 9, (Timestamp '2004-03-01 11:12:09.009801'), 4, (Timestamp '2004-10-11 19:20:33.038495'), '2009-05-13', '01:06:29', '2001', to_date('2000-10-28','yyyy-mm-dd'), '2002', (Timestamp '2002-07-05 03:45:52.055924'), '2005', NULL, 8, to_date('2008-06-21 23:37:14','yyyy-mm-dd hh24:mi:ss'), '2008-08-20', NULL, 'hgvqcjnedpgs', 'uhgvqcjned', (Timestamp '2001-07-20 15:36:06.055031'), to_date('2009-02-28 09:02:06','yyyy-mm-dd hh24:mi:ss')) INTO outer_3 VALUES (NULL, to_date('2002-06-20 12:43:10','yyyy-mm-dd hh24:mi:ss'), NULL, 10, (Timestamp '2007-07-17 12:04:21.031982'), NULL, (Timestamp '2008-04-12 11:03:00.015884'), '08:33:31', '', NULL, (Timestamp '2008-09-01 17:31:35.023160'), '2008', (Timestamp '2000-11-19 13:45:33.007475'), NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2000-02-19', (Timestamp '2000-11-12 07:38:28.001631'), (Timestamp '2004-06-19 18:49:04.043072')) SELECT 1 FROM DUAL; DROP TABLE outer_7; CREATE TABLE outer_7 ( col_nvarchar2_20_key nvarchar2(20), col_ts_with_time_zone_key timestamp with time zone, col_ts_with_local_time_zone_ke timestamp with local time zone, col_nchar_20 nchar(20), col_ts_with_local_time_zone timestamp with local time zone, col_date date, col_binary_float binary_float, col_nchar_20_key nchar(20), col_binary_double binary_double, col_binary_float_key binary_float, col_number_key number, col_varchar2_20_key varchar2(20), col_ts timestamp, col_ts_with_time_zone timestamp with time zone, col_char_20 char(20), col_nvarchar2_20 nvarchar2(20), col_date_key date, col_binary_double_key binary_double, col_number number, col_char_20_key char(20), pk int not null, col_ts_key timestamp, col_varchar2_20 varchar2(20), /*Indices*/ primary key (pk) ) ; INSERT ALL INTO outer_7 VALUES ('dwsnvqgzgwzab', NULL, to_date('2009-02-16 05:44:16','yyyy-mm-dd hh24:mi:ss'), '2003', (Timestamp '2009-05-14 01:36:45.051171'), to_date('2000-07-18 11:20:25','yyyy-mm-dd hh24:mi:ss'), NULL, '2007', NULL, NULL, 118, 'rdwsnvqgzgwzabxuj', (Timestamp '2005-04-04 17:38:38.037814'), (Timestamp '2006-03-25 21:19:12.054701'), NULL, '2002', NULL, NULL, -97, '2001-05-17', 1, NULL, '2005') INTO outer_7 VALUES ('2001', (Timestamp '2006-01-22 05:46:08.063894'), to_date('2008-07-24','yyyy-mm-dd'), NULL, to_date('2003-09-06','yyyy-mm-dd'), (Timestamp '2009-01-24 05:46:52.053963'), NULL, '2002-11-09 10:43:48', NULL, NULL, NULL, '', NULL, (Timestamp '2003-01-13 10:09:17.048312'), '2004', '2002-02-27', (Timestamp '2009-12-10 11:27:23.056974'), NULL, NULL, '10:23:25', 2, (Timestamp '2007-04-28 01:06:21.036188'), '11:00:43') INTO outer_7 VALUES ('09:47:17', (Timestamp '2007-05-13 16:35:52.024492'), NULL, '', to_date('2004-03-19 19:32:59','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, '', NULL, NULL, 9, 'wrdwsnvqgzg', to_date('2000-01-08 15:45:28','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2009-08-22 10:51:47.062106'), '2002-05-27 05:05:37', '2009-04-16 23:32:21', to_date('2002-11-10','yyyy-mm-dd'), NULL, 1, '2000-08-21 05:55:09', 3, to_date('2005-02-24 07:00:31','yyyy-mm-dd hh24:mi:ss'), 'bwrdwsnvqgzgwzabxujz') INTO outer_7 VALUES ('', (Timestamp '2006-09-06 03:06:06.047153'), (Timestamp '2003-11-10 14:38:12.018915'), '2007-06-05 12:50:19', (Timestamp '2006-08-23 23:44:44.037012'), NULL, NULL, '2002-12-04', NULL, NULL, 2, '19:19:05', to_date('2002-10-17','yyyy-mm-dd'), to_date('2001-01-19 07:16:08','yyyy-mm-dd hh24:mi:ss'), '17:28:47', NULL, to_date('2007-11-15 07:50:59','yyyy-mm-dd hh24:mi:ss'), NULL, 0, '2003-03-05 12:55:28', 4, to_date('2009-03-26 10:53:50','yyyy-mm-dd hh24:mi:ss'), 'abwrd') INTO outer_7 VALUES ('2009-04-25 18:56:33', to_date('2006-01-26 09:03:15','yyyy-mm-dd hh24:mi:ss'), NULL, '00:54:34', (Timestamp '2004-04-28 11:56:24.035416'), (Timestamp '2002-04-17 09:42:35.032892'), NULL, '2007-04-11 14:52:43', NULL, NULL, NULL, NULL, (Timestamp '2002-11-07 22:25:10.023166'), to_date('2007-05-24','yyyy-mm-dd'), '2000-03-27 19:08:33', '2008-09-13', (Timestamp '2002-05-20 23:50:26.052206'), NULL, -28561, '2004-11-03', 5, (Timestamp '2002-04-17 12:54:00.009573'), '2004') INTO outer_7 VALUES ('', (Timestamp '2003-01-13 09:46:39.020751'), NULL, '2009-08-21 11:14:55', NULL, NULL, NULL, 'vabwrdwsnvqg', NULL, NULL, NULL, NULL, to_date('2007-05-25 04:16:20','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2004-07-07 02:46:42.052883'), NULL, '2004', to_date('2006-03-16 13:11:21','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, '', 6, (Timestamp '2006-09-13 17:26:59.019383'), '2000-12-18 16:10:26') INTO outer_7 VALUES ('15:50:11', (Timestamp '2004-09-19 20:09:36.000053'), NULL, '2002-01-23 08:13:03', to_date('2007-06-03 08:41:10','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2001-10-04 03:54:51.000919'), NULL, '2009', NULL, NULL, -102, '2000-12-16', (Timestamp '2004-10-11 07:28:43.050162'), (Timestamp '2001-08-19 03:55:36.031435'), 'rvabwrdwsnvqgzgwzabx', 'zrvabwrdwsnvqgzgwza', (Timestamp '2007-03-04 14:02:30.028838'), NULL, NULL, '', 7, (Timestamp '2001-03-19 11:16:31.041359'), NULL) INTO outer_7 VALUES (NULL, to_date('2005-04-18 14:45:43','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2006-03-03 05:46:37.020440'), '', (Timestamp '2001-05-04 01:39:57.003252'), NULL, NULL, '', NULL, NULL, 10414, NULL, (Timestamp '2001-07-02 18:07:07.026779'), NULL, NULL, '2007', NULL, NULL, -16022, '', 8, NULL, '') INTO outer_7 VALUES ('2001-08-10', to_date('2004-06-06 21:54:38','yyyy-mm-dd hh24:mi:ss'), NULL, '2009-11-19 02:03:41', to_date('2001-05-04 06:30:33','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, NULL, NULL, NULL, 69, 'azr', (Timestamp '2009-06-11 00:40:11.029595'), to_date('2006-01-09 12:40:14','yyyy-mm-dd hh24:mi:ss'), '2008-08-28 17:45:49', '2005', (Timestamp '2000-03-20 17:38:13.016272'), NULL, -10558, NULL, 9, NULL, '2009') INTO outer_7 VALUES ('14:17:24', (Timestamp '2006-07-27 15:01:04.035288'), (Timestamp '2000-10-20 02:02:47.003220'), NULL, (Timestamp '2007-12-01 15:48:52.035676'), to_date('2005-07-13','yyyy-mm-dd'), NULL, '2009-03-05 10:30:22', NULL, NULL, -15, '2000', to_date('2000-08-05','yyyy-mm-dd'), to_date('2003-10-14','yyyy-mm-dd'), '03:26:17', '2000', (Timestamp '2004-10-07 04:20:24.060146'), NULL, 3, '2006-09-03 04:00:33', 10, (Timestamp '2004-09-15 12:10:07.032049'), '') INTO outer_7 VALUES ('2000-06-18 06:17:03', to_date('2006-09-09 12:57:27','yyyy-mm-dd hh24:mi:ss'), to_date('2003-10-19','yyyy-mm-dd'), '2005-05-20', (Timestamp '2009-12-05 08:39:11.028279'), to_date('2006-04-18','yyyy-mm-dd'), NULL, '2007-05-18 17:15:54', NULL, NULL, -106, '12:46:55', to_date('2006-10-07 00:45:11','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2002-08-05 11:49:01.034480'), '2004', 'vazrvabwrdwsn', (Timestamp '2005-06-01 08:05:00.025408'), NULL, NULL, '22:09:12', 11, to_date('2001-10-25','yyyy-mm-dd'), '07:50:18') INTO outer_7 VALUES ('a', (Timestamp '2009-10-26 04:14:41.048306'), (Timestamp '2009-09-25 12:44:43.004683'), 'oavazrvabwrdwsnvqgz', to_date('2004-01-01 12:16:21','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2006-03-05 23:50:19.024527'), NULL, '2003-08-16 10:34:43', NULL, NULL, -8484, NULL, NULL, to_date('2006-08-16 06:58:06','yyyy-mm-dd hh24:mi:ss'), NULL, '', (Timestamp '2003-01-17 11:26:04.055578'), NULL, -64, '2004', 12, to_date('2003-12-14 22:20:40','yyyy-mm-dd hh24:mi:ss'), '21:35:52') INTO outer_7 VALUES (NULL, (Timestamp '2001-03-21 21:23:58.003946'), (Timestamp '2006-05-19 13:21:28.057800'), '2001-12-09', NULL, (Timestamp '2008-02-08 08:29:58.032404'), NULL, 'xoavazrvabwrdwsnvq', NULL, NULL, NULL, '01:29:57', (Timestamp '2007-03-02 06:50:15.005069'), to_date('2005-05-04','yyyy-mm-dd'), '2009', '16:51:06', to_date('2004-04-01','yyyy-mm-dd'), NULL, 105, '00:22:10', 13, to_date('2002-12-20','yyyy-mm-dd'), '22:09:32') INTO outer_7 VALUES ('21:01:10', (Timestamp '2001-11-16 10:30:33.033702'), to_date('2009-03-08 17:43:33','yyyy-mm-dd hh24:mi:ss'), '2006', (Timestamp '2006-05-16 19:40:33.011727'), to_date('2005-11-14 04:36:41','yyyy-mm-dd hh24:mi:ss'), NULL, '2000-02-28 10:13:31', NULL, NULL, -127, '2001-06-06', (Timestamp '2009-10-04 03:02:02.028578'), to_date('2003-02-11','yyyy-mm-dd'), '', 'ixoavazrvabwrd', (Timestamp '2006-07-01 23:43:35.017236'), NULL, 89, 'uixoava', 14, (Timestamp '2006-04-24 06:14:23.039760'), NULL) INTO outer_7 VALUES ('buixoavazrvabwr', (Timestamp '2006-06-13 12:22:08.027178'), to_date('2006-07-04','yyyy-mm-dd'), '2005-11-07 14:12:22', NULL, NULL, NULL, '2000', NULL, NULL, 8, '2008', (Timestamp '2005-04-15 14:10:09.002066'), NULL, '', '2007', (Timestamp '2002-03-07 11:53:20.009305'), NULL, 7, '2007-01-25 21:01:07', 15, (Timestamp '2007-10-26 03:19:58.031399'), '2003') INTO outer_7 VALUES ('2008', NULL, (Timestamp '2003-12-21 17:45:04.037415'), '07:22:10', (Timestamp '2005-11-19 19:29:48.000696'), to_date('2009-05-28','yyyy-mm-dd'), NULL, NULL, NULL, NULL, NULL, 'obuixoavaz', (Timestamp '2006-04-04 05:45:14.043317'), (Timestamp '2007-01-24 11:22:49.048955'), '04:11:22', '2003', (Timestamp '2007-04-02 08:55:07.032852'), NULL, 5772, '2006', 16, (Timestamp '2004-02-13 10:52:33.034169'), 'uob') INTO outer_7 VALUES ('03:59:49', (Timestamp '2009-01-01 20:13:04.008416'), (Timestamp '2008-05-15 17:01:36.037056'), '2006', to_date('2000-12-12','yyyy-mm-dd'), to_date('2005-02-15 03:07:18','yyyy-mm-dd hh24:mi:ss'), NULL, '2004', NULL, NULL, 69, 'i', (Timestamp '2002-07-05 05:30:52.054244'), (Timestamp '2008-10-01 16:39:02.023814'), '2008', '2001-07-16 22:27:34', (Timestamp '2005-08-27 16:57:06.031601'), NULL, -90, NULL, 17, (Timestamp '2001-12-01 00:38:59.061209'), '2004-12-26 10:49:18') INTO outer_7 VALUES ('2004', to_date('2008-07-23 03:51:10','yyyy-mm-dd hh24:mi:ss'), to_date('2004-12-05 19:00:17','yyyy-mm-dd hh24:mi:ss'), '', to_date('2000-08-28 18:44:40','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, NULL, NULL, NULL, NULL, '2006', (Timestamp '2001-12-02 05:40:40.056149'), (Timestamp '2005-11-13 20:13:36.031470'), '2007-12-11 01:28:16', NULL, to_date('2000-03-22','yyyy-mm-dd'), NULL, 0, '02:00:31', 18, to_date('2004-03-26','yyyy-mm-dd'), '') INTO outer_7 VALUES ('2004', to_date('2007-03-07 13:11:48','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2007-06-13 04:53:44.048267'), '2002', to_date('2006-10-27','yyyy-mm-dd'), (Timestamp '2007-10-21 01:28:45.012332'), NULL, '2005-03-06', NULL, NULL, 1, '2000', (Timestamp '2007-08-13 19:35:00.013974'), (Timestamp '2004-02-27 22:25:53.033989'), '', '', (Timestamp '2007-06-26 08:30:32.004005'), NULL, 6145, '2001', 19, to_date('2000-06-07 01:03:37','yyyy-mm-dd hh24:mi:ss'), '2003') INTO outer_7 VALUES ('2004-04-01', to_date('2008-02-03 15:24:36','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2003-09-10 02:54:35.048488'), 'fiuobui', (Timestamp '2000-01-15 15:35:19.018907'), (Timestamp '2003-10-02 09:28:40.029099'), NULL, '', NULL, NULL, -7, '2005', to_date('2009-08-12 20:04:52','yyyy-mm-dd hh24:mi:ss'), to_date('2002-02-02 21:57:00','yyyy-mm-dd hh24:mi:ss'), '', '2005-04-20', to_date('2008-06-07 12:50:59','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, '22:51:54', 20, (Timestamp '2003-03-07 21:25:42.060968'), NULL) INTO outer_7 VALUES (NULL, to_date('2008-02-15 04:17:25','yyyy-mm-dd hh24:mi:ss'), to_date('2003-09-08 09:28:18','yyyy-mm-dd hh24:mi:ss'), '', (Timestamp '2001-06-05 18:02:21.012571'), to_date('2009-06-28 15:16:34','yyyy-mm-dd hh24:mi:ss'), NULL, '2001-02-07', NULL, NULL, 4, '2009', (Timestamp '2008-08-13 08:20:23.035162'), NULL, '2009-09-03 11:23:22', '', NULL, NULL, 942, '2000', 21, (Timestamp '2001-06-03 20:48:43.021318'), 'dfiuobuixoavazrvabw') INTO outer_7 VALUES ('xdfi', to_date('2000-11-13 18:33:04','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2001-06-27 16:50:50.015225'), '2009-08-14', NULL, NULL, NULL, 'bxdfiuobu', NULL, NULL, 17, '23:52:49', NULL, NULL, '2003-02-22 15:26:25', '2002', NULL, NULL, 23977, '21:55:38', 22, NULL, '2005-09-11') INTO outer_7 VALUES ('2008-12-10 01:28:35', to_date('2001-07-16 18:17:50','yyyy-mm-dd hh24:mi:ss'), NULL, '2008-11-11', to_date('2008-12-21 03:01:44','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2007-10-02 07:46:47.049203'), NULL, 'dbxdfi', NULL, NULL, -44, '2001', (Timestamp '2009-02-14 13:51:31.030751'), (Timestamp '2003-11-06 15:04:36.065056'), '', '2004-06-10', NULL, NULL, 4478, '08:24:18', 23, to_date('2007-03-08','yyyy-mm-dd'), '2006') INTO outer_7 VALUES ('2006', (Timestamp '2009-02-11 16:04:34.054395'), to_date('2008-05-28','yyyy-mm-dd'), NULL, (Timestamp '2006-11-03 09:21:42.006113'), NULL, NULL, '2006-08-11', NULL, NULL, -3885, '2007-06-05', (Timestamp '2000-10-09 18:24:08.057702'), (Timestamp '2003-02-04 17:29:21.062256'), '2003', 'udbxdfiuobuixoava', NULL, NULL, 47, 'iudbxdfiu', 24, (Timestamp '2006-03-27 09:57:57.050529'), '2008') INTO outer_7 VALUES (NULL, to_date('2006-04-10 18:18:48','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2006-06-04 10:47:36.000137'), '', (Timestamp '2004-05-11 13:41:30.063045'), (Timestamp '2009-04-10 11:51:44.012406'), NULL, '', NULL, NULL, -18286, '2000-07-24', to_date('2007-03-08 15:43:43','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2001-05-01 14:49:13.023726'), '06:48:40', '2004', (Timestamp '2003-12-26 21:48:28.031246'), NULL, 0, '2008', 25, to_date('2003-06-08','yyyy-mm-dd'), '2003-10-24') INTO outer_7 VALUES ('11:38:45', NULL, to_date('2006-10-15 11:41:14','yyyy-mm-dd hh24:mi:ss'), '19:32:34', (Timestamp '2007-10-05 20:28:22.063557'), (Timestamp '2002-09-10 17:16:58.008625'), NULL, '', NULL, NULL, 1, 'kiudbxdfiu', to_date('2003-11-27','yyyy-mm-dd'), (Timestamp '2009-08-20 04:12:11.017981'), '2005-11-06 08:41:49', '17:44:43', (Timestamp '2001-02-19 07:13:39.051054'), NULL, -31870, '2008', 26, to_date('2007-10-25 01:54:43','yyyy-mm-dd hh24:mi:ss'), '') INTO outer_7 VALUES (NULL, (Timestamp '2006-08-18 18:33:32.006913'), (Timestamp '2006-03-12 05:49:17.048138'), NULL, (Timestamp '2005-07-01 22:59:20.036941'), to_date('2006-08-06','yyyy-mm-dd'), NULL, '2004', NULL, NULL, -40, 'zkiudbxdfiuobuixoav', NULL, to_date('2005-04-19','yyyy-mm-dd'), '2003', NULL, (Timestamp '2000-09-01 11:29:33.007165'), NULL, NULL, '', 27, NULL, '2005-12-14 04:19:30') INTO outer_7 VALUES ('2007', (Timestamp '2002-08-14 02:38:51.028706'), (Timestamp '2006-09-14 01:20:47.046459'), '2006-01-13 05:59:13', (Timestamp '2002-05-26 19:06:14.062063'), to_date('2002-01-01 10:08:44','yyyy-mm-dd hh24:mi:ss'), NULL, '2004-04-22 20:09:39', NULL, NULL, NULL, '', NULL, (Timestamp '2005-03-22 10:03:49.017510'), '2006', '2007', (Timestamp '2004-02-11 07:46:24.065044'), NULL, 7, 'jzkiudbxdf', 28, NULL, '2007') INTO outer_7 VALUES ('2004-02-06 19:17:10', (Timestamp '2000-10-20 06:32:14.021278'), to_date('2005-02-16 15:34:53','yyyy-mm-dd hh24:mi:ss'), '', (Timestamp '2009-02-16 01:03:23.052064'), NULL, NULL, '2001', NULL, NULL, NULL, '', NULL, (Timestamp '2002-09-25 23:13:52.039759'), '09:51:21', '', NULL, NULL, -46, '2000', 29, to_date('2009-07-10 07:08:47','yyyy-mm-dd hh24:mi:ss'), '2006') INTO outer_7 VALUES (NULL, (Timestamp '2005-07-03 03:04:02.042352'), NULL, '2006-09-07 02:38:50', NULL, (Timestamp '2004-06-14 16:53:21.015308'), NULL, '2001-03-10 05:13:04', NULL, NULL, -102, NULL, (Timestamp '2009-06-09 19:23:03.035780'), NULL, '2001-01-07 00:06:24', '08:20:30', (Timestamp '2000-07-06 18:39:31.015822'), NULL, NULL, '2006-07-22', 30, (Timestamp '2002-02-08 17:01:53.059411'), '14:55:39') SELECT 1 FROM DUAL; DROP TABLE outer_8; CREATE TABLE outer_8 ( col_nvarchar2_20_key nvarchar2(20), col_ts_with_time_zone_key timestamp with time zone, col_binary_float binary_float, col_char_20_key char(20), col_binary_double binary_double, col_ts_with_time_zone timestamp with time zone, col_nchar_20 nchar(20), col_varchar2_20 varchar2(20), col_binary_float_key binary_float, col_nchar_20_key nchar(20), col_char_20 char(20), col_date date, col_date_key date, col_ts_with_local_time_zone_ke timestamp with local time zone, col_number number, col_varchar2_20_key varchar2(20), col_ts_key timestamp, col_binary_double_key binary_double, col_ts timestamp, pk int not null, col_number_key number, col_nvarchar2_20 nvarchar2(20), col_ts_with_local_time_zone timestamp with local time zone, /*Indices*/ primary key (pk) ) PARTITION BY range(pk)(partition p1 values less than(5),partition p2 values less than(maxvalue)) ; INSERT ALL INTO outer_8 VALUES ('sjz', (Timestamp '2000-06-21 21:06:59.030707'), NULL, NULL, NULL, (Timestamp '2005-06-11 17:54:16.034344'), 'xsjzkiudbx', 'exsjz', NULL, '2002', 'mexsjzkiudbxdfiuo', (Timestamp '2005-11-27 06:42:56.000458'), NULL, (Timestamp '2007-03-21 16:04:00.051047'), 0, '2007-07-25', (Timestamp '2008-06-03 01:58:40.045600'), NULL, (Timestamp '2004-04-06 03:28:39.009879'), 1, 2, '', to_date('2008-06-18','yyyy-mm-dd')) INTO outer_8 VALUES ('', (Timestamp '2008-07-27 03:45:46.018602'), NULL, '2007-05-15', NULL, to_date('2006-01-18','yyyy-mm-dd'), NULL, '2007-12-13', NULL, '2006-11-25', '2005-05-19 15:23:11', (Timestamp '2003-06-19 03:23:58.013220'), NULL, (Timestamp '2007-11-18 14:32:16.008874'), 5, '2002', to_date('2009-10-18','yyyy-mm-dd'), NULL, (Timestamp '2003-09-12 19:57:57.013982'), 2, -17, '2000-06-23', (Timestamp '2003-05-12 10:50:17.013992')) INTO outer_8 VALUES ('2004', NULL, NULL, '2001-01-21 02:52:48', NULL, (Timestamp '2008-12-10 12:57:11.031658'), '2003-07-05', '2009-09-02', NULL, '', '2001', to_date('2009-03-16','yyyy-mm-dd'), (Timestamp '2003-07-07 01:34:05.034053'), to_date('2001-01-23 18:21:21','yyyy-mm-dd hh24:mi:ss'), NULL, 'fmexsjzkiudb', (Timestamp '2007-05-26 04:08:43.020233'), NULL, to_date('2002-04-02 01:31:17','yyyy-mm-dd hh24:mi:ss'), 3, 4, '2006-06-04 16:34:23', NULL) INTO outer_8 VALUES ('2002', to_date('2008-08-13','yyyy-mm-dd'), NULL, '2004-08-23', NULL, NULL, '18:25:57', '2001-09-16 20:33:35', NULL, '', '2001', (Timestamp '2003-07-03 06:12:10.044021'), (Timestamp '2007-05-07 10:50:41.019355'), NULL, -106, NULL, NULL, NULL, (Timestamp '2005-03-26 18:53:06.036936'), 4, NULL, '2003-03-22', (Timestamp '2005-08-19 06:28:21.063320')) INTO outer_8 VALUES ('2001-10-10 13:21:18', to_date('2005-08-18 13:29:40','yyyy-mm-dd hh24:mi:ss'), NULL, '2007', NULL, (Timestamp '2001-03-20 17:54:36.025126'), '2002-06-05 08:38:46', 'vfmexs', NULL, NULL, '2007-09-16 17:26:41', (Timestamp '2006-08-11 00:36:49.008682'), NULL, to_date('2000-04-22','yyyy-mm-dd'), 1, NULL, (Timestamp '2006-02-02 10:28:53.061816'), NULL, to_date('2007-06-26 19:51:36','yyyy-mm-dd hh24:mi:ss'), 5, -9436, '03:35:05', (Timestamp '2002-03-07 11:46:42.029257')) INTO outer_8 VALUES ('2004-08-13 11:42:14', (Timestamp '2002-12-20 16:08:25.029069'), NULL, 'yvfmexsjzkiudbx', NULL, NULL, '2004', '2002-06-26', NULL, '08:31:51', '00:45:16', (Timestamp '2000-08-15 02:26:26.009903'), (Timestamp '2004-11-10 03:40:16.022238'), to_date('2009-06-09','yyyy-mm-dd'), 8, '12:37:08', (Timestamp '2008-04-13 22:01:09.003957'), NULL, to_date('2000-01-23 15:50:47','yyyy-mm-dd hh24:mi:ss'), 6, 4188, '15:08:05', (Timestamp '2005-12-04 12:00:12.040637')) INTO outer_8 VALUES ('2009-01-12 23:11:11', (Timestamp '2007-12-20 16:57:52.045763'), NULL, '', NULL, (Timestamp '2004-08-26 04:25:02.045845'), '2007-12-27', '', NULL, '2009', '23:38:55', (Timestamp '2008-08-22 01:35:40.064579'), NULL, NULL, NULL, '2000-09-01', to_date('2008-11-08','yyyy-mm-dd'), NULL, NULL, 7, NULL, '2004', (Timestamp '2002-07-26 19:14:02.049930')) INTO outer_8 VALUES ('2002', (Timestamp '2005-09-17 22:32:06.011255'), NULL, '2000', NULL, (Timestamp '2004-03-02 06:14:12.032935'), NULL, NULL, NULL, '', '2007-07-14', NULL, NULL, NULL, NULL, '2006-01-26', to_date('2003-09-13 11:23:14','yyyy-mm-dd hh24:mi:ss'), NULL, to_date('2003-08-06','yyyy-mm-dd'), 8, NULL, '2009-03-12 04:12:29', to_date('2006-11-08','yyyy-mm-dd')) INTO outer_8 VALUES ('2005', NULL, NULL, '', NULL, to_date('2002-08-26 20:27:32','yyyy-mm-dd hh24:mi:ss'), 'myvfmexsjzkiudb', '2004-12-08 06:04:34', NULL, '15:38:40', NULL, NULL, to_date('2002-08-06 23:26:15','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, '2006-06-01', (Timestamp '2004-06-09 00:36:39.024502'), NULL, (Timestamp '2000-03-26 07:29:39.036097'), 9, -10604, '2001', to_date('2009-06-17 05:41:53','yyyy-mm-dd hh24:mi:ss')) INTO outer_8 VALUES ('2002', (Timestamp '2008-05-04 09:50:09.010925'), NULL, '2000-06-10 11:06:38', NULL, (Timestamp '2009-06-05 00:53:20.010372'), 'hmyvfmex', 'uhmyvfmexsjzkiudbx', NULL, '00:55:13', '09:17:13', to_date('2000-01-02','yyyy-mm-dd'), NULL, NULL, 6, '2007-11-05', NULL, NULL, (Timestamp '2001-07-20 02:39:41.039929'), 10, 123, '2007', (Timestamp '2009-10-17 22:29:19.058291')) INTO outer_8 VALUES ('2004', (Timestamp '2004-11-24 04:15:42.019037'), NULL, NULL, NULL, to_date('2007-02-18 08:30:31','yyyy-mm-dd hh24:mi:ss'), '2007-08-18', '2008', NULL, '', '2005-11-05', to_date('2000-08-06','yyyy-mm-dd'), NULL, (Timestamp '2008-07-24 14:45:58.002915'), NULL, '2000-07-22 00:35:36', NULL, NULL, (Timestamp '2006-12-24 13:50:29.061423'), 11, -24886, '15:35:45', NULL) INTO outer_8 VALUES ('2005', (Timestamp '2001-04-05 10:31:31.010501'), NULL, '2005-04-18 04:58:16', NULL, to_date('2000-03-16 12:11:49','yyyy-mm-dd hh24:mi:ss'), 'vuhmyvfmexsjzki', '23:54:06', NULL, '2001-03-02 08:58:47', '2002-11-03 19:03:09', to_date('2008-11-08','yyyy-mm-dd'), NULL, NULL, NULL, 'evuhmyvfmexsjzkiudb', (Timestamp '2006-04-03 00:04:11.042477'), NULL, NULL, 12, 1, '', NULL) INTO outer_8 VALUES ('2009-09-08', (Timestamp '2008-09-05 09:04:21.061802'), NULL, '2006-01-12', NULL, NULL, '2007-02-18', '2001-07-03 11:33:39', NULL, '', '2008-05-06 08:42:05', to_date('2000-12-04','yyyy-mm-dd'), (Timestamp '2003-11-06 08:14:05.041820'), (Timestamp '2007-12-08 22:14:53.032660'), -55, '00:03:45', (Timestamp '2003-12-14 23:17:22.059568'), NULL, to_date('2005-03-15 10:28:31','yyyy-mm-dd hh24:mi:ss'), 13, -6258, '2000-05-25', (Timestamp '2000-06-25 11:35:27.005044')) INTO outer_8 VALUES ('2008-06-16', (Timestamp '2008-09-24 21:03:56.010286'), NULL, NULL, NULL, (Timestamp '2006-10-11 00:04:21.009461'), '2002', '2006', NULL, 'devuhm', '2008-06-24', to_date('2004-08-18 00:23:19','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2002-05-14 09:07:44.039437'), to_date('2008-12-12 02:50:36','yyyy-mm-dd hh24:mi:ss'), 9, '', to_date('2009-08-25 11:23:24','yyyy-mm-dd hh24:mi:ss'), NULL, (Timestamp '2003-12-13 09:21:26.008588'), 14, 3, NULL, to_date('2006-06-27','yyyy-mm-dd')) INTO outer_8 VALUES (NULL, (Timestamp '2006-07-09 02:04:08.039119'), NULL, '', NULL, (Timestamp '2003-10-10 05:22:08.064120'), '2002', 'gde', NULL, '2007', NULL, NULL, (Timestamp '2004-02-04 16:00:20.044214'), (Timestamp '2006-04-12 20:22:31.064773'), 6, '', (Timestamp '2009-10-21 07:45:23.000162'), NULL, to_date('2007-11-13 04:17:39','yyyy-mm-dd hh24:mi:ss'), 15, -28960, '2008-10-14', NULL) INTO outer_8 VALUES (NULL, (Timestamp '2002-11-12 04:23:02.047023'), NULL, '2002', NULL, (Timestamp '2008-07-18 01:54:44.052385'), NULL, '2004-05-06', NULL, '11:03:28', '2005-12-09', (Timestamp '2002-11-21 19:07:59.011313'), (Timestamp '2000-11-09 12:31:27.040861'), NULL, -31660, NULL, NULL, NULL, (Timestamp '2001-06-02 01:45:24.059986'), 16, 86, 'rgdevuhmyvfmexsjz', NULL) INTO outer_8 VALUES ('2007-06-13 08:56:04', to_date('2000-07-12 04:26:52','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, NULL, to_date('2002-03-23','yyyy-mm-dd'), NULL, '', NULL, '2008-04-18', '2005', to_date('2003-04-20 15:35:34','yyyy-mm-dd hh24:mi:ss'), NULL, to_date('2005-09-10 05:05:51','yyyy-mm-dd hh24:mi:ss'), 17, '03:36:09', NULL, NULL, (Timestamp '2000-06-15 03:32:22.055380'), 17, -4, '2001-12-27 00:34:11', to_date('2006-09-12','yyyy-mm-dd')) INTO outer_8 VALUES ('urgdevuhmyv', (Timestamp '2001-11-13 04:18:48.052826'), NULL, '00:07:11', NULL, to_date('2002-09-11','yyyy-mm-dd'), '', '03:44:04', NULL, '2001', '2000-10-26', (Timestamp '2002-07-10 05:08:07.062365'), NULL, (Timestamp '2002-09-17 07:55:42.057576'), -96, 'kurgdevuhmyvfmexsjzk', (Timestamp '2003-07-26 13:20:02.051440'), NULL, (Timestamp '2001-04-13 15:32:36.004743'), 18, 2, '12:01:14', to_date('2005-03-05 16:06:33','yyyy-mm-dd hh24:mi:ss')) INTO outer_8 VALUES ('2008', NULL, NULL, '2005', NULL, (Timestamp '2000-06-23 16:06:32.032589'), '2003', 'lkurgde', NULL, '2002', '2000-12-15 06:45:16', (Timestamp '2008-07-14 01:45:02.030795'), to_date('2006-02-12','yyyy-mm-dd'), (Timestamp '2004-10-11 04:29:54.017298'), -23693, '20:00:34', (Timestamp '2009-04-07 00:35:36.015663'), NULL, NULL, 19, -113, '2006', NULL) INTO outer_8 VALUES ('02:29:17', to_date('2001-10-16','yyyy-mm-dd'), NULL, NULL, NULL, (Timestamp '2004-05-14 13:42:59.017235'), '', NULL, NULL, '2003-05-10 08:34:51', NULL, (Timestamp '2002-02-24 02:20:56.053277'), to_date('2009-11-22 12:44:43','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2003-07-19 08:42:37.020833'), 19582, '', (Timestamp '2004-04-15 00:26:25.001848'), NULL, to_date('2000-06-17 02:06:55','yyyy-mm-dd hh24:mi:ss'), 20, 2, 'jlk', NULL) INTO outer_8 VALUES ('2009', (Timestamp '2000-07-14 04:30:13.032755'), NULL, '2005-05-09', NULL, NULL, NULL, '2009-02-09 15:03:27', NULL, '2002-10-16', '2002', (Timestamp '2002-04-26 05:43:40.016484'), (Timestamp '2000-05-09 18:47:08.031025'), to_date('2003-03-27','yyyy-mm-dd'), NULL, '2002-08-13', (Timestamp '2003-05-13 12:10:30.017300'), NULL, to_date('2002-07-26','yyyy-mm-dd'), 21, 9, '2009-12-26', (Timestamp '2004-01-27 18:52:32.001600')) INTO outer_8 VALUES ('2000-09-18 18:48:55', to_date('2001-01-13','yyyy-mm-dd'), NULL, '2004', NULL, (Timestamp '2009-06-07 18:19:34.059854'), '', '20:09:33', NULL, '2000-11-16', NULL, (Timestamp '2003-10-27 05:39:25.036180'), NULL, (Timestamp '2004-02-07 08:25:09.043586'), 5, '2003', to_date('2000-01-05 16:51:21','yyyy-mm-dd hh24:mi:ss'), NULL, (Timestamp '2003-04-26 17:51:40.011440'), 22, 3, '2002-03-10', (Timestamp '2005-04-13 02:35:01.025614')) INTO outer_8 VALUES ('wjlk', (Timestamp '2006-03-01 02:23:07.018455'), NULL, '2000-01-15 12:18:19', NULL, NULL, '2006-12-28', NULL, NULL, '2004-11-24 04:42:05', '23:52:17', (Timestamp '2003-02-09 21:10:46.030860'), to_date('2000-03-18','yyyy-mm-dd'), to_date('2008-11-11','yyyy-mm-dd'), 6, NULL, to_date('2007-12-19','yyyy-mm-dd'), NULL, (Timestamp '2000-02-14 15:48:25.063019'), 23, NULL, 'gwjlkurgdevu', to_date('2001-08-13','yyyy-mm-dd')) INTO outer_8 VALUES ('egwjlkur', NULL, NULL, 'tegwjlk', NULL, (Timestamp '2001-01-13 20:07:51.004804'), '', NULL, NULL, '2009-03-07', '2002-07-17 17:08:10', (Timestamp '2006-06-28 17:11:23.009299'), to_date('2003-03-14 19:45:06','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2005-07-16 22:54:22.047398'), -98, '2007', to_date('2004-04-09 19:05:25','yyyy-mm-dd hh24:mi:ss'), NULL, (Timestamp '2005-03-02 22:13:49.047382'), 24, 1131, '2004', (Timestamp '2001-09-15 19:02:56.054996')) INTO outer_8 VALUES ('lt', to_date('2009-06-08 12:24:27','yyyy-mm-dd hh24:mi:ss'), NULL, 'mltegwjlku', NULL, (Timestamp '2009-03-12 04:37:29.026949'), '2006-04-22', '2005-01-01', NULL, 'imltegwjlkurgde', '', to_date('2002-06-01','yyyy-mm-dd'), (Timestamp '2006-09-05 10:49:57.026852'), (Timestamp '2005-06-10 03:09:32.039741'), -27686, '2009-06-04 13:16:06', to_date('2008-12-13','yyyy-mm-dd'), NULL, (Timestamp '2001-02-26 22:12:06.053784'), 25, 2, '2003-02-18 13:32:08', to_date('2002-05-28','yyyy-mm-dd')) INTO outer_8 VALUES ('2003-10-28 03:18:55', NULL, NULL, '2006-08-26 17:23:43', NULL, (Timestamp '2005-11-08 14:52:07.051849'), '2007-04-01 21:09:15', '2009-08-27 01:49:19', NULL, NULL, '2005', to_date('2002-01-17','yyyy-mm-dd'), to_date('2009-05-06','yyyy-mm-dd'), to_date('2007-05-11 15:04:31','yyyy-mm-dd hh24:mi:ss'), NULL, '', (Timestamp '2008-11-06 10:04:46.029345'), NULL, (Timestamp '2002-07-11 14:15:42.047680'), 26, NULL, '00:23:12', to_date('2007-10-23 07:21:42','yyyy-mm-dd hh24:mi:ss')) INTO outer_8 VALUES ('2008-08-01 15:03:06', (Timestamp '2003-04-22 04:37:10.035199'), NULL, '22:01:54', NULL, (Timestamp '2005-12-14 19:33:13.028508'), NULL, 'oimlteg', NULL, NULL, '2000', (Timestamp '2003-02-12 10:33:33.044950'), (Timestamp '2002-05-19 15:43:58.021098'), (Timestamp '2002-10-17 17:29:02.062940'), 4, '16:13:07', to_date('2002-07-14 06:35:38','yyyy-mm-dd hh24:mi:ss'), NULL, (Timestamp '2008-11-24 04:14:58.057334'), 27, NULL, '', to_date('2005-05-02','yyyy-mm-dd')) INTO outer_8 VALUES ('goimltegwjlku', to_date('2005-09-15 16:26:37','yyyy-mm-dd hh24:mi:ss'), NULL, '2008', NULL, to_date('2004-12-26 02:43:31','yyyy-mm-dd hh24:mi:ss'), '2002', '2000-08-08 03:49:59', NULL, '2007-04-21 12:35:26', '2007', to_date('2007-11-26','yyyy-mm-dd'), (Timestamp '2007-06-28 20:24:25.037990'), (Timestamp '2002-06-14 02:25:18.025484'), -45, NULL, NULL, NULL, to_date('2003-09-27 06:00:13','yyyy-mm-dd hh24:mi:ss'), 28, 3, '00:30:49', to_date('2006-10-20 21:44:29','yyyy-mm-dd hh24:mi:ss')) INTO outer_8 VALUES ('', to_date('2008-09-10','yyyy-mm-dd'), NULL, '2006-01-05', NULL, NULL, '21:54:09', '2003', NULL, '', '2002-04-06 02:02:32', (Timestamp '2003-12-01 04:43:08.050915'), (Timestamp '2006-05-23 05:46:44.033220'), (Timestamp '2005-07-15 15:51:34.024299'), 2359, 'mgoimltegw', to_date('2008-11-25','yyyy-mm-dd'), NULL, (Timestamp '2008-02-17 17:04:12.060541'), 29, -109, NULL, NULL) INTO outer_8 VALUES ('2005', NULL, NULL, 'emgoimltegwjlkur', NULL, NULL, '2000-04-02', '2005', NULL, '2005', '2007-05-04', (Timestamp '2008-12-10 18:06:44.049157'), (Timestamp '2003-01-07 07:40:10.056539'), (Timestamp '2002-07-11 12:53:01.037146'), -28520, '', (Timestamp '2002-12-19 18:09:10.005803'), NULL, to_date('2007-04-22','yyyy-mm-dd'), 30, -105, '2007', to_date('2002-11-14 18:27:11','yyyy-mm-dd hh24:mi:ss')) SELECT 1 FROM DUAL; DROP TABLE outer_11; CREATE TABLE outer_11 ( col_char_20_key char(20), col_date_key date, col_ts_with_local_time_zone_ke timestamp with local time zone, col_ts_with_local_time_zone timestamp with local time zone, col_binary_float binary_float, col_binary_double_key binary_double, col_nvarchar2_20 nvarchar2(20), col_nchar_20 nchar(20), pk int not null, col_ts_key timestamp, col_char_20 char(20), col_number_key number, col_date date, col_ts_with_time_zone timestamp with time zone, col_varchar2_20 varchar2(20), col_binary_double binary_double, col_binary_float_key binary_float, col_nvarchar2_20_key nvarchar2(20), col_varchar2_20_key varchar2(20), col_ts_with_time_zone_key timestamp with time zone, col_nchar_20_key nchar(20), col_number number, col_ts timestamp, /*Indices*/ primary key (pk) ) PARTITION BY range(pk)(partition p1 values less than(5),partition p2 values less than(maxvalue)) ; INSERT ALL INTO outer_11 VALUES ('2005', (Timestamp '2001-05-01 10:02:14.030292'), (Timestamp '2006-09-10 17:37:09.050803'), (Timestamp '2008-03-10 13:57:57.051332'), NULL, NULL, '2005', 'f', 1, to_date('2003-11-14 16:34:58','yyyy-mm-dd hh24:mi:ss'), '2009-12-02 15:39:21', NULL, (Timestamp '2001-02-21 06:33:20.008700'), to_date('2005-04-01 14:32:11','yyyy-mm-dd hh24:mi:ss'), '2004-07-17', NULL, NULL, '12:15:33', '2000', (Timestamp '2004-08-09 09:53:33.035383'), '2005', 6, to_date('2009-07-22 08:10:44','yyyy-mm-dd hh24:mi:ss')) INTO outer_11 VALUES ('2004-09-08 00:10:31', to_date('2001-07-28','yyyy-mm-dd'), to_date('2007-11-24','yyyy-mm-dd'), to_date('2009-11-25','yyyy-mm-dd'), NULL, NULL, '2000', '2008', 2, to_date('2003-12-17 18:41:04','yyyy-mm-dd hh24:mi:ss'), '17:17:27', 8, (Timestamp '2003-03-28 13:19:26.051097'), (Timestamp '2006-10-24 20:49:46.036795'), '2002', NULL, NULL, '2009', '2005', NULL, '2009-05-06', 3, (Timestamp '2003-01-27 09:29:30.043459')) INTO outer_11 VALUES ('2002', (Timestamp '2000-07-17 21:07:33.049300'), NULL, to_date('2008-05-16 01:18:56','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, '2002', NULL, 3, to_date('2007-04-09 11:15:01','yyyy-mm-dd hh24:mi:ss'), '2006-06-28 08:12:26', 102, (Timestamp '2009-07-11 08:01:21.061258'), to_date('2000-06-03 09:57:51','yyyy-mm-dd hh24:mi:ss'), '2004-01-20 23:40:07', NULL, NULL, '2005-01-07', '2009-04-07 06:08:55', (Timestamp '2001-12-24 05:57:02.025702'), '2009-04-02', 9, (Timestamp '2008-09-08 10:26:39.065205')) INTO outer_11 VALUES ('2009', (Timestamp '2000-04-02 00:51:53.003232'), to_date('2004-01-10','yyyy-mm-dd'), to_date('2009-04-01','yyyy-mm-dd'), NULL, NULL, NULL, '2003', 4, NULL, '2005-03-02', NULL, (Timestamp '2000-04-23 07:01:26.000734'), to_date('2002-02-11 18:01:07','yyyy-mm-dd hh24:mi:ss'), '2005-06-24', NULL, NULL, 'bffo', '2003', (Timestamp '2009-02-24 13:06:07.038499'), '19:40:53', NULL, to_date('2007-05-15','yyyy-mm-dd')) INTO outer_11 VALUES ('2003', (Timestamp '2009-11-11 13:51:09.065024'), (Timestamp '2007-02-10 04:56:00.007249'), to_date('2002-12-06','yyyy-mm-dd'), NULL, NULL, NULL, '19:02:36', 5, NULL, '2009', -32761, to_date('2005-01-04','yyyy-mm-dd'), (Timestamp '2004-03-06 23:16:30.000522'), '2007', NULL, NULL, '2006-03-18 03:31:52', '', (Timestamp '2008-01-19 11:47:02.025832'), '2004', -106, (Timestamp '2004-07-06 18:37:04.055487')) INTO outer_11 VALUES ('2008', (Timestamp '2008-02-01 15:20:32.055631'), NULL, (Timestamp '2005-12-11 11:42:55.060479'), NULL, NULL, '2000', '2000-11-07', 6, NULL, '2009-10-25 23:32:01', NULL, to_date('2008-11-09 06:51:01','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2006-07-26 12:38:45.025368'), '2004-12-18 00:02:55', NULL, NULL, '2002', '2002', (Timestamp '2008-09-26 01:11:54.010616'), '22:41:25', 7, (Timestamp '2008-09-13 19:17:36.047139')) INTO outer_11 VALUES ('fbffo', (Timestamp '2008-12-16 00:28:32.016012'), NULL, (Timestamp '2002-12-06 09:09:32.038273'), NULL, NULL, '2000', '2006', 7, to_date('2001-04-12 07:22:49','yyyy-mm-dd hh24:mi:ss'), 'k', -11, NULL, NULL, 'bkfbffouktz', NULL, NULL, '04:49:18', '10:41:32', to_date('2000-01-24','yyyy-mm-dd'), '2008-02-21', -7, (Timestamp '2006-10-08 15:59:50.032989')) INTO outer_11 VALUES ('', to_date('2007-07-16 00:21:46','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2009-04-28 13:24:05.058167'), NULL, NULL, NULL, 'vbkfbff', NULL, 8, (Timestamp '2009-01-22 14:42:25.059778'), '2007-09-10', 9, NULL, (Timestamp '2001-02-06 03:53:00.056894'), '2002', NULL, NULL, '2004-11-19', 'q', to_date('2006-07-07','yyyy-mm-dd'), '2000', 652, NULL) INTO outer_11 VALUES ('2000', (Timestamp '2007-04-14 07:12:39.028824'), NULL, (Timestamp '2009-04-06 19:57:06.029291'), NULL, NULL, '2002-08-18 10:04:15', '2001', 9, (Timestamp '2005-05-15 12:52:54.064873'), '2005-07-17', -20259, (Timestamp '2007-02-13 04:42:06.026596'), to_date('2003-02-07 10:13:05','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, NULL, NULL, '14:08:34', (Timestamp '2002-08-26 14:52:47.052967'), '2004-11-27 11:54:13', NULL, (Timestamp '2006-11-07 22:30:04.007701')) INTO outer_11 VALUES ('', (Timestamp '2000-10-13 04:01:23.038654'), to_date('2007-05-05 14:42:28','yyyy-mm-dd hh24:mi:ss'), to_date('2001-04-24','yyyy-mm-dd'), NULL, NULL, '07:49:42', '2002-07-19 15:31:01', 10, (Timestamp '2002-11-14 21:59:46.038048'), 'yqvbkfbff', 6, to_date('2004-06-06 12:19:27','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2007-11-21 17:17:07.017113'), 'xyqvbkfbffou', NULL, NULL, '', '2005', to_date('2009-09-03','yyyy-mm-dd'), '2009-11-05 08:13:07', NULL, NULL) INTO outer_11 VALUES ('2001', (Timestamp '2004-03-03 18:33:56.005741'), (Timestamp '2003-11-08 19:56:57.016203'), (Timestamp '2006-04-04 23:37:24.037571'), NULL, NULL, NULL, NULL, 11, (Timestamp '2004-12-08 11:27:01.009901'), '2003-03-13', -3848, (Timestamp '2000-12-22 23:38:08.027971'), to_date('2000-03-13 17:04:52','yyyy-mm-dd hh24:mi:ss'), '2009-02-20', NULL, NULL, 'dxyqvb', 'hdxy', to_date('2009-05-15 11:38:27','yyyy-mm-dd hh24:mi:ss'), '00:22:10', 8, (Timestamp '2000-10-27 06:30:04.059947')) INTO outer_11 VALUES (NULL, NULL, to_date('2006-07-17','yyyy-mm-dd'), to_date('2002-12-16','yyyy-mm-dd'), NULL, NULL, '2003', '08:00:07', 12, NULL, NULL, 6, (Timestamp '2003-01-28 03:42:00.023419'), (Timestamp '2004-10-06 08:23:17.003452'), NULL, NULL, NULL, '00:34:18', '2000', to_date('2006-01-09','yyyy-mm-dd'), '2001-07-19 13:59:28', 28542, to_date('2009-04-20','yyyy-mm-dd')) INTO outer_11 VALUES ('ihdx', NULL, to_date('2009-01-02','yyyy-mm-dd'), to_date('2001-05-14 22:26:26','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, '2007', '2008-04-26', 13, (Timestamp '2007-04-24 14:15:19.031895'), '', 65, NULL, to_date('2002-11-04 14:04:10','yyyy-mm-dd hh24:mi:ss'), '12:12:20', NULL, NULL, '2007', '2009-02-16 11:12:25', NULL, 'lihdxyqvbkfbf', -17971, (Timestamp '2009-09-04 19:34:12.033548')) INTO outer_11 VALUES ('2004-09-26', to_date('2004-03-04 04:40:23','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2003-10-01 11:27:20.044177'), to_date('2007-08-12 10:51:52','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, '', '23:16:37', 14, (Timestamp '2003-12-19 11:40:16.047463'), '2008-10-14', NULL, (Timestamp '2000-06-21 18:56:06.030134'), (Timestamp '2000-09-16 17:05:13.005175'), '2009', NULL, NULL, '2002', '2004', to_date('2008-02-26','yyyy-mm-dd'), '2002-04-14', -70, to_date('2008-01-21 03:12:11','yyyy-mm-dd hh24:mi:ss')) INTO outer_11 VALUES ('llihdxyqvbkfbffouktz', to_date('2000-08-06','yyyy-mm-dd'), NULL, (Timestamp '2007-07-04 22:50:44.033179'), NULL, NULL, '2008', '', 15, (Timestamp '2009-01-20 03:41:16.022124'), NULL, 0, to_date('2003-06-21','yyyy-mm-dd'), (Timestamp '2008-02-25 15:31:40.054117'), '2006-06-12', NULL, NULL, NULL, '2003', to_date('2008-10-19','yyyy-mm-dd'), '2000-06-11', NULL, (Timestamp '2003-04-27 23:02:42.024150')) INTO outer_11 VALUES ('', NULL, (Timestamp '2005-12-16 19:42:30.015042'), (Timestamp '2008-06-05 21:12:56.054913'), NULL, NULL, '2002', '2008', 16, to_date('2003-08-06 00:20:10','yyyy-mm-dd hh24:mi:ss'), '2007-02-23', NULL, to_date('2000-05-18 23:56:01','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2009-11-28 15:48:31.039792'), '', NULL, NULL, '2005', NULL, (Timestamp '2006-04-08 07:36:33.002275'), '', 5, to_date('2005-07-25','yyyy-mm-dd')) INTO outer_11 VALUES ('2002', to_date('2007-06-18','yyyy-mm-dd'), (Timestamp '2004-01-01 12:38:05.030574'), NULL, NULL, NULL, NULL, '2005', 17, to_date('2001-05-13','yyyy-mm-dd'), '2003-02-07 10:54:47', -31250, (Timestamp '2006-03-26 12:53:47.042876'), (Timestamp '2006-09-28 16:25:06.000987'), NULL, NULL, NULL, '2004-11-03', '23:26:05', to_date('2006-12-23','yyyy-mm-dd'), '', NULL, (Timestamp '2009-05-17 22:22:05.025559')) INTO outer_11 VALUES ('07:17:06', (Timestamp '2009-09-17 10:25:42.027370'), NULL, NULL, NULL, NULL, NULL, '18:27:15', 18, NULL, 'a', 4, (Timestamp '2004-06-13 18:32:12.037470'), NULL, '2007', NULL, NULL, NULL, 'kallihdxyqvbkfbffouk', to_date('2001-01-12','yyyy-mm-dd'), '', NULL, (Timestamp '2006-05-24 16:57:19.011937')) INTO outer_11 VALUES ('e', to_date('2009-02-20','yyyy-mm-dd'), NULL, (Timestamp '2009-06-16 03:53:55.047363'), NULL, NULL, '2007', '2002-12-26', 19, to_date('2001-09-16','yyyy-mm-dd'), '', 9, (Timestamp '2009-09-06 17:56:04.063094'), (Timestamp '2002-02-05 16:55:17.025780'), NULL, NULL, NULL, '2004-07-05 06:27:26', '01:20:52', to_date('2009-05-12 06:44:13','yyyy-mm-dd hh24:mi:ss'), '2008', 6, NULL) INTO outer_11 VALUES ('', NULL, NULL, (Timestamp '2008-09-07 23:50:24.060622'), NULL, NULL, NULL, '2007', 20, to_date('2003-01-18 17:12:13','yyyy-mm-dd hh24:mi:ss'), '18:53:31', NULL, to_date('2006-09-06 13:01:42','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2004-02-22 12:14:39.057179'), '2009-02-01', NULL, NULL, '2001', 'zeka', NULL, '2008', 124, (Timestamp '2009-09-19 02:13:57.034707')) INTO outer_11 VALUES ('lzekallihdxyqvb', (Timestamp '2002-10-26 17:05:26.022931'), (Timestamp '2007-10-03 03:28:50.015595'), (Timestamp '2004-05-22 12:18:52.057221'), NULL, NULL, '2003-11-08 04:57:39', '2009', 21, (Timestamp '2009-11-26 06:35:09.011785'), '', NULL, (Timestamp '2002-11-14 17:37:33.014591'), (Timestamp '2006-07-02 13:12:00.034134'), '2005-09-21', NULL, NULL, 'qlz', '2004', (Timestamp '2005-12-12 00:31:03.001829'), '11:28:25', 8, (Timestamp '2005-06-20 01:52:27.059879')) INTO outer_11 VALUES (NULL, to_date('2009-10-09 13:38:00','yyyy-mm-dd hh24:mi:ss'), to_date('2006-09-28 22:58:35','yyyy-mm-dd hh24:mi:ss'), to_date('2002-05-18 05:51:40','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, '2007', '09:37:39', 22, (Timestamp '2008-02-23 09:22:06.010385'), '2003', -29042, (Timestamp '2004-09-11 21:43:03.005691'), NULL, '2002', NULL, NULL, NULL, NULL, to_date('2004-10-25','yyyy-mm-dd'), '2007-08-20 01:05:45', 1, to_date('2000-07-12 23:53:39','yyyy-mm-dd hh24:mi:ss')) INTO outer_11 VALUES (NULL, (Timestamp '2004-10-22 15:35:30.026352'), to_date('2003-04-28 07:14:09','yyyy-mm-dd hh24:mi:ss'), to_date('2007-03-20','yyyy-mm-dd'), NULL, NULL, '13:09:58', '2007-07-16 12:17:18', 23, (Timestamp '2009-12-12 20:34:52.061163'), 'fqlz', NULL, (Timestamp '2007-01-15 00:53:00.045804'), (Timestamp '2009-02-06 20:59:34.011050'), '2000', NULL, NULL, '2001', NULL, (Timestamp '2007-05-03 21:22:26.028978'), 'wfqlzekallihdxyqvbkf', -32411, NULL) INTO outer_11 VALUES ('rwfqlzekallihdxyqv', (Timestamp '2004-11-17 02:13:45.003437'), (Timestamp '2008-11-20 18:26:28.055334'), (Timestamp '2008-03-17 22:26:14.048309'), NULL, NULL, '2001-12-04 05:11:53', '2005', 24, (Timestamp '2008-08-20 03:04:20.006629'), '2000-01-21', NULL, (Timestamp '2003-09-18 14:42:58.028791'), (Timestamp '2009-03-20 09:37:24.055215'), '2009', NULL, NULL, 'arwfqlzekallihdxyqv', 'jarwfqlzek', to_date('2001-03-03 03:08:46','yyyy-mm-dd hh24:mi:ss'), '2009-09-04', -41, to_date('2006-05-12','yyyy-mm-dd')) INTO outer_11 VALUES ('', to_date('2005-08-07 05:57:59','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2001-11-19 21:48:40.025802'), (Timestamp '2005-03-26 01:42:35.032299'), NULL, NULL, 'ljarwfqlzekallihd', '2007-02-22 02:45:33', 25, to_date('2002-10-26 00:49:22','yyyy-mm-dd hh24:mi:ss'), '2001-11-18 01:55:08', 7, (Timestamp '2001-09-25 02:05:59.036679'), (Timestamp '2009-05-18 01:50:38.063384'), '', NULL, NULL, NULL, '2004', (Timestamp '2008-07-18 21:34:31.021292'), '2003', 5, to_date('2007-10-13 17:27:42','yyyy-mm-dd hh24:mi:ss')) INTO outer_11 VALUES ('2009', (Timestamp '2001-04-23 23:03:55.045709'), to_date('2000-07-01 12:07:35','yyyy-mm-dd hh24:mi:ss'), to_date('2005-03-10','yyyy-mm-dd'), NULL, NULL, '', '2009', 26, (Timestamp '2002-02-01 11:30:03.052306'), '2000', NULL, to_date('2006-01-23 17:01:46','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2008-02-02 13:21:03.018101'), '04:52:52', NULL, NULL, NULL, NULL, (Timestamp '2000-10-14 23:16:00.062377'), '', 18, (Timestamp '2009-03-11 06:26:48.010396')) INTO outer_11 VALUES ('10:17:27', NULL, (Timestamp '2007-09-08 08:34:27.051846'), (Timestamp '2006-06-15 12:27:17.023450'), NULL, NULL, 'dljarwfq', '2001-08-28', 27, (Timestamp '2002-01-20 15:56:42.002675'), '2007', -3679, to_date('2007-03-13','yyyy-mm-dd'), to_date('2008-04-19 04:18:03','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, NULL, '16:15:33', '00:00:58', to_date('2006-05-02','yyyy-mm-dd'), NULL, 16301, to_date('2005-04-06','yyyy-mm-dd')) INTO outer_11 VALUES ('2004-11-20 17:22:54', (Timestamp '2005-10-15 23:09:57.009632'), (Timestamp '2009-09-05 05:00:19.012407'), (Timestamp '2005-11-15 06:40:39.064062'), NULL, NULL, NULL, NULL, 28, (Timestamp '2003-02-20 20:37:28.051151'), '11:53:50', NULL, (Timestamp '2000-01-20 09:46:40.047145'), to_date('2000-08-07 05:02:55','yyyy-mm-dd hh24:mi:ss'), 'bdljarwf', NULL, NULL, '', '2009-04-04', (Timestamp '2003-11-09 11:49:49.013856'), '2000', -99, (Timestamp '2008-04-24 22:23:45.001262')) INTO outer_11 VALUES ('2003-11-01 13:14:55', (Timestamp '2004-10-25 14:53:03.034396'), (Timestamp '2006-07-07 03:50:53.053726'), to_date('2002-01-16','yyyy-mm-dd'), NULL, NULL, 'cb', '2004', 29, (Timestamp '2007-06-26 05:38:21.044706'), '2007-12-11', 2, (Timestamp '2005-03-17 06:31:26.003715'), to_date('2006-06-14','yyyy-mm-dd'), '05:05:20', NULL, NULL, '2000-06-27 19:47:37', '2000-02-06 15:34:43', (Timestamp '2009-03-24 07:48:12.044666'), '2004', -78, (Timestamp '2008-02-11 11:40:13.002139')) INTO outer_11 VALUES ('', (Timestamp '2006-08-06 13:23:16.020639'), to_date('2006-06-09 07:06:47','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, NULL, NULL, '2003-09-17', 30, (Timestamp '2004-07-08 22:12:15.044322'), '2007', 122, to_date('2009-04-14','yyyy-mm-dd'), (Timestamp '2006-10-23 18:03:31.037944'), '', NULL, NULL, '2002', NULL, (Timestamp '2005-07-12 18:12:15.044725'), 'kc', 59, to_date('2009-04-05 10:17:19','yyyy-mm-dd hh24:mi:ss')) INTO outer_11 VALUES ('2006', (Timestamp '2009-05-23 22:26:17.015593'), NULL, (Timestamp '2009-03-16 10:53:31.001193'), NULL, NULL, '2004-06-12', '2007-08-09', 31, (Timestamp '2009-05-11 16:39:49.001941'), '2003', 6, (Timestamp '2000-06-18 19:49:02.013413'), (Timestamp '2000-02-04 12:01:44.051371'), '2005-11-04', NULL, NULL, '2000-06-12', '2009-03-12 11:05:26', NULL, '', -23, (Timestamp '2001-02-03 11:25:13.065087')) INTO outer_11 VALUES ('tkcbdljarwfqlzek', NULL, (Timestamp '2001-04-01 06:40:14.003353'), NULL, NULL, NULL, NULL, '2007-03-22 07:56:04', 32, (Timestamp '2000-03-18 04:16:25.056352'), '2004-10-01', 22666, NULL, NULL, '2003-10-22', NULL, NULL, '', '2006-08-19', (Timestamp '2008-01-07 05:34:57.051810'), '2000', 6, (Timestamp '2008-02-05 19:10:59.019001')) INTO outer_11 VALUES ('2003-05-28 04:12:18', NULL, to_date('2009-04-16','yyyy-mm-dd'), (Timestamp '2006-10-16 03:16:09.036393'), NULL, NULL, '', NULL, 33, (Timestamp '2008-12-13 14:27:26.062071'), NULL, 60, (Timestamp '2004-10-06 08:59:15.029091'), to_date('2002-11-01','yyyy-mm-dd'), 'utkcbdljarwfq', NULL, NULL, '2007-01-27 23:58:20', '2004-03-02', (Timestamp '2001-09-27 12:37:36.037021'), NULL, 9, to_date('2009-05-24','yyyy-mm-dd')) INTO outer_11 VALUES ('2008-01-06', (Timestamp '2007-02-27 12:47:05.026759'), (Timestamp '2004-08-01 10:24:32.008276'), to_date('2001-02-26','yyyy-mm-dd'), NULL, NULL, '', '2007', 34, NULL, NULL, 7, (Timestamp '2006-08-01 15:48:19.044087'), NULL, '12:23:02', NULL, NULL, '2004-06-01 19:04:09', '2006-07-13', NULL, '', 8, to_date('2000-11-09','yyyy-mm-dd')) INTO outer_11 VALUES ('', NULL, (Timestamp '2004-11-05 01:27:39.025611'), (Timestamp '2005-07-17 16:04:49.050133'), NULL, NULL, '2009-02-06', '2008', 35, NULL, '2006-03-17', NULL, NULL, (Timestamp '2005-02-10 12:23:21.017517'), 'kutkc', NULL, NULL, '07:47:11', '', to_date('2003-06-26','yyyy-mm-dd'), '15:52:35', -846, (Timestamp '2009-03-25 12:28:19.010123')) INTO outer_11 VALUES ('', (Timestamp '2008-05-23 17:20:37.052896'), NULL, to_date('2005-09-05 13:38:48','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, '', '2002-06-24 13:56:36', 36, to_date('2001-01-10 08:54:19','yyyy-mm-dd hh24:mi:ss'), '2003-10-07', -93, (Timestamp '2001-03-10 06:02:46.011393'), to_date('2003-05-09 16:38:38','yyyy-mm-dd hh24:mi:ss'), '', NULL, NULL, '2003', '2002', to_date('2000-02-13 21:39:17','yyyy-mm-dd hh24:mi:ss'), NULL, 2, (Timestamp '2002-12-08 20:04:07.044718')) INTO outer_11 VALUES ('2009', to_date('2008-04-09 15:48:37','yyyy-mm-dd hh24:mi:ss'), to_date('2006-07-26 18:40:08','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2008-03-12 22:44:21.047958'), NULL, NULL, NULL, '2009', 37, NULL, '2008', 3, (Timestamp '2000-12-23 05:43:45.038163'), (Timestamp '2005-08-17 18:06:47.016275'), '', NULL, NULL, '2009', '2005', to_date('2007-11-24 02:03:50','yyyy-mm-dd hh24:mi:ss'), '2002', 6, (Timestamp '2000-07-12 11:23:10.051050')) INTO outer_11 VALUES ('2005', to_date('2001-11-14 05:23:15','yyyy-mm-dd hh24:mi:ss'), (Timestamp '2000-04-28 20:27:09.007496'), to_date('2002-01-19 15:33:35','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, '', '2008-06-22', 38, (Timestamp '2000-02-12 06:04:16.024501'), '2006-08-12', 30595, (Timestamp '2006-02-02 11:32:20.001222'), NULL, '', NULL, NULL, '', '2005', (Timestamp '2004-07-27 13:58:34.000127'), '05:19:22', 9, (Timestamp '2003-11-21 05:20:14.025734')) INTO outer_11 VALUES ('2000-01-25', (Timestamp '2008-01-10 07:03:08.022316'), to_date('2005-08-21','yyyy-mm-dd'), (Timestamp '2005-08-19 06:28:40.042104'), NULL, NULL, '2004', '23:44:04', 39, to_date('2006-08-04 02:50:28','yyyy-mm-dd hh24:mi:ss'), 'kkutkcbdljarwf', 1, (Timestamp '2005-07-22 08:03:07.004390'), to_date('2004-12-11','yyyy-mm-dd'), 'gkkutk', NULL, NULL, '2002-03-27', '', NULL, '', 8, (Timestamp '2005-02-24 10:06:51.027860')) INTO outer_11 VALUES ('17:51:23', (Timestamp '2008-12-18 05:25:03.054712'), (Timestamp '2003-01-17 16:21:49.056445'), to_date('2006-03-23 00:05:42','yyyy-mm-dd hh24:mi:ss'), NULL, NULL, '2004', '2006-03-03', 40, (Timestamp '2005-07-10 20:03:35.042898'), '01:03:12', 2, (Timestamp '2005-09-25 04:35:21.044598'), NULL, '09:18:52', NULL, NULL, '01:19:01', '2007', (Timestamp '2001-04-28 00:03:29.015620'), NULL, 9, (Timestamp '2006-12-22 15:28:07.014843')) SELECT 1 FROM DUAL; ``` ## 问题原因 改写 BUG，做 `where subquery pullup` 后 part hint 丢失了。 ## 问题的风险及原因 SQL 查询结果不正确。 ## 影响租户 影响 OceanBase 数据库中的 Oracle 租户和 MySQL 租户，对于 SYS 租户无影响。 ## 影响版本 OceanBase 数据库企业版 V2.2.77 GA（oceanbase-2.2.77-20210508211731）及之后版本。 ## 解决方法及规避方式 升级至问题已修复版本。目前已修复的版本包括 OceanBase 数据库企业版 V2.2.77 BP14（oceanbase-2.2.77-114000072022120410）。 - 加 `/*+ NO_REWRITE */` Hint。 Previous [merge into xxxx when xxxx insert 报错 ORA-00904: invalid identifier 'A.A' in 'field list'](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000002393581) Next [使用 PDML 且涉及多表时导致正确性问题](https://www.oceanbase.com/knowledge-base/oceanbase-database-1000000000008227) ![有帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*y6ocSqN8cqsAAAAAAAAAAAAAARQnAQ)![无帮助](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*BG9IQJyLHF8AAAAAAAAAAAAAARQnAQ)![反馈](https://gw.alipayobjects.com/mdn/ob_asset/afts/img/A*eTWdQKCRKHwAAAAAAAAAAAAAARQnAQ)[AI](https://www.oceanbase.com/obi) 咨询热线