[ https://issues.apache.org/jira/browse/PHOENIX-1695?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Yuming Wang closed PHOENIX-1695. -------------------------------- > Phoenix matching the HBase Bytes.toBytes(int) method cause numerical overflow > ----------------------------------------------------------------------------- > > Key: PHOENIX-1695 > URL: https://issues.apache.org/jira/browse/PHOENIX-1695 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.2.0 > Environment: HBase-0.98+Phoenix-4.2 > Reporter: Yuming Wang > > 1. Put data like below: > HTableInterface tableOrder = connection.getTable(newTableName); > List<Put> puts = new ArrayList<Put>(); > Put put1 = new Put(Bytes.toBytes("1")); > put1.add(DEFAULT_CF, Bytes.toBytes("ID"), Bytes.toBytes(3)); > put1.add(DEFAULT_CF, Bytes.toBytes("NAME"), Bytes.toBytes("Positive")); > puts.add(put1); > Put put2 = new Put(Bytes.toBytes("2")); > put2.add(DEFAULT_CF, Bytes.toBytes("ID"), Bytes.toBytes(-3)); > put2.add(DEFAULT_CF, Bytes.toBytes("NAME"), Bytes.toBytes("Negative")); > puts.add(put2); > tableOrder.put(puts); > 2. Map table as below: > CREATE VIEW T_PC_ORDER30 ( PK VARCHAR PRIMARY KEY, CF.ID INTEGER, CF.NAME > VARCHAR ); > 3.Select data as below > SELECT * FROM T_PC_ORDER30; > But the result is: > 1 -2147483645 Positive > 2 2147483645 Negative -- This message was sent by Atlassian JIRA (v6.3.4#6332)