This queue is for tickets about the DBIx-DBSchema CPAN distribution.

Report information
The Basics
Id:
58505
Status:
resolved
Priority:
Low/Low
Queue:

People
Owner:
ivan-pause [...] 420.am
Requestors:
trs [...] bestpractical.com
Cc:
AdminCc:

BugTracker
Severity:
Normal
Broken in:
(no value)
Fixed in:
(no value)



From trs@bestpractical.com Thu Jun 17 22: 32:48 2010
MIME-Version: 1.0
X-Spam-Status: No, score=-0.12 tagged_above=-99.9 required=10 tests=[BAYES_00=-2.599, FH_HOST_EQ_VERIZON_P=0.001, RCVD_IN_PBL=0.905, RCVD_IN_SORBS_DUL=0.877, RDNS_DYNAMIC=0.1, SPF_SOFTFAIL=0.596] autolearn=no
X-Spam-Flag: NO
Content-Type: multipart/mixed; boundary="------------060809050306040807080200"
Message-ID: <4C1ADB12.9070909@bestpractical.com>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-Spam-Score: -0.12
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 1C94B2408CE for <cpan-bug+DBIx-DBSchema@hipster.bestpractical.com>; Thu, 17 Jun 2010 22:32:48 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id WZh8tVq9LkRm for <cpan-bug+DBIx-DBSchema@hipster.bestpractical.com>; Thu, 17 Jun 2010 22:32:47 -0400 (EDT)
Received: from [192.168.1.2] (pool-96-236-122-244.spfdma.east.verizon.net [96.236.122.244]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by hipster.bestpractical.com (Postfix) with ESMTPS id 053F12408CB for <bug-DBIx-DBSchema@rt.cpan.org>; Thu, 17 Jun 2010 22:32:46 -0400 (EDT)
Delivered-To: cpan-bug+DBIx-DBSchema@hipster.bestpractical.com
Subject: mysql text/blob columns don't support defaults
User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4
Return-Path: <trs@bestpractical.com>
X-RT-Mail-Extension: dbix-dbschema
X-Original-To: cpan-bug+DBIx-DBSchema@hipster.bestpractical.com
Date: Thu, 17 Jun 2010 22:33:54 -0400
X-Spam-Level:
To: bug-DBIx-DBSchema@rt.cpan.org
From: Thomas Sibley <trs@bestpractical.com>
Content-Length: 0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-RT-Original-Encoding: utf-8
Content-Length: 316
MySQL used to partially support defaults of '' for NOT NULL text/blob columns, but it no longer supports even that. This module still generates default clauses for text/blob columns targeting mysql. I've attached a patch which fixes the issue and includes a new testfile to test that it works. Cheers, Thomas
content-type: text/x-diff; name="mysql-textblob-default.patch"
content-disposition: attachment; filename="mysql-textblob-default.patch"
Content-Transfer-Encoding: 7bit
Content-Length: 902

Message body is not shown because sender requested not to inline it.

MIME-Version: 1.0
In-Reply-To: <4C1ADB12.9070909@bestpractical.com>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <4C1ADB12.9070909@bestpractical.com>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-29216-1391038897-112.58505-0-0@rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 410
On Thu Jun 17 22:33:56 2010, trs@bestpractical.com wrote:
Show quoted text
> MySQL used to partially support defaults of '' for NOT NULL text/blob > columns, but it no longer supports even that. This module still > generates default clauses for text/blob columns targeting mysql. I've > attached a patch which fixes the issue and includes a new testfile to > test that it works.
Fixed in git; will be in 0.45. Thanks!
MIME-Version: 1.0
In-Reply-To: <4C1ADB12.9070909@bestpractical.com>
X-Mailer: MIME-tools 5.504 (Entity 5.504)
Content-Disposition: inline
X-RT-Interface: Web
References: <4C1ADB12.9070909@bestpractical.com>
Content-Type: text/plain; charset="utf-8"
Message-ID: <rt-4.0.18-10388-1449547176-198.58505-0-0@rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
X-RT-Encrypt: 0
X-RT-Sign: 0
Content-Length: 34
0.45 Wed May 6 22:17:33 PDT 2015


This service runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.