From dev-return-57638-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Mon Jul 29 02:56:03 2019 Return-Path: X-Original-To: archive-asf-public@cust-asf.ponee.io Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [207.244.88.153]) by mx-eu-01.ponee.io (Postfix) with SMTP id 6C093180671 for ; Mon, 29 Jul 2019 04:56:03 +0200 (CEST) Received: (qmail 8744 invoked by uid 500); 29 Jul 2019 02:56:02 -0000 Mailing-List: contact dev-help@phoenix.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@phoenix.apache.org Delivered-To: mailing list dev@phoenix.apache.org Received: (qmail 8733 invoked by uid 99); 29 Jul 2019 02:56:02 -0000 Received: from mailrelay1-us-west.apache.org (HELO mailrelay1-us-west.apache.org) (209.188.14.139) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 29 Jul 2019 02:56:02 +0000 Received: from jira-lw-us.apache.org (unknown [207.244.88.139]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 78ACBE2F0B for ; Mon, 29 Jul 2019 02:56:01 +0000 (UTC) Received: from jira-lw-us.apache.org (localhost [127.0.0.1]) by jira-lw-us.apache.org (ASF Mail Server at jira-lw-us.apache.org) with ESMTP id 2B0E726620 for ; Mon, 29 Jul 2019 02:56:00 +0000 (UTC) Date: Mon, 29 Jul 2019 02:56:00 +0000 (UTC) From: "Mehdi Salarkia (JIRA)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (PHOENIX-5104) PHOENIX-3547 breaks client backwards compatability MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/PHOENIX-5104?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehdi Salarkia updated PHOENIX-5104: ------------------------------------ Attachment: PHOENIX-5104.4.x-HBase-1.3.v1.patch > PHOENIX-3547 breaks client backwards compatability > -------------------------------------------------- > > Key: PHOENIX-5104 > URL: https://issues.apache.org/jira/browse/PHOENIX-5104 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.15.0 > Reporter: Lars Hofhansl > Assignee: Mehdi Salarkia > Priority: Blocker > Labels: SFDC > Fix For: 4.15.0 > > Attachments: PHOENIX-5104.4.x-HBase-1.3.v1.patch, PHOENIX-5104.patch > > Time Spent: 1h 40m > Remaining Estimate: 0h > > Scenario: > * New 4.15 client > ** {{create table ns1.test (pk1 integer not null, pk2 integer not null, pk3 integer not null, v1 float, v2 float, v3 integer CONSTRAINT pk PRIMARY KEY (pk1, pk2, pk3));}} > ** {{create local index l1 on ns1.test(v1);}} > * Old 4.14.x client > ** {{explain select count\(*) from test t1 where t1.v1 < 0.000001;}} > Result: > {code} > 0: jdbc:phoenix:localhost> explain select count(*) from ns1.test t1 where t1.v1 < 0.000001; > Error: ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had 2 (state=22000,code=201) > java.sql.SQLException: ERROR 201 (22000): Illegal data. Expected length of at least 8 bytes, but had 2 > at org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:494) > at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:150) > at org.apache.phoenix.schema.types.PDataType.checkForSufficientLength(PDataType.java:290) > at org.apache.phoenix.schema.types.PLong$LongCodec.decodeLong(PLong.java:256) > at org.apache.phoenix.schema.types.PLong.toObject(PLong.java:115) > at org.apache.phoenix.schema.types.PLong.toObject(PLong.java:31) > at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:994) > at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:1035) > at org.apache.phoenix.schema.types.PDataType.toObject(PDataType.java:1031) > at org.apache.phoenix.iterate.ExplainTable.appendPKColumnValue(ExplainTable.java:207) > at org.apache.phoenix.iterate.ExplainTable.appendScanRow(ExplainTable.java:282) > at org.apache.phoenix.iterate.ExplainTable.appendKeyRanges(ExplainTable.java:297) > at org.apache.phoenix.iterate.ExplainTable.explain(ExplainTable.java:127) > at org.apache.phoenix.iterate.BaseResultIterators.explain(BaseResultIterators.java:1544) > at org.apache.phoenix.iterate.ConcatResultIterator.explain(ConcatResultIterator.java:92) > at org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.explain(BaseGroupedAggregatingResultIterator.java:103) > at org.apache.phoenix.execute.BaseQueryPlan.getPlanSteps(BaseQueryPlan.java:524) > at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:372) > at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:217) > at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:212) > at org.apache.phoenix.execute.BaseQueryPlan.iterator(BaseQueryPlan.java:207) > at org.apache.phoenix.execute.BaseQueryPlan.getExplainPlan(BaseQueryPlan.java:516) > at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableExplainStatement.compilePlan(PhoenixStatement.java:603) > at org.apache.phoenix.jdbc.PhoenixStatement$ExecutableExplainStatement.compilePlan(PhoenixStatement.java:575) > at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:302) > at org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:291) > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > at org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:290) > ... > {code} -- This message was sent by Atlassian JIRA (v7.6.14#76016)