questions about "Update selection"

Hello!

I have IJC v.14.9.1,  when I try to select one or several columns in the table appear the status "Update selection" and this updating may continue for several hours! moreover, canceling for this process also impossible.

Maybe exist some way for solving of this question?

Thanks,

Igor T.

Dear Igor,

you also described a problem with Domain Search in query builder. That works fine, plus we did some fixes in this area too (it should be in IJC 14.9.8.0).

 

I was trying to reproduce the problem with selection hanging up. I could not reproduce it at all. This however is a serious problem. Could you please provide us with the log file when this happens? The best would be to enable SQL logging:

1. Go to Preferences -> Miscelaneous -> Other settings


2. Set SQL logging level to "SQL statements"


3. Reconnect to the schema

How to get the log file can be found here.

Best

David

Dear David,

problem with Domain Search was when in the Recent queries was too long string, so Domain was just hidden, I caught sight of this after the questions have been sent.

Problem with updating selection was due to the 4 tables with relationship, so all time when I select some data in main table, IJC looking for all related data in all other connected by relationship tables,

INFO [com.im.commons.db.datasource.BaseDataSource]: JDBC connection for jdbc:derby:D:\Bases_201409/.config/localdb/db;upgrade=false: net.sf.log4jdbc.ConnectionSpy@5be8466d

INFO [com.im.commons.db.datasource.BaseDataSource]: JDBC connection for jdbc:derby:D:\Bases_201409/.config/localdb/db;upgrade=false: net.sf.log4jdbc.ConnectionSpy@64b298f3

INFO [com.im.commons.db.datasource.BaseDataSource]: JDBC connection for jdbc:derby:D:\Bases_201409/.config/localdb/db;upgrade=false: net.sf.log4jdbc.ConnectionSpy@8198b6e

INFO [com.im.commons.db.datasource.BaseDataSource]: JDBC connection for jdbc:derby:D:\Bases_201409/.config/localdb/db;upgrade=false: net.sf.log4jdbc.ConnectionSpy@b83e0ef

INFO [jdbc.sqlonly]: SELECT count(*) FROM IJC_USER WHERE SCHEMA_ID = 'D64F1E7BCCFBF60114519B055CD2708' AND USERNAME = 'admin' AND LOGIN_TIME IS NOT NULL;

INFO [jdbc.sqlonly]: SELECT count(*) FROM IJC_USER WHERE SCHEMA_ID = 'D64F1E7BCCFBF60114519B055CD2708' AND USERNAME = 'admin' AND LOGIN_TIME IS NOT NULL;

INFO [jdbc.sqlonly]: SELECT count(*) FROM IJC_USER WHERE SCHEMA_ID = 'D64F1E7BCCFBF60114519B055CD2708' AND USERNAME = 'admin' AND LOGIN_TIME IS NOT NULL;

INFO [jdbc.sqlonly]: SELECT count(*) FROM IJC_USER WHERE SCHEMA_ID = 'D64F1E7BCCFBF60114519B055CD2708' AND USERNAME = 'admin' AND LOGIN_TIME IS NOT NULL;

INFO [jdbc.sqlonly]: UPDATE IJC_USER SET HEARTBEAT = CURRENT_TIMESTAMP WHERE SCHEMA_ID = 'D64F1E7BCCFFBF60114519B055CD2708' AND USERNAME = 'admin';

INFO [jdbc.sqlonly]: UPDATE IJC_USER SET HEARTBEAT = CURRENT_TIMESTAMP WHERE SCHEMA_ID = 'D64F1E7BCCFFBF60114519B055CD2708' AND USERNAME = 'admin';

INFO [jdbc.sqlonly]: UPDATE IJC_USER SET HEARTBEAT = CURRENT_TIMESTAMP WHERE SCHEMA_ID = 'D64F1E7BCCFFBF60114519B055CD2708' AND USERNAME = 'admin';

INFO [jdbc.sqlonly]: UPDATE IJC_USER SET HEARTBEAT = CURRENT_TIMESTAMP WHERE SCHEMA_ID = 'D64F1E7BCCFFBF60114519B055CD2708' AND USERNAME = 'admin';

INFO [jdbc.sqlonly]:

