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

Owner: Nobody in particular
Requestors: Andy.Baumhauer [...]

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 [...]>
X-Virus-Scanned: Debian amavisd-new at
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 []) by (Postfix) with ESMTP id 232342401F8 for <cpan-bug+SQL-Translator [...]>; Mon, 13 Jun 2016 18:07:27 -0400 (EDT)
Received: from ([]) by localhost ( []) (amavisd-new, port 10024) with ESMTP id C+2vr1Qp7OPt for <cpan-bug+SQL-Translator [...]>; Mon, 13 Jun 2016 18:07:24 -0400 (EDT)
Received: from ( []) by (Postfix) with SMTP id 98DE02400D9 for <bug-SQL-Translator [...]>; Mon, 13 Jun 2016 18:07:24 -0400 (EDT)
Received: (qmail 24336 invoked by alias); 13 Jun 2016 22:07:23 -0000
Received: from (HELO ( by (qpsmtpd/0.28) with ESMTP; Mon, 13 Jun 2016 15:07:20 -0700
Received: from ([]) by with ESMTP/TLS/DHE-RSA-AES256-GCM-SHA384; 13 Jun 2016 18:07:15 -0400
Received: from ([]) by (RSA Interceptor) for <bug-SQL-Translator [...]>; Mon, 13 Jun 2016 18:06:59 -0400
Received: from ([fe80::11d6:c318:7e69:a4b7]) by ([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 [...]
Subject: SQL::Translator::Producer::Oracle overrides constraint names with table causing errors
X-Rsa-Action: allow
Return-Path: <Andy.Baumhauer [...]>
Thread-Index: AdHFvhrJEvDi5GI8RASHbwYu2z9y8w==
X-RT-Mail-Extension: sql-translator
X-Original-To: cpan-bug+SQL-Translator [...]
Date: Mon, 13 Jun 2016 22:06:58 +0000
Thread-Topic: SQL::Translator::Producer::Oracle overrides constraint names with table causing errors
X-Rsa-Classifications: public
X-Rsa-Inspected: yes
X-Originating-Ip: []
Accept-Language: en-US
To: "bug-SQL-Translator [...]" <bug-SQL-Translator [...]>
From: "Baumhauer, Andy" <Andy.Baumhauer [...]>
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/ 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: 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 infrastructure.

Please report any issues with to