duerwuyi opened a new issue, #37851:
URL: https://github.com/apache/shardingsphere/issues/37851
## Bug Report
### Which version of ShardingSphere did you use?
shardingsphere-proxy 5.5.2
postgres 17.6 as backend
### Expected behavior
In PG 17.6, the query should return 26 rows of `false`, 17 rows of `true`
and 24 rows of `null`.
```sql
select
(ref_0.c37) between (ref_0.c40) and (pg_catalog.bit_or(ref_0.c37) over
(partition by ref_0.c36 order by ref_0.vkey asc, ref_0.pkey asc, ref_0.c36 asc,
ref_0.c37 asc, ref_0.c38 desc, ref_0.c39 desc, ref_0.c40 asc, ref_0.c41 asc,
ref_0.c42 asc, ref_0.c43 desc)) as c_0
from
t21 as ref_0
where ((ref_0.c41) is not null) is not null
order by c_0;
```
### Actual behavior
shardingsphere returns 19 rows of `false`, 23 rows of `true` and 25 rows of
`null`, when `t21` is shraded.
### Reason analyze (If you can)
When executing through ShardingSphere (distributed/sharded), the output
boolean results (c_0) differ from the single-node / direct PostgreSQL
execution. In my case, the total row count is the same, but the number of
true/false results differs (some rows flip between t and f).
This appears to be caused by ShardingSphere pushing down the window function
query to each physical shard independently and then merging results, which is
not semantically equivalent when the window partition key (c36) is not aligned
with the sharding key (colocated_key). If rows with the same c36 exist across
multiple shards, the correct PostgreSQL window semantics require a global
partition + global ordering, not per-shard local computation.
Log:
```log
[INFO ] 2026-01-26 10:25:59.206 [ShardingSphere-Command-453]
ShardingSphere-SQL - Actual SQL: ds_0 ::: select
(ref_0.c37) between (ref_0.c40) and (pg_catalog.bit_or(ref_0.c37) over
(partition by ref_0.c36 order by ref_0.vkey asc, ref_0.pkey asc, ref_0.c36 asc,
ref_0.c37 asc, ref_0.c38 desc, ref_0.c39 desc, ref_0.c40 asc, ref_0.c41 asc,
ref_0.c42 asc, ref_0.c43 desc)) as c_0
from
t21_5 as ref_0
where ((ref_0.c41) is not null) is not null
order by c_0;
[INFO ] 2026-01-26 10:25:59.206 [ShardingSphere-Command-453]
ShardingSphere-SQL - Actual SQL: ds_1 ::: select
(ref_0.c37) between (ref_0.c40) and (pg_catalog.bit_or(ref_0.c37) over
(partition by ref_0.c36 order by ref_0.vkey asc, ref_0.pkey asc, ref_0.c36 asc,
ref_0.c37 asc, ref_0.c38 desc, ref_0.c39 desc, ref_0.c40 asc, ref_0.c41 asc,
ref_0.c42 asc, ref_0.c43 desc)) as c_0
from
t21_1 as ref_0
where ((ref_0.c41) is not null) is not null
order by c_0;
[INFO ] 2026-01-26 10:25:59.206 [ShardingSphere-Command-453]
ShardingSphere-SQL - Actual SQL: ds_1 ::: select
(ref_0.c37) between (ref_0.c40) and (pg_catalog.bit_or(ref_0.c37) over
(partition by ref_0.c36 order by ref_0.vkey asc, ref_0.pkey asc, ref_0.c36 asc,
ref_0.c37 asc, ref_0.c38 desc, ref_0.c39 desc, ref_0.c40 asc, ref_0.c41 asc,
ref_0.c42 asc, ref_0.c43 desc)) as c_0
from
t21_6 as ref_0
where ((ref_0.c41) is not null) is not null
order by c_0;
[INFO ] 2026-01-26 10:25:59.206 [ShardingSphere-Command-453]
ShardingSphere-SQL - Actual SQL: ds_2 ::: select
(ref_0.c37) between (ref_0.c40) and (pg_catalog.bit_or(ref_0.c37) over
(partition by ref_0.c36 order by ref_0.vkey asc, ref_0.pkey asc, ref_0.c36 asc,
ref_0.c37 asc, ref_0.c38 desc, ref_0.c39 desc, ref_0.c40 asc, ref_0.c41 asc,
ref_0.c42 asc, ref_0.c43 desc)) as c_0
from
t21_2 as ref_0
where ((ref_0.c41) is not null) is not null
order by c_0;
[INFO ] 2026-01-26 10:25:59.206 [ShardingSphere-Command-453]
ShardingSphere-SQL - Actual SQL: ds_2 ::: select
(ref_0.c37) between (ref_0.c40) and (pg_catalog.bit_or(ref_0.c37) over
(partition by ref_0.c36 order by ref_0.vkey asc, ref_0.pkey asc, ref_0.c36 asc,
ref_0.c37 asc, ref_0.c38 desc, ref_0.c39 desc, ref_0.c40 asc, ref_0.c41 asc,
ref_0.c42 asc, ref_0.c43 desc)) as c_0
from
t21_7 as ref_0
where ((ref_0.c41) is not null) is not null
order by c_0;
[INFO ] 2026-01-26 10:25:59.206 [ShardingSphere-Command-453]
ShardingSphere-SQL - Actual SQL: ds_3 ::: select
(ref_0.c37) between (ref_0.c40) and (pg_catalog.bit_or(ref_0.c37) over
(partition by ref_0.c36 order by ref_0.vkey asc, ref_0.pkey asc, ref_0.c36 asc,
ref_0.c37 asc, ref_0.c38 desc, ref_0.c39 desc, ref_0.c40 asc, ref_0.c41 asc,
ref_0.c42 asc, ref_0.c43 desc)) as c_0
from
t21_3 as ref_0
where ((ref_0.c41) is not null) is not null
order by c_0;
[INFO ] 2026-01-26 10:25:59.206 [ShardingSphere-Command-453]
ShardingSphere-SQL - Actual SQL: ds_4 ::: select
(ref_0.c37) between (ref_0.c40) and (pg_catalog.bit_or(ref_0.c37) over
(partition by ref_0.c36 order by ref_0.vkey asc, ref_0.pkey asc, ref_0.c36 asc,
ref_0.c37 asc, ref_0.c38 desc, ref_0.c39 desc, ref_0.c40 asc, ref_0.c41 asc,
ref_0.c42 asc, ref_0.c43 desc)) as c_0
from
t21_4 as ref_0
where ((ref_0.c41) is not null) is not null
order by c_0;
```
### Steps to reproduce the behavior, such as: SQL to execute, sharding rule
configuration, when exception occur etc.
[ss_postgres.zip](https://github.com/user-attachments/files/24228864/ss_postgres.zip)
run `docker compose up -d` in this file.
SQL to execute first:
```sql
CREATE SHARDING TABLE RULE t21 (
STORAGE_UNITS(ds_0,ds_1,ds_2,ds_3,ds_4),
SHARDING_COLUMN=colocated_key,TYPE(NAME="HASH_MOD",PROPERTIES(
"sharding-count"="8"))
);
DROP TABLE IF EXISTS t21;
create table t21 (
vkey int4 ,
pkey int4 ,
c36 numeric ,
c37 int4 ,
c38 text ,
c39 numeric ,
c40 int4 ,
c41 int4 ,
c42 numeric ,
c43 numeric ,
colocated_key numeric
);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10877, 10887000, -1246674693.8889, null::int4, 'M!B3HU5q', 724394685.23219,
-66, 463679616, null::numeric, -421951710.13177, -0.0);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10879, 10889000, null::numeric, 152095832, 'wK|Z5Ms i+EzZtI+>Jq5Aff`XGP+*',
1648365.25068, null::int4, null::int4, 872701505.6235, null::numeric, 0.0);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10880, 10890000, 814990146.7866, 758828286, '8~{F4FWJ^c70<',
-1091228638.5620, 0, 1958765715, 0.78, 1212685981.19038, -71.89);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10881, 10891000, -3003685.13692, 0, ';l9&Voc#SvV9q W=6z<U@PVFvKA',
-441421334.26603, -0, 1742291185, 531715415.10506, null::numeric,
-858078043.31423);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10882, 10892000, 149193544.4793, 80334031, 'rZ`EpaK)', 862352466.7881,
812598657, 47375065, null::numeric, -17.74, -1415847224.26812);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10883, 10893000, -931046694.9646, 0, '^rsp!', -127246642.32516, -0, -0,
-79.37, -100452781.23804, 1748689925.1443);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10884, 10894000, 23.9, 920279031, '.=h:`?D2WsalWrV,7LYG2/L?',
null::numeric, null::int4, -0, null::numeric, -249052825.16239, 0.0);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10885, 10895000, null::numeric, -972667273, '= UP/#7(gWm8a#tT$',
1405099803.21691, -1570656541, 817535507, 44.6, 406821741.7238, -44.65);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10886, 10896000, 9.58, -7, 'tAJhva9(9:Ys9iujInSyu$g m;I+o', 18.83,
null::int4, 63, -1015121106.3652, -286576357.7221, -1722690237.23476);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10887, 10897000, 488315928.29959, -0, 'aNI35)=', -723806110.25950,
281530122, null::int4, -850804060.10946, 1836022817.24552, 340912127.20258);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10888, 10898000, 453546788.2476, -114982659, ';v7PLa&[5[231t:6m.<l2Z-8',
755359661.25005, null::int4, 1726472445, 118127377.3153, 1787280799.27060,
-79.65);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10889, 10899000, 0.0, -32, 'odyz-&0/<B-;$[@A5K[KT3$', 548351853.16582,
892240696, 1266790392, -1346986721.13175, null::numeric, 742052176.27605);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10890, 10900000, -18.62, 1264141791, '^g$F&EYKr', 0.0, 249810006, 0,
1680185990.7104, 755520638.20570, -1517164360.15636);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10891, 10901000, null::numeric, -0, 'P7h4i~4@v`nXt', 1708254304.18678, -0,
-78, -1758936021.15030, 52.45, 0.0);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10892, 10902000, 72.81, -38, '5EdXd)9`$+F<0TIQm9y!!S6XI', -93.36,
2000489850, 0, 523617989.19885, -1237503724.4751, 616872669.27122);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10894, 10904000, -908097170.2523, null::int4, 'Do*+', -0.0, -9, -0,
1794263118.9992, -1519225788.15372, 0.0);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10895, 10905000, 1804419150.14872, -27, '0*@`fM4eEN6x9:Vgd', null::numeric,
null::int4, 815501458, null::numeric, 1193716102.21251, 84.56);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10896, 10906000, 7.60, 48, '', 0.0, 609014282, -37, -344020426.14198,
1655868834.17375, -2071701470.32408);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10897, 10907000, -40.32, 2103631489, '=#afIG:hc>W', -311709245.926,
null::int4, null::int4, 1852180700.2184, 1074039721.4636, -1434002653.23375);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10898, 10908000, -0.0, 963047599, '=uL', -0.0, -0, -1493242568,
null::numeric, 0.0, -691968584.26829);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10899, 10909000, 90.56, 98, '!b-<Lx96BYTm/E/?9S+NN : ', -1213763459.32339,
-702218978, 163220995, -1975042604.14060, -96.85, 1003421275.14215);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10900, 10910000, 864548793.8614, null::int4, 'TTnO.8QR2^^H[OVIKm]5F}hN',
0.0, 1602379917, -541680224, -1842517302.11042, null::numeric, -23.46);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10901, 10911000, -1561673794.30166, 1686907272, 'y5{5ym', null::numeric,
80, 70, -47.15, -612690361.19783, -376884921.32023);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10902, 10912000, -2077714873.17621, null::int4, '7r{$#HU8Tqi&
4!f?,#=cU4R$YI', 378652181.20828, 693771253, 589169487, -1022479255.31251,
1658292373.4770, -555792934.17686);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10903, 10913000, -166178683.3250, -341086176, 'W-/f$OLlsLa', 75.78, 41, 0,
1071860118.12054, null::numeric, 18.1);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10904, 10914000, 96.97, -406694602, '8),}$8qD!#{]@]2DM7LSwr7TW)*-/', 0.0,
597885888, 2082133905, 0.0, 0.0, 1338057079.3005);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10905, 10915000, 0.0, 770266051, 'n9MVAHG#HFZ5', -352547529.2441,
2005583614, 926909346, -86.81, -73.61, 87.84);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10906, 10916000, -0.0, -394427987, null::text, -77.75, 0, -940190197,
-2111805037.26184, 1782848203.8840, 1336899660.5976);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10907, 10917000, 27.88, 1156117150, '<OL&XTV-0<`I^Y/1XAET[',
1715836916.25740, 41, 492655490, -1731717689.4926, 1896169268.27178, -67.57);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10908, 10918000, 78298572.31210, 1999116701, 'd4u8-:>MM;vX0]5:h]o;',
-850153152.2993, 1952431516, 0, null::numeric, 28.8, -0.0);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10909, 10919000, 1574197275.24006, 1087521812, ',SfYu XCb`w-Nl5',
1552694864.18635, 21, 808754699, -1737257895.29395, -15.18, -1692623585.27018);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10911, 10921000, -91.14, 1075471135, null::text, -633047468.11025,
null::int4, 2102116802, null::numeric, null::numeric, -1869034326.30658);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10912, 10922000, -0.0, 1339728953, '}{t1U#zQ:O}0GyO>pp=JBbc', 51.86,
null::int4, 0, -1230821387.25869, -48.27, -75521564.18062);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10913, 10923000, -50.2, null::int4, '[84T:,', 58.91, -42, -0,
837739895.12459, null::numeric, -498690696.26604);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10914, 10924000, 0.0, 1607535544, '2xVX|', 2137136051.30661, -45, -44,
32.46, -1556784402.2623, -186546048.7207);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10917, 10927000, -1158190847.12091, 1690930591, 'jD/NxZa4B', 97.14, -87,
null::int4, -1581643771.3477, 773687215.21163, -1170979776.10979);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10918, 10928000, -104635991.11678, 1521675348, 'm2bDPvS<Wy~',
1632653185.25749, -1317985244, 408733151, 264573915.16982, -1964096334.21664,
-30.28);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10919, 10929000, 0.0, 1183869496, 'GgQ@2y2~hbI', 573459743.30190, -80,
505960782, null::numeric, -1279727233.106, -31.56);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10920, 10930000, -0.0, 1532689859, null::text, 9.91, 84, 842707278, 96.83,
453329910.10234, 1594806217.6319);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10921, 10931000, -171860132.7243, null::int4, 'e$', -181136710.3316,
null::int4, null::int4, -292328137.2536, 210641143.20757, -1294834843.25500);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10922, 10932000, 0.0, -0, 'M', 1810853653.4124, -24, 1631892441,
1880800594.23444, 1683988381.28172, -64.80);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10923, 10933000, -71.39, 54, null::text, 2066840815.1582, null::int4,
1708015151, -1070687516.26982, 890381548.17347, -56.5);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10924, 10934000, 939649812.9523, -729876579, 'QK$ F:|<A', 39.71,
-1762221967, -981899467, 499141525.28901, 596570051.2837, 98.26);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10925, 10935000, -1435123648.14427, -68, 'VsM5z2N4', 65.77, 93,
-1442934198, -1867874529.17323, -1302854545.25465, -1404555725.6545);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10926, 10936000, -694898946.6895, -0, 'P:H', -1375665768.26442,
-1245785304, 938782462, -53.51, -1346380948.23931, -57.39);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10927, 10937000, null::numeric, 1847148438, 'uHMRI4m~Y;9&|K', -26.8,
225147530, 617163406, null::numeric, null::numeric, -55.11);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10928, 10938000, 412331963.18736, 1, 'iISYl(P>Pn 0]sTwe?/:+jNP<&Th`',
-744093883.32126, null::int4, 10, -70.59, 580735488.12537, -1601060994.31547);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10929, 10939000, 249185539.27081, null::int4,
'n`|0^Y*cB(K9.o!:)$#i/[2&l,3q', 2049158475.29794, 967839342, 1047331309,
956098869.9391, 0.0, -50.52);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10930, 10940000, 129702427.24522, -55, null::text, -84.51, 99, 0, 63.11,
null::numeric, 0.0);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10931, 10941000, 13.54, -25, 'Fz9;44e', -275157583.31162, null::int4,
1436888334, -2078774743.1044, -69.67, 1621868407.159);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10932, 10942000, -1206422807.16074, 115524494, ':sU=U]1[p /M<', 68.65, -70,
-1774616259, -784981018.3123, 1814575776.1913, -55.27);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10933, 10943000, 1745053756.9372, 1936484043, 'M.U@MZ1CWPWaUD|2S*C/W',
-1851927101.560, 0, -0, -57.40, -61.95, -0.0);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10934, 10944000, null::numeric, -1244472298, '/ OJJ5i[x<50a1qZ$E-/Obu:13J',
-1600215351.31117, -85, 0, -1461672246.31566, 6.44, 24.51);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10935, 10945000, 0.0, 908813173, null::text, 528188682.25462, 2085014584,
912707446, -1803953239.20711, null::numeric, 26.63);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10936, 10946000, -1850517626.27626, -1915632799,
'G-m6k!,CBW!PJ+wYEz,9gFFn,($', null::numeric, 69, 0, -427203728.20923,
null::numeric, 305679756.12654);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10938, 10948000, -31.24, null::int4, 'kB', 32.33, null::int4, 1298252701,
-321482674.22711, -1543542063.13100, -1508891509.10686);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10940, 10950000, 60.97, null::int4, '>Y]', -18.77, -46, 95, -0.0, 0.0,
-0.0);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10941, 10951000, 7.87, 448852400, '^w9:-5WAMZs#z.>q6*]Ol',
1419472502.17506, 108462673, -40, 33.88, 202669903.14353, 717869729.15948);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10942, 10952000, 1321246560.5972, null::int4, 'ZM[4Qta]D[ZW3^]B',
1427917682.21969, -84, 25, 51.60, null::numeric, 642964820.29290);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10943, 10953000, 59.18, -1766681444, '1rXcdaW', 71.72, 0, 1325619571,
2096540983.23316, 738349540.27858, 1386111506.21380);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10944, 10954000, -30.15, 70, 'D{.v?F^-', 1330499060.17027, 1217987559,
180268892, 803266043.13058, 2054486159.18082, 0.0);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10945, 10955000, 1441732247.19805, -557302689, 'b3:RYd*,]P>xLp', 2.41,
1713149937, 50, -91.55, -0.0, -44.30);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10946, 10956000, -99.47, 606162160, '3J=ROWZ1Kw^q@Yqht6=}HC',
859014113.516, null::int4, 1714361085, -0.0, null::numeric, 433426056.19098);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10947, 10957000, 85.26, 1050953495, 's}?`=-@OgzW#[531SY1Kakl', -0.0,
1568053134, 1387285468, -990332067.7949, -74.97, 47.35);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10948, 10958000, -65.56, 54, ']]r1vE?]GHaD* +V9I', 68.32, null::int4, -66,
-1297577702.1363, -138206935.2925, 1411609223.9615);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10949, 10959000, null::numeric, -2005473843, 'I,;Q#fx(rVW<|!pN.cL37', 0.0,
null::int4, 1453286359, -1552008798.2134, -476674759.5331, -80.14);
insert into t21 (vkey, pkey, c36, c37, c38, c39, c40, c41, c42, c43,
colocated_key) values
(10951, 10961000, -0.0, null::int4, null::text, 1986527838.12920, 0, 20,
0.0, null::numeric, 38.73);
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail:
[email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
