[Dbix-class] Table name length constraint?

[Greg Coates]

Yes, that is correct.

On 2/24/2015 12:57 AM, Hartmaier Alexander wrote:
> 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.
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"* 
>
>
> _______________________________________________
> 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