Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qXkqG-0073zN-P9 for pgsql-bugs@arkaria.postgresql.org; Sun, 20 Aug 2023 15:59:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qXkqF-006CB7-9v for pgsql-bugs@arkaria.postgresql.org; Sun, 20 Aug 2023 15:59:51 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qWvp1-009js7-Rv for pgsql-bugs@lists.postgresql.org; Fri, 18 Aug 2023 09:31:12 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qWvow-000pQ3-Ft for pgsql-bugs@lists.postgresql.org; Fri, 18 Aug 2023 09:31:10 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:Cc:From:To:Subject: MIME-Version:Content-Type:Sender:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=s7EX+v/0muYFdT7bLTpFts3J5ML5JUoIOY714EEeY1g=; b=wHRgyjlUSVOsJUNN4rP56AptBi e7+Yw6hnQY/ItYF5KqpOLa9qRdbkDN3wh3qqhZpvAlItJ4fFMLa0RaRT6fvsVQkajbEJNf8QPREWj m+rxqazUKHmVfPktVhd2/7N2H9HxGFs29444x/1WL/xJzSFFxpHYyb5Y+Skr1MLH+gz1RMhhfM/i1 2lvGdYW3PUsmZBbw4Yuju2h0OWOV77pWNYZPDJmRsEtwnFzvnZS2vCyWTTV4dNs4/n7dtoAPtuqn0 CaRBHkBo4TpMsr2ZTiTkrZ9TuYVCN/O4fC6S8TL5m5n9EQjCnqug5Q6m4nsauD8ClDDoXDrDROxyi wDg9tGKQ==; Received: from wrigleys.postgresql.org ([2a02:c0:301:0:ffff::34]) by mahout.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1qWvou-0005SW-N8 for pgsql-bugs@lists.postgresql.org; Fri, 18 Aug 2023 09:31:04 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qWvor-002ZKN-Fj for pgsql-bugs@lists.postgresql.org; Fri, 18 Aug 2023 09:31:02 +0000 Content-Type: multipart/mixed; boundary="===============1231876924596077376==" MIME-Version: 1.0 Subject: BUG #18060: Left joining rows using random() function in join condition doesn't work as expected. To: pgsql-bugs@lists.postgresql.org From: PG Bug reporting form Cc: james.inform@pharmapp.de Reply-To: james.inform@pharmapp.de, pgsql-bugs@lists.postgresql.org Date: Fri, 18 Aug 2023 09:30:51 +0000 Message-ID: <18060-e59408b5655979ed@postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1231876924596077376== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJzaXRlOgoKQnVnIHJl ZmVyZW5jZTogICAgICAxODA2MApMb2dnZWQgYnk6ICAgICAgICAgIEphbWVzIEluZm9ybQpFbWFp bCBhZGRyZXNzOiAgICAgIGphbWVzLmluZm9ybUBwaGFybWFwcC5kZQpQb3N0Z3JlU1FMIHZlcnNp b246IDE1LjQKT3BlcmF0aW5nIHN5c3RlbTogICBMaW51eCBhbmQgTWFjCkRlc2NyaXB0aW9uOiAg ICAgICAgCgovKg0KICAgIFBvc3RncmVTUUwgMTQuOSAvIDE1LjQgb24gTGludXggYW5kIE1hYw0K ICAgIA0KICAgIExlZnQgam9pbmluZyByb3dzIHVzaW5nIHJhbmRvbSgpIGZ1bmN0aW9uIGluIGpv aW4gY29uZGl0aW9uDQogICAgZG9lc24ndCB3b3JrIGFzIGV4cGVjdGVkLg0KICAgDQogICANCiAg ICBJIGhhdmUgZW5jb3VudGVyZWQgdGhpcyB3aGlsZSBJIHdhcyB0cnlpbmcgcmFuZG9tbHkgbGVm dCBqb2luIGEgcmVjb3JkCm9mIGEgc291cmNlIHRhYmxlDQogICAgd2l0aCBleGFjdGx5IHdpdGgg b25lIHJlY29yZCBvZiBhIGxpbmsgdGFibGUuDQogICAgDQogICAgSnVzdCBleGVjdXRlIHRoZSBj cmVhdGUgc3RhdGVtZW50cyB1bmRlciAxLg0KICAgIA0KICAgIFRoZW4gZXhlY3V0ZSB0aGUgc2Vs ZWN0IHVuZGVyIDIuIG11bHRpcGxlIHRpbWVzIGFuZCB3YXRjaCB0aGVlCnJlc3VsdHMuDQogKi8N Cg0KLS0gMS4gR2VuZXJhdGUgdHdvIHRhYmxlcyAoc291cmNlIGFuZCBsaW5rKSB3aXRoIDEwMDAg cm93cyBoYXZpbmcgZ2FwbGVzcwppZHMNCmNyZWF0ZSB0ZW1wIHRhYmxlIHNvdXJjZSBhcw0Kc2Vs ZWN0IHNvdXJjZV9pZCwgJ3NvdXJjZScgYXMgc291cmNlX25hbWUgZnJvbSBnZW5lcmF0ZV9zZXJp ZXMoMSwxMDAwKSBhcwpzb3VyY2VfaWQNCjsNCg0KY3JlYXRlIHRlbXAgdGFibGUgbGluayBhcw0K c2VsZWN0IGxpbmtfaWQsICdsaW5rJyBhcyBsaW5rX25hbWUgZnJvbSBnZW5lcmF0ZV9zZXJpZXMo MSwxMDAwKSBhcwpsaW5rX2lkDQo7DQoNCi0tIDIuIEV4ZWN1dGUgdGhpcyBxdWVyeSBtdWx0aXBs ZSB0aW1lIGFuZCB5b3Ugd2lsbCBzZWUgcmVzdWx0cyB3aGVyZToNCi0tICogbm8gcm93cyBmcm9t IGxpbmsgYXJlIGpvaW5lZA0KLS0gKiBleHRhY3RseSBvbmUgcm93IGlzIGpvaW5lZA0KLS0gKiBt dWx0aXBsZSByb3dzIGFyZSBqb2luZWQNCg0Kc2VsZWN0ICogZnJvbSBzb3VyY2UgbGVmdCBqb2lu IGxpbmsgb24gbGlua19pZCA9IDEgKyAocmFuZG9tKCkqNTAwKTo6aW50OA0Kb3JkZXIgYnkgMQ0K DQovKg0KSSB3b3VsZCBleHBlY3QgYWx3YXlzIGV4YWN0bHkgb25lIHJvdyB0byBiZSBqb2luZWQu IA0KSW5zdGVhZCBJIGdldCAxLCBub25lIG9yIG11bHRpcGxlLg0KDQpJcyB0aGlzIGFuIGVycm9y IG9yIGFtIEkgZG9pbmcgc29tZXRoaW5nIHdyb25nPw0KKi8KCg== --===============1231876924596077376==--