Return-Path: <oracle-l-bounce@freelists.org>
X-Original-To: oracle-l@orafaq.com
Delivered-To: oracle-l@orafaq.com
Received: from turing.freelists.org (turing.freelists.org [206.53.239.180])
 by malta2546.startdedicated.com (Postfix) with ESMTPS id 78944100333EC0
 for <oracle-l@orafaq.com>; Wed,  8 Aug 2018 02:08:59 +0200 (CEST)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 447AE28469;
 Tue,  7 Aug 2018 20:08:58 -0400 (EDT)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org;
 s=turing; t=1533686938;
 bh=9A7kWcFmFSmWUTEsA1BYk5nDJrcx2lmRxfhT0OMuAkQ=;
 h=References:In-Reply-To:From:Date:Subject:To:Cc:Reply-To:List-help:
	 List-unsubscribe:List-Id:List-subscribe:List-owner:List-post:
	 List-archive;
 b=IOUnNw33JjjPma8uiojb1GIiz5Dg2AF61/vRiH6Wn2QvMp6HgpeDT+9yjQ/at/98l
	 FSIDeDe9q7GC24nMBANWHqBYdMOVGWYVNKwEBmaTi3YDezij3RdRo0OkOcx9uJGvTs
	 +lvSh6f63ddSThwTVipbMcYRnOaaQNCcAIZaLkCM=
X-Virus-Scanned: Debian amavisd-new at turing.freelists.org
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id E6fuckyAKyPZ; Tue,  7 Aug 2018 20:08:58 -0400 (EDT)
Received: from turing.freelists.org (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2CAE82825E;
 Tue,  7 Aug 2018 20:08:42 -0400 (EDT)
DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=freelists.org;
 s=turing; t=1533686934;
 bh=9A7kWcFmFSmWUTEsA1BYk5nDJrcx2lmRxfhT0OMuAkQ=;
 h=References:In-Reply-To:From:Date:Subject:To:Cc:Reply-To:List-help:
	 List-unsubscribe:List-Id:List-subscribe:List-owner:List-post:
	 List-archive;
 b=i+KBAsyv1HmfMMQJD56NToSZyyoYdnmqsTxNrJyoSt+sC4svDgZ0ueS0R2TY1ZZY7
	 A+qHIQvjrs3tpjRTn85IWoheHN+d8cQI2VSrmnile99wZyovgzpZRrL1GaWGNddmnx
	 ZcXfTIGdXYkPd83SG439rDMGWd56Dtw3gopH1uTA=
Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 07 Aug 2018 20:07:20 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 54A6C283D3
 for <oracle-l@freelists.org>; Tue,  7 Aug 2018 20:07:20 -0400 (EDT)
Authentication-Results: turing.freelists.org; dkim=pass
 reason="2048-bit key; unprotected key"
 header.d=gmail.com header.i=@gmail.com header.b=IRzhiKwN;
 dkim-adsp=pass; dkim-atps=neutral
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id uOA90FJb2-w8 for <oracle-l@freelists.org>;
 Tue,  7 Aug 2018 20:07:20 -0400 (EDT)
Received: from mail-oi0-f52.google.com (mail-oi0-f52.google.com [209.85.218.52])
 (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits))
 (No client certificate requested)
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTPS id 27268282D9
 for <oracle-l@freelists.org>; Tue,  7 Aug 2018 20:07:19 -0400 (EDT)
Received: by mail-oi0-f52.google.com with SMTP id 13-v6so814876ois.1;
        Tue, 07 Aug 2018 17:07:19 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20161025;
        h=x-gm-message-state:mime-version:references:in-reply-to:from:date
         :message-id:subject:to:cc;
        bh=DtPYaWZm7Z9Kwyz5+hnVXZVnMI+3vm9Br+cKdN4Ob1g=;
        b=Fbk4Hn7sjb9L/6RENBi5pL3dXLlK1LrErgi1Jr4sxL6jjrYH6L4lRRu4+J14P4Ty6R
         LT4g5Ll9uYCZAwu9SILER4vY6hP8iAjjIPXPLM6FMy2tRHzAd7fQPQPUe3lgNn1PMhHt
         VSuQoEHLH2YGR2XN9T6UyVzPpJELYa8rrjXPBq98dJqdNUGGHnPXyvS8iTvAuVcrfwhX
         eOD1oQSCJcLT3QD7m9Ar9knrZ6gMySPhVu7EVgGI+weghQAF/LqMj0yhrC6gGtwpNWNn
         YUkGKAJxk+fQuiJuZDMCZ/uYVQdOXg8ci/gGh1wLYmia9GMN0OW5Wqw0tV9JhwqWQzyE
         BP6w==
