Skip Menu |
 

This queue is for tickets about the SQL-Translator CPAN distribution.

Report information
The Basics
Id: 115313
Status: new
Priority: 0/
Queue: SQL-Translator

People
Owner: Nobody in particular
Requestors: Andy.Baumhauer [...] interactivedata.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)



MIME-Version: 1.0
X-Spam-Status: No, score=-4.981 tagged_above=-99.9 required=10 tests=[AWL=-0.781, BAYES_00=-1.9, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_MED=-2.3, RP_MATCHES_RCVD=-0.001] autolearn=ham
X-Spam-Flag: NO
X-Virus-Checked: Checked
Content-Language: en-US
Content-Type: multipart/alternative; boundary="_000_8E6AE4A98E99E94D8AB379564627AC2EF4B4517Eswpma1exmail02i_"
Message-ID: <8E6AE4A98E99E94D8AB379564627AC2EF4B4517E [...] swpma1exmail02.idco.intdata.com>
X-Virus-Scanned: Debian amavisd-new at bestpractical.com
X-MS-Tnef-Correlator:
X-Ironport-Av: E=Sophos;i="5.26,468,1459828800"; d="scan'208,217";a="361540570"
X-Spam-Score: -4.981
Received: from localhost (localhost [127.0.0.1]) by hipster.bestpractical.com (Postfix) with ESMTP id 232342401F8 for <cpan-bug+SQL-Translator [...] hipster.bestpractical.com>; Mon, 13 Jun 2016 18:07:27 -0400 (EDT)
Received: from hipster.bestpractical.com ([127.0.0.1]) by localhost (hipster.bestpractical.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id C+2vr1Qp7OPt for <cpan-bug+SQL-Translator [...] hipster.bestpractical.com>; Mon, 13 Jun 2016 18:07:24 -0400 (EDT)
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by hipster.bestpractical.com (Postfix) with SMTP id 98DE02400D9 for <bug-SQL-Translator [...] rt.cpan.org>; Mon, 13 Jun 2016 18:07:24 -0400 (EDT)
Received: (qmail 24336 invoked by alias); 13 Jun 2016 22:07:23 -0000
Received: from mxgateway01.interactivedata.com (HELO mxgateway01.interactivedata.com) (199.181.252.99) by la.mx.develooper.com (qpsmtpd/0.28) with ESMTP; Mon, 13 Jun 2016 15:07:20 -0700
Received: from dlp-extmx01.intdata.com ([192.245.63.35]) by mxgateway01.interactivedata.com with ESMTP/TLS/DHE-RSA-AES256-GCM-SHA384; 13 Jun 2016 18:07:15 -0400
Received: from SWPMA1EXCAS05.idco.intdata.com ([10.170.32.170]) by dlp-extmx01.intdata.com (RSA Interceptor) for <bug-SQL-Translator [...] rt.cpan.org>; Mon, 13 Jun 2016 18:06:59 -0400
Received: from SWPMA1EXMAIL02.idco.intdata.com ([fe80::11d6:c318:7e69:a4b7]) by SWPMA1EXCAS05.idco.intdata.com ([fe80::d55d:9bb9:2acf:dbff%11]) with mapi id 14.03.0210.002; Mon, 13 Jun 2016 18:06:58 -0400
Delivered-To: cpan-bug+SQL-Translator [...] hipster.bestpractical.com
Subject: SQL::Translator::Producer::Oracle overrides constraint names with table causing errors
X-Rsa-Action: allow
Return-Path: <Andy.Baumhauer [...] interactivedata.com>
Thread-Index: AdHFvhrJEvDi5GI8RASHbwYu2z9y8w==
X-RT-Mail-Extension: sql-translator
X-Original-To: cpan-bug+SQL-Translator [...] hipster.bestpractical.com
X-Spam-Check-BY: la.mx.develooper.com
Date: Mon, 13 Jun 2016 22:06:58 +0000
X-Spam-Level:
X-MS-Has-Attach:
Thread-Topic: SQL::Translator::Producer::Oracle overrides constraint names with table causing errors
X-Rsa-Classifications: public
X-Rsa-Inspected: yes
X-Originating-Ip: [172.24.157.149]
Accept-Language: en-US
To: "bug-SQL-Translator [...] rt.cpan.org" <bug-SQL-Translator [...] rt.cpan.org>
From: "Baumhauer, Andy" <Andy.Baumhauer [...] interactivedata.com>
X-RT-Interface: Email
Content-Length: 0
MIME-Version: 1.0
content-type: text/plain; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: ascii
Content-Length: 1519
Download (untitled) / with headers
text/plain 1.4k
Line 336 of SQL/Translator/Producer/Oracle.pm overrides the $c->name value supplied by the user with the $table_name prepending. Oracle doesn't like constraint identifiers longer than 30 characters. In cases where the user has long table names, and wants to hard-code the constraint identifier, this code is making the problem worse. I've encountered two errors due to this issue, "ORA-01408: such column list already indexed" and ORA-00904: invalid identifier. A discussion on why this issue exists is here: http://stackoverflow.com/questions/1378133/why-are-oracle-table-column-index-names-limited-to-30-characters Either we add an option to enable this "helpful" code. Or disable the table prepending and trust that the programmer knows what is best to name the constraint. ******************************************************* This message may contain confidential information and is intended for specific recipients unless explicitly noted otherwise. If you have reason to believe you are not an intended recipient of this message, please delete it and notify the sender. This message may not represent the opinion of Intercontinental Exchange, Inc. (ICE), its subsidiaries or affiliates, and does not constitute a contract or guarantee. Unencrypted electronic mail is not secure and the recipient of this message is expected to provide safeguards from viruses and pursue alternate means of communication where privacy or a binding message is desired. *******************************************************
MIME-Version: 1.0
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: ascii
Content-Length: 3449


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.