[Dbix-class] Table name length constraint?

Greg Coates greg at coatesoft.com
Tue Feb 24 01:00:23 GMT 2015


That looks to be what is happening.  Is there any way to turn this 
behavior off?  This is a legitimate table name with a dblink and schema 
appended.  It works in a direct query.

Thanks,
Greg

On 2/23/2015 4:49 PM, Ben Tilly wrote:
> 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
> _______________________________________________
> 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