This log is too long to show here, 12,140 KB has been skipped — click to see the complete log
[INFO] [testng] riga[129]= [DayOfWeekCondition] (shortDayNameColonna:FRI) (shortDayNameColonnaTabella:FRI)
21:36:12 [INFO] [testng] riga[130]= [DayOfWeekCondition] (dayOfYearColonna:023) (dayOfYearColonnaTabella:023)
21:36:12 [INFO] [testng] riga[131]= [DayOfWeekCondition] (dayOfWeekColonna:6) (dayOfWeekColonnaTabella:6)
21:36:12 [INFO] [testng] riga[132]= [DayOfWeekCondition] (data:2026-01-23 21:36:11.050)
21:36:12 [INFO] [testng] riga[133]= [DayOfWeekCondition] (yearColonna:2026) (yearColonnaTabella:2026)
21:36:12 [INFO] [testng] riga[134]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
21:36:12 [INFO] [testng] riga[135]= [DayOfWeekCondition] (dayColonna:23) (dayColonnaTabella:23)
21:36:12 [INFO] [testng] riga[136]= [DayOfWeekCondition] (hourColonna:21) (hourColonnaTabella:21)
21:36:12 [INFO] [testng] riga[137]= [DayOfWeekCondition] (minuteColonna:36) (minuteColonnaTabella:36)
21:36:12 [INFO] [testng] riga[138]= [DayOfWeekCondition] (secondColonna:11.05) (secondColonnaTabella:11.05)
21:36:12 [INFO] [testng] riga[139]= [DayOfWeekCondition] (fullDayNameColonna:FRIDAY) (fullDayNameColonnaTabella:FRIDAY)
21:36:12 [INFO] [testng] riga[140]= [DayOfWeekCondition] (shortDayNameColonna:FRI) (shortDayNameColonnaTabella:FRI)
21:36:12 [INFO] [testng] riga[141]= [DayOfWeekCondition] (dayOfYearColonna:023) (dayOfYearColonnaTabella:023)
21:36:12 [INFO] [testng] riga[142]= [DayOfWeekCondition] (dayOfWeekColonna:6) (dayOfWeekColonnaTabella:6)
21:36:12 [INFO] [testng] riga[143]= [DayOfWeekCondition] (data:2026-01-23 21:36:11.052)
21:36:12 [INFO] [testng] riga[144]= [DayOfWeekCondition] (yearColonna:2026) (yearColonnaTabella:2026)
21:36:12 [INFO] [testng] riga[145]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
21:36:12 [INFO] [testng] riga[146]= [DayOfWeekCondition] (dayColonna:23) (dayColonnaTabella:23)
21:36:12 [INFO] [testng] riga[147]= [DayOfWeekCondition] (hourColonna:21) (hourColonnaTabella:21)
21:36:12 [INFO] [testng] riga[148]= [DayOfWeekCondition] (minuteColonna:36) (minuteColonnaTabella:36)
21:36:12 [INFO] [testng] riga[149]= [DayOfWeekCondition] (secondColonna:11.052359) (secondColonnaTabella:11.052359)
21:36:12 [INFO] [testng] riga[150]= [DayOfWeekCondition] (fullDayNameColonna:FRIDAY) (fullDayNameColonnaTabella:FRIDAY)
21:36:12 [INFO] [testng] riga[151]= [DayOfWeekCondition] (shortDayNameColonna:FRI) (shortDayNameColonnaTabella:FRI)
21:36:12 [INFO] [testng] riga[152]= [DayOfWeekCondition] (dayOfYearColonna:023) (dayOfYearColonnaTabella:023)
21:36:12 [INFO] [testng] riga[153]= [DayOfWeekCondition] (dayOfWeekColonna:6) (dayOfWeekColonnaTabella:6)
21:36:12 [INFO] [testng] riga[154]= [DayOfWeekCondition] (data:2026-01-23 21:36:11.053)
21:36:12 [INFO] [testng] riga[155]= [DayOfWeekCondition] (yearColonna:2026) (yearColonnaTabella:2026)
21:36:12 [INFO] [testng] riga[156]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
21:36:12 [INFO] [testng] riga[157]= [DayOfWeekCondition] (dayColonna:23) (dayColonnaTabella:23)
21:36:12 [INFO] [testng] riga[158]= [DayOfWeekCondition] (hourColonna:21) (hourColonnaTabella:21)
21:36:12 [INFO] [testng] riga[159]= [DayOfWeekCondition] (minuteColonna:36) (minuteColonnaTabella:36)
21:36:12 [INFO] [testng] riga[160]= [DayOfWeekCondition] (secondColonna:11.053) (secondColonnaTabella:11.053)
21:36:12 [INFO] [testng] riga[161]= [DayOfWeekCondition] (fullDayNameColonna:FRIDAY) (fullDayNameColonnaTabella:FRIDAY)
21:36:12 [INFO] [testng] riga[162]= [DayOfWeekCondition] (shortDayNameColonna:FRI) (shortDayNameColonnaTabella:FRI)
21:36:12 [INFO] [testng] riga[163]= [DayOfWeekCondition] (dayOfYearColonna:023) (dayOfYearColonnaTabella:023)
21:36:12 [INFO] [testng] riga[164]= [DayOfWeekCondition] (dayOfWeekColonna:6) (dayOfWeekColonnaTabella:6)
21:36:12 [INFO] [testng] riga[165]= [DayOfWeekCondition] (data:2026-01-23 21:36:11.055)
21:36:12 [INFO] [testng] riga[166]= [DayOfWeekCondition] (yearColonna:2026) (yearColonnaTabella:2026)
21:36:12 [INFO] [testng] riga[167]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
21:36:12 [INFO] [testng] riga[168]= [DayOfWeekCondition] (dayColonna:23) (dayColonnaTabella:23)
21:36:12 [INFO] [testng] riga[169]= [DayOfWeekCondition] (hourColonna:21) (hourColonnaTabella:21)
21:36:12 [INFO] [testng] riga[170]= [DayOfWeekCondition] (minuteColonna:36) (minuteColonnaTabella:36)
21:36:12 [INFO] [testng] riga[171]= [DayOfWeekCondition] (secondColonna:11.055235) (secondColonnaTabella:11.055235)
21:36:12 [INFO] [testng] riga[172]= [DayOfWeekCondition] (fullDayNameColonna:FRIDAY) (fullDayNameColonnaTabella:FRIDAY)
21:36:12 [INFO] [testng] riga[173]= [DayOfWeekCondition] (shortDayNameColonna:FRI) (shortDayNameColonnaTabella:FRI)
21:36:12 [INFO] [testng] riga[174]= [DayOfWeekCondition] (dayOfYearColonna:023) (dayOfYearColonnaTabella:023)
21:36:12 [INFO] [testng] riga[175]= [DayOfWeekCondition] (dayOfWeekColonna:6) (dayOfWeekColonnaTabella:6)
21:36:12 [INFO] [testng] riga[176]= [DayOfWeekCondition] (data:2026-01-23 21:36:11.056)
21:36:12 [INFO] [testng] riga[177]= [DayOfWeekCondition] (yearColonna:2026) (yearColonnaTabella:2026)
21:36:12 [INFO] [testng] riga[178]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
21:36:12 [INFO] [testng] riga[179]= [DayOfWeekCondition] (dayColonna:23) (dayColonnaTabella:23)
21:36:12 [INFO] [testng] riga[180]= [DayOfWeekCondition] (hourColonna:21) (hourColonnaTabella:21)
21:36:12 [INFO] [testng] riga[181]= [DayOfWeekCondition] (minuteColonna:36) (minuteColonnaTabella:36)
21:36:12 [INFO] [testng] riga[182]= [DayOfWeekCondition] (secondColonna:11.056) (secondColonnaTabella:11.056)
21:36:12 [INFO] [testng] riga[183]= [DayOfWeekCondition] (fullDayNameColonna:FRIDAY) (fullDayNameColonnaTabella:FRIDAY)
21:36:12 [INFO] [testng] riga[184]= [DayOfWeekCondition] (shortDayNameColonna:FRI) (shortDayNameColonnaTabella:FRI)
21:36:12 [INFO] [testng] riga[185]= [DayOfWeekCondition] (dayOfYearColonna:023) (dayOfYearColonnaTabella:023)
21:36:12 [INFO] [testng] riga[186]= [DayOfWeekCondition] (dayOfWeekColonna:6) (dayOfWeekColonnaTabella:6)
21:36:12 [INFO] [testng] riga[187]= [DayOfWeekCondition] (data:2026-01-23 21:36:11.057)
21:36:12 [INFO] [testng] riga[188]= [DayOfWeekCondition] (yearColonna:2026) (yearColonnaTabella:2026)
21:36:12 [INFO] [testng] riga[189]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
21:36:12 [INFO] [testng] riga[190]= [DayOfWeekCondition] (dayColonna:23) (dayColonnaTabella:23)
21:36:12 [INFO] [testng] riga[191]= [DayOfWeekCondition] (hourColonna:21) (hourColonnaTabella:21)
21:36:12 [INFO] [testng] riga[192]= [DayOfWeekCondition] (minuteColonna:36) (minuteColonnaTabella:36)
21:36:12 [INFO] [testng] riga[193]= [DayOfWeekCondition] (secondColonna:11.057965) (secondColonnaTabella:11.057965)
21:36:12 [INFO] [testng] riga[194]= [DayOfWeekCondition] (fullDayNameColonna:FRIDAY) (fullDayNameColonnaTabella:FRIDAY)
21:36:12 [INFO] [testng] riga[195]= [DayOfWeekCondition] (shortDayNameColonna:FRI) (shortDayNameColonnaTabella:FRI)
21:36:12 [INFO] [testng] riga[196]= [DayOfWeekCondition] (dayOfYearColonna:023) (dayOfYearColonnaTabella:023)
21:36:12 [INFO] [testng] riga[197]= [DayOfWeekCondition] (dayOfWeekColonna:6) (dayOfWeekColonnaTabella:6)
21:36:12 [INFO] [testng] riga[198]= [DayOfWeekCondition] (data:2026-01-23 21:36:11.059)
21:36:12 [INFO] [testng] riga[199]= [DayOfWeekCondition] (yearColonna:2026) (yearColonnaTabella:2026)
21:36:12 [INFO] [testng] riga[200]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
21:36:12 [INFO] [testng] riga[201]= [DayOfWeekCondition] (dayColonna:23) (dayColonnaTabella:23)
21:36:12 [INFO] [testng] riga[202]= [DayOfWeekCondition] (hourColonna:21) (hourColonnaTabella:21)
21:36:12 [INFO] [testng] riga[203]= [DayOfWeekCondition] (minuteColonna:36) (minuteColonnaTabella:36)
21:36:12 [INFO] [testng] riga[204]= [DayOfWeekCondition] (secondColonna:11.059) (secondColonnaTabella:11.059)
21:36:12 [INFO] [testng] riga[205]= [DayOfWeekCondition] (fullDayNameColonna:FRIDAY) (fullDayNameColonnaTabella:FRIDAY)
21:36:12 [INFO] [testng] riga[206]= [DayOfWeekCondition] (shortDayNameColonna:FRI) (shortDayNameColonnaTabella:FRI)
21:36:12 [INFO] [testng] riga[207]= [DayOfWeekCondition] (dayOfYearColonna:023) (dayOfYearColonnaTabella:023)
21:36:12 [INFO] [testng] riga[208]= [DayOfWeekCondition] (dayOfWeekColonna:6) (dayOfWeekColonnaTabella:6)
21:36:12 [INFO] [testng] riga[209]= [DayOfWeekCondition] (data:2026-01-23 21:36:11.060)
21:36:12 [INFO] [testng] riga[210]= [DayOfWeekCondition] (yearColonna:2026) (yearColonnaTabella:2026)
21:36:12 [INFO] [testng] riga[211]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
21:36:12 [INFO] [testng] riga[212]= [DayOfWeekCondition] (dayColonna:23) (dayColonnaTabella:23)
21:36:12 [INFO] [testng] riga[213]= [DayOfWeekCondition] (hourColonna:21) (hourColonnaTabella:21)
21:36:12 [INFO] [testng] riga[214]= [DayOfWeekCondition] (minuteColonna:36) (minuteColonnaTabella:36)
21:36:12 [INFO] [testng] riga[215]= [DayOfWeekCondition] (secondColonna:11.060612) (secondColonnaTabella:11.060612)
21:36:12 [INFO] [testng] riga[216]= [DayOfWeekCondition] (fullDayNameColonna:FRIDAY) (fullDayNameColonnaTabella:FRIDAY)
21:36:12 [INFO] [testng] riga[217]= [DayOfWeekCondition] (shortDayNameColonna:FRI) (shortDayNameColonnaTabella:FRI)
21:36:12 [INFO] [testng] riga[218]= [DayOfWeekCondition] (dayOfYearColonna:023) (dayOfYearColonnaTabella:023)
21:36:12 [INFO] [testng] riga[219]= [DayOfWeekCondition] (dayOfWeekColonna:6) (dayOfWeekColonnaTabella:6)
21:36:12 [INFO] [testng] riga[220]= [DayOfWeekCondition] (data:2026-01-23 21:36:11.062)
21:36:12 [INFO] [testng] riga[221]= [DayOfWeekCondition] (yearColonna:2026) (yearColonnaTabella:2026)
21:36:12 [INFO] [testng] riga[222]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
21:36:12 [INFO] [testng] riga[223]= [DayOfWeekCondition] (dayColonna:23) (dayColonnaTabella:23)
21:36:12 [INFO] [testng] riga[224]= [DayOfWeekCondition] (hourColonna:21) (hourColonnaTabella:21)
21:36:12 [INFO] [testng] riga[225]= [DayOfWeekCondition] (minuteColonna:36) (minuteColonnaTabella:36)
21:36:12 [INFO] [testng] riga[226]= [DayOfWeekCondition] (secondColonna:11.062) (secondColonnaTabella:11.062)
21:36:12 [INFO] [testng] riga[227]= [DayOfWeekCondition] (fullDayNameColonna:FRIDAY) (fullDayNameColonnaTabella:FRIDAY)
21:36:12 [INFO] [testng] riga[228]= [DayOfWeekCondition] (shortDayNameColonna:FRI) (shortDayNameColonnaTabella:FRI)
21:36:12 [INFO] [testng] riga[229]= [DayOfWeekCondition] (dayOfYearColonna:023) (dayOfYearColonnaTabella:023)
21:36:12 [INFO] [testng] riga[230]= [DayOfWeekCondition] (dayOfWeekColonna:6) (dayOfWeekColonnaTabella:6)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] test0_engine:
21:36:12 [INFO] [testng] SELECT timestamp '2026-01-23 21:36:12.543' as data_attuale,timestamp '2022-01-01 12:34:56.789' as data_passata,timestamp '2092-10-31 17:34:56.789' as data_futura FROM msgdiagnostici as aliasMSG
21:36:12 [INFO] [testng] riga[0]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[2]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[4]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[6]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[8]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[10]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[12]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[14]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[16]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[18]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[20]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[22]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[24]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[26]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[28]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[30]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[32]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[34]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[36]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[38]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[40]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] test0_engine:
21:36:12 [INFO] [testng] SELECT timestamp '2026-01-23 21:36:12.543' as data_attuale,timestamp '2022-01-01 12:34:56.789' as data_passata,timestamp '2092-10-31 17:34:56.789' as data_futura FROM msgdiagnostici as aliasMSG WHERE ( timestamp '2026-01-23 21:36:12.543'=? ) AND ( timestamp '2022-01-01 12:34:56.789'<? ) AND ( timestamp '2092-10-31 17:34:56.789'>? )
21:36:12 [INFO] [testng] riga[0]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[2]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[4]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[6]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[8]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[10]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[12]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[14]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[16]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[18]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[20]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[22]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[24]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[26]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[28]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[30]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[32]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[34]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[36]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[38]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] riga[40]= (now:2026-01-23 21:36:12.543) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
21:36:12 [INFO] [testng] (test0_engine) [postgresql] getFieldsName: [cont, avgMedio, mittente, ALIASDEST]
21:36:12 [INFO] [testng] (test0_engine) [postgresql] getTablesName: [tracce, aliasMSG]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] test0_engine:
21:36:12 [INFO] [testng] SELECT DISTINCT count(DISTINCT aliasMSG.id) as cont,avg(aliasMSG.id) as avgMedio,aliasMSG.mittente,aliasMSG.destinatario as ALIASDEST FROM tracce,msgdiagnostici as aliasMSG WHERE ( tracce.tipo_mittente is not null ) GROUP BY aliasMSG.mittente,aliasMSG.destinatario ORDER BY cont DESC ,avgMedio ASC ,mittente ASC ,ALIASDEST DESC
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0->SoggettoDestinatario0) (count:2)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente1->SoggettoDestinatario1) (count:2)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente2->SoggettoDestinatario2) (count:2)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente3->SoggettoDestinatario3) (count:2)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente4->SoggettoDestinatario4) (count:2)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente5->SoggettoDestinatario5) (count:2)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente6->SoggettoDestinatario6) (count:2)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente7->SoggettoDestinatario7) (count:2)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente8->SoggettoDestinatario8) (count:2)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente9->SoggettoDestinatario9) (count:2)
21:36:12 [INFO] [testng] riga[10]= (SoggettoMittente10->SoggettoDestinatario10) (count:1)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] a. ** Query normale
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(false) [postgresql] [QueryNormale]:
21:36:12 [INFO] [testng] SELECT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC FOR UPDATE
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
21:36:12 [INFO] [testng] riga[10]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
21:36:12 [INFO] [testng] riga[11]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
21:36:12 [INFO] [testng] riga[12]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
21:36:12 [INFO] [testng] riga[13]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
21:36:12 [INFO] [testng] riga[14]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
21:36:12 [INFO] [testng] riga[15]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
21:36:12 [INFO] [testng] riga[16]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
21:36:12 [INFO] [testng] riga[17]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
21:36:12 [INFO] [testng] riga[18]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
21:36:12 [INFO] [testng] riga[19]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
21:36:12 [INFO] [testng] riga[20]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] b. ** Query con limit/offset
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(false) [postgresql] [QueryLimitOffset]:
21:36:12 [INFO] [testng] SELECT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC LIMIT 10 OFFSET 0
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] b. ** Query con limit/offset (unixTimestamp)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(false) [postgresql] [QueryLimitOffset]:
21:36:12 [INFO] [testng] SELECT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente,gdo2,gdo,(date_part('epoch',( gdo2 - gdo ))*1000) as latenza FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC ,(date_part('epoch',( gdo2 - gdo ))*1000) ASC LIMIT 10 OFFSET 0
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)(45)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)(10371800101)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)(91)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)(31104600303)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)(217732202121)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)(137)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)(51844600505)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)(183)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)(72581000707)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)(228)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] c. ** Query con limit
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(false) [postgresql] [QueryLimit]:
21:36:12 [INFO] [testng] SELECT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC LIMIT 10
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] d. ** Query con offset
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(false) [postgresql] [QueryOffset]:
21:36:12 [INFO] [testng] SELECT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC OFFSET 2
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
21:36:12 [INFO] [testng] riga[10]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
21:36:12 [INFO] [testng] riga[11]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
21:36:12 [INFO] [testng] riga[12]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
21:36:12 [INFO] [testng] riga[13]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
21:36:12 [INFO] [testng] riga[14]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
21:36:12 [INFO] [testng] riga[15]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
21:36:12 [INFO] [testng] riga[16]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
21:36:12 [INFO] [testng] riga[17]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
21:36:12 [INFO] [testng] riga[18]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] e. ** Query groupBy
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(false) [postgresql] [GroupBy]:
21:36:12 [INFO] [testng] SELECT count(DISTINCT id) as cont,mittente,tracce.tipo_destinatario as TIPODEST,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,tracce.tipo_destinatario,tracce.destinatario ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0) = 2
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente1) = 2
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente10) = 1
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente2) = 2
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente3) = 2
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente4) = 2
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente5) = 2
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente6) = 2
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente7) = 2
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente8) = 2
21:36:12 [INFO] [testng] riga[10]= (SoggettoMittente9) = 2
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] f. ** Query groupBy con limit/offset
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(false) [postgresql] [GroupByLimitOffset]:
21:36:12 [INFO] [testng] SELECT count(DISTINCT id) as cont,mittente,tracce.tipo_destinatario as TIPODEST,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,tracce.tipo_destinatario,tracce.destinatario ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC LIMIT 5 OFFSET 1
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente1) = 2
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente10) = 1
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente2) = 2
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente3) = 2
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente4) = 2
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] g. ** Query con select*
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(false) [postgresql] [QuerySelect*]:
21:36:12 [INFO] [testng] SELECT * FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,tipo_destinatario ASC ,tracce.destinatario DESC FOR UPDATE
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente0)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente1)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente1)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente10)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente2)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente2)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente3)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente3)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente4)
21:36:12 [INFO] [testng] riga[10]= (SoggettoMittente4)
21:36:12 [INFO] [testng] riga[11]= (SoggettoMittente5)
21:36:12 [INFO] [testng] riga[12]= (SoggettoMittente5)
21:36:12 [INFO] [testng] riga[13]= (SoggettoMittente6)
21:36:12 [INFO] [testng] riga[14]= (SoggettoMittente6)
21:36:12 [INFO] [testng] riga[15]= (SoggettoMittente7)
21:36:12 [INFO] [testng] riga[16]= (SoggettoMittente7)
21:36:12 [INFO] [testng] riga[17]= (SoggettoMittente8)
21:36:12 [INFO] [testng] riga[18]= (SoggettoMittente8)
21:36:12 [INFO] [testng] riga[19]= (SoggettoMittente9)
21:36:12 [INFO] [testng] riga[20]= (SoggettoMittente9)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] h. ** Query con select* e offset/limit
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(false) [postgresql] [QuerySelect*LimitOffset*]:
21:36:12 [INFO] [testng] SELECT * FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,tipo_destinatario ASC ,tracce.destinatario DESC LIMIT 10 OFFSET 0
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente0)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente1)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente1)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente10)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente2)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente2)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente3)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente3)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente4)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] i. ** Query con select* e offset/limit e alias
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(false) [postgresql] [QuerySelect*LimitOffsetAlias*]:
21:36:12 [INFO] [testng] SELECT * FROM tracce as tr WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,tipo_destinatario ASC ,tr.destinatario DESC LIMIT 10 OFFSET 0
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente0)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente1)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente1)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente10)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente2)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente2)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente3)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente3)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente4)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] a. ** Query normale
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(true) [postgresql] [QueryNormale]:
21:36:12 [INFO] [testng] SELECT DISTINCT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
21:36:12 [INFO] [testng] riga[10]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] b. ** Query con limit/offset
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(true) [postgresql] [QueryLimitOffset]:
21:36:12 [INFO] [testng] SELECT DISTINCT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC LIMIT 10 OFFSET 0
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] b. ** Query con limit/offset (unixTimestamp)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(true) [postgresql] [QueryLimitOffset]:
21:36:12 [INFO] [testng] SELECT DISTINCT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente,gdo2,gdo,(date_part('epoch',( gdo2 - gdo ))*1000) as latenza FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC ,(date_part('epoch',( gdo2 - gdo ))*1000) ASC LIMIT 10 OFFSET 0
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)(45)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)(10371800101)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)(91)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)(31104600303)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)(217732202121)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)(137)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)(51844600505)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)(183)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)(72581000707)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)(228)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] c. ** Query con limit
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(true) [postgresql] [QueryLimit]:
21:36:12 [INFO] [testng] SELECT DISTINCT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC LIMIT 10
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] d. ** Query con offset
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(true) [postgresql] [QueryOffset]:
21:36:12 [INFO] [testng] SELECT DISTINCT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC OFFSET 2
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] e. ** Query groupBy
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(true) [postgresql] [GroupBy]:
21:36:12 [INFO] [testng] SELECT DISTINCT count(DISTINCT id) as cont,mittente,tracce.tipo_destinatario as TIPODEST,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,tracce.tipo_destinatario,tracce.destinatario ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0) = 2
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente1) = 2
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente10) = 1
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente2) = 2
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente3) = 2
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente4) = 2
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente5) = 2
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente6) = 2
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente7) = 2
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente8) = 2
21:36:12 [INFO] [testng] riga[10]= (SoggettoMittente9) = 2
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] f. ** Query groupBy con limit/offset
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test1(true) [postgresql] [GroupByLimitOffset]:
21:36:12 [INFO] [testng] SELECT DISTINCT count(DISTINCT id) as cont,mittente,tracce.tipo_destinatario as TIPODEST,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,tracce.tipo_destinatario,tracce.destinatario ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC LIMIT 5 OFFSET 1
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente1) = 2
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente10) = 1
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente2) = 2
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente3) = 2
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente4) = 2
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] g. ** Query con select*
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] h. ** Query con select* e offset/limit
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] i. ** Query con select* e offset/limit e alias
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] a. ** Query Union (unionCount:false unionAll:true)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [Normale UnionAll]:
21:36:12 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente0):[2]
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente1):[2]
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente1):[2]
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente10):[1]
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente10):[1]
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente2):[2]
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente2):[2]
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente3):[2]
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente3):[2]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] b. ** Query Union OffSetLimit (unionCount:false unionAll:true)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [OffSetLimit UnionAll]:
21:36:12 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC LIMIT 6 OFFSET 2
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente1):[2]
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente10):[1]
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente10):[1]
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente2):[2]
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente2):[2]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] c. ** Query Union OffSet (unionCount:false unionAll:true)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [OffSet UnionAll]:
21:36:12 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC OFFSET 2
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente1):[2]
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente10):[1]
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente10):[1]
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente2):[2]
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente2):[2]
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente3):[2]
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente3):[2]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] d. ** Query Union Limit (unionCount:false unionAll:true)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [OffSet UnionAll]:
21:36:12 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC LIMIT 4
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente0):[2]
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente1):[2]
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente1):[2]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] e. ** Query Union con select* (unionCount:false unionAll:true)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [Normale UnionAll]:
21:36:12 [INFO] [testng] SELECT * FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente0):[2]
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente1):[2]
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente1):[2]
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente10):[1]
21:36:12 [INFO] [testng] riga[5]= (SoggettoMittente10):[1]
21:36:12 [INFO] [testng] riga[6]= (SoggettoMittente2):[2]
21:36:12 [INFO] [testng] riga[7]= (SoggettoMittente2):[2]
21:36:12 [INFO] [testng] riga[8]= (SoggettoMittente3):[2]
21:36:12 [INFO] [testng] riga[9]= (SoggettoMittente3):[2]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] f. ** Query Union con select* e LimitOffset (unionCount:false unionAll:true)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] g. ** Query Union con select* e Offset (unionCount:false unionAll:true)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] h. ** Query Union con select* e Limit (unionCount:false unionAll:true)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] i. ** Query Union per test SelectForUpdate (unionCount:false unionAll:true)
21:36:12 [INFO] [testng] ERRORE ATTESO: Parametro SqlQueryObject[0] non valido: Utilizzo dell'opzione 'FOR UPDATE' non permesso con il comando UNION
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] a. ** Query Union (unionCount:true unionAll:true)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test(count:true unionAll:true) [postgresql] [Normale UnionAll]:
21:36:12 [INFO] [testng] SELECT count(*) as aliasUnion FROM ( SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ) as subquery2
21:36:12 [INFO] [testng] riga[0]= [10]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] e. ** Query Union con select* (unionCount:true unionAll:true)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test(count:true unionAll:true) [postgresql] [Normale UnionAll]:
21:36:12 [INFO] [testng] SELECT count(*) as aliasUnion FROM ( SELECT * FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ) as subquery2
21:36:12 [INFO] [testng] riga[0]= [10]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] i. ** Query Union per test SelectForUpdate (unionCount:true unionAll:true)
21:36:12 [INFO] [testng] ERRORE ATTESO: Parametro SqlQueryObject[0] non valido: Utilizzo dell'opzione 'FOR UPDATE' non permesso con il comando UNION
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] a. ** Query Union (unionCount:false unionAll:false)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [Normale UnionAll]:
21:36:12 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente10):[1]
21:36:12 [INFO] [testng] riga[3]= (SoggettoMittente2):[2]
21:36:12 [INFO] [testng] riga[4]= (SoggettoMittente3):[2]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] b. ** Query Union OffSetLimit (unionCount:false unionAll:false)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [OffSetLimit UnionAll]:
21:36:12 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC LIMIT 3 OFFSET 1
21:36:12 [INFO] [testng] riga[0]= (SoggettoMittente1):[2]
21:36:12 [INFO] [testng] riga[1]= (SoggettoMittente10):[1]
21:36:12 [INFO] [testng] riga[2]= (SoggettoMittente2):[2]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] c. ** Query Union OffSet (unionCount:false unionAll:false)
21:36:12 [INFO] [testng]
21:36:12 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [OffSet UnionAll]:
21:36:13 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC OFFSET 1
21:36:13 [INFO] [testng] riga[0]= (SoggettoMittente1):[2]
21:36:13 [INFO] [testng] riga[1]= (SoggettoMittente10):[1]
21:36:13 [INFO] [testng] riga[2]= (SoggettoMittente2):[2]
21:36:13 [INFO] [testng] riga[3]= (SoggettoMittente3):[2]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] d. ** Query Union Limit (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [OffSet UnionAll]:
21:36:13 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC LIMIT 2
21:36:13 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
21:36:13 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] e. ** Query Union con select* (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [Normale UnionAll]:
21:36:13 [INFO] [testng] SELECT * FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC
21:36:13 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
21:36:13 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
21:36:13 [INFO] [testng] riga[2]= (SoggettoMittente10):[1]
21:36:13 [INFO] [testng] riga[3]= (SoggettoMittente2):[2]
21:36:13 [INFO] [testng] riga[4]= (SoggettoMittente3):[2]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] f. ** Query Union con select* e LimitOffset (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] g. ** Query Union con select* e Offset (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] h. ** Query Union con select* e Limit (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] i. ** Query Union per test SelectForUpdate (unionCount:false unionAll:false)
21:36:13 [INFO] [testng] ERRORE ATTESO: Parametro SqlQueryObject[0] non valido: Utilizzo dell'opzione 'FOR UPDATE' non permesso con il comando UNION
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] a. ** Query Union (unionCount:true unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:true unionAll:false) [postgresql] [Normale UnionAll]:
21:36:13 [INFO] [testng] SELECT count(*) as aliasUnion FROM ( SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ) as subquery2
21:36:13 [INFO] [testng] riga[0]= [5]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] e. ** Query Union con select* (unionCount:true unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:true unionAll:false) [postgresql] [Normale UnionAll]:
21:36:13 [INFO] [testng] SELECT count(*) as aliasUnion FROM ( SELECT * FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ) as subquery2
21:36:13 [INFO] [testng] riga[0]= [5]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] i. ** Query Union per test SelectForUpdate (unionCount:true unionAll:false)
21:36:13 [INFO] [testng] ERRORE ATTESO: Parametro SqlQueryObject[0] non valido: Utilizzo dell'opzione 'FOR UPDATE' non permesso con il comando UNION
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] a. ** Query UnionGroupBy (unionCount:false unionAll:true)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [Normale UnionAll]:
21:36:13 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC
21:36:13 [INFO] [testng] riga[0]= (SoggettoMittente0):[4]
21:36:13 [INFO] [testng] riga[1]= (SoggettoMittente1):[4]
21:36:13 [INFO] [testng] riga[2]= (SoggettoMittente10):[2]
21:36:13 [INFO] [testng] riga[3]= (SoggettoMittente2):[4]
21:36:13 [INFO] [testng] riga[4]= (SoggettoMittente3):[4]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] b. ** Query UnionGroupBy OffSetLimit (unionCount:false unionAll:true)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [OffSetLimit UnionAll]:
21:36:13 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 3 OFFSET 1
21:36:13 [INFO] [testng] riga[0]= (SoggettoMittente1):[4]
21:36:13 [INFO] [testng] riga[1]= (SoggettoMittente10):[2]
21:36:13 [INFO] [testng] riga[2]= (SoggettoMittente2):[4]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] c. ** Query UnionGroupBy OffSet (unionCount:false unionAll:true)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [OffSet UnionAll]:
21:36:13 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC OFFSET 1
21:36:13 [INFO] [testng] riga[0]= (SoggettoMittente1):[4]
21:36:13 [INFO] [testng] riga[1]= (SoggettoMittente10):[2]
21:36:13 [INFO] [testng] riga[2]= (SoggettoMittente2):[4]
21:36:13 [INFO] [testng] riga[3]= (SoggettoMittente3):[4]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] d. ** Query UnionGroupBy Limit (unionCount:false unionAll:true)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [OffSet UnionAll]:
21:36:13 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 2
21:36:13 [INFO] [testng] riga[0]= (SoggettoMittente0):[4]
21:36:13 [INFO] [testng] riga[1]= (SoggettoMittente1):[4]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] e. ** Query UnionGroupBy con select* (unionCount:false unionAll:true)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] f. ** Query UnionGroupBy con select* e LimitOffset (unionCount:false unionAll:true)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] g. ** Query UnionGroupBy con select* e Offset (unionCount:false unionAll:true)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] h. ** Query UnionGroupBy con select* e Limit (unionCount:false unionAll:true)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] a. ** Query UnionGroupBy (unionCount:true unionAll:true)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:true unionAll:true) [postgresql] [Normale UnionAll]:
21:36:13 [INFO] [testng] SELECT count(*) as aliasUnion FROM ( SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ) as subquery2
21:36:13 [INFO] [testng] riga[0]= [5]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] e. ** Query UnionGroupBy con select* (unionCount:true unionAll:true)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] a. ** Query UnionGroupBy (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [Normale UnionAll]:
21:36:13 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC
21:36:13 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
21:36:13 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
21:36:13 [INFO] [testng] riga[2]= (SoggettoMittente10):[1]
21:36:13 [INFO] [testng] riga[3]= (SoggettoMittente2):[2]
21:36:13 [INFO] [testng] riga[4]= (SoggettoMittente3):[2]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] b. ** Query UnionGroupBy OffSetLimit (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [OffSetLimit UnionAll]:
21:36:13 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 3 OFFSET 1
21:36:13 [INFO] [testng] riga[0]= (SoggettoMittente1):[2]
21:36:13 [INFO] [testng] riga[1]= (SoggettoMittente10):[1]
21:36:13 [INFO] [testng] riga[2]= (SoggettoMittente2):[2]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] c. ** Query UnionGroupBy OffSet (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [OffSet UnionAll]:
21:36:13 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC OFFSET 1
21:36:13 [INFO] [testng] riga[0]= (SoggettoMittente1):[2]
21:36:13 [INFO] [testng] riga[1]= (SoggettoMittente10):[1]
21:36:13 [INFO] [testng] riga[2]= (SoggettoMittente2):[2]
21:36:13 [INFO] [testng] riga[3]= (SoggettoMittente3):[2]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] d. ** Query UnionGroupBy Limit (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [OffSet UnionAll]:
21:36:13 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 2
21:36:13 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
21:36:13 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] e. ** Query UnionGroupBy con select* (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] f. ** Query UnionGroupBy con select* e LimitOffset (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] g. ** Query UnionGroupBy con select* e Offset (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] h. ** Query UnionGroupBy con select* e Limit (unionCount:false unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] a. ** Query UnionGroupBy (unionCount:true unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Test(count:true unionAll:false) [postgresql] [Normale UnionAll]:
21:36:13 [INFO] [testng] SELECT count(*) as aliasUnion FROM ( SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ) as subquery2
21:36:13 [INFO] [testng] riga[0]= [5]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] e. ** Query UnionGroupBy con select* (unionCount:true unionAll:false)
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] h. ** Test IS NULL / IS EMPTY
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-msgdiagnostici isNull:
21:36:13 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo FROM msgdiagnostici WHERE ( campo_vuoto is null ) ORDER BY gdo ASC FOR UPDATE
21:36:13 [INFO] [testng] riga[0]=descrizione esempio 1 (time:2026-01-23 21:36:11.035084 campo_vuoto:(null)
21:36:13 [INFO] [testng] riga[1]=descrizione esempio 2 (time:2026-01-23 21:36:11.036 campo_vuoto:(null)
21:36:13 [INFO] [testng] riga[2]=descrizione esempio 3 (time:2026-01-23 21:36:11.038108 campo_vuoto:(null)
21:36:13 [INFO] [testng] riga[3]=descrizione esempio 4 (time:2026-01-23 21:36:11.039 campo_vuoto:(null)
21:36:13 [INFO] [testng] riga[4]=descrizione esempio 5 (time:2026-01-23 21:36:11.040945 campo_vuoto:(null)
21:36:13 [INFO] [testng] riga[5]=descrizione esempio 6 (time:2026-01-23 21:36:11.042 campo_vuoto:(null)
21:36:13 [INFO] [testng] riga[6]=descrizione esempio 7 (time:2026-01-23 21:36:11.043715 campo_vuoto:(null)
21:36:13 [INFO] [testng] riga[7]=descrizione esempio 8 (time:2026-01-23 21:36:11.044 campo_vuoto:(null)
21:36:13 [INFO] [testng] riga[8]=descrizione esempio 9 (time:2026-01-23 21:36:11.046556 campo_vuoto:(null)
21:36:13 [INFO] [testng] riga[9]=descrizione esempio uguale (time:2026-01-23 21:36:11.048 campo_vuoto:(null)
21:36:13 [INFO] [testng] Attesi [10] trovati[10]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test2-msgdiagnostici isNotNull:
21:36:13 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo FROM msgdiagnostici WHERE ( campo_vuoto is not null ) ORDER BY gdo ASC FOR UPDATE
21:36:13 [INFO] [testng] riga[0]=descrizione esempio 0 (time:2026-01-23 21:36:11.032 campo_vuoto:(Prima colonna valorizzata)
21:36:13 [INFO] [testng] riga[1]=descrizione esempio uguale (time:2026-01-23 21:36:11.049609 campo_vuoto:()
21:36:13 [INFO] [testng] riga[2]=descrizione esempio uguale (time:2026-01-23 21:36:11.05 campo_vuoto:()
21:36:13 [INFO] [testng] riga[3]=descrizione esempio uguale (time:2026-01-23 21:36:11.052359 campo_vuoto:()
21:36:13 [INFO] [testng] riga[4]=descrizione esempio uguale (time:2026-01-23 21:36:11.053 campo_vuoto:()
21:36:13 [INFO] [testng] riga[5]=descrizione esempio uguale (time:2026-01-23 21:36:11.055235 campo_vuoto:()
21:36:13 [INFO] [testng] riga[6]=descrizione esempio uguale (time:2026-01-23 21:36:11.056 campo_vuoto:()
21:36:13 [INFO] [testng] riga[7]=descrizione esempio uguale (time:2026-01-23 21:36:11.057965 campo_vuoto:()
21:36:13 [INFO] [testng] riga[8]=descrizione esempio uguale (time:2026-01-23 21:36:11.059 campo_vuoto:()
21:36:13 [INFO] [testng] riga[9]=descrizione esempio uguale (time:2026-01-23 21:36:11.060612 campo_vuoto:()
21:36:13 [INFO] [testng] riga[10]=descrizione con caratteri particolari: ------- { ( [ _ % ^ \ / # | & à è @ . : ; , < parolaCasualeMAIUSCOLA > é ù ì ^ " ' ? ! ] ) } ------
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Un po di parole Maiuscole Minuscole § ° ç £----- (time:2026-01-23 21:36:11.062 campo_vuoto:(Ultima colonna valorizzata)Attesi [11] trovati[11]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test3-msgdiagnostici isEmpty:
21:36:13 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo FROM msgdiagnostici WHERE ( campo_vuoto = '' ) ORDER BY gdo ASC FOR UPDATE
21:36:13 [INFO] [testng] riga[0]=descrizione esempio uguale (time:2026-01-23 21:36:11.049609 campo_vuoto:()
21:36:13 [INFO] [testng] riga[1]=descrizione esempio uguale (time:2026-01-23 21:36:11.05 campo_vuoto:()
21:36:13 [INFO] [testng] riga[2]=descrizione esempio uguale (time:2026-01-23 21:36:11.052359 campo_vuoto:()
21:36:13 [INFO] [testng] riga[3]=descrizione esempio uguale (time:2026-01-23 21:36:11.053 campo_vuoto:()
21:36:13 [INFO] [testng] riga[4]=descrizione esempio uguale (time:2026-01-23 21:36:11.055235 campo_vuoto:()
21:36:13 [INFO] [testng] riga[5]=descrizione esempio uguale (time:2026-01-23 21:36:11.056 campo_vuoto:()
21:36:13 [INFO] [testng] riga[6]=descrizione esempio uguale (time:2026-01-23 21:36:11.057965 campo_vuoto:()
21:36:13 [INFO] [testng] riga[7]=descrizione esempio uguale (time:2026-01-23 21:36:11.059 campo_vuoto:()
21:36:13 [INFO] [testng] riga[8]=descrizione esempio uguale (time:2026-01-23 21:36:11.060612 campo_vuoto:()
21:36:13 [INFO] [testng] Attesi [9] trovati[9]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test4-msgdiagnostici isNotEmpty:
21:36:13 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo FROM msgdiagnostici WHERE ( campo_vuoto <> '' ) ORDER BY gdo ASC FOR UPDATE
21:36:13 [INFO] [testng] riga[0]=descrizione esempio 0 (time:2026-01-23 21:36:11.032 campo_vuoto:(Prima colonna valorizzata)
21:36:13 [INFO] [testng] riga[1]=descrizione con caratteri particolari: ------- { ( [ _ % ^ \ / # | & à è @ . : ; , < parolaCasualeMAIUSCOLA > é ù ì ^ " ' ? ! ] ) } ------
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] Un po di parole Maiuscole Minuscole § ° ç £----- (time:2026-01-23 21:36:11.062 campo_vuoto:(Ultima colonna valorizzata)Attesi [2] trovati[2]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] h. ** Test CASE
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-tracce case:
21:36:13 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo,mittente,destinatario FROM tracce WHERE ( campo_update is null ) AND ( campo_int_update is null ) ORDER BY gdo ASC
21:36:13 [INFO] [testng] riga[0] mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2026-01-23 21:36:11.063)
21:36:13 [INFO] [testng] riga[1] mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2026-01-23 21:36:11.065965)
21:36:13 [INFO] [testng] riga[2] mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2026-01-23 21:36:11.067)
21:36:13 [INFO] [testng] riga[3] mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2026-01-23 21:36:11.068879)
21:36:13 [INFO] [testng] riga[4] mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2026-01-23 21:36:11.07)
21:36:13 [INFO] [testng] riga[5] mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2026-01-23 21:36:11.071691)
21:36:13 [INFO] [testng] riga[6] mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2026-01-23 21:36:11.073)
21:36:13 [INFO] [testng] riga[7] mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2026-01-23 21:36:11.074744)
21:36:13 [INFO] [testng] riga[8] mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2026-01-23 21:36:11.076)
21:36:13 [INFO] [testng] riga[9] mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2026-01-23 21:36:11.078195)
21:36:13 [INFO] [testng] riga[10] mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2026-01-23 21:36:11.079)
21:36:13 [INFO] [testng] riga[11] mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2026-01-23 21:36:11.081204)
21:36:13 [INFO] [testng] riga[12] mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2026-01-23 21:36:11.082)
21:36:13 [INFO] [testng] riga[13] mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2026-01-23 21:36:11.08392)
21:36:13 [INFO] [testng] riga[14] mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2026-01-23 21:36:11.085)
21:36:13 [INFO] [testng] riga[15] mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2026-01-23 21:36:11.086684)
21:36:13 [INFO] [testng] riga[16] mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2026-01-23 21:36:11.087)
21:36:13 [INFO] [testng] riga[17] mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2026-01-23 21:36:11.089448)
21:36:13 [INFO] [testng] riga[18] mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2026-01-23 21:36:11.09)
21:36:13 [INFO] [testng] riga[19] mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2026-01-23 21:36:11.092839)
21:36:13 [INFO] [testng] riga[20] mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2026-01-23 21:36:11.094)
21:36:13 [INFO] [testng] Attesi [21] trovati[21]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-tracce case:
21:36:13 [INFO] [testng] UPDATE tracce SET campo_update = CASE WHEN mittente=? THEN ? WHEN mittente=? THEN ? ELSE ? END , campo_int_update = CASE WHEN mittente=? OR destinatario=? THEN ? WHEN mittente=? OR destinatario=? THEN ? ELSE ? END
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-tracce case:
21:36:13 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo,mittente,destinatario,campo_update,campo_int_update FROM tracce WHERE ( campo_update is not null ) AND ( campo_int_update is not null ) ORDER BY gdo ASC
21:36:13 [INFO] [testng] riga[0] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2026-01-23 21:36:11.063)
21:36:13 [INFO] [testng] riga[1] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2026-01-23 21:36:11.065965)
21:36:13 [INFO] [testng] riga[2] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2026-01-23 21:36:11.067)
21:36:13 [INFO] [testng] riga[3] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2026-01-23 21:36:11.068879)
21:36:13 [INFO] [testng] riga[4] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2026-01-23 21:36:11.07)
21:36:13 [INFO] [testng] riga[5] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2026-01-23 21:36:11.071691)
21:36:13 [INFO] [testng] riga[6] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2026-01-23 21:36:11.073)
21:36:13 [INFO] [testng] riga[7] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2026-01-23 21:36:11.074744)
21:36:13 [INFO] [testng] riga[8] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2026-01-23 21:36:11.076)
21:36:13 [INFO] [testng] riga[9] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2026-01-23 21:36:11.078195)
21:36:13 [INFO] [testng] riga[10] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2026-01-23 21:36:11.079)
21:36:13 [INFO] [testng] riga[11] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2026-01-23 21:36:11.081204)
21:36:13 [INFO] [testng] riga[12] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2026-01-23 21:36:11.082)
21:36:13 [INFO] [testng] riga[13] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2026-01-23 21:36:11.08392)
21:36:13 [INFO] [testng] riga[14] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2026-01-23 21:36:11.085)
21:36:13 [INFO] [testng] riga[15] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2026-01-23 21:36:11.086684)
21:36:13 [INFO] [testng] riga[16] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2026-01-23 21:36:11.087)
21:36:13 [INFO] [testng] riga[17] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2026-01-23 21:36:11.089448)
21:36:13 [INFO] [testng] riga[18] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2026-01-23 21:36:11.09)
21:36:13 [INFO] [testng] riga[19] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2026-01-23 21:36:11.092839)
21:36:13 [INFO] [testng] riga[20] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2026-01-23 21:36:11.094)
21:36:13 [INFO] [testng] Attesi [21] trovati[21]
21:36:13 [INFO] [testng] (stringCasoA) Attesi [2] trovati[2]
21:36:13 [INFO] [testng] (stringCasoB) Attesi [2] trovati[2]
21:36:13 [INFO] [testng] (stringCasoDefault) Attesi [17] trovati[17]
21:36:13 [INFO] [testng] (intCasoA) Attesi [4] trovati[4]
21:36:13 [INFO] [testng] (intCasoB) Attesi [4] trovati[4]
21:36:13 [INFO] [testng] (intCasoDefault) Attesi [13] trovati[13]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] h. ** Test CASE SENZA ELSE
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-tracce case:
21:36:13 [INFO] [testng] UPDATE tracce SET campo_update = ? , campo_int_update = ?
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-tracce case:
21:36:13 [INFO] [testng] UPDATE tracce SET campo_update = CASE WHEN mittente=? THEN ? WHEN mittente=? THEN ? END , campo_int_update = CASE WHEN mittente=? OR destinatario=? THEN ? WHEN mittente=? OR destinatario=? THEN ? END
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-tracce case:
21:36:13 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo,mittente,destinatario,campo_update,campo_int_update FROM tracce ORDER BY gdo ASC
21:36:13 [INFO] [testng] riga[0] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2026-01-23 21:36:11.063)
21:36:13 [INFO] [testng] riga[1] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2026-01-23 21:36:11.065965)
21:36:13 [INFO] [testng] riga[2] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2026-01-23 21:36:11.067)
21:36:13 [INFO] [testng] riga[3] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2026-01-23 21:36:11.068879)
21:36:13 [INFO] [testng] riga[4] (string:null int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2026-01-23 21:36:11.07)
21:36:13 [INFO] [testng] riga[5] (string:null int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2026-01-23 21:36:11.071691)
21:36:13 [INFO] [testng] riga[6] (string:null int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2026-01-23 21:36:11.073)
21:36:13 [INFO] [testng] riga[7] (string:null int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2026-01-23 21:36:11.074744)
21:36:13 [INFO] [testng] riga[8] (string:null int:0) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2026-01-23 21:36:11.076)
21:36:13 [INFO] [testng] riga[9] (string:null int:0) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2026-01-23 21:36:11.078195)
21:36:13 [INFO] [testng] riga[10] (string:null int:0) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2026-01-23 21:36:11.079)
21:36:13 [INFO] [testng] riga[11] (string:null int:0) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2026-01-23 21:36:11.081204)
21:36:13 [INFO] [testng] riga[12] (string:null int:0) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2026-01-23 21:36:11.082)
21:36:13 [INFO] [testng] riga[13] (string:null int:0) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2026-01-23 21:36:11.08392)
21:36:13 [INFO] [testng] riga[14] (string:null int:0) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2026-01-23 21:36:11.085)
21:36:13 [INFO] [testng] riga[15] (string:null int:0) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2026-01-23 21:36:11.086684)
21:36:13 [INFO] [testng] riga[16] (string:null int:0) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2026-01-23 21:36:11.087)
21:36:13 [INFO] [testng] riga[17] (string:null int:0) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2026-01-23 21:36:11.089448)
21:36:13 [INFO] [testng] riga[18] (string:null int:0) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2026-01-23 21:36:11.09)
21:36:13 [INFO] [testng] riga[19] (string:null int:0) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2026-01-23 21:36:11.092839)
21:36:13 [INFO] [testng] riga[20] (string:null int:0) mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2026-01-23 21:36:11.094)
21:36:13 [INFO] [testng] Attesi [21] trovati[21]
21:36:13 [INFO] [testng] (stringCasoA) Attesi [2] trovati[2]
21:36:13 [INFO] [testng] (stringCasoB) Attesi [2] trovati[2]
21:36:13 [INFO] [testng] (stringCasoDefault) Attesi [0] trovati[0]
21:36:13 [INFO] [testng] (intCasoA) Attesi [4] trovati[4]
21:36:13 [INFO] [testng] (intCasoB) Attesi [4] trovati[4]
21:36:13 [INFO] [testng] (intCasoDefault) Attesi [0] trovati[0]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] h. ** Test CASE senza ?
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-tracce case:
21:36:13 [INFO] [testng] UPDATE tracce SET campo_update = ? , campo_int_update = ?
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-tracce case:
21:36:13 [INFO] [testng] UPDATE tracce SET campo_update = CASE WHEN mittente=? THEN 'CASO_0' WHEN mittente=? THEN 'CASO_1' ELSE 'CASO_DEFAULT' END , campo_int_update = CASE WHEN mittente=? OR destinatario=? THEN 22 WHEN mittente=? OR destinatario=? THEN 33 ELSE 11 END
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-tracce case:
21:36:13 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo,mittente,destinatario,campo_update,campo_int_update FROM tracce WHERE ( campo_update is not null ) AND ( campo_int_update is not null ) ORDER BY gdo ASC
21:36:13 [INFO] [testng] riga[0] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2026-01-23 21:36:11.063)
21:36:13 [INFO] [testng] riga[1] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2026-01-23 21:36:11.065965)
21:36:13 [INFO] [testng] riga[2] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2026-01-23 21:36:11.067)
21:36:13 [INFO] [testng] riga[3] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2026-01-23 21:36:11.068879)
21:36:13 [INFO] [testng] riga[4] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2026-01-23 21:36:11.07)
21:36:13 [INFO] [testng] riga[5] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2026-01-23 21:36:11.071691)
21:36:13 [INFO] [testng] riga[6] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2026-01-23 21:36:11.073)
21:36:13 [INFO] [testng] riga[7] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2026-01-23 21:36:11.074744)
21:36:13 [INFO] [testng] riga[8] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2026-01-23 21:36:11.076)
21:36:13 [INFO] [testng] riga[9] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2026-01-23 21:36:11.078195)
21:36:13 [INFO] [testng] riga[10] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2026-01-23 21:36:11.079)
21:36:13 [INFO] [testng] riga[11] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2026-01-23 21:36:11.081204)
21:36:13 [INFO] [testng] riga[12] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2026-01-23 21:36:11.082)
21:36:13 [INFO] [testng] riga[13] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2026-01-23 21:36:11.08392)
21:36:13 [INFO] [testng] riga[14] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2026-01-23 21:36:11.085)
21:36:13 [INFO] [testng] riga[15] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2026-01-23 21:36:11.086684)
21:36:13 [INFO] [testng] riga[16] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2026-01-23 21:36:11.087)
21:36:13 [INFO] [testng] riga[17] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2026-01-23 21:36:11.089448)
21:36:13 [INFO] [testng] riga[18] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2026-01-23 21:36:11.09)
21:36:13 [INFO] [testng] riga[19] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2026-01-23 21:36:11.092839)
21:36:13 [INFO] [testng] riga[20] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2026-01-23 21:36:11.094)
21:36:13 [INFO] [testng] Attesi [21] trovati[21]
21:36:13 [INFO] [testng] (stringCasoA) Attesi [2] trovati[2]
21:36:13 [INFO] [testng] (stringCasoB) Attesi [2] trovati[2]
21:36:13 [INFO] [testng] (stringCasoDefault) Attesi [17] trovati[17]
21:36:13 [INFO] [testng] (intCasoA) Attesi [4] trovati[4]
21:36:13 [INFO] [testng] (intCasoB) Attesi [4] trovati[4]
21:36:13 [INFO] [testng] (intCasoDefault) Attesi [13] trovati[13]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] h. ** Test CASE SENZA ELSE senza ?
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-tracce case:
21:36:13 [INFO] [testng] UPDATE tracce SET campo_update = ? , campo_int_update = ?
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-tracce case:
21:36:13 [INFO] [testng] UPDATE tracce SET campo_update = CASE WHEN mittente=? THEN 'CASO_0' WHEN mittente=? THEN 'CASO_1' END , campo_int_update = CASE WHEN mittente=? OR destinatario=? THEN 22 WHEN mittente=? OR destinatario=? THEN 33 END
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] test1-tracce case:
21:36:13 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo,mittente,destinatario,campo_update,campo_int_update FROM tracce ORDER BY gdo ASC
21:36:13 [INFO] [testng] riga[0] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2026-01-23 21:36:11.063)
21:36:13 [INFO] [testng] riga[1] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2026-01-23 21:36:11.065965)
21:36:13 [INFO] [testng] riga[2] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2026-01-23 21:36:11.067)
21:36:13 [INFO] [testng] riga[3] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2026-01-23 21:36:11.068879)
21:36:13 [INFO] [testng] riga[4] (string:null int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2026-01-23 21:36:11.07)
21:36:13 [INFO] [testng] riga[5] (string:null int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2026-01-23 21:36:11.071691)
21:36:13 [INFO] [testng] riga[6] (string:null int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2026-01-23 21:36:11.073)
21:36:13 [INFO] [testng] riga[7] (string:null int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2026-01-23 21:36:11.074744)
21:36:13 [INFO] [testng] riga[8] (string:null int:0) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2026-01-23 21:36:11.076)
21:36:13 [INFO] [testng] riga[9] (string:null int:0) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2026-01-23 21:36:11.078195)
21:36:13 [INFO] [testng] riga[10] (string:null int:0) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2026-01-23 21:36:11.079)
21:36:13 [INFO] [testng] riga[11] (string:null int:0) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2026-01-23 21:36:11.081204)
21:36:13 [INFO] [testng] riga[12] (string:null int:0) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2026-01-23 21:36:11.082)
21:36:13 [INFO] [testng] riga[13] (string:null int:0) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2026-01-23 21:36:11.08392)
21:36:13 [INFO] [testng] riga[14] (string:null int:0) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2026-01-23 21:36:11.085)
21:36:13 [INFO] [testng] riga[15] (string:null int:0) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2026-01-23 21:36:11.086684)
21:36:13 [INFO] [testng] riga[16] (string:null int:0) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2026-01-23 21:36:11.087)
21:36:13 [INFO] [testng] riga[17] (string:null int:0) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2026-01-23 21:36:11.089448)
21:36:13 [INFO] [testng] riga[18] (string:null int:0) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2026-01-23 21:36:11.09)
21:36:13 [INFO] [testng] riga[19] (string:null int:0) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2026-01-23 21:36:11.092839)
21:36:13 [INFO] [testng] riga[20] (string:null int:0) mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2026-01-23 21:36:11.094)
21:36:13 [INFO] [testng] Attesi [21] trovati[21]
21:36:13 [INFO] [testng] (stringCasoA) Attesi [2] trovati[2]
21:36:13 [INFO] [testng] (stringCasoB) Attesi [2] trovati[2]
21:36:13 [INFO] [testng] (stringCasoDefault) Attesi [0] trovati[0]
21:36:13 [INFO] [testng] (intCasoA) Attesi [4] trovati[4]
21:36:13 [INFO] [testng] (intCasoB) Attesi [4] trovati[4]
21:36:13 [INFO] [testng] (intCasoDefault) Attesi [0] trovati[0]
21:36:13 [INFO] [testng] Testsuite completata
21:36:13 [INFO] [testng] Run test 'SQLGenerator' ok
21:36:13 [INFO] [testng]
21:36:13 [INFO] [testng] ===============================================
21:36:13 [INFO] [testng] Ant suite
21:36:13 [INFO] [testng] Total tests run: 6, Passes: 6, Failures: 0, Skips: 0
21:36:13 [INFO] [testng] ===============================================
21:36:13 [INFO] [testng]
21:36:14 [INFO] [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/tools/utils/mvn/sql/build_testunits
21:36:14 [INFO] Executed tasks
21:36:14 [INFO]
21:36:14 [INFO] ---------< org.openspcoop2:org.openspcoop2.testsuite.pdd.core >---------
21:36:14 [INFO] Building testsuite.pdd.core 1.0 [66/71]
21:36:14 [INFO] --------------------------------[ pom ]---------------------------------
21:36:14 [INFO]
21:36:14 [INFO] -------< org.openspcoop2:org.openspcoop2.testsuite.pdd.core.sql >-------
21:36:14 [INFO] Building testsuite.pdd.core.sql 1.0 [67/71]
21:36:14 [INFO] --------------------------------[ pom ]---------------------------------
21:36:14 [INFO]
21:36:14 [INFO] --- maven-dependency-plugin:3.8.1:copy-dependencies (copy-dependencies) @ org.openspcoop2.testsuite.pdd.core.sql ---
21:36:14 [INFO] org.postgresql:postgresql:jar:9.4.1212 already exists in destination.
21:36:14 [INFO]
21:36:14 [INFO] --- maven-antrun-plugin:3.1.0:run (default) @ org.openspcoop2.testsuite.pdd.core.sql ---
21:36:14 [INFO] Executing tasks
21:36:15 [INFO] [unzip] Expanding: /var/lib/jenkins/workspace/GovWay/dist/openspcoop2_pdd-test-3.3.18.jar into /var/lib/jenkins/workspace/GovWay/core/mvn/sql/build_testunits
21:36:15 [INFO] [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite-result/pdd-sql
21:36:15 [WARNING] [echo] Avvio TestSuite (gruppo: pdd.sql) (haltOnFailure:true)
21:36:15 [INFO] [jacoco:coverage] Enhancing testng with coverage
21:36:17 [INFO] [testng] Run test 'GestoreRepositoryBuste' ...
21:36:17 [INFO] [testng] LogMessages write in /tmp/runGestoreRepositoryTest_12000904874705518390.log
21:36:19 [INFO] [testng] URL:jdbc:postgresql://localhost/govway_test
21:36:19 [INFO] [testng] UserName:govway
21:36:19 [INFO] [testng] Password:govway
21:36:19 [INFO] [testng] DriverJDBC:org.postgresql.Driver
21:36:19 [WARNING] [testng] WARNING: An illegal reflective access operation has occurred
21:36:19 [WARNING] [testng] WARNING: Illegal reflective access by org.postgresql.jdbc.TimestampUtils (file:/var/lib/jenkins/workspace/GovWay/core/lib/postgresql-9.4.1212.jar) to field java.util.TimeZone.defaultTimeZone
21:36:19 [WARNING] [testng] WARNING: Please consider reporting this to the maintainers of org.postgresql.jdbc.TimestampUtils
21:36:19 [WARNING] [testng] WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
21:36:19 [WARNING] [testng] WARNING: All illegal access operations will be denied in a future release
21:36:19 [INFO] [testng] Creato IGestoreRepository[bytewise] di tipo org.openspcoop2.protocol.engine.driver.repository.GestoreRepositoryBytewise
21:36:19 [INFO] [testng] createSQLFields: REPOSITORY_ACCESS
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] inserita riga: 1
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0)]
21:36:19 [INFO] [testng] (test 1. history=false). Trovata entry con valore: 0
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0) and (REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=4 OR REPOSITORY_ACCESS=0)]
21:36:19 [INFO] [testng] (test 2. history=false and profilo=false). Trovata entry con valore: 0
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0) and (REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=4 OR REPOSITORY_ACCESS=0) and (REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=4 OR REPOSITORY_ACCESS=0)]
21:36:19 [INFO] [testng] (test 3. history=false and profilo=false and pdd=false). Trovata entry con valore: 0
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS | 4)]
21:36:19 [INFO] [testng] aggiornata riga: 1
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0)]
21:36:19 [INFO] [testng] (test 4. history=false). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
21:36:19 [INFO] [testng] (test 5. history=true). Trovata entry con valore: 4
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS | 2)]
21:36:19 [INFO] [testng] aggiornata riga: 1
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
21:36:19 [INFO] [testng] (test 6. history=true). Trovata entry con valore: 6
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)and (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
21:36:19 [INFO] [testng] (test 7. history=true and profilo=true). Trovata entry con valore: 6
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
21:36:19 [INFO] [testng] (test 8. history=true or profilo=true). Trovata entry con valore: 6
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS | 1)]
21:36:19 [INFO] [testng] aggiornata riga: 1
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
21:36:19 [INFO] [testng] (test 9. history=true). Trovata entry con valore: 7
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)and (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
21:36:19 [INFO] [testng] (test 10. history=true and profilo=true). Trovata entry con valore: 7
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
21:36:19 [INFO] [testng] (test 1. history=true or profilo=true). Trovata entry con valore: 7
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)and (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)and (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1)]
21:36:19 [INFO] [testng] (test 12. history=true and profilo=true and pdd=true). Trovata entry con valore: 7
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1)]
21:36:19 [INFO] [testng] (test 13. history=true or profilo=true or pdd=true). Trovata entry con valore: 7
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=4)]
21:36:19 [INFO] [testng] (test 14. onlyHistory). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=2)]
21:36:19 [INFO] [testng] (test 15. onlyProfilo). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=1)]
21:36:19 [INFO] [testng] (test 16. onlyPdd). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3)]
21:36:19 [INFO] [testng] (test 17. onlyPddAndProfilo). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=0)]
21:36:19 [INFO] [testng] (test 18. disableAll). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS & 3)]
21:36:19 [INFO] [testng] aggiornata riga: 1
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
21:36:19 [INFO] [testng] (test 19. history=true). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
21:36:19 [INFO] [testng] (test 20. pdd=true or profilo=true). Trovata entry con valore: 3
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=2)]
21:36:19 [INFO] [testng] (test 21. onlyProfilo). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=1)]
21:36:19 [INFO] [testng] (test 22. onlyPdd). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3)]
21:36:19 [INFO] [testng] (test 23. pddAndProfilo). Trovata entry con valore: 3
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=0)]
21:36:19 [INFO] [testng] (test 24. disableAll). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS & 6)]
21:36:19 [INFO] [testng] aggiornata riga: 1
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
21:36:19 [INFO] [testng] (test 25. history=true). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
21:36:19 [INFO] [testng] (test 26. pdd=true or profilo=true). Trovata entry con valore: 2
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=2)]
21:36:19 [INFO] [testng] (test 27. profilo=true). Trovata entry con valore: 2
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=1)]
21:36:19 [INFO] [testng] (test 28. onlyPdd). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3)]
21:36:19 [INFO] [testng] (test 29. pddAndProfilo). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=0)]
21:36:19 [INFO] [testng] (test 30. disableAll). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS & 5)]
21:36:19 [INFO] [testng] aggiornata riga: 1
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
21:36:19 [INFO] [testng] (test 31. history=true). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
21:36:19 [INFO] [testng] (test 32. pdd=true or profilo=true). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=2)]
21:36:19 [INFO] [testng] (test 33. onlyProfilo). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=1)]
21:36:19 [INFO] [testng] (test 34. onlyPdd). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3)]
21:36:19 [INFO] [testng] (test 35. pddAndProfilo). Non e' stata trovata correttamente una entry
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=0)]
21:36:19 [INFO] [testng] (test 36. disableAll). Trovata entry con valore: 0
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] inserita riga: 1
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
21:36:19 [INFO] [testng] (test 37. history=true). Trovata entry con valore: 4
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] inserita riga: 1
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0)]
21:36:19 [INFO] [testng] (test 38. history=false). Trovata entry con valore: 0
21:36:19 [INFO] [testng] Run test 'GestoreRepositoryBuste' ok
21:36:19 [INFO] [testng]
21:36:19 [INFO] [testng] ===============================================
21:36:19 [INFO] [testng] Ant suite
21:36:19 [INFO] [testng] Total tests run: 1, Passes: 1, Failures: 0, Skips: 0
21:36:19 [INFO] [testng] ===============================================
21:36:19 [INFO] [testng]
21:36:20 [INFO] [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/core/mvn/sql/build_testunits
21:36:20 [INFO] Executed tasks
21:36:20 [INFO]
21:36:20 [INFO] ------< org.openspcoop2:org.openspcoop2.static_analysis.spotbugs >------
21:36:20 [INFO] Building static_analysis.spotbugs 1.0 [68/71]
21:36:20 [INFO] --------------------------------[ pom ]---------------------------------
21:36:20 [INFO]
21:36:20 [INFO] -----< org.openspcoop2:org.openspcoop2.static_analysis.sonarqube >------
21:36:20 [INFO] Building static_analysis.sonarqube 1.0 [69/71]
21:36:20 [INFO] --------------------------------[ pom ]---------------------------------
21:36:20 [INFO]
21:36:20 [INFO] --------< org.openspcoop2:org.openspcoop2.dynamic_analysis.zap >--------
21:36:20 [INFO] Building dynamic_analysis.zap 1.0 [70/71]
21:36:20 [INFO] --------------------------------[ pom ]---------------------------------
21:36:20 [INFO]
21:36:20 [INFO] ----------< org.openspcoop2:org.openspcoop2.coverage.jacoco >-----------
21:36:20 [INFO] Building coverage.jacoco 1.0 [71/71]
21:36:20 [INFO] --------------------------------[ pom ]---------------------------------
21:36:20 [INFO] ------------------------------------------------------------------------
21:36:20 [INFO] Reactor Summary for govway 1.0:
21:36:20 [INFO]
21:36:20 [INFO] govway ............................................. SUCCESS [ 0.005 s]
21:36:20 [INFO] dependencies ....................................... SUCCESS [ 0.002 s]
21:36:20 [INFO] dependencies.ant ................................... SUCCESS [ 1.196 s]
21:36:20 [INFO] dependencies.antinstaller .......................... SUCCESS [ 0.035 s]
21:36:20 [INFO] dependencies.axiom ................................. SUCCESS [ 0.468 s]
21:36:20 [INFO] dependencies.bean-validation ....................... SUCCESS [ 0.048 s]
21:36:20 [INFO] dependencies.cxf ................................... SUCCESS [ 0.387 s]
21:36:20 [INFO] dependencies.commons ............................... SUCCESS [ 0.220 s]
21:36:20 [INFO] dependencies.faces ................................. SUCCESS [ 0.106 s]
21:36:20 [INFO] dependencies.git ................................... SUCCESS [ 0.046 s]
21:36:20 [INFO] dependencies.httpcore .............................. SUCCESS [ 0.139 s]
21:36:20 [INFO] dependencies.jackson ............................... SUCCESS [ 0.087 s]
21:36:20 [INFO] dependencies.javax ................................. SUCCESS [ 0.062 s]
21:36:20 [INFO] dependencies.jax ................................... SUCCESS [ 0.205 s]
21:36:20 [INFO] dependencies.jetty ................................. SUCCESS [ 0.043 s]
21:36:20 [INFO] dependencies.jminix ................................ SUCCESS [ 0.072 s]
21:36:20 [INFO] dependencies.json .................................. SUCCESS [ 0.091 s]
21:36:20 [INFO] dependencies.log ................................... SUCCESS [ 0.108 s]
21:36:20 [INFO] dependencies.lucene ................................ SUCCESS [ 0.024 s]
21:36:20 [INFO] dependencies.openapi4j ............................. SUCCESS [ 0.074 s]
21:36:20 [INFO] dependencies.opensaml .............................. SUCCESS [ 0.124 s]
21:36:20 [INFO] dependencies.pdf ................................... SUCCESS [ 0.032 s]
21:36:20 [INFO] dependencies.redis ................................. SUCCESS [ 0.060 s]
21:36:20 [INFO] dependencies.reports ............................... SUCCESS [ 0.067 s]
21:36:20 [INFO] dependencies.saaj .................................. SUCCESS [ 0.064 s]
21:36:20 [INFO] dependencies.security .............................. SUCCESS [ 0.099 s]
21:36:20 [INFO] dependencies.shared ................................ SUCCESS [ 0.238 s]
21:36:20 [INFO] dependencies.spring ................................ SUCCESS [ 0.164 s]
21:36:20 [INFO] dependencies.spring-ldap ........................... SUCCESS [ 0.022 s]
21:36:20 [INFO] dependencies.spring-security ....................... SUCCESS [ 0.119 s]
21:36:20 [INFO] dependencies.swagger ............................... SUCCESS [ 0.153 s]
21:36:20 [INFO] dependencies.swagger-codegen ....................... SUCCESS [ 0.142 s]
21:36:20 [INFO] dependencies.swagger-codegen.linkit ................ SUCCESS [ 0.124 s]
21:36:20 [INFO] dependencies.wadl .................................. SUCCESS [ 0.017 s]
21:36:20 [INFO] dependencies.wss4j ................................. SUCCESS [ 0.178 s]
21:36:20 [INFO] dependencies.testsuite ............................. SUCCESS [ 0.001 s]
21:36:20 [INFO] dependencies.testsuite.axis14 ...................... SUCCESS [ 0.147 s]
21:36:20 [INFO] dependencies.testsuite.as .......................... SUCCESS [ 0.003 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly9 ................. SUCCESS [ 0.053 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly10 ................ SUCCESS [ 0.063 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly11 ................ SUCCESS [ 0.033 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly12 ................ SUCCESS [ 0.054 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly13 ................ SUCCESS [ 0.058 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly14 ................ SUCCESS [ 0.064 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly15 ................ SUCCESS [ 0.045 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly16 ................ SUCCESS [ 0.072 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly17 ................ SUCCESS [ 0.072 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly18 ................ SUCCESS [ 0.081 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly19 ................ SUCCESS [ 0.050 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly20 ................ SUCCESS [ 0.049 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly21 ................ SUCCESS [ 0.037 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly22 ................ SUCCESS [ 0.034 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly23 ................ SUCCESS [ 0.046 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly24 ................ SUCCESS [ 0.063 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly25 ................ SUCCESS [ 0.051 s]
21:36:20 [INFO] dependencies.testsuite.as.wildfly26 ................ SUCCESS [ 0.163 s]
21:36:20 [INFO] dependencies.testsuite.as.tomcat9 .................. SUCCESS [ 0.012 s]
21:36:20 [INFO] dependencies.testsuite.test ........................ SUCCESS [ 0.277 s]
21:36:20 [INFO] dependencies.testsuite.staticAnalysis .............. SUCCESS [ 0.028 s]
21:36:20 [INFO] dependencies.testsuite.dynamicAnalysis ............. SUCCESS [ 0.023 s]
21:36:20 [INFO] dependencies.testsuite.coverage .................... SUCCESS [ 0.034 s]
21:36:20 [INFO] compile ............................................ SUCCESS [ 0.015 s]
21:36:20 [INFO] package ............................................ SUCCESS [ 0.001 s]
21:36:20 [INFO] testsuite.utils .................................... SUCCESS [ 0.000 s]
21:36:20 [INFO] testsuite.utils.sql ................................ SUCCESS [01:34 min]
21:36:20 [INFO] testsuite.pdd.core ................................. SUCCESS [ 0.001 s]
21:36:20 [INFO] testsuite.pdd.core.sql ............................. SUCCESS [ 5.223 s]
21:36:20 [INFO] static_analysis.spotbugs ........................... SUCCESS [ 0.001 s]
21:36:20 [INFO] static_analysis.sonarqube .......................... SUCCESS [ 0.001 s]
21:36:20 [INFO] dynamic_analysis.zap ............................... SUCCESS [ 0.001 s]
21:36:20 [INFO] coverage.jacoco .................................... SUCCESS [ 0.001 s]
21:36:20 [INFO] ------------------------------------------------------------------------
21:36:20 [INFO] BUILD SUCCESS
21:36:20 [INFO] ------------------------------------------------------------------------
21:36:20 [INFO] Total time: 01:47 min
21:36:20 [INFO] Finished at: 2026-01-23T21:36:20+01:00
21:36:20 [INFO] ------------------------------------------------------------------------
21:36:20 [GovWay] $ /bin/sh -xe /tmp/jenkins5960272693709764434.sh
21:36:20 + echo 'Pubblicazione risultati testsuite core ...'
21:36:20 Pubblicazione risultati testsuite core ...
21:36:20 + sudo su -c 'rm -rf /opt/apache-tomcat-9.0.91/webapps/govway-testsuite/core'
21:36:20 + sudo su -c 'mkdir /opt/apache-tomcat-9.0.91/webapps/govway-testsuite/core'
21:36:20 + sudo su -c 'cp -r /var/lib/jenkins/workspace/GovWay/testsuite-result/* /opt/apache-tomcat-9.0.91/webapps/govway-testsuite/core/'
21:36:20 + echo 'Pubblicazione risultati testsuite core effettuata'
21:36:20 Pubblicazione risultati testsuite core effettuata
21:36:20 [Boolean condition] checking [true] against [^(1|y|yes|t|true|on|run)$] (origin token: ${GOVWAY_TEST_INTEGRAZIONE})
21:36:20 Run condition [Boolean condition] enabling perform for step [BuilderChain]
21:36:20 [GovWay] $ /bin/bash /tmp/jenkins15956228736386488030.sh
21:36:20 Fermo application server ...
21:36:20 [00;31mStoping Tomcat[00m
21:36:20 NOTE: Picked up JDK_JAVA_OPTIONS: --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.util.concurrent=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
21:36:21 Pid Tomcat: 9276
21:36:21
21:36:22 [00;31mwaiting for processes to exit[00m
21:36:23 [00;31mwaiting for processes to exit[00m
21:36:24 [00;31mwaiting for processes to exit[00m
21:36:25 [00;31mwaiting for processes to exit[00m
21:36:26 [00;31mwaiting for processes to exit[00m
21:36:27 [00;31mwaiting for processes to exit[00mFermo application server effettuato
21:36:27 Predisposizione datasource ...
21:36:27 Predisposizione datasource effettuata
21:36:27 Predisposizione jars ...
21:36:27 Predisposizione jars effettuata
21:36:27 Preparazione compilazione govwayTestSuite.war ...
21:36:27 Preparazione compilazione govwayTestSuite.war effettuata
21:36:27 [testsuite] $ /var/lib/jenkins/tools/hudson.tasks.Ant_AntInstallation/ant-1.10.6/bin/ant -file build.xml -Das=tomcat9 clean build
21:36:28 Buildfile: /var/lib/jenkins/workspace/GovWay/testsuite/build.xml
21:36:29
21:36:29 check_as_version:
21:36:29
21:36:29 clean_testsuite:
21:36:29 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite
21:36:29 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/build
21:36:29 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/dist
21:36:29 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/doc
21:36:29
21:36:29 clean:
21:36:29
21:36:29 init_compile_testsuite:
21:36:29 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite
21:36:29 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/tmp
21:36:29 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/dist
21:36:29
21:36:29 compile_govway_testsuite:
21:36:29
21:36:29 checkgit:
21:36:31
21:36:31 init_compile-build:
21:36:31 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/compile-jar-openspcoop2
21:36:31
21:36:31 compile_src_openspcoop2:
21:36:31 [echo] Java home: /opt/openjdk-11.0.12_7/
21:36:31 [echo] ****************************************
21:36:31 [echo] **** DEBUG MODE ON *****
21:36:31 [echo] ****************************************
21:36:31 [echo] Raccolta informazioni git per inserimento in manifest...
21:36:31 [echo] compileSRC[/var/lib/jenkins/workspace/GovWay/testsuite/src]
21:36:31 [javac] Compiling 78 source files to /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/compile-jar-openspcoop2
21:36:38 [jar] Building jar: /var/lib/jenkins/workspace/GovWay/testsuite/dist/openspcoop2_testsuite-lib_BUILD-656afd14.jar
21:36:38 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/compile-jar-openspcoop2
21:36:38 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/doc
21:36:38
21:36:38 compile_api_openspcoop2:
21:36:39
21:36:39 init_compile-api:
21:36:39 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/doc/api
21:36:39 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/doc/api/testsuite-lib
21:36:39 [echo] WARN: Java8 -Xdoclint:none
21:36:39 [echo] build API for packages: org.openspcoop2.testsuite,org.openspcoop2.testsuite.axis14,org.openspcoop2.testsuite.clients,org.openspcoop2.testsuite.core,org.openspcoop2.testsuite.core.asincrono,org.openspcoop2.testsuite.db,org.openspcoop2.testsuite.gui.commons,org.openspcoop2.testsuite.gui.constant,org.openspcoop2.testsuite.gui.ctrlstat,org.openspcoop2.testsuite.server,org.openspcoop2.testsuite.wssecurity,org.openspcoop2.testsuite.units,org.openspcoop2.testsuite.units.utils
21:36:39 [javadoc] Generating Javadoc
21:36:39 [javadoc] Javadoc execution
21:36:40 [javadoc] Loading source files for package org.openspcoop2.testsuite.axis14...
21:36:40 [javadoc] Loading source files for package org.openspcoop2.testsuite.clients...
21:36:40 [javadoc] Loading source files for package org.openspcoop2.testsuite.core...
21:36:40 [javadoc] Loading source files for package org.openspcoop2.testsuite.core.asincrono...
21:36:40 [javadoc] Loading source files for package org.openspcoop2.testsuite.db...
21:36:40 [javadoc] Loading source files for package org.openspcoop2.testsuite.server...
21:36:40 [javadoc] Loading source files for package org.openspcoop2.testsuite.units...
21:36:40 [javadoc] Loading source files for package org.openspcoop2.testsuite.units.utils...
21:36:40 [javadoc] Loading source files for package org.openspcoop2.testsuite.wssecurity...
21:36:41 [javadoc] Constructing Javadoc information...
21:36:44 [javadoc] Standard Doclet version 11.0.12
21:36:44 [javadoc] Building tree for all the packages and classes...
21:36:47 [javadoc] Building index for all the packages and classes...
21:36:47 [javadoc] Building index for all classes...
21:36:47 [javadoc] Building index for all classes...
21:36:47 [echo] Raccolta informazioni git per inserimento in manifest...
21:36:47 [jar] Building jar: /var/lib/jenkins/workspace/GovWay/testsuite/doc/api/openspcoop2_testsuite-lib_BUILD-656afd14-javadoc.jar
21:36:47
21:36:47 compile_testsuite:
21:36:47
21:36:47 war_govway_testsuite:
21:36:47 [copy] Copying 1 file to /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/tmp
21:36:48
21:36:48 set_property:
21:36:48
21:36:48 set_property:
21:36:48
21:36:48 set_property:
21:36:49
21:36:49 set_property:
21:36:49 [copy] Copying 1 file to /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/tmp
21:36:49 [war] Building war: /var/lib/jenkins/workspace/GovWay/testsuite/dist/govwayTestSuite.war
21:36:52 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/tmp
21:36:52
21:36:52 build_testsuite:
21:36:52
21:36:52 build:
21:36:52
21:36:52 BUILD SUCCESSFUL
21:36:52 Total time: 24 seconds
21:36:52 [GovWay] $ /bin/sh -xe /tmp/jenkins10876617855793413543.sh
21:36:52 + echo 'Predisposizione jar di protocolli in govwayTestSuite.war ...'
21:36:52 Predisposizione jar di protocolli in govwayTestSuite.war ...
21:36:52 + sudo su -c 'rm -rf /tmp/govwayTestSuite.war.tmp'
21:36:52 + sudo su -c 'rm -f /tmp/govwayTestSuite.war'
21:36:52 + sudo su -c 'unzip -q /var/lib/jenkins/workspace/GovWay/testsuite/dist/govwayTestSuite.war -d /tmp/govwayTestSuite.war.tmp'
21:36:53 + sudo su -c 'cp /var/lib/jenkins/workspace/GovWay/protocolli/spcoop/dist/openspcoop2_spcoop-protocol*.jar /tmp/govwayTestSuite.war.tmp/WEB-INF/lib/'
21:36:53 + sudo su -c 'cp /var/lib/jenkins/workspace/GovWay/protocolli/trasparente/dist/openspcoop2_trasparente-protocol*.jar /tmp/govwayTestSuite.war.tmp/WEB-INF/lib/'
21:36:53 + sudo su -c 'rm -f /tmp/govwayTestSuite.war.tmp/WEB-INF/lib/openspcoop2_utils-test*.jar'
21:36:53 + sudo su -c 'rm -f /tmp/govwayTestSuite.war.tmp/WEB-INF/lib/openspcoop2_pdd-test*.jar'
21:36:53 + sudo su -c 'pushd /tmp/govwayTestSuite.war.tmp/; zip -rq /tmp/govwayTestSuite.war *; popd'
21:36:53 /tmp/govwayTestSuite.war.tmp /var/lib/jenkins/workspace/GovWay
21:36:55 /var/lib/jenkins/workspace/GovWay
21:36:55 + echo 'Predisposizione jar di protocolli in govwayTestSuite.war effettuata'
21:36:55 Predisposizione jar di protocolli in govwayTestSuite.war effettuata
21:36:55 + echo 'Predispongo govwayTestSuite.war su Tomcat ...'
21:36:55 Predispongo govwayTestSuite.war su Tomcat ...
21:36:55 + sudo su -c 'rm -rf /opt/apache-tomcat-9.0.91/webapps/govwayTestSuite.war'
21:36:55 + sudo su -c 'rm -rf /opt/apache-tomcat-9.0.91/webapps/govwayTestSuite'
21:36:55 + sudo su -c 'cp /tmp/govwayTestSuite.war /opt/apache-tomcat-9.0.91/webapps/'
21:36:56 + sudo su -c 'chown -R tomcat.tomcat /opt/apache-tomcat-9.0.91/webapps/govwayTestSuite.war'
21:36:56 + sudo su -c 'rm -rf /tmp/govwayTestSuite.war.tmp'
21:36:56 + sudo su -c 'rm -f /tmp/govwayTestSuite.war'
21:36:56 + echo 'Predispongo govwayTestSuite.war su Tomcat ok'
21:36:56 Predispongo govwayTestSuite.war su Tomcat ok
21:36:56 + echo 'Predispongo govwayTestSuite come libreria per i test ...'
21:36:56 Predispongo govwayTestSuite come libreria per i test ...
21:36:56 + cd /var/lib/jenkins/workspace/GovWay/testsuite
21:36:56 + sed -i -e s#/var/govway/log#/var/log/govway_testsuite#g deploy/properties_xml2Backend/xml2backend.log4j2.properties
21:36:56 + sed -i -e s#/var/govway/log#/var/log/govway_testsuite#g deploy/properties/log4j2.properties
21:36:56 + sed -i -e s#/var/govway/log#/var/log/govway_testsuite#g deploy/properties/testsuite.log4j2.properties
21:36:56 + echo 'Predispongo govwayTestSuite come libreria per i test ok'
21:36:56 Predispongo govwayTestSuite come libreria per i test ok
21:36:56 + echo 'Predispongo tempi alti di generazione delle statistiche per i test ...'
21:36:56 Predispongo tempi alti di generazione delle statistiche per i test ...
21:36:56 + sudo su -c 'echo '\''org.openspcoop2.pdd.statistiche.generazione.baseOraria.timer.intervalloSecondi=36000'\'' >> /etc/govway/govway_local.properties'
21:36:56 + sudo su -c 'echo '\''org.openspcoop2.pdd.statistiche.generazione.baseGiornaliera.timer.intervalloSecondi=36000'\'' >> /etc/govway/govway_local.properties'
21:36:56 + sudo su -c 'echo '\''org.openspcoop2.pdd.statistiche.generazione.baseSettimanale.timer.intervalloSecondi=36000'\'' >> /etc/govway/govway_local.properties'
21:36:56 + sudo su -c 'echo '\''org.openspcoop2.pdd.statistiche.generazione.baseMensile.timer.intervalloSecondi=36000'\'' >> /etc/govway/govway_local.properties'
21:36:56 + echo 'Predispongo tempi alti di generazione delle statistiche per i test ok'
21:36:56 Predispongo tempi alti di generazione delle statistiche per i test ok
21:36:56 [Boolean condition] checking [true] against [^(1|y|yes|t|true|on|run)$] (origin token: ${GOVWAY_TEST_INTEGRAZIONE_BYOK})
21:36:56 Run condition [Boolean condition] enabling perform for step [BuilderChain]
21:36:56 [GovWay] $ /bin/bash /tmp/jenkins15624592707020982337.sh
21:36:56 Fermo application server ...
21:36:56 [00;31mTomcat is not running[00m
21:36:56 Fermo application server effettuato
21:36:56 Predispongo Testsuite per byok ...
21:36:56 - properties
21:36:57 - predispongo ambiente di test
21:36:57 - jks jose ...
21:36:57 - jks ...
21:36:57 - jks (xca) ...
21:36:57 - jwk ...
21:36:57 - jwk (truststore) ...
21:36:57 - jwk testPrivate/Public ...
21:36:57 - keypair pem ...
21:36:57 - keypair der ...
21:36:58 - keypair jwk ...
21:36:58 - tool govway-vault-cli
21:36:58 - tool config-loader
21:36:58 - init db per proprieta' cifrate
21:36:58 DELETE 0
21:36:58 INSERT 0 1
21:36:58 - predispongo pacchetto testService
21:36:58 [testService] $ /var/lib/jenkins/tools/hudson.tasks.Ant_AntInstallation/ant-1.10.6/bin/ant -file build.xml -Das=tomcat9 clean build
21:36:58 Buildfile: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build.xml
21:36:59
21:36:59 check_as_version:
21:36:59
21:36:59 clean:
21:36:59 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build
21:36:59 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/dist
21:36:59
21:36:59 init_compile:
21:36:59 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build
21:36:59 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/dist
21:36:59
21:36:59 compile:
21:36:59 [javac] Compiling 5 source files to /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build
21:37:03
21:37:03 build:
21:37:03 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build/example
21:37:03 [war] Building war: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/dist/TestService.war
21:37:05 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build/example
21:37:05
21:37:05 BUILD SUCCESSFUL
21:37:05 Total time: 6 seconds
21:37:05 [testsuite] $ /var/lib/jenkins/tools/hudson.tasks.Ant_AntInstallation/ant-1.10.6/bin/ant -file build.xml clean build
21:37:05 Buildfile: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build.xml
21:37:06
21:37:06 clean:
21:37:06 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
21:37:06 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/log
21:37:06
21:37:06 clean:
21:37:06
21:37:06 init:
21:37:06 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
21:37:06
21:37:06 build:
21:37:06 [javac] Compiling 8 source files to /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
21:37:09 [copy] Copying 9 files to /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
21:37:09 [copy] Copied 3 empty directories to 2 empty directories under /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
21:37:09
21:37:09 BUILD SUCCESSFUL
21:37:09 Total time: 3 seconds
21:37:09 [GovWay] $ /bin/bash /tmp/jenkins1442366491343888162.sh
21:37:09 Predispongo TestService.war ...
21:37:09 Predispongo TestService.war ok
21:37:09 Predispongo testsuite BYOK ...
21:37:09 Predispongo testsuite BYOK ok
21:37:09 Riavvio application server ...
21:37:10 [00;32mStarting tomcat[00m
21:37:10 Tomcat started.
21:37:10 [00;32mTomcat is running with pid: 17217[00m
21:37:10
21:37:10 Attendo che GovWay sia completamente riavviato (timeout 120sec)
21:37:10 .
21:37:11 .
21:37:12 .
21:38:28 .
21:38:29 .
21:38:30 .
21:38:31 .
21:38:32 .
21:38:33 .
21:38:34 .
21:38:35 .
21:38:36 .
21:38:37 .
21:38:38 .
21:38:40 .
21:38:41 .
21:38:42 .
21:38:43 .
21:38:44 .
21:38:45 .
21:38:46 .
21:38:47 .
21:38:48 .
21:38:49 .
21:38:50 .
21:38:51 .
21:38:52 .
21:38:53 .
21:38:54 .
21:38:55 .
21:38:56 .
21:38:57 .
21:38:58 .
21:38:59 .
21:39:00 .
21:39:01 .
21:39:02 .
21:39:03 .
21:39:04 .
21:39:05 .
21:39:06 .
21:39:07 .
21:39:08 .
21:39:09 .
21:39:10 .
21:39:11 .
21:39:12 .
21:39:13 .
21:39:14 .
21:39:15 .
21:39:16 .
21:39:17 .
21:39:18 .
21:39:19 .
21:39:20 .
21:39:21 .
21:39:22 .
21:39:23 .
21:39:24 .
21:39:25 .
21:39:26 .
21:39:27 .
21:39:28 .
21:39:29 .
21:39:30 .
21:39:31 .
21:39:32 .
21:39:33 .
21:39:34 .
21:39:35 .
21:39:36 .
21:39:37 .
21:39:38 .
21:39:39 .
21:39:40 .
21:39:41 .
21:39:42 .
21:39:43 .
21:39:44 .
21:39:45 .
21:39:46 .
21:39:47 .
21:39:48 .
21:39:49 .
21:39:50 .
21:39:51 .
21:39:52 .
21:39:53 .
21:39:54 .
21:39:55 .
21:39:56 .
21:39:58 .
21:39:59 .
21:40:00 .
21:40:01 .
21:40:02 .
21:40:03 .
21:40:04 .
21:40:05 .
21:40:06 .
21:40:07 .
21:40:08 .
21:40:09 .
21:40:10 .
21:40:11 .
21:40:12 .
21:40:13 .
21:40:14 .
21:40:15 .
21:40:16 .
21:40:17 .
21:40:18 .
21:40:19 .
21:40:20 .
21:40:21 .
21:40:22 .
21:40:23 .
21:40:24 .
21:40:25 .
21:40:26 .
21:40:27 .
21:40:27 Timeout.
21:40:27 Attendo 15 secondi prima di aggiornare certificati HSM ...
21:40:42 [testsuite] $ /var/lib/jenkins/tools/hudson.tasks.Ant_AntInstallation/ant-1.10.6/bin/ant -file build.xml -Doutput=risultati-testsuite -Das=tomcat9 -DshowOutput=yes -DhaltOnFailure=no run_test
21:40:42 Buildfile: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build.xml
21:40:43
21:40:43 run_test:
21:40:43 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/risultati-testsuite
21:40:43 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/risultati-testsuite
21:40:43 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/log
21:40:43 [echo] Caricamento configurazione in corso (delete) ...
21:40:50 [java] Exception in thread "main" org.openspcoop2.utils.UtilsException: Rilevata precedente esecuzione di 'delete config' fallita: Error stream found small:Exception in thread "main" org.openspcoop2.core.commons.CoreException: Errore durante l'inizializzazione dell'ambiente (secrets): [java.PWD_NODO_RUNTIME] Load private key failed: missing provider
21:40:50 [java] at org.openspcoop2.pdd.config.loader.cli.Loader.main(Loader.java:324)
21:40:50 [java] Caused by: org.openspcoop2.core.commons.CoreException: Errore durante l'inizializzazione dell'ambiente (secrets): [java.PWD_NODO_RUNTIME] Load private key failed: missing provider
21:40:50 [java] at org.openspcoop2.pdd.config.loader.cli.Loader.doError(Loader.java:652)
21:40:50 [java] at org.openspcoop2.pdd.config.loader.cli.Loader.initSecrets(Loader.java:576)
21:40:50 [java] at org.openspcoop2.pdd.config.loader.cli.Loader.main(Loader.java:195)
21:40:50 [java] Caused by: org.openspcoop2.utils.UtilsException: [java.PWD_NODO_RUNTIME] Load private key failed: missing provider
21:40:50 [java] at org.openspcoop2.pdd.core.byok.BYOKMapProperties.processWrappedValue(BYOKMapProperties.java:265)
21:40:50 [java] at org.openspcoop2.pdd.core.byok.BYOKMapProperties.loadJavaPropertyInEnvironment(BYOKMapProperties.java:242)
21:40:50 [java] at org.openspcoop2.pdd.core.byok.BYOKMapProperties.loadPropertyInEnvironment(BYOKMapProperties.java:208)
21:40:50 [java] at org.openspcoop2.utils.properties.MapProperties.initEnvironment(MapProperties.java:219)
21:40:50 [java] at org.openspcoop2.pdd.config.loader.cli.Loader.initSecrets(Loader.java:568)
21:40:50 [java] ... 1 more
21:40:50 [java] Caused by: org.openspcoop2.utils.UtilsException: Load private key failed: missing provider
21:40:50 [java] at org.openspcoop2.pdd.core.byok.DriverBYOK.processInstance(DriverBYOK.java:351)
21:40:50 [java] at org.openspcoop2.pdd.core.byok.BYOKMapProperties.unwrapByKmsId(BYOKMapProperties.java:500)
21:40:50 [java] at org.openspcoop2.pdd.core.byok.BYOKMapProperties.processWrappedValue(BYOKMapProperties.java:262)
21:40:50 [java] ... 5 more
21:40:50 [java] Caused by: org.openspcoop2.utils.UtilsException: Load private key failed: missing provider
21:40:50 [java] at org.openspcoop2.security.keystore.BYOKLocalEncrypt.unwrap(BYOKLocalEncrypt.java:196)
21:40:50 [java] at org.openspcoop2.security.keystore.BYOKLocalEncrypt.unwrap(BYOKLocalEncrypt.java:163)
21:40:50 [java] at org.openspcoop2.pdd.core.byok.DriverBYOK.processInstance(DriverBYOK.java:346)
21:40:50 [java] ... 7 more
21:40:50 [java] Caused by: org.openspcoop2.security.SecurityException: Load private key failed: missing provider
21:40:50 [java] at org.openspcoop2.security.keystore.KeyPairStore.initializePrivateKey(KeyPairStore.java:180)
21:40:50 [java] at org.openspcoop2.security.keystore.KeyPairStore.getPrivateKey(KeyPairStore.java:162)
21:40:50 [java] at org.openspcoop2.security.keystore.BYOKLocalEncrypt.readKeyPair(BYOKLocalEncrypt.java:428)
21:40:50 [java] at org.openspcoop2.security.keystore.BYOKLocalEncrypt.unwrap(BYOKLocalEncrypt.java:183)
21:40:50 [java] ... 9 more
21:40:50 [java] Caused by: org.openspcoop2.utils.UtilsException: missing provider
21:40:50 [java] at org.openspcoop2.utils.certificate.KeyUtils.<init>(KeyUtils.java:114)
21:40:50 [java] at org.openspcoop2.utils.certificate.KeyUtils.getInstance(KeyUtils.java:98)
21:40:50 [java] at org.openspcoop2.security.keystore.KeyPairStore.initializePrivateKey(KeyPairStore.java:173)
21:40:50 [java] ... 12 more
21:40:50 [java] Caused by: java.lang.IllegalArgumentException: missing provider
21:40:50 [java] at java.base/sun.security.jca.GetInstance.getService(GetInstance.java:96)
21:40:50 [java] at java.base/sun.security.jca.GetInstance.getInstance(GetInstance.java:218)
21:40:50 [java] at java.base/java.security.KeyFactory.getInstance(KeyFactory.java:266)
21:40:50 [java] at org.openspcoop2.utils.certificate.KeyUtils.<init>(KeyUtils.java:111)
21:40:50 [java] ... 14 more
21:40:50 [java] full: Exception in thread "main" org.openspcoop2.core.commons.CoreException: Errore durante l'inizializzazione dell'ambiente (secrets): [java.PWD_NODO_RUNTIME] Load private key failed: missing provider
21:40:50 [java] at org.openspcoop2.pdd.config.loader.cli.Loader.main(Loader.java:324)
21:40:50 [java] Caused by: org.openspcoop2.core.commons.CoreException: Errore durante l'inizializzazione dell'ambiente (secrets): [java.PWD_NODO_RUNTIME] Load private key failed: missing provider
21:40:50 [java] at org.openspcoop2.pdd.config.loader.cli.Loader.doError(Loader.java:652)
21:40:50 [java] at org.openspcoop2.pdd.config.loader.cli.Loader.initSecrets(Loader.java:576)
21:40:50 [java] at org.openspcoop2.pdd.config.loader.cli.Loader.main(Loader.java:195)
21:40:50 [java] Caused by: org.openspcoop2.utils.UtilsException: [java.PWD_NODO_RUNTIME] Load private key failed: missing provider
21:40:50 [java] at org.openspcoop2.pdd.core.byok.BYOKMapProperties.processWrappedValue(BYOKMapProperties.java:265)
21:40:50 [java] at org.openspcoop2.pdd.core.byok.BYOKMapProperties.loadJavaPropertyInEnvironment(BYOKMapProperties.java:242)
21:40:50 [java] at org.openspcoop2.pdd.core.byok.BYOKMapProperties.loadPropertyInEnvironment(BYOKMapProperties.java:208)
21:40:50 [java] at org.openspcoop2.utils.properties.MapProperties.initEnvironment(MapProperties.java:219)
21:40:50 [java] at org.openspcoop2.pdd.config.loader.cli.Loader.initSecrets(Loader.java:568)
21:40:50 [java] ... 1 more
21:40:50 [java] Caused by: org.openspcoop2.utils.UtilsException: Load private key failed: missing provider
21:40:50 [java] at org.openspcoop2.pdd.core.byok.DriverBYOK.processInstance(DriverBYOK.java:351)
21:40:50 [java] at org.openspcoop2.pdd.core.byok.BYOKMapProperties.unwrapByKmsId(BYOKMapProperties.java:500)
21:40:50 [java] at org.openspcoop2.pdd.core.byok.BYOKMapProperties.processWrappedValue(BYOKMapProperties.java:262)
21:40:50 [java] ... 5 more
21:40:50 [java] Caused by: org.openspcoop2.utils.UtilsException: Load private key failed: missing provider
21:40:50 [java] at org.openspcoop2.security.keystore.BYOKLocalEncrypt.unwrap(BYOKLocalEncrypt.java:196)
21:40:50 [java] at org.openspcoop2.security.keystore.BYOKLocalEncrypt.unwrap(BYOKLocalEncrypt.java:163)
21:40:50 [java] at org.openspcoop2.pdd.core.byok.DriverBYOK.processInstance(DriverBYOK.java:346)
21:40:50 [java] ... 7 more
21:40:50 [java] Caused by: org.openspcoop2.security.SecurityException: Load private key failed: missing provider
21:40:50 [java] at org.openspcoop2.security.keystore.KeyPairStore.initializePrivateKey(KeyPairStore.java:180)
21:40:50 [java] at org.openspcoop2.security.keystore.KeyPairStore.getPrivateKey(KeyPairStore.java:162)
21:40:50 [java] at org.openspcoop2.security.keystore.BYOKLocalEncrypt.readKeyPair(BYOKLocalEncrypt.java:428)
21:40:50 [java] at org.openspcoop2.security.keystore.BYOKLocalEncrypt.unwrap(BYOKLocalEncrypt.java:183)
21:40:50 [java] ... 9 more
21:40:50 [java] Caused by: org.openspcoop2.utils.UtilsException: missing provider
21:40:50 [java] at org.openspcoop2.utils.certificate.KeyUtils.<init>(KeyUtils.java:114)
21:40:50 [java] at org.openspcoop2.utils.certificate.KeyUtils.getInstance(KeyUtils.java:98)
21:40:50 [java] at org.openspcoop2.security.keystore.KeyPairStore.initializePrivateKey(KeyPairStore.java:173)
21:40:50 [java] ... 12 more
21:40:50 [java] Caused by: java.lang.IllegalArgumentException: missing provider
21:40:50 [java] at java.base/sun.security.jca.GetInstance.getService(GetInstance.java:96)
21:40:50 [java] at java.base/sun.security.jca.GetInstance.getInstance(GetInstance.java:218)
21:40:50 [java] at java.base/java.security.KeyFactory.getInstance(KeyFactory.java:266)
21:40:51 [java] at org.openspcoop2.utils.certificate.KeyUtils.<init>(KeyUtils.java:111)
21:40:51 [java] ... 14 more
21:40:51 [java]
21:40:51 [java] at org.openspcoop2.pdd.config.vault.cli.testsuite.ConfigLoader.checkExternalToolError(ConfigLoader.java:342)
21:40:51 [java] at org.openspcoop2.pdd.config.vault.cli.testsuite.ConfigLoader.deleteConfig(ConfigLoader.java:406)
21:40:51 [java] at org.openspcoop2.pdd.config.vault.cli.testsuite.ConfigLoader.main(ConfigLoader.java:228)
21:40:51
21:40:51 BUILD FAILED
21:40:51 /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build.xml:226: Java returned: 1
21:40:51
21:40:51 Total time: 8 seconds
21:40:51 Build step 'Conditional steps (multiple)' marked build as failure
21:40:51 INFO: Processing JUnit
21:40:51 INFO: [JUnit] - 2 test report file(s) were found with the pattern 'tools/rs/*/server/testsuite/risultati-testsuite/TEST-*.xml' relative to '/var/lib/jenkins/workspace/GovWay' for the testing framework 'JUnit'.
21:40:51 ERROR: Step ‘Publish xUnit test result report’ failed: Test reports were found but not all of them are new. Did all the tests run?
21:40:51 * /var/lib/jenkins/workspace/GovWay/tools/rs/config/server/testsuite/risultati-testsuite/TEST-org.openspcoop2.core.config.rs.testsuite.ApiConfigTestSuite.xml is 3 days 15 hr old
21:40:51 * /var/lib/jenkins/workspace/GovWay/tools/rs/monitor/server/testsuite/risultati-testsuite/TEST-org.openspcoop2.core.monitor.rs.testsuite.ApiMonitorTestSuite.xml is 3 days 14 hr old
21:40:51
21:40:51 TestNG Reports Processing: START
21:40:51 Looking for TestNG results report in workspace using pattern: **/testng-results.xml
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 testng-results.xml was last modified before this build started. Ignoring it.
21:40:53 Saving reports...
21:40:53 Processing '/var/lib/jenkins/jobs/GovWay/builds/1356/testng/testng-results-1.xml'
21:40:53 Processing '/var/lib/jenkins/jobs/GovWay/builds/1356/testng/testng-results-2.xml'
21:40:53 Processing '/var/lib/jenkins/jobs/GovWay/builds/1356/testng/testng-results-3.xml'
21:40:53 Processing '/var/lib/jenkins/jobs/GovWay/builds/1356/testng/testng-results.xml'
21:40:53 12.186380% of tests failed, which exceeded threshold of 5%. Marking build as UNSTABLE
21:40:53 TestNG Reports Processing: FINISH
21:40:53 Collecting Dependency-Check artifact
21:40:53 Parsing file /var/lib/jenkins/workspace/GovWay/dependency-check-result/dependency-check-report.xml
21:40:54 [analysis] Skipping execution of recorder since overall result is 'FAILURE'
21:40:54 Started calculate disk usage of build
21:40:54 Finished Calculation of disk usage of build in 0 seconds
21:40:54 Started calculate disk usage of workspace
21:40:55 Finished Calculation of disk usage of workspace in 1 second
21:40:55 Finished: FAILURE
