Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 824532E00E7 for ; Fri, 22 Feb 2008 20:13:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 01200-08 for ; Fri, 22 Feb 2008 20:13:34 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from el-out-1112.google.com (el-out-1112.google.com [209.85.162.180]) by postgresql.org (Postfix) with ESMTP id CAA5C2E00C4 for ; Fri, 22 Feb 2008 20:13:40 -0400 (AST) Received: by el-out-1112.google.com with SMTP id r27so644824ele.5 for ; Fri, 22 Feb 2008 16:13:39 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; bh=q57Q6DkzR1W+h0V7KMDXtdsUmACohFZ76EGj9l3uQCQ=; b=YmVUyuKlMGYG5QzW1YWKzU/9Py0x3ZbhaPfahQ7nSvd2x6aaLPH41JiuX4gXS9M9FMXVWEfeBp0CYg1eHy1iWGPWKOl1s+XDsUdp3heWubWcV132eUO3TijnfSQirq5z1QfKzspXoR41Gm9tgM8KFOsq7TXUbT32LvplouDtG2Y= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=ejihT35diApWMXolDKllVabN5gbgu/9XqWldM/JDQZTMGo/xVZeX57bItisI/3c2H0o8AbaJRsUQ/vLOI2z5+71oA9OaidnY15dsusFty3eEBDVIGeBEapViEVhjoxB2KHDShKtMVj3x6eHesu336G2pUfU0+aquabnPxQKWS3s= Received: by 10.114.160.1 with SMTP id i1mr772145wae.49.1203725618879; Fri, 22 Feb 2008 16:13:38 -0800 (PST) Received: by 10.114.133.6 with HTTP; Fri, 22 Feb 2008 16:13:38 -0800 (PST) Message-ID: Date: Fri, 22 Feb 2008 18:13:38 -0600 From: "Scott Marlowe" To: "Alvaro Herrera" Subject: Re: SQL standards in Mysql Cc: "Ken Johanson" , pgsql-sql@postgresql.org In-Reply-To: <20080222195720.GL9392@alvh.no-ip.org> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <47BF1B32.2050800@kensystem.com> <20080222195720.GL9392@alvh.no-ip.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/168 X-Sequence-Number: 30259 On Fri, Feb 22, 2008 at 1:57 PM, Alvaro Herrera wrote: > Ken Johanson wrote: > > Here's one Mysql developer's response to adding (fixing) the > > integer/bigint/tinyint types to their CAST function: > > > > http://bugs.mysql.com/bug.php?id=34562 > > So they are anal too, but in the opposite direction? No, they're just hopelessly lost and making good time. Or lazy. Or both. I'm not sure. There's example after example of things in the mysql bug database that should make anyone considering it as a database engine cringe and walk away shaking their head. for instance, someone JUST submitted this bug: http://bugs.mysql.com/bug.php?id=34231 Which is about a problem with the mysql packages including a statically linked zlib which makes it impossible to compile php against it. Problem is, their inability to properly package / not package zlib with mysql is an ongoing problem. As far back as 2004 it showed up. Then was fixed, then showed up again, then was fixed. Here's the most recent "we fixed it! Oh shit it's broken again" bug record: http://bugs.mysql.com/bug.php?id=15255 Before that we had http://bugs.mysql.com/bug.php?id=3700 After that we had http://bugs.mysql.com/bug.php?id=28569 and now the latest reports. It's like the Keystone Kops create RPM packages reading those messages. Pick any subject area. Foreign keys, SQL compliance, and on and on and you'll find dozens of the same bugs coming and going as one person stomps it and another apparently reinstates it.