Replacing environment values with dummy values in the Validate Info window does not work for timestamps

Description

Steps to Reproduce the Issue

  1. Go to the System Tenant

  2. 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");

Environment

None

Activity

Fixed

Details

Assignee

Reporter

Fix versions

Priority

Created February 6, 2025 at 5:45 AM
Updated May 1, 2025 at 10:26 PM
Resolved March 14, 2025 at 4:11 PM