Closed rudyryk closed 1 month ago
It shouldn't be too much effort to add a class specific to this since Python itself doesn't handle it. I'll consider it for 2.2.
I have added the necessary code to support INTERVAL YEAR TO MONTH as requested. If you are able to build from source you can verify that it works for you, too.
This was included in version 2.2.0 which was just released.
As known and described in the official documentation database type
DB_TYPE_INTERVAL_YM
is not supported. But what is unclear is how to mitigate this limitation.For example, when running
SELECT * FROM "MYDB"."SOMETABLE"
an error is thrown:DPY-3007: database type "DB_TYPE_INTERVAL_YM" is not supported
The expected behaviour would be to replace unsupported values with some
UNSUPPORTED
token or justNone
. Otherwise it's becomes impossible to useSELECT *
in case when it's potentially possible to have unsupported types.