Skipping 12,444 KB.. Full Log

   [testng] riga[126]= [DayOfYearCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[127]= [DayOfYearCondition] (secondColonna:9.509892) (secondColonnaTabella:9.509892)
16:52:10    [testng] riga[128]= [DayOfYearCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[129]= [DayOfYearCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[130]= [DayOfYearCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[131]= [DayOfYearCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[132]= [DayOfYearCondition] (data:2024-07-15 16:52:09.510)
16:52:10    [testng] riga[133]= [DayOfYearCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[134]= [DayOfYearCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[135]= [DayOfYearCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[136]= [DayOfYearCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[137]= [DayOfYearCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[138]= [DayOfYearCondition] (secondColonna:9.51) (secondColonnaTabella:9.51)
16:52:10    [testng] riga[139]= [DayOfYearCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[140]= [DayOfYearCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[141]= [DayOfYearCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[142]= [DayOfYearCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[143]= [DayOfYearCondition] (data:2024-07-15 16:52:09.512)
16:52:10    [testng] riga[144]= [DayOfYearCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[145]= [DayOfYearCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[146]= [DayOfYearCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[147]= [DayOfYearCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[148]= [DayOfYearCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[149]= [DayOfYearCondition] (secondColonna:9.512582) (secondColonnaTabella:9.512582)
16:52:10    [testng] riga[150]= [DayOfYearCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[151]= [DayOfYearCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[152]= [DayOfYearCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[153]= [DayOfYearCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[154]= [DayOfYearCondition] (data:2024-07-15 16:52:09.514)
16:52:10    [testng] riga[155]= [DayOfYearCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[156]= [DayOfYearCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[157]= [DayOfYearCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[158]= [DayOfYearCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[159]= [DayOfYearCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[160]= [DayOfYearCondition] (secondColonna:9.514) (secondColonnaTabella:9.514)
16:52:10    [testng] riga[161]= [DayOfYearCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[162]= [DayOfYearCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[163]= [DayOfYearCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[164]= [DayOfYearCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[165]= [DayOfYearCondition] (data:2024-07-15 16:52:09.516)
16:52:10    [testng] riga[166]= [DayOfYearCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[167]= [DayOfYearCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[168]= [DayOfYearCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[169]= [DayOfYearCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[170]= [DayOfYearCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[171]= [DayOfYearCondition] (secondColonna:9.516802) (secondColonnaTabella:9.516802)
16:52:10    [testng] riga[172]= [DayOfYearCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[173]= [DayOfYearCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[174]= [DayOfYearCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[175]= [DayOfYearCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[176]= [DayOfYearCondition] (data:2024-07-15 16:52:09.517)
16:52:10    [testng] riga[177]= [DayOfYearCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[178]= [DayOfYearCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[179]= [DayOfYearCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[180]= [DayOfYearCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[181]= [DayOfYearCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[182]= [DayOfYearCondition] (secondColonna:9.517) (secondColonnaTabella:9.517)
16:52:10    [testng] riga[183]= [DayOfYearCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[184]= [DayOfYearCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[185]= [DayOfYearCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[186]= [DayOfYearCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[187]= [DayOfYearCondition] (data:2024-07-15 16:52:09.518)
16:52:10    [testng] riga[188]= [DayOfYearCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[189]= [DayOfYearCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[190]= [DayOfYearCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[191]= [DayOfYearCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[192]= [DayOfYearCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[193]= [DayOfYearCondition] (secondColonna:9.518978) (secondColonnaTabella:9.518978)
16:52:10    [testng] riga[194]= [DayOfYearCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[195]= [DayOfYearCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[196]= [DayOfYearCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[197]= [DayOfYearCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[198]= [DayOfYearCondition] (data:2024-07-15 16:52:09.520)
16:52:10    [testng] riga[199]= [DayOfYearCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[200]= [DayOfYearCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[201]= [DayOfYearCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[202]= [DayOfYearCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[203]= [DayOfYearCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[204]= [DayOfYearCondition] (secondColonna:9.52) (secondColonnaTabella:9.52)
16:52:10    [testng] riga[205]= [DayOfYearCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[206]= [DayOfYearCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[207]= [DayOfYearCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[208]= [DayOfYearCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[209]= [DayOfYearCondition] (data:2024-07-15 16:52:09.521)
16:52:10    [testng] riga[210]= [DayOfYearCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[211]= [DayOfYearCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[212]= [DayOfYearCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[213]= [DayOfYearCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[214]= [DayOfYearCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[215]= [DayOfYearCondition] (secondColonna:9.521287) (secondColonnaTabella:9.521287)
16:52:10    [testng] riga[216]= [DayOfYearCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[217]= [DayOfYearCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[218]= [DayOfYearCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[219]= [DayOfYearCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[220]= [DayOfYearCondition] (data:2024-07-15 16:52:09.522)
16:52:10    [testng] riga[221]= [DayOfYearCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[222]= [DayOfYearCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[223]= [DayOfYearCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[224]= [DayOfYearCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[225]= [DayOfYearCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[226]= [DayOfYearCondition] (secondColonna:9.522) (secondColonnaTabella:9.522)
16:52:10    [testng] riga[227]= [DayOfYearCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[228]= [DayOfYearCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[229]= [DayOfYearCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[230]= [DayOfYearCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] test0_engine:
16:52:10    [testng] 	SELECT  DISTINCT aliasMSG.gdo as data,EXTRACT(YEAR FROM gdo) as yearColonna,EXTRACT(YEAR FROM aliasMSG.gdo) as yearColonnaTabella,EXTRACT(MONTH FROM gdo) as monthColonna,EXTRACT(MONTH FROM aliasMSG.gdo) as monthColonnaTabella,EXTRACT(DAY FROM gdo) as dayColonna,EXTRACT(DAY FROM aliasMSG.gdo) as dayColonnaTabella,EXTRACT(HOUR FROM gdo) as hourColonna,EXTRACT(HOUR FROM aliasMSG.gdo) as hourColonnaTabella,EXTRACT(MINUTE FROM gdo) as minuteColonna,EXTRACT(MINUTE FROM aliasMSG.gdo) as minuteColonnaTabella,EXTRACT(SECOND FROM gdo) as secondColonna,EXTRACT(SECOND FROM aliasMSG.gdo) as secondColonnaTabella,TRIM(BOTH FROM TO_CHAR(gdo, 'DAY')) as fullDayNameColonna,TRIM(BOTH FROM TO_CHAR(aliasMSG.gdo, 'DAY')) as fullDayNameColonnaTabella,TO_CHAR(gdo, 'DY') as shortDayNameColonna,TO_CHAR(aliasMSG.gdo, 'DY') as shortDayNameColonnaTabella,TO_CHAR(gdo, 'DDD') as dayOfYearColonna,TO_CHAR(aliasMSG.gdo, 'DDD') as dayOfYearColonnaTabella,TO_CHAR(gdo, 'D') as dayOfWeekColonna,TO_CHAR(aliasMSG.gdo, 'D') as dayOfWeekColonnaTabella FROM msgdiagnostici as aliasMSG WHERE ( TO_CHAR(gdo, 'D') = '2' )
16:52:10    [testng] riga[0]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.491)
16:52:10    [testng] riga[1]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[2]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[3]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[4]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[5]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[6]= [DayOfWeekCondition] (secondColonna:9.491) (secondColonnaTabella:9.491)
16:52:10    [testng] riga[7]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[8]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[9]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[10]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[11]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.494)
16:52:10    [testng] riga[12]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[13]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[14]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[15]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[16]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[17]= [DayOfWeekCondition] (secondColonna:9.494045) (secondColonnaTabella:9.494045)
16:52:10    [testng] riga[18]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[19]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[20]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[21]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[22]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.496)
16:52:10    [testng] riga[23]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[24]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[25]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[26]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[27]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[28]= [DayOfWeekCondition] (secondColonna:9.496) (secondColonnaTabella:9.496)
16:52:10    [testng] riga[29]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[30]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[31]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[32]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[33]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.499)
16:52:10    [testng] riga[34]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[35]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[36]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[37]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[38]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[39]= [DayOfWeekCondition] (secondColonna:9.499157) (secondColonnaTabella:9.499157)
16:52:10    [testng] riga[40]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[41]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[42]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[43]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[44]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.500)
16:52:10    [testng] riga[45]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[46]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[47]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[48]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[49]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[50]= [DayOfWeekCondition] (secondColonna:9.5) (secondColonnaTabella:9.5)
16:52:10    [testng] riga[51]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[52]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[53]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[54]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[55]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.501)
16:52:10    [testng] riga[56]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[57]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[58]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[59]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[60]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[61]= [DayOfWeekCondition] (secondColonna:9.501745) (secondColonnaTabella:9.501745)
16:52:10    [testng] riga[62]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[63]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[64]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[65]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[66]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.502)
16:52:10    [testng] riga[67]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[68]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[69]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[70]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[71]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[72]= [DayOfWeekCondition] (secondColonna:9.502) (secondColonnaTabella:9.502)
16:52:10    [testng] riga[73]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[74]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[75]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[76]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[77]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.504)
16:52:10    [testng] riga[78]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[79]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[80]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[81]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[82]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[83]= [DayOfWeekCondition] (secondColonna:9.504161) (secondColonnaTabella:9.504161)
16:52:10    [testng] riga[84]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[85]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[86]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[87]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[88]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.505)
16:52:10    [testng] riga[89]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[90]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[91]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[92]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[93]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[94]= [DayOfWeekCondition] (secondColonna:9.505) (secondColonnaTabella:9.505)
16:52:10    [testng] riga[95]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[96]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[97]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[98]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[99]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.507)
16:52:10    [testng] riga[100]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[101]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[102]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[103]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[104]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[105]= [DayOfWeekCondition] (secondColonna:9.507373) (secondColonnaTabella:9.507373)
16:52:10    [testng] riga[106]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[107]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[108]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[109]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[110]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.508)
16:52:10    [testng] riga[111]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[112]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[113]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[114]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[115]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[116]= [DayOfWeekCondition] (secondColonna:9.508) (secondColonnaTabella:9.508)
16:52:10    [testng] riga[117]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[118]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[119]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[120]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[121]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.509)
16:52:10    [testng] riga[122]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[123]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[124]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[125]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[126]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[127]= [DayOfWeekCondition] (secondColonna:9.509892) (secondColonnaTabella:9.509892)
16:52:10    [testng] riga[128]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[129]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[130]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[131]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[132]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.510)
16:52:10    [testng] riga[133]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[134]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[135]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[136]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[137]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[138]= [DayOfWeekCondition] (secondColonna:9.51) (secondColonnaTabella:9.51)
16:52:10    [testng] riga[139]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[140]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[141]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[142]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[143]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.512)
16:52:10    [testng] riga[144]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[145]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[146]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[147]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[148]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[149]= [DayOfWeekCondition] (secondColonna:9.512582) (secondColonnaTabella:9.512582)
16:52:10    [testng] riga[150]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[151]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[152]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[153]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[154]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.514)
16:52:10    [testng] riga[155]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[156]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[157]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[158]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[159]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[160]= [DayOfWeekCondition] (secondColonna:9.514) (secondColonnaTabella:9.514)
16:52:10    [testng] riga[161]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[162]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[163]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[164]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[165]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.516)
16:52:10    [testng] riga[166]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[167]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[168]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[169]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[170]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[171]= [DayOfWeekCondition] (secondColonna:9.516802) (secondColonnaTabella:9.516802)
16:52:10    [testng] riga[172]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[173]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[174]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[175]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[176]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.517)
16:52:10    [testng] riga[177]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[178]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[179]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[180]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[181]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[182]= [DayOfWeekCondition] (secondColonna:9.517) (secondColonnaTabella:9.517)
16:52:10    [testng] riga[183]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[184]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[185]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[186]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[187]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.518)
16:52:10    [testng] riga[188]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[189]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[190]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[191]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[192]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[193]= [DayOfWeekCondition] (secondColonna:9.518978) (secondColonnaTabella:9.518978)
16:52:10    [testng] riga[194]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[195]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[196]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[197]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[198]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.520)
16:52:10    [testng] riga[199]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[200]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[201]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[202]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[203]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[204]= [DayOfWeekCondition] (secondColonna:9.52) (secondColonnaTabella:9.52)
16:52:10    [testng] riga[205]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[206]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[207]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[208]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[209]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.521)
16:52:10    [testng] riga[210]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[211]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[212]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[213]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[214]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[215]= [DayOfWeekCondition] (secondColonna:9.521287) (secondColonnaTabella:9.521287)
16:52:10    [testng] riga[216]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[217]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[218]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[219]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] riga[220]= [DayOfWeekCondition] (data:2024-07-15 16:52:09.522)
16:52:10    [testng] riga[221]= [DayOfWeekCondition] (yearColonna:2024) (yearColonnaTabella:2024)
16:52:10    [testng] riga[222]= [DayOfWeekCondition] (monthColonna:7) (monthColonnaTabella:7)
16:52:10    [testng] riga[223]= [DayOfWeekCondition] (dayColonna:15) (dayColonnaTabella:15)
16:52:10    [testng] riga[224]= [DayOfWeekCondition] (hourColonna:16) (hourColonnaTabella:16)
16:52:10    [testng] riga[225]= [DayOfWeekCondition] (minuteColonna:52) (minuteColonnaTabella:52)
16:52:10    [testng] riga[226]= [DayOfWeekCondition] (secondColonna:9.522) (secondColonnaTabella:9.522)
16:52:10    [testng] riga[227]= [DayOfWeekCondition] (fullDayNameColonna:MONDAY) (fullDayNameColonnaTabella:MONDAY)
16:52:10    [testng] riga[228]= [DayOfWeekCondition] (shortDayNameColonna:MON) (shortDayNameColonnaTabella:MON)
16:52:10    [testng] riga[229]= [DayOfWeekCondition] (dayOfYearColonna:197) (dayOfYearColonnaTabella:197)
16:52:10    [testng] riga[230]= [DayOfWeekCondition] (dayOfWeekColonna:2) (dayOfWeekColonnaTabella:2)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] test0_engine:
16:52:10    [testng] 	SELECT timestamp '2024-07-15 16:52:10.372' 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
16:52:10    [testng] riga[0]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[2]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[4]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[6]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[8]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[10]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[12]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[14]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[16]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[18]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[20]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[22]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[24]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[26]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[28]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[30]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[32]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[34]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[36]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[38]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[40]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] test0_engine:
16:52:10    [testng] 	SELECT timestamp '2024-07-15 16:52:10.372' 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 '2024-07-15 16:52:10.372'=? ) AND ( timestamp '2022-01-01 12:34:56.789'<? ) AND ( timestamp '2092-10-31 17:34:56.789'>? )
16:52:10    [testng] riga[0]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[2]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[4]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[6]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[8]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[10]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[12]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[14]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[16]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[18]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[20]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[22]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[24]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[26]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[28]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[30]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[32]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[34]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[36]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[38]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] riga[40]= (now:2024-07-15 16:52:10.372) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
16:52:10    [testng] (test0_engine) [postgresql] getFieldsName: 	[cont, avgMedio, mittente, ALIASDEST]
16:52:10    [testng] (test0_engine) [postgresql] getTablesName: 	[tracce, aliasMSG]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] test0_engine:
16:52:10    [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 
16:52:10    [testng] riga[0]= (SoggettoMittente0->SoggettoDestinatario0) (count:2)
16:52:10    [testng] riga[1]= (SoggettoMittente1->SoggettoDestinatario1) (count:2)
16:52:10    [testng] riga[2]= (SoggettoMittente2->SoggettoDestinatario2) (count:2)
16:52:10    [testng] riga[3]= (SoggettoMittente3->SoggettoDestinatario3) (count:2)
16:52:10    [testng] riga[4]= (SoggettoMittente4->SoggettoDestinatario4) (count:2)
16:52:10    [testng] riga[5]= (SoggettoMittente5->SoggettoDestinatario5) (count:2)
16:52:10    [testng] riga[6]= (SoggettoMittente6->SoggettoDestinatario6) (count:2)
16:52:10    [testng] riga[7]= (SoggettoMittente7->SoggettoDestinatario7) (count:2)
16:52:10    [testng] riga[8]= (SoggettoMittente8->SoggettoDestinatario8) (count:2)
16:52:10    [testng] riga[9]= (SoggettoMittente9->SoggettoDestinatario9) (count:2)
16:52:10    [testng] riga[10]= (SoggettoMittente10->SoggettoDestinatario10) (count:1)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] a. ** Query normale
16:52:10    [testng] 
16:52:10    [testng] Test1(false) [postgresql] [QueryNormale]:
16:52:10    [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 
16:52:10    [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
16:52:10    [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
16:52:10    [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
16:52:10    [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
16:52:10    [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
16:52:10    [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
16:52:10    [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
16:52:10    [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
16:52:10    [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
16:52:10    [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
16:52:10    [testng] riga[10]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
16:52:10    [testng] riga[11]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
16:52:10    [testng] riga[12]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
16:52:10    [testng] riga[13]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
16:52:10    [testng] riga[14]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
16:52:10    [testng] riga[15]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
16:52:10    [testng] riga[16]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
16:52:10    [testng] riga[17]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
16:52:10    [testng] riga[18]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
16:52:10    [testng] riga[19]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
16:52:10    [testng] riga[20]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] b. ** Query con limit/offset
16:52:10    [testng] 
16:52:10    [testng] Test1(false) [postgresql] [QueryLimitOffset]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
16:52:10    [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
16:52:10    [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
16:52:10    [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
16:52:10    [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
16:52:10    [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
16:52:10    [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
16:52:10    [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
16:52:10    [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
16:52:10    [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] b. ** Query con limit/offset (unixTimestamp)
16:52:10    [testng] 
16:52:10    [testng] Test1(false) [postgresql] [QueryLimitOffset]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)(45)
16:52:10    [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)(10364600101)
16:52:10    [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)(91)
16:52:10    [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)(31104600303)
16:52:10    [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)(217732202121)
16:52:10    [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)(137)
16:52:10    [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)(51837400505)
16:52:10    [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)(183)
16:52:10    [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)(72573800707)
16:52:10    [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)(228)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] c. ** Query con limit
16:52:10    [testng] 
16:52:10    [testng] Test1(false) [postgresql] [QueryLimit]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
16:52:10    [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
16:52:10    [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
16:52:10    [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
16:52:10    [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
16:52:10    [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
16:52:10    [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
16:52:10    [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
16:52:10    [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
16:52:10    [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] d. ** Query con offset
16:52:10    [testng] 
16:52:10    [testng] Test1(false) [postgresql] [QueryOffset]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
16:52:10    [testng] riga[1]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
16:52:10    [testng] riga[2]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
16:52:10    [testng] riga[3]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
16:52:10    [testng] riga[4]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
16:52:10    [testng] riga[5]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
16:52:10    [testng] riga[6]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
16:52:10    [testng] riga[7]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
16:52:10    [testng] riga[8]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
16:52:10    [testng] riga[9]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
16:52:10    [testng] riga[10]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
16:52:10    [testng] riga[11]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
16:52:10    [testng] riga[12]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
16:52:10    [testng] riga[13]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
16:52:10    [testng] riga[14]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
16:52:10    [testng] riga[15]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
16:52:10    [testng] riga[16]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
16:52:10    [testng] riga[17]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
16:52:10    [testng] riga[18]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] e. ** Query groupBy
16:52:10    [testng] 
16:52:10    [testng] Test1(false) [postgresql] [GroupBy]:
16:52:10    [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 
16:52:10    [testng] riga[0]= (SoggettoMittente0) = 2
16:52:10    [testng] riga[1]= (SoggettoMittente1) = 2
16:52:10    [testng] riga[2]= (SoggettoMittente10) = 1
16:52:10    [testng] riga[3]= (SoggettoMittente2) = 2
16:52:10    [testng] riga[4]= (SoggettoMittente3) = 2
16:52:10    [testng] riga[5]= (SoggettoMittente4) = 2
16:52:10    [testng] riga[6]= (SoggettoMittente5) = 2
16:52:10    [testng] riga[7]= (SoggettoMittente6) = 2
16:52:10    [testng] riga[8]= (SoggettoMittente7) = 2
16:52:10    [testng] riga[9]= (SoggettoMittente8) = 2
16:52:10    [testng] riga[10]= (SoggettoMittente9) = 2
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] f. ** Query groupBy con limit/offset
16:52:10    [testng] 
16:52:10    [testng] Test1(false) [postgresql] [GroupByLimitOffset]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente1) = 2
16:52:10    [testng] riga[1]= (SoggettoMittente10) = 1
16:52:10    [testng] riga[2]= (SoggettoMittente2) = 2
16:52:10    [testng] riga[3]= (SoggettoMittente3) = 2
16:52:10    [testng] riga[4]= (SoggettoMittente4) = 2
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] g. ** Query con select*
16:52:10    [testng] 
16:52:10    [testng] Test1(false) [postgresql] [QuerySelect*]:
16:52:10    [testng] 	SELECT * FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,tipo_destinatario ASC ,tracce.destinatario DESC  FOR UPDATE 
16:52:10    [testng] riga[0]= (SoggettoMittente0)
16:52:10    [testng] riga[1]= (SoggettoMittente0)
16:52:10    [testng] riga[2]= (SoggettoMittente1)
16:52:10    [testng] riga[3]= (SoggettoMittente1)
16:52:10    [testng] riga[4]= (SoggettoMittente10)
16:52:10    [testng] riga[5]= (SoggettoMittente2)
16:52:10    [testng] riga[6]= (SoggettoMittente2)
16:52:10    [testng] riga[7]= (SoggettoMittente3)
16:52:10    [testng] riga[8]= (SoggettoMittente3)
16:52:10    [testng] riga[9]= (SoggettoMittente4)
16:52:10    [testng] riga[10]= (SoggettoMittente4)
16:52:10    [testng] riga[11]= (SoggettoMittente5)
16:52:10    [testng] riga[12]= (SoggettoMittente5)
16:52:10    [testng] riga[13]= (SoggettoMittente6)
16:52:10    [testng] riga[14]= (SoggettoMittente6)
16:52:10    [testng] riga[15]= (SoggettoMittente7)
16:52:10    [testng] riga[16]= (SoggettoMittente7)
16:52:10    [testng] riga[17]= (SoggettoMittente8)
16:52:10    [testng] riga[18]= (SoggettoMittente8)
16:52:10    [testng] riga[19]= (SoggettoMittente9)
16:52:10    [testng] riga[20]= (SoggettoMittente9)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] h. ** Query con select* e offset/limit
16:52:10    [testng] 
16:52:10    [testng] Test1(false) [postgresql] [QuerySelect*LimitOffset*]:
16:52:10    [testng] 	SELECT * FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,tipo_destinatario ASC ,tracce.destinatario DESC  LIMIT 10 OFFSET 0
16:52:10    [testng] riga[0]= (SoggettoMittente0)
16:52:10    [testng] riga[1]= (SoggettoMittente0)
16:52:10    [testng] riga[2]= (SoggettoMittente1)
16:52:10    [testng] riga[3]= (SoggettoMittente1)
16:52:10    [testng] riga[4]= (SoggettoMittente10)
16:52:10    [testng] riga[5]= (SoggettoMittente2)
16:52:10    [testng] riga[6]= (SoggettoMittente2)
16:52:10    [testng] riga[7]= (SoggettoMittente3)
16:52:10    [testng] riga[8]= (SoggettoMittente3)
16:52:10    [testng] riga[9]= (SoggettoMittente4)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] i. ** Query con select* e offset/limit e alias
16:52:10    [testng] 
16:52:10    [testng] Test1(false) [postgresql] [QuerySelect*LimitOffsetAlias*]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente0)
16:52:10    [testng] riga[1]= (SoggettoMittente0)
16:52:10    [testng] riga[2]= (SoggettoMittente1)
16:52:10    [testng] riga[3]= (SoggettoMittente1)
16:52:10    [testng] riga[4]= (SoggettoMittente10)
16:52:10    [testng] riga[5]= (SoggettoMittente2)
16:52:10    [testng] riga[6]= (SoggettoMittente2)
16:52:10    [testng] riga[7]= (SoggettoMittente3)
16:52:10    [testng] riga[8]= (SoggettoMittente3)
16:52:10    [testng] riga[9]= (SoggettoMittente4)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] a. ** Query normale
16:52:10    [testng] 
16:52:10    [testng] Test1(true) [postgresql] [QueryNormale]:
16:52:10    [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 
16:52:10    [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
16:52:10    [testng] riga[1]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
16:52:10    [testng] riga[2]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
16:52:10    [testng] riga[3]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
16:52:10    [testng] riga[4]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
16:52:10    [testng] riga[5]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
16:52:10    [testng] riga[6]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
16:52:10    [testng] riga[7]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
16:52:10    [testng] riga[8]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
16:52:10    [testng] riga[9]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
16:52:10    [testng] riga[10]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] b. ** Query con limit/offset
16:52:10    [testng] 
16:52:10    [testng] Test1(true) [postgresql] [QueryLimitOffset]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
16:52:10    [testng] riga[1]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
16:52:10    [testng] riga[2]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
16:52:10    [testng] riga[3]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
16:52:10    [testng] riga[4]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
16:52:10    [testng] riga[5]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
16:52:10    [testng] riga[6]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
16:52:10    [testng] riga[7]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
16:52:10    [testng] riga[8]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
16:52:10    [testng] riga[9]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] b. ** Query con limit/offset (unixTimestamp)
16:52:10    [testng] 
16:52:10    [testng] Test1(true) [postgresql] [QueryLimitOffset]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)(45)
16:52:10    [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)(10364600101)
16:52:10    [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)(91)
16:52:10    [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)(31104600303)
16:52:10    [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)(217732202121)
16:52:10    [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)(137)
16:52:10    [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)(51837400505)
16:52:10    [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)(183)
16:52:10    [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)(72573800707)
16:52:10    [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)(228)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] c. ** Query con limit
16:52:10    [testng] 
16:52:10    [testng] Test1(true) [postgresql] [QueryLimit]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
16:52:10    [testng] riga[1]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
16:52:10    [testng] riga[2]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
16:52:10    [testng] riga[3]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
16:52:10    [testng] riga[4]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
16:52:10    [testng] riga[5]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
16:52:10    [testng] riga[6]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
16:52:10    [testng] riga[7]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
16:52:10    [testng] riga[8]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
16:52:10    [testng] riga[9]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] d. ** Query con offset
16:52:10    [testng] 
16:52:10    [testng] Test1(true) [postgresql] [QueryOffset]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
16:52:10    [testng] riga[1]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
16:52:10    [testng] riga[2]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
16:52:10    [testng] riga[3]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
16:52:10    [testng] riga[4]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
16:52:10    [testng] riga[5]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
16:52:10    [testng] riga[6]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
16:52:10    [testng] riga[7]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
16:52:10    [testng] riga[8]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] e. ** Query groupBy
16:52:10    [testng] 
16:52:10    [testng] Test1(true) [postgresql] [GroupBy]:
16:52:10    [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 
16:52:10    [testng] riga[0]= (SoggettoMittente0) = 2
16:52:10    [testng] riga[1]= (SoggettoMittente1) = 2
16:52:10    [testng] riga[2]= (SoggettoMittente10) = 1
16:52:10    [testng] riga[3]= (SoggettoMittente2) = 2
16:52:10    [testng] riga[4]= (SoggettoMittente3) = 2
16:52:10    [testng] riga[5]= (SoggettoMittente4) = 2
16:52:10    [testng] riga[6]= (SoggettoMittente5) = 2
16:52:10    [testng] riga[7]= (SoggettoMittente6) = 2
16:52:10    [testng] riga[8]= (SoggettoMittente7) = 2
16:52:10    [testng] riga[9]= (SoggettoMittente8) = 2
16:52:10    [testng] riga[10]= (SoggettoMittente9) = 2
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] f. ** Query groupBy con limit/offset
16:52:10    [testng] 
16:52:10    [testng] Test1(true) [postgresql] [GroupByLimitOffset]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente1) = 2
16:52:10    [testng] riga[1]= (SoggettoMittente10) = 1
16:52:10    [testng] riga[2]= (SoggettoMittente2) = 2
16:52:10    [testng] riga[3]= (SoggettoMittente3) = 2
16:52:10    [testng] riga[4]= (SoggettoMittente4) = 2
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] g. ** Query con select*
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] h. ** Query con select* e offset/limit
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] i. ** Query con select* e offset/limit e alias
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] a. ** Query Union (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:true) [postgresql] [Normale UnionAll]:
16:52:10    [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 
16:52:10    [testng] riga[0]= (SoggettoMittente0):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente0):[2]
16:52:10    [testng] riga[2]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[3]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[4]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[5]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[6]= (SoggettoMittente2):[2]
16:52:10    [testng] riga[7]= (SoggettoMittente2):[2]
16:52:10    [testng] riga[8]= (SoggettoMittente3):[2]
16:52:10    [testng] riga[9]= (SoggettoMittente3):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] b. ** Query Union OffSetLimit (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:true) [postgresql] [OffSetLimit UnionAll]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[2]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[3]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[4]= (SoggettoMittente2):[2]
16:52:10    [testng] riga[5]= (SoggettoMittente2):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] c. ** Query Union OffSet (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:true) [postgresql] [OffSet UnionAll]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[2]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[3]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[4]= (SoggettoMittente2):[2]
16:52:10    [testng] riga[5]= (SoggettoMittente2):[2]
16:52:10    [testng] riga[6]= (SoggettoMittente3):[2]
16:52:10    [testng] riga[7]= (SoggettoMittente3):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] d. ** Query Union Limit (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:true) [postgresql] [OffSet UnionAll]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente0):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente0):[2]
16:52:10    [testng] riga[2]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[3]= (SoggettoMittente1):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] e. ** Query Union con select* (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:true) [postgresql] [Normale UnionAll]:
16:52:10    [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 
16:52:10    [testng] riga[0]= (SoggettoMittente0):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente0):[2]
16:52:10    [testng] riga[2]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[3]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[4]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[5]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[6]= (SoggettoMittente2):[2]
16:52:10    [testng] riga[7]= (SoggettoMittente2):[2]
16:52:10    [testng] riga[8]= (SoggettoMittente3):[2]
16:52:10    [testng] riga[9]= (SoggettoMittente3):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] f. ** Query Union con select* e LimitOffset (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] g. ** Query Union con select* e Offset (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] h. ** Query Union con select* e Limit (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] i. ** Query Union per test SelectForUpdate (unionCount:false unionAll:true)
16:52:10    [testng] ERRORE ATTESO: Parametro SqlQueryObject[0] non valido: Utilizzo dell'opzione 'FOR UPDATE' non permesso con il comando UNION
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] a. ** Query Union (unionCount:true unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] Test(count:true unionAll:true) [postgresql] [Normale UnionAll]:
16:52:10    [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 
16:52:10    [testng] riga[0]= [10]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] e. ** Query Union con select* (unionCount:true unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] Test(count:true unionAll:true) [postgresql] [Normale UnionAll]:
16:52:10    [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 
16:52:10    [testng] riga[0]= [10]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] i. ** Query Union per test SelectForUpdate (unionCount:true unionAll:true)
16:52:10    [testng] ERRORE ATTESO: Parametro SqlQueryObject[0] non valido: Utilizzo dell'opzione 'FOR UPDATE' non permesso con il comando UNION
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] a. ** Query Union (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:false) [postgresql] [Normale UnionAll]:
16:52:10    [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 
16:52:10    [testng] riga[0]= (SoggettoMittente0):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[2]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[3]= (SoggettoMittente2):[2]
16:52:10    [testng] riga[4]= (SoggettoMittente3):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] b. ** Query Union OffSetLimit (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:false) [postgresql] [OffSetLimit UnionAll]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[2]= (SoggettoMittente2):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] c. ** Query Union OffSet (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:false) [postgresql] [OffSet UnionAll]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[2]= (SoggettoMittente2):[2]
16:52:10    [testng] riga[3]= (SoggettoMittente3):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] d. ** Query Union Limit (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:false) [postgresql] [OffSet UnionAll]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente0):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente1):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] e. ** Query Union con select* (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:false) [postgresql] [Normale UnionAll]:
16:52:10    [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 
16:52:10    [testng] riga[0]= (SoggettoMittente0):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[2]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[3]= (SoggettoMittente2):[2]
16:52:10    [testng] riga[4]= (SoggettoMittente3):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] f. ** Query Union con select* e LimitOffset (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] g. ** Query Union con select* e Offset (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] h. ** Query Union con select* e Limit (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] i. ** Query Union per test SelectForUpdate (unionCount:false unionAll:false)
16:52:10    [testng] ERRORE ATTESO: Parametro SqlQueryObject[0] non valido: Utilizzo dell'opzione 'FOR UPDATE' non permesso con il comando UNION
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] a. ** Query Union (unionCount:true unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] Test(count:true unionAll:false) [postgresql] [Normale UnionAll]:
16:52:10    [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 
16:52:10    [testng] riga[0]= [5]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] e. ** Query Union con select* (unionCount:true unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] Test(count:true unionAll:false) [postgresql] [Normale UnionAll]:
16:52:10    [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 
16:52:10    [testng] riga[0]= [5]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] i. ** Query Union per test SelectForUpdate (unionCount:true unionAll:false)
16:52:10    [testng] ERRORE ATTESO: Parametro SqlQueryObject[0] non valido: Utilizzo dell'opzione 'FOR UPDATE' non permesso con il comando UNION
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] a. ** Query UnionGroupBy (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:true) [postgresql] [Normale UnionAll]:
16:52:10    [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 
16:52:10    [testng] riga[0]= (SoggettoMittente0):[4]
16:52:10    [testng] riga[1]= (SoggettoMittente1):[4]
16:52:10    [testng] riga[2]= (SoggettoMittente10):[2]
16:52:10    [testng] riga[3]= (SoggettoMittente2):[4]
16:52:10    [testng] riga[4]= (SoggettoMittente3):[4]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] b. ** Query UnionGroupBy OffSetLimit (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:true) [postgresql] [OffSetLimit UnionAll]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente1):[4]
16:52:10    [testng] riga[1]= (SoggettoMittente10):[2]
16:52:10    [testng] riga[2]= (SoggettoMittente2):[4]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] c. ** Query UnionGroupBy  OffSet (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:true) [postgresql] [OffSet UnionAll]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente1):[4]
16:52:10    [testng] riga[1]= (SoggettoMittente10):[2]
16:52:10    [testng] riga[2]= (SoggettoMittente2):[4]
16:52:10    [testng] riga[3]= (SoggettoMittente3):[4]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] d. ** Query UnionGroupBy Limit (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:true) [postgresql] [OffSet UnionAll]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente0):[4]
16:52:10    [testng] riga[1]= (SoggettoMittente1):[4]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] e. ** Query UnionGroupBy con select* (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] f. ** Query UnionGroupBy con select* e LimitOffset (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] g. ** Query UnionGroupBy con select* e Offset (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] h. ** Query UnionGroupBy con select* e Limit (unionCount:false unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] a. ** Query UnionGroupBy (unionCount:true unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] Test(count:true unionAll:true) [postgresql] [Normale UnionAll]:
16:52:10    [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 
16:52:10    [testng] riga[0]= [5]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] e. ** Query UnionGroupBy con select* (unionCount:true unionAll:true)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] a. ** Query UnionGroupBy (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:false) [postgresql] [Normale UnionAll]:
16:52:10    [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 
16:52:10    [testng] riga[0]= (SoggettoMittente0):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[2]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[3]= (SoggettoMittente2):[2]
16:52:10    [testng] riga[4]= (SoggettoMittente3):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] b. ** Query UnionGroupBy OffSetLimit (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:false) [postgresql] [OffSetLimit UnionAll]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[2]= (SoggettoMittente2):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] c. ** Query UnionGroupBy  OffSet (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:false) [postgresql] [OffSet UnionAll]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente1):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente10):[1]
16:52:10    [testng] riga[2]= (SoggettoMittente2):[2]
16:52:10    [testng] riga[3]= (SoggettoMittente3):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] d. ** Query UnionGroupBy Limit (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] Test(count:false unionAll:false) [postgresql] [OffSet UnionAll]:
16:52:10    [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
16:52:10    [testng] riga[0]= (SoggettoMittente0):[2]
16:52:10    [testng] riga[1]= (SoggettoMittente1):[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] e. ** Query UnionGroupBy con select* (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] f. ** Query UnionGroupBy con select* e LimitOffset (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] g. ** Query UnionGroupBy con select* e Offset (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] h. ** Query UnionGroupBy con select* e Limit (unionCount:false unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] a. ** Query UnionGroupBy (unionCount:true unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] Test(count:true unionAll:false) [postgresql] [Normale UnionAll]:
16:52:10    [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 
16:52:10    [testng] riga[0]= [5]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] e. ** Query UnionGroupBy con select* (unionCount:true unionAll:false)
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] h. ** Test IS NULL / IS EMPTY
16:52:10    [testng] 
16:52:10    [testng] test1-msgdiagnostici isNull:
16:52:10    [testng] 	SELECT campo_vuoto,descrizione,gdo FROM msgdiagnostici WHERE ( campo_vuoto is null ) ORDER BY gdo ASC  FOR UPDATE 
16:52:10    [testng] riga[0]=descrizione esempio 1 (time:2024-07-15 16:52:09.494045 campo_vuoto:(null)
16:52:10    [testng] riga[1]=descrizione esempio 2 (time:2024-07-15 16:52:09.496 campo_vuoto:(null)
16:52:10    [testng] riga[2]=descrizione esempio 3 (time:2024-07-15 16:52:09.499157 campo_vuoto:(null)
16:52:10    [testng] riga[3]=descrizione esempio 4 (time:2024-07-15 16:52:09.5 campo_vuoto:(null)
16:52:10    [testng] riga[4]=descrizione esempio 5 (time:2024-07-15 16:52:09.501745 campo_vuoto:(null)
16:52:10    [testng] riga[5]=descrizione esempio 6 (time:2024-07-15 16:52:09.502 campo_vuoto:(null)
16:52:10    [testng] riga[6]=descrizione esempio 7 (time:2024-07-15 16:52:09.504161 campo_vuoto:(null)
16:52:10    [testng] riga[7]=descrizione esempio 8 (time:2024-07-15 16:52:09.505 campo_vuoto:(null)
16:52:10    [testng] riga[8]=descrizione esempio 9 (time:2024-07-15 16:52:09.507373 campo_vuoto:(null)
16:52:10    [testng] riga[9]=descrizione esempio uguale (time:2024-07-15 16:52:09.508 campo_vuoto:(null)
16:52:10    [testng] Attesi [10] trovati[10]
16:52:10    [testng] 
16:52:10    [testng] test2-msgdiagnostici isNotNull:
16:52:10    [testng] 	SELECT campo_vuoto,descrizione,gdo FROM msgdiagnostici WHERE ( campo_vuoto is not null ) ORDER BY gdo ASC  FOR UPDATE 
16:52:10    [testng] riga[0]=descrizione esempio 0 (time:2024-07-15 16:52:09.491 campo_vuoto:(Prima colonna valorizzata)
16:52:10    [testng] riga[1]=descrizione esempio uguale (time:2024-07-15 16:52:09.509892 campo_vuoto:()
16:52:10    [testng] riga[2]=descrizione esempio uguale (time:2024-07-15 16:52:09.51 campo_vuoto:()
16:52:10    [testng] riga[3]=descrizione esempio uguale (time:2024-07-15 16:52:09.512582 campo_vuoto:()
16:52:10    [testng] riga[4]=descrizione esempio uguale (time:2024-07-15 16:52:09.514 campo_vuoto:()
16:52:10    [testng] riga[5]=descrizione esempio uguale (time:2024-07-15 16:52:09.516802 campo_vuoto:()
16:52:10    [testng] riga[6]=descrizione esempio uguale (time:2024-07-15 16:52:09.517 campo_vuoto:()
16:52:10    [testng] riga[7]=descrizione esempio uguale (time:2024-07-15 16:52:09.518978 campo_vuoto:()
16:52:10    [testng] riga[8]=descrizione esempio uguale (time:2024-07-15 16:52:09.52 campo_vuoto:()
16:52:10    [testng] riga[9]=descrizione esempio uguale (time:2024-07-15 16:52:09.521287 campo_vuoto:()
16:52:10    [testng] riga[10]=descrizione con caratteri particolari: ------- { ( [ _ % ^ \ / # | & à è @ . : ; , < parolaCasualeMAIUSCOLA > é ù ì ^ " ' ? ! ] ) } ------
16:52:10    [testng]  	 
16:52:10    [testng]   Un  po di parole Maiuscole Minuscole § ° ç £----- (time:2024-07-15 16:52:09.522 campo_vuoto:(Ultima colonna valorizzata)Attesi [11] trovati[11]
16:52:10    [testng] 
16:52:10    [testng] test3-msgdiagnostici isEmpty:
16:52:10    [testng] 	SELECT campo_vuoto,descrizione,gdo FROM msgdiagnostici WHERE ( campo_vuoto = '' ) ORDER BY gdo ASC  FOR UPDATE 
16:52:10    [testng] riga[0]=descrizione esempio uguale (time:2024-07-15 16:52:09.509892 campo_vuoto:()
16:52:10    [testng] riga[1]=descrizione esempio uguale (time:2024-07-15 16:52:09.51 campo_vuoto:()
16:52:10    [testng] riga[2]=descrizione esempio uguale (time:2024-07-15 16:52:09.512582 campo_vuoto:()
16:52:10    [testng] riga[3]=descrizione esempio uguale (time:2024-07-15 16:52:09.514 campo_vuoto:()
16:52:10    [testng] riga[4]=descrizione esempio uguale (time:2024-07-15 16:52:09.516802 campo_vuoto:()
16:52:10    [testng] riga[5]=descrizione esempio uguale (time:2024-07-15 16:52:09.517 campo_vuoto:()
16:52:10    [testng] riga[6]=descrizione esempio uguale (time:2024-07-15 16:52:09.518978 campo_vuoto:()
16:52:10    [testng] riga[7]=descrizione esempio uguale (time:2024-07-15 16:52:09.52 campo_vuoto:()
16:52:10    [testng] riga[8]=descrizione esempio uguale (time:2024-07-15 16:52:09.521287 campo_vuoto:()
16:52:10    [testng] Attesi [9] trovati[9]
16:52:10    [testng] 
16:52:10    [testng] test4-msgdiagnostici isNotEmpty:
16:52:10    [testng] 	SELECT campo_vuoto,descrizione,gdo FROM msgdiagnostici WHERE ( campo_vuoto <> '' ) ORDER BY gdo ASC  FOR UPDATE 
16:52:10    [testng] riga[0]=descrizione esempio 0 (time:2024-07-15 16:52:09.491 campo_vuoto:(Prima colonna valorizzata)
16:52:10    [testng] riga[1]=descrizione con caratteri particolari: ------- { ( [ _ % ^ \ / # | & à è @ . : ; , < parolaCasualeMAIUSCOLA > é ù ì ^ " ' ? ! ] ) } ------
16:52:10    [testng]  	 
16:52:10    [testng]   Un  po di parole Maiuscole Minuscole § ° ç £----- (time:2024-07-15 16:52:09.522 campo_vuoto:(Ultima colonna valorizzata)Attesi [2] trovati[2]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] h. ** Test CASE
16:52:10    [testng] 
16:52:10    [testng] test1-tracce case:
16:52:10    [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 
16:52:10    [testng] riga[0] mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2024-07-15 16:52:09.524)
16:52:10    [testng] riga[1] mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2024-07-15 16:52:09.527506)
16:52:10    [testng] riga[2] mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2024-07-15 16:52:09.529)
16:52:10    [testng] riga[3] mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2024-07-15 16:52:09.530846)
16:52:10    [testng] riga[4] mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2024-07-15 16:52:09.531)
16:52:10    [testng] riga[5] mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2024-07-15 16:52:09.532897)
16:52:10    [testng] riga[6] mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2024-07-15 16:52:09.533)
16:52:10    [testng] riga[7] mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2024-07-15 16:52:09.535232)
16:52:10    [testng] riga[8] mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2024-07-15 16:52:09.536)
16:52:10    [testng] riga[9] mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2024-07-15 16:52:09.538229)
16:52:10    [testng] riga[10] mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2024-07-15 16:52:09.539)
16:52:10    [testng] riga[11] mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2024-07-15 16:52:09.540472)
16:52:10    [testng] riga[12] mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2024-07-15 16:52:09.541)
16:52:10    [testng] riga[13] mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2024-07-15 16:52:09.542562)
16:52:10    [testng] riga[14] mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2024-07-15 16:52:09.543)
16:52:10    [testng] riga[15] mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2024-07-15 16:52:09.545379)
16:52:10    [testng] riga[16] mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2024-07-15 16:52:09.546)
16:52:10    [testng] riga[17] mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2024-07-15 16:52:09.547568)
16:52:10    [testng] riga[18] mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2024-07-15 16:52:09.548)
16:52:10    [testng] riga[19] mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2024-07-15 16:52:09.54997)
16:52:10    [testng] riga[20] mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2024-07-15 16:52:09.551)
16:52:10    [testng] Attesi [21] trovati[21]
16:52:10    [testng] 
16:52:10    [testng] test1-tracce case:
16:52:10    [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
16:52:10    [testng] 
16:52:10    [testng] test1-tracce case:
16:52:10    [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 
16:52:10    [testng] riga[0] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2024-07-15 16:52:09.524)
16:52:10    [testng] riga[1] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2024-07-15 16:52:09.527506)
16:52:10    [testng] riga[2] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2024-07-15 16:52:09.529)
16:52:10    [testng] riga[3] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2024-07-15 16:52:09.530846)
16:52:10    [testng] riga[4] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2024-07-15 16:52:09.531)
16:52:10    [testng] riga[5] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2024-07-15 16:52:09.532897)
16:52:10    [testng] riga[6] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2024-07-15 16:52:09.533)
16:52:10    [testng] riga[7] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2024-07-15 16:52:09.535232)
16:52:10    [testng] riga[8] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2024-07-15 16:52:09.536)
16:52:10    [testng] riga[9] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2024-07-15 16:52:09.538229)
16:52:10    [testng] riga[10] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2024-07-15 16:52:09.539)
16:52:10    [testng] riga[11] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2024-07-15 16:52:09.540472)
16:52:10    [testng] riga[12] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2024-07-15 16:52:09.541)
16:52:10    [testng] riga[13] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2024-07-15 16:52:09.542562)
16:52:10    [testng] riga[14] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2024-07-15 16:52:09.543)
16:52:10    [testng] riga[15] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2024-07-15 16:52:09.545379)
16:52:10    [testng] riga[16] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2024-07-15 16:52:09.546)
16:52:10    [testng] riga[17] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2024-07-15 16:52:09.547568)
16:52:10    [testng] riga[18] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2024-07-15 16:52:09.548)
16:52:10    [testng] riga[19] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2024-07-15 16:52:09.54997)
16:52:10    [testng] riga[20] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2024-07-15 16:52:09.551)
16:52:10    [testng] Attesi [21] trovati[21]
16:52:10    [testng] (stringCasoA) Attesi [2] trovati[2]
16:52:10    [testng] (stringCasoB) Attesi [2] trovati[2]
16:52:10    [testng] (stringCasoDefault) Attesi [17] trovati[17]
16:52:10    [testng] (intCasoA) Attesi [4] trovati[4]
16:52:10    [testng] (intCasoB) Attesi [4] trovati[4]
16:52:10    [testng] (intCasoDefault) Attesi [13] trovati[13]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] h. ** Test CASE SENZA ELSE
16:52:10    [testng] 
16:52:10    [testng] test1-tracce case:
16:52:10    [testng] 	UPDATE tracce SET campo_update = ? , campo_int_update = ?
16:52:10    [testng] 
16:52:10    [testng] test1-tracce case:
16:52:10    [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
16:52:10    [testng] 
16:52:10    [testng] test1-tracce case:
16:52:10    [testng] 	SELECT campo_vuoto,descrizione,gdo,mittente,destinatario,campo_update,campo_int_update FROM tracce ORDER BY gdo ASC 
16:52:10    [testng] riga[0] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2024-07-15 16:52:09.524)
16:52:10    [testng] riga[1] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2024-07-15 16:52:09.527506)
16:52:10    [testng] riga[2] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2024-07-15 16:52:09.529)
16:52:10    [testng] riga[3] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2024-07-15 16:52:09.530846)
16:52:10    [testng] riga[4] (string:null int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2024-07-15 16:52:09.531)
16:52:10    [testng] riga[5] (string:null int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2024-07-15 16:52:09.532897)
16:52:10    [testng] riga[6] (string:null int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2024-07-15 16:52:09.533)
16:52:10    [testng] riga[7] (string:null int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2024-07-15 16:52:09.535232)
16:52:10    [testng] riga[8] (string:null int:0) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2024-07-15 16:52:09.536)
16:52:10    [testng] riga[9] (string:null int:0) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2024-07-15 16:52:09.538229)
16:52:10    [testng] riga[10] (string:null int:0) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2024-07-15 16:52:09.539)
16:52:10    [testng] riga[11] (string:null int:0) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2024-07-15 16:52:09.540472)
16:52:10    [testng] riga[12] (string:null int:0) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2024-07-15 16:52:09.541)
16:52:10    [testng] riga[13] (string:null int:0) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2024-07-15 16:52:09.542562)
16:52:10    [testng] riga[14] (string:null int:0) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2024-07-15 16:52:09.543)
16:52:10    [testng] riga[15] (string:null int:0) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2024-07-15 16:52:09.545379)
16:52:10    [testng] riga[16] (string:null int:0) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2024-07-15 16:52:09.546)
16:52:10    [testng] riga[17] (string:null int:0) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2024-07-15 16:52:09.547568)
16:52:10    [testng] riga[18] (string:null int:0) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2024-07-15 16:52:09.548)
16:52:10    [testng] riga[19] (string:null int:0) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2024-07-15 16:52:09.54997)
16:52:10    [testng] riga[20] (string:null int:0) mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2024-07-15 16:52:09.551)
16:52:10    [testng] Attesi [21] trovati[21]
16:52:10    [testng] (stringCasoA) Attesi [2] trovati[2]
16:52:10    [testng] (stringCasoB) Attesi [2] trovati[2]
16:52:10    [testng] (stringCasoDefault) Attesi [0] trovati[0]
16:52:10    [testng] (intCasoA) Attesi [4] trovati[4]
16:52:10    [testng] (intCasoB) Attesi [4] trovati[4]
16:52:10    [testng] (intCasoDefault) Attesi [0] trovati[0]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] h. ** Test CASE senza ?
16:52:10    [testng] 
16:52:10    [testng] test1-tracce case:
16:52:10    [testng] 	UPDATE tracce SET campo_update = ? , campo_int_update = ?
16:52:10    [testng] 
16:52:10    [testng] test1-tracce case:
16:52:10    [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
16:52:10    [testng] 
16:52:10    [testng] test1-tracce case:
16:52:10    [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 
16:52:10    [testng] riga[0] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2024-07-15 16:52:09.524)
16:52:10    [testng] riga[1] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2024-07-15 16:52:09.527506)
16:52:10    [testng] riga[2] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2024-07-15 16:52:09.529)
16:52:10    [testng] riga[3] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2024-07-15 16:52:09.530846)
16:52:10    [testng] riga[4] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2024-07-15 16:52:09.531)
16:52:10    [testng] riga[5] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2024-07-15 16:52:09.532897)
16:52:10    [testng] riga[6] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2024-07-15 16:52:09.533)
16:52:10    [testng] riga[7] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2024-07-15 16:52:09.535232)
16:52:10    [testng] riga[8] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2024-07-15 16:52:09.536)
16:52:10    [testng] riga[9] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2024-07-15 16:52:09.538229)
16:52:10    [testng] riga[10] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2024-07-15 16:52:09.539)
16:52:10    [testng] riga[11] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2024-07-15 16:52:09.540472)
16:52:10    [testng] riga[12] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2024-07-15 16:52:09.541)
16:52:10    [testng] riga[13] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2024-07-15 16:52:09.542562)
16:52:10    [testng] riga[14] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2024-07-15 16:52:09.543)
16:52:10    [testng] riga[15] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2024-07-15 16:52:09.545379)
16:52:10    [testng] riga[16] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2024-07-15 16:52:09.546)
16:52:10    [testng] riga[17] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2024-07-15 16:52:09.547568)
16:52:10    [testng] riga[18] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2024-07-15 16:52:09.548)
16:52:10    [testng] riga[19] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2024-07-15 16:52:09.54997)
16:52:10    [testng] riga[20] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2024-07-15 16:52:09.551)
16:52:10    [testng] Attesi [21] trovati[21]
16:52:10    [testng] (stringCasoA) Attesi [2] trovati[2]
16:52:10    [testng] (stringCasoB) Attesi [2] trovati[2]
16:52:10    [testng] (stringCasoDefault) Attesi [17] trovati[17]
16:52:10    [testng] (intCasoA) Attesi [4] trovati[4]
16:52:10    [testng] (intCasoB) Attesi [4] trovati[4]
16:52:10    [testng] (intCasoDefault) Attesi [13] trovati[13]
16:52:10    [testng] 
16:52:10    [testng] 
16:52:10    [testng] h. ** Test CASE SENZA ELSE senza ?
16:52:10    [testng] 
16:52:10    [testng] test1-tracce case:
16:52:10    [testng] 	UPDATE tracce SET campo_update = ? , campo_int_update = ?
16:52:10    [testng] 
16:52:10    [testng] test1-tracce case:
16:52:10    [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
16:52:10    [testng] 
16:52:10    [testng] test1-tracce case:
16:52:10    [testng] 	SELECT campo_vuoto,descrizione,gdo,mittente,destinatario,campo_update,campo_int_update FROM tracce ORDER BY gdo ASC 
16:52:10    [testng] riga[0] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2024-07-15 16:52:09.524)
16:52:10    [testng] riga[1] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2024-07-15 16:52:09.527506)
16:52:10    [testng] riga[2] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2024-07-15 16:52:09.529)
16:52:10    [testng] riga[3] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2024-07-15 16:52:09.530846)
16:52:10    [testng] riga[4] (string:null int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2024-07-15 16:52:09.531)
16:52:10    [testng] riga[5] (string:null int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2024-07-15 16:52:09.532897)
16:52:10    [testng] riga[6] (string:null int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2024-07-15 16:52:09.533)
16:52:10    [testng] riga[7] (string:null int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2024-07-15 16:52:09.535232)
16:52:10    [testng] riga[8] (string:null int:0) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2024-07-15 16:52:09.536)
16:52:10    [testng] riga[9] (string:null int:0) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2024-07-15 16:52:09.538229)
16:52:10    [testng] riga[10] (string:null int:0) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2024-07-15 16:52:09.539)
16:52:10    [testng] riga[11] (string:null int:0) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2024-07-15 16:52:09.540472)
16:52:10    [testng] riga[12] (string:null int:0) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2024-07-15 16:52:09.541)
16:52:10    [testng] riga[13] (string:null int:0) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2024-07-15 16:52:09.542562)
16:52:10    [testng] riga[14] (string:null int:0) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2024-07-15 16:52:09.543)
16:52:10    [testng] riga[15] (string:null int:0) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2024-07-15 16:52:09.545379)
16:52:10    [testng] riga[16] (string:null int:0) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2024-07-15 16:52:09.546)
16:52:10    [testng] riga[17] (string:null int:0) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2024-07-15 16:52:09.547568)
16:52:10    [testng] riga[18] (string:null int:0) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2024-07-15 16:52:09.548)
16:52:10    [testng] riga[19] (string:null int:0) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2024-07-15 16:52:09.54997)
16:52:10    [testng] riga[20] (string:null int:0) mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2024-07-15 16:52:09.551)
16:52:10    [testng] Attesi [21] trovati[21]
16:52:10    [testng] (stringCasoA) Attesi [2] trovati[2]
16:52:10    [testng] (stringCasoB) Attesi [2] trovati[2]
16:52:10    [testng] (stringCasoDefault) Attesi [0] trovati[0]
16:52:10    [testng] (intCasoA) Attesi [4] trovati[4]
16:52:10    [testng] (intCasoB) Attesi [4] trovati[4]
16:52:10    [testng] (intCasoDefault) Attesi [0] trovati[0]
16:52:10    [testng] Testsuite completata
16:52:10    [testng] Run test 'SQLGenerator' ok
16:52:10    [testng] 
16:52:10    [testng] ===============================================
16:52:10    [testng] Ant suite
16:52:10    [testng] Total tests run: 6, Passes: 6, Failures: 0, Skips: 0
16:52:10    [testng] ===============================================
16:52:10    [testng] 
16:52:12    [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/tools/utils/mvn/sql/build_testunits
16:52:12 [INFO] Executed tasks
16:52:12 [INFO] 
16:52:12 [INFO] ---------< org.openspcoop2:org.openspcoop2.testsuite.pdd.core >---------
16:52:12 [INFO] Building testsuite.pdd.core 1.0                                  [67/72]
16:52:12 [INFO] --------------------------------[ pom ]---------------------------------
16:52:12 [INFO] 
16:52:12 [INFO] -------< org.openspcoop2:org.openspcoop2.testsuite.pdd.core.sql >-------
16:52:12 [INFO] Building testsuite.pdd.core.sql 1.0                              [68/72]
16:52:12 [INFO] --------------------------------[ pom ]---------------------------------
16:52:12 [INFO] 
16:52:12 [INFO] --- maven-dependency-plugin:3.1.1:copy-dependencies (copy-dependencies) @ org.openspcoop2.testsuite.pdd.core.sql ---
16:52:12 [INFO] org.postgresql:postgresql:jar:9.4.1212 already exists in destination.
16:52:12 [INFO] 
16:52:12 [INFO] --- maven-antrun-plugin:1.8:run (default) @ org.openspcoop2.testsuite.pdd.core.sql ---
16:52:12 [INFO] Executing tasks
16:52:12 
16:52:12 main:
16:52:12     [unzip] Expanding: /var/lib/jenkins/workspace/GovWay/dist/openspcoop2_pdd-test-3.3.14.jar into /var/lib/jenkins/workspace/GovWay/core/mvn/sql/build_testunits
16:52:12    [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite-result/pdd-sql
16:52:12      [echo] Avvio TestSuite (gruppo: pdd.sql) (haltOnFailure:true)
16:52:12 [jacoco:coverage] Enhancing testng with coverage
16:52:15    [testng] Run test 'GestoreRepositoryBuste' ...
16:52:15    [testng] LogMessages write in /tmp/runGestoreRepositoryTest_7611907008419989312.log
16:52:16    [testng] URL:jdbc:postgresql://localhost/govway_test
16:52:16    [testng] UserName:govway
16:52:16    [testng] Password:govway
16:52:16    [testng] DriverJDBC:org.postgresql.Driver
16:52:16    [testng] WARNING: An illegal reflective access operation has occurred
16:52:16    [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
16:52:16    [testng] WARNING: Please consider reporting this to the maintainers of org.postgresql.jdbc.TimestampUtils
16:52:16    [testng] WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
16:52:16    [testng] WARNING: All illegal access operations will be denied in a future release
16:52:16    [testng] Creato IGestoreRepository[bytewise] di tipo org.openspcoop2.protocol.engine.driver.repository.GestoreRepositoryBytewise
16:52:16    [testng] createSQLFields: REPOSITORY_ACCESS
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] inserita riga: 1
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0)]
16:52:16    [testng] (test 1. history=false). Trovata entry con valore: 0
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [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)]
16:52:16    [testng] (test 2. history=false and profilo=false). Trovata entry con valore: 0
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [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)]
16:52:16    [testng] (test 3. history=false and profilo=false and pdd=false). Trovata entry con valore: 0
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS | 4)]
16:52:16    [testng] aggiornata riga: 1
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0)]
16:52:16    [testng] (test 4. history=false). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
16:52:16    [testng] (test 5. history=true). Trovata entry con valore: 4
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS | 2)]
16:52:16    [testng] aggiornata riga: 1
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
16:52:16    [testng] (test 6. history=true). Trovata entry con valore: 6
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [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)]
16:52:16    [testng] (test 7. history=true and profilo=true). Trovata entry con valore: 6
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [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)]
16:52:16    [testng] (test 8. history=true or profilo=true). Trovata entry con valore: 6
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS | 1)]
16:52:16    [testng] aggiornata riga: 1
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
16:52:16    [testng] (test 9. history=true). Trovata entry con valore: 7
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [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)]
16:52:16    [testng] (test 10. history=true and profilo=true). Trovata entry con valore: 7
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [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)]
16:52:16    [testng] (test 1. history=true or profilo=true). Trovata entry con valore: 7
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [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)]
16:52:16    [testng] (test 12. history=true and profilo=true and pdd=true). Trovata entry con valore: 7
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [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)]
16:52:16    [testng] (test 13. history=true or profilo=true or pdd=true). Trovata entry con valore: 7
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=4)]
16:52:16    [testng] (test 14. onlyHistory). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=2)]
16:52:16    [testng] (test 15. onlyProfilo). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=1)]
16:52:16    [testng] (test 16. onlyPdd). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3)]
16:52:16    [testng] (test 17. onlyPddAndProfilo). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=0)]
16:52:16    [testng] (test 18. disableAll). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS & 3)]
16:52:16    [testng] aggiornata riga: 1
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
16:52:16    [testng] (test 19. history=true). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [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)]
16:52:16    [testng] (test 20. pdd=true or profilo=true). Trovata entry con valore: 3
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=2)]
16:52:16    [testng] (test 21. onlyProfilo). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=1)]
16:52:16    [testng] (test 22. onlyPdd). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3)]
16:52:16    [testng] (test 23. pddAndProfilo). Trovata entry con valore: 3
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=0)]
16:52:16    [testng] (test 24. disableAll). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS & 6)]
16:52:16    [testng] aggiornata riga: 1
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
16:52:16    [testng] (test 25. history=true). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [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)]
16:52:16    [testng] (test 26. pdd=true or profilo=true). Trovata entry con valore: 2
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=2)]
16:52:16    [testng] (test 27. profilo=true). Trovata entry con valore: 2
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=1)]
16:52:16    [testng] (test 28. onlyPdd). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3)]
16:52:16    [testng] (test 29. pddAndProfilo). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=0)]
16:52:16    [testng] (test 30. disableAll). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS & 5)]
16:52:16    [testng] aggiornata riga: 1
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
16:52:16    [testng] (test 31. history=true). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [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)]
16:52:16    [testng] (test 32. pdd=true or profilo=true). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=2)]
16:52:16    [testng] (test 33. onlyProfilo). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=1)]
16:52:16    [testng] (test 34. onlyPdd). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3)]
16:52:16    [testng] (test 35. pddAndProfilo). Non e' stata trovata correttamente una entry
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=0)]
16:52:16    [testng] (test 36. disableAll). Trovata entry con valore: 0
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] inserita riga: 1
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
16:52:16    [testng] (test 37. history=true). Trovata entry con valore: 4
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] inserita riga: 1
16:52:16    [testng] 
16:52:16    [testng] 
16:52:16    [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0)]
16:52:16    [testng] (test 38. history=false). Trovata entry con valore: 0
16:52:16    [testng] Run test 'GestoreRepositoryBuste' ok
16:52:16    [testng] 
16:52:16    [testng] ===============================================
16:52:16    [testng] Ant suite
16:52:16    [testng] Total tests run: 1, Passes: 1, Failures: 0, Skips: 0
16:52:16    [testng] ===============================================
16:52:16    [testng] 
16:52:17    [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/core/mvn/sql/build_testunits
16:52:17 [INFO] Executed tasks
16:52:17 [INFO] 
16:52:17 [INFO] ------< org.openspcoop2:org.openspcoop2.static_analysis.spotbugs >------
16:52:17 [INFO] Building static_analysis.spotbugs 1.0                            [69/72]
16:52:17 [INFO] --------------------------------[ pom ]---------------------------------
16:52:17 [INFO] 
16:52:17 [INFO] -----< org.openspcoop2:org.openspcoop2.static_analysis.sonarqube >------
16:52:17 [INFO] Building static_analysis.sonarqube 1.0                           [70/72]
16:52:17 [INFO] --------------------------------[ pom ]---------------------------------
16:52:17 [INFO] 
16:52:17 [INFO] --------< org.openspcoop2:org.openspcoop2.dynamic_analysis.zap >--------
16:52:17 [INFO] Building dynamic_analysis.zap 1.0                                [71/72]
16:52:17 [INFO] --------------------------------[ pom ]---------------------------------
16:52:17 [INFO] 
16:52:17 [INFO] ----------< org.openspcoop2:org.openspcoop2.coverage.jacoco >-----------
16:52:17 [INFO] Building coverage.jacoco 1.0                                     [72/72]
16:52:17 [INFO] --------------------------------[ pom ]---------------------------------
16:52:17 [INFO] ------------------------------------------------------------------------
16:52:17 [INFO] Reactor Summary for govway 1.0:
16:52:17 [INFO] 
16:52:17 [INFO] govway ............................................. SUCCESS [  0.003 s]
16:52:17 [INFO] dependencies ....................................... SUCCESS [  0.001 s]
16:52:17 [INFO] dependencies.ant ................................... SUCCESS [  0.953 s]
16:52:17 [INFO] dependencies.antinstaller .......................... SUCCESS [  0.032 s]
16:52:17 [INFO] dependencies.axiom ................................. SUCCESS [  0.020 s]
16:52:17 [INFO] dependencies.bean-validation ....................... SUCCESS [  0.095 s]
16:52:17 [INFO] dependencies.cxf ................................... SUCCESS [  0.217 s]
16:52:17 [INFO] dependencies.commons ............................... SUCCESS [  0.168 s]
16:52:17 [INFO] dependencies.faces ................................. SUCCESS [  0.049 s]
16:52:17 [INFO] dependencies.git ................................... SUCCESS [  0.018 s]
16:52:17 [INFO] dependencies.httpcore .............................. SUCCESS [  0.049 s]
16:52:17 [INFO] dependencies.jackson ............................... SUCCESS [  0.059 s]
16:52:17 [INFO] dependencies.javax ................................. SUCCESS [  0.042 s]
16:52:17 [INFO] dependencies.jax ................................... SUCCESS [  0.110 s]
16:52:17 [INFO] dependencies.jetty ................................. SUCCESS [  0.071 s]
16:52:17 [INFO] dependencies.jminix ................................ SUCCESS [  0.013 s]
16:52:17 [INFO] dependencies.json .................................. SUCCESS [  0.039 s]
16:52:17 [INFO] dependencies.log ................................... SUCCESS [  0.039 s]
16:52:17 [INFO] dependencies.lucene ................................ SUCCESS [  0.017 s]
16:52:17 [INFO] dependencies.swagger ............................... SUCCESS [  0.010 s]
16:52:17 [INFO] dependencies.opensaml .............................. SUCCESS [  0.059 s]
16:52:17 [INFO] dependencies.pdf ................................... SUCCESS [  0.025 s]
16:52:17 [INFO] dependencies.redis ................................. SUCCESS [  0.061 s]
16:52:17 [INFO] dependencies.reports ............................... SUCCESS [  0.037 s]
16:52:17 [INFO] dependencies.saaj .................................. SUCCESS [  0.014 s]
16:52:17 [INFO] dependencies.security .............................. SUCCESS [  0.033 s]
16:52:17 [INFO] dependencies.shared ................................ SUCCESS [  0.132 s]
16:52:17 [INFO] dependencies.soapbox ............................... SUCCESS [  0.013 s]
16:52:17 [INFO] dependencies.spring ................................ SUCCESS [  0.022 s]
16:52:17 [INFO] dependencies.spring-security ....................... SUCCESS [  0.013 s]
16:52:17 [INFO] dependencies.swagger ............................... SUCCESS [  0.040 s]
16:52:17 [INFO] dependencies.swagger-codegen ....................... SUCCESS [  0.120 s]
16:52:17 [INFO] dependencies.swagger-codegen.linkit ................ SUCCESS [  0.157 s]
16:52:17 [INFO] dependencies.wadl .................................. SUCCESS [  0.012 s]
16:52:17 [INFO] dependencies.wss4j ................................. SUCCESS [  0.024 s]
16:52:17 [INFO] dependencies.testsuite ............................. SUCCESS [  0.000 s]
16:52:17 [INFO] dependencies.testsuite.axis14 ...................... SUCCESS [  0.043 s]
16:52:17 [INFO] dependencies.testsuite.as .......................... SUCCESS [  0.000 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly8 ................. SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly9 ................. SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly10 ................ SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly11 ................ SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly12 ................ SUCCESS [  0.012 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly13 ................ SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly14 ................ SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly15 ................ SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly16 ................ SUCCESS [  0.005 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly17 ................ SUCCESS [  0.005 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly18 ................ SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly19 ................ SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly20 ................ SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly21 ................ SUCCESS [  0.005 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly22 ................ SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly23 ................ SUCCESS [  0.004 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly24 ................ SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly25 ................ SUCCESS [  0.005 s]
16:52:17 [INFO] dependencies.testsuite.as.wildfly26 ................ SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.as.tomcat9 .................. SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.test ........................ SUCCESS [  0.048 s]
16:52:17 [INFO] dependencies.testsuite.staticAnalysis .............. SUCCESS [  0.015 s]
16:52:17 [INFO] dependencies.testsuite.dynamicAnalysis ............. SUCCESS [  0.006 s]
16:52:17 [INFO] dependencies.testsuite.coverage .................... SUCCESS [  0.047 s]
16:52:17 [INFO] compile ............................................ SUCCESS [  0.001 s]
16:52:17 [INFO] package ............................................ SUCCESS [  0.001 s]
16:52:17 [INFO] testsuite.utils .................................... SUCCESS [  0.000 s]
16:52:17 [INFO] testsuite.utils.sql ................................ SUCCESS [01:25 min]
16:52:17 [INFO] testsuite.pdd.core ................................. SUCCESS [  0.000 s]
16:52:17 [INFO] testsuite.pdd.core.sql ............................. SUCCESS [  4.616 s]
16:52:17 [INFO] static_analysis.spotbugs ........................... SUCCESS [  0.001 s]
16:52:17 [INFO] static_analysis.sonarqube .......................... SUCCESS [  0.000 s]
16:52:17 [INFO] dynamic_analysis.zap ............................... SUCCESS [  0.000 s]
16:52:17 [INFO] coverage.jacoco .................................... SUCCESS [  0.001 s]
16:52:17 [INFO] ------------------------------------------------------------------------
16:52:17 [INFO] BUILD SUCCESS
16:52:17 [INFO] ------------------------------------------------------------------------
16:52:17 [INFO] Total time:  01:34 min
16:52:17 [INFO] Finished at: 2024-07-15T16:52:17+02:00
16:52:17 [INFO] ------------------------------------------------------------------------
16:52:17 [GovWay] $ /bin/sh -xe /tmp/jenkins359450136434699423.sh
16:52:17 + echo 'Pubblicazione risultati testsuite core ...'
16:52:17 Pubblicazione risultati testsuite core ...
16:52:17 + sudo su -c 'rm -rf /opt/apache-tomcat-9.0.31/webapps/govway-testsuite/core'
16:52:17 + sudo su -c 'mkdir /opt/apache-tomcat-9.0.31/webapps/govway-testsuite/core'
16:52:17 + sudo su -c 'cp -r /var/lib/jenkins/workspace/GovWay/testsuite-result/* /opt/apache-tomcat-9.0.31/webapps/govway-testsuite/core/'
16:52:17 + echo 'Pubblicazione risultati testsuite core effettuata'
16:52:17 Pubblicazione risultati testsuite core effettuata
16:52:17 [Boolean condition] checking [true] against [^(1|y|yes|t|true|on|run)$] (origin token: ${GOVWAY_TEST_INTEGRAZIONE})
16:52:17 Run condition [Boolean condition] enabling perform for step [BuilderChain]
16:52:17 [GovWay] $ /bin/bash /tmp/jenkins3189956147325414739.sh
16:52:17 Fermo application server ...
16:52:17 Stoping Tomcat
16:52:17 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.rmi/sun.rmi.transport=ALL-UNNAMED
16:52:18 Pid Tomcat: 16318 
16:52:18 
16:52:19 waiting for processes to exit
16:52:20 waiting for processes to exit
16:52:21 waiting for processes to exit
16:52:22 waiting for processes to exit
16:52:23 waiting for processes to exit
16:52:24 waiting for processes to exitFermo application server effettuato
16:52:24 Predisposizione datasource ...
16:52:24 Predisposizione datasource effettuata
16:52:24 Predisposizione jars ...
16:52:24 Predisposizione jars effettuata
16:52:24 Preparazione compilazione govwayTestSuite.war ...
16:52:24 Preparazione compilazione govwayTestSuite.war effettuata
16:52:24 [testsuite] $ /var/lib/jenkins/tools/hudson.tasks.Ant_AntInstallation/ant-1.10.6/bin/ant -file build.xml -Das=tomcat9 clean build
16:52:24 Buildfile: /var/lib/jenkins/workspace/GovWay/testsuite/build.xml
16:52:25 
16:52:25 check_as_version:
16:52:25 
16:52:25 clean_testsuite:
16:52:25    [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite
16:52:25    [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/build
16:52:25    [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/dist
16:52:25    [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/doc
16:52:25 
16:52:25 clean:
16:52:25 
16:52:25 init_compile_testsuite:
16:52:25     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite
16:52:25     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/tmp
16:52:25     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/dist
16:52:25 
16:52:25 compile_govway_testsuite:
16:52:25 
16:52:25 checkgit:
16:52:27 
16:52:27 init_compile-build:
16:52:27     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/compile-jar-openspcoop2
16:52:27 
16:52:27 compile_src_openspcoop2:
16:52:27      [echo] Java home: /opt/openjdk-11.0.12_7/
16:52:27      [echo] ****************************************
16:52:27      [echo] ****         DEBUG MODE ON         *****
16:52:27      [echo] ****************************************
16:52:27      [echo] Raccolta informazioni git per inserimento in manifest...
16:52:27      [echo] compileSRC[/var/lib/jenkins/workspace/GovWay/testsuite/src]
16:52:27     [javac] Compiling 78 source files to /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/compile-jar-openspcoop2
16:52:35       [jar] Building jar: /var/lib/jenkins/workspace/GovWay/testsuite/dist/openspcoop2_testsuite-lib_BUILD-001f0937.jar
16:52:35    [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/compile-jar-openspcoop2
16:52:35     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/doc
16:52:35 
16:52:35 compile_api_openspcoop2:
16:52:36 
16:52:36 init_compile-api:
16:52:36     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/doc/api
16:52:36     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/doc/api/testsuite-lib
16:52:36      [echo] WARN: Java8 -Xdoclint:none
16:52:36      [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
16:52:36   [javadoc] Generating Javadoc
16:52:36   [javadoc] Javadoc execution
16:52:38   [javadoc] Loading source files for package org.openspcoop2.testsuite.axis14...
16:52:38   [javadoc] Loading source files for package org.openspcoop2.testsuite.clients...
16:52:38   [javadoc] Loading source files for package org.openspcoop2.testsuite.core...
16:52:38   [javadoc] Loading source files for package org.openspcoop2.testsuite.core.asincrono...
16:52:38   [javadoc] Loading source files for package org.openspcoop2.testsuite.db...
16:52:38   [javadoc] Loading source files for package org.openspcoop2.testsuite.server...
16:52:38   [javadoc] Loading source files for package org.openspcoop2.testsuite.units...
16:52:38   [javadoc] Loading source files for package org.openspcoop2.testsuite.units.utils...
16:52:38   [javadoc] Loading source files for package org.openspcoop2.testsuite.wssecurity...
16:52:39   [javadoc] Constructing Javadoc information...
16:52:42   [javadoc] Standard Doclet version 11.0.12
16:52:42   [javadoc] Building tree for all the packages and classes...
16:52:44   [javadoc] Building index for all the packages and classes...
16:52:45   [javadoc] Building index for all classes...
16:52:45   [javadoc] Building index for all classes...
16:52:45      [echo] Raccolta informazioni git per inserimento in manifest...
16:52:45       [jar] Building jar: /var/lib/jenkins/workspace/GovWay/testsuite/doc/api/openspcoop2_testsuite-lib_BUILD-001f0937-javadoc.jar
16:52:45 
16:52:45 compile_testsuite:
16:52:45 
16:52:45 war_govway_testsuite:
16:52:45      [copy] Copying 1 file to /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/tmp
16:52:45 
16:52:45 set_property:
16:52:46 
16:52:46 set_property:
16:52:46 
16:52:46 set_property:
16:52:46 
16:52:46 set_property:
16:52:46      [copy] Copying 1 file to /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/tmp
16:52:46       [war] Building war: /var/lib/jenkins/workspace/GovWay/testsuite/dist/govwayTestSuite.war
16:52:49    [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/tmp
16:52:49 
16:52:49 build_testsuite:
16:52:49 
16:52:49 build:
16:52:49 
16:52:49 BUILD SUCCESSFUL
16:52:49 Total time: 24 seconds
16:52:49 [GovWay] $ /bin/sh -xe /tmp/jenkins15372666079052845354.sh
16:52:49 + echo 'Predisposizione jar di protocolli in govwayTestSuite.war ...'
16:52:49 Predisposizione jar di protocolli in govwayTestSuite.war ...
16:52:49 + sudo su -c 'rm -rf /tmp/govwayTestSuite.war.tmp'
16:52:49 + sudo su -c 'rm -f /tmp/govwayTestSuite.war'
16:52:49 + sudo su -c 'unzip -q /var/lib/jenkins/workspace/GovWay/testsuite/dist/govwayTestSuite.war -d /tmp/govwayTestSuite.war.tmp'
16:52:50 + sudo su -c 'cp /var/lib/jenkins/workspace/GovWay/protocolli/spcoop/dist/openspcoop2_spcoop-protocol*.jar /tmp/govwayTestSuite.war.tmp/WEB-INF/lib/'
16:52:50 + sudo su -c 'cp /var/lib/jenkins/workspace/GovWay/protocolli/trasparente/dist/openspcoop2_trasparente-protocol*.jar /tmp/govwayTestSuite.war.tmp/WEB-INF/lib/'
16:52:50 + sudo su -c 'rm -f /tmp/govwayTestSuite.war.tmp/WEB-INF/lib/openspcoop2_utils-test*.jar'
16:52:50 + sudo su -c 'rm -f /tmp/govwayTestSuite.war.tmp/WEB-INF/lib/openspcoop2_pdd-test*.jar'
16:52:50 + sudo su -c 'pushd /tmp/govwayTestSuite.war.tmp/; zip -rq /tmp/govwayTestSuite.war *; popd'
16:52:50 /tmp/govwayTestSuite.war.tmp /var/lib/jenkins/workspace/GovWay
16:52:52 /var/lib/jenkins/workspace/GovWay
16:52:52 + echo 'Predisposizione jar di protocolli in govwayTestSuite.war effettuata'
16:52:52 Predisposizione jar di protocolli in govwayTestSuite.war effettuata
16:52:52 + echo 'Predispongo govwayTestSuite.war su Tomcat ...'
16:52:52 Predispongo govwayTestSuite.war su Tomcat ...
16:52:52 + sudo su -c 'rm -rf /opt/apache-tomcat-9.0.31/webapps/govwayTestSuite.war'
16:52:52 + sudo su -c 'rm -rf /opt/apache-tomcat-9.0.31/webapps/govwayTestSuite'
16:52:52 + sudo su -c 'cp /tmp/govwayTestSuite.war /opt/apache-tomcat-9.0.31/webapps/'
16:52:53 + sudo su -c 'chown -R tomcat.tomcat /opt/apache-tomcat-9.0.31/webapps/govwayTestSuite.war'
16:52:53 + sudo su -c 'rm -rf /tmp/govwayTestSuite.war.tmp'
16:52:53 + sudo su -c 'rm -f /tmp/govwayTestSuite.war'
16:52:53 + echo 'Predispongo govwayTestSuite.war su Tomcat ok'
16:52:53 Predispongo govwayTestSuite.war su Tomcat ok
16:52:53 + echo 'Predispongo govwayTestSuite come libreria per i test ...'
16:52:53 Predispongo govwayTestSuite come libreria per i test ...
16:52:53 + cd /var/lib/jenkins/workspace/GovWay/testsuite
16:52:53 + sed -i -e s#/var/govway/log#/var/log/govway_testsuite#g deploy/properties_xml2Backend/xml2backend.log4j2.properties
16:52:53 + sed -i -e s#/var/govway/log#/var/log/govway_testsuite#g deploy/properties/log4j2.properties
16:52:53 + sed -i -e s#/var/govway/log#/var/log/govway_testsuite#g deploy/properties/testsuite.log4j2.properties
16:52:53 + echo 'Predispongo govwayTestSuite come libreria per i test ok'
16:52:53 Predispongo govwayTestSuite come libreria per i test ok
16:52:53 + echo 'Predispongo tempi alti di generazione delle statistiche per i test ...'
16:52:53 Predispongo tempi alti di generazione delle statistiche per i test ...
16:52:53 + sudo su -c 'echo '\''org.openspcoop2.pdd.statistiche.generazione.baseOraria.timer.intervalloSecondi=36000'\'' >> /etc/govway/govway_local.properties'
16:52:53 + sudo su -c 'echo '\''org.openspcoop2.pdd.statistiche.generazione.baseGiornaliera.timer.intervalloSecondi=36000'\'' >> /etc/govway/govway_local.properties'
16:52:53 + sudo su -c 'echo '\''org.openspcoop2.pdd.statistiche.generazione.baseSettimanale.timer.intervalloSecondi=36000'\'' >> /etc/govway/govway_local.properties'
16:52:53 + sudo su -c 'echo '\''org.openspcoop2.pdd.statistiche.generazione.baseMensile.timer.intervalloSecondi=36000'\'' >> /etc/govway/govway_local.properties'
16:52:53 + echo 'Predispongo tempi alti di generazione delle statistiche per i test ok'
16:52:53 Predispongo tempi alti di generazione delle statistiche per i test ok
16:52:53 [Boolean condition] checking [true] against [^(1|y|yes|t|true|on|run)$] (origin token: ${GOVWAY_TEST_INTEGRAZIONE_BYOK})
16:52:53 Run condition [Boolean condition] enabling perform for step [BuilderChain]
16:52:53 [GovWay] $ /bin/bash /tmp/jenkins16547407041358128074.sh
16:52:53 Fermo application server ...
16:52:53 Tomcat is not running
16:52:53 Fermo application server effettuato
16:52:53 Predispongo Testsuite per byok ...
16:52:53 - properties
16:52:54 - predispongo ambiente di test
16:52:54 - jks jose ...
16:52:54 - jks ...
16:52:54 - jks (xca) ...
16:52:54 - jwk ...
16:52:54 - jwk (truststore) ...
16:52:54 - jwk testPrivate/Public ...
16:52:54 - tool govway-vault-cli
16:52:54 sed: couldn't open temporary file /etc/govway/govway-vault-cli/sed1pUxuv: Permission denied
16:52:54 sed: couldn't open temporary file /etc/govway/govway-vault-cli/sedI9OQBv: Permission denied
16:52:54 sed: couldn't open temporary file /etc/govway/govway-vault-cli/sed5leSwv: Permission denied
16:52:55 - tool config-loader
16:52:55 sed: couldn't open temporary file /etc/govway/govway-config-loader/sedZFKedv: Permission denied
16:52:55 sed: couldn't open temporary file /etc/govway/govway-config-loader/sedbDWX6u: Permission denied
16:52:55 sed: couldn't open temporary file /etc/govway/govway-config-loader/sed1RSKiv: Permission denied
16:52:55 sed: couldn't open temporary file /etc/govway/govway-config-loader/properties/sedkmCziu: Permission denied
16:52:55 sed: couldn't open temporary file /etc/govway/govway-config-loader/properties/sedTiE2fu: Permission denied
16:52:55 - init db per proprieta' cifrate
16:52:55 DELETE 0
16:52:55 INSERT 0 1
16:52:55 - predispongo pacchetto testService
16:52:55 [testService] $ /var/lib/jenkins/tools/hudson.tasks.Ant_AntInstallation/ant-1.10.6/bin/ant -file build.xml -Das=tomcat9 clean build
16:52:55 Buildfile: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build.xml
16:52:56 
16:52:56 check_as_version:
16:52:56 
16:52:56 clean:
16:52:56    [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build
16:52:56    [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/dist
16:52:56 
16:52:56 init_compile:
16:52:56     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build
16:52:56     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/dist
16:52:56 
16:52:56 compile:
16:52:56     [javac] Compiling 5 source files to /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build
16:53:00 
16:53:00 build:
16:53:00     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build/example
16:53:00       [war] Building war: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/dist/TestService.war
16:53:01    [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build/example
16:53:01 
16:53:01 BUILD SUCCESSFUL
16:53:01 Total time: 6 seconds
16:53:01 [testsuite] $ /var/lib/jenkins/tools/hudson.tasks.Ant_AntInstallation/ant-1.10.6/bin/ant -file build.xml clean build
16:53:02 Buildfile: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build.xml
16:53:02 
16:53:02 clean:
16:53:02 
16:53:02 clean:
16:53:02 
16:53:02 init:
16:53:02     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
16:53:02 
16:53:02 build:
16:53:02     [javac] Compiling 8 source files to /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
16:53:06      [copy] Copying 9 files to /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
16:53:06      [copy] Copied 3 empty directories to 2 empty directories under /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
16:53:06 
16:53:06 BUILD SUCCESSFUL
16:53:06 Total time: 3 seconds
16:53:06 [GovWay] $ /bin/bash /tmp/jenkins5098848143629914956.sh
16:53:06 Predispongo TestService.war ...
16:53:06 Predispongo TestService.war ok
16:53:06 Predispongo testsuite BYOK ...
16:53:06 Predispongo testsuite BYOK ok
16:53:06 Riavvio application server ...
16:53:06 Starting tomcat
16:53:06 Tomcat started.
16:53:06 Tomcat is running with pid: 26068
16:53:06 
16:53:06 Attendo che GovWay sia completamente riavviato (timeout 120sec)
16:53:06 .
16:53:07 .
16:53:08 .
16:54:30 .
16:54:31 .
16:54:32 .
16:54:33 .
16:54:35 GovWay è tornato operativo
16:54:35 Attendo 15 secondi prima di aggiornare certificati HSM ...
16:54:50 [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
16:54:50 Buildfile: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build.xml
16:54:51 
16:54:51 run_test:
16:54:51     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/risultati-testsuite
16:54:51     [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/log
16:54:51      [echo] Caricamento configurazione in corso (delete) ...
16:55:14      [echo] Caricamento configurazione in corso (create) ...
22:44:53 Build was aborted
22:44:53 Aborted by Andrea Poli
22:44:53 INFO: Processing JUnit
22:44:53 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'.
22:44:53 ERROR: Step ‘Publish xUnit test result report’ failed: Test reports were found but not all of them are new. Did all the tests run?
22:44:53   * /var/lib/jenkins/workspace/GovWay/tools/rs/config/server/testsuite/risultati-testsuite/TEST-org.openspcoop2.core.config.rs.testsuite.ApiConfigTestSuite.xml is 4 days 13 hr old
22:44:53   * /var/lib/jenkins/workspace/GovWay/tools/rs/monitor/server/testsuite/risultati-testsuite/TEST-org.openspcoop2.core.monitor.rs.testsuite.ApiMonitorTestSuite.xml is 4 days 11 hr old
22:44:53 
22:44:53 Build Aborted. Not looking for any TestNG results.
22:44:53 Collecting Dependency-Check artifact
22:44:53 Parsing file /var/lib/jenkins/workspace/GovWay/dependency-check-result/dependency-check-report.xml
22:44:54 ERROR: Unable to parse /var/lib/jenkins/workspace/GovWay/dependency-check-result/dependency-check-report.xml
22:44:54 [SpotBugsZed Attack Proxy (ZAP)] Skipping execution of recorder since overall result is 'ABORTED'
22:44:54 Started calculate disk usage of build
22:44:54 Finished Calculation of disk usage of build in 0 seconds
22:44:54 Started calculate disk usage of workspace
22:44:54 Finished Calculation of disk usage of workspace in 0 seconds
22:44:54 Finished: ABORTED