[Dbix-class] Bug in SQL::Abstract's generate method

Stefan Hornburg (Racke) racke at linuxia.de
Thu Nov 10 07:29:25 GMT 2011


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:

#! /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";

racke at 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

Feedback is appreciated :-).


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

More information about the DBIx-Class mailing list