Bug #60469 for DBIx-Class-Schema-Loader: Can't use at tables with "-" sign

Wed Aug 18 08:33:19 2010 DEMIURG [...] cpan.org - Ticket created

Subject:

Can't use at tables with "-" sign

I have several tables with "-" sign in its names, i.e. 'bonusGroup-bonus', 'operatorGroup-permission', 'region-country' and so on... dbicdump report on it: Bad table or view 'bonusGroup-bonus', ignoring: DBIx::Class::Schema::Loader::make_schema_at(): DBI Exception: DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-bonus WHERE ( 1 = 0 )' at line 1 [for Statement "SELECT * FROM bonusGroup-bonus WHERE ( 1 = 0 )"] at /usr/local/bin/dbicdump line 71 Such names need to be quoted by ``

Wed Aug 18 12:53:42 2010 rkitover@cpan.org - Correspondence added

Subject:	Re: [rt.cpan.org #60469] Can't use at tables with "-" sign
Date:	Wed, 18 Aug 2010 12:53:17 -0400
To:	bug-DBIx-Class-Schema-Loader [...] rt.cpan.org
From:	Rafael Kitover <rkitover [...] cpan.org>

You need to turn on quoting in your connect_info, see quote_char and namesep "Алексей Вениаминович Мышкин via RT" <bug-DBIx-Class-Schema-Loader@rt.cpan.org> wrote: Show quoted text

>Wed Aug 18 08:33:19 2010: Request 60469 was acted upon. >Transaction: Ticket created by DEMIURG > Queue: DBIx-Class-Schema-Loader > Subject: Can't use at tables with "-" sign > Broken in: 0.07001 > Severity: Important > Owner: Nobody > Requestors: DEMIURG@cpan.org > Status: new > Ticket <URL: https://rt.cpan.org/Ticket/Display.html?id=60469 > > > >I have several tables with "-" sign in its names, i.e. 'bonusGroup-bonus', >'operatorGroup-permission', 'region-country' and so on... > >dbicdump report on it: >Bad table or view 'bonusGroup-bonus', ignoring: >DBIx::Class::Schema::Loader::make_schema_at(): DBI Exception: >DBD::mysql::st execute failed: You have an error in your SQL syntax; >check the manual that corresponds to your MySQL server version for the >right syntax to use near '-bonus WHERE ( 1 = 0 )' at line 1 [for >Statement "SELECT * FROM bonusGroup-bonus WHERE ( 1 = 0 )"] at >/usr/local/bin/dbicdump line 71 > >Such names need to be quoted by ``

-- Sent from my Android phone with K-9 Mail. Please excuse my brevity.

Wed Aug 18 12:53:43 2010 The RT System itself - Status changed from 'new' to 'open'

Thu May 26 16:55:50 2011 rkitover [...] cpan.org - Correspondence added

fixed in git

Thu May 26 16:55:51 2011 rkitover [...] cpan.org - Status changed from 'open' to 'patched'

Tue Nov 01 08:19:31 2011 rkitover [...] cpan.org - Correspondence added

Fixed in 0.07011

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

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