X-Gm-Message-State: AOUpUlFeT1ntG/YYFX2gBJui2TiSWPBswgRLZb7sTVqOoi6gB9dDgu2O
 cmVvE+qzJYa8iKNSKebzy+2cI+O4pQ1n+Ua///A=
X-Google-Smtp-Source: AA+uWPySJp8dcGYAWB4uQxkCzvVEIxBWciEqsDNinH9XWbCIVxKkK9bfmAzXHsvfxDI18XkEA61k7eKz2EWNdfCXvDY=
X-Received: by 2002:aca:ceca:: with SMTP id e193-v6mr573536oig.37.1533686839422;
 Tue, 07 Aug 2018 17:07:19 -0700 (PDT)
MIME-Version: 1.0
References: <CAL2aWL4PpdSueJDO6GHdhdxwOcLa_epjpNnLdYWt_NNnnW1exw@mail.gmail.com>
 <trinity-3b2d1275-49f8-4cef-bf0e-9ec28e75bed0-1533660833767@3c-app-webde-bs38>
 <CAL2aWL7W9wJ+h+ApoxEtmVvpFG9H3gmuzpm5DoQ5hryinbF=-A@mail.gmail.com>
 <CAA_xQWq6WPGY7-A-TgNVFQuvRDJA_6ZinAQcyF6aMjRE8af7AQ@mail.gmail.com> <CACj1VR6Lhj8BCAKi+E2XLFKZzWw1cqS9bWZ9FjMVwJdfMBSmqQ@mail.gmail.com>
In-Reply-To: <CACj1VR6Lhj8BCAKi+E2XLFKZzWw1cqS9bWZ9FjMVwJdfMBSmqQ@mail.gmail.com>
From: Sayan Malakshinov <xt.and.r@gmail.com>
Date: Tue, 7 Aug 2018 20:07:06 -0400
Message-ID: <CAOVevU5WY7ViOtbMacAJ78th45Nq6kqBs4qzLYsFHKQ26mx_eA@mail.gmail.com>
Subject: Re: Group by wrong results?
To: Andy Sayer <andysayer@gmail.com>
Cc: getsach@gmail.com, dmarc-noreply@freelists.org, rogel@web.de,
 ORACLE-L <oracle-l@freelists.org>
Content-Type: multipart/alternative; boundary="00000000000042b4dc0572e14b86"
X-archive-position: 72039
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: xt.and.r@gmail.com
Precedence: normal
Reply-To: xt.and.r@gmail.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
--00000000000042b4dc0572e14b86
Content-Type: text/plain; charset="UTF-8"

Hi Daniel,

It seems like like this bug:
https://jonathanlewis.wordpress.com/2014/09/04/group-by-bug/amp/


Best regards,
Sayan Malakshinov
http://orasql.org

--00000000000042b4dc0572e14b86
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"auto">Hi Daniel,<div dir=3D"auto"><br></div><div dir=3D"auto">I=
t seems like like this bug:=C2=A0<a href=3D"https://jonathanlewis.wordpress=
.com/2014/09/04/group-by-bug/amp/">https://jonathanlewis.wordpress.com/2014=
/09/04/group-by-bug/amp/</a></div><div class=3D"gmail_quote" dir=3D"auto"><=
div dir=3D"ltr"><br></div><div dir=3D"ltr"><br></div><div dir=3D"ltr">Best =
regards,=C2=A0</div><div dir=3D"ltr">Sayan Malakshinov=C2=A0</div><div dir=
=3D"ltr"><a href=3D"http://orasql.org">http://orasql.org</a>=C2=A0</div></d=
iv></div>

--00000000000042b4dc0572e14b86--
--
http://www.freelists.org/webpage/oracle-l


