Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id 089B9200BE4 for ; Wed, 21 Dec 2016 15:05:00 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id 072D1160B26; Wed, 21 Dec 2016 14:05:00 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 532B5160B0C for ; Wed, 21 Dec 2016 15:04:59 +0100 (CET) Received: (qmail 16171 invoked by uid 500); 21 Dec 2016 14:04:58 -0000 Mailing-List: contact issues-help@ignite.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@ignite.apache.org Delivered-To: mailing list issues@ignite.apache.org Received: (qmail 16159 invoked by uid 99); 21 Dec 2016 14:04:58 -0000 Received: from arcas.apache.org (HELO arcas) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 Dec 2016 14:04:58 +0000 Received: from arcas.apache.org (localhost [127.0.0.1]) by arcas (Postfix) with ESMTP id 5D5162C0086 for ; Wed, 21 Dec 2016 14:04:58 +0000 (UTC) Date: Wed, 21 Dec 2016 14:04:58 +0000 (UTC) From: "Andrew Mashenkov (JIRA)" To: issues@ignite.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (IGNITE-4247) Table aliases not supported for SqlQuery MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 archived-at: Wed, 21 Dec 2016 14:05:00 -0000 [ https://issues.apache.org/jira/browse/IGNITE-4247?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15767124#comment-15767124 ] Andrew Mashenkov commented on IGNITE-4247: ------------------------------------------ TC test looks good. Can be merged after review > Table aliases not supported for SqlQuery > ---------------------------------------- > > Key: IGNITE-4247 > URL: https://issues.apache.org/jira/browse/IGNITE-4247 > Project: Ignite > Issue Type: Bug > Components: SQL > Affects Versions: 1.7 > Reporter: Valentin Kulichenko > Assignee: Andrew Mashenkov > Fix For: 2.0 > > > Here is the example of the query: > {code} > from Person p where p.salary > ? and p.salary <= ? > {code} > Ignite is not aware of the alias and incorrectly appends the SELECT statement, which causes this exception: > {noformat} > Exception in thread "main" javax.cache.CacheException: Failed to parse query: SELECT "CacheQueryExamplePersons".Person._key, "CacheQueryExamplePersons".Person._val from Person p where salary > ? and salary <= ? > at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:1217) > at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:1123) > at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:813) > at org.apache.ignite.internal.processors.query.GridQueryProcessor$4.applyx(GridQueryProcessor.java:811) > at org.apache.ignite.internal.util.lang.IgniteOutClosureX.apply(IgniteOutClosureX.java:36) > at org.apache.ignite.internal.processors.query.GridQueryProcessor.executeQuery(GridQueryProcessor.java:1760) > at org.apache.ignite.internal.processors.query.GridQueryProcessor.queryTwoStep(GridQueryProcessor.java:811) > at org.apache.ignite.internal.processors.cache.IgniteCacheProxy.query(IgniteCacheProxy.java:733) > at org.apache.ignite.examples.datagrid.CacheQueryExample.sqlQuery(CacheQueryExample.java:176) > at org.apache.ignite.examples.datagrid.CacheQueryExample.main(CacheQueryExample.java:116) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:606) > at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144) > Caused by: org.h2.jdbc.JdbcSQLException: Column "CacheQueryExamplePersons.PERSON._KEY" not found; SQL statement: > SELECT "CacheQueryExamplePersons".Person._key, "CacheQueryExamplePersons".Person._val from Person p where salary > ? and salary <= ? [42122-191] > at org.h2.message.DbException.getJdbcSQLException(DbException.java:345) > at org.h2.message.DbException.get(DbException.java:179) > at org.h2.message.DbException.get(DbException.java:155) > at org.h2.expression.ExpressionColumn.optimize(ExpressionColumn.java:147) > at org.h2.command.dml.Select.prepare(Select.java:852) > at org.h2.command.Parser.prepareCommand(Parser.java:257) > at org.h2.engine.Session.prepareLocal(Session.java:560) > at org.h2.engine.Session.prepareCommand(Session.java:501) > at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1188) > at org.h2.jdbc.JdbcPreparedStatement.(JdbcPreparedStatement.java:73) > at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:276) > at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.prepareStatement(IgniteH2Indexing.java:410) > at org.apache.ignite.internal.processors.query.h2.IgniteH2Indexing.queryTwoStep(IgniteH2Indexing.java:1201) > ... 14 more > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)