Details
-
Bug
-
Status: Confirmed (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.13, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.11, 11.4, 11.8, 12.3, 13.0, 13.1, 13.2
-
None
Description
Hi, I have a question about partition reorganizing while I'm trying to test.
I use LIST COLUMNS type and DEFAULT partition.
I want to split (reorganize) specific value of DEFAULT partition into other new partitions.
Here is the script.
CREATE TABLE PAR_TEST (COL VARCHAR(6)); |
|
|
ALTER TABLE PAR_TEST PARTITION BY LIST COLUMNS (COL) ( |
PARTITION P_00000 VALUES IN ('00000'), |
PARTITION P_00001 VALUES IN ('00001'), |
PARTITION P_00002 VALUES IN ('00002'), |
PARTITION P_00003 VALUES IN ('00003'), |
PARTITION P_00004 VALUES IN ('00004'), |
PARTITION P_DEFAULT DEFAULT); |
|
|
INSERT INTO PAR_TEST |
VALUES ('00000'),('00001'),('00002'),('00003'),('00004'),('11111'),('22222'),('22222'), ('TEST'), ('TEST1'); |
<TEST1>
|
ALTER TABLE PAR_TEST
|
REORGANIZE PARTITION P_DEFAULT INTO
|
(PARTITION P_DEFAULT DEFAULT, PARTITION P_11111 VALUES IN ('11111'), PARTITION P_22222 VALUES IN ('22222')
|
);
|
|
|
<TEST2>
|
ALTER TABLE PAR_TEST
|
REORGANIZE PARTITION P_DEFAULT INTO
|
(PARTITION P_11111 VALUES IN ('11111'), PARTITION P_22222 VALUES IN ('22222'),PARTITION P_DEFAULT DEFAULT
|
);
|
The only difference between TEST1 AND TEST2 is just the order of 'P_11111' and 'P_DEFAULT'
in REORGANIZE PARTITION clause.
When I select a certain partition, TEST1 shows the result what I expected.
But, If I select DEFAULT partition, it shows nothing.
(SELECT * FROM PAR_TEST PARTITION(P_DEFAULT); -> no result)
And the values which should be in DEFAULT partition are in 'P_11111' partition.
(SELECT * FROM PAR_TEST PARTITION(P_11111); -> 11111, TEST, TEST1 (3 rows))
Original env: Centos 7 (no longer applicable)
I wonder if it is intended or bug. Thank you.
Attachments
Issue Links
- relates to
-
-
- Open
-
-
-
- Open
-
