Return-Path: Delivered-To: apmail-incubator-open-jpa-dev-archive@locus.apache.org Received: (qmail 47044 invoked from network); 1 Feb 2007 01:23:28 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 1 Feb 2007 01:23:28 -0000 Received: (qmail 6323 invoked by uid 500); 1 Feb 2007 01:23:33 -0000 Delivered-To: apmail-incubator-open-jpa-dev-archive@incubator.apache.org Received: (qmail 6210 invoked by uid 500); 1 Feb 2007 01:23:33 -0000 Mailing-List: contact open-jpa-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: open-jpa-dev@incubator.apache.org Delivered-To: mailing list open-jpa-dev@incubator.apache.org Received: (qmail 6197 invoked by uid 99); 1 Feb 2007 01:23:33 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 31 Jan 2007 17:23:33 -0800 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UPPERCASE_25_50 X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 31 Jan 2007 17:23:25 -0800 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id C17E471429F for ; Wed, 31 Jan 2007 17:23:05 -0800 (PST) Message-ID: <25945631.1170292985790.JavaMail.jira@brutus> Date: Wed, 31 Jan 2007 17:23:05 -0800 (PST) From: "David Wisneski (JIRA)" To: open-jpa-dev@incubator.apache.org Subject: [jira] Closed: (OPENJPA-47) 143 arithmetic unary operator (+,-) gives parsing error In-Reply-To: <14792903.1158626002263.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/OPENJPA-47?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] David Wisneski closed OPENJPA-47. --------------------------------- Resolution: Duplicate duplicate of OPENJPA-26 > 143 arithmetic unary operator (+,-) gives parsing error > ------------------------------------------------------- > > Key: OPENJPA-47 > URL: https://issues.apache.org/jira/browse/OPENJPA-47 > Project: OpenJPA > Issue Type: Bug > Components: query > Environment: windows xp, derby, db2 > Reporter: George Hongell > Attachments: failureEntities.jar > > > 143 unary operator (+,-) gives parsing error > select e from EmpBean e where -(e.salary) >-10; > select e from EmpBean e where -e.salary >-10; > select e, -e.salary , +e.salary from EmpBean e where +e.salary >-10; > [ FAILED 143- bucket = fvtfull, query = select e from EmpBean e where -(e.salary+10) > -10 : > DIFFERENCE-locations based on expected-( > diff at line 2 position 1 EXPECTED [[] ACTUAL [ ] > [( class com.dw.test.EmpBean empid=2 name=andrew salary=13.1 dept=210)] > e > ) > EXPECTED( > TEST143; select e from EmpBean e where -(e.salary+10) > -10 > [( class com.dw.test.EmpBean empid=2 name=andrew salary=13.1 dept=210)] > [( class com.dw.test.EmpBean empid=4 name=george salary=0.0 dept=200)] > [( class com.dw.test.EmpBean empid=1 name=david salary=12.1 dept=210)] > [( class com.dw.test.EmpBean empid=10 name=Catalina Wei salary=0.0 dept=0)] > [( class com.dw.test.EmpBean empid=3 name=minmei salary=15.5 dept=200)] > [( class com.dw.test.EmpBean empid=5 name=ritika salary=0.0 dept=220)] > [( class com.dw.test.EmpBean empid=6 name=ahmad salary=0.0 dept=100)] > [( class com.dw.test.EmpBean empid=7 name=charlene salary=0.0 dept=210)] > [( class com.dw.test.EmpBean empid=8 name=Tom Rayburn salary=0.0 dept=100)] > [( class com.dw.test.EmpBean empid=9 name=harry salary=0.0 dept=210)] > TEST143; 10 tuples) > ACTUAL( > TEST143; select e from EmpBean e where -(e.salary+10) > -10 > e > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ > An error occurred while parsing the query filter 'select e from EmpBean e where -(e.salary+10) > -10'. Error message: <4|false|0.0.0> org.apache.openjpa.kernel.jpql.ParseException: Encountered "- (" at character 31, but expected: ["(", "+", "-", ":", "?", "ABS", "ALL", "AND", "ANY", "AS", "ASC", "AVG", "BETWEEN", "BOTH", "BY", "CONCAT", "COUNT", "CURRENT_DATE", "CURRENT_TIME", "CURRENT_TIMESTAMP", "DELETE", "DESC", "DISTINCT", "EMPTY", "ESCAPE", "EXISTS", "FETCH", "FROM", "GROUP", "HAVING", "IN", "INNER", "IS", "JOIN", "LEADING", "LEFT", "LENGTH", "LIKE", "LOCATE", "LOWER", "MAX", "MEMBER", "MIN", "MOD", "NEW", "NOT", "NULL", "OBJECT", "OF", "OR", "ORDER", "OUTER", "SELECT", "SET", "SIZE", "SOME", "SQRT", "SUBSTRING", "SUM", "TRAILING", "TRIM", "UPDATE", "UPPER", "WHERE", , , , , ]. > TEST143; 1 tuple) ] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.