SELECT DISTINCT APP.TABLE_0147."CD_ID" FROM APP.TABLE_0147, APP.X111 WHERE ((APP.X111."CD_ID" IN (388254, 351764, 348443, 348090, 341923, 340901, 331984, 318835, 290315, 387273, 387087, 384173, 383479, 383346, 379829, 379489, 379484, 379336, 379334, 379322, 377843, 374016, 373722, 371415, 368139, 367266, 367006, 365868, 365124, 360065, 359338, 358985, 358654, 358298, 355447, 351642, 348408, 348250, 340921, 318873, 317773, 316611, 315809, 314462, 313726, 313724, 310013, 302914, 302324, 300341, 299619, 291307, 388194, 388148, 387577, 387382, 387107, 386978, 386393, 383668, 383531, 383484, 383478, 383187, 382994, 382993, 382992, 382991, 381379, 379599, 379598, 379576, 379571, 379529, 379510, 379486, 379407, 379368, 379364, 379361, 379360, 379335, 379316, 379085, 379084, 378220, 377855, 377829, 377518, 377345, 374966, 372579, 372279, 372106, 371334, 370881, 368138, 367931, 367865, 366158, 365946, 365137, 363551, 362183, 362060, 361741, 360707, 360538, 360141, 360134, 359339, 358931, 358825, 358265, 358064, 357394, 356658, 355606, 355567, 354235, 353392, 352082, 351541, 351212, 348546, 348255, 348102, 347963, 347802, 345839, 341957, 340617, 340174, 339471, 338367, 336505, 336190, 335144, 335015, 334982, 318895, 318782, 318450, 318326, 318269, 318263, 317812, 317630, 317391, 317338, 317258, 317084, 316984, 316776, 316719, 316562, 316014, 315819, 315343, 314779, 314688, 313730, 313728, 313727, 311899, 310328, 310012, 310011, 307987, 305366, 303771, 302258, 300861, 300592, 297733, 297438, 297437, 295190, 294362, 292400, 291624, 290718, 389247, 389095, 388797, 388796, 388795, 388794, 388612, 388042, 387105, 386977, 386743, 386652, 386552, 386132, 386037, 385982, 385922, 385702, 384743, 384496, 383938, 383620, 383553, 383513, 383507, 383501, 383490, 383485, 383470, 383464, 383357, 383244, 383177, 383176, 382999, 382998, 382499, 381935, 380536, 380183, 380066, 380044, 379597, 379554, 379509, 379485, 379481, 379480, 379413, 379366, 379365, 379357, 379347, 379328, 379323, 379318, 379301, 379195, 379092, 379090, 379089, 379088, 379087, 379086, 379083, 379082, 378462, 378226, 378157, 378156, 377830, 377346, 377339, 377338, 377113, 377112, 376741, 376250, 375292, 375220, 374963, 374594, 373344, 372103, 371451, 369880, 369410, 368661, 368428, 366977, 366058, 364990, 364647, 363943, 363618, 362851, 362719, 362718, 362231, 362112, 362085, 361905, 361731, 361399, 361345, 361111, 361072, 361035, 360708, 360519, 360328, 359963, 359546, 359519, 359494, 359330, 358829, 358755, 358608, 358575, 358333, 358325, 358260, 358172, 358001, 357948, 357113, 356979, 356895, 356780, 356309, 355502, 354119, 353580, 353419, 353412, 353120, 352946, 352048, 352000, 351967, 351941, 351491, 351391, 351062, 350128, 350011, 349050, 348378, 348277, 348210, 348153, 348146, 348111, 348100, 348078, 347994, 347987, 347899, 347892, 347800, 346679, 346012, 343342, 342873, 340028, 339994, 339888, 339859, 339562, 339454, 339425, 339362, 339019, 338250, 336474, 336152, 336041, 335867, 335715, 335048, 334876, 334761, 334699, 334595, 334481, 334394, 334366, 334243, 333967, 333781, 333067, 332540, 332538, 332537, 332417, 331919, 331482, 331391, 331057, 321673, 321427, 321289, 320350, 318891, 318820, 318750, 318725, 318720, 318716, 318665, 318421, 318321, 318280, 318193, 318185, 318131, 318120, 318103, 318074, 318064, 318056, 318024, 318017, 317986, 317848, 317651, 317537, 317529, 317509, 317213, 317135, 317100, 317070, 317065, 317043, 316767, 316757, 316717, 316702, 316695, 316658, 316619, 316607, 316599, 316555, 316548, 316401, 316236, 316174, 316121, 316037, 316017, 315990, 315943, 315872, 315855, 315810, 315700, 315532, 315464, 315093, 315009, 314910, 314773, 314557, 314305, 314279, 313926, 313869, 313818, 313773, 313143, 312138, 311129, 310647, 310243, 309721, 309179, 308797, 305827, 305393, 305178, 304980, 304615, 304469, 304398, 304125, 304006, 302991, 302696, 301454, 301069, 300628, 300273, 299654, 299130, 298794, 298078, 297316, 296783, 295994, 295651, 294528, 294070, 293112, 292803, 292792, 292559, 292021, 291832, 291470, 291340, 290996, 290189, 290116, 389003, 388698, 388444, 388196, 388111, 388024, 387849, 387547, 387544, 387520, 387156, 387155, 387125, 386799, 386442, 386041, 386039, 385926, 385763, 384939, 384904, 384857, 384833, 384828, 384751, 384744, 384605, 384431, 384336, 384100, 384073, 383935, 383664, 383661, 383555, 383500, 383487, 383486, 383466, 383337, 383335, 383318, 383312, 383246, 383227, 383179, 383178, 383052, 383051, 383041, 383031, 383030, 383004, 383002, 383001, 383000, 382794, 382624, 382596, 382595, 382277, 382060, 382059, 380900, 380458, 379852, 379851, 379637, 379523, 379511, 379493, 379487, 379454, 379354, 379204, 379192, 379162, 379095, 379094, 379093, 379091, 378581, 378480, 378262, 378240, 378239, 378232, 378219, 378217, 378216, 378203, 378159, 378063, 378060, 378059, 377992, 377856, 377735, 377680, 377344, 377343, 377342, 377341, 377340, 377295, 377229, 377216, 377213, 377210, 377193, 377192, 377191, 377190, 377189, 377148, 377074, 376770, 376769, 376183, 376180, 376179, 376178, 376175, 376069, 375998, 375687, 375564, 375421, 375380, 375120, 374577, 374517, 374215, 374120, 374023, 374012, 373978, 373687, 373590, 373306, 372974, 372703, 372483, 372176, 372092, 371946, 371897, 371861, 371304, 370767, 370730, 370576, 370438, 369699, 369366, 368812, 368535, 368383, 368262, 367975, 367844, 367725, 367162, 367007, 367005, 366845, 366670, 366198, 366159, 366130, 366016, 365592, 365126, 364974, 364541, 364505, 363947, 363946, 363689, 363446, 363330, 362956, 362539, 362347, 362158, 361972, 361906, 361581, 361461, 361414, 361408, 361271, 361112, 361110, 361038, 361036, 360874, 360658, 360277, 360189, 359920, 359919, 359862, 359861, 359860, 359797, 359709, 359652, 359548, 359285, 359242, 358916, 358625, 358480, 358263, 357968, 357827, 357148, 357042, 356696, 356546, 356479, 356466, 356428, 356323, 356183, 355553, 355503, 355371, 354276, 353882, 353592, 353421, 353262, 353252, 353204, 352957, 352949, 352465, 352215, 352109, 352030, 351751, 351701, 351558, 351496, 350980, 350598, 350517, 350250, 349986, 349927, 349743, 349632, 349471, 348942, 348936, 348840, 348639, 348295, 348125, 348099, 348026, 347801, 347251, 347239, 347128, 346517, 346477, 346353, 345950, 345870, 345808, 345639, 344774, 344305, 343178, 343103, 342875, 342808, 342578, 341674, 341508, 340362, 340335, 340160, 340052, 339698, 339378, 339339, 339287, 339123, 339033, 339032, 338948, 338646, 338615, 338554, 338236, 338098, 338054, 338029, 338028, 338027, 337763, 337184, 336882, 336775, 336774, 336506, 336499, 336470, 336452, 336264, 336131, 336126, 336125, 336123, 336121, 336120, 336116, 336033, 336026, 335914, 335864, 335722, 335187, 335138, 334964, 334802, 334792, 334771, 334769, 334767, 334766, 334755, 334700, 334653, 334482, 334168, 333872, 333731, 333278, 333146, 333110, 332807, 332804, 332615, 332176, 332123, 331367, 331260, 331115, 331110, 331107, 322174, 321151, 321083, 320351, 320254, 320122, 320004, 319823, 318982, 318909, 318906, 318890, 318870, 318824, 318812, 318798, 318789, 318780, 318730, 318672, 318575, 318530, 318504, 318498, 318481, 318414, 318386, 318380, 318329, 318306, 318288, 318261, 318249, 318222, 318218, 318207, 318163, 318155, 318149, 318141, 318108, 318080, 318050, 318031, 318010, 318004, 317987, 317975, 317971, 317963, 317953, 317945, 317936, 317920, 317914, 317877, 317826, 317822, 317817, 317807, 317776, 317747, 317721, 317713, 317709, 317706, 317641, 317632, 317626, 317616, 317546, 317536, 317520, 317500, 317481, 317472, 317390, 317372, 317356, 317306, 317225, 317222, 317214, 317149, 317114, 317097, 317083, 317081, 317050, 317042, 317015, 316997, 316979, 316964, 316824, 316753, 316713, 316696, 316662, 316587, 316549, 316506, 316474, 316374, 316263, 316202, 316198, 316190, 316141, 316112, 316074, 316066, 316054, 315941, 315865, 315804, 315747, 315746, 315702, 315643, 315615, 315607, 315566, 315538, 315526, 315501, 315497, 315463, 315374, 315335, 315075, 315048, 315029, 314986, 314984, 314714, 314666, 314658, 314164, 314161, 314025, 314001, 313731, 313080, 313074, 312829, 312371)

  OR APP.X111."CD_ID" IN (312295, 312021, 311789, 311548, 311547, 310987, 310698, 310697, 310304, 309674, 309434, 308594, 307915, 307292, 307057, 306061, 306002, 305991, 304934, 304865, 304836, 304722, 304598, 304449, 304385, 304290, 303996, 303995, 303814, 303812, 303726, 302642, 302628, 302504, 302224, 301783, 301735, 301671, 301387, 301029, 300915, 300535, 300437, 300275, 300160, 299929, 299199, 298842, 298463, 297323, 297317, 297212, 297144, 297078, 297068, 296827, 296003, 295713, 295399, 295165, 295025, 294682, 294678, 294533, 293986, 293838, 293186, 293141, 292962, 292800, 292700, 292527, 292142, 292022, 291627, 291346, 291286, 291139, 291061, 290914, 290557, 290508, 290420, 290398, 290002, 289290, 288751, 287236, 389191, 389102, 389101, 389078, 389077, 389076, 388992, 388920, 388638, 388552, 388515, 388159, 388153, 388067, 387646, 387080, 386801, 386697, 386643, 386606, 386564, 386510, 386426, 386131, 385983, 385865, 384928, 384679, 384606, 384338, 384278, 384227, 384184, 384140, 384121, 384105, 384089, 383896, 383875, 383874, 383831, 383665, 383662, 383657, 383632, 383558, 383546, 383535, 383519, 383518, 383505, 383502, 383493, 383489, 383488, 383481, 383469, 383468, 383454, 383453, 383370, 383367, 383358, 383349, 383347, 383338, 383336, 383282, 383204, 383203, 383170, 383050, 383049, 383046, 383045, 383040, 383038, 383037, 383036, 382912, 382874, 382717, 382683, 382655, 382653, 382637, 382636, 382459, 382457, 382456, 382422, 382248, 382058, 382056, 381991, 381911, 381710, 381709, 381706, 381705, 381253, 381198, 381120, 381103, 380693, 380677, 380407, 380392, 379993, 379955, 379843, 379768, 379628, 379513, 379512, 379502, 379499, 379456, 379455, 379451, 379355, 379291, 379232, 379193, 378639, 378554, 378545, 378529, 378425, 378229, 378228, 378227, 378223, 378218, 378215, 378214, 378163, 378162, 378161, 378160, 378064, 377971, 377963, 377857, 377832, 377679, 377308, 377304, 377303, 377302, 377292, 377289, 377278, 377239, 377238, 377237, 377219, 377207, 376992, 376929, 376906, 376698, 376539, 376525, 376391, 376347, 376251, 376068, 375960, 375954, 375542, 375379, 375374, 375289, 375271, 375218, 375105, 374435, 374255, 374113, 374111, 373679, 373592, 373503, 373490, 373099, 373085, 373083, 372629, 372421, 372370, 372174, 372128, 371940, 371790, 371687, 371336, 371221, 370763, 369822, 369715, 369688, 369678, 369423, 369206, 369050, 368547, 368484, 368063, 367869, 367854, 367758, 367685, 367399, 367076, 367041, 367040, 366998, 366979, 366940, 366671, 366669, 366577, 366286, 365774, 365268, 364602, 364553, 364479, 364357, 364356, 364282, 364073, 364031, 364026, 363927, 363807, 363677, 363241, 362976, 362473, 362412, 362204, 362148, 362128, 362082, 362076, 362075, 362056, 362024, 361960, 361936, 361749, 361666, 361456, 361452, 361368, 361321, 361317, 361303, 361180, 361067, 360838, 360750, 360674, 360542, 360348, 360242, 360190, 360042, 359922, 359921, 359887, 359886, 359870, 359858, 359680, 359596, 359575, 359574, 359269, 359067, 359024, 358861, 358398, 358334, 358331, 358266, 358188, 358092, 357722, 357516, 357501, 357355, 357003, 356489, 356311, 356297, 356032, 355871, 355565, 355535, 354871, 354780, 354575, 354441, 354336, 353863, 353861, 353820, 353720, 353414, 353365, 353089, 353087, 352842, 352794, 352575, 352480, 352404, 352395, 352258, 352251, 351905, 351861, 351795, 351794, 351790, 351787, 351742, 351717, 351669, 351562, 351560, 351345, 351284, 351227, 350848, 350815, 350710, 350672, 350650, 350559, 350391, 350255, 350156, 349976, 349809, 349782, 349722, 349720, 349710, 349640, 349482, 349155, 349141, 348980, 348955, 348940, 348879, 348446, 348432, 348429, 348406, 348112, 348101, 348094, 348086, 347915, 347661, 347241, 347208, 346792, 346729, 346706, 346651, 346534, 346335, 345976, 345958, 345927, 345900, 345842, 345721, 345607, 345568, 345509, 345226, 345140, 344602, 344506, 344370, 344258, 344244, 343742, 343383, 343142, 343069, 342596, 341995, 341889, 341739, 341376, 340653, 340625, 340173, 340172, 340155, 340082, 339916, 339875, 339769, 339762, 339756, 339637, 339628, 339421, 339290, 339271, 339220, 339185, 339172, 339140, 339073, 338877, 338787, 338774, 338569, 338568, 338556, 338223, 338177, 338139, 337814, 337578, 337182, 336853, 336779, 336747, 336720, 336710, 336575, 336503, 336491, 336472, 336471, 336405, 336344, 336261, 336226, 336216, 336209, 336203, 336129, 336031, 335863, 335862, 335823, 335784, 335767, 335721, 335622, 335474, 335235, 335211, 335150, 335110, 335108, 334965, 334936, 334726, 334623, 334552, 334483, 334464, 334458, 333894, 333878, 333870, 333723, 333318, 333092, 332805, 332795, 332644, 332346, 332248, 332122, 331976, 331947, 331766, 331654, 331359, 331338, 331146, 331113, 331111, 331081, 330927, 329336, 329335, 327437, 327436, 323443, 321858, 321829, 321744, 321735, 321716, 321389, 320885, 320504, 320352, 320269, 320266, 320064, 320063, 319774, 319696, 319690, 319689, 319469, 319441, 319138, 318987, 318983, 318903, 318893, 318758, 318755, 318752, 318701, 318669, 318654, 318596, 318592, 318582, 318568, 318567, 318543, 318519, 318518, 318509, 318462, 318333, 318323, 318319, 318307, 318259, 318258, 318250, 318248, 318239, 318224, 318198, 318178, 318170, 318146, 318136, 318129, 318100, 318099, 318072, 318070, 318019, 318008, 317983, 317964, 317929, 317917, 317908, 317900, 317894, 317880, 317879, 317842, 317831, 317811, 317783, 317770, 317720, 317708, 317664, 317650, 317644, 317643, 317637, 317585, 317562, 317535, 317521, 317514, 317495, 317475, 317468, 317410, 317383, 317363, 317362, 317342, 317340, 317321, 317235, 317224, 317162, 317143, 317141, 317140, 317115, 317101, 317087, 317086, 317022, 316986, 316969, 316956, 316951, 316948, 316938, 316933, 316916, 316873, 316828, 316810, 316805, 316795, 316778, 316765, 316743, 316742, 316721, 316718, 316714, 316710, 316677, 316663, 316660, 316634, 316633, 316631, 316623, 316608, 316559, 316523, 316492, 316479, 316472, 316470, 316458, 316425, 316423, 316419, 316403, 316396, 316385, 316383, 316359, 316326, 316312, 316292, 316257, 316244, 316229, 316195, 316179, 316152, 316114, 316102, 316091, 316027, 316021, 316010, 315984, 315966, 315965, 315963, 315962, 315956, 315912, 315860, 315840, 315737, 315727, 315726, 315653, 315635, 315628, 315609, 315606, 315542, 315517, 315491, 315426, 315327, 315321, 315278, 315238, 315211, 315208, 315162, 315124, 315096, 315090, 315077, 315072, 315070, 315049, 314880, 314774, 314648, 314477, 314359, 314160, 314148, 313831, 313119, 313081, 313078, 313050, 313048, 313045, 312827, 312765, 312377, 312375, 312373, 312369, 312197, 312196, 312116, 312007, 311645, 311601, 311600, 311563, 311558, 311557, 311555, 311553, 311550, 311546, 311448, 311310, 310986, 310814, 310740, 310700, 310102, 309949, 309774, 309667, 309567, 309463, 309430, 309328, 309163, 308629, 308434, 308055, 308032, 307924, 307643, 307448, 307447, 307144, 307058, 307013, 306758, 306564, 306514, 306208, 306204, 305888, 305528, 305499, 304988, 304939, 304881, 304754, 304716, 304649, 304551, 304497, 304492, 304246, 303955, 303921, 303691, 303339, 303068, 302898, 302641, 302505, 302279, 302070, 301972, 301784, 301781, 301432, 301266, 301086, 301084, 301000, 300570, 300347, 300132, 300100, 299933, 299673, 299317, 299208, 299205, 299150, 298870, 298686, 298416, 298349, 298057, 297755, 297732, 297698, 297669, 297542, 297314, 297192, 297064, 296940, 296902, 296830, 296818, 296801, 295855, 295756, 295679, 295312, 295135, 295093, 295047, 294782, 294737, 293895, 293824, 293536, 293532, 293024, 292964, 292855, 292854, 292827, 292773, 292636, 292613, 292565, 292483, 292455, 291937, 291544, 291347, 291249, 291201, 291182, 291152, 291067, 290918, 290911, 290586, 290359, 290144, 287773, 284575, 389159, 389106, 389103, 389073, 389072, 389071, 389054, 389038, 389012, 388952, 388898, 388813, 388778, 388766, 388680, 388677, 388676, 388528, 388525, 388296, 388246, 388230, 388079, 388064, 387696, 387687, 387644, 387487, 387451, 387384, 387173, 387091, 387045, 386981, 386942, 386648, 386500, 386423, 386382, 385923, 385867, 385866)

  ...

  OR APP.X111."CD_ID" IN (381518, 381509, 381502, 381500, 381498, 381490, 381467, 381386, 381174, 372353, 369761, 355761, 349326, 336614, 336613, 336611, 336605, 335729, 335455, 320123, 293432, 288911, 287509, 286618, 284826, 284688, 283982, 282734, 281723, 382495, 382357, 382356, 381599, 381506, 381464, 381445, 376205, 372356, 370470, 353549, 351712, 336616, 336615, 336609, 336608, 330918, 320187, 314137, 299783, 299614, 288268, 284050, 282465, 281585, 281578, 382625, 382514, 382355, 382354, 381981, 381902, 381385, 378550, 376750, 375923, 375587, 356097, 351668, 344313, 336612, 336610, 336029, 335402, 319556, 315007, 284375, 281600, 387428, 381901, 381606, 381590, 381568, 351667, 314343, 287408, 287202, 284058, 284015, 283925, 382044, 381938, 357601, 303134, 286934, 381903, 381175, 351658, 286563, 284563, 382948, 381924, 381913, 356745, 356517, 355773, 285394, 381927, 381925, 358009, 387393, 382008, 382007, 382006, 381942, 381930, 381929, 381904, 383932, 381932, 382011, 382010, 382009, 382005, 382004, 382003, 304377, 382020, 381905, 382019, 358460, 381941, 301711, 387426, 387432, 387394, 382017, 382016, 302435, 382018, 382015)) AND (APP.X111."CD_ID" = APP.TABLE_0147."IDCB"));

