BUG #18729: update with multiple subpartitions return error: too many range table entries - Mailing list pgsql-bugs
| From | PG Bug reporting form |
|---|---|
| Subject | BUG #18729: update with multiple subpartitions return error: too many range table entries |
| Date | |
| Msg-id | 18729-9bd4c9ec46c39848@postgresql.org Whole thread Raw |
| Responses |
Re: BUG #18729: update with multiple subpartitions return error: too many range table entries
|
| List | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 18729 Logged by: chunling qin Email address: 303677365@qq.com PostgreSQL version: 13.1 Operating system: centos Description: DROP TABLE if exists rqg_table3 cascade; CREATE TABLE rqg_table3 ( c0 int, c1 int, c2 text, c3 text, c4 date, c5 date, c6 timestamp, c7 timestamp, c8 numeric, c9 numeric) PARTITION BY hash( c2) ; create TABLE rqg_table3_p0 partition of rqg_table3 for values with(modulus 50,remainder 0) PARTITION BY hash( c2); create TABLE rqg_table3_p0_p0 partition of rqg_table3_p0 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p0_p1 partition of rqg_table3_p0 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p0_p2 partition of rqg_table3_p0 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p0_p3 partition of rqg_table3_p0 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p0_p4 partition of rqg_table3_p0 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p0_p5 partition of rqg_table3_p0 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p0_p6 partition of rqg_table3_p0 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p0_p7 partition of rqg_table3_p0 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p0_p8 partition of rqg_table3_p0 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p0_p9 partition of rqg_table3_p0 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p1 partition of rqg_table3 for values with(modulus 50,remainder 1) PARTITION BY hash( c2); create TABLE rqg_table3_p1_p0 partition of rqg_table3_p1 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p1_p1 partition of rqg_table3_p1 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p1_p2 partition of rqg_table3_p1 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p1_p3 partition of rqg_table3_p1 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p1_p4 partition of rqg_table3_p1 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p1_p5 partition of rqg_table3_p1 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p1_p6 partition of rqg_table3_p1 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p1_p7 partition of rqg_table3_p1 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p1_p8 partition of rqg_table3_p1 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p1_p9 partition of rqg_table3_p1 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p2 partition of rqg_table3 for values with(modulus 50,remainder 2) PARTITION BY hash( c2); create TABLE rqg_table3_p2_p0 partition of rqg_table3_p2 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p2_p1 partition of rqg_table3_p2 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p2_p2 partition of rqg_table3_p2 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p2_p3 partition of rqg_table3_p2 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p2_p4 partition of rqg_table3_p2 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p2_p5 partition of rqg_table3_p2 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p2_p6 partition of rqg_table3_p2 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p2_p7 partition of rqg_table3_p2 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p2_p8 partition of rqg_table3_p2 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p2_p9 partition of rqg_table3_p2 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p3 partition of rqg_table3 for values with(modulus 50,remainder 3) PARTITION BY hash( c2); create TABLE rqg_table3_p3_p0 partition of rqg_table3_p3 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p3_p1 partition of rqg_table3_p3 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p3_p2 partition of rqg_table3_p3 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p3_p3 partition of rqg_table3_p3 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p3_p4 partition of rqg_table3_p3 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p3_p5 partition of rqg_table3_p3 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p3_p6 partition of rqg_table3_p3 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p3_p7 partition of rqg_table3_p3 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p3_p8 partition of rqg_table3_p3 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p3_p9 partition of rqg_table3_p3 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p4 partition of rqg_table3 for values with(modulus 50,remainder 4) PARTITION BY hash( c2); create TABLE rqg_table3_p4_p0 partition of rqg_table3_p4 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p4_p1 partition of rqg_table3_p4 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p4_p2 partition of rqg_table3_p4 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p4_p3 partition of rqg_table3_p4 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p4_p4 partition of rqg_table3_p4 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p4_p5 partition of rqg_table3_p4 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p4_p6 partition of rqg_table3_p4 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p4_p7 partition of rqg_table3_p4 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p4_p8 partition of rqg_table3_p4 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p4_p9 partition of rqg_table3_p4 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p5 partition of rqg_table3 for values with(modulus 50,remainder 5) PARTITION BY hash( c2); create TABLE rqg_table3_p5_p0 partition of rqg_table3_p5 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p5_p1 partition of rqg_table3_p5 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p5_p2 partition of rqg_table3_p5 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p5_p3 partition of rqg_table3_p5 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p5_p4 partition of rqg_table3_p5 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p5_p5 partition of rqg_table3_p5 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p5_p6 partition of rqg_table3_p5 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p5_p7 partition of rqg_table3_p5 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p5_p8 partition of rqg_table3_p5 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p5_p9 partition of rqg_table3_p5 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p6 partition of rqg_table3 for values with(modulus 50,remainder 6) PARTITION BY hash( c2); create TABLE rqg_table3_p6_p0 partition of rqg_table3_p6 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p6_p1 partition of rqg_table3_p6 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p6_p2 partition of rqg_table3_p6 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p6_p3 partition of rqg_table3_p6 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p6_p4 partition of rqg_table3_p6 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p6_p5 partition of rqg_table3_p6 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p6_p6 partition of rqg_table3_p6 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p6_p7 partition of rqg_table3_p6 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p6_p8 partition of rqg_table3_p6 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p6_p9 partition of rqg_table3_p6 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p7 partition of rqg_table3 for values with(modulus 50,remainder 7) PARTITION BY hash( c2); create TABLE rqg_table3_p7_p0 partition of rqg_table3_p7 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p7_p1 partition of rqg_table3_p7 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p7_p2 partition of rqg_table3_p7 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p7_p3 partition of rqg_table3_p7 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p7_p4 partition of rqg_table3_p7 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p7_p5 partition of rqg_table3_p7 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p7_p6 partition of rqg_table3_p7 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p7_p7 partition of rqg_table3_p7 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p7_p8 partition of rqg_table3_p7 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p7_p9 partition of rqg_table3_p7 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p8 partition of rqg_table3 for values with(modulus 50,remainder 8) PARTITION BY hash( c2); create TABLE rqg_table3_p8_p0 partition of rqg_table3_p8 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p8_p1 partition of rqg_table3_p8 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p8_p2 partition of rqg_table3_p8 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p8_p3 partition of rqg_table3_p8 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p8_p4 partition of rqg_table3_p8 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p8_p5 partition of rqg_table3_p8 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p8_p6 partition of rqg_table3_p8 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p8_p7 partition of rqg_table3_p8 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p8_p8 partition of rqg_table3_p8 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p8_p9 partition of rqg_table3_p8 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p9 partition of rqg_table3 for values with(modulus 50,remainder 9) PARTITION BY hash( c2); create TABLE rqg_table3_p9_p0 partition of rqg_table3_p9 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p9_p1 partition of rqg_table3_p9 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p9_p2 partition of rqg_table3_p9 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p9_p3 partition of rqg_table3_p9 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p9_p4 partition of rqg_table3_p9 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p9_p5 partition of rqg_table3_p9 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p9_p6 partition of rqg_table3_p9 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p9_p7 partition of rqg_table3_p9 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p9_p8 partition of rqg_table3_p9 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p9_p9 partition of rqg_table3_p9 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p10 partition of rqg_table3 for values with(modulus 50,remainder 10) PARTITION BY hash( c2); create TABLE rqg_table3_p10_p0 partition of rqg_table3_p10 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p10_p1 partition of rqg_table3_p10 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p10_p2 partition of rqg_table3_p10 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p10_p3 partition of rqg_table3_p10 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p10_p4 partition of rqg_table3_p10 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p10_p5 partition of rqg_table3_p10 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p10_p6 partition of rqg_table3_p10 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p10_p7 partition of rqg_table3_p10 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p10_p8 partition of rqg_table3_p10 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p10_p9 partition of rqg_table3_p10 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p11 partition of rqg_table3 for values with(modulus 50,remainder 11) PARTITION BY hash( c2); create TABLE rqg_table3_p11_p0 partition of rqg_table3_p11 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p11_p1 partition of rqg_table3_p11 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p11_p2 partition of rqg_table3_p11 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p11_p3 partition of rqg_table3_p11 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p11_p4 partition of rqg_table3_p11 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p11_p5 partition of rqg_table3_p11 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p11_p6 partition of rqg_table3_p11 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p11_p7 partition of rqg_table3_p11 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p11_p8 partition of rqg_table3_p11 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p11_p9 partition of rqg_table3_p11 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p12 partition of rqg_table3 for values with(modulus 50,remainder 12) PARTITION BY hash( c2); create TABLE rqg_table3_p12_p0 partition of rqg_table3_p12 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p12_p1 partition of rqg_table3_p12 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p12_p2 partition of rqg_table3_p12 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p12_p3 partition of rqg_table3_p12 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p12_p4 partition of rqg_table3_p12 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p12_p5 partition of rqg_table3_p12 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p12_p6 partition of rqg_table3_p12 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p12_p7 partition of rqg_table3_p12 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p12_p8 partition of rqg_table3_p12 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p12_p9 partition of rqg_table3_p12 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p13 partition of rqg_table3 for values with(modulus 50,remainder 13) PARTITION BY hash( c2); create TABLE rqg_table3_p13_p0 partition of rqg_table3_p13 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p13_p1 partition of rqg_table3_p13 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p13_p2 partition of rqg_table3_p13 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p13_p3 partition of rqg_table3_p13 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p13_p4 partition of rqg_table3_p13 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p13_p5 partition of rqg_table3_p13 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p13_p6 partition of rqg_table3_p13 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p13_p7 partition of rqg_table3_p13 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p13_p8 partition of rqg_table3_p13 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p13_p9 partition of rqg_table3_p13 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p14 partition of rqg_table3 for values with(modulus 50,remainder 14) PARTITION BY hash( c2); create TABLE rqg_table3_p14_p0 partition of rqg_table3_p14 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p14_p1 partition of rqg_table3_p14 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p14_p2 partition of rqg_table3_p14 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p14_p3 partition of rqg_table3_p14 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p14_p4 partition of rqg_table3_p14 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p14_p5 partition of rqg_table3_p14 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p14_p6 partition of rqg_table3_p14 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p14_p7 partition of rqg_table3_p14 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p14_p8 partition of rqg_table3_p14 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p14_p9 partition of rqg_table3_p14 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p15 partition of rqg_table3 for values with(modulus 50,remainder 15) PARTITION BY hash( c2); create TABLE rqg_table3_p15_p0 partition of rqg_table3_p15 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p15_p1 partition of rqg_table3_p15 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p15_p2 partition of rqg_table3_p15 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p15_p3 partition of rqg_table3_p15 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p15_p4 partition of rqg_table3_p15 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p15_p5 partition of rqg_table3_p15 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p15_p6 partition of rqg_table3_p15 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p15_p7 partition of rqg_table3_p15 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p15_p8 partition of rqg_table3_p15 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p15_p9 partition of rqg_table3_p15 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p16 partition of rqg_table3 for values with(modulus 50,remainder 16) PARTITION BY hash( c2); create TABLE rqg_table3_p16_p0 partition of rqg_table3_p16 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p16_p1 partition of rqg_table3_p16 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p16_p2 partition of rqg_table3_p16 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p16_p3 partition of rqg_table3_p16 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p16_p4 partition of rqg_table3_p16 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p16_p5 partition of rqg_table3_p16 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p16_p6 partition of rqg_table3_p16 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p16_p7 partition of rqg_table3_p16 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p16_p8 partition of rqg_table3_p16 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p16_p9 partition of rqg_table3_p16 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p17 partition of rqg_table3 for values with(modulus 50,remainder 17) PARTITION BY hash( c2); create TABLE rqg_table3_p17_p0 partition of rqg_table3_p17 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p17_p1 partition of rqg_table3_p17 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p17_p2 partition of rqg_table3_p17 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p17_p3 partition of rqg_table3_p17 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p17_p4 partition of rqg_table3_p17 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p17_p5 partition of rqg_table3_p17 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p17_p6 partition of rqg_table3_p17 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p17_p7 partition of rqg_table3_p17 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p17_p8 partition of rqg_table3_p17 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p17_p9 partition of rqg_table3_p17 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p18 partition of rqg_table3 for values with(modulus 50,remainder 18) PARTITION BY hash( c2); create TABLE rqg_table3_p18_p0 partition of rqg_table3_p18 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p18_p1 partition of rqg_table3_p18 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p18_p2 partition of rqg_table3_p18 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p18_p3 partition of rqg_table3_p18 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p18_p4 partition of rqg_table3_p18 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p18_p5 partition of rqg_table3_p18 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p18_p6 partition of rqg_table3_p18 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p18_p7 partition of rqg_table3_p18 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p18_p8 partition of rqg_table3_p18 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p18_p9 partition of rqg_table3_p18 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p19 partition of rqg_table3 for values with(modulus 50,remainder 19) PARTITION BY hash( c2); create TABLE rqg_table3_p19_p0 partition of rqg_table3_p19 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p19_p1 partition of rqg_table3_p19 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p19_p2 partition of rqg_table3_p19 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p19_p3 partition of rqg_table3_p19 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p19_p4 partition of rqg_table3_p19 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p19_p5 partition of rqg_table3_p19 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p19_p6 partition of rqg_table3_p19 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p19_p7 partition of rqg_table3_p19 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p19_p8 partition of rqg_table3_p19 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p19_p9 partition of rqg_table3_p19 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p20 partition of rqg_table3 for values with(modulus 50,remainder 20) PARTITION BY hash( c2); create TABLE rqg_table3_p20_p0 partition of rqg_table3_p20 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p20_p1 partition of rqg_table3_p20 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p20_p2 partition of rqg_table3_p20 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p20_p3 partition of rqg_table3_p20 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p20_p4 partition of rqg_table3_p20 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p20_p5 partition of rqg_table3_p20 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p20_p6 partition of rqg_table3_p20 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p20_p7 partition of rqg_table3_p20 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p20_p8 partition of rqg_table3_p20 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p20_p9 partition of rqg_table3_p20 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p21 partition of rqg_table3 for values with(modulus 50,remainder 21) PARTITION BY hash( c2); create TABLE rqg_table3_p21_p0 partition of rqg_table3_p21 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p21_p1 partition of rqg_table3_p21 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p21_p2 partition of rqg_table3_p21 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p21_p3 partition of rqg_table3_p21 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p21_p4 partition of rqg_table3_p21 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p21_p5 partition of rqg_table3_p21 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p21_p6 partition of rqg_table3_p21 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p21_p7 partition of rqg_table3_p21 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p21_p8 partition of rqg_table3_p21 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p21_p9 partition of rqg_table3_p21 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p22 partition of rqg_table3 for values with(modulus 50,remainder 22) PARTITION BY hash( c2); create TABLE rqg_table3_p22_p0 partition of rqg_table3_p22 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p22_p1 partition of rqg_table3_p22 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p22_p2 partition of rqg_table3_p22 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p22_p3 partition of rqg_table3_p22 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p22_p4 partition of rqg_table3_p22 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p22_p5 partition of rqg_table3_p22 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p22_p6 partition of rqg_table3_p22 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p22_p7 partition of rqg_table3_p22 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p22_p8 partition of rqg_table3_p22 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p22_p9 partition of rqg_table3_p22 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p23 partition of rqg_table3 for values with(modulus 50,remainder 23) PARTITION BY hash( c2); create TABLE rqg_table3_p23_p0 partition of rqg_table3_p23 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p23_p1 partition of rqg_table3_p23 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p23_p2 partition of rqg_table3_p23 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p23_p3 partition of rqg_table3_p23 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p23_p4 partition of rqg_table3_p23 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p23_p5 partition of rqg_table3_p23 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p23_p6 partition of rqg_table3_p23 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p23_p7 partition of rqg_table3_p23 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p23_p8 partition of rqg_table3_p23 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p23_p9 partition of rqg_table3_p23 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p24 partition of rqg_table3 for values with(modulus 50,remainder 24) PARTITION BY hash( c2); create TABLE rqg_table3_p24_p0 partition of rqg_table3_p24 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p24_p1 partition of rqg_table3_p24 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p24_p2 partition of rqg_table3_p24 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p24_p3 partition of rqg_table3_p24 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p24_p4 partition of rqg_table3_p24 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p24_p5 partition of rqg_table3_p24 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p24_p6 partition of rqg_table3_p24 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p24_p7 partition of rqg_table3_p24 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p24_p8 partition of rqg_table3_p24 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p24_p9 partition of rqg_table3_p24 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p25 partition of rqg_table3 for values with(modulus 50,remainder 25) PARTITION BY hash( c2); create TABLE rqg_table3_p25_p0 partition of rqg_table3_p25 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p25_p1 partition of rqg_table3_p25 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p25_p2 partition of rqg_table3_p25 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p25_p3 partition of rqg_table3_p25 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p25_p4 partition of rqg_table3_p25 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p25_p5 partition of rqg_table3_p25 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p25_p6 partition of rqg_table3_p25 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p25_p7 partition of rqg_table3_p25 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p25_p8 partition of rqg_table3_p25 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p25_p9 partition of rqg_table3_p25 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p26 partition of rqg_table3 for values with(modulus 50,remainder 26) PARTITION BY hash( c2); create TABLE rqg_table3_p26_p0 partition of rqg_table3_p26 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p26_p1 partition of rqg_table3_p26 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p26_p2 partition of rqg_table3_p26 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p26_p3 partition of rqg_table3_p26 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p26_p4 partition of rqg_table3_p26 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p26_p5 partition of rqg_table3_p26 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p26_p6 partition of rqg_table3_p26 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p26_p7 partition of rqg_table3_p26 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p26_p8 partition of rqg_table3_p26 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p26_p9 partition of rqg_table3_p26 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p27 partition of rqg_table3 for values with(modulus 50,remainder 27) PARTITION BY hash( c2); create TABLE rqg_table3_p27_p0 partition of rqg_table3_p27 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p27_p1 partition of rqg_table3_p27 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p27_p2 partition of rqg_table3_p27 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p27_p3 partition of rqg_table3_p27 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p27_p4 partition of rqg_table3_p27 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p27_p5 partition of rqg_table3_p27 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p27_p6 partition of rqg_table3_p27 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p27_p7 partition of rqg_table3_p27 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p27_p8 partition of rqg_table3_p27 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p27_p9 partition of rqg_table3_p27 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p28 partition of rqg_table3 for values with(modulus 50,remainder 28) PARTITION BY hash( c2); create TABLE rqg_table3_p28_p0 partition of rqg_table3_p28 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p28_p1 partition of rqg_table3_p28 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p28_p2 partition of rqg_table3_p28 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p28_p3 partition of rqg_table3_p28 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p28_p4 partition of rqg_table3_p28 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p28_p5 partition of rqg_table3_p28 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p28_p6 partition of rqg_table3_p28 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p28_p7 partition of rqg_table3_p28 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p28_p8 partition of rqg_table3_p28 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p28_p9 partition of rqg_table3_p28 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p29 partition of rqg_table3 for values with(modulus 50,remainder 29) PARTITION BY hash( c2); create TABLE rqg_table3_p29_p0 partition of rqg_table3_p29 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p29_p1 partition of rqg_table3_p29 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p29_p2 partition of rqg_table3_p29 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p29_p3 partition of rqg_table3_p29 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p29_p4 partition of rqg_table3_p29 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p29_p5 partition of rqg_table3_p29 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p29_p6 partition of rqg_table3_p29 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p29_p7 partition of rqg_table3_p29 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p29_p8 partition of rqg_table3_p29 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p29_p9 partition of rqg_table3_p29 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p30 partition of rqg_table3 for values with(modulus 50,remainder 30) PARTITION BY hash( c2); create TABLE rqg_table3_p30_p0 partition of rqg_table3_p30 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p30_p1 partition of rqg_table3_p30 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p30_p2 partition of rqg_table3_p30 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p30_p3 partition of rqg_table3_p30 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p30_p4 partition of rqg_table3_p30 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p30_p5 partition of rqg_table3_p30 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p30_p6 partition of rqg_table3_p30 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p30_p7 partition of rqg_table3_p30 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p30_p8 partition of rqg_table3_p30 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p30_p9 partition of rqg_table3_p30 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p31 partition of rqg_table3 for values with(modulus 50,remainder 31) PARTITION BY hash( c2); create TABLE rqg_table3_p31_p0 partition of rqg_table3_p31 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p31_p1 partition of rqg_table3_p31 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p31_p2 partition of rqg_table3_p31 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p31_p3 partition of rqg_table3_p31 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p31_p4 partition of rqg_table3_p31 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p31_p5 partition of rqg_table3_p31 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p31_p6 partition of rqg_table3_p31 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p31_p7 partition of rqg_table3_p31 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p31_p8 partition of rqg_table3_p31 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p31_p9 partition of rqg_table3_p31 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p32 partition of rqg_table3 for values with(modulus 50,remainder 32) PARTITION BY hash( c2); create TABLE rqg_table3_p32_p0 partition of rqg_table3_p32 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p32_p1 partition of rqg_table3_p32 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p32_p2 partition of rqg_table3_p32 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p32_p3 partition of rqg_table3_p32 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p32_p4 partition of rqg_table3_p32 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p32_p5 partition of rqg_table3_p32 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p32_p6 partition of rqg_table3_p32 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p32_p7 partition of rqg_table3_p32 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p32_p8 partition of rqg_table3_p32 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p32_p9 partition of rqg_table3_p32 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p33 partition of rqg_table3 for values with(modulus 50,remainder 33) PARTITION BY hash( c2); create TABLE rqg_table3_p33_p0 partition of rqg_table3_p33 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p33_p1 partition of rqg_table3_p33 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p33_p2 partition of rqg_table3_p33 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p33_p3 partition of rqg_table3_p33 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p33_p4 partition of rqg_table3_p33 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p33_p5 partition of rqg_table3_p33 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p33_p6 partition of rqg_table3_p33 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p33_p7 partition of rqg_table3_p33 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p33_p8 partition of rqg_table3_p33 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p33_p9 partition of rqg_table3_p33 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p34 partition of rqg_table3 for values with(modulus 50,remainder 34) PARTITION BY hash( c2); create TABLE rqg_table3_p34_p0 partition of rqg_table3_p34 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p34_p1 partition of rqg_table3_p34 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p34_p2 partition of rqg_table3_p34 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p34_p3 partition of rqg_table3_p34 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p34_p4 partition of rqg_table3_p34 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p34_p5 partition of rqg_table3_p34 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p34_p6 partition of rqg_table3_p34 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p34_p7 partition of rqg_table3_p34 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p34_p8 partition of rqg_table3_p34 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p34_p9 partition of rqg_table3_p34 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p35 partition of rqg_table3 for values with(modulus 50,remainder 35) PARTITION BY hash( c2); create TABLE rqg_table3_p35_p0 partition of rqg_table3_p35 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p35_p1 partition of rqg_table3_p35 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p35_p2 partition of rqg_table3_p35 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p35_p3 partition of rqg_table3_p35 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p35_p4 partition of rqg_table3_p35 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p35_p5 partition of rqg_table3_p35 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p35_p6 partition of rqg_table3_p35 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p35_p7 partition of rqg_table3_p35 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p35_p8 partition of rqg_table3_p35 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p35_p9 partition of rqg_table3_p35 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p36 partition of rqg_table3 for values with(modulus 50,remainder 36) PARTITION BY hash( c2); create TABLE rqg_table3_p36_p0 partition of rqg_table3_p36 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p36_p1 partition of rqg_table3_p36 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p36_p2 partition of rqg_table3_p36 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p36_p3 partition of rqg_table3_p36 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p36_p4 partition of rqg_table3_p36 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p36_p5 partition of rqg_table3_p36 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p36_p6 partition of rqg_table3_p36 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p36_p7 partition of rqg_table3_p36 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p36_p8 partition of rqg_table3_p36 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p36_p9 partition of rqg_table3_p36 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p37 partition of rqg_table3 for values with(modulus 50,remainder 37) PARTITION BY hash( c2); create TABLE rqg_table3_p37_p0 partition of rqg_table3_p37 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p37_p1 partition of rqg_table3_p37 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p37_p2 partition of rqg_table3_p37 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p37_p3 partition of rqg_table3_p37 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p37_p4 partition of rqg_table3_p37 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p37_p5 partition of rqg_table3_p37 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p37_p6 partition of rqg_table3_p37 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p37_p7 partition of rqg_table3_p37 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p37_p8 partition of rqg_table3_p37 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p37_p9 partition of rqg_table3_p37 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p38 partition of rqg_table3 for values with(modulus 50,remainder 38) PARTITION BY hash( c2); create TABLE rqg_table3_p38_p0 partition of rqg_table3_p38 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p38_p1 partition of rqg_table3_p38 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p38_p2 partition of rqg_table3_p38 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p38_p3 partition of rqg_table3_p38 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p38_p4 partition of rqg_table3_p38 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p38_p5 partition of rqg_table3_p38 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p38_p6 partition of rqg_table3_p38 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p38_p7 partition of rqg_table3_p38 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p38_p8 partition of rqg_table3_p38 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p38_p9 partition of rqg_table3_p38 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p39 partition of rqg_table3 for values with(modulus 50,remainder 39) PARTITION BY hash( c2); create TABLE rqg_table3_p39_p0 partition of rqg_table3_p39 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p39_p1 partition of rqg_table3_p39 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p39_p2 partition of rqg_table3_p39 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p39_p3 partition of rqg_table3_p39 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p39_p4 partition of rqg_table3_p39 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p39_p5 partition of rqg_table3_p39 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p39_p6 partition of rqg_table3_p39 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p39_p7 partition of rqg_table3_p39 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p39_p8 partition of rqg_table3_p39 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p39_p9 partition of rqg_table3_p39 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p40 partition of rqg_table3 for values with(modulus 50,remainder 40) PARTITION BY hash( c2); create TABLE rqg_table3_p40_p0 partition of rqg_table3_p40 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p40_p1 partition of rqg_table3_p40 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p40_p2 partition of rqg_table3_p40 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p40_p3 partition of rqg_table3_p40 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p40_p4 partition of rqg_table3_p40 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p40_p5 partition of rqg_table3_p40 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p40_p6 partition of rqg_table3_p40 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p40_p7 partition of rqg_table3_p40 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p40_p8 partition of rqg_table3_p40 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p40_p9 partition of rqg_table3_p40 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p41 partition of rqg_table3 for values with(modulus 50,remainder 41) PARTITION BY hash( c2); create TABLE rqg_table3_p41_p0 partition of rqg_table3_p41 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p41_p1 partition of rqg_table3_p41 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p41_p2 partition of rqg_table3_p41 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p41_p3 partition of rqg_table3_p41 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p41_p4 partition of rqg_table3_p41 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p41_p5 partition of rqg_table3_p41 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p41_p6 partition of rqg_table3_p41 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p41_p7 partition of rqg_table3_p41 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p41_p8 partition of rqg_table3_p41 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p41_p9 partition of rqg_table3_p41 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p42 partition of rqg_table3 for values with(modulus 50,remainder 42) PARTITION BY hash( c2); create TABLE rqg_table3_p42_p0 partition of rqg_table3_p42 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p42_p1 partition of rqg_table3_p42 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p42_p2 partition of rqg_table3_p42 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p42_p3 partition of rqg_table3_p42 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p42_p4 partition of rqg_table3_p42 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p42_p5 partition of rqg_table3_p42 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p42_p6 partition of rqg_table3_p42 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p42_p7 partition of rqg_table3_p42 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p42_p8 partition of rqg_table3_p42 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p42_p9 partition of rqg_table3_p42 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p43 partition of rqg_table3 for values with(modulus 50,remainder 43) PARTITION BY hash( c2); create TABLE rqg_table3_p43_p0 partition of rqg_table3_p43 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p43_p1 partition of rqg_table3_p43 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p43_p2 partition of rqg_table3_p43 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p43_p3 partition of rqg_table3_p43 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p43_p4 partition of rqg_table3_p43 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p43_p5 partition of rqg_table3_p43 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p43_p6 partition of rqg_table3_p43 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p43_p7 partition of rqg_table3_p43 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p43_p8 partition of rqg_table3_p43 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p43_p9 partition of rqg_table3_p43 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p44 partition of rqg_table3 for values with(modulus 50,remainder 44) PARTITION BY hash( c2); create TABLE rqg_table3_p44_p0 partition of rqg_table3_p44 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p44_p1 partition of rqg_table3_p44 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p44_p2 partition of rqg_table3_p44 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p44_p3 partition of rqg_table3_p44 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p44_p4 partition of rqg_table3_p44 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p44_p5 partition of rqg_table3_p44 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p44_p6 partition of rqg_table3_p44 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p44_p7 partition of rqg_table3_p44 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p44_p8 partition of rqg_table3_p44 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p44_p9 partition of rqg_table3_p44 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p45 partition of rqg_table3 for values with(modulus 50,remainder 45) PARTITION BY hash( c2); create TABLE rqg_table3_p45_p0 partition of rqg_table3_p45 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p45_p1 partition of rqg_table3_p45 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p45_p2 partition of rqg_table3_p45 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p45_p3 partition of rqg_table3_p45 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p45_p4 partition of rqg_table3_p45 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p45_p5 partition of rqg_table3_p45 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p45_p6 partition of rqg_table3_p45 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p45_p7 partition of rqg_table3_p45 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p45_p8 partition of rqg_table3_p45 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p45_p9 partition of rqg_table3_p45 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p46 partition of rqg_table3 for values with(modulus 50,remainder 46) PARTITION BY hash( c2); create TABLE rqg_table3_p46_p0 partition of rqg_table3_p46 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p46_p1 partition of rqg_table3_p46 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p46_p2 partition of rqg_table3_p46 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p46_p3 partition of rqg_table3_p46 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p46_p4 partition of rqg_table3_p46 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p46_p5 partition of rqg_table3_p46 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p46_p6 partition of rqg_table3_p46 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p46_p7 partition of rqg_table3_p46 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p46_p8 partition of rqg_table3_p46 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p46_p9 partition of rqg_table3_p46 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p47 partition of rqg_table3 for values with(modulus 50,remainder 47) PARTITION BY hash( c2); create TABLE rqg_table3_p47_p0 partition of rqg_table3_p47 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p47_p1 partition of rqg_table3_p47 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p47_p2 partition of rqg_table3_p47 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p47_p3 partition of rqg_table3_p47 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p47_p4 partition of rqg_table3_p47 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p47_p5 partition of rqg_table3_p47 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p47_p6 partition of rqg_table3_p47 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p47_p7 partition of rqg_table3_p47 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p47_p8 partition of rqg_table3_p47 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p47_p9 partition of rqg_table3_p47 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p48 partition of rqg_table3 for values with(modulus 50,remainder 48) PARTITION BY hash( c2); create TABLE rqg_table3_p48_p0 partition of rqg_table3_p48 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p48_p1 partition of rqg_table3_p48 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p48_p2 partition of rqg_table3_p48 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p48_p3 partition of rqg_table3_p48 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p48_p4 partition of rqg_table3_p48 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p48_p5 partition of rqg_table3_p48 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p48_p6 partition of rqg_table3_p48 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p48_p7 partition of rqg_table3_p48 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p48_p8 partition of rqg_table3_p48 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p48_p9 partition of rqg_table3_p48 for values with(modulus 10,remainder 9); create TABLE rqg_table3_p49 partition of rqg_table3 for values with(modulus 50,remainder 49) PARTITION BY hash( c2); create TABLE rqg_table3_p49_p0 partition of rqg_table3_p49 for values with(modulus 10,remainder 0); create TABLE rqg_table3_p49_p1 partition of rqg_table3_p49 for values with(modulus 10,remainder 1); create TABLE rqg_table3_p49_p2 partition of rqg_table3_p49 for values with(modulus 10,remainder 2); create TABLE rqg_table3_p49_p3 partition of rqg_table3_p49 for values with(modulus 10,remainder 3); create TABLE rqg_table3_p49_p4 partition of rqg_table3_p49 for values with(modulus 10,remainder 4); create TABLE rqg_table3_p49_p5 partition of rqg_table3_p49 for values with(modulus 10,remainder 5); create TABLE rqg_table3_p49_p6 partition of rqg_table3_p49 for values with(modulus 10,remainder 6); create TABLE rqg_table3_p49_p7 partition of rqg_table3_p49 for values with(modulus 10,remainder 7); create TABLE rqg_table3_p49_p8 partition of rqg_table3_p49 for values with(modulus 10,remainder 8); create TABLE rqg_table3_p49_p9 partition of rqg_table3_p49 for values with(modulus 10,remainder 9); CREATE INDEX idx_rqg_table3_c1 ON rqg_table3(c1); CREATE INDEX idx_rqg_table3_c3 ON rqg_table3(c3); CREATE INDEX idx_rqg_table3_c5 ON rqg_table3(c5); CREATE INDEX idx_rqg_table3_c7 ON rqg_table3(c7); CREATE INDEX idx_rqg_table3_c9 ON rqg_table3(c9); INSERT INTO rqg_table3 VALUES (9, 0, 'iqkmzipdbebwcubgsqvlusgfbcjudheivjjyocaripehlxnrrkhcufvyziunhjqvmpxmkknpjrhagqmasajlflngjuybkzaomdidikhzkperlxqmhwdaacjdqzzaotrrndqttmvnhjraacplckmofzlbpfvnqjpgovqseqolwwvlnjuvpmhanhqxyudkjdvfify', 'bar', '2017-03-16', '1978-06-01 21:46:05', NULL, '1996-02-15 02:58:14.050469', -9.984130859375e+80, 1.23456789123457e-09) , (5, 4, NULL, 'foo', '1984-01-05 07:03:08', '2006-02-11 09:24:28', '2016-01-28 06:14:30.055959', '2024-03-26 19:23:21.058920', -1.23456789123457e+44, -1.23456789123457e+39) , (3, 7, NULL, NULL, '1994-04-24', '2005-01-23 14:29:35', '1996-10-18 14:38:17.042773', '2031-12-18 12:51:25', -1.23456789123457e+30, 0.832290649414062) , (0, 1, NULL, 'foo', '2021-08-23 01:43:04', '1978-11-01', '2002-05-01 21:43:02.001700', '1993-12-09 15:26:53.004487', 0.686492919921875, -5.59661865234375e+80) , (2, 4, 'bar', 'qkmzipdbebwcubgsqvlusg', '2027-06-13 16:48:35', '1990-11-26', '2015-01-26 17:27:58.005042', '2003-12-04 18:17:11.049284', 1.23456789123457e+43, -1188036608) ; UPDATE rqg_table3 T2 SET c2 = T2.c2 || '该行序号不正确;' WHERE NOT EXISTS ( SELECT NULL FROM ( SELECT c1, c0, c2 AS RIGHT_NUM FROM rqg_table3 ORDER BY c1 ) T3 WHERE T3.RIGHT_NUM = T2.c2 AND T3.c0 = T2.c0 );
pgsql-bugs by date: