From owner-freebsd-ports-bugs@FreeBSD.ORG Tue Jul 8 10:14:26 2014 Return-Path: Delivered-To: freebsd-ports-bugs@FreeBSD.org Received: from mx1.freebsd.org (mx1.freebsd.org [8.8.178.115]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id DB818B3D for ; Tue, 8 Jul 2014 10:14:26 +0000 (UTC) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2001:1900:2254:206a::16:76]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client did not present a certificate) by mx1.freebsd.org (Postfix) with ESMTPS id A958D21D3 for ; Tue, 8 Jul 2014 10:14:26 +0000 (UTC) Received: from bugs.freebsd.org ([127.0.1.118]) by kenobi.freebsd.org (8.14.8/8.14.8) with ESMTP id s68AEQXS072770 for ; Tue, 8 Jul 2014 11:14:26 +0100 (BST) (envelope-from bugzilla-noreply@freebsd.org) From: bugzilla-noreply@freebsd.org To: freebsd-ports-bugs@FreeBSD.org Subject: [Bug 191734] New: Patch for p5-DBIx-SearchBuilder Date: Tue, 08 Jul 2014 10:14:26 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: new X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports Tree X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Only Me X-Bugzilla-Who: michelle@sorbs.net X-Bugzilla-Status: Needs Triage X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: freebsd-ports-bugs@FreeBSD.org X-Bugzilla-Target-Milestone: --- X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: bug_id short_desc product version rep_platform op_sys bug_status bug_severity priority component assigned_to reporter attachments.created Message-ID: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 7bit X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated MIME-Version: 1.0 X-BeenThere: freebsd-ports-bugs@freebsd.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: Ports bug reports List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Tue, 08 Jul 2014 10:14:26 -0000 https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=191734 Bug ID: 191734 Summary: Patch for p5-DBIx-SearchBuilder Product: Ports Tree Version: Latest Hardware: Any OS: Any Status: Needs Triage Severity: Affects Only Me Priority: --- Component: Individual Port(s) Assignee: freebsd-ports-bugs@FreeBSD.org Reporter: michelle@sorbs.net Created attachment 144512 --> https://bugs.freebsd.org/bugzilla/attachment.cgi?id=144512&action=edit p5-DBIx-SearchBuilder patch for performance/case-sensitivity Patch for an optional patch to be applied to make ->Fields() case sensitive and speed up performance for large databases (ones with lots of schema's, or tables, or both) This is a modification of my previous patch (mentioned in email to ports@), but goes to fully making it case-sensitive (docs patched as well) as I thought, having it 'half broken' is worse than making it completely broken. Net result is the fields will be returned case-sensitive and the column names will be case sensitive. Any applications not using the correct case for the calls or results will break with this patch (but really they shouldn't be case-insensitive results when using a case sensitive DB - any Case-Insensitive databases like MySQL will not be affected by this patch, they will continue to return case insensitive results.) -- You are receiving this mail because: You are the assignee for the bug.