Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-29341

Wrong results for the query with several long IN lists ORed together

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 10.2.27, 10.5.18
    • N/A
    • Optimizer
    • None

    Description

      In general it's expected that the results of the query:

      select PK from T where c1 IN (1, 2, 3, .... );
      

      are the same as:

      select PK from T where c1 = 1
      UNION
      select PK from T where c1 = 2
      UNION
      select PK from T where c1 = 3
      UNION
      ...
      

      and the same as from this query:

      select PK from T where (c1 = 1)
      OR
      (c1 = 2)
      OR
      (c1 = 3)
      OR
      ...
      

      order aside, no matter what indexes are defined on c1 etc and assuming PK column is a PRIMARY KEY.

      Moreover, even if some of conditions are in the form of c2 = N or c1 IN (list of values) and c2 IN (list of values), both ORed and UNIONed versions should still produce the same result order aside (prove me wrong if you can).

      Still, for a specific data set in the innodb table (see formdb1.sql attached) specific queries considered equivalent (order aside), see q11.sql attache and q2.sql attached, do produce different results and it seems ORed version does miss valid rows. Consider the following steps:

      Yuliyas-Air:maria10.5 Valerii$ bin/mysql test </tmp/q11.sql | sort > /tmp/r11.txt
      Yuliyas-Air:maria10.5 Valerii$ bin/mysql test </tmp/q2.sql | sort > /tmp/r2.txt
      Yuliyas-Air:maria10.5 Valerii$ diff -u /tmp/r11.txt /tmp/r2.txt | head -10
      --- /tmp/r11.txt 2022-08-19 16:23:42.000000000 +0300
      +++ /tmp/r2.txt 2022-08-19 16:23:58.000000000 +0300
      @@ -1,39 +1,128 @@
      +00038729db261810f1629ec2ca96199c
      000730bcdbbe7780f1629ec2ca96195d
      +000796281b551154ceefa971604bcbd9
      +000899dedbaed450ca44ff00ba96199a
      +00091031db065090a037d2e3ca96191b
      00095cf0db5534104314e05c8a9619d4
      000bf9701bfcbc90a76a0e966e4bcbde
      

      I took the first row that UNIONEd version (q2.sql) produced, and then checked that '26de9960db29bf80a250a9f7059619c1' is presented in ORed version and compared with parent column:

      Yuliyas-Air:maria10.5 Valerii$ bin/mysql test -e"select * from formdb1 where id ='00038729db261810f1629ec2ca96199c'"
      +----------------------------------+----------------------------------+----------------------------------+
      | id | parent | child |
      +----------------------------------+----------------------------------+----------------------------------+
      | 00038729db261810f1629ec2ca96199c | 26de9960db29bf80a250a9f7059619c1 | 4654b8591b6ad0104639b99e0a4bcbbd |
      +----------------------------------+----------------------------------+----------------------------------+
      Yuliyas-Air:maria10.5 Valerii$ grep -n 26de9960db29bf80a250a9f7059619c1 /tmp/q11.sql
      2: formdb10.`parent` IN ('20cb1351dbabd410ef939f67f496195e' , '20ce7f75db3c249491126451ca9619a4' , '20d3c00adbb0e094568e6ac2ca961932' , '20f2edc41beed8d00420624d6e4bcb58' , '210a00eedb3b1050fcf84c95b996198b' , '210b5c671b54489012e3ece03d4bcbe5' , '210f95a0db29bf80a250a9f705961956' , '210f95a0db29bf80a250a9f705961972' , '211fd9a0db29bf80a250a9f705961930' , '212a83b1dbf8e8949752ab92ca9619cb' , '212e9dacdbe5bf80a250a9f7059619d8' , '212f5da0db29bf80a250a9f7059619b4' , '214e95ecdbe5bf80a250a9f7059619d6' , '214e95ecdbe5bf80a250a9f7059619ed' , '21560406dbbc60d4e09d5e25ca9619ca' , '215804e2dbdf4494f7de166e1396195c' , '215fd9e0db29bf80a250a9f70596193d' , '216b69921bc57050a76a0e966e4bcba7' , '217ac48adb30a0d4e09d5e25ca9619df' , '217fd124db29bf80a250a9f7059619ce' , '2190385bdb942410fcf84c95b996198a' , '2191804edbbc2454822ac8cb139619ef' , '21966df51b11dc500420624d6e4bcbe8' , '21a404c2dbf8a8d438cbe1c2ca9619eb' , '21abbbbddbb860d4ff4e176a4896196c' , '21b2cc02dbb464941ec2d487f496193f' , '21b2cc02dbb464941ec2d487f4961959' , '21b7e70a1b990d90350511b7b04bcb79' , '21c8cc4adb306414bef004c2ca9619a4' , '21d205751b8b68504639b99e0a4bcbad' , '21deaf64db372c10c7dd9b3c8a961965' , '21ed3b7ddb7ca094568e6ac2ca96191a' , '21f7448a1b4e50d00420624d6e4bcb45' , '2200e552dbace050ef939f67f4961986' , '2206c802db7cec94790b69c3ca961997' , '221acf71dbf8e8949752ab92ca961975' , '221b1ca71b54489012e3ece03d4bcbc1' , '221ed9acdbe5bf80a250a9f705961963' , '221fd9a0db29bf80a250a9f7059619e0' , '2221d0581bf7734080af4225bd4bcb22' , '2225cf911bd8285080af4225bd4bcb8f' , '2225e48cdb141418ef939f67f4961959' , '222e11ecdbe5bf80a250a9f705961900' , '2238c3eadb551010a250a9f705961925' , '2239bbb91b382cd4b83d631e6e4bcbf1' , '22643fc01b445cd01b7fb8cc1d4bcb9d' , '226eddecdbe5bf80a250a9f7059619a4' , '226fdde0db29bf80a250a9f7059619ca' , '226fdde0db29bf80a250a9f7059619cf' , '22700cc2db30e094568e6ac2ca961992' , '2278f33f87c6f890e567a86e0ebb3598' , '227d1e7fdb985850fcf84c95b9961941' , '227e2cd287a0c5d4c8bdc84e0ebb3577' , '2291879d870dc950aea4a82d0ebb35f2' , '22a484c2dbf8a8d438cbe1c2ca961979' , '22b0f7131b7224104639b99e0a4bcb48' , '22b8fb35dbb8a094568e6ac2ca961924' , '22bac8061b7020d4dd652f0b234bcb92' , '22c5fb0bdb3300d0ef939f67f49619f6' , '22c997d11b0f3c50f0455420604bcb97' , '22ce9560db29bf80a250a9f7059619f1' , '22db19641b211090a76a0e966e4bcb9d' , '22e6593f1b3051906ab2c998624bcbbb' , '22e680c6dbf0e094568e6ac2ca9619f1' , '22ed7cacdb241490a037d2e3ca961981' , '22fed1a0db29bf80a250a9f70596195d' , '230f19a0db29bf80a250a9f7059619b4' , '231e1dacdbe5bf80a250a9f70596197a' , '2320848edbb4a4180812cf0913961968' , '2327e6badb50dc10a037d2e3ca961905' , '232914f21bb954500420624d6e4bcbe1' , '232c6221db633784a037d2e3ca96196a' , '232f11e0db29bf80a250a9f705961918' , '23395c16db433340a250a9f705961902' , '23466c4c1b613c100420624d6e4bcb68' , '235f1de0db29bf80a250a9f7059619c9' , '235f1de0db29bf80a250a9f7059619d8' , '23674c0e1bf02494f7ccea866e4bcbc4' , '236e1120db29bf80a250a9f70596198c' , '237e1520db29bf80a250a9f705961926' , '237e1520db29bf80a250a9f70596192b' , '2382b2af1bcb9810c144fc8e034bcb2e' , '23960046dbb4a0d4bf30de82ca96193c' , '23978569db54c450ef939f67f49619b3' , '2398a3df1b9250101b7fb8cc1d4bcb76' , '239db371db3c60d4bf30de82ca9619db' , '239e1d20db29bf80a250a9f7059619a9' , '23ae1160db29bf80a250a9f705961907' , '23d1986587d04d507daec88d0ebb3570' , '23e1af791b0a1c501b7fb8cc1d4bcb38' , '23eedd60db29bf80a250a9f705961990' , '23f278581bc9b0980420624d6e4bcbb0' , '23ffd4b6dba69010fcf84c95b9961973' , '240a33611ba1c9945c0711b7b04bcb8b' , '240b8886dbb860106c3de05e1396195a' , '240e55acdbe5bf80a250a9f7059619f2' , '240f55a0db29bf80a250a9f705961961' , '2426cfb7db6e1450a037d2e3ca961956' , '242e5dacdbe5bf80a250a9f7059619bb' , '242f5da0db29bf80a250a9f705961939' , '243be66d1bd860100420624d6e4bcb45' , '2457324fdb27e4d4c7dd9b3c8a96194b' , '246408c2db3860106c3de05e139619f1' , '2482cbfbdb2e1450a037d2e3ca96190f' , '248adfaadbc00054ef939f67f49619ea' , '248e5520db29bf80a250a9f705961901' , '249ff9a31b520190350511b7b04bcbf8' , '24a6c046dbb4a0d4bf30de82ca961962' , '24baea5c8753b450e8afc916cebb351a' , '24c50c8adbb0a0d4ff4e176a4896195f' , '24dd3ff31bed85504f5c11b7b04bcbfd' , '24e94c86db3864941ec2d487f49619cb' , '24eb29101b38885080af4225bd4bcbff' , '24eba7d9dbf588d44ae38a72399619f5' , '24f08b9f1b3819506ab2c998624bcbfb' , '24fe51a0db29bf80a250a9f70596191a' , '250108c2db7860d4e09d5e25ca96195f' , '2509275b1b5ed89080af4225bd4bcb7e' , '250b80c6dbb860106c3de05e139619d3' , '25133e9c1be905545c0711b7b04bcbb8' , '251448421b7cec94dd652f0b234bcbb9' , '2518ff941b534554ceefa971604bcb75' , '252e9dacdbe5bf80a250a9f705961996' , '25329f03db0a5410a250a9f705961922' , '2534a5d71b9c2c10a76a0e966e4bcbc3' , '2546d36edb0b6490b5ce1dca48961937' , '2571c4d81b8349106ab2c998624bcb15' , '257353b4dbd80810a037d2e3ca961991' , '257cfffddbb060106c3de05e139619d6' , '2583dbfddb462410ef68dbc66896191a' , '258ae7f6dbb8e010b5ce1dca48961925' , '25a7be4b1b1109d0350511b7b04bcbc3' , '25ae9d20db29bf80a250a9f705961983' , '25b7c0461bf06cd4b83d631e6e4bcb07' , '25b91eda1bf789d8e87211b7b04bcbb4' , '25bac4c81b49fc580420624d6e4bcbcb' , '25e060f71ba364104639b99e0a4bcb75' , '25f332c9db8de454b384533fd3961952' , '25fe91a0db29bf80a250a9f705961908' , '2609da77dbae7b4042ac5e25ca961973' , '261ed9acdbe5bf80a250a9f705961953' , '261ed9acdbe5bf80a250a9f705961979' , '261fd9a0db29bf80a250a9f7059619b2' , '262010861bb82494f7ccea866e4bcb2a' , '262cbbb5dbf42c54106a6693ca96190c' , '262eddacdbe5bf80a250a9f7059619f6' , '262f9da0db29bf80a250a9f7059619b6' , '263e15ecdbe5bf80a250a9f70596195a' , '2646eafa1b985c101b7fb8cc1d4bcb22' , '264f19e0db29bf80a250a9f70596191e' , '265d7d15dbe3f784a250a9f7059619e1' , '265ed9ecdbe5bf80a250a9f70596199e' , '265ed9ecdbe5bf80a250a9f7059619a9' , '265f1de0db29bf80a250a9f705961919' , '266eddecdbe5bf80a250a9f70596198c' , '266fdde0db29bf80a250a9f7059619d4' , '267f5524db29bf80a250a9f70596196d' , '267f5524db29bf80a250a9f705961989' , '2691844edbbc2454822ac8cb139619bb' , '2691844edbbc2454822ac8cb139619c8' , '269ed920db29bf80a250a9f705961974' , '26b455801b88dd5c3c38c998624bcbe3' , '26de9960db29bf80a250a9f70596195f' , '26de9960db29bf80a250a9f7059619c1' , '26e61f4cdbc76050ef68dbc668961910' , '270a41c8db09a410ca44ff00ba961975' , '270f19a0db29bf80a250a9f7059619b9' , '270f19a0db29bf80a250a9f7059619c8' , '2715169b1b174950738cc998624bcb1a' , '2718ed2f1b613c1cb9bf86ae6e4bcb3a' , '271a03b1dbf8e8949752ab92ca96199f' , '271e1dacdbe5bf80a250a9f70596197f' , '27247730dbc46050a037d2e3ca96198a' , '272fdda0db29bf80a250a9f7059619c7' , '27357f1d1b189110738cc998624bcb17' , '273e55ecdbe5bf80a250a9f70596198f' , '27624ccedb7c6c549b0b9cd5ca96192b' , '276fee4bdbe3e4d4c7dd9b3c8a961948' , '277223f1dbf024941ec2d487f49619bb' , '277ea6861ba8e490a76a0e966e4bcba5' , '277f9524db29bf80a250a9f705961982' , '279e1d20db29bf80a250a9f70596199f' , '279e1d20db29bf80a250a9f7059619a4' , '27a2e7f11b4650d00420624d6e4bcb4b' , '27baebb31b8210901b7fb8cc1d4bcba7' , '27beb775db3c249491126451ca961937' , '27bed160db29bf80a250a9f7059619ca' , '27bed160db29bf80a250a9f7059619ee' , '27c189341baa701c1e91ec65604bcb7a' , '27d487e3dbf19410a037d2e3ca961986' , '27e448c2dbfc6c549b0b9cd5ca9619f4' , '27f2c08adbf860d4e09d5e25ca96193f' , '27fd11a8dbe1bf80a250a9f70596197b' , '280b1c671b54489012e3ece03d4bcb78' , '280f55a0db29bf80a250a9f70596193e' , '281f99a0db29bf80a250a9f705961927' , '28295f3f1b91d05080af4225bd4bcb13' , '282e5dacdbe5bf80a250a9f7059619a4' , '2836a2361bd89c100420624d6e4bcbce' , '283e51ecdbe5bf80a250a9f7059619fb' , '283e91ecdbe5bf80a250a9f705961906' , '284ee1d41bf49c904639b99e0a4bcb7a' , '284f55e0db29bf80a250a9f7059619f4' , '285e59ecdbe5bf80a250a9f7059619f7' , '285f99e0db29bf80a250a9f705961938' , '286648331bd62c104639b99e0a4bcbe1' , '286e5decdbe5bf80a250a9f705961956' , '28733b221b0a50100420624d6e4bcb37' , '287ba410dbe59c50a250a9f705961940' , '288f883bdbe3641093340082ca9619cf' , '288f91ebdb3c9850a037d2e3ca961959' , '28ae4bdf87544dd07daec88d0ebb35ee' , '28af9afa1bff90501b7fb8cc1d4bcbe4' , '28b8ff7f87cabc98318a2f46cebb3546' , '28be1160db29bf80a250a9f7059619f3' , '28be1160db29bf80a250a9f7059619f8' , '28c50c8adbb0a0d4ff4e176a4896196c' , '28ce1560db29bf80a250a9f7059619db' , '28d53035dbdb77c0ef939f67f496191e' , '28de1960db29bf80a250a9f7059619cd' , '28eee2de1bc605106ab2c998624bcbc8' , '28f8d15f1bb7f85c1e91ec65604bcbce' , '290fee0bdba104544ae38a7239961993' , '2912cb8edb9bc818c7dd9b3c8a961914' , '293ed1ecdbe5bf80a250a9f70596194b' , '293f91e0db29bf80a250a9f7059619b9' , '29465269dbc0f8d0ca44ff00ba961913' , '294e95ecdbe5bf80a250a9f7059619f2' , '294ed5ecdbe5bf80a250a9f705961907' , '29598c0adb3ca8d438cbe1c2ca961943' , '296f9de0db29bf80a250a9f7059619ed' , '297ae006dbd118d0ef939f67f4961904' , '297cfffddbb060106c3de05e139619fc' , '297ef3751b7ce094f7ccea866e4bcbeb' , '298880871b320d90caab11b7b04bcbdb' , '298917981b4e05906ab2c998624bcb4f' , '299e9920db29bf80a250a9f70596194a' , '29fe51a0db29bf80a250a9f7059619ec' , '2a06c802db7cec94790b69c3ca9619a4' , '2a0ed5acdbe5bf80a250a9f7059619c3' , '2a0fa9e0876c49d4f5f54226cebb35cf' , '2a0fd5a0db29bf80a250a9f705961993' , '2a1dbf7c97630d98c0c03e0e6253afa8' , '2a39a382db49e0189752ab92ca961990' , '2a453a8a1bbc11542653c998624bcbbe' , '2a6eddecdbe5bf80a250a9f705961977' , '2a6eddecdbe5bf80a250a9f70596197c' , '2a7c7331dbf060106c3de05e139619c7' , '2a7ed120db29bf80a250a9f70596199a' , '2a7f5524db29bf80a250a9f705961972' , '2a8140ce1be01990caab11b7b04bcb69' , '2a8e9520db29bf80a250a9f7059619b4' , '2a8ed520db29bf80a250a9f70596192a' , '2a9fb379dbb4a4180812cf09139619ad' , '2abe9160db29bf80a250a9f7059619d4' , '2aee9d60db29bf80a250a9f7059619cd' , '2aef2b731b6015946ab2c998624bcbaf' , '2afba6e61b47d4141b7fb8cc1d4bcb1b' , '2b078e60db5e2c10c7dd9b3c8a9619fe' , '2b1a68acdbb56c1093340082ca96195d' , '2b1cd1f81b8281d0caab11b7b04bcb1d' , '2b1e1dacdbe5bf80a250a9f705961984' , '2b1e1dacdbe5bf80a250a9f70596199b' , '2b20848edbb4a4180812cf09139619b3' , '2b20848edbb4a4180812cf09139619cd' , '2b2cfbb5dbf42c54106a6693ca961948' , '2b2e51ecdbe5bf80a250a9f70596194d' , '2b2eb7bddbbca814b384533fd39619b7' , '2b3e55ecdbe5bf80a250a9f705961985' , '2b3f55e0db29bf80a250a9f70596192a' , '2b40e8fc1b10ac500420624d6e4bcb2a' , '2b485bc6db81ec10ca44ff00ba961957' , '2b4e19ecdbe5bf80a250a9f7059619db' , '2b5c1986db7ca45093340082ca9619ed' , '2b6d84d4dbf1a810ef68dbc66896198b' , '2b739c351bd61890a76a0e966e4bcb3e' , '2b85fa841ba94914e87211b7b04bcbb1' , '2b8e1920db29bf80a250a9f705961954' , '2bb0840adb38a8d438cbe1c2ca9619fc' , '2bb1615adb009094a037d2e3ca9619d2' , '2bbe5cbadb796c10f1629ec2ca9619c7' , '2bbfa4821bb4685893073112cd4bcb70' , '2bc0c0361be7bc10aae9a975604bcbc1' , '2bd10c0e1bb4689444af4336dc4bcb1a' , '2bd7dbb11bf9cd90dfaec998624bcb3f' , '2bdcbca11b15cd504f5c11b7b04bcbe1' , '2bded960db29bf80a250a9f705961959' , '2be14509dbe6e010ef68dbc6689619de' , '2be6422e1b7a7098598d1173b24bcbcc' , '2befa2bb8780c9509880ecad3fbb35c6' , '2bf2c08adbf860d4e09d5e25ca9619bb' , '2bfaeb6b87bf78dc640b415d0ebb3567' , '2bfed1a0db29bf80a250a9f7059619bd' , '2bffdff9db43441462b6622dca96190d' , '2c004786db01a0d0f1629ec2ca961997' , '2c1d44391b99949080af4225bd4bcb94' , '2c1fa5758739f8907daec88d0ebb353e' , '2c25bfd6dbc16cd491126451ca961949' , '2c30f83bdbdb7344a250a9f705961924' , '2c35024cdbc04890a250a9f705961987' , '2c3f11e0db29bf80a250a9f7059619ff' , '2c4cf55c1bb60190dfaec998624bcb9a' , '2c61a7f6db026010b5ce1dca489619ca' , '2c6f5de0db29bf80a250a9f7059619b3' , '2c6f5de0db29bf80a250a9f7059619cc' , '2c7667ab1b254150caab11b7b04bcbd8' , '2c7f9124db29bf80a250a9f705961954' , '2c8568401ba29cd0a76a0e966e4bcbf7' , '2c8cd755dbabd410ef939f67f49619e8' , '2c8fd524db29bf80a250a9f7059619c1' , '2c974ae21b149d10738cc998624bcb3b' , '2cbe5160db29bf80a250a9f70596192d' , '2cc50c8adbb0a0d4ff4e176a48961986' , '2cd4cf531b1051547df5a971604bcbdc' , '2cd7072c1b7dc990e87211b7b04bcbfa' , '2cdafe6bdb4f9490a037d2e3ca9619cb' , '2cde1960db29bf80a250a9f7059619d2' , '2ceae1778772f850c8bdc84e0ebb350c' , '2cee1d60db29bf80a250a9f7059619ca' , '2cf80bd21b6f7810aae9a975604bcb30' , '2cf85a1087db7450e8afc916cebb35c2' , '2cfe11a0db29bf80a250a9f7059619e7' , '2d01c4c2db7860d4e09d5e25ca9619d3' , '2d068802db7cec94790b69c3ca96192e' , '2d0bae148797bc1077a1ba29cebb353a' , '2d0f95a0db29bf80a250a9f705961941' , '2d0f95a0db29bf80a250a9f705961946' , '2d1448421b7cec94dd652f0b234bcb54' , '2d1d5c5edbf26450ca44ff00ba96199b' , '2d2d86191bb6bcd4b5972f82604bcb63' , '2d2e9dacdbe5bf80a250a9f705961990' , '2d33d8eb97ef051cfb8871e3a253af44' , '2d3f91e0db29bf80a250a9f7059619af' , '2d40d8cadbb0e8d438cbe1c2ca9619c1' , '2d44b6b3db770cd0ef939f67f4961995' , '2d564406dbbc60d4e09d5e25ca961954' , '2d6e9decdbe5bf80a250a9f70596199b' , '2d6e9decdbe5bf80a250a9f7059619ed' , '2d7f1524db29bf80a250a9f705961916' , '2d87dc781b859d905c0711b7b04bcb2c' , '2d9da35bdb92a010b5ce1dca4896199a' , '2d9e9920db29bf80a250a9f705961938' , '2d9e9920db29bf80a250a9f705961972' , '2dae9d20db29bf80a250a9f705961955' , '2dae9d20db29bf80a250a9f705961978' , '2db76c04dba6d410a250a9f7059619e7' , '2dce5560db29bf80a250a9f7059619b6' , '2dce5560db29bf80a250a9f7059619ff' , '2dd725f0db5f3f804ae38a72399619ce' , '2de00eb11b89d8d00420624d6e4bcb28' , '2dedcf66db951010a250a9f70596191f' , '2dfd28af1ba4b450c144fc8e034bcb6d' , '2dfe51a0db29bf80a250a9f7059619d5' , '2e01fec1db8d10d0fcf84c95b99619d4' , '2e03d52adbbb5c90ef939f67f4961925' , '2e1ed9acdbe5bf80a250a9f70596196d' , '2e25b8471b7dd4500420624d6e4bcb6d' , '2e2eddacdbe5bf80a250a9f7059619bc' , '2e2eddacdbe5bf80a250a9f7059619c1' , '2e2f9da0db29bf80a250a9f7059619e0' , '2e301046dbb8ac949752ab92ca9619f2' , '2e429d91db784090ef939f67f496195b' , '2e42a8d01b2190101b7fb8cc1d4bcb6c' , '2e4862aedbc79450ef939f67f49619fb' , '2e4ed5ecdbe5bf80a250a9f7059619d3' , '2e50f9aadb8377404ae38a7239961905' , '2e55bc9ddb0a1850a037d2e3ca961951' , '2e5a9ededb97e054f1629ec2ca96198c' , '2e68c2841b7d4c500420624d6e4bcbb8' , '2e8e9520db29bf80a250a9f7059619ae' , '2e929155db784090ef939f67f496195c' , '2e9910c91bf50590dfaec998624bcbbb' , '2e9fb379dbb4a4180812cf091396199f' , '2eaedd20db29bf80a250a9f70596198c' , '2eba61e7873eb490e8afc916cebb35c2' , '2ebe9160db29bf80a250a9f7059619b3' , '2ed5eedc87d3bc1077a1ba29cebb35dd' , '2ed9a31b1b3e181080af4225bd4bcb4e' , '2eef506f1beb0910738cc998624bcba0' , '2efa58671b54489012e3ece03d4bcbf4' , '2f009c0adb30e4180812cf091396191e' , '2f15812f1ba434501b7fb8cc1d4bcbf4' , '2f17aefbdbb30cd0ef939f67f4961966' , '2f18d1bedbedccdca037d2e3ca961934' , '2f1f1da0db29bf80a250a9f705961936' , '2f23043297138d10d83930f3a253afc0' , '2f2e3bbddbbca814b384533fd396196d' , '2f364854db041cd0a037d2e3ca961991' , '2f4041cddb910c584ae38a723996190a' , '2f4e19ecdbe5bf80a250a9f7059619e5' , '2f4f59e0db29bf80a250a9f705961901' , '2f5112fedb988090a037d2e3ca9619f0' , '2f53fda01b089154dc95a971604bcbb4' , '2f5e1decdbe5bf80a250a9f70596198e' , '2f5ecedc1b7154100420624d6e4bcb36' , '2f6e1120db29bf80a250a9f705961986' , '2f6f5124db29bf80a250a9f705961967' , '2f7f9524db29bf80a250a9f70596195c' , '2f7f9524db29bf80a250a9f705961966' , '2fa3b41d1bde0550350511b7b04bcb9e' , '2fab48091be745584c4965f0b24bcb8e' , '2fae1160db29bf80a250a9f705961901' , '2fb917fddbb02c949752ab92ca9619f2' , '2fbed160db29bf80a250a9f7059619c4' , '2fc9f7341b5a0150350511b7b04bcb58' , '2fce8145db77ec1093340082ca961971' , '2fced560db29bf80a250a9f705961995' , '2fced560db29bf80a250a9f7059619da' , '2fd10c0e1bb4689444af4336dc4bcb77' , '2fd6485c87ebf8949880ecad3fbb354a' , '2fd6ef891b2e4950dfaec998624bcb0f' , '2fd8cf33dbae1450a037d2e3ca961918' , '2fe1d303db0a5410a250a9f70596198a' , '2fe530cedb869814fcf84c95b99619c4' , '301e59acdbe5bf80a250a9f70596197a' , '301f99a0db29bf80a250a9f70596197b' , '3022a080db141418ef939f67f4961955' , '3027c037db0454d4a037d2e3ca9619f5' , '3033af69dbcb5410a037d2e3ca96197a' , '3039efae1b03e4908a0e9607b04bcb3e' , '303f51e0db29bf80a250a9f705961980' , '303feb47db45ac98635b8b0505961969' , '304562401b79d0100420624d6e4bcbe9' , '304e1ba11bd02010a76a0e966e4bcb4d' , '304e95ecdbe5bf80a250a9f705961950' , '304f95e0db29bf80a250a9f705961958' , '305856f91bc60514738cc998624bcbc3' , '305f99e0db29bf80a250a9f705961961' , '3067f65cdb50f050f1629ec2ca96197f' , '307e5120db29bf80a250a9f705961985' , '30802fff1bdb30d4f0455420604bcbbd' , '30839c4887563c90e567a86e0ebb35d9' , '30a19ae197601d5472d832890353af55' , '30a2e735db7024941ec2d487f49619bc' , '30adfe9bdb284c10ef939f67f49619fd' , '30b21ed1dbef4cd862b6622dca961997' , '30d9639cdb675810a037d2e3ca9619ad' , '30e31f4e1bb55c1080af4225bd4bcb4c' , '30fe51a0db29bf80a250a9f705961925' , '310bc0c6dbb860106c3de05e13961988' , '310ed5acdbe5bf80a250a9f705961935' , '310f95a0db29bf80a250a9f7059619a4' , '311a8f71dbf8e8949752ab92ca9619a7' , '31222ff41bd54550dfaec998624bcb98' , '3129249cdb037704b5ce1dca489619c7' , '31295ed51b2124104639b99e0a4bcb88' , '313370a91bdd01905c0711b7b04bcbdd' , '3135855c1b4b4d10738cc998624bcb36' , '31358c8adbb8a4180812cf09139619f7' , '313ed1ecdbe5bf80a250a9f70596199f' , '313fd1e0db29bf80a250a9f705961903' , '314ed5ecdbe5bf80a250a9f705961913' , '315e1efe1b8c5d54fcef84c3604bcbb9' , '315fd9e0db29bf80a250a9f70596196e' , '316bf7b5db3ca814b384533fd39619b5' , '317088c2db30e094568e6ac2ca9619ed' , '317a6637dbf45490a250a9f7059619f4' , '317dcc3adb356c10f1629ec2ca9619bc' , '317e77751b7ce094f7ccea866e4bcb4a' , '317f1524db29bf80a250a9f70596198d' , '317f1524db29bf80a250a9f705961992' , '318d237f1b1d94541b7fb8cc1d4bcb52' , '318e9520db29bf80a250a9f705961900' , '3191044edbbc2454822ac8cb139619d0' , '31912e08dbfd5050a037d2e3ca96190c' , '319e9920db29bf80a250a9f7059619c0' , '31b7c0461bf06cd4b83d631e6e4bcbba' , '31ca4beedb551010a250a9f7059619ad' , '31ce9560db29bf80a250a9f70596196b' , '31de5960db29bf80a250a9f7059619a0' , '31f954e71be8f0501b7fb8cc1d4bcbd3' , '31fb90a71b7a1010a76a0e966e4bcbcb' , '31fce2ab878ef410024cb84acebb3581' , '320fd5a0db29bf80a250a9f7059619da' , '320fd5a0db29bf80a250a9f7059619df' , '3216e3061b60e81080af4225bd4bcbbf' , '321b9ca71b54489012e3ece03d4bcbf4' , '321ed9acdbe5bf80a250a9f7059619a2' , '321fd9a0db29bf80a250a9f7059619f0' , '3224e139dbda58d0ef939f67f4961982' , '322e11ecdbe5bf80a250a9f70596196e' , '322e11ecdbe5bf80a250a9f705961979' , '322e11ecdbe5bf80a250a9f70596197e' , '323f052c1b4f01504f5c11b7b04bcb68' , '32700cc2db30e094568e6ac2ca9619ad' , '32739df31b1d45146ab2c998624bcb96' , '327a7eeedb78ac50ca44ff00ba9619ae' , '327f5524db29bf80a250a9f7059619b8' , '3283c0ca1b38689444af4336dc4bcb6d' , '3283c0ca1b38689444af4336dc4bcbbc' , '328ad5e81b8341504f5c11b7b04bcbd2' , '32961f801b846c501b7fb8cc1d4bcb82' , '32aedd20db29bf80a250a9f7059619b0' , '32b8c333dbae1450a037d2e3ca961944' , '32be7375db3c249491126451ca96197a' , '32cfbfd01b15d85080af4225bd4bcbe6' , '32d25195db784090ef939f67f4961975' , '32e7113edbedccdca037d2e3ca961901' , '32ed5b48876401547daec88d0ebb353a' , '32ee9d60db29bf80a250a9f7059619e7' , '32f20c4adbf860d4e09d5e25ca961969' , '331d862f1bbe385c47896397624bcb12' , '331e1dacdbe5bf80a250a9f7059619d9' , '331f1da0db29bf80a250a9f705961996' , '331f1da0db29bf80a250a9f7059619b4' , '3320c48edbb4a4180812cf0913961926' , '3320c48edbb4a4180812cf0913961940' , '33227e958709c950aea4a82d0ebb35ca' , '332e97e21b279850a76a0e966e4bcba7' , '332f11e0db29bf80a250a9f705961958' , '332f11e0db29bf80a250a9f70596197b' , '333e55ecdbe5bf80a250a9f7059619ca' , '333f55e0db29bf80a250a9f705961945' , '33464006dbbc60d4e09d5e25ca96192e' , '33466b081bc8605080af4225bd4bcb2f' , '334e59ecdbe5bf80a250a9f70596191e' , '33624ccedb7c6c549b0b9cd5ca961984' , '33653fe41b7641906ab2c998624bcb7e' , '33678c0e1bf02494f7ccea866e4bcb1a' , '33685a37dbae7b4042ac5e25ca961966' , '336e1120db29bf80a250a9f7059619ea' , '336e1120db29bf80a250a9f7059619ef' , '336f5124db29bf80a250a9f705961972' , '337f9524db29bf80a250a9f7059619af' , '337f9524db29bf80a250a9f7059619e7' , '338e1920db29bf80a250a9f70596198d' , '338e1920db29bf80a250a9f705961992' , '339e1d20db29bf80a250a9f7059619eb' , '33b0c40adb38a8d438cbe1c2ca961941' , '33d1d6181b29b4143b3255351a4bcb81' , '33d86e76db338c90a250a9f7059619a1' , '33ded960db29bf80a250a9f7059619cd' , '33df9f911ba66050ebc3c955624bcbed' , '33e4e0a3db1ae010f1629ec2ca961933' , '33e7528ddb2890d0a250a9f70596195a' , '33ee11a0db29bf80a250a9f705961915' , '33ee11a0db29bf80a250a9f70596191a' , '33ee11a0db29bf80a250a9f705961936' , '33f084f41b3118100420624d6e4bcbb0' , '340e55acdbe5bf80a250a9f7059619fc' , '341dce8b1bf61890c144fc8e034bcb4e' , '342a83b1dbf8e8949752ab92ca961947' , '3443c8c6dbb464941ec2d487f49619db' , '344aebf5dbbc00d04ae38a72399619fc' , '344f95e0db29bf80a250a9f705961979' , '345e99ecdbe5bf80a250a9f705961939' , '345e99ecdbe5bf80a250a9f705961949' , '346219d2db3bec50f1629ec2ca9619fd' , '346f8d0e1b73ec508a0e9607b04bcb35' , '3474d191dbb84090ef939f67f496196e' , '347cbcd71b0b9850a76a0e966e4bcb1a' , '347f9124db29bf80a250a9f7059619da' , '3480724c873b3018b0ecda0d3fbb3552' , '3496aa041bafd4d4c144fc8e034bcb8b' , '349e5920db29bf80a250a9f70596197b' , '34b89b301b1d0950738cc998624bcb05' , '34bfe6151be10118dfaec998624bcb3b' , '34c4402187d4c950c8bdc84e0ebb35c0' , '34c804dc1b083c548a0e9607b04bcb87' , '34cc7739dbf860d4ff4e176a48961926' , '34ce844adb7cecd4a25a034b8a961951' , '34d66edc87df7450e8afc916cebb3564' , '34ea54631b54489012e3ece03d4bcb64' , '34fe8110db259090a037d2e3ca961903' , '34ff222cdbd00410a250a9f7059619b9' , '350ed5acdbe5bf80a250a9f70596190e' , '350ed5acdbe5bf80a250a9f705961946' , '351448421b7cec94dd652f0b234bcbdf' , '35220c8edbfc6c949752ab92ca96198b' , '35224c8edbfc6c949752ab92ca96190b' , '352ac3b1dbf8e8949752ab92ca961932' , '352eddacdbe5bf80a250a9f70596190f' , '3530d086dbb0e8d438cbe1c2ca9619e2' , '353ed1ecdbe5bf80a250a9f7059619c2' , '35457a07db6d9c10fcf84c95b996197a' , '35474722db5d1450a037d2e3ca9619ac' , '3547ac6d1b0d18101b7fb8cc1d4bcbde' , '354ed5ecdbe5bf80a250a9f70596190d' , '354f512c1b0741504f5c11b7b04bcbb8' , '3553650bdb36b704c7dd9b3c8a9619dd' , '356e9decdbe5bf80a250a9f7059619f8' , '357e9120db29bf80a250a9f70596198e' , '35a444c2dbf8a8d438cbe1c2ca96193a' , '35a635861ba498104639b99e0a4bcb76' , '35bf28d61b5c541080af4225bd4bcb3a' , '35c09235db851414fcf84c95b9961929' , '35c8008adb306414bef004c2ca961954' , '35c99fd5db6bd410ef939f67f4961900' , '35ce9560db29bf80a250a9f705961954' , '35cfdb181bf330541cec657a234bcb71' , '35d50e04db044890a250a9f70596192b' , '35d56df31b73f78012e3ece03d4bcb5e' , '35d91e4c1ba20190caab11b7b04bcb3f' , '35e14f39db813894a037d2e3ca9619d1' , '35ee5d60db29bf80a250a9f7059619df' , '35f375aa1b2d94501b7fb8cc1d4bcb4e' , '35fa18671b54489012e3ece03d4bcb92' , '35fabaf71bd60d50caab11b7b04bcb21' , '35fe91a0db29bf80a250a9f705961917' , '36013d4d1b9789d0e87211b7b04bcb96' , '36039dc6db3abf80cca941deaa9619f1' , '361acf71dbf8e8949752ab92ca9619a9' , '361acf71dbf8e8949752ab92ca9619dc' , '362b8f56db7d6010c7dd9b3c8a96198a' , '362cbbb5dbf42c54106a6693ca961927' , '3643a8dd1bd35c101b7fb8cc1d4bcb5f' , '3646b5261b3d8114350511b7b04bcb52' , '366ef6f11b425450a76a0e966e4bcbc1' , '366f1124db29bf80a250a9f705961923' , '36704cc2db30e094568e6ac2ca961911' , '3682ed438730c5d0e8afc916cebb3572' , '3685b84d874a3058024cb84acebb3516' , '368ed520db29bf80a250a9f7059619c3' , '36aedd20db29bf80a250a9f705961992' , '36af44531b8e94100420624d6e4bcb98' , '36b1fec31b0bc1dc68e3a971604bcb29' , '36be08141bed5c500420624d6e4bcb50' , '36c4d3cd1ba89c900420624d6e4bcbbf' , '36c6b4f71b6908501b7fb8cc1d4bcb64' , '36de9960db29bf80a250a9f7059619e8' , '36de9960db29bf80a250a9f7059619fd' , '36e6610edb83a090ca44ff00ba96193a' , '36fbf2ff87ccc110e8afc916cebb35af' , '37030df147b3c51429c4c5e3846d4378' , '370e19acdbe5bf80a250a9f7059619cd' , '370e19acdbe5bf80a250a9f7059619dc' , '371e1dacdbe5bf80a250a9f7059619de' , '37244e61db61a01093340082ca96194e' , '373e55ecdbe5bf80a250a9f7059619b1' , '373e55ecdbe5bf80a250a9f7059619b6' , '373e55ecdbe5bf80a250a9f7059619c5' , '373ea8681b210154e87211b7b04bcbe8' , '373f55e0db29bf80a250a9f705961984' , '376ec15a1befff8412e3ece03d4bcbc3' , '3771c9ed1be82090a76a0e966e4bcb78' , '378e1920db29bf80a250a9f705961971' , '378e1920db29bf80a250a9f705961976' , '37a77af21b84ec90c144fc8e034bcbac' , '37b5888adbb0a0d4ff4e176a489619e5' , '37b9449f1b2c3090a76a0e966e4bcba9' , '37be0c8c1b04b8944639b99e0a4bcbe1' , '37be1560db29bf80a250a9f70596190d' , '37be1560db29bf80a250a9f705961912' , '37be1560db29bf80a250a9f705961921' , '37ca88241b0f105080af4225bd4bcb6d' , '37ca9c231b54489012e3ece03d4bcb11' , '37d23459dbf6c450f1629ec2ca96192f' , '37e488c2dbfc6c549b0b9cd5ca961981' , '37ee11a0db29bf80a250a9f70596193b' , '37f6a557db4e6410f1629ec2ca9619cc' , '37fe15a0db29bf80a250a9f70596193c' , '3801a8c31bb07014a76a0e966e4bcb73' , '380b0c86dbb860106c3de05e13961998' , '380f55a0db29bf80a250a9f705961996' , '381e59acdbe5bf80a250a9f70596197f' , '38225b781b2918101b7fb8cc1d4bcbda' , '3822888edbfc6c949752ab92ca961900' , '3826836c1b22101480af4225bd4bcb5a' , '3827b8be1b96a010ebc3c955624bcbc7' , '382e5dacdbe5bf80a250a9f7059619c5' , '383f51e0db29bf80a250a9f7059619a9' , '384eaaacdb900410a250a9f705961963' , '384f95e0db29bf80a250a9f70596195d' , '385e76b41b23381821979938b04bcb86' , '387f9124db29bf80a250a9f7059619b1' , '3880332bdb2f241093340082ca961947' , '38835b211b142010c144fc8e034bcb71' , '388e5520db29bf80a250a9f705961939' , '38a323051bec9c900420624d6e4bcbc7' , '38c397b91b401d10738cc998624bcb2f' , '38c50c8adbb0a0d4ff4e176a489619ae' , '38c50c8adbb0a0d4ff4e176a489619bb' , '38de1960db29bf80a250a9f7059619f9' , '38e914b01b51701080af4225bd4bcb10' , '38ee1d60db29bf80a250a9f7059619f0' , '38f74790db8f04d0b5ce1dca4896195c' , '38fb6c9f1b205914738cc998624bcb7d' , '390d73f11b34ec94dd652f0b234bcba4' , '39150858db8c6410ef939f67f49619bd' , '3916c6f81b4ac1d0caab11b7b04bcbbe' , '393b7befdb7d9c90ef939f67f4961929' , '39430cc6dbb464941ec2d487f4961972' , '394d8bf3dbee1450a037d2e3ca9619bf' , '395e99ecdbe5bf80a250a9f7059619fe' , '395fd9e0db29bf80a250a9f705961953' , '395fd9e0db29bf80a250a9f705961958' , '396c11c8db33e8909b0b9cd5ca9619de' , '396eddecdbe5bf80a250a9f705961919' , '397f1524db29bf80a250a9f705961976' , '3982304f1b1fcd9c2800a971604bcb7d' , '3991444edbbc2454822ac8cb13961997' , '3997e14987ee78d0f5f54226cebb35dc' , '39992f421b1718501b7fb8cc1d4bcbac' , '399c6a52db43a490c7dd9b3c8a961902' , '39b7c0461bf06cd4b83d631e6e4bcb6d' , '39be94001b48dd1c5c0711b7b04bcbeb' , '39ce9560db29bf80a250a9f705961945' , '39ce9560db29bf80a250a9f705961965' , '39d3ee1c879f7450e8afc916cebb356e' , '39de5960db29bf80a250a9f7059619b5' , '39de5960db29bf80a250a9f7059619ba' , '39edbb7ddb7ca094568e6ac2ca96194b' , '39ee5d60db29bf80a250a9f7059619c3' , '39f5e1371b73f78012e3ece03d4bcb11' , '3a0616811be85c9080af4225bd4bcbf0' , '3a06c802db7cec94790b69c3ca9619b1' , '3a0f7f75dbf86c549b0b9cd5ca961930' , '3a0fd5a0db29bf80a250a9f7059619f3' , '3a1ed9acdbe5bf80a250a9f70596197e' , '3a1ed9acdbe5bf80a250a9f705961988' , '3a1f35d8dbcfb704b5ce1dca48961959' , '3a26727d1bca10d00420624d6e4bcbd6' , '3a2cbbb5dbf42c54106a6693ca96194e' , '3a2e11ecdbe5bf80a250a9f705961973' , '3a2ef8aedb955cd0ef939f67f49619b7' , '3a349cd51b23cd90738cc998624bcba9' , '3a4e19ecdbe5bf80a250a9f705961908' , '3a4e19ecdbe5bf80a250a9f705961912' , '3a69c15fdbbbd010a037d2e3ca9619ca' , '3a6f1124db29bf80a250a9f705961932' , '3a7b1dec1b8341504f5c11b7b04bcb7d' , '3a7f5524db29bf80a250a9f7059619a8' , '3a91c44edbbc2454822ac8cb13961922' , '3a91c44edbbc2454822ac8cb1396193c' , '3a9465181bb50514738cc998624bcbc4' , '3a990846db34e814b384533fd39619a3' , '3a9f7779dbb4a4180812cf0913961943' , '3aa093ea1b11d4100420624d6e4bcb3d' , '3abaf86f1b243c1467bb0f2f5b4bcbde' , '3abed160db29bf80a250a9f70596191e' , '3abed160db29bf80a250a9f705961923' , '3ac815201b8341504f5c11b7b04bcbcf' , '3acb26cbdb8ea010b5ce1dca489619b6' , '3af40f7d1b958dd0caab11b7b04bcb44' , '3af4b9261b7505105c0711b7b04bcb15' , '3afa98671b54489012e3ece03d4bcb09' , '3b07d8521bad90501b7fb8cc1d4bcb91' , '3b0cbb701b554950738cc998624bcbb3' , '3b1a03b1dbf8e8949752ab92ca9619d3' , '3b1e1dacdbe5bf80a250a9f7059619a0' , '3b1e1dacdbe5bf80a250a9f7059619e3' , '3b1e491a1befff8412e3ece03d4bcbb9' , '3b2f11e0db29bf80a250a9f70596191d' , '3b320692db995050a037d2e3ca9619f0' , '3b4010c6dbf4a0d4e09d5e25ca9619e9' , '3b643ab31bff88d00420624d6e4bcbce' , '3b678c0e1bf02494f7ccea866e4bcb4c' , '3b703e92db432890f1629ec2ca961954' , '3b7a40ab1bc998101b7fb8cc1d4bcb14' , '3b83831c1ba5fc180f0c55f5624bcb41' , '3b84ee5487d3bc1077a1ba29cebb35ee' , '3b9e77601bfec590dfaec998624bcbbe' , '3ba0f5bb1be4f490a76a0e966e4bcbbd' , '3ba793f3db8fa8d091126451ca961991' , '3bb0c40adb38a8d438cbe1c2ca961984' , '3bb95df21babb010f4f763d6624bcbd3' , '3bbcbff5dbf860d4ff4e176a4896191f' , '3bc974b487833454f6a5fc07cebb35bf' , '3bced560db29bf80a250a9f7059619f7' , '3bd460fa1b42c910dfaec998624bcb66' , '3bda14631b54489012e3ece03d4bcb44' , '3be290e7976f811c314b390e6253aff3' , '3be2f61f1b0064d0c144fc8e034bcbd4' , '3bf0db84dba4ac10fcf84c95b996197d' , '3bf49ccc1b0170141b7fb8cc1d4bcbcf' , '3bf5c427dbdee010ca44ff00ba9619df' , '3bf5d1bd1bee0194e87211b7b04bcbc7' , '3bfe15a0db29bf80a250a9f705961969' , '3c0b0c86dbb860106c3de05e139619d7' , '3c0b4c86dbb860106c3de05e139619a0' , '3c127e90db9d4c58a250a9f7059619e0' , '3c14763fdbf7c4d0a037d2e3ca9619b9' , '3c1ed63c1b6f3490f61821fa234bcb38' , '3c1f99a0db29bf80a250a9f705961975' , '3c210b69db1c9810ef939f67f4961928' , '3c2a8082dbbcec94790b69c3ca961976' , '3c2ac082dbbcec94790b69c3ca961919' , '3c2e5dacdbe5bf80a250a9f7059619ca' , '3c2e5dacdbe5bf80a250a9f7059619d5' , '3c31044fdbd8ac10ef939f67f49619f6' , '3c3e91ecdbe5bf80a250a9f70596192f' , '3c3f51e0db29bf80a250a9f705961985' , '3c427be6db5a8450a250a9f705961908' , '3c43c8c6dbb464941ec2d487f49619b4' , '3c522c73dbe7641093340082ca96190d' , '3c6448c2db3860106c3de05e13961931' , '3c7975df1bcb70d8a426eb16624bcb58' , '3c7a008adb30a0d4e09d5e25ca9619bd' , '3c85f30bdb77c890a037d2e3ca96197a' , '3c8e5520db29bf80a250a9f705961924' , '3c8fd524db29bf80a250a9f7059619e2' , '3c9e5920db29bf80a250a9f705961964' , '3ca32fbcdbbfe890ef68dbc66896199d' , '3cb510c41b6b4594350511b7b04bcb6b' , '3cb6ca4b1b93334480af4225bd4bcba4' , '3cd3b2f31bb708d01b7fb8cc1d4bcbdb' , '3cde1960db29bf80a250a9f7059619ee' , '3cf4caa9db105810a250a9f7059619c1' , '3d006777db851490ef939f67f49619bb' , '3d1488421b7cec94dd652f0b234bcbbf' , '3d1a8f71dbf8e8949752ab92ca9619b4' , '3d2ac082dbbcec94790b69c3ca9619b2' , '3d2f5da0db29bf80a250a9f7059619d1' , '3d32bd6a1b3505105c0711b7b04bcb1b' , '3d3f03981b298150caab11b7b04bcbdd' , '3d3fd1e0db29bf80a250a9f705961937' , '3d4fd5e0db29bf80a250a9f70596197c' , '3d50826c1b928910350511b7b04bcbda' , '3d598c0adb3ca8d438cbe1c2ca9619d0' , '3d68ee46876f3410f5f54226cebb35e3' , '3d76d5551b3c80901b7fb8cc1d4bcb5e' , '3d7e37751b7ce094f7ccea866e4bcb68' , '3d7e9120db29bf80a250a9f7059619a5' , '3d8e5520db29bf80a250a9f7059619e6' , '3d8e5520db29bf80a250a9f7059619eb' , '3d91c04edbbc2454822ac8cb139619c8' , '3da444c2dbf8a8d438cbe1c2ca961953' , '3dcbea1b87bfb41077a1ba29cebb35d2' , '3dfd47b7dbee1450a037d2e3ca9619ac' , '3dfe91a0db29bf80a250a9f705961926' , '3dff4fb887723814c29b84cd0ebb3597' , '3e01c8c2db7860d4e09d5e25ca9619ef' , '3e035e1e872a3090c29b84cd0ebb3523' , '3e17826ddb3c4490ef939f67f4961995' , '3e207c65dbe4a810ef939f67f4961955' , '3e2e11ecdbe5bf80a250a9f705961956' , '3e3881e8dbcc2c10a037d2e3ca961951' , '3e39fbb91b382cd4b83d631e6e4bcb0a' , '3e43a206dbdb8818c7dd9b3c8a9619d2' , '3e4651d11b3c80901b7fb8cc1d4bcb54' , '3e4e19ecdbe5bf80a250a9f705961917' , '3e4ed5ecdbe5bf80a250a9f7059619de' , '3e56a7671b70f014c144fc8e034bcb2a' , '3e5f1de0db29bf80a250a9f705961935' , '3e7ed120db29bf80a250a9f70596199f' , '3e8ed520db29bf80a250a9f7059619c8' , '3e930e4bdb719490fcf84c95b9961980' , '3e9f7779dbb4a4180812cf0913961912' , '3ea677461bb218d0a76a0e966e4bcbe3' , '3eaedd20db29bf80a250a9f7059619bf' , '3ebed160db29bf80a250a9f70596190e' , '3ed6d66e1bcc1590188da9b5604bcbfc' , '3ede9960db29bf80a250a9f7059619cc' , '3ede9960db29bf80a250a9f7059619d1' , '3eea5ce31b54489012e3ece03d4bcbb2' , '3eea7f75dbf0a010635b8b05059619ac' , '3ef3f9f11ba24514350511b7b04bcb3f' , '3ef51c82db18b410ef939f67f49619ef' , '3ef9f4dbdb5c7850ef939f67f49619d8' , '3f0b59261b3080d00420624d6e4bcbf2' , '3f0e19acdbe5bf80a250a9f7059619f1' , '3f15ac02dba2981062b6622dca961982' , '3f198dd91b538d98127cea45604bcb8d' , '3f20c48edbb4a4180812cf09139619b1' , '3f2b2a108793b450e8afc916cebb35ab' , '3f301c86dbb8ac949752ab92ca961916' , '3f38c0cadbf8a010635b8b05059619c6' , '3f42e1a01b8741504f5c11b7b04bcbaa' , '3f5fdcf1db4bec50f1629ec2ca96191c' , '3f6d1f701bff24504639b99e0a4bcbeb' , '3f6e1120db29bf80a250a9f7059619f4' , '3f6f5124db29bf80a250a9f70596196c' , '3f6f5124db29bf80a250a9f705961981' , '3fbcbff5dbf860d4ff4e176a48961962' , '3fbef775db3c249491126451ca961973' , '3fc0d3f4db695850fcf84c95b9961959' , '3fd9c886db3864941ec2d487f4961959' , '3fd9c886db3864941ec2d487f4961966' , '400495b2dbde6490ef68dbc66896194d' , '4009dd4a1b63d050a76a0e966e4bcb66' , '402e1dacdbe5bf80a250a9f7059619f3' , '4030c48edbb4a4180812cf09139619e4' , '403e02871b139c501b7fb8cc1d4bcb8c' , '403f11e0db29bf80a250a9f705961985' , '404804cadbf8a010635b8b05059619da' , '404b946b1b54489012e3ece03d4bcba2' , '404caa601b5c189412e3ece03d4bcb95' , '404e294adbb0e450c7dd9b3c8a961932' , '405f59e0db29bf80a250a9f7059619c9' , '4064c4c2db3860106c3de05e13961975' , '406568d91b1bd0d0c144fc8e034bcb0b' , '406b1f781bac7090a76a0e966e4bcbd7' , '406f5de0db29bf80a250a9f70596195b' , '40728ccedb7c6c549b0b9cd5ca96191c' , '40778c0e1bf02494f7ccea866e4bcbdb' , '408c2646db2c1410b5ce1dca4896197e' , '408e0a061b734ddcdc95a971604bcb55' , '408e1520db29bf80a250a9f705961948' , '40954a851b46cd90dfaec998624bcb10' , '409cf2cd1b23e4948a0e9607b04bcbaa' , '409e1920db29bf80a250a9f7059619a7' , '40ae5d20db29bf80a250a9f705961962' , '40b16dd31bff099c6ab2c998624bcbc6' , '40b2f6ce1b749d50e87211b7b04bcb9b' , '40b4aa3a1b7fc05012e3ece03d4bcb2a' , '40ce1560db29bf80a250a9f705961931' , '40d81677dbae7b4042ac5e25ca96196b' , '410e95acdbe5bf80a250a9f705961998' , '411f99a0db29bf80a250a9f7059619ce' , '413932cf1b1cdd94fcef84c3604bcbfa') OR
      Yuliyas-Air:maria10.5 Valerii$ echo $?
      0
      

      I clearly see it in the list and for me it means ORed version produced wrong result. Why is it so?

      Attachments

        1. q2.sql
          931 kB
          Valerii Kravchuk
        2. q11.sql
          929 kB
          Valerii Kravchuk
        3. formdb1.sql.gz
          1.26 MB
          Valerii Kravchuk

        Activity

          People

            Unassigned Unassigned
            valerii Valerii Kravchuk
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.