github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/opt/exec/execbuilder/testdata/distsql_indexjoin (about)

     1  # LogicTest: 5node
     2  
     3  statement ok
     4  CREATE TABLE t (k INT PRIMARY KEY, v INT, w INT, INDEX v(v))
     5  
     6  # Split the index into 5 parts, as if numbers were in the range 1 to 100.
     7  statement ok
     8  ALTER INDEX t@v SPLIT AT SELECT (i * 10)::int FROM generate_series(1, 4) AS g(i)
     9  
    10  # Relocate the five parts to the five nodes.
    11  statement ok
    12  ALTER INDEX t@v EXPERIMENTAL_RELOCATE
    13    SELECT ARRAY[i+1], (i * 10)::int FROM generate_series(0, 4) AS g(i)
    14  
    15  query TTTI colnames
    16  SELECT start_key, end_key, replicas, lease_holder from [SHOW RANGES FROM INDEX t@v]
    17  ----
    18  start_key  end_key  replicas  lease_holder
    19  NULL       /10      {1}       1
    20  /10        /20      {2}       2
    21  /20        /30      {3}       3
    22  /30        /40      {4}       4
    23  /40        NULL     {5}       5
    24  
    25  query T
    26  SELECT url FROM [EXPLAIN (DISTSQL) SELECT * FROM t WHERE v > 10 AND v < 50]
    27  ----
    28  https://cockroachdb.github.io/distsqlplan/decode.html#eJyMkEFr4zAQhe_7K4Z3ShYtK-9SKDolNA41pE5qG1pIfVDtIRgcy5Xk0hL830vspKGHQo_zvqfRxxzgXmoopOEqvMmoszUtk_UdbcPHzWoexTRZRGmW3q-mdKr8HgueHm7DJKTJKz11Uv5nCuSU5vHiMynoSk5zCDSm5Fjv2UFtESAXaK0p2Dljj9FhKETlG5QUqJq288c4FyiMZagDfOVrhkKmn2tOWJds_0oIlOx1VQ9rW1vttX2feQikrW6coj8QWFa1Z6toMvt30VRKRXF2fbI9k6PumSDvBUznLyrO6x1DBb34uW7CrjWN4y-m322WfS7A5Y7HkzjT2YI31hTDN-O4Ht4NQcnOjzQYh6gZUZ_3vz4CAAD__x43j38=
    29  
    30  query T
    31  SELECT url FROM [EXPLAIN (DISTSQL) SELECT * FROM t WHERE v > 10 AND v < 50 ORDER BY v]
    32  ----
    33  https://cockroachdb.github.io/distsqlplan/decode.html#eJyUkM9L40AUx-_7Vzzeqd2dpZMsCzKnVptioKY1CajUHMbkUQJpJs5MilLyv0uS1lqhosf3_TUfZofmuUCBkTf3rmKodQGzcHEDK-9-OZ_4AQymfhRHt_Mh7CO_-4CFu2sv9GCwhcea838EDh_CJJi-Kyn850NYhFMvhMsH2CbIsFQZBXJDBsUKHUwYVlqlZIzSrbTrAn72goIzzMuqtq2cMEyVJhQ7tLktCAXG8qmgkGRGesSRYUZW5kU3W-l8I_Xr2CLDqJKlEfAXGc7ywpIWMBi7R2IhhB_EF3vwg9OSHxxMGoaqtkcUY-WaUDgN-z5upLQlPXJOScfun7Pz7k_mQzKVKg2dzJ9b5k3CkLI19T9uVK1TWmqVds_056LrdUJGxvau0x9-2Vst4Mey82XZ_VROml9vAQAA__9mWsVp
    34  
    35  # Here we care about ordering by v, but v is not otherwise used.
    36  query T
    37  SELECT url FROM [EXPLAIN (DISTSQL) SELECT w FROM t WHERE v > 10 AND v < 50 ORDER BY v]
    38  ----
    39  https://cockroachdb.github.io/distsqlplan/decode.html#eJyUkd9Lg1AUx9_7Kw7naaMbU0cQ98nVHAlLlwoVywfTwxCc1-69rmL4v4e6tRYs6vF-f5zvB-4W1WuBHENn7txEUMsCZoF_B0vncTGfuB4Mpm4YhffzIewib31Aw8OtEzgw2MBzbRhjAtMYwsSbfikpXBpD8IOpE8D1E2xiZFiKjLxkTQr5Ek2MGVZSpKSUkK207QJu9o7cYJiXVa1bOWaYCknIt6hzXRByjJKXggJKMpIjAxlmpJO86M5WMl8n8sPWyDCsklJxuECGs7zQJDkMbOtAzDl3vehqB753WvK9gwz9WnOwLWaPMW4YilofuJROVoTcbNjf2UMhNcmReYxtm-eHrZND1n-GAlKVKBUdDZ26bDQxQ8pW1H-EErVMaSFF2s30T7_rdUJGSveu2T_csrdawO9l89ey9aMcN2efAQAA__-T88s8
    40  
    41  # The single join reader should be on node 5, and doesn't need to output v.
    42  query T
    43  SELECT url FROM [EXPLAIN (DISTSQL) SELECT w FROM t WHERE v > 40 AND v < 50 ORDER BY v]
    44  ----
    45  https://cockroachdb.github.io/distsqlplan/decode.html#eJyUkcGOmzAQhu99itGcEskRBpKLT0kbqlKlkEKktko5UBhFSART26RdRbz7Coh2k5XC7h79-__ms8Zn1H9LFBh7G-_TDhpVwuco_AZ77-d2s_IDmKz9eBd_30zhUvk3FAz8-OJFHkxO8Lvh3CWY8ymsgvVTksGCTyGM1l4EH3_BKUGGlcwpSI-kUezRRoYLTBjWSmaktVRdfO5Lfv4fBWdYVHVjujhhmElFKM5oClMSCgzkTNaWgwxzMmlR9rWWoWzMM6RNeiAUbsuuBtvjg3fpn5IiSnNSFr8Zj6elQYZxnVZagDW3Z9aia4SNEbC08Z7efo_-qyyqi92-tdeqOKbqoX_DoHTvKp0b5SurjEjXstL0pl3yNmFI-YGG79KyURltlcx6zXAMe64PctJmuHWHg18NV90Dr2F7FHbGYWcU5i_gpP3wGAAA___-4PGJ