Return-Path: X-Original-To: archive-asf-public-internal@cust-asf2.ponee.io Delivered-To: archive-asf-public-internal@cust-asf2.ponee.io Received: from cust-asf.ponee.io (cust-asf.ponee.io [163.172.22.183]) by cust-asf2.ponee.io (Postfix) with ESMTP id F139B200C1B for ; Tue, 14 Feb 2017 18:15:05 +0100 (CET) Received: by cust-asf.ponee.io (Postfix) id EFC56160B5F; Tue, 14 Feb 2017 17:15:05 +0000 (UTC) Delivered-To: archive-asf-public@cust-asf.ponee.io Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by cust-asf.ponee.io (Postfix) with SMTP id 468A4160B45 for ; Tue, 14 Feb 2017 18:15:05 +0100 (CET) Received: (qmail 65541 invoked by uid 500); 14 Feb 2017 17:15:04 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 65521 invoked by uid 99); 14 Feb 2017 17:15:03 -0000 Received: from pnap-us-west-generic-nat.apache.org (HELO spamd4-us-west.apache.org) (209.188.14.142) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 14 Feb 2017 17:15:03 +0000 Received: from localhost (localhost [127.0.0.1]) by spamd4-us-west.apache.org (ASF Mail Server at spamd4-us-west.apache.org) with ESMTP id 45712C0D33 for ; Tue, 14 Feb 2017 17:15:03 +0000 (UTC) X-Virus-Scanned: Debian amavisd-new at spamd4-us-west.apache.org X-Spam-Flag: NO X-Spam-Score: -0.82 X-Spam-Level: X-Spam-Status: No, score=-0.82 tagged_above=-999 required=6.31 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=-0.01, RCVD_IN_MSPIKE_WL=-0.01, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=disabled Authentication-Results: spamd4-us-west.apache.org (amavisd-new); dkim=pass (1024-bit key) header.d=objectstyle.org header.b=SybTN2+g; dkim=pass (1024-bit key) header.d=messagingengine.com header.b=N4IsnEDC Received: from mx1-lw-eu.apache.org ([10.40.0.8]) by localhost (spamd4-us-west.apache.org [10.40.0.11]) (amavisd-new, port 10024) with ESMTP id hI3PtIoSSd28 for ; Tue, 14 Feb 2017 17:15:01 +0000 (UTC) Received: from out4-smtp.messagingengine.com (out4-smtp.messagingengine.com [66.111.4.28]) by mx1-lw-eu.apache.org (ASF Mail Server at mx1-lw-eu.apache.org) with ESMTPS id C4B345F659 for ; Tue, 14 Feb 2017 17:15:00 +0000 (UTC) Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.nyi.internal (Postfix) with ESMTP id 191BC20D97 for ; Tue, 14 Feb 2017 12:14:54 -0500 (EST) Received: from frontend1 ([10.202.2.160]) by compute3.internal (MEProxy); Tue, 14 Feb 2017 12:14:54 -0500 DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d=objectstyle.org; h=content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc:x-sasl-enc; s=mesmtp; bh=LVKBn4O+qUsfDk6 NHX6Kshm4BHo=; b=SybTN2+g9yINtOkvcplWsltws7K9mu+jr9Ka1UrSfZFFudA dP2L6LWoxXrqg4ApWyrknOV4TeUL9d0DAjpHMAYbRGdraQLgn9CdkxSUvPFky+BH VBtCLNy4nHNuB/qk0QKONYHATFY9qHsK9CVyF0veamtsii8HTtaDxbmB6nQE= DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; d= messagingengine.com; h=content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc:x-sasl-enc; s= smtpout; bh=LVKBn4O+qUsfDk6NHX6Kshm4BHo=; b=N4IsnEDCkUSFrHYtZwo0 qgIhlELvuUTEPbUuB/rez4fKuc1hqYwGFzDWu1S4cvPag9EN2rF28z3Dq0sMah0Y 32QEM8zV8zy0FQUfmBQouZQqRNjN1ZEU3C4s0DTp0HQ0Ws7BzT4BJH5Na4qqCT4e xORanMLoko5d3HMorz5bg/c= X-ME-Sender: X-Sasl-enc: GqC5GrkAAnCpSj3dS7kuVeZWaLwqdhwZbnFPv8yn28VL 1487092493 Received: from [192.168.2.101] (unknown [212.98.184.210]) by mail.messagingengine.com (Postfix) with ESMTPA id 9862C7E033 for ; Tue, 14 Feb 2017 12:14:53 -0500 (EST) From: Andrus Adamchik Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (Mac OS X Mail 10.2 \(3259\)) Subject: Re: ColumnSelect and distinct Date: Tue, 14 Feb 2017 20:14:49 +0300 References: <201C8AF1-FD8B-42B7-A529-D08149465D10@karlmenn.is> To: user@cayenne.apache.org In-Reply-To: <201C8AF1-FD8B-42B7-A529-D08149465D10@karlmenn.is> Message-Id: X-Mailer: Apple Mail (2.3259) archived-at: Tue, 14 Feb 2017 17:15:06 -0000 We just discussed this with Nikita today. Explicit DISTINCT didn't make = sense in the days of pure object select (as we could guess it during = query translation). But now it does. And the backend actually supports = it. We just need to add public API for it.=20 Andrus > On Feb 14, 2017, at 7:58 PM, Hugi Thordarson wrote: >=20 > Hi all, once again :). >=20 > Playing around a little with the new ColumnSelect API. Can I use = DISTINCT with it? >=20 > Cheers, > - hugi