Return-Path: Delivered-To: apmail-cayenne-dev-archive@www.apache.org Received: (qmail 50003 invoked from network); 11 Jan 2010 11:06:24 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 11 Jan 2010 11:06:24 -0000 Received: (qmail 72446 invoked by uid 500); 11 Jan 2010 11:06:24 -0000 Delivered-To: apmail-cayenne-dev-archive@cayenne.apache.org Received: (qmail 72423 invoked by uid 500); 11 Jan 2010 11:06:24 -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 72413 invoked by uid 99); 11 Jan 2010 11:06:23 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jan 2010 11:06:23 +0000 X-ASF-Spam-Status: No, hits=2.2 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of tkachovaolga@gmail.com designates 209.85.219.209 as permitted sender) Received: from [209.85.219.209] (HELO mail-ew0-f209.google.com) (209.85.219.209) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 11 Jan 2010 11:06:17 +0000 Received: by ewy1 with SMTP id 1so2989860ewy.28 for ; Mon, 11 Jan 2010 03:05:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:in-reply-to:references :date:message-id:subject:from:to:content-type; bh=n3cfMSmpLP270LLl7Gnb2mhcp2ElOlH5K8a0mJ0pumk=; b=Xf/p02+Fu0R8jLMLBRjrAMaB7bpfLHPLVfMGTjeyhux/Bo5x2/LzHbxpgmTSbg+WH3 IGofzXBTuM07hu1jjR9hP52npBBvw9YLq9j8rh6/5W7isBGt4fbF9KWvt2o0L6RExa5M CR2VgVGYiGihH0iEVbhXjy4HEJD+igKdW0UYQ= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; b=HHWGsfYXJ0zh/bS18oaRJ6mrEOT0/J+hGi43ePv/lKq29+twt4vYFK4wk3z1UeL+Ia nPjM4c0fdemh18kBP8dl3Q29ucu7odIA1JlGVlUYW2tjSUdZdc5UzrFYTCewxB7Qhupl Xe+TPgVHVT5aMPcnVR0q7fXZfjksKbQVsP2qU= MIME-Version: 1.0 Received: by 10.216.87.12 with SMTP id x12mr2648388wee.48.1263207954285; Mon, 11 Jan 2010 03:05:54 -0800 (PST) In-Reply-To: <1400565539.143101263119276266.JavaMail.jira@brutus.apache.org> References: <870704935.1262161289532.JavaMail.jira@brutus.apache.org> <1400565539.143101263119276266.JavaMail.jira@brutus.apache.org> Date: Mon, 11 Jan 2010 13:05:54 +0200 Message-ID: <2ad0f7b31001110305y19000a2fm7b6e3f0d10fc9f2c@mail.gmail.com> Subject: Re: [jira] Commented: (CAY-1354) Wrong Types mapping for selected values in Row Queries From: =?KOI8-R?B?78zYx8Eg9MvB3sXXwQ==?= To: dev@cayenne.apache.org Content-Type: multipart/alternative; boundary=0016e6d7e0a9648612047ce18513 --0016e6d7e0a9648612047ce18513 Content-Type: text/plain; charset=ISO-8859-1 I apply the latest patch from this Jira locally and run a test. *Result without the patch* *mysql* - all ok *sqlserver* Failed tests: testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest) testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest) testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest) Tests run: 1986, Failures: 3, Errors: 0, Skipped: 0 *postgres* Failed tests: testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest) testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest) testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest) Tests in error: testNullParameter(org.apache.cayenne.query.EJBQLQueryTest) testBindingForCollection(org.apache.cayenne.access.jdbc.BindDirectiveTest) Tests run: 1986, Failures: 3, Errors: 2, Skipped: 0 *Result with the patch* *mysql* Failed tests: testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest) testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest) testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest) Tests run: 2030, Failures: 3, Errors: 0, Skipped: 0 *sqlserver* Failed tests: testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest) testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest) testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest) testSelectWithRowDescriptor(org.apache.cayenne.access.DataContextProcedureQueryTest) testFetchLimitWithOffset(org.apache.cayenne.query.SelectQueryTest) testDECIMAL(org.apache.cayenne.access.ReturnTypesMappingTest) testDECIMAL2(org.apache.cayenne.access.ReturnTypesMappingTest) testFLOAT(org.apache.cayenne.access.ReturnTypesMappingTest) testNUMERIC(org.apache.cayenne.access.ReturnTypesMappingTest) testNUMERIC2(org.apache.cayenne.access.ReturnTypesMappingTest) testTIMESTAMP(org.apache.cayenne.access.ReturnTypesMappingTest) Tests in error: testBINARY(org.apache.cayenne.access.ReturnTypesMappingTest) testBINARY2(org.apache.cayenne.access.ReturnTypesMappingTest) testVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest) testVARBINARY2(org.apache.cayenne.access.ReturnTypesMappingTest) Tests run: 2030, Failures: 11, Errors: 4, Skipped: 0 *postgres* Failed tests: testSQLTemplateTimestamp(org.apache.cayenne.access.DateTimeTypesTest) testSQLTemplateDate(org.apache.cayenne.access.DateTimeTypesTest) testSQLTemplateTime(org.apache.cayenne.access.DateTimeTypesTest) testSelectWithRowDescriptor(org.apache.cayenne.access.DataContextProcedureQueryTest) testBIGINT(org.apache.cayenne.access.ReturnTypesMappingTest) testBINARY(org.apache.cayenne.access.ReturnTypesMappingTest) testBIT(org.apache.cayenne.access.ReturnTypesMappingTest) testBLOB(org.apache.cayenne.access.ReturnTypesMappingTest) testBOOLEAN(org.apache.cayenne.access.ReturnTypesMappingTest) testCHAR(org.apache.cayenne.access.ReturnTypesMappingTest) testCLOB(org.apache.cayenne.access.ReturnTypesMappingTest) testDATE(org.apache.cayenne.access.ReturnTypesMappingTest) testDECIMAL(org.apache.cayenne.access.ReturnTypesMappingTest) testDOUBLE(org.apache.cayenne.access.ReturnTypesMappingTest) testFLOAT(org.apache.cayenne.access.ReturnTypesMappingTest) testINTEGER(org.apache.cayenne.access.ReturnTypesMappingTest) testLONGVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest) testLONGVARCHAR(org.apache.cayenne.access.ReturnTypesMappingTest) testNUMERIC(org.apache.cayenne.access.ReturnTypesMappingTest) testREAL(org.apache.cayenne.access.ReturnTypesMappingTest) testSMALLINT(org.apache.cayenne.access.ReturnTypesMappingTest) testTIME(org.apache.cayenne.access.ReturnTypesMappingTest) testTIMESTAMP(org.apache.cayenne.access.ReturnTypesMappingTest) testTINYINT(org.apache.cayenne.access.ReturnTypesMappingTest) testVARBINARY(org.apache.cayenne.access.ReturnTypesMappingTest) testVARCHAR(org.apache.cayenne.access.ReturnTypesMappingTest) Tests in error: testNullParameter(org.apache.cayenne.query.EJBQLQueryTest) testBindingForCollection(org.apache.cayenne.access.jdbc.BindDirectiveTest) Tests run: 2030, Failures: 26, Errors: 2, Skipped: 0 2010/1/10 Andrus Adamchik (JIRA) > > [ > https://issues.apache.org/jira/browse/CAY-1354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12798458#action_12798458] > > Andrus Adamchik commented on CAY-1354: > -------------------------------------- > > Next week myself or Olga may try to test this patch in our environment that > includes PostgreSQL and SQLServer (I think the later was causing trouble)... > > > Wrong Types mapping for selected values in Row Queries > > ------------------------------------------------------ > > > > Key: CAY-1354 > > URL: https://issues.apache.org/jira/browse/CAY-1354 > > Project: Cayenne > > Issue Type: Bug > > Components: Core Library > > Affects Versions: 3.1M1 > > Reporter: Evgeny Ryabitskiy > > Assignee: Evgeny Ryabitskiy > > Priority: Critical > > Fix For: 3.1M1 > > > > Attachments: CAY-1354.patch, CAY-1354_TEST.patch, > ReturnTypesMappingTest.java > > > > > > By default every SQL type is mapped to some Java type by modeler. > > I am expecting same behavior in common DataRow queries (without ORM). > > But in fact half of types are not mapped correctly.... > > Attached JUnit test can to explain problem with more details... > > -- > This message is automatically generated by JIRA. > - > You can reply to this email to add a comment to the issue online. > > -- Olga Tkacheva --0016e6d7e0a9648612047ce18513--