Re: [Dbix-class] Table name length constraint?

Greg Coates Tue, 24 Feb 2015 08:36:14 -0800

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 <g...@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@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 maybe 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



_______________________________________________
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

Re: [Dbix-class] Table name length constraint?

Reply via email to