[Dbix-class] Table name length constraint?

Hartmaier Alexander alexander.hartmaier at t-systems.at
Tue Feb 24 08:57:37 GMT 2015


So the correct way to handle that case is to limit only the tablename
portion, right?

On 2015-02-24 02:00, Greg Coates wrote:
> 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
>
>
> _______________________________________________
> 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



*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be privileged.
If you are not the intended recipient, please notify the sender and then
delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*



More information about the DBIx-Class mailing list