Steps to Reproduce the Issue
Go to the System Tenant
Add a new Info column with the value of "SQL SELECT" set to invoiceDiscount(1,@payDate@,1)
invoiceDiscount(1,@payDate@,1)
When saving, an error occurs “cannot cast type integer to timestamp without time zone“
cannot cast type integer to timestamp without time zone
Solution
on MInfoWindow.validate
MInfoWindow
validate
replace builder.replace(start, end+1, "0");
builder.replace(start, end+1, "0");
by builder.replace(start, end+1, "null");
builder.replace(start, end+1, "null");
Steps to Reproduce the Issue
Go to the System Tenant
Add a new Info column with the value of "SQL SELECT" set to
invoiceDiscount(1,@payDate@,1)
When saving, an error occurs “
cannot cast type integer to timestamp without time zone
“Solution
on
MInfoWindow
.validate
replace
builder.replace(start, end+1, "0");
by
builder.replace(start, end+1, "null");