INFO [jdbc.sqlonly]:

SELECT DISTINCT APP.TABLE_0789."CD_ID" FROM APP.TABLE_0789, APP.X111 WHERE ((APP.X111."CD_ID" IN (388254, 351764, 348443, 348090, 341923, 340901, 331984, 318835, 290315, 387273, 387087, 384173, 383479, 383346, 379829, 379489, 379484, 379336, 379334, 379322, 377843, 374016, 373722, 371415, 368139, 367266, 367006, 365868, 365124, 360065, 359338, 358985, 358654, 358298, 355447, 351642, 348408, 348250, 340921, 318873, 317773, 316611, 315809, 314462, 313726, 313724, 310013, 302914, 302324, 300341, 299619, 291307, 388194, 388148, 387577, 387382, 387107, 386978, 386393, 383668, 383531, 383484, 383478, 383187, 382994, 382993, 382992, 382991, 381379, 379599, 379598, 379576, 379571, 379529, 379510, 379486, 379407, 379368, 379364, 379361, 379360, 379335, 379316, 379085, 379084, 378220, 377855, 377829, 377518, 377345, 374966, 372579, 372279, 372106, 371334, 370881, 368138, 367931, 367865, 366158, 365946, 365137, 363551, 362183, 362060, 361741, 360707, 360538, 360141, 360134, 359339, 358931, 358825, 358265, 358064, 357394, 356658, 355606, 355567, 354235, 353392, 352082, 351541, 351212, 348546, 348255, 348102, 347963, 347802, 345839, 341957, 340617, 340174, 339471, 338367, 336505, 336190, 335144, 335015, 334982, 318895, 318782, 318450, 318326, 318269, 318263, 317812, 317630, 317391, 317338, 317258, 317084, 316984, 316776, 316719, 316562, 316014, 315819, 315343, 314779, 314688, 313730, 313728, 313727, 311899, 310328, 310012, 310011, 307987, 305366, 303771, 302258, 300861, 300592, 297733, 297438, 297437, 295190, 294362, 292400, 291624, 290718, 389247, 389095, 388797, 388796, 388795, 388794, 388612, 388042, 387105, 386977, 386743, 386652, 386552, 386132, 386037, 385982, 385922, 385702, 384743, 384496, 383938, 383620, 383553, 383513, 383507, 383501, 383490, 383485, 383470, 383464, 383357, 383244, 383177, 383176, 382999, 382998, 382499, 381935, 380536, 380183, 380066, 380044, 379597, 379554, 379509, 379485, 379481, 379480, 379413, 379366, 379365, 379357, 379347, 379328, 379323, 379318, 379301, 379195, 379092, 379090, 379089, 379088, 379087, 379086, 379083, 379082, 378462, 378226, 378157, 378156, 377830, 377346, 377339, 377338, 377113, 377112, 376741, 376250, 375292, 375220, 374963, 374594, 373344, 372103, 371451, 369880, 369410, 368661, 368428, 366977, 366058, 364990, 364647, 363943, 363618, 362851, 362719, 362718, 362231, 362112, 362085, 361905, 361731, 361399, 361345, 361111, 361072, 361035, 360708, 360519, 360328, 359963, 359546, 359519, 359494, 359330, 358829, 358755, 358608, 358575, 358333, 358325, 358260, 358172, 358001, 357948, 357113, 356979, 356895, 356780, 356309, 355502, 354119, 353580, 353419, 353412, 353120, 352946, 352048, 352000, 351967, 351941, 351491, 351391, 351062, 350128, 350011, 349050, 348378, 348277, 348210, 348153, 348146, 348111, 348100, 348078, 347994, 347987, 347899, 347892, 347800, 346679, 346012, 343342, 342873, 340028, 339994, 339888, 339859, 339562, 339454, 339425, 339362, 339019, 338250, 336474, 336152, 336041, 335867, 335715, 335048, 334876, 334761, 334699, 334595, 334481, 334394, 334366, 334243, 333967, 333781, 333067, 332540, 332538, 332537, 332417, 331919, 331482, 331391, 331057, 321673, 321427, 321289, 320350, 318891, 318820, 318750, 318725, 318720, 318716, 318665, 318421, 318321, 318280, 318193, 318185, 318131, 318120, 318103, 318074, 318064, 318056, 318024, 318017, 317986, 317848, 317651, 317537, 317529, 317509, 317213, 317135, 317100, 317070, 317065, 317043, 316767, 316757, 316717, 316702, 316695, 316658, 316619, 316607, 316599, 316555, 316548, 316401, 316236, 316174, 316121, 316037, 316017, 315990, 315943, 315872, 315855, 315810, 315700, 315532, 315464, 315093, 315009, 314910, 314773, 314557, 314305, 314279, 313926, 313869, 313818, 313773, 313143, 312138, 311129, 310647, 310243, 309721, 309179, 308797, 305827, 305393, 305178, 304980, 304615, 304469, 304398, 304125, 304006, 302991, 302696, 301454, 301069, 300628, 300273, 299654, 299130, 298794, 298078, 297316, 296783, 295994, 295651, 294528, 294070, 293112, 292803, 292792, 292559, 292021, 291832, 291470, 291340, 290996, 290189, 290116, 389003, 388698, 388444, 388196, 388111, 388024, 387849, 387547, 387544, 387520, 387156, 387155, 387125, 386799, 386442, 386041, 386039, 385926, 385763, 384939, 384904, 384857, 384833, 384828, 384751, 384744, 384605, 384431, 384336, 384100, 384073, 383935, 383664, 383661, 383555, 383500, 383487, 383486, 383466, 383337, 383335, 383318, 383312, 383246, 383227, 383179, 383178, 383052, 383051, 383041, 383031, 383030, 383004, 383002, 383001, 383000, 382794, 382624, 382596, 382595, 382277, 382060, 382059, 380900, 380458, 379852, 379851, 379637, 379523, 379511, 379493, 379487, 379454, 379354, 379204, 379192, 379162, 379095, 379094, 379093, 379091, 378581, 378480, 378262, 378240, 378239, 378232, 378219, 378217, 378216, 378203, 378159, 378063, 378060, 378059, 377992, 377856, 377735, 377680, 377344, 377343, 377342, 377341, 377340, 377295, 377229, 377216, 377213, 377210, 377193, 377192, 377191, 377190, 377189, 377148, 377074, 376770, 376769, 376183, 376180, 376179, 376178, 376175, 376069, 375998, 375687, 375564, 375421, 375380, 375120, 374577, 374517, 374215, 374120, 374023, 374012, 373978, 373687, 373590, 373306, 372974, 372703, 372483, 372176, 372092, 371946, 371897, 371861, 371304, 370767, 370730, 370576, 370438, 369699, 369366, 368812, 368535, 368383, 368262, 367975, 367844, 367725, 367162, 367007, 367005, 366845, 366670, 366198, 366159, 366130, 366016, 365592, 365126, 364974, 364541, 364505, 363947, 363946, 363689, 363446, 363330, 362956, 362539, 362347, 362158, 361972, 361906, 361581, 361461, 361414, 361408, 361271, 361112, 361110, 361038, 361036, 360874, 360658, 360277, 360189, 359920, 359919, 359862, 359861, 359860, 359797, 359709, 359652, 359548, 359285, 359242, 358916, 358625, 358480, 358263, 357968, 357827, 357148, 357042, 356696, 356546, 356479, 356466, 356428, 356323, 356183, 355553, 355503, 355371, 354276, 353882, 353592, 353421, 353262, 353252, 353204, 352957, 352949, 352465, 352215, 352109, 352030, 351751, 351701, 351558, 351496, 350980, 350598, 350517, 350250, 349986, 349927, 349743, 349632, 349471, 348942, 348936, 348840, 348639, 348295, 348125, 348099, 348026, 347801, 347251, 347239, 347128, 346517, 346477, 346353, 345950, 345870, 345808, 345639, 344774, 344305, 343178, 343103, 342875, 342808, 342578, 341674, 341508, 340362, 340335, 340160, 340052, 339698, 339378, 339339, 339287, 339123, 339033, 339032, 338948, 338646, 338615, 338554, 338236, 338098, 338054, 338029, 338028, 338027, 337763, 337184, 336882, 336775, 336774, 336506, 336499, 336470, 336452, 336264, 336131, 336126, 336125, 336123, 336121, 336120, 336116, 336033, 336026, 335914, 335864, 335722, 335187, 335138, 334964, 334802, 334792, 334771, 334769, 334767, 334766, 334755, 334700, 334653, 334482, 334168, 333872, 333731, 333278, 333146, 333110, 332807, 332804, 332615, 332176, 332123, 331367, 331260, 331115, 331110, 331107, 322174, 321151, 321083, 320351, 320254, 320122, 320004, 319823, 318982, 318909, 318906, 318890, 318870, 318824, 318812, 318798, 318789, 318780, 318730, 318672, 318575, 318530, 318504, 318498, 318481, 318414, 318386, 318380, 318329, 318306, 318288, 318261, 318249, 318222, 318218, 318207, 318163, 318155, 318149, 318141, 318108, 318080, 318050, 318031, 318010, 318004, 317987, 317975, 317971, 317963, 317953, 317945, 317936, 317920, 317914, 317877, 317826, 317822, 317817, 317807, 317776, 317747, 317721, 317713, 317709, 317706, 317641, 317632, 317626, 317616, 317546, 317536, 317520, 317500, 317481, 317472, 317390, 317372, 317356, 317306, 317225, 317222, 317214, 317149, 317114, 317097, 317083, 317081, 317050, 317042, 317015, 316997, 316979, 316964, 316824, 316753, 316713, 316696, 316662, 316587, 316549, 316506, 316474, 316374, 316263, 316202, 316198, 316190, 316141, 316112, 316074, 316066, 316054, 315941, 315865, 315804, 315747, 315746, 315702, 315643, 315615, 315607, 315566, 315538, 315526, 315501, 315497, 315463, 315374, 315335, 315075, 315048, 315029, 314986, 314984, 314714, 314666, 314658, 314164, 314161, 314025, 314001, 313731, 313080, 313074, 312829, 312371)

  OR APP.X111."CD_ID" IN (312295, 312021, 311789, 311548, 311547, 310987, 310698, 310697, 310304, 309674, 309434, 308594, 307915, 307292, 307057, 306061, 306002, 305991, 304934, 304865, 304836, 304722, 304598, 304449, 304385, 304290, 303996, 303995, 303814, 303812, 303726, 302642, 302628, 302504, 302224, 301783, 301735, 301671, 301387, 301029, 300915, 300535, 300437, 300275, 300160, 299929, 299199, 298842, 298463, 297323, 297317, 297212, 297144, 297078, 297068, 296827, 296003, 295713, 295399, 295165, 295025, 294682, 294678, 294533, 293986, 293838, 293186, 293141, 292962, 292800, 292700, 292527, 292142, 292022, 291627, 291346, 291286, 291139, 291061, 290914, 290557, 290508, 290420, 290398, 290002, 289290, 288751, 287236, 389191, 389102, 389101, 389078, 389077, 389076, 388992, 388920, 388638, 388552, 388515, 388159, 388153, 388067, 387646, 387080, 386801, 386697, 386643, 386606, 386564, 386510, 386426, 386131, 385983, 385865, 384928, 384679, 384606, 384338, 384278, 384227, 384184, 384140, 384121, 384105, 384089, 383896, 383875, 383874, 383831, 383665, 383662, 383657, 383632, 383558, 383546, 383535, 383519, 383518, 383505, 383502, 383493, 383489, 383488, 383481, 383469, 383468, 383454, 383453, 383370, 383367, 383358, 383349, 383347, 383338, 383336, 383282, 383204, 383203, 383170, 383050, 383049, 383046, 383045, 383040, 383038, 383037, 383036, 382912, 382874, 382717, 382683, 382655, 382653, 382637, 382636, 382459, 382457, 382456, 382422, 382248, 382058, 382056, 381991, 381911, 381710, 381709, 381706, 381705, 381253, 381198, 381120, 381103, 380693, 380677, 380407, 380392, 379993, 379955, 379843, 379768, 379628, 379513, 379512, 379502, 379499, 379456, 379455, 379451, 379355, 379291, 379232, 379193, 378639, 378554, 378545, 378529, 378425, 378229, 378228, 378227, 378223, 378218, 378215, 378214, 378163, 378162, 378161, 378160, 378064, 377971, 377963, 377857, 377832, 377679, 377308, 377304, 377303, 377302, 377292, 377289, 377278, 377239, 377238, 377237, 377219, 377207, 376992, 376929, 376906, 376698, 376539, 376525, 376391, 376347, 376251, 376068, 375960, 375954, 375542, 375379, 375374, 375289, 375271, 375218, 375105, 374435, 374255, 374113, 374111, 373679, 373592, 373503, 373490, 373099, 373085, 373083, 372629, 372421, 372370, 372174, 372128, 371940, 371790, 371687, 371336, 371221, 370763, 369822, 369715, 369688, 369678, 369423, 369206, 369050, 368547, 368484, 368063, 367869, 367854, 367758, 367685, 367399, 367076, 367041, 367040, 366998, 366979, 366940, 366671, 366669, 366577, 366286, 365774, 365268, 364602, 364553, 364479, 364357, 364356, 364282, 364073, 364031, 364026, 363927, 363807, 363677, 363241, 362976, 362473, 362412, 362204, 362148, 362128, 362082, 362076, 362075, 362056, 362024, 361960, 361936, 361749, 361666, 361456, 361452, 361368, 361321, 361317, 361303, 361180, 361067, 360838, 360750, 360674, 360542, 360348, 360242, 360190, 360042, 359922, 359921, 359887, 359886, 359870, 359858, 359680, 359596, 359575, 359574, 359269, 359067, 359024, 358861, 358398, 358334, 358331, 358266, 358188, 358092, 357722, 357516, 357501, 357355, 357003, 356489, 356311, 356297, 356032, 355871, 355565, 355535, 354871, 354780, 354575, 354441, 354336, 353863, 353861, 353820, 353720, 353414, 353365, 353089, 353087, 352842, 352794, 352575, 352480, 352404, 352395, 352258, 352251, 351905, 351861, 351795, 351794, 351790, 351787, 351742, 351717, 351669, 351562, 351560, 351345, 351284, 351227, 350848, 350815, 350710, 350672, 350650, 350559, 350391, 350255, 350156, 349976, 349809, 349782, 349722, 349720, 349710, 349640, 349482, 349155, 349141, 348980, 348955, 348940, 348879, 348446, 348432, 348429, 348406, 348112, 348101, 348094, 348086, 347915, 347661, 347241, 347208, 346792, 346729, 346706, 346651, 346534, 346335, 345976, 345958, 345927, 345900, 345842, 345721, 345607, 345568, 345509, 345226, 345140, 344602, 344506, 344370, 344258, 344244, 343742, 343383, 343142, 343069, 342596, 341995, 341889, 341739, 341376, 340653, 340625, 340173, 340172, 340155, 340082, 339916, 339875, 339769, 339762, 339756, 339637, 339628, 339421, 339290, 339271, 339220, 339185, 339172, 339140, 339073, 338877, 338787, 338774, 338569, 338568, 338556, 338223, 338177, 338139, 337814, 337578, 337182, 336853, 336779, 336747, 336720, 336710, 336575, 336503, 336491, 336472, 336471, 336405, 336344, 336261, 336226, 336216, 336209, 336203, 336129, 336031, 335863, 335862, 335823, 335784, 335767, 335721, 335622, 335474, 335235, 335211, 335150, 335110, 335108, 334965, 334936, 334726, 334623, 334552, 334483, 334464, 334458, 333894, 333878, 333870, 333723, 333318, 333092, 332805, 332795, 332644, 332346, 332248, 332122, 331976, 331947, 331766, 331654, 331359, 331338, 331146, 331113, 331111, 331081, 330927, 329336, 329335, 327437, 327436, 323443, 321858, 321829, 321744, 321735, 321716, 321389, 320885, 320504, 320352, 320269, 320266, 320064, 320063, 319774, 319696, 319690, 319689, 319469, 319441, 319138, 318987, 318983, 318903, 318893, 318758, 318755, 318752, 318701, 318669, 318654, 318596, 318592, 318582, 318568, 318567, 318543, 318519, 318518, 318509, 318462, 318333, 318323, 318319, 318307, 318259, 318258, 318250, 318248, 318239, 318224, 318198, 318178, 318170, 318146, 318136, 318129, 318100, 318099, 318072, 318070, 318019, 318008, 317983, 317964, 317929, 317917, 317908, 317900, 317894, 317880, 317879, 317842, 317831, 317811, 317783, 317770, 317720, 317708, 317664, 317650, 317644, 317643, 317637, 317585, 317562, 317535, 317521, 317514, 317495, 317475, 317468, 317410, 317383, 317363, 317362, 317342, 317340, 317321, 317235, 317224, 317162, 317143, 317141, 317140, 317115, 317101, 317087, 317086, 317022, 316986, 316969, 316956, 316951, 316948, 316938, 316933, 316916, 316873, 316828, 316810, 316805, 316795, 316778, 316765, 316743, 316742, 316721, 316718, 316714, 316710, 316677, 316663, 316660, 316634, 316633, 316631, 316623, 316608, 316559, 316523, 316492, 316479, 316472, 316470, 316458, 316425, 316423, 316419, 316403, 316396, 316385, 316383, 316359, 316326, 316312, 316292, 316257, 316244, 316229, 316195, 316179, 316152, 316114, 316102, 316091, 316027, 316021, 316010, 315984, 315966, 315965, 315963, 315962, 315956, 315912, 315860, 315840, 315737, 315727, 315726, 315653, 315635, 315628, 315609, 315606, 315542, 315517, 315491, 315426, 315327, 315321, 315278, 315238, 315211, 315208, 315162, 315124, 315096, 315090, 315077, 315072, 315070, 315049, 314880, 314774, 314648, 314477, 314359, 314160, 314148, 313831, 313119, 313081, 313078, 313050, 313048, 313045, 312827, 312765, 312377, 312375, 312373, 312369, 312197, 312196, 312116, 312007, 311645, 311601, 311600, 311563, 311558, 311557, 311555, 311553, 311550, 311546, 311448, 311310, 310986, 310814, 310740, 310700, 310102, 309949, 309774, 309667, 309567, 309463, 309430, 309328, 309163, 308629, 308434, 308055, 308032, 307924, 307643, 307448, 307447, 307144, 307058, 307013, 306758, 306564, 306514, 306208, 306204, 305888, 305528, 305499, 304988, 304939, 304881, 304754, 304716, 304649, 304551, 304497, 304492, 304246, 303955, 303921, 303691, 303339, 303068, 302898, 302641, 302505, 302279, 302070, 301972, 301784, 301781, 301432, 301266, 301086, 301084, 301000, 300570, 300347, 300132, 300100, 299933, 299673, 299317, 299208, 299205, 299150, 298870, 298686, 298416, 298349, 298057, 297755, 297732, 297698, 297669, 297542, 297314, 297192, 297064, 296940, 296902, 296830, 296818, 296801, 295855, 295756, 295679, 295312, 295135, 295093, 295047, 294782, 294737, 293895, 293824, 293536, 293532, 293024, 292964, 292855, 292854, 292827, 292773, 292636, 292613, 292565, 292483, 292455, 291937, 291544, 291347, 291249, 291201, 291182, 291152, 291067, 290918, 290911, 290586, 290359, 290144, 287773, 284575, 389159, 389106, 389103, 389073, 389072, 389071, 389054, 389038, 389012, 388952, 388898, 388813, 388778, 388766, 388680, 388677, 388676, 388528, 388525, 388296, 388246, 388230, 388079, 388064, 387696, 387687, 387644, 387487, 387451, 387384, 387173, 387091, 387045, 386981, 386942, 386648, 386500, 386423, 386382, 385923, 385867, 385866)

  ...

  OR APP.X111."CD_ID" IN (381518, 381509, 381502, 381500, 381498, 381490, 381467, 381386, 381174, 372353, 369761, 355761, 349326, 336614, 336613, 336611, 336605, 335729, 335455, 320123, 293432, 288911, 287509, 286618, 284826, 284688, 283982, 282734, 281723, 382495, 382357, 382356, 381599, 381506, 381464, 381445, 376205, 372356, 370470, 353549, 351712, 336616, 336615, 336609, 336608, 330918, 320187, 314137, 299783, 299614, 288268, 284050, 282465, 281585, 281578, 382625, 382514, 382355, 382354, 381981, 381902, 381385, 378550, 376750, 375923, 375587, 356097, 351668, 344313, 336612, 336610, 336029, 335402, 319556, 315007, 284375, 281600, 387428, 381901, 381606, 381590, 381568, 351667, 314343, 287408, 287202, 284058, 284015, 283925, 382044, 381938, 357601, 303134, 286934, 381903, 381175, 351658, 286563, 284563, 382948, 381924, 381913, 356745, 356517, 355773, 285394, 381927, 381925, 358009, 387393, 382008, 382007, 382006, 381942, 381930, 381929, 381904, 383932, 381932, 382011, 382010, 382009, 382005, 382004, 382003, 304377, 382020, 381905, 382019, 358460, 381941, 301711, 387426, 387432, 387394, 382017, 382016, 302435, 382018, 382015)) AND (APP.X111."CD_ID" = APP.TABLE_0789."IDREL"));

