[PHOENIX-6606] Cannot use float array data type with PQS client

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Component/s: queryserver
• Assignee: Unassigned
• Reporter: Cong Luo
• Created: 28/Nov/21 12:15
• Updated: 08/Dec/21 10:45

Description

IDE use the PQS client with the 6.0.0, then write and read the float data array got :

case 1 (cannot be written) :

Array t_float = conn.createArrayOf("FLOAT", new Float[] { Float.MIN_VALUE, Float.MAX_VALUE });

pstmt = conn.prepareStatement("upsert into s1.datatype(t_uuid, t_float) values(?, ?)");

pstmt.setArray(2, t_float);

Exception in thread "main" java.sql.SQLException: java.lang.Float cannot be cast to java.lang.Double
    at org.apache.calcite.avatica.Helper.createException(Helper.java:56)
    at org.apache.calcite.avatica.Helper.createException(Helper.java:41)
    at org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:557)
    at org.apache.calcite.avatica.AvaticaPreparedStatement.executeLargeUpdate(AvaticaPreparedStatement.java:152)
    at org.apache.calcite.avatica.AvaticaPreparedStatement.executeUpdate(AvaticaPreparedStatement.java:147) 

 

case 2 (can be written and cannot be read) :

pstmt = conn.prepareStatement("upsert into s1.datatype(t_uuid, t_float) values(?, ARRAY[1.0, 2.0])");

Exception in thread "main" org.apache.calcite.avatica.AvaticaSqlException: Error -1 (00000) : Remote driver error: ClassCastException: (null exception message)     at org.apache.calcite.avatica.Helper.createException(Helper.java:54)     at org.apache.calcite.avatica.Helper.createException(Helper.java:41)     at org.apache.calcite.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:557)     at org.apache.calcite.avatica.AvaticaPreparedStatement.executeQuery(AvaticaPreparedStatement.java:137)