Skip to content

Oracle dialect generates too long index names #820

Closed
@sqlalchemy-bot

Description

@sqlalchemy-bot

Migrated issue, originally created by Anonymous

This issue exists in 3.11

in _execute
raise exceptions.SQLError(context.statement, context.parameters, e)
sqlalchemy.exceptions.SQLError: (DatabaseError) ORA-00972: identifier is too long
'CREATE INDEX ix_r_5_0_was_r_notify_user_name ON r_5_0_was_r_notify (user_name)' {}

This patch works around the issue by truncating the index to the max_identifier_length() specified by the dialect.


Attachments: oracle.patch | oracle.utf8.patch

Activity

sqlalchemy-bot

sqlalchemy-bot commented on Oct 18, 2007

@sqlalchemy-bot
CollaboratorAuthor

Anonymous wrote:

This is a possible (general) patch for too long identifier.

sqlalchemy-bot

sqlalchemy-bot commented on Oct 18, 2007

@sqlalchemy-bot
CollaboratorAuthor

Changes by Anonymous:

  • attached file oracle.utf8.patch
sqlalchemy-bot

sqlalchemy-bot commented on Oct 19, 2007

@sqlalchemy-bot
CollaboratorAuthor

Michael Bayer (@zzzeek) wrote:

im assuming the autosetinputsizes change is not part of the change...

sqlalchemy-bot

sqlalchemy-bot commented on Oct 19, 2007

@sqlalchemy-bot
CollaboratorAuthor

Changes by Michael Bayer (@zzzeek):

  • set milestone to "0.4.xx"
sqlalchemy-bot

sqlalchemy-bot commented on Oct 23, 2007

@sqlalchemy-bot
CollaboratorAuthor

Anonymous wrote:

Patch agaist SA 4.0 release

sqlalchemy-bot

sqlalchemy-bot commented on Oct 23, 2007

@sqlalchemy-bot
CollaboratorAuthor

Changes by Anonymous:

  • attached file oracle.patch
sqlalchemy-bot

sqlalchemy-bot commented on Oct 23, 2007

@sqlalchemy-bot
CollaboratorAuthor

Anonymous wrote:

Added patch against SA 0.4 (pardon the dyslexia)
autosetinputsizes is not really part of the change, however I seem to require it with Oracle 10g with UTF8 (testing on Win32 if that makes a difference).

sqlalchemy-bot

sqlalchemy-bot commented on Jun 13, 2008

@sqlalchemy-bot
CollaboratorAuthor

Anonymous wrote:

(original author: ged) Doesn't this problem also exists for other DBMS? (I think I've had it with Postgres) and there is also a similar problem with table names (see ticket 571).

sqlalchemy-bot

sqlalchemy-bot commented on Jun 22, 2008

@sqlalchemy-bot
CollaboratorAuthor

Michael Bayer (@zzzeek) wrote:

bd708ad 8c1f08c

sqlalchemy-bot

sqlalchemy-bot commented on Jun 22, 2008

@sqlalchemy-bot
CollaboratorAuthor

Changes by Michael Bayer (@zzzeek):

  • changed status to closed
added this to the 0.4.xx milestone on Nov 27, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't workingoracle

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

      Development

      No branches or pull requests

        Participants

        @sqlalchemy-bot

        Issue actions

          Oracle dialect generates too long index names · Issue #820 · sqlalchemy/sqlalchemy