From issues-return-4127-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Sun Jan 20 21:19:10 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 [140.211.11.3]) by mx-eu-01.ponee.io (Postfix) with SMTP id A763C180634 for ; Sun, 20 Jan 2019 21:19:09 +0100 (CET) Received: (qmail 21090 invoked by uid 500); 20 Jan 2019 20:19:08 -0000 Mailing-List: contact issues-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 issues@phoenix.apache.org Received: (qmail 21081 invoked by uid 99); 20 Jan 2019 20:19:08 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd1-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 20 Jan 2019 20:19:08 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd1-us-west.apache.org (ASF Mail Server at spamd1-us-west.apache.org) with ESMTP id 6D0CAC2C79 for ; Sun, 20 Jan 2019 20:19:08 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd1-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -109.501 X-Spam-Level: X-Spam-Status: No, score=-109.501 tagged_above=-999 required=6.31 tests=[ENV_AND_HDR_SPF_MATCH=-0.5, KAM_ASCII_DIVIDERS=0.8, RCVD_IN_DNSWL_MED=-2.3, SPF_PASS=-0.001, USER_IN_DEF_SPF_WL=-7.5, USER_IN_WHITELIST=-100] autolearn=disabled Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd1-us-west.apache.org [10.40.0.7]) (amavisd-new, port 10024) with ESMTP id SIVLF5oc6mcT for ; Sun, 20 Jan 2019 20:19:06 +0000 (UTC) Received: from mailrelay1-us-west.apache.org (mailrelay1-us-west.apache.org [209.188.14.139]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTP id 5EBFC60D95 for ; Sun, 20 Jan 2019 20:12:01 +0000 (UTC) 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 8F3C6E0E87 for ; Sun, 20 Jan 2019 20:12:00 +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 0ED1325673 for ; Sun, 20 Jan 2019 20:12:00 +0000 (UTC) Date: Sun, 20 Jan 2019 20:12:00 +0000 (UTC) From: "Lars Hofhansl (JIRA)" To: issues@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (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:comment-tabpanel&focusedCommentId=16747536#comment-16747536 ] Lars Hofhansl commented on PHOENIX-5104: ---------------------------------------- If we do not have cycles, we can also take it on the next release. This either needs to be fixed or be reverted. The fix is actually not entirely clear to me. It's only safe to use Integer index ids once all clients are rolled forward. So perhaps we turn this on with an option only. Or perhaps we change the encoding such that old clients still can understand what's going on. > 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 > Priority: Blocker > Fix For: 4.15.0 > > > 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.3#76005)