Received: from mail.opentec.com.au ([203.5.51.3]) by hub.org (8.10.1/8.10.1) with ESMTP id e675PuW20793 for ; Fri, 7 Jul 2000 01:25:58 -0400 (EDT) Received: from opentec.com.au (ochre) by mail.opentec.com.au (Sun Internet Mail Server sims.3.5.1999.07.30.00.05.p8) with ESMTP id <0FXB00602BBA6D@mail.opentec.com.au> for pgsql-bugs@postgresql.org; Fri, 7 Jul 2000 15:30:46 +1000 (EST) Date: Fri, 07 Jul 2000 15:34:13 +1000 From: Paul McGarry Subject: Re: [SQL] MAX() of 0 records. To: Tom Lane Cc: pgsql-bugs@postgresql.org Message-id: <39656BD5.801BDEDC@opentec.com.au> MIME-version: 1.0 X-Mailer: Mozilla 4.61 [en] (Win98; I) Content-type: multipart/mixed; boundary="------------BFA25AB610B68E71E4CD3B3E" X-Accept-Language: en References: <396535EF.8132CF80@opentec.com.au> <8477.962940582@sss.pgh.pa.us> X-Archive-Number: 200007/40 This is a multi-part message in MIME format. --------------BFA25AB610B68E71E4CD3B3E Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Tom Lane wrote: > This seems like a backend bug to me, but being an overworked hacker > I'm too lazy to try to reconstruct the scenario from your sketch. > Could I trouble you to submit a formal bug report with a specific, > hopefully compact script that triggers the problem? I've attached it here, along with the output I see. I am running 7.0.2 and the problem occurs on both my x86 Linux and Sparc Solaris installations. In addition to the output attached the postmaster console adds: ==== DEBUG: Last error occured while executing PL/pgSQL function setentrystats DEBUG: line 4 at SQL statement ==== Thanks, -- Paul McGarry mailto:paulm@opentec.com.au Systems Integrator http://www.opentec.com.au Opentec Pty Ltd http://www.iebusiness.com.au 6 Lyon Park Road Phone: (02) 9878 1744 North Ryde NSW 2113 Fax: (02) 9878 1755 --------------BFA25AB610B68E71E4CD3B3E Content-Type: application/x-unknown-content-type-out_auto_file; name="ctidnulltest.out" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="ctidnulltest.out" W3Bvc3RncmVzQGJlZWZjYWtlIGllYnVzaW5lc3NdJCBwc3FsIC1mIGN0aWRu dWxsdGVzdC5zcWwgdGVzdGRiDQpDUkVBVEUNCkNSRUFURQ0KcHNxbDpjdGlk bnVsbHRlc3Quc3FsOjExOiBOT1RJQ0U6ICBDUkVBVEUgVEFCTEUvUFJJTUFS WSBLRVkgd2lsbCBjcmVhdGUgaW1wbGljaXQgaW5kZXggJ2VudHJ5X3BrZXkn IGZvciB0YWJsZSAnZW50cnknDQpDUkVBVEUNCnBzcWw6Y3RpZG51bGx0ZXN0 LnNxbDoxNzogTk9USUNFOiAgQ1JFQVRFIFRBQkxFIHdpbGwgY3JlYXRlIGlt cGxpY2l0IHRyaWdnZXIocykgZm9yIEZPUkVJR04gS0VZIGNoZWNrKHMpDQpD UkVBVEUNCkNSRUFURQ0KQ1JFQVRFDQpJTlNFUlQgODA1NzcgMQ0KcHNxbDpj dGlkbnVsbHRlc3Quc3FsOjM3OiBOT1RJQ0U6ICBDUkVBVEUgVEFCTEUvUFJJ TUFSWSBLRVkgd2lsbCBjcmVhdGUgaW1wbGljaXQgaW5kZXggJ2l0ZW1fcGtl eScgZm9yIHRhYmxlICdpdGVtJw0KcHNxbDpjdGlkbnVsbHRlc3Quc3FsOjM3 OiBOT1RJQ0U6ICBDUkVBVEUgVEFCTEUgd2lsbCBjcmVhdGUgaW1wbGljaXQg dHJpZ2dlcihzKSBmb3IgRk9SRUlHTiBLRVkgY2hlY2socykNCkNSRUFURQ0K Q1JFQVRFDQpDUkVBVEUNCnBzcWw6Y3RpZG51bGx0ZXN0LnNxbDo1NTogRVJS T1I6ICBFeGVjdXRlUGxhbjogKGp1bmspIGBjdGlkJyBpcyBOVUxMIQ0KW3Bv c3RncmVzQGJlZWZjYWtlIGllYnVzaW5lc3NdJCANCg== --------------BFA25AB610B68E71E4CD3B3E Content-Type: application/x-unknown-content-type-sql_auto_file; name="ctidnulltest.sql" Content-Transfer-Encoding: base64 Content-Disposition: inline; filename="ctidnulltest.sql" Q1JFQVRFIEZVTkNUSU9OIHBscGdzcWxfY2FsbF9oYW5kbGVyICgpIFJFVFVS TlMgT1BBUVVFIEFTDQogICAgICAgICAnL3Vzci9sb2NhbC9wZ3NxbC9saWIv cGxwZ3NxbC5zbycgTEFOR1VBR0UgJ0MnOw0KDQpDUkVBVEUgVFJVU1RFRCBQ Uk9DRURVUkFMIExBTkdVQUdFICdwbHBnc3FsJw0KICAgICAgICAgSEFORExF UiBwbHBnc3FsX2NhbGxfaGFuZGxlcg0KICAgICAgICAgTEFOQ09NUElMRVIg J1BML3BnU1FMJzsNCg0KDQpDUkVBVEUgVEFCTEUgZW50cnkoDQoJZW50cnlf aWQgSU5UNCBQUklNQVJZIEtFWQ0KKTsNCg0KQ1JFQVRFIFRBQkxFIGVudHJ5 X3N0YXRzDQooDQoJZW50cnlfaWQgSU5UNCBOT1QgTlVMTCBSRUZFUkVOQ0VT IGVudHJ5IE9OIERFTEVURSBDQVNDQURFLA0KCWVudHJ5X21pbnByaWNlIElO VDQgTk9UIE5VTEwgREVGQVVMVCAwDQopOw0KDQpDUkVBVEUgRlVOQ1RJT04g aW5pdF9lbnRyeV9zdGF0c19mdW5jKCkgUkVUVVJOUyBPUEFRVUUgQVMgJw0K CURFQ0xBUkUNCglCRUdJTg0KCQlJTlNFUlQgSU5UTyBlbnRyeV9zdGF0cyBW QUxVRVMgKE5FVy5lbnRyeV9pZCwwKTsNCgkJUkVUVVJOIE5VTEw7DQoJRU5E Ow0KJyBMQU5HVUFHRSAncGxwZ3NxbCc7DQoNCkNSRUFURSBUUklHR0VSIGlu aXRfZW50cnlfc3RhdHMgQUZURVIgSU5TRVJUIE9OIGVudHJ5DQpGT1IgRUFD SCBST1cgRVhFQ1VURSBQUk9DRURVUkUgaW5pdF9lbnRyeV9zdGF0c19mdW5j KGVudHJ5X2lkKTsNCg0KSU5TRVJUIElOVE8gZW50cnkgVkFMVUVTICgxKTsN Cg0KQ1JFQVRFIFRBQkxFIGl0ZW0oDQoJaXRlbV9pZCBJTlQ0IFBSSU1BUlkg S0VZLA0KCWl0ZW1fZW50cnlfaWQgSU5UNCBOT1QgTlVMTCBSRUZFUkVOQ0VT IGVudHJ5IE9OIERFTEVURSBOTyBBQ1RJT04sDQoJaXRlbV9wcmljZSBJTlQ0 IE5PVCBOVUxMLA0KCWl0ZW1fbGl2ZSBib29sIE5PVCBOVUxMIERFRkFVTFQg J24nDQopOw0KDQpDUkVBVEUgRlVOQ1RJT04gc2V0ZW50cnlzdGF0cyAoKQ0K UkVUVVJOUyBPUEFRVUUgQVMgJw0KCURFQ0xBUkUNCglCRUdJTg0KCQlJRiBU R19PUD0nJ0lOU0VSVCcnIFRIRU4NCgkJCVVQREFURSBlbnRyeV9zdGF0cyAN CgkJCVNFVCBlbnRyeV9taW5wcmljZT1taW4oaXRlbV9wcmljZSkNCgkJCUZS T00gaXRlbSB3aGVyZSBpdGVtX2VudHJ5X2lkPU5FVy5pdGVtX2VudHJ5X2lk IEFORCBpdGVtX2xpdmU9Jyd0Jyc7DQoJCUVORCBJRjsNCgkJUkVUVVJOIE5V TEw7DQoJRU5EOw0KJyBMQU5HVUFHRSAncGxwZ3NxbCc7DQoNCkNSRUFURSBU UklHR0VSIHVwZGF0ZWVudHJ5cHJpY2VzIEFGVEVSIElOU0VSVCBPTiBpdGVt DQpGT1IgRUFDSCBST1cgRVhFQ1VURSBQUk9DRURVUkUgc2V0ZW50cnlzdGF0 cygpOw0KDQpJTlNFUlQgSU5UTyBpdGVtIFZBTFVFUyAoMSwxLDEyLCdmJyk7 DQovKiBDaGFuZ2UgdGhpcyBsYXN0IGxpbmUgdG8gIklOU0VSVCBJTlRPIGl0 ZW0gVkFMVUVTICgxLDEsMTIsJ3QnKTsiIGFuZCBubyBlcnJvciBpcyBnZW5l cmF0ZWQgKi8NCg0K --------------BFA25AB610B68E71E4CD3B3E--