Update/Insert Timestamp doesn't work with PostgreSQL SQL syntax.

[Shashwat32]

What happened Update/Insert Timestamp doesn't work with PostgreSQL SQL syntax. It throws exception as "org.postgresql.util.PSQLException: ERROR: value is not a timestamp: invalid value provided" That would be the result of incompatibility between SQL syntax in PostgreSQL and immudb - looks like the driver assumes that casts from string to timestamp are implicit.

What you expected to happen PostgreSQL should be able to update/insert timestamp in immudb using SQL syntax.

How to reproduce it (as minimally and precisely as possible)

1. Create one table in immudb.

CREATE TABLE IF NOT EXISTS users ( username VARCHAR[50], created_at TIMESTAMP, PRIMARY KEY (username) );

2. Try inserting one row using immudb4j (Java SDK : 0.9.0.6) and PostgreSQL (Version : 42.2.25) import java.sql.Timestamp;

private final String INSERT_QUERY_USERS = "INSERT INTO USERS (username,created_at) VALUES (?,?)"; String urlForConnection = "jdbc:postgresql://"+url+":"+port+"/"+databaseName+"?sslmode=allow&preferQueryMode=simple"; var connection = DriverManager.getConnection(urlForConnection,"immudb", "immudb"); var client = connection .getClient(); PreparedStatement pstmt = client.prepareStatement(INSERT_QUERY_USERS); pstmt.setString(1,"TestUserName"); pstmt.setTimestamp(2, new Timestamp(System.currentTimeMillis())); pstmt.execute();

Environment

# run immudb 1.2.2 and copy/paste the output here
 ./immudb -d

immudb 2022/03/18 09:56:25 INFO: SQL Engine ready for database 'defaultdb' {replica = false} immudb 2022/03/18 09:56:25 INFO: pgsl server is running at port 5432 immudb 2022/03/18 09:56:25 INFO: Webconsole enabled: 0.0.0.0:8080 immudb 2022/03/18 09:56:25 INFO: Web API server enabled on 0.0.0.0:8080/api (http) You can now use immuadmin and immuclient CLIs to login with the immudb superadmin user and start using immudb. immudb has been started with PID 211 shashwat32@Eternal007:~$ immudb 2022/03/18 10:23:15 ERROR: unable to write error on wire: write tcp 172.19.66.153:5432->172.19.64.1:53826: write: broken pipe immudb 2022/03/18 10:23:15 ERROR: unable to complete error handling: write tcp 172.19.66.153:5432->172.19.64.1:53826: write: broken pipe immudb 2022/03/18 10:23:15 WARNING: connection is closed immudb 2022/03/18 10:28:46 INFO: 1 transaction/s to be indexed at 'data/defaultdb' immudb 2022/03/18 10:34:31 ERROR: unable to write error on wire: write tcp 172.19.66.153:5432->172.19.64.1:54138: write: broken pipe immudb 2022/03/18 10:34:31 ERROR: unable to complete error handling: write tcp 172.19.66.153:5432->172.19.64.1:54138: write: broken pipe immudb 2022/03/18 10:34:31 WARNING: connection is closed

Additional info (any other context about the problem) Tried with all kinds of Timestamps but it doesn't work.