Return-Path: X-Original-To: apmail-cayenne-dev-archive@www.apache.org Delivered-To: apmail-cayenne-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 3D8619625 for ; Mon, 20 Feb 2012 15:40:13 +0000 (UTC) Received: (qmail 29300 invoked by uid 500); 20 Feb 2012 15:40:13 -0000 Delivered-To: apmail-cayenne-dev-archive@cayenne.apache.org Received: (qmail 29252 invoked by uid 500); 20 Feb 2012 15:40:12 -0000 Mailing-List: contact dev-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cayenne.apache.org Delivered-To: mailing list dev@cayenne.apache.org Received: (qmail 29238 invoked by uid 99); 20 Feb 2012 15:40:12 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Feb 2012 15:40:12 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of tkachovaolga@gmail.com designates 209.85.214.43 as permitted sender) Received: from [209.85.214.43] (HELO mail-bk0-f43.google.com) (209.85.214.43) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 20 Feb 2012 15:40:06 +0000 Received: by bkcjg15 with SMTP id jg15so8393039bkc.16 for ; Mon, 20 Feb 2012 07:39:45 -0800 (PST) Received-SPF: pass (google.com: domain of tkachovaolga@gmail.com designates 10.112.84.233 as permitted sender) client-ip=10.112.84.233; Authentication-Results: mr.google.com; spf=pass (google.com: domain of tkachovaolga@gmail.com designates 10.112.84.233 as permitted sender) smtp.mail=tkachovaolga@gmail.com; dkim=pass header.i=tkachovaolga@gmail.com Received: from mr.google.com ([10.112.84.233]) by 10.112.84.233 with SMTP id c9mr6741848lbz.1.1329752385191 (num_hops = 1); Mon, 20 Feb 2012 07:39:45 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=KbjXuq+BdKI1iZEI6zB6SB68f3iWhAbASBf/W/TS5/E=; b=DQz0LDgWHZp8Gy9Ae2EQUcgQg0633KmCjGN0JuTfC+QjYs+DQIGU2iZqdHNzHFyd9K C0Ai9TiDg+qi0apQNqw6fqnX3nCo4hKycMluKh9/s40ETK9UuDI+l3ObYzduv7dwHX+g aWcUxClhgb89b5ZOPu9lzYVdodIWUf3K2QTzc= MIME-Version: 1.0 Received: by 10.112.84.233 with SMTP id c9mr5642069lbz.1.1329752385089; Mon, 20 Feb 2012 07:39:45 -0800 (PST) Received: by 10.112.107.68 with HTTP; Mon, 20 Feb 2012 07:39:45 -0800 (PST) In-Reply-To: References: Date: Mon, 20 Feb 2012 18:39:45 +0300 Message-ID: Subject: Re: Tests result Ingres report From: =?KOI8-R?B?78zYx8Eg9MvB3sXXwQ==?= To: dev@cayenne.apache.org Content-Type: text/plain; charset=ISO-8859-1 we can't fix : a) testSelectEqualsClob(org.apache.cayenne.query.SelectQueryTest) testSelectNotEqualsClob(org.apache.cayenne.query.SelectQueryTest) because Ingres doesn't support LONGVARCHAR comparisions ('like', '=', etc.) INFO: SELECT t0.CLOB_TEST_ID, t0.CLOB_COL FROM CLOB_TEST t0 WHERE t0.CLOB_COL = ? [bind: 1->CLOB_COL:'clob1'] - prepared in 50 ms. Feb 20, 2012 10:59:41 AM org.apache.cayenne.log.CommonsJdbcEventLogger logQueryError INFO: *** error. java.sql.SQLException: line 1, Function '=' is not defined for arguments of type 'long varchar' and 'long varchar'. Explicitly convert its arguments to the desired type(s). at com.ingres.gcf.util.SqlExType.getSqlEx(SqlExType.java:112) at com.ingres.gcf.util.SqlExFactory.get(SqlExFactory.java:96) b) test(org.apache.cayenne.merge.SetPrimaryKeyToDbTest) test(org.apache.cayenne.merge.SetAllowNullToDbTest) test(org.apache.cayenne.merge.SetNotNullToDbTest) test(org.apache.cayenne.merge.ValueForNullTest) I tried with this syntax: (as in example 7 here : http://docs.actian.com/ingres/9.3/sql-reference-guide/2523-examples-alter-table) ALTER TABLE [table_name] ALTER COLUMN [column_name] INTEGER NOT NULL NOT DEFAULT; and it doesn't work. -- Olga Tkacheva