You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Kevin Liew (JIRA)" <ji...@apache.org> on 2015/09/04 20:42:46 UTC

[jira] [Created] (PHOENIX-2233) Assertion error on query

Kevin Liew created PHOENIX-2233:
-----------------------------------

             Summary: Assertion error on query
                 Key: PHOENIX-2233
                 URL: https://issues.apache.org/jira/browse/PHOENIX-2233
             Project: Phoenix
          Issue Type: Bug
    Affects Versions: 4.5.0
         Environment: Hadoop Data Platform (HDP) 2.3 VM
            Reporter: Kevin Liew


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)





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)