[Dbix-class] Table name length constraint?

Ben Tilly btilly at gmail.com
Tue Feb 24 00:49:24 GMT 2015


Random guess, DBIx::Class is working around a database limitation.
For example see
http://search.cpan.org/~ribasushi/DBIx-Class-0.082810/lib/DBIx/Class/Storage/DBI/Oracle/Generic.pm#relname_to_table_alias
for how your situation could have happened.

On Mon, Feb 23, 2015 at 4:36 PM, Greg Coates <greg at coatesoft.com> wrote:
> Is there code somewhere in DBIx::Class that limits the length of a table
> name?
>
> I have a schema package with the following table name:
>
> __PACKAGE__->table('RDSPRD.REC_CLASS_MTG_INSTRUCTOR_DTL at FRONT1');
>
> When I try to access data from this table, I get an error saying the table
> does not exist, but if I look at the generated SQL in the error message, the
> table name has changed to RDSPRD.RcClssMtgInstrctrDt_D412VD8KCP.
>
> If I change the table name to REC_CLASS_MTG_INSTRUCTOR_DTL, the table name
> doesn't get changed in the SQL.
>
> Does anyone have any idea what is going on here?
>
> Thanks,
> Greg Coates
>
>
> _______________________________________________
> 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/dbix-class@lists.scsys.co.uk



More information about the DBIx-Class mailing list