On 11/10/2011 04:50 PM, xli wrote:
On 11/10/11, Stefan Hornburg (Racke)<[email protected]>  wrote:
Hello,

I'm seeking help on a bug that I ran into with SQL::Abstract, so I'm writing
to this
list as advised on the POD of SQL::Abstract.

Simple test script to demonstrate the problem:

--snip--
#! /usr/bin/env perl

use SQL::Abstract;

my $sqla;

$sqla = SQL::Abstract->new;

$stmt = $sqla->generate('create table',  'products', ['sku varchar(32)',
'name varchar(255)']);

print "STMT: $stmt\n";
--snap--

racke@argus:~/shop/dancer$ ~/bin/sqla
STMT: CREATE TABLE PRODUCTS (sku varchar(32), name varchar(255))

This generates table PRODUCTS (uppercase) instead of products, which is not
the same
table.

Feedback is appreciated :-).



$stmt = $sqla->generate('create table',
   \'products', ['sku varchar(32)', 'name varchar(255)']);


That works, thanks a lot!

Regards
        Racke

--
LinuXia Systems => http://www.linuxia.de/
Expert Interchange Consulting and System Administration
ICDEVGROUP => http://www.icdevgroup.org/
Interchange Development Team


_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/[email protected]

Reply via email to