INFO [jdbc.sqlonly]:

SELECT DISTINCT APP.TABLE_0456."CD_ID" FROM APP.TABLE_0456, APP.X111 WHERE ((APP.X111."CD_ID" IN (388254, 351764, 348443, 348090, 341923, 340901, 331984, 318835, 290315, 387273, 387087, 384173, 383479, 383346, 379829, 379489, 379484, 379336, 379334, 379322, 377843, 374016, 373722, 371415, 368139, 367266, 367006, 365868, 365124, 360065, 359338, 358985, 358654, 358298, 355447, 351642, 348408, 348250, 340921, 318873, 317773, 316611, 315809, 314462, 313726, 313724, 310013, 302914, 302324, 300341, 299619, 291307, 388194, 388148, 387577, 387382, 387107, 386978, 386393, 383668, 383531, 383484, 383478, 383187, 382994, 382993, 382992, 382991, 381379, 379599, 379598, 379576, 379571, 379529, 379510, 379486, 379407, 379368, 379364, 379361, 379360, 379335, 379316, 379085, 379084, 378220, 377855, 377829, 377518, 377345, 374966, 372579, 372279, 372106, 371334, 370881, 368138, 367931, 367865, 366158, 365946, 365137, 363551, 362183, 362060, 361741, 360707, 360538, 360141, 360134, 359339, 358931, 358825, 358265, 358064, 357394, 356658, 355606, 355567, 354235, 353392, 352082, 351541, 351212, 348546, 348255, 348102, 347963, 347802, 345839, 341957, 340617, 340174, 339471, 338367, 336505, 336190, 335144, 335015, 334982, 318895, 318782, 318450, 318326, 318269, 318263, 317812, 317630, 317391, 317338, 317258, 317084, 316984, 316776, 316719, 316562, 316014, 315819, 315343, 314779, 314688, 313730, 313728, 313727, 311899, 310328, 310012, 310011, 307987, 305366, 303771, 302258, 300861, 300592, 297733, 297438, 297437, 295190, 294362, 292400, 291624, 290718, 389247, 389095, 388797, 388796, 388795, 388794, 388612, 388042, 387105, 386977, 386743, 386652, 386552, 386132, 386037, 385982, 385922, 385702, 384743, 384496, 383938, 383620, 383553, 383513, 383507, 383501, 383490, 383485, 383470, 383464, 383357, 383244, 383177, 383176, 382999, 382998, 382499, 381935, 380536, 380183, 380066, 380044, 379597, 379554, 379509, 379485, 379481, 379480, 379413, 379366, 379365, 379357, 379347, 379328, 379323, 379318, 379301, 379195, 379092, 379090, 379089, 379088, 379087, 379086, 379083, 379082, 378462, 378226, 378157, 378156, 377830, 377346, 377339, 377338, 377113, 377112, 376741, 376250, 375292, 375220, 374963, 374594, 373344, 372103, 371451, 369880, 369410, 368661, 368428, 366977, 366058, 364990, 364647, 363943, 363618, 362851, 362719, 362718, 362231, 362112, 362085, 361905, 361731, 361399, 361345, 361111, 361072, 361035, 360708, 360519, 360328, 359963, 359546, 359519, 359494, 359330, 358829, 358755, 358608, 358575, 358333, 358325, 358260, 358172, 358001, 357948, 357113, 356979, 356895, 356780, 356309, 355502, 354119, 353580, 353419, 353412, 353120, 352946, 352048, 352000, 351967, 351941, 351491, 351391, 351062, 350128, 350011, 349050, 348378, 348277, 348210, 348153, 348146, 348111, 348100, 348078, 347994, 347987, 347899, 347892, 347800, 346679, 346012, 343342, 342873, 340028, 339994, 339888, 339859, 339562, 339454, 339425, 339362, 339019, 338250, 336474, 336152, 336041, 335867, 335715, 335048, 334876, 334761, 334699, 334595, 334481, 334394, 334366, 334243, 333967, 333781, 333067, 332540, 332538, 332537, 332417, 331919, 331482, 331391, 331057, 321673, 321427, 321289, 320350, 318891, 318820, 318750, 318725, 318720, 318716, 318665, 318421, 318321, 318280, 318193, 318185, 318131, 318120, 318103, 318074, 318064, 318056, 318024, 318017, 317986, 317848, 317651, 317537, 317529, 317509, 317213, 317135, 317100, 317070, 317065, 317043, 316767, 316757, 316717, 316702, 316695, 316658, 316619, 316607, 316599, 316555, 316548, 316401, 316236, 316174, 316121, 316037, 316017, 315990, 315943, 315872, 315855, 315810, 315700, 315532, 315464, 315093, 315009, 314910, 314773, 314557, 314305, 314279, 313926, 313869, 313818, 313773, 313143, 312138, 311129, 310647, 310243, 309721, 309179, 308797, 305827, 305393, 305178, 304980, 304615, 304469, 304398, 304125, 304006, 302991, 302696, 301454, 301069, 300628, 300273, 299654, 299130, 298794, 298078, 297316, 296783, 295994, 295651, 294528, 294070, 293112, 292803, 292792, 292559, 292021, 291832, 291470, 291340, 290996, 290189, 290116, 389003, 388698, 388444, 388196, 388111, 388024, 387849, 387547, 387544, 387520, 387156, 387155, 387125, 386799, 386442, 386041, 386039, 385926, 385763, 384939, 384904, 384857, 384833, 384828, 384751, 384744, 384605, 384431, 384336, 384100, 384073, 383935, 383664, 383661, 383555, 383500, 383487, 383486, 383466, 383337, 383335, 383318, 383312, 383246, 383227, 383179, 383178, 383052, 383051, 383041, 383031, 383030, 383004, 383002, 383001, 383000, 382794, 382624, 382596, 382595, 382277, 382060, 382059, 380900, 380458, 379852, 379851, 379637, 379523, 379511, 379493, 379487, 379454, 379354, 379204, 379192, 379162, 379095, 379094, 379093, 379091, 378581, 378480, 378262, 378240, 378239, 378232, 378219, 378217, 378216, 378203, 378159, 378063, 378060, 378059, 377992, 377856, 377735, 377680, 377344, 377343, 377342, 377341, 377340, 377295, 377229, 377216, 377213, 377210, 377193, 377192, 377191, 377190, 377189, 377148, 377074, 376770, 376769, 376183, 376180, 376179, 376178, 376175, 376069, 375998, 375687, 375564, 375421, 375380, 375120, 374577, 374517, 374215, 374120, 374023, 374012, 373978, 373687, 373590, 373306, 372974, 372703, 372483, 372176, 372092, 371946, 371897, 371861, 371304, 370767, 370730, 370576, 370438, 369699, 369366, 368812, 368535, 368383, 368262, 367975, 367844, 367725, 367162, 367007, 367005, 366845, 366670, 366198, 366159, 366130, 366016, 365592, 365126, 364974, 364541, 364505, 363947, 363946, 363689, 363446, 363330, 362956, 362539, 362347, 362158, 361972, 361906, 361581, 361461, 361414, 361408, 361271, 361112, 361110, 361038, 361036, 360874, 360658, 360277, 360189, 359920, 359919, 359862, 359861, 359860, 359797, 359709, 359652, 359548, 359285, 359242, 358916, 358625, 358480, 358263, 357968, 357827, 357148, 357042, 356696, 356546, 356479, 356466, 356428, 356323, 356183, 355553, 355503, 355371, 354276, 353882, 353592, 353421, 353262, 353252, 353204, 352957, 352949, 352465, 352215, 352109, 352030, 351751, 351701, 351558, 351496, 350980, 350598, 350517, 350250, 349986, 349927, 349743, 349632, 349471, 348942, 348936, 348840, 348639, 348295, 348125, 348099, 348026, 347801, 347251, 347239, 347128, 346517, 346477, 346353, 345950, 345870, 345808, 345639, 344774, 344305, 343178, 343103, 342875, 342808, 342578, 341674, 341508, 340362, 340335, 340160, 340052, 339698, 339378, 339339, 339287, 339123, 339033, 339032, 338948, 338646, 338615, 338554, 338236, 338098, 338054, 338029, 338028, 338027, 337763, 337184, 336882, 336775, 336774, 336506, 336499, 336470, 336452, 336264, 336131, 336126, 336125, 336123, 336121, 336120, 336116, 336033, 336026, 335914, 335864, 335722, 335187, 335138, 334964, 334802, 334792, 334771, 334769, 334767, 334766, 334755, 334700, 334653, 334482, 334168, 333872, 333731, 333278, 333146, 333110, 332807, 332804, 332615, 332176, 332123, 331367, 331260, 331115, 331110, 331107, 322174, 321151, 321083, 320351, 320254, 320122, 320004, 319823, 318982, 318909, 318906, 318890, 318870, 318824, 318812, 318798, 318789, 318780, 318730, 318672, 318575, 318530, 318504, 318498, 318481, 318414, 318386, 318380, 318329, 318306, 318288, 318261, 318249, 318222, 318218, 318207, 318163, 318155, 318149, 318141, 318108, 318080, 318050, 318031, 318010, 318004, 317987, 317975, 317971, 317963, 317953, 317945, 317936, 317920, 317914, 317877, 317826, 317822, 317817, 317807, 317776, 317747, 317721, 317713, 317709, 317706, 317641, 317632, 317626, 317616, 317546, 317536, 317520, 317500, 317481, 317472, 317390, 317372, 317356, 317306, 317225, 317222, 317214, 317149, 317114, 317097, 317083, 317081, 317050, 317042, 317015, 316997, 316979, 316964, 316824, 316753, 316713, 316696, 316662, 316587, 316549, 316506, 316474, 316374, 316263, 316202, 316198, 316190, 316141, 316112, 316074, 316066, 316054, 315941, 315865, 315804, 315747, 315746, 315702, 315643, 315615, 315607, 315566, 315538, 315526, 315501, 315497, 315463, 315374, 315335, 315075, 315048, 315029, 314986, 314984, 314714, 314666, 314658, 314164, 314161, 314025, 314001, 313731, 313080, 313074, 312829, 312371)

  OR APP.X111."CD_ID" IN (312295, 312021, 311789, 311548, 311547, 310987, 310698, 310697, 310304, 309674, 309434, 308594, 307915, 307292, 307057, 306061, 306002, 305991, 304934, 304865, 304836, 304722, 304598, 304449, 304385, 304290, 303996, 303995, 303814, 303812, 303726, 302642, 302628, 302504, 302224, 301783, 301735, 301671, 301387, 301029, 300915, 300535, 300437, 300275, 300160, 299929, 299199, 298842, 298463, 297323, 297317, 297212, 297144, 297078, 297068, 296827, 296003, 295713, 295399, 295165, 295025, 294682, 294678, 294533, 293986, 293838, 293186, 293141, 292962, 292800, 292700, 292527, 292142, 292022, 291627, 291346, 291286, 291139, 291061, 290914, 290557, 290508, 290420, 290398, 290002, 289290, 288751, 287236, 389191, 389102, 389101, 389078, 389077, 389076, 388992, 388920, 388638, 388552, 388515, 388159, 388153, 388067, 387646, 387080, 386801, 386697, 386643, 386606, 386564, 386510, 386426, 386131, 385983, 385865, 384928, 384679, 384606, 384338, 384278, 384227, 384184, 384140, 384121, 384105, 384089, 383896, 383875, 383874, 383831, 383665, 383662, 383657, 383632, 383558, 383546, 383535, 383519, 383518, 383505, 383502, 383493, 383489, 383488, 383481, 383469, 383468, 383454, 383453, 383370, 383367, 383358, 383349, 383347, 383338, 383336, 383282, 383204, 383203, 383170, 383050, 383049, 383046, 383045, 383040, 383038, 383037, 383036, 382912, 382874, 382717, 382683, 382655, 382653, 382637, 382636, 382459, 382457, 382456, 382422, 382248, 382058, 382056, 381991, 381911, 381710, 381709, 381706, 381705, 381253, 381198, 381120, 381103, 380693, 380677, 380407, 380392, 379993, 379955, 379843, 379768, 379628, 379513, 379512, 379502, 379499, 379456, 379455, 379451, 379355, 379291, 379232, 379193, 378639, 378554, 378545, 378529, 378425, 378229, 378228, 378227, 378223, 378218, 378215, 378214, 378163, 378162, 378161, 378160, 378064, 377971, 377963, 377857, 377832, 377679, 377308, 377304, 377303, 377302, 377292, 377289, 377278, 377239, 377238, 377237, 377219, 377207, 376992, 376929, 376906, 376698, 376539, 376525, 376391, 376347, 376251, 376068, 375960, 375954, 375542, 375379, 375374, 375289, 375271, 375218, 375105, 374435, 374255, 374113, 374111, 373679, 373592, 373503, 373490, 373099, 373085, 373083, 372629, 372421, 372370, 372174, 372128, 371940, 371790, 371687, 371336, 371221, 370763, 369822, 369715, 369688, 369678, 369423, 369206, 369050, 368547, 368484, 368063, 367869, 367854, 367758, 367685, 367399, 367076, 367041, 367040, 366998, 366979, 366940, 366671, 366669, 366577, 366286, 365774, 365268, 364602, 364553, 364479, 364357, 364356, 364282, 364073, 364031, 364026, 363927, 363807, 363677, 363241, 362976, 362473, 362412, 362204, 362148, 362128, 362082, 362076, 362075, 362056, 362024, 361960, 361936, 361749, 361666, 361456, 361452, 361368, 361321, 361317, 361303, 361180, 361067, 360838, 360750, 360674, 360542, 360348, 360242, 360190, 360042, 359922, 359921, 359887, 359886, 359870, 359858, 359680, 359596, 359575, 359574, 359269, 359067, 359024, 358861, 358398, 358334, 358331, 358266, 358188, 358092, 357722, 357516, 357501, 357355, 357003, 356489, 356311, 356297, 356032, 355871, 355565, 355535, 354871, 354780, 354575, 354441, 354336, 353863, 353861, 353820, 353720, 353414, 353365, 353089, 353087, 352842, 352794, 352575, 352480, 352404, 352395, 352258, 352251, 351905, 351861, 351795, 351794, 351790, 351787, 351742, 351717, 351669, 351562, 351560, 351345, 351284, 351227, 350848, 350815, 350710, 350672, 350650, 350559, 350391, 350255, 350156, 349976, 349809, 349782, 349722, 349720, 349710, 349640, 349482, 349155, 349141, 348980, 348955, 348940, 348879, 348446, 348432, 348429, 348406, 348112, 348101, 348094, 348086, 347915, 347661, 347241, 347208, 346792, 346729, 346706, 346651, 346534, 346335, 345976, 345958, 345927, 345900, 345842, 345721, 345607, 345568, 345509, 345226, 345140, 344602, 344506, 344370, 344258, 344244, 343742, 343383, 343142, 343069, 342596, 341995, 341889, 341739, 341376, 340653, 340625, 340173, 340172, 340155, 340082, 339916, 339875, 339769, 339762, 339756, 339637, 339628, 339421, 339290, 339271, 339220, 339185, 339172, 339140, 339073, 338877, 338787, 338774, 338569, 338568, 338556, 338223, 338177, 338139, 337814, 337578, 337182, 336853, 336779, 336747, 336720, 336710, 336575, 336503, 336491, 336472, 336471, 336405, 336344, 336261, 336226, 336216, 336209, 336203, 336129, 336031, 335863, 335862, 335823, 335784, 335767, 335721, 335622, 335474, 335235, 335211, 335150, 335110, 335108, 334965, 334936, 334726, 334623, 334552, 334483, 334464, 334458, 333894, 333878, 333870, 333723, 333318, 333092, 332805, 332795, 332644, 332346, 332248, 332122, 331976, 331947, 331766, 331654, 331359, 331338, 331146, 331113, 331111, 331081, 330927, 329336, 329335, 327437, 327436, 323443, 321858, 321829, 321744, 321735, 321716, 321389, 320885, 320504, 320352, 320269, 320266, 320064, 320063, 319774, 319696, 319690, 319689, 319469, 319441, 319138, 318987, 318983, 318903, 318893, 318758, 318755, 318752, 318701, 318669, 318654, 318596, 318592, 318582, 318568, 318567, 318543, 318519, 318518, 318509, 318462, 318333, 318323, 318319, 318307, 318259, 318258, 318250, 318248, 318239, 318224, 318198, 318178, 318170, 318146, 318136, 318129, 318100, 318099, 318072, 318070, 318019, 318008, 317983, 317964, 317929, 317917, 317908, 317900, 317894, 317880, 317879, 317842, 317831, 317811, 317783, 317770, 317720, 317708, 317664, 317650, 317644, 317643, 317637, 317585, 317562, 317535, 317521, 317514, 317495, 317475, 317468, 317410, 317383, 317363, 317362, 317342, 317340, 317321, 317235, 317224, 317162, 317143, 317141, 317140, 317115, 317101, 317087, 317086, 317022, 316986, 316969, 316956, 316951, 316948, 316938, 316933, 316916, 316873, 316828, 316810, 316805, 316795, 316778, 316765, 316743, 316742, 316721, 316718, 316714, 316710, 316677, 316663, 316660, 316634, 316633, 316631, 316623, 316608, 316559, 316523, 316492, 316479, 316472, 316470, 316458, 316425, 316423, 316419, 316403, 316396, 316385, 316383, 316359, 316326, 316312, 316292, 316257, 316244, 316229, 316195, 316179, 316152, 316114, 316102, 316091, 316027, 316021, 316010, 315984, 315966, 315965, 315963, 315962, 315956, 315912, 315860, 315840, 315737, 315727, 315726, 315653, 315635, 315628, 315609, 315606, 315542, 315517, 315491, 315426, 315327, 315321, 315278, 315238, 315211, 315208, 315162, 315124, 315096, 315090, 315077, 315072, 315070, 315049, 314880, 314774, 314648, 314477, 314359, 314160, 314148, 313831, 313119, 313081, 313078, 313050, 313048, 313045, 312827, 312765, 312377, 312375, 312373, 312369, 312197, 312196, 312116, 312007, 311645, 311601, 311600, 311563, 311558, 311557, 311555, 311553, 311550, 311546, 311448, 311310, 310986, 310814, 310740, 310700, 310102, 309949, 309774, 309667, 309567, 309463, 309430, 309328, 309163, 308629, 308434, 308055, 308032, 307924, 307643, 307448, 307447, 307144, 307058, 307013, 306758, 306564, 306514, 306208, 306204, 305888, 305528, 305499, 304988, 304939, 304881, 304754, 304716, 304649, 304551, 304497, 304492, 304246, 303955, 303921, 303691, 303339, 303068, 302898, 302641, 302505, 302279, 302070, 301972, 301784, 301781, 301432, 301266, 301086, 301084, 301000, 300570, 300347, 300132, 300100, 299933, 299673, 299317, 299208, 299205, 299150, 298870, 298686, 298416, 298349, 298057, 297755, 297732, 297698, 297669, 297542, 297314, 297192, 297064, 296940, 296902, 296830, 296818, 296801, 295855, 295756, 295679, 295312, 295135, 295093, 295047, 294782, 294737, 293895, 293824, 293536, 293532, 293024, 292964, 292855, 292854, 292827, 292773, 292636, 292613, 292565, 292483, 292455, 291937, 291544, 291347, 291249, 291201, 291182, 291152, 291067, 290918, 290911, 290586, 290359, 290144, 287773, 284575, 389159, 389106, 389103, 389073, 389072, 389071, 389054, 389038, 389012, 388952, 388898, 388813, 388778, 388766, 388680, 388677, 388676, 388528, 388525, 388296, 388246, 388230, 388079, 388064, 387696, 387687, 387644, 387487, 387451, 387384, 387173, 387091, 387045, 386981, 386942, 386648, 386500, 386423, 386382, 385923, 385867, 385866)

  ...

  OR APP.X111."CD_ID" IN (381518, 381509, 381502, 381500, 381498, 381490, 381467, 381386, 381174, 372353, 369761, 355761, 349326, 336614, 336613, 336611, 336605, 335729, 335455, 320123, 293432, 288911, 287509, 286618, 284826, 284688, 283982, 282734, 281723, 382495, 382357, 382356, 381599, 381506, 381464, 381445, 376205, 372356, 370470, 353549, 351712, 336616, 336615, 336609, 336608, 330918, 320187, 314137, 299783, 299614, 288268, 284050, 282465, 281585, 281578, 382625, 382514, 382355, 382354, 381981, 381902, 381385, 378550, 376750, 375923, 375587, 356097, 351668, 344313, 336612, 336610, 336029, 335402, 319556, 315007, 284375, 281600, 387428, 381901, 381606, 381590, 381568, 351667, 314343, 287408, 287202, 284058, 284015, 283925, 382044, 381938, 357601, 303134, 286934, 381903, 381175, 351658, 286563, 284563, 382948, 381924, 381913, 356745, 356517, 355773, 285394, 381927, 381925, 358009, 387393, 382008, 382007, 382006, 381942, 381930, 381929, 381904, 383932, 381932, 382011, 382010, 382009, 382005, 382004, 382003, 304377, 382020, 381905, 382019, 358460, 381941, 301711, 387426, 387432, 387394, 382017, 382016, 302435, 382018, 382015)) AND (APP.X111."CD_ID" = APP.TABLE_0456."IDDD"));

