[
https://issues.apache.org/jira/browse/FLINK-36303?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ken Geis updated FLINK-36303:
-----------------------------
Description:
I am having trouble with Flink 3.2.0 recognizing my timestamp(0) columns in
PostgreSQL 15.
PostgresDialect code says:
{code:java}
// Define MAX/MIN precision of TIMESTAMP type according to PostgreSQL docs:
// https://www.postgresql.org/docs/12/datatype-datetime.html
private static final int MAX_TIMESTAMP_PRECISION = 6;
private static final int MIN_TIMESTAMP_PRECISION = 1;
{code}
The linked documentation says:
{quote}{{{}time{}}}, {{{}timestamp{}}}, and {{interval}} accept an optional
precision value _{{p}}_ which specifies the number of fractional digits
retained in the seconds field. By default, there is no explicit bound on
precision. The allowed range of _{{p}}_ is from 0 to 6.
{quote}
was:
I am having trouble with Flink 3.2.0 recognizing my timestamp(0) columns in
PostgreSQL 15.
PostgresDialect code says:
{code:java}
// Define MAX/MIN precision of TIMESTAMP type according to PostgreSQL docs:
// https://www.postgresql.org/docs/12/datatype-datetime.html
private static final int MAX_TIMESTAMP_PRECISION = 6;
private static final int MIN_TIMESTAMP_PRECISION = 1;
{code}
The linked documentation says:
{quote}{{{}time{}}}, {{{}timestamp{}}}, and {{interval}} accept an optional
precision value _{{p}}_ which specifies the number of fractional digits
retained in the seconds field. By default, there is no explicit bound on
precision. The allowed range of _{{p}}_ is from 0 to 6.
{quote}
> PostgreSQL timestamp precision 0 not supported
> ----------------------------------------------
>
> Key: FLINK-36303
> URL: https://issues.apache.org/jira/browse/FLINK-36303
> Project: Flink
> Issue Type: Bug
> Components: Connectors / JDBC
> Affects Versions: jdbc-3.2.0
> Reporter: Ken Geis
> Priority: Minor
>
> I am having trouble with Flink 3.2.0 recognizing my timestamp(0) columns in
> PostgreSQL 15.
> PostgresDialect code says:
> {code:java}
> // Define MAX/MIN precision of TIMESTAMP type according to PostgreSQL
> docs:
> // https://www.postgresql.org/docs/12/datatype-datetime.html
> private static final int MAX_TIMESTAMP_PRECISION = 6;
> private static final int MIN_TIMESTAMP_PRECISION = 1;
> {code}
> The linked documentation says:
> {quote}{{{}time{}}}, {{{}timestamp{}}}, and {{interval}} accept an optional
> precision value _{{p}}_ which specifies the number of fractional digits
> retained in the seconds field. By default, there is no explicit bound on
> precision. The allowed range of _{{p}}_ is from 0 to 6.
> {quote}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
