From dev-return-8194-apmail-openjpa-dev-archive=openjpa.apache.org@openjpa.apache.org Wed May 21 01:35:19 2008 Return-Path: Delivered-To: apmail-openjpa-dev-archive@www.apache.org Received: (qmail 70072 invoked from network); 21 May 2008 01:35:19 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 21 May 2008 01:35:19 -0000 Received: (qmail 48088 invoked by uid 500); 21 May 2008 01:35:20 -0000 Delivered-To: apmail-openjpa-dev-archive@openjpa.apache.org Received: (qmail 48063 invoked by uid 500); 21 May 2008 01:35:20 -0000 Mailing-List: contact dev-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@openjpa.apache.org Delivered-To: mailing list dev@openjpa.apache.org Received: (qmail 48052 invoked by uid 99); 21 May 2008 01:35:20 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 20 May 2008 18:35:20 -0700 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 21 May 2008 01:34:34 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 968D3234C118 for ; Tue, 20 May 2008 18:34:55 -0700 (PDT) Message-ID: <13948571.1211333695603.JavaMail.jira@brutus> Date: Tue, 20 May 2008 18:34:55 -0700 (PDT) From: "Catalina Wei (JIRA)" To: dev@openjpa.apache.org Subject: [jira] Created: (OPENJPA-606) InformixDictionary default setting beaks many testcases MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org InformixDictionary default setting beaks many testcases ------------------------------------------------------- Key: OPENJPA-606 URL: https://issues.apache.org/jira/browse/OPENJPA-606 Project: OpenJPA Issue Type: Bug Components: sql Affects Versions: 1.2.0 Reporter: Catalina Wei In testing Informix backend store, there are many query test string failed: 1. parameter of a boolean value does not work, should use 't for true, 'f' for false WHERE (t1.isManager = ?) [params=(boolean) false] should generate WHERE (t1.isManager = ?) [params=(String) f] 2. SELECT COUNT(DISTINCT(t1.name)) reported syntax error [code=-201, state=42000] should generate COUNT(DISTINCT t1.name ) 3. CROSS JOIN syntax error should generate JOIN with ON 1 = 1 4. There is no equivalent function for LOCATE. Informix users must create INSTR as a user defined function. 3. CONCAT function in '||' does not take parameter markers WHERE ((?||t0.name) LIKE ? ESCAPE '\') should generate CONCAT(?, t0.name) -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.