INFO [jdbc.sqlonly]:

SELECT DISTINCT APP.TABLE_0123."CD_ID" FROM APP.TABLE_0123, APP.X111 WHERE ((APP.X111."CD_ID" IN (388254, 351764, 348443, 348090, 341923, 340901, 331984, 318835, 290315, 387273, 387087, 384173, 383479, 383346, 379829, 379489, 379484, 379336, 379334, 379322, 377843, 374016, 373722, 371415, 368139, 367266, 367006, 365868, 365124, 360065, 359338, 358985, 358654, 358298, 355447, 351642, 348408, 348250, 340921, 318873, 317773, 316611, 315809, 314462, 313726, 313724, 310013, 302914, 302324, 300341, 299619, 291307, 388194, 388148, 387577, 387382, 387107, 386978, 386393, 383668, 383531, 383484, 383478, 383187, 382994, 382993, 382992, 382991, 381379, 379599, 379598, 379576, 379571, 379529, 379510, 379486, 379407, 379368, 379364, 379361, 379360, 379335, 379316, 379085, 379084, 378220, 377855, 377829, 377518, 377345, 374966, 372579, 372279, 372106, 371334, 370881, 368138, 367931, 367865, 366158, 365946, 365137, 363551, 362183, 362060, 361741, 360707, 360538, 360141, 360134, 359339, 358931, 358825, 358265, 358064, 357394, 356658, 355606, 355567, 354235, 353392, 352082, 351541, 351212, 348546, 348255, 348102, 347963, 347802, 345839, 341957, 340617, 340174, 339471, 338367, 336505, 336190, 335144, 335015, 334982, 318895, 318782, 318450, 318326, 318269, 318263, 317812, 317630, 317391, 317338, 317258, 317084, 316984, 316776, 316719, 316562, 316014, 315819, 315343, 314779, 314688, 313730, 313728, 313727, 311899, 310328, 310012, 310011, 307987, 305366, 303771, 302258, 300861, 300592, 297733, 297438, 297437, 295190, 294362, 292400, 291624, 290718, 389247, 389095, 388797, 388796, 388795, 388794, 388612, 388042, 387105, 386977, 386743, 386652, 386552, 386132, 386037, 385982, 385922, 385702, 384743, 384496, 383938, 383620, 383553, 383513, 383507, 383501, 383490, 383485, 383470, 383464, 383357, 383244, 383177, 383176, 382999, 382998, 382499, 381935, 380536, 380183, 380066, 380044, 379597, 379554, 379509, 379485, 379481, 379480, 379413, 379366, 379365, 379357, 379347, 379328, 379323, 379318, 379301, 379195, 379092, 379090, 379089, 379088, 379087, 379086, 379083, 379082, 378462, 378226, 378157, 378156, 377830, 377346, 377339, 377338, 377113, 377112, 376741, 376250, 375292, 375220, 374963, 374594, 373344, 372103, 371451, 369880, 369410, 368661, 368428, 366977, 366058, 364990, 364647, 363943, 363618, 362851, 362719, 362718, 362231, 362112, 362085, 361905, 361731, 361399, 361345, 361111, 361072, 361035, 360708, 360519, 360328, 359963, 359546, 359519, 359494, 359330, 358829, 358755, 358608, 358575, 358333, 358325, 358260, 358172, 358001, 357948, 357113, 356979, 356895, 356780, 356309, 355502, 354119, 353580, 353419, 353412, 353120, 352946, 352048, 352000, 351967, 351941, 351491, 351391, 351062, 350128, 350011, 349050, 348378, 348277, 348210, 348153, 348146, 348111, 348100, 348078, 347994, 347987, 347899, 347892, 347800, 346679, 346012, 343342, 342873, 340028, 339994, 339888, 339859, 339562, 339454, 339425, 339362, 339019, 338250, 336474, 336152, 336041, 335867, 335715, 335048, 334876, 334761, 334699, 334595, 334481, 334394, 334366, 334243, 333967, 333781, 333067, 332540, 332538, 332537, 332417, 331919, 331482, 331391, 331057, 321673, 321427, 321289, 320350, 318891, 318820, 318750, 318725, 318720, 318716, 318665, 318421, 318321, 318280, 318193, 318185, 318131, 318120, 318103, 318074, 318064, 318056, 318024, 318017, 317986, 317848, 317651, 317537, 317529, 317509, 317213, 317135, 317100, 317070, 317065, 317043, 316767, 316757, 316717, 316702, 316695, 316658, 316619, 316607, 316599, 316555, 316548, 316401, 316236, 316174, 316121, 316037, 316017, 315990, 315943, 315872, 315855, 315810, 315700, 315532, 315464, 315093, 315009, 314910, 314773, 314557, 314305, 314279, 313926, 313869, 313818, 313773, 313143, 312138, 311129, 310647, 310243, 309721, 309179, 308797, 305827, 305393, 305178, 304980, 304615, 304469, 304398, 304125, 304006, 302991, 302696, 301454, 301069, 300628, 300273, 299654, 299130, 298794, 298078, 297316, 296783, 295994, 295651, 294528, 294070, 293112, 292803, 292792, 292559, 292021, 291832, 291470, 291340, 290996, 290189, 290116, 389003, 388698, 388444, 388196, 388111, 388024, 387849, 387547, 387544, 387520, 387156, 387155, 387125, 386799, 386442, 386041, 386039, 385926, 385763, 384939, 384904, 384857, 384833, 384828, 384751, 384744, 384605, 384431, 384336, 384100, 384073, 383935, 383664, 383661, 383555, 383500, 383487, 383486, 383466, 383337, 383335, 383318, 383312, 383246, 383227, 383179, 383178, 383052, 383051, 383041, 383031, 383030, 383004, 383002, 383001, 383000, 382794, 382624, 382596, 382595, 382277, 382060, 382059, 380900, 380458, 379852, 379851, 379637, 379523, 379511, 379493, 379487, 379454, 379354, 379204, 379192, 379162, 379095, 379094, 379093, 379091, 378581, 378480, 378262, 378240, 378239, 378232, 378219, 378217, 378216, 378203, 378159, 378063, 378060, 378059, 377992, 377856, 377735, 377680, 377344, 377343, 377342, 377341, 377340, 377295, 377229, 377216, 377213, 377210, 377193, 377192, 377191, 377190, 377189, 377148, 377074, 376770, 376769, 376183, 376180, 376179, 376178, 376175, 376069, 375998, 375687, 375564, 375421, 375380, 375120, 374577, 374517, 374215, 374120, 374023, 374012, 373978, 373687, 373590, 373306, 372974, 372703, 372483, 372176, 372092, 371946, 371897, 371861, 371304, 370767, 370730, 370576, 370438, 369699, 369366, 368812, 368535, 368383, 368262, 367975, 367844, 367725, 367162, 367007, 367005, 366845, 366670, 366198, 366159, 366130, 366016, 365592, 365126, 364974, 364541, 364505, 363947, 363946, 363689, 363446, 363330, 362956, 362539, 362347, 362158, 361972, 361906, 361581, 361461, 361414, 361408, 361271, 361112, 361110, 361038, 361036, 360874, 360658, 360277, 360189, 359920, 359919, 359862, 359861, 359860, 359797, 359709, 359652, 359548, 359285, 359242, 358916, 358625, 358480, 358263, 357968, 357827, 357148, 357042, 356696, 356546, 356479, 356466, 356428, 356323, 356183, 355553, 355503, 355371, 354276, 353882, 353592, 353421, 353262, 353252, 353204, 352957, 352949, 352465, 352215, 352109, 352030, 351751, 351701, 351558, 351496, 350980, 350598, 350517, 350250, 349986, 349927, 349743, 349632, 349471, 348942, 348936, 348840, 348639, 348295, 348125, 348099, 348026, 347801, 347251, 347239, 347128, 346517, 346477, 346353, 345950, 345870, 345808, 345639, 344774, 344305, 343178, 343103, 342875, 342808, 342578, 341674, 341508, 340362, 340335, 340160, 340052, 339698, 339378, 339339, 339287, 339123, 339033, 339032, 338948, 338646, 338615, 338554, 338236, 338098, 338054, 338029, 338028, 338027, 337763, 337184, 336882, 336775, 336774, 336506, 336499, 336470, 336452, 336264, 336131, 336126, 336125, 336123, 336121, 336120, 336116, 336033, 336026, 335914, 335864, 335722, 335187, 335138, 334964, 334802, 334792, 334771, 334769, 334767, 334766, 334755, 334700, 334653, 334482, 334168, 333872, 333731, 333278, 333146, 333110, 332807, 332804, 332615, 332176, 332123, 331367, 331260, 331115, 331110, 331107, 322174, 321151, 321083, 320351, 320254, 320122, 320004, 319823, 318982, 318909, 318906, 318890, 318870, 318824, 318812, 318798, 318789, 318780, 318730, 318672, 318575, 318530, 318504, 318498, 318481, 318414, 318386, 318380, 318329, 318306, 318288, 318261, 318249, 318222, 318218, 318207, 318163, 318155, 318149, 318141, 318108, 318080, 318050, 318031, 318010, 318004, 317987, 317975, 317971, 317963, 317953, 317945, 317936, 317920, 317914, 317877, 317826, 317822, 317817, 317807, 317776, 317747, 317721, 317713, 317709, 317706, 317641, 317632, 317626, 317616, 317546, 317536, 317520, 317500, 317481, 317472, 317390, 317372, 317356, 317306, 317225, 317222, 317214, 317149, 317114, 317097, 317083, 317081, 317050, 317042, 317015, 316997, 316979, 316964, 316824, 316753, 316713, 316696, 316662, 316587, 316549, 316506, 316474, 316374, 316263, 316202, 316198, 316190, 316141, 316112, 316074, 316066, 316054, 315941, 315865, 315804, 315747, 315746, 315702, 315643, 315615, 315607, 315566, 315538, 315526, 315501, 315497, 315463, 315374, 315335, 315075, 315048, 315029, 314986, 314984, 314714, 314666, 314658, 314164, 314161, 314025, 314001, 313731, 313080, 313074, 312829, 312371)

  OR APP.X111."CD_ID" IN (312295, 312021, 311789, 311548, 311547, 310987, 310698, 310697, 310304, 309674, 309434, 308594, 307915, 307292, 307057, 306061, 306002, 305991, 304934, 304865, 304836, 304722, 304598, 304449, 304385, 304290, 303996, 303995, 303814, 303812, 303726, 302642, 302628, 302504, 302224, 301783, 301735, 301671, 301387, 301029, 300915, 300535, 300437, 300275, 300160, 299929, 299199, 298842, 298463, 297323, 297317, 297212, 297144, 297078, 297068, 296827, 296003, 295713, 295399, 295165, 295025, 294682, 294678, 294533, 293986, 293838, 293186, 293141, 292962, 292800, 292700, 292527, 292142, 292022, 291627, 291346, 291286, 291139, 291061, 290914, 290557, 290508, 290420, 290398, 290002, 289290, 288751, 287236, 389191, 389102, 389101, 389078, 389077, 389076, 388992, 388920, 388638, 388552, 388515, 388159, 388153, 388067, 387646, 387080, 386801, 386697, 386643, 386606, 386564, 386510, 386426, 386131, 385983, 385865, 384928, 384679, 384606, 384338, 384278, 384227, 384184, 384140, 384121, 384105, 384089, 383896, 383875, 383874, 383831, 383665, 383662, 383657, 383632, 383558, 383546, 383535, 383519, 383518, 383505, 383502, 383493, 383489, 383488, 383481, 383469, 383468, 383454, 383453, 383370, 383367, 383358, 383349, 383347, 383338, 383336, 383282, 383204, 383203, 383170, 383050, 383049, 383046, 383045, 383040, 383038, 383037, 383036, 382912, 382874, 382717, 382683, 382655, 382653, 382637, 382636, 382459, 382457, 382456, 382422, 382248, 382058, 382056, 381991, 381911, 381710, 381709, 381706, 381705, 381253, 381198, 381120, 381103, 380693, 380677, 380407, 380392, 379993, 379955, 379843, 379768, 379628, 379513, 379512, 379502, 379499, 379456, 379455, 379451, 379355, 379291, 379232, 379193, 378639, 378554, 378545, 378529, 378425, 378229, 378228, 378227, 378223, 378218, 378215, 378214, 378163, 378162, 378161, 378160, 378064, 377971, 377963, 377857, 377832, 377679, 377308, 377304, 377303, 377302, 377292, 377289, 377278, 377239, 377238, 377237, 377219, 377207, 376992, 376929, 376906, 376698, 376539, 376525, 376391, 376347, 376251, 376068, 375960, 375954, 375542, 375379, 375374, 375289, 375271, 375218, 375105, 374435, 374255, 374113, 374111, 373679, 373592, 373503, 373490, 373099, 373085, 373083, 372629, 372421, 372370, 372174, 372128, 371940, 371790, 371687, 371336, 371221, 370763, 369822, 369715, 369688, 369678, 369423, 369206, 369050, 368547, 368484, 368063, 367869, 367854, 367758, 367685, 367399, 367076, 367041, 367040, 366998, 366979, 366940, 366671, 366669, 366577, 366286, 365774, 365268, 364602, 364553, 364479, 364357, 364356, 364282, 364073, 364031, 364026, 363927, 363807, 363677, 363241, 362976, 362473, 362412, 362204, 362148, 362128, 362082, 362076, 362075, 362056, 362024, 361960, 361936, 361749, 361666, 361456, 361452, 361368, 361321, 361317, 361303, 361180, 361067, 360838, 360750, 360674, 360542, 360348, 360242, 360190, 360042, 359922, 359921, 359887, 359886, 359870, 359858, 359680, 359596, 359575, 359574, 359269, 359067, 359024, 358861, 358398, 358334, 358331, 358266, 358188, 358092, 357722, 357516, 357501, 357355, 357003, 356489, 356311, 356297, 356032, 355871, 355565, 355535, 354871, 354780, 354575, 354441, 354336, 353863, 353861, 353820, 353720, 353414, 353365, 353089, 353087, 352842, 352794, 352575, 352480, 352404, 352395, 352258, 352251, 351905, 351861, 351795, 351794, 351790, 351787, 351742, 351717, 351669, 351562, 351560, 351345, 351284, 351227, 350848, 350815, 350710, 350672, 350650, 350559, 350391, 350255, 350156, 349976, 349809, 349782, 349722, 349720, 349710, 349640, 349482, 349155, 349141, 348980, 348955, 348940, 348879, 348446, 348432, 348429, 348406, 348112, 348101, 348094, 348086, 347915, 347661, 347241, 347208, 346792, 346729, 346706, 346651, 346534, 346335, 345976, 345958, 345927, 345900, 345842, 345721, 345607, 345568, 345509, 345226, 345140, 344602, 344506, 344370, 344258, 344244, 343742, 343383, 343142, 343069, 342596, 341995, 341889, 341739, 341376, 340653, 340625, 340173, 340172, 340155, 340082, 339916, 339875, 339769, 339762, 339756, 339637, 339628, 339421, 339290, 339271, 339220, 339185, 339172, 339140, 339073, 338877, 338787, 338774, 338569, 338568, 338556, 338223, 338177, 338139, 337814, 337578, 337182, 336853, 336779, 336747, 336720, 336710, 336575, 336503, 336491, 336472, 336471, 336405, 336344, 336261, 336226, 336216, 336209, 336203, 336129, 336031, 335863, 335862, 335823, 335784, 335767, 335721, 335622, 335474, 335235, 335211, 335150, 335110, 335108, 334965, 334936, 334726, 334623, 334552, 334483, 334464, 334458, 333894, 333878, 333870, 333723, 333318, 333092, 332805, 332795, 332644, 332346, 332248, 332122, 331976, 331947, 331766, 331654, 331359, 331338, 331146, 331113, 331111, 331081, 330927, 329336, 329335, 327437, 327436, 323443, 321858, 321829, 321744, 321735, 321716, 321389, 320885, 320504, 320352, 320269, 320266, 320064, 320063, 319774, 319696, 319690, 319689, 319469, 319441, 319138, 318987, 318983, 318903, 318893, 318758, 318755, 318752, 318701, 318669, 318654, 318596, 318592, 318582, 318568, 318567, 318543, 318519, 318518, 318509, 318462, 318333, 318323, 318319, 318307, 318259, 318258, 318250, 318248, 318239, 318224, 318198, 318178, 318170, 318146, 318136, 318129, 318100, 318099, 318072, 318070, 318019, 318008, 317983, 317964, 317929, 317917, 317908, 317900, 317894, 317880, 317879, 317842, 317831, 317811, 317783, 317770, 317720, 317708, 317664, 317650, 317644, 317643, 317637, 317585, 317562, 317535, 317521, 317514, 317495, 317475, 317468, 317410, 317383, 317363, 317362, 317342, 317340, 317321, 317235, 317224, 317162, 317143, 317141, 317140, 317115, 317101, 317087, 317086, 317022, 316986, 316969, 316956, 316951, 316948, 316938, 316933, 316916, 316873, 316828, 316810, 316805, 316795, 316778, 316765, 316743, 316742, 316721, 316718, 316714, 316710, 316677, 316663, 316660, 316634, 316633, 316631, 316623, 316608, 316559, 316523, 316492, 316479, 316472, 316470, 316458, 316425, 316423, 316419, 316403, 316396, 316385, 316383, 316359, 316326, 316312, 316292, 316257, 316244, 316229, 316195, 316179, 316152, 316114, 316102, 316091, 316027, 316021, 316010, 315984, 315966, 315965, 315963, 315962, 315956, 315912, 315860, 315840, 315737, 315727, 315726, 315653, 315635, 315628, 315609, 315606, 315542, 315517, 315491, 315426, 315327, 315321, 315278, 315238, 315211, 315208, 315162, 315124, 315096, 315090, 315077, 315072, 315070, 315049, 314880, 314774, 314648, 314477, 314359, 314160, 314148, 313831, 313119, 313081, 313078, 313050, 313048, 313045, 312827, 312765, 312377, 312375, 312373, 312369, 312197, 312196, 312116, 312007, 311645, 311601, 311600, 311563, 311558, 311557, 311555, 311553, 311550, 311546, 311448, 311310, 310986, 310814, 310740, 310700, 310102, 309949, 309774, 309667, 309567, 309463, 309430, 309328, 309163, 308629, 308434, 308055, 308032, 307924, 307643, 307448, 307447, 307144, 307058, 307013, 306758, 306564, 306514, 306208, 306204, 305888, 305528, 305499, 304988, 304939, 304881, 304754, 304716, 304649, 304551, 304497, 304492, 304246, 303955, 303921, 303691, 303339, 303068, 302898, 302641, 302505, 302279, 302070, 301972, 301784, 301781, 301432, 301266, 301086, 301084, 301000, 300570, 300347, 300132, 300100, 299933, 299673, 299317, 299208, 299205, 299150, 298870, 298686, 298416, 298349, 298057, 297755, 297732, 297698, 297669, 297542, 297314, 297192, 297064, 296940, 296902, 296830, 296818, 296801, 295855, 295756, 295679, 295312, 295135, 295093, 295047, 294782, 294737, 293895, 293824, 293536, 293532, 293024, 292964, 292855, 292854, 292827, 292773, 292636, 292613, 292565, 292483, 292455, 291937, 291544, 291347, 291249, 291201, 291182, 291152, 291067, 290918, 290911, 290586, 290359, 290144, 287773, 284575, 389159, 389106, 389103, 389073, 389072, 389071, 389054, 389038, 389012, 388952, 388898, 388813, 388778, 388766, 388680, 388677, 388676, 388528, 388525, 388296, 388246, 388230, 388079, 388064, 387696, 387687, 387644, 387487, 387451, 387384, 387173, 387091, 387045, 386981, 386942, 386648, 386500, 386423, 386382, 385923, 385867, 385866)

  ...

  OR APP.X111."CD_ID" IN (381518, 381509, 381502, 381500, 381498, 381490, 381467, 381386, 381174, 372353, 369761, 355761, 349326, 336614, 336613, 336611, 336605, 335729, 335455, 320123, 293432, 288911, 287509, 286618, 284826, 284688, 283982, 282734, 281723, 382495, 382357, 382356, 381599, 381506, 381464, 381445, 376205, 372356, 370470, 353549, 351712, 336616, 336615, 336609, 336608, 330918, 320187, 314137, 299783, 299614, 288268, 284050, 282465, 281585, 281578, 382625, 382514, 382355, 382354, 381981, 381902, 381385, 378550, 376750, 375923, 375587, 356097, 351668, 344313, 336612, 336610, 336029, 335402, 319556, 315007, 284375, 281600, 387428, 381901, 381606, 381590, 381568, 351667, 314343, 287408, 287202, 284058, 284015, 283925, 382044, 381938, 357601, 303134, 286934, 381903, 381175, 351658, 286563, 284563, 382948, 381924, 381913, 356745, 356517, 355773, 285394, 381927, 381925, 358009, 387393, 382008, 382007, 382006, 381942, 381930, 381929, 381904, 383932, 381932, 382011, 382010, 382009, 382005, 382004, 382003, 304377, 382020, 381905, 382019, 358460, 381941, 301711, 387426, 387432, 387394, 382017, 382016, 302435, 382018, 382015)) AND (APP.X111."CD_ID" = APP.TABLE_0123."RLFIELD"));

