Skipping 14,595 KB..
Full Log[INFO] [testng] riga[0]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.058)
20:06:39 [INFO] [testng] riga[1]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[2]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[3]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[4]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[5]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[6]= [DayOfWeekCondition] (secondColonna:38.058) (secondColonnaTabella:38.058)
20:06:39 [INFO] [testng] riga[7]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[8]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[9]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[10]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[11]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.060)
20:06:39 [INFO] [testng] riga[12]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[13]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[14]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[15]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[16]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[17]= [DayOfWeekCondition] (secondColonna:38.060686) (secondColonnaTabella:38.060686)
20:06:39 [INFO] [testng] riga[18]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[19]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[20]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[21]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[22]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.061)
20:06:39 [INFO] [testng] riga[23]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[24]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[25]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[26]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[27]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[28]= [DayOfWeekCondition] (secondColonna:38.061) (secondColonnaTabella:38.061)
20:06:39 [INFO] [testng] riga[29]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[30]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[31]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[32]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[33]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.062)
20:06:39 [INFO] [testng] riga[34]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[35]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[36]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[37]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[38]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[39]= [DayOfWeekCondition] (secondColonna:38.062999) (secondColonnaTabella:38.062999)
20:06:39 [INFO] [testng] riga[40]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[41]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[42]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[43]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[44]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.064)
20:06:39 [INFO] [testng] riga[45]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[46]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[47]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[48]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[49]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[50]= [DayOfWeekCondition] (secondColonna:38.064) (secondColonnaTabella:38.064)
20:06:39 [INFO] [testng] riga[51]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[52]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[53]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[54]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[55]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.065)
20:06:39 [INFO] [testng] riga[56]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[57]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[58]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[59]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[60]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[61]= [DayOfWeekCondition] (secondColonna:38.065375) (secondColonnaTabella:38.065375)
20:06:39 [INFO] [testng] riga[62]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[63]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[64]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[65]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[66]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.066)
20:06:39 [INFO] [testng] riga[67]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[68]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[69]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[70]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[71]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[72]= [DayOfWeekCondition] (secondColonna:38.066) (secondColonnaTabella:38.066)
20:06:39 [INFO] [testng] riga[73]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[74]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[75]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[76]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[77]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.067)
20:06:39 [INFO] [testng] riga[78]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[79]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[80]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[81]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[82]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[83]= [DayOfWeekCondition] (secondColonna:38.067666) (secondColonnaTabella:38.067666)
20:06:39 [INFO] [testng] riga[84]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[85]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[86]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[87]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[88]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.068)
20:06:39 [INFO] [testng] riga[89]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[90]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[91]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[92]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[93]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[94]= [DayOfWeekCondition] (secondColonna:38.068) (secondColonnaTabella:38.068)
20:06:39 [INFO] [testng] riga[95]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[96]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[97]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[98]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[99]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.069)
20:06:39 [INFO] [testng] riga[100]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[101]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[102]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[103]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[104]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[105]= [DayOfWeekCondition] (secondColonna:38.069756) (secondColonnaTabella:38.069756)
20:06:39 [INFO] [testng] riga[106]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[107]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[108]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[109]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[110]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.071)
20:06:39 [INFO] [testng] riga[111]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[112]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[113]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[114]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[115]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[116]= [DayOfWeekCondition] (secondColonna:38.071) (secondColonnaTabella:38.071)
20:06:39 [INFO] [testng] riga[117]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[118]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[119]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[120]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[121]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.072)
20:06:39 [INFO] [testng] riga[122]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[123]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[124]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[125]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[126]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[127]= [DayOfWeekCondition] (secondColonna:38.072) (secondColonnaTabella:38.072)
20:06:39 [INFO] [testng] riga[128]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[129]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[130]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[131]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[132]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.072)
20:06:39 [INFO] [testng] riga[133]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[134]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[135]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[136]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[137]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[138]= [DayOfWeekCondition] (secondColonna:38.072023) (secondColonnaTabella:38.072023)
20:06:39 [INFO] [testng] riga[139]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[140]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[141]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[142]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[143]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.074)
20:06:39 [INFO] [testng] riga[144]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[145]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[146]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[147]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[148]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[149]= [DayOfWeekCondition] (secondColonna:38.074141) (secondColonnaTabella:38.074141)
20:06:39 [INFO] [testng] riga[150]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[151]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[152]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[153]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[154]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.075)
20:06:39 [INFO] [testng] riga[155]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[156]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[157]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[158]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[159]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[160]= [DayOfWeekCondition] (secondColonna:38.075) (secondColonnaTabella:38.075)
20:06:39 [INFO] [testng] riga[161]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[162]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[163]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[164]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[165]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.076)
20:06:39 [INFO] [testng] riga[166]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[167]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[168]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[169]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[170]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[171]= [DayOfWeekCondition] (secondColonna:38.076) (secondColonnaTabella:38.076)
20:06:39 [INFO] [testng] riga[172]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[173]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[174]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[175]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[176]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.076)
20:06:39 [INFO] [testng] riga[177]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[178]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[179]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[180]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[181]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[182]= [DayOfWeekCondition] (secondColonna:38.076132) (secondColonnaTabella:38.076132)
20:06:39 [INFO] [testng] riga[183]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[184]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[185]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[186]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[187]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.077)
20:06:39 [INFO] [testng] riga[188]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[189]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[190]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[191]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[192]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[193]= [DayOfWeekCondition] (secondColonna:38.077912) (secondColonnaTabella:38.077912)
20:06:39 [INFO] [testng] riga[194]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[195]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[196]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[197]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[198]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.078)
20:06:39 [INFO] [testng] riga[199]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[200]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[201]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[202]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[203]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[204]= [DayOfWeekCondition] (secondColonna:38.078) (secondColonnaTabella:38.078)
20:06:39 [INFO] [testng] riga[205]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[206]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[207]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[208]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[209]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.080)
20:06:39 [INFO] [testng] riga[210]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[211]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[212]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[213]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[214]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[215]= [DayOfWeekCondition] (secondColonna:38.080017) (secondColonnaTabella:38.080017)
20:06:39 [INFO] [testng] riga[216]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[217]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[218]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[219]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng] riga[220]= [DayOfWeekCondition] (data:2025-01-08 20:06:38.081)
20:06:39 [INFO] [testng] riga[221]= [DayOfWeekCondition] (yearColonna:2025) (yearColonnaTabella:2025)
20:06:39 [INFO] [testng] riga[222]= [DayOfWeekCondition] (monthColonna:1) (monthColonnaTabella:1)
20:06:39 [INFO] [testng] riga[223]= [DayOfWeekCondition] (dayColonna:8) (dayColonnaTabella:8)
20:06:39 [INFO] [testng] riga[224]= [DayOfWeekCondition] (hourColonna:20) (hourColonnaTabella:20)
20:06:39 [INFO] [testng] riga[225]= [DayOfWeekCondition] (minuteColonna:6) (minuteColonnaTabella:6)
20:06:39 [INFO] [testng] riga[226]= [DayOfWeekCondition] (secondColonna:38.081) (secondColonnaTabella:38.081)
20:06:39 [INFO] [testng] riga[227]= [DayOfWeekCondition] (fullDayNameColonna:WEDNESDAY) (fullDayNameColonnaTabella:WEDNESDAY)
20:06:39 [INFO] [testng] riga[228]= [DayOfWeekCondition] (shortDayNameColonna:WED) (shortDayNameColonnaTabella:WED)
20:06:39 [INFO] [testng] riga[229]= [DayOfWeekCondition] (dayOfYearColonna:008) (dayOfYearColonnaTabella:008)
20:06:39 [INFO] [testng] riga[230]= [DayOfWeekCondition] (dayOfWeekColonna:4) (dayOfWeekColonnaTabella:4)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] test0_engine:
20:06:39 [INFO] [testng] SELECT timestamp '2025-01-08 20:06:39.645' 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
20:06:39 [INFO] [testng] riga[0]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[2]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[4]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[6]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[8]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[10]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[12]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[14]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[16]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[18]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[20]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[22]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[24]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[26]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[28]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[30]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[32]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[34]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[36]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[38]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[40]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] test0_engine:
20:06:39 [INFO] [testng] SELECT timestamp '2025-01-08 20:06:39.645' 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 '2025-01-08 20:06:39.645'=? ) AND ( timestamp '2022-01-01 12:34:56.789'<? ) AND ( timestamp '2092-10-31 17:34:56.789'>? )
20:06:39 [INFO] [testng] riga[0]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[2]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[4]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[6]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[8]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[10]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[12]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[14]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[16]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[18]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[20]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[22]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[24]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[26]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[28]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[30]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[32]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[34]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[36]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[38]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] riga[40]= (now:2025-01-08 20:06:39.645) (past:2022-01-01 12:34:56.789) (future:2092-10-31 17:34:56.789)
20:06:39 [INFO] [testng] (test0_engine) [postgresql] getFieldsName: [cont, avgMedio, mittente, ALIASDEST]
20:06:39 [INFO] [testng] (test0_engine) [postgresql] getTablesName: [tracce, aliasMSG]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] test0_engine:
20:06:39 [INFO] [testng] SELECT DISTINCT count(DISTINCT aliasMSG.id) as cont,avg(aliasMSG.id) as avgMedio,aliasMSG.mittente,aliasMSG.destinatario as ALIASDEST FROM tracce,msgdiagnostici as aliasMSG WHERE ( tracce.tipo_mittente is not null ) GROUP BY aliasMSG.mittente,aliasMSG.destinatario ORDER BY cont DESC ,avgMedio ASC ,mittente ASC ,ALIASDEST DESC
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0->SoggettoDestinatario0) (count:2)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente1->SoggettoDestinatario1) (count:2)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente2->SoggettoDestinatario2) (count:2)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente3->SoggettoDestinatario3) (count:2)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente4->SoggettoDestinatario4) (count:2)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente5->SoggettoDestinatario5) (count:2)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente6->SoggettoDestinatario6) (count:2)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente7->SoggettoDestinatario7) (count:2)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente8->SoggettoDestinatario8) (count:2)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente9->SoggettoDestinatario9) (count:2)
20:06:39 [INFO] [testng] riga[10]= (SoggettoMittente10->SoggettoDestinatario10) (count:1)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] a. ** Query normale
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(false) [postgresql] [QueryNormale]:
20:06:39 [INFO] [testng] SELECT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC FOR UPDATE
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
20:06:39 [INFO] [testng] riga[10]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
20:06:39 [INFO] [testng] riga[11]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
20:06:39 [INFO] [testng] riga[12]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
20:06:39 [INFO] [testng] riga[13]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
20:06:39 [INFO] [testng] riga[14]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
20:06:39 [INFO] [testng] riga[15]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
20:06:39 [INFO] [testng] riga[16]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
20:06:39 [INFO] [testng] riga[17]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
20:06:39 [INFO] [testng] riga[18]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
20:06:39 [INFO] [testng] riga[19]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
20:06:39 [INFO] [testng] riga[20]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] b. ** Query con limit/offset
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(false) [postgresql] [QueryLimitOffset]:
20:06:39 [INFO] [testng] SELECT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC LIMIT 10 OFFSET 0
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] b. ** Query con limit/offset (unixTimestamp)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(false) [postgresql] [QueryLimitOffset]:
20:06:39 [INFO] [testng] SELECT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente,gdo2,gdo,(date_part('epoch',( gdo2 - gdo ))*1000) as latenza FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC ,(date_part('epoch',( gdo2 - gdo ))*1000) ASC LIMIT 10 OFFSET 0
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)(45)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)(10371800101)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)(91)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)(31104600303)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)(217732202121)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)(137)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)(51844600505)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)(183)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)(72581000707)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)(229)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] c. ** Query con limit
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(false) [postgresql] [QueryLimit]:
20:06:39 [INFO] [testng] SELECT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC LIMIT 10
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] d. ** Query con offset
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(false) [postgresql] [QueryOffset]:
20:06:39 [INFO] [testng] SELECT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC OFFSET 2
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
20:06:39 [INFO] [testng] riga[10]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
20:06:39 [INFO] [testng] riga[11]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
20:06:39 [INFO] [testng] riga[12]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
20:06:39 [INFO] [testng] riga[13]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
20:06:39 [INFO] [testng] riga[14]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
20:06:39 [INFO] [testng] riga[15]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
20:06:39 [INFO] [testng] riga[16]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
20:06:39 [INFO] [testng] riga[17]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
20:06:39 [INFO] [testng] riga[18]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] e. ** Query groupBy
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(false) [postgresql] [GroupBy]:
20:06:39 [INFO] [testng] SELECT count(DISTINCT id) as cont,mittente,tracce.tipo_destinatario as TIPODEST,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,tracce.tipo_destinatario,tracce.destinatario ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0) = 2
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente1) = 2
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente10) = 1
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente2) = 2
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente3) = 2
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente4) = 2
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente5) = 2
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente6) = 2
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente7) = 2
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente8) = 2
20:06:39 [INFO] [testng] riga[10]= (SoggettoMittente9) = 2
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] f. ** Query groupBy con limit/offset
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(false) [postgresql] [GroupByLimitOffset]:
20:06:39 [INFO] [testng] SELECT count(DISTINCT id) as cont,mittente,tracce.tipo_destinatario as TIPODEST,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,tracce.tipo_destinatario,tracce.destinatario ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC LIMIT 5 OFFSET 1
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente1) = 2
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente10) = 1
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente2) = 2
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente3) = 2
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente4) = 2
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] g. ** Query con select*
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(false) [postgresql] [QuerySelect*]:
20:06:39 [INFO] [testng] SELECT * FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,tipo_destinatario ASC ,tracce.destinatario DESC FOR UPDATE
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente0)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente1)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente1)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente10)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente2)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente2)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente3)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente3)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente4)
20:06:39 [INFO] [testng] riga[10]= (SoggettoMittente4)
20:06:39 [INFO] [testng] riga[11]= (SoggettoMittente5)
20:06:39 [INFO] [testng] riga[12]= (SoggettoMittente5)
20:06:39 [INFO] [testng] riga[13]= (SoggettoMittente6)
20:06:39 [INFO] [testng] riga[14]= (SoggettoMittente6)
20:06:39 [INFO] [testng] riga[15]= (SoggettoMittente7)
20:06:39 [INFO] [testng] riga[16]= (SoggettoMittente7)
20:06:39 [INFO] [testng] riga[17]= (SoggettoMittente8)
20:06:39 [INFO] [testng] riga[18]= (SoggettoMittente8)
20:06:39 [INFO] [testng] riga[19]= (SoggettoMittente9)
20:06:39 [INFO] [testng] riga[20]= (SoggettoMittente9)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] h. ** Query con select* e offset/limit
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(false) [postgresql] [QuerySelect*LimitOffset*]:
20:06:39 [INFO] [testng] SELECT * FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,tipo_destinatario ASC ,tracce.destinatario DESC LIMIT 10 OFFSET 0
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente0)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente1)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente1)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente10)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente2)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente2)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente3)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente3)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente4)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] i. ** Query con select* e offset/limit e alias
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(false) [postgresql] [QuerySelect*LimitOffsetAlias*]:
20:06:39 [INFO] [testng] SELECT * FROM tracce as tr WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,tipo_destinatario ASC ,tr.destinatario DESC LIMIT 10 OFFSET 0
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente0)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente1)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente1)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente10)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente2)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente2)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente3)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente3)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente4)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] a. ** Query normale
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(true) [postgresql] [QueryNormale]:
20:06:39 [INFO] [testng] SELECT DISTINCT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
20:06:39 [INFO] [testng] riga[10]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] b. ** Query con limit/offset
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(true) [postgresql] [QueryLimitOffset]:
20:06:39 [INFO] [testng] SELECT DISTINCT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC LIMIT 10 OFFSET 0
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] b. ** Query con limit/offset (unixTimestamp)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(true) [postgresql] [QueryLimitOffset]:
20:06:39 [INFO] [testng] SELECT DISTINCT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente,gdo2,gdo,(date_part('epoch',( gdo2 - gdo ))*1000) as latenza FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC ,(date_part('epoch',( gdo2 - gdo ))*1000) ASC LIMIT 10 OFFSET 0
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)(45)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)(10371800101)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)(91)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)(31104600303)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)(217732202121)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)(137)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)(51844600505)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)(183)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)(72581000707)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)(229)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] c. ** Query con limit
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(true) [postgresql] [QueryLimit]:
20:06:39 [INFO] [testng] SELECT DISTINCT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC LIMIT 10
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0)(SPC)(SoggettoDestinatario0)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente1)(SPC)(SoggettoDestinatario1)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] d. ** Query con offset
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(true) [postgresql] [QueryOffset]:
20:06:39 [INFO] [testng] SELECT DISTINCT tracce.tipo_destinatario as TIPODEST,tracce.destinatario,mittente FROM tracce WHERE ( tipo_mittente is not null ) ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC OFFSET 2
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente10)(SPC)(SoggettoDestinatario10)
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente2)(SPC)(SoggettoDestinatario2)
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente3)(SPC)(SoggettoDestinatario3)
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente4)(SPC)(SoggettoDestinatario4)
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente5)(SPC)(SoggettoDestinatario5)
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente6)(SPC)(SoggettoDestinatario6)
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente7)(SPC)(SoggettoDestinatario7)
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente8)(SPC)(SoggettoDestinatario8)
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente9)(SPC)(SoggettoDestinatario9)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] e. ** Query groupBy
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(true) [postgresql] [GroupBy]:
20:06:39 [INFO] [testng] SELECT DISTINCT count(DISTINCT id) as cont,mittente,tracce.tipo_destinatario as TIPODEST,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,tracce.tipo_destinatario,tracce.destinatario ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0) = 2
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente1) = 2
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente10) = 1
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente2) = 2
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente3) = 2
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente4) = 2
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente5) = 2
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente6) = 2
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente7) = 2
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente8) = 2
20:06:39 [INFO] [testng] riga[10]= (SoggettoMittente9) = 2
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] f. ** Query groupBy con limit/offset
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test1(true) [postgresql] [GroupByLimitOffset]:
20:06:39 [INFO] [testng] SELECT DISTINCT count(DISTINCT id) as cont,mittente,tracce.tipo_destinatario as TIPODEST,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,tracce.tipo_destinatario,tracce.destinatario ORDER BY mittente ASC ,TIPODEST DESC ,tracce.destinatario DESC LIMIT 5 OFFSET 1
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente1) = 2
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente10) = 1
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente2) = 2
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente3) = 2
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente4) = 2
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] g. ** Query con select*
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] h. ** Query con select* e offset/limit
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] i. ** Query con select* e offset/limit e alias
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] a. ** Query Union (unionCount:false unionAll:true)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [Normale UnionAll]:
20:06:39 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente0):[2]
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente10):[1]
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente10):[1]
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente2):[2]
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente2):[2]
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente3):[2]
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente3):[2]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] b. ** Query Union OffSetLimit (unionCount:false unionAll:true)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [OffSetLimit UnionAll]:
20:06:39 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC LIMIT 6 OFFSET 2
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente10):[1]
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente10):[1]
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente2):[2]
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente2):[2]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] c. ** Query Union OffSet (unionCount:false unionAll:true)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [OffSet UnionAll]:
20:06:39 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC OFFSET 2
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente10):[1]
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente10):[1]
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente2):[2]
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente2):[2]
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente3):[2]
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente3):[2]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] d. ** Query Union Limit (unionCount:false unionAll:true)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [OffSet UnionAll]:
20:06:39 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC LIMIT 4
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente0):[2]
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] e. ** Query Union con select* (unionCount:false unionAll:true)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [Normale UnionAll]:
20:06:39 [INFO] [testng] SELECT * FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente0):[2]
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente10):[1]
20:06:39 [INFO] [testng] riga[5]= (SoggettoMittente10):[1]
20:06:39 [INFO] [testng] riga[6]= (SoggettoMittente2):[2]
20:06:39 [INFO] [testng] riga[7]= (SoggettoMittente2):[2]
20:06:39 [INFO] [testng] riga[8]= (SoggettoMittente3):[2]
20:06:39 [INFO] [testng] riga[9]= (SoggettoMittente3):[2]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] f. ** Query Union con select* e LimitOffset (unionCount:false unionAll:true)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] g. ** Query Union con select* e Offset (unionCount:false unionAll:true)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] h. ** Query Union con select* e Limit (unionCount:false unionAll:true)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] i. ** Query Union per test SelectForUpdate (unionCount:false unionAll:true)
20:06:39 [INFO] [testng] ERRORE ATTESO: Parametro SqlQueryObject[0] non valido: Utilizzo dell'opzione 'FOR UPDATE' non permesso con il comando UNION
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] a. ** Query Union (unionCount:true unionAll:true)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:true unionAll:true) [postgresql] [Normale UnionAll]:
20:06:39 [INFO] [testng] SELECT count(*) as aliasUnion FROM ( SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ) as subquery2
20:06:39 [INFO] [testng] riga[0]= [10]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] e. ** Query Union con select* (unionCount:true unionAll:true)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:true unionAll:true) [postgresql] [Normale UnionAll]:
20:06:39 [INFO] [testng] SELECT count(*) as aliasUnion FROM ( SELECT * FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ) as subquery2
20:06:39 [INFO] [testng] riga[0]= [10]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] i. ** Query Union per test SelectForUpdate (unionCount:true unionAll:true)
20:06:39 [INFO] [testng] ERRORE ATTESO: Parametro SqlQueryObject[0] non valido: Utilizzo dell'opzione 'FOR UPDATE' non permesso con il comando UNION
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] a. ** Query Union (unionCount:false unionAll:false)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [Normale UnionAll]:
20:06:39 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente10):[1]
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente2):[2]
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente3):[2]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] b. ** Query Union OffSetLimit (unionCount:false unionAll:false)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [OffSetLimit UnionAll]:
20:06:39 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC LIMIT 3 OFFSET 1
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente10):[1]
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente2):[2]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] c. ** Query Union OffSet (unionCount:false unionAll:false)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [OffSet UnionAll]:
20:06:39 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC OFFSET 1
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente10):[1]
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente2):[2]
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente3):[2]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] d. ** Query Union Limit (unionCount:false unionAll:false)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [OffSet UnionAll]:
20:06:39 [INFO] [testng] SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC LIMIT 2
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] e. ** Query Union con select* (unionCount:false unionAll:false)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [Normale UnionAll]:
20:06:39 [INFO] [testng] SELECT * FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ORDER BY mittente ASC ,destinatario DESC
20:06:39 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
20:06:39 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
20:06:39 [INFO] [testng] riga[2]= (SoggettoMittente10):[1]
20:06:39 [INFO] [testng] riga[3]= (SoggettoMittente2):[2]
20:06:39 [INFO] [testng] riga[4]= (SoggettoMittente3):[2]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] f. ** Query Union con select* e LimitOffset (unionCount:false unionAll:false)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] g. ** Query Union con select* e Offset (unionCount:false unionAll:false)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] h. ** Query Union con select* e Limit (unionCount:false unionAll:false)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] i. ** Query Union per test SelectForUpdate (unionCount:false unionAll:false)
20:06:39 [INFO] [testng] ERRORE ATTESO: Parametro SqlQueryObject[0] non valido: Utilizzo dell'opzione 'FOR UPDATE' non permesso con il comando UNION
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] a. ** Query Union (unionCount:true unionAll:false)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:true unionAll:false) [postgresql] [Normale UnionAll]:
20:06:39 [INFO] [testng] SELECT count(*) as aliasUnion FROM ( SELECT mittente as mit,cont FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ) as subquery2
20:06:39 [INFO] [testng] riga[0]= [5]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] e. ** Query Union con select* (unionCount:true unionAll:false)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:true unionAll:false) [postgresql] [Normale UnionAll]:
20:06:39 [INFO] [testng] SELECT count(*) as aliasUnion FROM ( SELECT * FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 ) as subquery2
20:06:39 [INFO] [testng] riga[0]= [5]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] i. ** Query Union per test SelectForUpdate (unionCount:true unionAll:false)
20:06:39 [INFO] [testng] ERRORE ATTESO: Parametro SqlQueryObject[0] non valido: Utilizzo dell'opzione 'FOR UPDATE' non permesso con il comando UNION
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] a. ** Query UnionGroupBy (unionCount:false unionAll:true)
20:06:39 [INFO] [testng]
20:06:39 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [Normale UnionAll]:
20:06:40 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC
20:06:40 [INFO] [testng] riga[0]= (SoggettoMittente0):[4]
20:06:40 [INFO] [testng] riga[1]= (SoggettoMittente1):[4]
20:06:40 [INFO] [testng] riga[2]= (SoggettoMittente10):[2]
20:06:40 [INFO] [testng] riga[3]= (SoggettoMittente2):[4]
20:06:40 [INFO] [testng] riga[4]= (SoggettoMittente3):[4]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] b. ** Query UnionGroupBy OffSetLimit (unionCount:false unionAll:true)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [OffSetLimit UnionAll]:
20:06:40 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 3 OFFSET 1
20:06:40 [INFO] [testng] riga[0]= (SoggettoMittente1):[4]
20:06:40 [INFO] [testng] riga[1]= (SoggettoMittente10):[2]
20:06:40 [INFO] [testng] riga[2]= (SoggettoMittente2):[4]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] c. ** Query UnionGroupBy OffSet (unionCount:false unionAll:true)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [OffSet UnionAll]:
20:06:40 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC OFFSET 1
20:06:40 [INFO] [testng] riga[0]= (SoggettoMittente1):[4]
20:06:40 [INFO] [testng] riga[1]= (SoggettoMittente10):[2]
20:06:40 [INFO] [testng] riga[2]= (SoggettoMittente2):[4]
20:06:40 [INFO] [testng] riga[3]= (SoggettoMittente3):[4]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] d. ** Query UnionGroupBy Limit (unionCount:false unionAll:true)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] Test(count:false unionAll:true) [postgresql] [OffSet UnionAll]:
20:06:40 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 2
20:06:40 [INFO] [testng] riga[0]= (SoggettoMittente0):[4]
20:06:40 [INFO] [testng] riga[1]= (SoggettoMittente1):[4]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] e. ** Query UnionGroupBy con select* (unionCount:false unionAll:true)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] f. ** Query UnionGroupBy con select* e LimitOffset (unionCount:false unionAll:true)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] g. ** Query UnionGroupBy con select* e Offset (unionCount:false unionAll:true)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] h. ** Query UnionGroupBy con select* e Limit (unionCount:false unionAll:true)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] a. ** Query UnionGroupBy (unionCount:true unionAll:true)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] Test(count:true unionAll:true) [postgresql] [Normale UnionAll]:
20:06:40 [INFO] [testng] SELECT count(*) as aliasUnion FROM ( SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ALL ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ) as subquery2
20:06:40 [INFO] [testng] riga[0]= [5]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] e. ** Query UnionGroupBy con select* (unionCount:true unionAll:true)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] a. ** Query UnionGroupBy (unionCount:false unionAll:false)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [Normale UnionAll]:
20:06:40 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC
20:06:40 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
20:06:40 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
20:06:40 [INFO] [testng] riga[2]= (SoggettoMittente10):[1]
20:06:40 [INFO] [testng] riga[3]= (SoggettoMittente2):[2]
20:06:40 [INFO] [testng] riga[4]= (SoggettoMittente3):[2]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] b. ** Query UnionGroupBy OffSetLimit (unionCount:false unionAll:false)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [OffSetLimit UnionAll]:
20:06:40 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 3 OFFSET 1
20:06:40 [INFO] [testng] riga[0]= (SoggettoMittente1):[2]
20:06:40 [INFO] [testng] riga[1]= (SoggettoMittente10):[1]
20:06:40 [INFO] [testng] riga[2]= (SoggettoMittente2):[2]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] c. ** Query UnionGroupBy OffSet (unionCount:false unionAll:false)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [OffSet UnionAll]:
20:06:40 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC OFFSET 1
20:06:40 [INFO] [testng] riga[0]= (SoggettoMittente1):[2]
20:06:40 [INFO] [testng] riga[1]= (SoggettoMittente10):[1]
20:06:40 [INFO] [testng] riga[2]= (SoggettoMittente2):[2]
20:06:40 [INFO] [testng] riga[3]= (SoggettoMittente3):[2]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] d. ** Query UnionGroupBy Limit (unionCount:false unionAll:false)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] Test(count:false unionAll:false) [postgresql] [OffSet UnionAll]:
20:06:40 [INFO] [testng] SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 2
20:06:40 [INFO] [testng] riga[0]= (SoggettoMittente0):[2]
20:06:40 [INFO] [testng] riga[1]= (SoggettoMittente1):[2]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] e. ** Query UnionGroupBy con select* (unionCount:false unionAll:false)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] f. ** Query UnionGroupBy con select* e LimitOffset (unionCount:false unionAll:false)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] g. ** Query UnionGroupBy con select* e Offset (unionCount:false unionAll:false)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] h. ** Query UnionGroupBy con select* e Limit (unionCount:false unionAll:false)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] a. ** Query UnionGroupBy (unionCount:true unionAll:false)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] Test(count:true unionAll:false) [postgresql] [Normale UnionAll]:
20:06:40 [INFO] [testng] SELECT count(*) as aliasUnion FROM ( SELECT mittente as mit,sum(cont) as contRisultatoGroupBy FROM ( ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) UNION ( SELECT DISTINCT count(DISTINCT id) as cont,mittente,destinatario FROM tracce WHERE ( tipo_mittente is not null ) GROUP BY mittente,destinatario ORDER BY mittente ASC ,destinatario DESC LIMIT 5 OFFSET 0) ) as subquery1 GROUP BY mittente,destinatario ) as subquery2
20:06:40 [INFO] [testng] riga[0]= [5]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] e. ** Query UnionGroupBy con select* (unionCount:true unionAll:false)
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] h. ** Test IS NULL / IS EMPTY
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-msgdiagnostici isNull:
20:06:40 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo FROM msgdiagnostici WHERE ( campo_vuoto is null ) ORDER BY gdo ASC FOR UPDATE
20:06:40 [INFO] [testng] riga[0]=descrizione esempio 1 (time:2025-01-08 20:06:38.060686 campo_vuoto:(null)
20:06:40 [INFO] [testng] riga[1]=descrizione esempio 2 (time:2025-01-08 20:06:38.061 campo_vuoto:(null)
20:06:40 [INFO] [testng] riga[2]=descrizione esempio 3 (time:2025-01-08 20:06:38.062999 campo_vuoto:(null)
20:06:40 [INFO] [testng] riga[3]=descrizione esempio 4 (time:2025-01-08 20:06:38.064 campo_vuoto:(null)
20:06:40 [INFO] [testng] riga[4]=descrizione esempio 5 (time:2025-01-08 20:06:38.065375 campo_vuoto:(null)
20:06:40 [INFO] [testng] riga[5]=descrizione esempio 6 (time:2025-01-08 20:06:38.066 campo_vuoto:(null)
20:06:40 [INFO] [testng] riga[6]=descrizione esempio 7 (time:2025-01-08 20:06:38.067666 campo_vuoto:(null)
20:06:40 [INFO] [testng] riga[7]=descrizione esempio 8 (time:2025-01-08 20:06:38.068 campo_vuoto:(null)
20:06:40 [INFO] [testng] riga[8]=descrizione esempio 9 (time:2025-01-08 20:06:38.069756 campo_vuoto:(null)
20:06:40 [INFO] [testng] riga[9]=descrizione esempio uguale (time:2025-01-08 20:06:38.071 campo_vuoto:(null)
20:06:40 [INFO] [testng] Attesi [10] trovati[10]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test2-msgdiagnostici isNotNull:
20:06:40 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo FROM msgdiagnostici WHERE ( campo_vuoto is not null ) ORDER BY gdo ASC FOR UPDATE
20:06:40 [INFO] [testng] riga[0]=descrizione esempio 0 (time:2025-01-08 20:06:38.058 campo_vuoto:(Prima colonna valorizzata)
20:06:40 [INFO] [testng] riga[1]=descrizione esempio uguale (time:2025-01-08 20:06:38.072 campo_vuoto:()
20:06:40 [INFO] [testng] riga[2]=descrizione esempio uguale (time:2025-01-08 20:06:38.072023 campo_vuoto:()
20:06:40 [INFO] [testng] riga[3]=descrizione esempio uguale (time:2025-01-08 20:06:38.074141 campo_vuoto:()
20:06:40 [INFO] [testng] riga[4]=descrizione esempio uguale (time:2025-01-08 20:06:38.075 campo_vuoto:()
20:06:40 [INFO] [testng] riga[5]=descrizione esempio uguale (time:2025-01-08 20:06:38.076 campo_vuoto:()
20:06:40 [INFO] [testng] riga[6]=descrizione esempio uguale (time:2025-01-08 20:06:38.076132 campo_vuoto:()
20:06:40 [INFO] [testng] riga[7]=descrizione esempio uguale (time:2025-01-08 20:06:38.077912 campo_vuoto:()
20:06:40 [INFO] [testng] riga[8]=descrizione esempio uguale (time:2025-01-08 20:06:38.078 campo_vuoto:()
20:06:40 [INFO] [testng] riga[9]=descrizione esempio uguale (time:2025-01-08 20:06:38.080017 campo_vuoto:()
20:06:40 [INFO] [testng] riga[10]=descrizione con caratteri particolari: ------- { ( [ _ % ^ \ / # | & à è @ . : ; , < parolaCasualeMAIUSCOLA > é ù ì ^ " ' ? ! ] ) } ------
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] Un po di parole Maiuscole Minuscole § ° ç £----- (time:2025-01-08 20:06:38.081 campo_vuoto:(Ultima colonna valorizzata)Attesi [11] trovati[11]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test3-msgdiagnostici isEmpty:
20:06:40 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo FROM msgdiagnostici WHERE ( campo_vuoto = '' ) ORDER BY gdo ASC FOR UPDATE
20:06:40 [INFO] [testng] riga[0]=descrizione esempio uguale (time:2025-01-08 20:06:38.072 campo_vuoto:()
20:06:40 [INFO] [testng] riga[1]=descrizione esempio uguale (time:2025-01-08 20:06:38.072023 campo_vuoto:()
20:06:40 [INFO] [testng] riga[2]=descrizione esempio uguale (time:2025-01-08 20:06:38.074141 campo_vuoto:()
20:06:40 [INFO] [testng] riga[3]=descrizione esempio uguale (time:2025-01-08 20:06:38.075 campo_vuoto:()
20:06:40 [INFO] [testng] riga[4]=descrizione esempio uguale (time:2025-01-08 20:06:38.076 campo_vuoto:()
20:06:40 [INFO] [testng] riga[5]=descrizione esempio uguale (time:2025-01-08 20:06:38.076132 campo_vuoto:()
20:06:40 [INFO] [testng] riga[6]=descrizione esempio uguale (time:2025-01-08 20:06:38.077912 campo_vuoto:()
20:06:40 [INFO] [testng] riga[7]=descrizione esempio uguale (time:2025-01-08 20:06:38.078 campo_vuoto:()
20:06:40 [INFO] [testng] riga[8]=descrizione esempio uguale (time:2025-01-08 20:06:38.080017 campo_vuoto:()
20:06:40 [INFO] [testng] Attesi [9] trovati[9]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test4-msgdiagnostici isNotEmpty:
20:06:40 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo FROM msgdiagnostici WHERE ( campo_vuoto <> '' ) ORDER BY gdo ASC FOR UPDATE
20:06:40 [INFO] [testng] riga[0]=descrizione esempio 0 (time:2025-01-08 20:06:38.058 campo_vuoto:(Prima colonna valorizzata)
20:06:40 [INFO] [testng] riga[1]=descrizione con caratteri particolari: ------- { ( [ _ % ^ \ / # | & à è @ . : ; , < parolaCasualeMAIUSCOLA > é ù ì ^ " ' ? ! ] ) } ------
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] Un po di parole Maiuscole Minuscole § ° ç £----- (time:2025-01-08 20:06:38.081 campo_vuoto:(Ultima colonna valorizzata)Attesi [2] trovati[2]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] h. ** Test CASE
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-tracce case:
20:06:40 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo,mittente,destinatario FROM tracce WHERE ( campo_update is null ) AND ( campo_int_update is null ) ORDER BY gdo ASC
20:06:40 [INFO] [testng] riga[0] mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2025-01-08 20:06:38.082)
20:06:40 [INFO] [testng] riga[1] mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2025-01-08 20:06:38.084495)
20:06:40 [INFO] [testng] riga[2] mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2025-01-08 20:06:38.085)
20:06:40 [INFO] [testng] riga[3] mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2025-01-08 20:06:38.086702)
20:06:40 [INFO] [testng] riga[4] mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2025-01-08 20:06:38.087)
20:06:40 [INFO] [testng] riga[5] mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2025-01-08 20:06:38.088801)
20:06:40 [INFO] [testng] riga[6] mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2025-01-08 20:06:38.089)
20:06:40 [INFO] [testng] riga[7] mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2025-01-08 20:06:38.090926)
20:06:40 [INFO] [testng] riga[8] mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2025-01-08 20:06:38.091)
20:06:40 [INFO] [testng] riga[9] mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2025-01-08 20:06:38.093423)
20:06:40 [INFO] [testng] riga[10] mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2025-01-08 20:06:38.094)
20:06:40 [INFO] [testng] riga[11] mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2025-01-08 20:06:38.095459)
20:06:40 [INFO] [testng] riga[12] mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2025-01-08 20:06:38.096)
20:06:40 [INFO] [testng] riga[13] mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2025-01-08 20:06:38.098137)
20:06:40 [INFO] [testng] riga[14] mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2025-01-08 20:06:38.099)
20:06:40 [INFO] [testng] riga[15] mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2025-01-08 20:06:38.100522)
20:06:40 [INFO] [testng] riga[16] mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2025-01-08 20:06:38.101)
20:06:40 [INFO] [testng] riga[17] mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2025-01-08 20:06:38.10264)
20:06:40 [INFO] [testng] riga[18] mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2025-01-08 20:06:38.103)
20:06:40 [INFO] [testng] riga[19] mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2025-01-08 20:06:38.104417)
20:06:40 [INFO] [testng] riga[20] mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2025-01-08 20:06:38.105)
20:06:40 [INFO] [testng] Attesi [21] trovati[21]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-tracce case:
20:06:40 [INFO] [testng] UPDATE tracce SET campo_update = CASE WHEN mittente=? THEN ? WHEN mittente=? THEN ? ELSE ? END , campo_int_update = CASE WHEN mittente=? OR destinatario=? THEN ? WHEN mittente=? OR destinatario=? THEN ? ELSE ? END
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-tracce case:
20:06:40 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo,mittente,destinatario,campo_update,campo_int_update FROM tracce WHERE ( campo_update is not null ) AND ( campo_int_update is not null ) ORDER BY gdo ASC
20:06:40 [INFO] [testng] riga[0] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2025-01-08 20:06:38.082)
20:06:40 [INFO] [testng] riga[1] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2025-01-08 20:06:38.084495)
20:06:40 [INFO] [testng] riga[2] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2025-01-08 20:06:38.085)
20:06:40 [INFO] [testng] riga[3] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2025-01-08 20:06:38.086702)
20:06:40 [INFO] [testng] riga[4] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2025-01-08 20:06:38.087)
20:06:40 [INFO] [testng] riga[5] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2025-01-08 20:06:38.088801)
20:06:40 [INFO] [testng] riga[6] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2025-01-08 20:06:38.089)
20:06:40 [INFO] [testng] riga[7] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2025-01-08 20:06:38.090926)
20:06:40 [INFO] [testng] riga[8] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2025-01-08 20:06:38.091)
20:06:40 [INFO] [testng] riga[9] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2025-01-08 20:06:38.093423)
20:06:40 [INFO] [testng] riga[10] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2025-01-08 20:06:38.094)
20:06:40 [INFO] [testng] riga[11] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2025-01-08 20:06:38.095459)
20:06:40 [INFO] [testng] riga[12] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2025-01-08 20:06:38.096)
20:06:40 [INFO] [testng] riga[13] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2025-01-08 20:06:38.098137)
20:06:40 [INFO] [testng] riga[14] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2025-01-08 20:06:38.099)
20:06:40 [INFO] [testng] riga[15] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2025-01-08 20:06:38.100522)
20:06:40 [INFO] [testng] riga[16] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2025-01-08 20:06:38.101)
20:06:40 [INFO] [testng] riga[17] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2025-01-08 20:06:38.10264)
20:06:40 [INFO] [testng] riga[18] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2025-01-08 20:06:38.103)
20:06:40 [INFO] [testng] riga[19] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2025-01-08 20:06:38.104417)
20:06:40 [INFO] [testng] riga[20] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2025-01-08 20:06:38.105)
20:06:40 [INFO] [testng] Attesi [21] trovati[21]
20:06:40 [INFO] [testng] (stringCasoA) Attesi [2] trovati[2]
20:06:40 [INFO] [testng] (stringCasoB) Attesi [2] trovati[2]
20:06:40 [INFO] [testng] (stringCasoDefault) Attesi [17] trovati[17]
20:06:40 [INFO] [testng] (intCasoA) Attesi [4] trovati[4]
20:06:40 [INFO] [testng] (intCasoB) Attesi [4] trovati[4]
20:06:40 [INFO] [testng] (intCasoDefault) Attesi [13] trovati[13]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] h. ** Test CASE SENZA ELSE
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-tracce case:
20:06:40 [INFO] [testng] UPDATE tracce SET campo_update = ? , campo_int_update = ?
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-tracce case:
20:06:40 [INFO] [testng] UPDATE tracce SET campo_update = CASE WHEN mittente=? THEN ? WHEN mittente=? THEN ? END , campo_int_update = CASE WHEN mittente=? OR destinatario=? THEN ? WHEN mittente=? OR destinatario=? THEN ? END
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-tracce case:
20:06:40 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo,mittente,destinatario,campo_update,campo_int_update FROM tracce ORDER BY gdo ASC
20:06:40 [INFO] [testng] riga[0] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2025-01-08 20:06:38.082)
20:06:40 [INFO] [testng] riga[1] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2025-01-08 20:06:38.084495)
20:06:40 [INFO] [testng] riga[2] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2025-01-08 20:06:38.085)
20:06:40 [INFO] [testng] riga[3] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2025-01-08 20:06:38.086702)
20:06:40 [INFO] [testng] riga[4] (string:null int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2025-01-08 20:06:38.087)
20:06:40 [INFO] [testng] riga[5] (string:null int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2025-01-08 20:06:38.088801)
20:06:40 [INFO] [testng] riga[6] (string:null int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2025-01-08 20:06:38.089)
20:06:40 [INFO] [testng] riga[7] (string:null int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2025-01-08 20:06:38.090926)
20:06:40 [INFO] [testng] riga[8] (string:null int:0) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2025-01-08 20:06:38.091)
20:06:40 [INFO] [testng] riga[9] (string:null int:0) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2025-01-08 20:06:38.093423)
20:06:40 [INFO] [testng] riga[10] (string:null int:0) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2025-01-08 20:06:38.094)
20:06:40 [INFO] [testng] riga[11] (string:null int:0) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2025-01-08 20:06:38.095459)
20:06:40 [INFO] [testng] riga[12] (string:null int:0) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2025-01-08 20:06:38.096)
20:06:40 [INFO] [testng] riga[13] (string:null int:0) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2025-01-08 20:06:38.098137)
20:06:40 [INFO] [testng] riga[14] (string:null int:0) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2025-01-08 20:06:38.099)
20:06:40 [INFO] [testng] riga[15] (string:null int:0) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2025-01-08 20:06:38.100522)
20:06:40 [INFO] [testng] riga[16] (string:null int:0) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2025-01-08 20:06:38.101)
20:06:40 [INFO] [testng] riga[17] (string:null int:0) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2025-01-08 20:06:38.10264)
20:06:40 [INFO] [testng] riga[18] (string:null int:0) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2025-01-08 20:06:38.103)
20:06:40 [INFO] [testng] riga[19] (string:null int:0) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2025-01-08 20:06:38.104417)
20:06:40 [INFO] [testng] riga[20] (string:null int:0) mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2025-01-08 20:06:38.105)
20:06:40 [INFO] [testng] Attesi [21] trovati[21]
20:06:40 [INFO] [testng] (stringCasoA) Attesi [2] trovati[2]
20:06:40 [INFO] [testng] (stringCasoB) Attesi [2] trovati[2]
20:06:40 [INFO] [testng] (stringCasoDefault) Attesi [0] trovati[0]
20:06:40 [INFO] [testng] (intCasoA) Attesi [4] trovati[4]
20:06:40 [INFO] [testng] (intCasoB) Attesi [4] trovati[4]
20:06:40 [INFO] [testng] (intCasoDefault) Attesi [0] trovati[0]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] h. ** Test CASE senza ?
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-tracce case:
20:06:40 [INFO] [testng] UPDATE tracce SET campo_update = ? , campo_int_update = ?
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-tracce case:
20:06:40 [INFO] [testng] UPDATE tracce SET campo_update = CASE WHEN mittente=? THEN 'CASO_0' WHEN mittente=? THEN 'CASO_1' ELSE 'CASO_DEFAULT' END , campo_int_update = CASE WHEN mittente=? OR destinatario=? THEN 22 WHEN mittente=? OR destinatario=? THEN 33 ELSE 11 END
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-tracce case:
20:06:40 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo,mittente,destinatario,campo_update,campo_int_update FROM tracce WHERE ( campo_update is not null ) AND ( campo_int_update is not null ) ORDER BY gdo ASC
20:06:40 [INFO] [testng] riga[0] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2025-01-08 20:06:38.082)
20:06:40 [INFO] [testng] riga[1] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2025-01-08 20:06:38.084495)
20:06:40 [INFO] [testng] riga[2] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2025-01-08 20:06:38.085)
20:06:40 [INFO] [testng] riga[3] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2025-01-08 20:06:38.086702)
20:06:40 [INFO] [testng] riga[4] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2025-01-08 20:06:38.087)
20:06:40 [INFO] [testng] riga[5] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2025-01-08 20:06:38.088801)
20:06:40 [INFO] [testng] riga[6] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2025-01-08 20:06:38.089)
20:06:40 [INFO] [testng] riga[7] (string:CASO_DEFAULT int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2025-01-08 20:06:38.090926)
20:06:40 [INFO] [testng] riga[8] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2025-01-08 20:06:38.091)
20:06:40 [INFO] [testng] riga[9] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2025-01-08 20:06:38.093423)
20:06:40 [INFO] [testng] riga[10] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2025-01-08 20:06:38.094)
20:06:40 [INFO] [testng] riga[11] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2025-01-08 20:06:38.095459)
20:06:40 [INFO] [testng] riga[12] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2025-01-08 20:06:38.096)
20:06:40 [INFO] [testng] riga[13] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2025-01-08 20:06:38.098137)
20:06:40 [INFO] [testng] riga[14] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2025-01-08 20:06:38.099)
20:06:40 [INFO] [testng] riga[15] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2025-01-08 20:06:38.100522)
20:06:40 [INFO] [testng] riga[16] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2025-01-08 20:06:38.101)
20:06:40 [INFO] [testng] riga[17] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2025-01-08 20:06:38.10264)
20:06:40 [INFO] [testng] riga[18] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2025-01-08 20:06:38.103)
20:06:40 [INFO] [testng] riga[19] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2025-01-08 20:06:38.104417)
20:06:40 [INFO] [testng] riga[20] (string:CASO_DEFAULT int:11) mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2025-01-08 20:06:38.105)
20:06:40 [INFO] [testng] Attesi [21] trovati[21]
20:06:40 [INFO] [testng] (stringCasoA) Attesi [2] trovati[2]
20:06:40 [INFO] [testng] (stringCasoB) Attesi [2] trovati[2]
20:06:40 [INFO] [testng] (stringCasoDefault) Attesi [17] trovati[17]
20:06:40 [INFO] [testng] (intCasoA) Attesi [4] trovati[4]
20:06:40 [INFO] [testng] (intCasoB) Attesi [4] trovati[4]
20:06:40 [INFO] [testng] (intCasoDefault) Attesi [13] trovati[13]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] h. ** Test CASE SENZA ELSE senza ?
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-tracce case:
20:06:40 [INFO] [testng] UPDATE tracce SET campo_update = ? , campo_int_update = ?
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-tracce case:
20:06:40 [INFO] [testng] UPDATE tracce SET campo_update = CASE WHEN mittente=? THEN 'CASO_0' WHEN mittente=? THEN 'CASO_1' END , campo_int_update = CASE WHEN mittente=? OR destinatario=? THEN 22 WHEN mittente=? OR destinatario=? THEN 33 END
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] test1-tracce case:
20:06:40 [INFO] [testng] SELECT campo_vuoto,descrizione,gdo,mittente,destinatario,campo_update,campo_int_update FROM tracce ORDER BY gdo ASC
20:06:40 [INFO] [testng] riga[0] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2025-01-08 20:06:38.082)
20:06:40 [INFO] [testng] riga[1] (string:CASO_0 int:22) mittente:SoggettoMittente0 destinatario:SoggettoDestinatario0 (time:2025-01-08 20:06:38.084495)
20:06:40 [INFO] [testng] riga[2] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2025-01-08 20:06:38.085)
20:06:40 [INFO] [testng] riga[3] (string:CASO_1 int:22) mittente:SoggettoMittente1 destinatario:SoggettoDestinatario1 (time:2025-01-08 20:06:38.086702)
20:06:40 [INFO] [testng] riga[4] (string:null int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2025-01-08 20:06:38.087)
20:06:40 [INFO] [testng] riga[5] (string:null int:33) mittente:SoggettoMittente2 destinatario:SoggettoDestinatario2 (time:2025-01-08 20:06:38.088801)
20:06:40 [INFO] [testng] riga[6] (string:null int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2025-01-08 20:06:38.089)
20:06:40 [INFO] [testng] riga[7] (string:null int:33) mittente:SoggettoMittente3 destinatario:SoggettoDestinatario3 (time:2025-01-08 20:06:38.090926)
20:06:40 [INFO] [testng] riga[8] (string:null int:0) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2025-01-08 20:06:38.091)
20:06:40 [INFO] [testng] riga[9] (string:null int:0) mittente:SoggettoMittente4 destinatario:SoggettoDestinatario4 (time:2025-01-08 20:06:38.093423)
20:06:40 [INFO] [testng] riga[10] (string:null int:0) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2025-01-08 20:06:38.094)
20:06:40 [INFO] [testng] riga[11] (string:null int:0) mittente:SoggettoMittente5 destinatario:SoggettoDestinatario5 (time:2025-01-08 20:06:38.095459)
20:06:40 [INFO] [testng] riga[12] (string:null int:0) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2025-01-08 20:06:38.096)
20:06:40 [INFO] [testng] riga[13] (string:null int:0) mittente:SoggettoMittente6 destinatario:SoggettoDestinatario6 (time:2025-01-08 20:06:38.098137)
20:06:40 [INFO] [testng] riga[14] (string:null int:0) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2025-01-08 20:06:38.099)
20:06:40 [INFO] [testng] riga[15] (string:null int:0) mittente:SoggettoMittente7 destinatario:SoggettoDestinatario7 (time:2025-01-08 20:06:38.100522)
20:06:40 [INFO] [testng] riga[16] (string:null int:0) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2025-01-08 20:06:38.101)
20:06:40 [INFO] [testng] riga[17] (string:null int:0) mittente:SoggettoMittente8 destinatario:SoggettoDestinatario8 (time:2025-01-08 20:06:38.10264)
20:06:40 [INFO] [testng] riga[18] (string:null int:0) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2025-01-08 20:06:38.103)
20:06:40 [INFO] [testng] riga[19] (string:null int:0) mittente:SoggettoMittente9 destinatario:SoggettoDestinatario9 (time:2025-01-08 20:06:38.104417)
20:06:40 [INFO] [testng] riga[20] (string:null int:0) mittente:SoggettoMittente10 destinatario:SoggettoDestinatario10 (time:2025-01-08 20:06:38.105)
20:06:40 [INFO] [testng] Attesi [21] trovati[21]
20:06:40 [INFO] [testng] (stringCasoA) Attesi [2] trovati[2]
20:06:40 [INFO] [testng] (stringCasoB) Attesi [2] trovati[2]
20:06:40 [INFO] [testng] (stringCasoDefault) Attesi [0] trovati[0]
20:06:40 [INFO] [testng] (intCasoA) Attesi [4] trovati[4]
20:06:40 [INFO] [testng] (intCasoB) Attesi [4] trovati[4]
20:06:40 [INFO] [testng] (intCasoDefault) Attesi [0] trovati[0]
20:06:40 [INFO] [testng] Testsuite completata
20:06:40 [INFO] [testng] Run test 'SQLGenerator' ok
20:06:40 [INFO] [testng]
20:06:40 [INFO] [testng] ===============================================
20:06:40 [INFO] [testng] Ant suite
20:06:40 [INFO] [testng] Total tests run: 6, Passes: 6, Failures: 0, Skips: 0
20:06:40 [INFO] [testng] ===============================================
20:06:40 [INFO] [testng]
20:06:41 [INFO] [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/tools/utils/mvn/sql/build_testunits
20:06:41 [INFO] Executed tasks
20:06:41 [INFO]
20:06:41 [INFO] ---------< org.openspcoop2:org.openspcoop2.testsuite.pdd.core >---------
20:06:41 [INFO] Building testsuite.pdd.core 1.0 [66/71]
20:06:41 [INFO] --------------------------------[ pom ]---------------------------------
20:06:41 [INFO]
20:06:41 [INFO] -------< org.openspcoop2:org.openspcoop2.testsuite.pdd.core.sql >-------
20:06:41 [INFO] Building testsuite.pdd.core.sql 1.0 [67/71]
20:06:41 [INFO] --------------------------------[ pom ]---------------------------------
20:06:41 [INFO]
20:06:41 [INFO] --- maven-dependency-plugin:3.8.1:copy-dependencies (copy-dependencies) @ org.openspcoop2.testsuite.pdd.core.sql ---
20:06:41 [INFO]
20:06:41 [INFO] --- maven-antrun-plugin:3.1.0:run (default) @ org.openspcoop2.testsuite.pdd.core.sql ---
20:06:41 [INFO] Executing tasks
20:06:41 [INFO] [unzip] Expanding: /var/lib/jenkins/workspace/GovWay/dist/openspcoop2_pdd-test-3.3.15.p2.jar into /var/lib/jenkins/workspace/GovWay/core/mvn/sql/build_testunits
20:06:41 [WARNING] [echo] Avvio TestSuite (gruppo: pdd.sql) (haltOnFailure:true)
20:06:41 [INFO] [jacoco:coverage] Enhancing testng with coverage
20:06:44 [INFO] [testng] Run test 'GestoreRepositoryBuste' ...
20:06:44 [INFO] [testng] LogMessages write in /tmp/runGestoreRepositoryTest_126775061903909949.log
20:06:45 [INFO] [testng] URL:jdbc:postgresql://localhost/govway_test
20:06:45 [INFO] [testng] UserName:govway
20:06:45 [INFO] [testng] Password:govway
20:06:45 [INFO] [testng] DriverJDBC:org.postgresql.Driver
20:06:45 [WARNING] [testng] WARNING: An illegal reflective access operation has occurred
20:06:45 [WARNING] [testng] WARNING: Illegal reflective access by org.postgresql.jdbc.TimestampUtils (file:/var/lib/jenkins/workspace/GovWay/core/lib/postgresql-9.4.1212.jar) to field java.util.TimeZone.defaultTimeZone
20:06:45 [WARNING] [testng] WARNING: Please consider reporting this to the maintainers of org.postgresql.jdbc.TimestampUtils
20:06:45 [WARNING] [testng] WARNING: Use --illegal-access=warn to enable warnings of further illegal reflective access operations
20:06:45 [WARNING] [testng] WARNING: All illegal access operations will be denied in a future release
20:06:45 [INFO] [testng] Creato IGestoreRepository[bytewise] di tipo org.openspcoop2.protocol.engine.driver.repository.GestoreRepositoryBytewise
20:06:45 [INFO] [testng] createSQLFields: REPOSITORY_ACCESS
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] inserita riga: 1
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0)]
20:06:45 [INFO] [testng] (test 1. history=false). Trovata entry con valore: 0
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0) and (REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=4 OR REPOSITORY_ACCESS=0)]
20:06:45 [INFO] [testng] (test 2. history=false and profilo=false). Trovata entry con valore: 0
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0) and (REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=4 OR REPOSITORY_ACCESS=0) and (REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=4 OR REPOSITORY_ACCESS=0)]
20:06:45 [INFO] [testng] (test 3. history=false and profilo=false and pdd=false). Trovata entry con valore: 0
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS | 4)]
20:06:45 [INFO] [testng] aggiornata riga: 1
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0)]
20:06:45 [INFO] [testng] (test 4. history=false). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
20:06:45 [INFO] [testng] (test 5. history=true). Trovata entry con valore: 4
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS | 2)]
20:06:45 [INFO] [testng] aggiornata riga: 1
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
20:06:45 [INFO] [testng] (test 6. history=true). Trovata entry con valore: 6
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)and (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
20:06:45 [INFO] [testng] (test 7. history=true and profilo=true). Trovata entry con valore: 6
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
20:06:45 [INFO] [testng] (test 8. history=true or profilo=true). Trovata entry con valore: 6
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS | 1)]
20:06:45 [INFO] [testng] aggiornata riga: 1
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
20:06:45 [INFO] [testng] (test 9. history=true). Trovata entry con valore: 7
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)and (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
20:06:45 [INFO] [testng] (test 10. history=true and profilo=true). Trovata entry con valore: 7
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
20:06:45 [INFO] [testng] (test 1. history=true or profilo=true). Trovata entry con valore: 7
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)and (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)and (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1)]
20:06:45 [INFO] [testng] (test 12. history=true and profilo=true and pdd=true). Trovata entry con valore: 7
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1)]
20:06:45 [INFO] [testng] (test 13. history=true or profilo=true or pdd=true). Trovata entry con valore: 7
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=4)]
20:06:45 [INFO] [testng] (test 14. onlyHistory). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=2)]
20:06:45 [INFO] [testng] (test 15. onlyProfilo). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=1)]
20:06:45 [INFO] [testng] (test 16. onlyPdd). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3)]
20:06:45 [INFO] [testng] (test 17. onlyPddAndProfilo). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=0)]
20:06:45 [INFO] [testng] (test 18. disableAll). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS & 3)]
20:06:45 [INFO] [testng] aggiornata riga: 1
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
20:06:45 [INFO] [testng] (test 19. history=true). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
20:06:45 [INFO] [testng] (test 20. pdd=true or profilo=true). Trovata entry con valore: 3
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=2)]
20:06:45 [INFO] [testng] (test 21. onlyProfilo). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=1)]
20:06:45 [INFO] [testng] (test 22. onlyPdd). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3)]
20:06:45 [INFO] [testng] (test 23. pddAndProfilo). Trovata entry con valore: 3
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=0)]
20:06:45 [INFO] [testng] (test 24. disableAll). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS & 6)]
20:06:45 [INFO] [testng] aggiornata riga: 1
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
20:06:45 [INFO] [testng] (test 25. history=true). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
20:06:45 [INFO] [testng] (test 26. pdd=true or profilo=true). Trovata entry con valore: 2
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=2)]
20:06:45 [INFO] [testng] (test 27. profilo=true). Trovata entry con valore: 2
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=1)]
20:06:45 [INFO] [testng] (test 28. onlyPdd). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3)]
20:06:45 [INFO] [testng] (test 29. pddAndProfilo). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=0)]
20:06:45 [INFO] [testng] (test 30. disableAll). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Update [UPDATE prova_bytewise set REPOSITORY_ACCESS = (REPOSITORY_ACCESS & 5)]
20:06:45 [INFO] [testng] aggiornata riga: 1
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
20:06:45 [INFO] [testng] (test 31. history=true). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=1)or (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=2)]
20:06:45 [INFO] [testng] (test 32. pdd=true or profilo=true). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=2)]
20:06:45 [INFO] [testng] (test 33. onlyProfilo). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=1)]
20:06:45 [INFO] [testng] (test 34. onlyPdd). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3)]
20:06:45 [INFO] [testng] (test 35. pddAndProfilo). Non e' stata trovata correttamente una entry
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=0)]
20:06:45 [INFO] [testng] (test 36. disableAll). Trovata entry con valore: 0
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] inserita riga: 1
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=7 OR REPOSITORY_ACCESS=5 OR REPOSITORY_ACCESS=6 OR REPOSITORY_ACCESS=4)]
20:06:45 [INFO] [testng] (test 37. history=true). Trovata entry con valore: 4
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] inserita riga: 1
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] Query [select REPOSITORY_ACCESS from prova_bytewise where (REPOSITORY_ACCESS=3 OR REPOSITORY_ACCESS=1 OR REPOSITORY_ACCESS=2 OR REPOSITORY_ACCESS=0)]
20:06:45 [INFO] [testng] (test 38. history=false). Trovata entry con valore: 0
20:06:45 [INFO] [testng] Run test 'GestoreRepositoryBuste' ok
20:06:45 [INFO] [testng]
20:06:45 [INFO] [testng] ===============================================
20:06:45 [INFO] [testng] Ant suite
20:06:45 [INFO] [testng] Total tests run: 1, Passes: 1, Failures: 0, Skips: 0
20:06:45 [INFO] [testng] ===============================================
20:06:45 [INFO] [testng]
20:06:46 [INFO] [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/core/mvn/sql/build_testunits
20:06:46 [INFO] Executed tasks
20:06:46 [INFO]
20:06:46 [INFO] ------< org.openspcoop2:org.openspcoop2.static_analysis.spotbugs >------
20:06:46 [INFO] Building static_analysis.spotbugs 1.0 [68/71]
20:06:46 [INFO] --------------------------------[ pom ]---------------------------------
20:06:46 [INFO]
20:06:46 [INFO] -----< org.openspcoop2:org.openspcoop2.static_analysis.sonarqube >------
20:06:46 [INFO] Building static_analysis.sonarqube 1.0 [69/71]
20:06:46 [INFO] --------------------------------[ pom ]---------------------------------
20:06:46 [INFO]
20:06:46 [INFO] --------< org.openspcoop2:org.openspcoop2.dynamic_analysis.zap >--------
20:06:46 [INFO] Building dynamic_analysis.zap 1.0 [70/71]
20:06:46 [INFO] --------------------------------[ pom ]---------------------------------
20:06:46 [INFO]
20:06:46 [INFO] ----------< org.openspcoop2:org.openspcoop2.coverage.jacoco >-----------
20:06:46 [INFO] Building coverage.jacoco 1.0 [71/71]
20:06:46 [INFO] --------------------------------[ pom ]---------------------------------
20:06:46 [INFO] ------------------------------------------------------------------------
20:06:46 [INFO] Reactor Summary for govway 1.0:
20:06:46 [INFO]
20:06:46 [INFO] govway ............................................. SUCCESS [ 0.003 s]
20:06:46 [INFO] dependencies ....................................... SUCCESS [ 0.001 s]
20:06:46 [INFO] dependencies.ant ................................... SUCCESS [ 1.188 s]
20:06:46 [INFO] dependencies.antinstaller .......................... SUCCESS [ 0.035 s]
20:06:46 [INFO] dependencies.axiom ................................. SUCCESS [ 0.448 s]
20:06:46 [INFO] dependencies.bean-validation ....................... SUCCESS [ 0.044 s]
20:06:46 [INFO] dependencies.cxf ................................... SUCCESS [ 0.274 s]
20:06:46 [INFO] dependencies.commons ............................... SUCCESS [ 0.101 s]
20:06:46 [INFO] dependencies.faces ................................. SUCCESS [ 0.058 s]
20:06:46 [INFO] dependencies.git ................................... SUCCESS [ 0.018 s]
20:06:46 [INFO] dependencies.httpcore .............................. SUCCESS [ 0.083 s]
20:06:46 [INFO] dependencies.jackson ............................... SUCCESS [ 0.043 s]
20:06:46 [INFO] dependencies.javax ................................. SUCCESS [ 0.037 s]
20:06:46 [INFO] dependencies.jax ................................... SUCCESS [ 0.137 s]
20:06:46 [INFO] dependencies.jetty ................................. SUCCESS [ 0.037 s]
20:06:46 [INFO] dependencies.jminix ................................ SUCCESS [ 0.056 s]
20:06:46 [INFO] dependencies.json .................................. SUCCESS [ 0.069 s]
20:06:46 [INFO] dependencies.log ................................... SUCCESS [ 0.128 s]
20:06:46 [INFO] dependencies.lucene ................................ SUCCESS [ 0.029 s]
20:06:46 [INFO] dependencies.openapi4j ............................. SUCCESS [ 0.082 s]
20:06:46 [INFO] dependencies.opensaml .............................. SUCCESS [ 0.062 s]
20:06:46 [INFO] dependencies.pdf ................................... SUCCESS [ 0.027 s]
20:06:46 [INFO] dependencies.redis ................................. SUCCESS [ 0.056 s]
20:06:46 [INFO] dependencies.reports ............................... SUCCESS [ 0.039 s]
20:06:46 [INFO] dependencies.saaj .................................. SUCCESS [ 0.067 s]
20:06:46 [INFO] dependencies.security .............................. SUCCESS [ 0.089 s]
20:06:46 [INFO] dependencies.shared ................................ SUCCESS [ 0.188 s]
20:06:46 [INFO] dependencies.spring ................................ SUCCESS [ 0.081 s]
20:06:46 [INFO] dependencies.spring-ldap ........................... SUCCESS [ 0.009 s]
20:06:46 [INFO] dependencies.spring-security ....................... SUCCESS [ 0.013 s]
20:06:46 [INFO] dependencies.swagger ............................... SUCCESS [ 0.088 s]
20:06:46 [INFO] dependencies.swagger-codegen ....................... SUCCESS [ 0.205 s]
20:06:46 [INFO] dependencies.swagger-codegen.linkit ................ SUCCESS [ 0.152 s]
20:06:46 [INFO] dependencies.wadl .................................. SUCCESS [ 0.013 s]
20:06:46 [INFO] dependencies.wss4j ................................. SUCCESS [ 0.082 s]
20:06:46 [INFO] dependencies.testsuite ............................. SUCCESS [ 0.001 s]
20:06:46 [INFO] dependencies.testsuite.axis14 ...................... SUCCESS [ 0.083 s]
20:06:46 [INFO] dependencies.testsuite.as .......................... SUCCESS [ 0.001 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly9 ................. SUCCESS [ 0.021 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly10 ................ SUCCESS [ 0.024 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly11 ................ SUCCESS [ 0.027 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly12 ................ SUCCESS [ 0.024 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly13 ................ SUCCESS [ 0.025 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly14 ................ SUCCESS [ 0.025 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly15 ................ SUCCESS [ 0.025 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly16 ................ SUCCESS [ 0.024 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly17 ................ SUCCESS [ 0.029 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly18 ................ SUCCESS [ 0.036 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly19 ................ SUCCESS [ 0.027 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly20 ................ SUCCESS [ 0.027 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly21 ................ SUCCESS [ 0.106 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly22 ................ SUCCESS [ 0.023 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly23 ................ SUCCESS [ 0.025 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly24 ................ SUCCESS [ 0.025 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly25 ................ SUCCESS [ 0.025 s]
20:06:46 [INFO] dependencies.testsuite.as.wildfly26 ................ SUCCESS [ 0.027 s]
20:06:46 [INFO] dependencies.testsuite.as.tomcat9 .................. SUCCESS [ 0.007 s]
20:06:46 [INFO] dependencies.testsuite.test ........................ SUCCESS [ 0.105 s]
20:06:46 [INFO] dependencies.testsuite.staticAnalysis .............. SUCCESS [ 0.011 s]
20:06:46 [INFO] dependencies.testsuite.dynamicAnalysis ............. SUCCESS [ 0.007 s]
20:06:46 [INFO] dependencies.testsuite.coverage .................... SUCCESS [ 0.017 s]
20:06:46 [INFO] compile ............................................ SUCCESS [ 0.000 s]
20:06:46 [INFO] package ............................................ SUCCESS [ 0.001 s]
20:06:46 [INFO] testsuite.utils .................................... SUCCESS [ 0.000 s]
20:06:46 [INFO] testsuite.utils.sql ................................ SUCCESS [01:21 min]
20:06:46 [INFO] testsuite.pdd.core ................................. SUCCESS [ 0.001 s]
20:06:46 [INFO] testsuite.pdd.core.sql ............................. SUCCESS [ 4.441 s]
20:06:46 [INFO] static_analysis.spotbugs ........................... SUCCESS [ 0.001 s]
20:06:46 [INFO] static_analysis.sonarqube .......................... SUCCESS [ 0.000 s]
20:06:46 [INFO] dynamic_analysis.zap ............................... SUCCESS [ 0.001 s]
20:06:46 [INFO] coverage.jacoco .................................... SUCCESS [ 0.001 s]
20:06:46 [INFO] ------------------------------------------------------------------------
20:06:46 [INFO] BUILD SUCCESS
20:06:46 [INFO] ------------------------------------------------------------------------
20:06:46 [INFO] Total time: 01:31 min
20:06:46 [INFO] Finished at: 2025-01-08T20:06:46+01:00
20:06:46 [INFO] ------------------------------------------------------------------------
20:06:46 [GovWay] $ /bin/sh -xe /tmp/jenkins11818743410225760139.sh
20:06:46 + echo 'Pubblicazione risultati testsuite core ...'
20:06:46 Pubblicazione risultati testsuite core ...
20:06:46 + sudo su -c 'rm -rf /opt/apache-tomcat-9.0.91/webapps/govway-testsuite/core'
20:06:46 + sudo su -c 'mkdir /opt/apache-tomcat-9.0.91/webapps/govway-testsuite/core'
20:06:46 + sudo su -c 'cp -r /var/lib/jenkins/workspace/GovWay/testsuite-result/* /opt/apache-tomcat-9.0.91/webapps/govway-testsuite/core/'
20:06:46 + echo 'Pubblicazione risultati testsuite core effettuata'
20:06:46 Pubblicazione risultati testsuite core effettuata
20:06:46 [Boolean condition] checking [true] against [^(1|y|yes|t|true|on|run)$] (origin token: ${GOVWAY_TEST_INTEGRAZIONE})
20:06:46 Run condition [Boolean condition] enabling perform for step [BuilderChain]
20:06:46 [GovWay] $ /bin/bash /tmp/jenkins14648422224223991391.sh
20:06:46 Fermo application server ...
20:06:46 [00;31mStoping Tomcat[00m
20:06:46 NOTE: Picked up JDK_JAVA_OPTIONS: --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.util.concurrent=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED
20:06:47 Pid Tomcat: 7735
20:06:47
20:06:48 [00;31mwaiting for processes to exit[00m
20:06:49 [00;31mwaiting for processes to exit[00m
20:06:50 [00;31mwaiting for processes to exit[00m
20:06:51 [00;31mwaiting for processes to exit[00m
20:06:52 [00;31mwaiting for processes to exit[00mFermo application server effettuato
20:06:52 Predisposizione datasource ...
20:06:52 Predisposizione datasource effettuata
20:06:52 Predisposizione jars ...
20:06:52 Predisposizione jars effettuata
20:06:52 Preparazione compilazione govwayTestSuite.war ...
20:06:52 Preparazione compilazione govwayTestSuite.war effettuata
20:06:52 [testsuite] $ /var/lib/jenkins/tools/hudson.tasks.Ant_AntInstallation/ant-1.10.6/bin/ant -file build.xml -Das=tomcat9 clean build
20:06:53 Buildfile: /var/lib/jenkins/workspace/GovWay/testsuite/build.xml
20:06:53
20:06:53 check_as_version:
20:06:54
20:06:54 clean_testsuite:
20:06:54
20:06:54 clean:
20:06:54
20:06:54 init_compile_testsuite:
20:06:54 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite
20:06:54 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/tmp
20:06:54 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/dist
20:06:54
20:06:54 compile_govway_testsuite:
20:06:54
20:06:54 checkgit:
20:06:55
20:06:55 init_compile-build:
20:06:55 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/compile-jar-openspcoop2
20:06:55
20:06:55 compile_src_openspcoop2:
20:06:55 [echo] Java home: /opt/openjdk-11.0.12_7/
20:06:55 [echo] ****************************************
20:06:55 [echo] **** DEBUG MODE ON *****
20:06:55 [echo] ****************************************
20:06:55 [echo] Raccolta informazioni git per inserimento in manifest...
20:06:55 [echo] compileSRC[/var/lib/jenkins/workspace/GovWay/testsuite/src]
20:06:55 [javac] Compiling 78 source files to /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/compile-jar-openspcoop2
20:07:03 [jar] Building jar: /var/lib/jenkins/workspace/GovWay/testsuite/dist/openspcoop2_testsuite-lib_BUILD-616594db.jar
20:07:03 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/compile-jar-openspcoop2
20:07:03 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/doc
20:07:03
20:07:03 compile_api_openspcoop2:
20:07:03
20:07:03 init_compile-api:
20:07:03 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/doc/api
20:07:03 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/testsuite/doc/api/testsuite-lib
20:07:03 [echo] WARN: Java8 -Xdoclint:none
20:07:03 [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
20:07:03 [javadoc] Generating Javadoc
20:07:03 [javadoc] Javadoc execution
20:07:05 [javadoc] Loading source files for package org.openspcoop2.testsuite.axis14...
20:07:05 [javadoc] Loading source files for package org.openspcoop2.testsuite.clients...
20:07:05 [javadoc] Loading source files for package org.openspcoop2.testsuite.core...
20:07:05 [javadoc] Loading source files for package org.openspcoop2.testsuite.core.asincrono...
20:07:05 [javadoc] Loading source files for package org.openspcoop2.testsuite.db...
20:07:05 [javadoc] Loading source files for package org.openspcoop2.testsuite.server...
20:07:05 [javadoc] Loading source files for package org.openspcoop2.testsuite.units...
20:07:05 [javadoc] Loading source files for package org.openspcoop2.testsuite.units.utils...
20:07:05 [javadoc] Loading source files for package org.openspcoop2.testsuite.wssecurity...
20:07:05 [javadoc] Constructing Javadoc information...
20:07:07 [javadoc] Standard Doclet version 11.0.12
20:07:07 [javadoc] Building tree for all the packages and classes...
20:07:09 [javadoc] Building index for all the packages and classes...
20:07:09 [javadoc] Building index for all classes...
20:07:09 [javadoc] Building index for all classes...
20:07:10 [echo] Raccolta informazioni git per inserimento in manifest...
20:07:10 [jar] Building jar: /var/lib/jenkins/workspace/GovWay/testsuite/doc/api/openspcoop2_testsuite-lib_BUILD-616594db-javadoc.jar
20:07:10
20:07:10 compile_testsuite:
20:07:10
20:07:10 war_govway_testsuite:
20:07:10 [copy] Copying 1 file to /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/tmp
20:07:10
20:07:10 set_property:
20:07:10
20:07:10 set_property:
20:07:11
20:07:11 set_property:
20:07:11
20:07:11 set_property:
20:07:11 [copy] Copying 1 file to /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/tmp
20:07:11 [war] Building war: /var/lib/jenkins/workspace/GovWay/testsuite/dist/govwayTestSuite.war
20:07:14 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/testsuite/build/testsuite/tmp
20:07:14
20:07:14 build_testsuite:
20:07:14
20:07:14 build:
20:07:14
20:07:14 BUILD SUCCESSFUL
20:07:14 Total time: 21 seconds
20:07:14 [GovWay] $ /bin/sh -xe /tmp/jenkins11268033219598234520.sh
20:07:14 + echo 'Predisposizione jar di protocolli in govwayTestSuite.war ...'
20:07:14 Predisposizione jar di protocolli in govwayTestSuite.war ...
20:07:14 + sudo su -c 'rm -rf /tmp/govwayTestSuite.war.tmp'
20:07:14 + sudo su -c 'rm -f /tmp/govwayTestSuite.war'
20:07:14 + sudo su -c 'unzip -q /var/lib/jenkins/workspace/GovWay/testsuite/dist/govwayTestSuite.war -d /tmp/govwayTestSuite.war.tmp'
20:07:14 + sudo su -c 'cp /var/lib/jenkins/workspace/GovWay/protocolli/spcoop/dist/openspcoop2_spcoop-protocol*.jar /tmp/govwayTestSuite.war.tmp/WEB-INF/lib/'
20:07:14 + sudo su -c 'cp /var/lib/jenkins/workspace/GovWay/protocolli/trasparente/dist/openspcoop2_trasparente-protocol*.jar /tmp/govwayTestSuite.war.tmp/WEB-INF/lib/'
20:07:14 + sudo su -c 'rm -f /tmp/govwayTestSuite.war.tmp/WEB-INF/lib/openspcoop2_utils-test*.jar'
20:07:14 + sudo su -c 'rm -f /tmp/govwayTestSuite.war.tmp/WEB-INF/lib/openspcoop2_pdd-test*.jar'
20:07:15 + sudo su -c 'pushd /tmp/govwayTestSuite.war.tmp/; zip -rq /tmp/govwayTestSuite.war *; popd'
20:07:15 /tmp/govwayTestSuite.war.tmp /var/lib/jenkins/workspace/GovWay
20:07:17 /var/lib/jenkins/workspace/GovWay
20:07:17 + echo 'Predisposizione jar di protocolli in govwayTestSuite.war effettuata'
20:07:17 Predisposizione jar di protocolli in govwayTestSuite.war effettuata
20:07:17 + echo 'Predispongo govwayTestSuite.war su Tomcat ...'
20:07:17 Predispongo govwayTestSuite.war su Tomcat ...
20:07:17 + sudo su -c 'rm -rf /opt/apache-tomcat-9.0.91/webapps/govwayTestSuite.war'
20:07:17 + sudo su -c 'rm -rf /opt/apache-tomcat-9.0.91/webapps/govwayTestSuite'
20:07:17 + sudo su -c 'cp /tmp/govwayTestSuite.war /opt/apache-tomcat-9.0.91/webapps/'
20:07:17 + sudo su -c 'chown -R tomcat.tomcat /opt/apache-tomcat-9.0.91/webapps/govwayTestSuite.war'
20:07:17 + sudo su -c 'rm -rf /tmp/govwayTestSuite.war.tmp'
20:07:17 + sudo su -c 'rm -f /tmp/govwayTestSuite.war'
20:07:18 + echo 'Predispongo govwayTestSuite.war su Tomcat ok'
20:07:18 Predispongo govwayTestSuite.war su Tomcat ok
20:07:18 + echo 'Predispongo govwayTestSuite come libreria per i test ...'
20:07:18 Predispongo govwayTestSuite come libreria per i test ...
20:07:18 + cd /var/lib/jenkins/workspace/GovWay/testsuite
20:07:18 + sed -i -e s#/var/govway/log#/var/log/govway_testsuite#g deploy/properties_xml2Backend/xml2backend.log4j2.properties
20:07:18 + sed -i -e s#/var/govway/log#/var/log/govway_testsuite#g deploy/properties/log4j2.properties
20:07:18 + sed -i -e s#/var/govway/log#/var/log/govway_testsuite#g deploy/properties/testsuite.log4j2.properties
20:07:18 + echo 'Predispongo govwayTestSuite come libreria per i test ok'
20:07:18 Predispongo govwayTestSuite come libreria per i test ok
20:07:18 + echo 'Predispongo tempi alti di generazione delle statistiche per i test ...'
20:07:18 Predispongo tempi alti di generazione delle statistiche per i test ...
20:07:18 + sudo su -c 'echo '\''org.openspcoop2.pdd.statistiche.generazione.baseOraria.timer.intervalloSecondi=36000'\'' >> /etc/govway/govway_local.properties'
20:07:18 + sudo su -c 'echo '\''org.openspcoop2.pdd.statistiche.generazione.baseGiornaliera.timer.intervalloSecondi=36000'\'' >> /etc/govway/govway_local.properties'
20:07:18 + sudo su -c 'echo '\''org.openspcoop2.pdd.statistiche.generazione.baseSettimanale.timer.intervalloSecondi=36000'\'' >> /etc/govway/govway_local.properties'
20:07:18 + sudo su -c 'echo '\''org.openspcoop2.pdd.statistiche.generazione.baseMensile.timer.intervalloSecondi=36000'\'' >> /etc/govway/govway_local.properties'
20:07:18 + echo 'Predispongo tempi alti di generazione delle statistiche per i test ok'
20:07:18 Predispongo tempi alti di generazione delle statistiche per i test ok
20:07:18 [Boolean condition] checking [true] against [^(1|y|yes|t|true|on|run)$] (origin token: ${GOVWAY_TEST_INTEGRAZIONE_BYOK})
20:07:18 Run condition [Boolean condition] enabling perform for step [BuilderChain]
20:07:18 [GovWay] $ /bin/bash /tmp/jenkins5656535611915817207.sh
20:07:18 Fermo application server ...
20:07:18 [00;31mTomcat is not running[00m
20:07:18 Fermo application server effettuato
20:07:18 Predispongo Testsuite per byok ...
20:07:18 - properties
20:07:18 - predispongo ambiente di test
20:07:18 - jks jose ...
20:07:19 - jks ...
20:07:19 - jks (xca) ...
20:07:19 - jwk ...
20:07:19 - jwk (truststore) ...
20:07:19 - jwk testPrivate/Public ...
20:07:20 - tool govway-vault-cli
20:07:20 - tool config-loader
20:07:20 - init db per proprieta' cifrate
20:07:20 DELETE 0
20:07:20 INSERT 0 1
20:07:20 - predispongo pacchetto testService
20:07:20 [testService] $ /var/lib/jenkins/tools/hudson.tasks.Ant_AntInstallation/ant-1.10.6/bin/ant -file build.xml -Das=tomcat9 clean build
20:07:20 Buildfile: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build.xml
20:07:21
20:07:21 check_as_version:
20:07:21
20:07:21 clean:
20:07:21
20:07:21 init_compile:
20:07:21 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build
20:07:21 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/dist
20:07:21
20:07:21 compile:
20:07:21 [javac] Compiling 5 source files to /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build
20:07:24
20:07:24 build:
20:07:24 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build/example
20:07:24 [war] Building war: /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/dist/TestService.war
20:07:26 [delete] Deleting directory /var/lib/jenkins/workspace/GovWay/example/pdd/server/testService/build/example
20:07:26
20:07:26 BUILD SUCCESSFUL
20:07:26 Total time: 5 seconds
20:07:26 [testsuite] $ /var/lib/jenkins/tools/hudson.tasks.Ant_AntInstallation/ant-1.10.6/bin/ant -file build.xml clean build
20:07:26 Buildfile: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build.xml
20:07:27
20:07:27 clean:
20:07:27
20:07:27 clean:
20:07:27
20:07:27 init:
20:07:27 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
20:07:27
20:07:27 build:
20:07:27 [javac] Compiling 8 source files to /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
20:07:29 [copy] Copying 9 files to /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
20:07:29 [copy] Copied 3 empty directories to 2 empty directories under /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build
20:07:29
20:07:29 BUILD SUCCESSFUL
20:07:29 Total time: 3 seconds
20:07:29 [GovWay] $ /bin/bash /tmp/jenkins13814155781354519198.sh
20:07:29 Predispongo TestService.war ...
20:07:29 Predispongo TestService.war ok
20:07:29 Predispongo testsuite BYOK ...
20:07:30 Predispongo testsuite BYOK ok
20:07:30 Riavvio application server ...
20:07:30 [00;32mStarting tomcat[00m
20:07:30 Tomcat started.
20:07:30 [00;32mTomcat is running with pid: 17849[00m
20:07:30
20:07:30 Attendo che GovWay sia completamente riavviato (timeout 120sec)
20:07:30 .
20:07:31 .
20:08:45 .
20:08:46 .
20:08:47 .
20:08:48 GovWay è tornato operativo
20:08:48 Attendo 15 secondi prima di aggiornare certificati HSM ...
20:09:03 [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
20:09:03 Buildfile: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build.xml
20:09:04
20:09:04 run_test:
20:09:04 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/risultati-testsuite
20:09:04 [mkdir] Created dir: /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/log
20:09:04 [echo] Caricamento configurazione in corso (delete) ...
20:09:15 [java] Exception in thread "main" org.openspcoop2.utils.UtilsException: Rilevata precedente esecuzione di 'delete config' fallita: Error found in log file '/etc/govway/govway-config-loader/log/govway_cli_configLoader_sql.log': ERROR <08-01-2025 20:09:12> org.openspcoop2.web.ctrlstat.core.ControlStationCore.logError(301): Errore di inizializzazione: Inizializzazione auditManager non riuscita: InizializzazioneFallita: Inizializzazione appender[dbAppender] non riuscita: Name [java:/comp/env/org.govway.datasource.console] is not b
20:09:15 [java] at org.openspcoop2.pdd.config.vault.cli.testsuite.ConfigLoader.checkExternalToolError(ConfigLoader.java:342)
20:09:15 [java] at org.openspcoop2.pdd.config.vault.cli.testsuite.ConfigLoader.deleteConfig(ConfigLoader.java:406)
20:09:15 [java] at org.openspcoop2.pdd.config.vault.cli.testsuite.ConfigLoader.main(ConfigLoader.java:228)
20:09:15
20:09:15 BUILD FAILED
20:09:15 /var/lib/jenkins/workspace/GovWay/tools/command_line_interfaces/govway_vault/testsuite/build.xml:226: Java returned: 1
20:09:15
20:09:15 Total time: 11 seconds
20:09:15 Build step 'Conditional steps (multiple)' marked build as failure
20:09:15 INFO: Processing JUnit
20:09:15 ERROR: Step ‘Publish xUnit test result report’ failed: [JUnit] - No 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'.
20:09:15 Did you enter a pattern relative to (and within) the workspace directory?
20:09:15 Did you generate the result report(s) for 'JUnit'?"
20:09:15 TestNG Reports Processing: START
20:09:15 Looking for TestNG results report in workspace using pattern: **/testng-results.xml
20:09:15 Saving reports...
20:09:15 Processing '/var/lib/jenkins/jobs/GovWay/builds/1171/testng/testng-results-1.xml'
20:09:15 Processing '/var/lib/jenkins/jobs/GovWay/builds/1171/testng/testng-results-2.xml'
20:09:15 Processing '/var/lib/jenkins/jobs/GovWay/builds/1171/testng/testng-results-3.xml'
20:09:15 Processing '/var/lib/jenkins/jobs/GovWay/builds/1171/testng/testng-results.xml'
20:09:15 TestNG Reports Processing: FINISH
20:09:15 Collecting Dependency-Check artifact
20:09:15 Parsing file /var/lib/jenkins/workspace/GovWay/dependency-check-result/dependency-check-report.xml
20:09:16 [SpotBugsZed Attack Proxy (ZAP)] Skipping execution of recorder since overall result is 'FAILURE'
20:09:16 Started calculate disk usage of build
20:09:16 Finished Calculation of disk usage of build in 0 seconds
20:09:16 Started calculate disk usage of workspace
20:09:16 Finished Calculation of disk usage of workspace in 0 seconds
20:09:16 Finished: FAILURE
![[Jenkins]](/govway/static/8980f668/images/svgs/logo.svg){kind=logo}
