We are getting org.apache.calcite.avatica.AvaticaSqlException when using bind parameters in a SQL select statement that contains a UNION ALL. Queries without a UNION ALL work fine.
This is Phoenix 4.9 For example: select a, b, c from TABLE_1 where a = ? union all select a, b, c from TABLE_2 where a = ? Exception: org.apache.calcite.avatica.AvaticaSqlException: Error -1 (00000) : while preparing SQL: ... at org.apache.calcite.avatica.Helper.createException(Helper.java:53) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:329) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:165) ____________________________________________________________ Buckingham Confirms Unfortunate News risingstarnewspaper.com http://thirdpartyoffers.netzero.net/TGL3231/5ac436cae7d1d36ca7070st02vuc