From dev-return-59604-archive-asf-public=cust-asf.ponee.io@phoenix.apache.org Sat Jan 11 22:21:03 2020 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 624BD18067C for ; Sat, 11 Jan 2020 23:21:03 +0100 (CET) Received: (qmail 96066 invoked by uid 500); 11 Jan 2020 22:21: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 96042 invoked by uid 99); 11 Jan 2020 22:21: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; Sat, 11 Jan 2020 22:21:02 +0000 Received: from jira-he-de.apache.org (static.172.67.40.188.clients.your-server.de [188.40.67.172]) by mailrelay1-us-west.apache.org (ASF Mail Server at mailrelay1-us-west.apache.org) with ESMTP id 89542E2C1A for ; Sat, 11 Jan 2020 22:21:01 +0000 (UTC) Received: from jira-he-de.apache.org (localhost.localdomain [127.0.0.1]) by jira-he-de.apache.org (ASF Mail Server at jira-he-de.apache.org) with ESMTP id 535AA780547 for ; Sat, 11 Jan 2020 22:21:00 +0000 (UTC) Date: Sat, 11 Jan 2020 22:21:00 +0000 (UTC) From: "Lars Hofhansl (Jira)" To: dev@phoenix.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (PHOENIX-5580) Wrong values seen when updating a view for a table that has an index 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-5580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Lars Hofhansl updated PHOENIX-5580: ----------------------------------- Comment: was deleted (was: Hmm... I also see it's using the same plan in both cases: {code} 0: jdbc:phoenix:localhost> explain select /*+ NO_INDEX */ * from v1; +----------------------------------------------------------------------------------------------+-----------------+----------------+--------------+ | PLAN | EST_BYTES_READ | EST_ROWS_READ | EST_INFO_TS | +----------------------------------------------------------------------------------------------+-----------------+----------------+--------------+ | CLIENT 1-CHUNK 1 ROWS 141 BYTES PARALLEL 1-WAY ROUND ROBIN POINT LOOKUP ON 1 KEY OVER TEST1 | 141 | 1 | 0 | +----------------------------------------------------------------------------------------------+-----------------+----------------+--------------+ 1 row selected (0.025 seconds) 0: jdbc:phoenix:localhost> explain select * from v1; +----------------------------------------------------------------------------------------------+-----------------+----------------+--------------+ | PLAN | EST_BYTES_READ | EST_ROWS_READ | EST_INFO_TS | +----------------------------------------------------------------------------------------------+-----------------+----------------+--------------+ | CLIENT 1-CHUNK 1 ROWS 141 BYTES PARALLEL 1-WAY ROUND ROBIN POINT LOOKUP ON 1 KEY OVER TEST1 | 141 | 1 | 0 | +----------------------------------------------------------------------------------------------+-----------------+----------------+--------------+ 1 row selected (0.026 seconds) {code} ) > Wrong values seen when updating a view for a table that has an index > -------------------------------------------------------------------- > > Key: PHOENIX-5580 > URL: https://issues.apache.org/jira/browse/PHOENIX-5580 > Project: Phoenix > Issue Type: Bug > Affects Versions: 4.15.0, 4.14.1, 4.14.3 > Reporter: Swaroopa Kadam > Assignee: Abhishek Singh Chouhan > Priority: Major > Labels: indexing, phoenix-hardening > Fix For: 5.1.0, 4.15.1 > > > {code:sql} > CREATE TABLE IF NOT EXISTS TEST (ID INTEGER NOT NULL PRIMARY KEY, HOST VARCHAR(10)); > CREATE INDEX I ON TEST(HOST); > -- create updatable view (equality condition in where clause) > CREATE VIEW V1 (col1 INTEGER) AS SELECT * FROM TEST WHERE ID=15; > UPSERT INTO V1(ID, HOST, col1) VALUES (15, 'this', 7); > SELECT * FROM TEST; > -- Wrong results, but correct results when using the NO_INDEX hint > {code} -- This message was sent by Atlassian Jira (v8.3.4#803005)