[Bug]: Mssql data type timestamp mishandled #41268
Description
Is there an existing issue for this?
- I have searched the existing issues
Description
When querying a table including a field of timestamp data type from mssql, it occurs an error:
Your query failed to execute:
The conversion from timestamp to DATE is unsupported.
[SQLSTATE: null]
In Date and time data types and functions (Transact-SQL), it says:
The Transact-SQL rowversion data type isn't a date or time data type. timestamp is a deprecated synonym for rowversion.
Here's the introduction of rowversion (Transact-SQL).
timestamp is a datatype to store binary array. The mssql-plugin tries to convert the timestamp fields into LocalDateTime object, it appearently can't be done.
Steps To Reproduce
- Create a new table (for example, "MyTable" in sql server, including a
timestampfield. - Add this sql server as a data source to your application.
- Create a query of
select * from MyTable, then run it.
Public Sample App
No response
Environment
Release
Severity
High (Blocker to building or releasing)
Issue video log
No response
Version
Self Hosted 1.86