when I click cancel, appear string:

WARNING [org.netbeans.modules.progress.spi.InternalHandle]: Cannot switch to silent mode when not running at org.netbeans.core.ui.warmup.MenuWarmUpTask$NbWindowsAdapter$1HandleBridge.run(MenuWarmUpTask.java:260)

and process of cancelling is not finishing for hours, so I have to restart program

sorry, but I cant add all log file...

Dear Igor,

yes, the problem with Domain search you describe is indeed there. I have already encountered and reported this myself last week and we are working on improving this. It has been caused by a new improvement, where Recent queries also include information about the query used.

 

Regarding the selection, I will investigate together with our developers. I understand that the log file might contain sensitive information, so do not worry, what you sent us should be enough. For more complete information, you mentioned relational tables. Could you please describe the relationship topology so that we can recreate it ourselves? 

 

Best
David 

about the relationship topology: main table connected to 4 other tables by one-to-many relationship between cdid (in main table "one") and between empty fields in all other tables ("many")

Empty fields this is specific need for my base.

 

Best,

Igor

Dear Igor,

I have talked with one of our developers and according to him, it seems as it selects too many data -> hangs. As a possible workaround, could you please try to set the Master-Detail data retrieval limit for your relationships? You can find documentation here.

If this does not help, then we have to fix a bug in IJC. For that yet more additional info would be needed:

• What widgets are you using


• Approximately how many rows in detail table are there per one master table 

Wishing all the best

David

Dear David,

It's great! when I've set retrieval limit the problem disappeared!

Thank You!

Igor