[PHOENIX-2233] Assertion error on query

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 4.5.0
• Labels: phoenix sqlline

Environment

Hadoop Data Platform (HDP) 2.3 VM

• Assignee: Josh Elser
• Reporter: Kevin Liew
• Created: 04/Sep/15 18:42
• Updated: 23/Jan/16 03:09

Description

CREATE TABLE dataTypes
(
int INTEGER,
uint UNSIGNED_INT,
bigint BIGINT,
ulong UNSIGNED_LONG,
tinyint TINYINT,
utinyint UNSIGNED_TINYINT,
smallint SMALLINT,
usmallint UNSIGNED_SMALLINT,
float FLOAT,
ufloat UNSIGNED_FLOAT,
double DOUBLE,
udouble UNSIGNED_DOUBLE,
decimal102 DECIMAL (10,2),
time TIME,
date DATE,
timestamp TIMESTAMP,
utime UNSIGNED_TIME,
udate UNSIGNED_DATE,
utimestamp UNSIGNED_TIMESTAMP,
varchar VARCHAR (255),
char VARCHAR (255),
binary BINARY (1024),
varbinary VARBINARY,

CONSTRAINT pk PRIMARY KEY (int)
);

UPSERT INTO dataTypes values
(
1,
2,
3,
4,
5,
6,
7,
8,
9,
1,
2,
3,
4,
TO_DATE('1992-12-30 12:12:12'),
TO_DATE('1992-12-30 12:12:12'),
TO_DATE('1992-12-30 12:12:12.99999'),
TO_DATE('1992-12-30 12:12:12'),
TO_DATE('1992-12-30 12:12:12'),
TO_DATE('1992-12-30 12:12:12.99999'),
'test',
'test2',
10,
11
);

select * from dataTypes;
java.lang.AssertionError: bad OBJECT
at org.apache.calcite.avatica.util.AbstractCursor.createAccessor(AbstractCursor.java:145)
at org.apache.calcite.avatica.util.AbstractCursor.createAccessors(AbstractCursor.java:69)
at org.apache.calcite.avatica.AvaticaResultSet.execute(AvaticaResultSet.java:187)
at org.apache.calcite.avatica.AvaticaConnection$1.execute(AvaticaConnection.java:470)
at org.apache.calcite.avatica.remote.RemoteMeta.prepareAndExecute(RemoteMeta.java:165)
at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:474)
at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:108)
at org.apache.calcite.avatica.AvaticaStatement.execute(AvaticaStatement.java:120)
at sqlline.Commands.execute(Commands.java:822)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:808)
at sqlline.SqlLine.begin(SqlLine.java:681)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)