[jira] [Created] (FLINK-31091) SQL interval related queries stop working via SQL client

["Sergey Nuyanzin (Jira)" <ji...@apache.org>]

Sergey Nuyanzin created FLINK-31091:
---------------------------------------

             Summary: SQL interval related queries stop working via SQL client
                 Key: FLINK-31091
                 URL: https://issues.apache.org/jira/browse/FLINK-31091
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / Client
            Reporter: Sergey Nuyanzin


I put blocker since it works in 1.16.x and stopped working in 1.17 after a certain commit

Any interval related query run via SQL Client is failing with 

{noformat}
[ERROR] Could not execute SQL statement. Reason:
org.apache.flink.runtime.rest.util.RestClientException: [Internal server error. Could not map response to JSON.]
	at org.apache.flink.runtime.rest.RestClient.parseResponse(RestClient.java:536)
	at org.apache.flink.runtime.rest.RestClient.lambda$submitRequest$3(RestClient.java:516)
	at java.util.concurrent.CompletableFuture.uniCompose(CompletableFuture.java:966)
	at java.util.concurrent.CompletableFuture$UniCompose.tryFire(CompletableFuture.java:940)
	at java.util.concurrent.CompletableFuture$Completion.run(CompletableFuture.java:456)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:750)

{noformat}

example of query
{code:sql}
SELECT INTERVAL '2' DAY;
SELECT 1, INTERVAL '2' YEAR;
{code}

based on tests it stopped working after this commit 
https://issues.apache.org/jira/browse/FLINK-29945

//cc [~fsk119]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)