[jira] [Created] (CALCITE-4903) Avatica pads values returned from values-clause to same length

["Magnus Mogren (Jira)" <ji...@apache.org>]

Magnus Mogren created CALCITE-4903:
--------------------------------------

             Summary: Avatica pads values returned from values-clause to same length
                 Key: CALCITE-4903
                 URL: https://issues.apache.org/jira/browse/CALCITE-4903
             Project: Calcite
          Issue Type: Bug
          Components: avatica
    Affects Versions: avatica-1.19.0
            Reporter: Magnus Mogren


When executing a values clause, the avatica driver returns the wrong values.

It seems it checks what value is longest and then pads all other values in the values clause to the same length.

{*}SQL{*}:
{code:java}
select * from (values ('a'),('abcd')){code}
{*}Expected values to be returned{*}:
{{'a'}}
{{'abcd'}}

 

{*}Actual values returned{*}:
{{'a   '}}
{{'abcd'}}

It seems that for some reason the driver thinks the columns for the values-clause should be treated as fixed length CHAR(4) instead of VARCHAR. This is also verified by calling ResultSet.getMetaData().getColumnType(1) for the ResultSet returned when executing the SQL statement. Indeed it returns 1 (java.sql.Types.CHAR)

In my optinion this is a high priority bug since it affects any and all calcite adapters. In my example above no remote call is ever done.



--
This message was sent by Atlassian Jira
(v8.20.1#820001)