Bug #70851 for DBIx-Class-Schema-Loader: DBIx::Class::Schema::Loader::DBI::Oracle 0.07010 multi schema unique constraint patch

Fri Sep 09 15:13:37 2011 rickypc [...] gmail.com - Ticket created

Subject:	DBIx::Class::Schema::Loader::DBI::Oracle 0.07010 multi schema unique constraint patch
Date:	Fri, 9 Sep 2011 12:13:08 -0700
To:	bug-DBIx-Class-Schema-Loader [...] rt.cpan.org
From:	Richard Huang <rickypc [...] gmail.com>

85,86c85 < WHERE all_constraints.owner = acc.owner AND constraint_type='U' < AND acc.table_name=? AND acc.owner = ? --- Show quoted text

> WHERE acc.table_name=? and acc.owner = ? AND

constraint_type='U'

Sat Sep 10 15:34:59 2011 rkitover [...] cpan.org - Correspondence added

Hi, what issue does this patch solve for you? What were you seeing?

Sat Sep 10 15:35:02 2011 The RT System itself - Status changed from 'new' to 'open'

Sat Sep 10 18:02:01 2011 rickypc [...] gmail.com - Correspondence added

Subject:	Re: [rt.cpan.org #70851] DBIx::Class::Schema::Loader::DBI::Oracle 0.07010 multi schema unique constraint patch
Date:	Sat, 10 Sep 2011 15:01:33 -0700
To:	bug-DBIx-Class-Schema-Loader [...] rt.cpan.org
From:	Richard Huang <rickypc [...] gmail.com>

Hi Rafael, When I try to regenerate dbix schema class on oracle with multiple schema instance, I got the same column repeated multiple times where the actual unique column only one for the requested instance. Below is an example of expected result and the actual result: Expected: __PACKAGE__->add_unique_constraint("xxx_uc", ["xxx"]); Actual (assumed I have 5 oracle schema instances): __PACKAGE__->add_unique_constraint( "xxx_uc", [ "xxx", "xxx", "xxx", "xxx", "xxx", ], ); On Sat, Sep 10, 2011 at 12:35 PM, Rafael Kitover via RT < bug-DBIx-Class-Schema-Loader@rt.cpan.org> wrote: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=70851 > > > Hi, what issue does this patch solve for you? What were you seeing? >

Thu Oct 20 06:29:46 2011 rkitover [...] cpan.org - Correspondence added

Fixed in git master, with tests, thanks for the report.

Thu Oct 20 06:29:49 2011 rkitover [...] cpan.org - Status changed from 'open' to 'patched'

Tue Nov 01 08:34:40 2011 rkitover [...] cpan.org - Correspondence added

Fixed in 0.07011.

Tue Nov 01 08:34:41 2011 The RT System itself - Status changed from 'patched' to 'open'

Tue Nov 01 08:34:41 2011 rkitover [...] cpan.org - Status changed from 'open' to 'resolved'