From torque-dev-return-13112-apmail-db-torque-dev-archive=db.apache.org@db.apache.org Tue Apr 15 15:23:52 2014 Return-Path: X-Original-To: apmail-db-torque-dev-archive@www.apache.org Delivered-To: apmail-db-torque-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 0139811DBF for ; Tue, 15 Apr 2014 15:23:52 +0000 (UTC) Received: (qmail 25061 invoked by uid 500); 15 Apr 2014 15:23:51 -0000 Delivered-To: apmail-db-torque-dev-archive@db.apache.org Received: (qmail 24987 invoked by uid 500); 15 Apr 2014 15:23:50 -0000 Mailing-List: contact torque-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Help: List-Post: List-Id: "Apache Torque Developers List" Reply-To: "Apache Torque Developers List" Delivered-To: mailing list torque-dev@db.apache.org Received: (qmail 24920 invoked by uid 99); 15 Apr 2014 15:23:50 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Apr 2014 15:23:50 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of minfrin@sharp.fm designates 174.143.229.200 as permitted sender) Received: from [174.143.229.200] (HELO chandler.sharp.fm) (174.143.229.200) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 15 Apr 2014 15:23:43 +0000 Received: from chandler.sharp.fm (localhost [127.0.0.1]) by chandler.sharp.fm (Postfix) with ESMTP id D5CA7C8313 for ; Tue, 15 Apr 2014 10:23:22 -0500 (CDT) Received: from [10.100.174.17] (unknown [84.233.131.98]) (using TLSv1 with cipher AES128-SHA (128/128 bits)) (Client did not present a certificate) (Authenticated sender: minfrin@sharp.fm) by chandler.sharp.fm (Postfix) with ESMTP id 60AD078038 for ; Tue, 15 Apr 2014 10:23:22 -0500 (CDT) From: Graham Leggett Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Subject: Strange missing spaces in a Criteria based query Message-Id: <2A5026F1-8887-4296-81AD-75FB154F3BE9@sharp.fm> Date: Tue, 15 Apr 2014 17:23:17 +0200 To: Apache Torque Developers List Mime-Version: 1.0 (Mac OS X Mail 6.6 \(1510\)) X-Mailer: Apple Mail (2.1510) X-Virus-Scanned: ClamAV using ClamSMTP X-Virus-Checked: Checked by ClamAV on apache.org Hi all, I am having some bizarre behaviour from torque v3.3. On a specific = machine (RHEL6, Java SE 7u51), an attempt to generate a query from a = Criteria object using a join results in the bogus query below, notice = the missing spaces between "payment_note", "JOIN", and "note": Criteria:: note.effective_date<=3D>note.effective_date<=3D'2014-04-15 = 17:13:06': payment_note.description<=3D>upper(payment_note.description) = LIKE '%LOM104%': =20 Current Query SQL (may not be complete or applicable): SELECT = UPPER(payment_note.serial) FROM payment_noteJOINnote ON = payment_note.note_id=3Dnote.note_id WHERE = note.effective_date<=3D'2014-04-15 17:13:06' AND = upper(payment_note.description) LIKE '%LOM104%' ORDER BY = UPPER(payment_note.serial) DESC [ERROR] AccountingPaymentNoteIndexAction - While trying to search for = payment notes from the database, an exception was thrown. = org.apache.torque.TorqueException: = org.postgresql.util.PSQLException: ERROR: syntax error at or near "ON" Position: 387 On a dev machine (running MacOSX 10.8.5) the query builds fine. Anyone seen anything like this before? Regards, Graham -- --------------------------------------------------------------------- To unsubscribe, e-mail: torque-dev-unsubscribe@db.apache.org For additional commands, e-mail: torque-dev-help@db.apache.org