Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Increase maximum length of object names to 63 characters [CORE749] #1124

Closed
firebird-automations opened this issue Sep 17, 2003 · 26 comments
Closed

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @pcisar

Is duplicated by CORE1948
Is duplicated by CORE2375
Is duplicated by CORE1262
Is duplicated by CORE3659
Relate to CORE4339
Is duplicated by CORE5031
Block progress on JDBC467
Relate to CORE5866

Votes: 49

SFID: 807895#⁠
Submitted By: pcisar

Like other RDBMS's we should be supporting longer
object names.
----------------------
User: nobody
Logged In: NO

Longer identifiers are useful, but remember that Oracle
supports 30 character identifiers, so this would impact DB
portability. A switch would be nice.

Commits: 91a2a3c fc95191 e69a823

====== Test Details ======

See test core_2350.fbt (no more troubles with this ticket issue, so it can be closed).

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

issuetype: New Feature [ 2 ] => Improvement [ 4 ]

assignee: Dmitry Yemanov [ dimitr ]

SF_ID: 807895 =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

assignee: Dmitry Yemanov [ dimitr ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue is duplicated by CORE1262 [ CORE1262 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 10773 ] => Firebird [ 15144 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is duplicated by CORE1948 [ CORE1948 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is duplicated by CORE2375 [ CORE2375 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Fidel Viegas (araujofh)

This would be a really nice feature, as it sometimes complicates when we try to make an application compatible with various RDBMS. This is the only restriction I find when I try to port applications from other RDBMS. It forces one to rename object names to adjust to this limitation, and this sometimes breaks code that was already working. Specially when you are dealing with frameworks like Ruby on Rails.

I do understand that if it wasn't yet implemented is because somehow it is a difficult task, but the truth is that it sometimes forces us to do extra work when porting from other RDMBS.

Regards,

Fidel.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue is duplicated by CORE3659 [ CORE3659 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Tim Kelly (m00bh000)

Any chance of this making it into version 3. It's such as frustrating limitation.

Cheers,

Tim

@firebird-automations
Copy link
Collaborator Author

Commented by: Valdir Marcos (valdir_marcos)

I could not find this request neither on Release Notes - Firebird Core - Version 3.0 Alpha 1 - HTML format (http://tracker.firebirdsql.org/secure/ReleaseNote.jspa?version=10331&styleName=Html&projectId=10000) nor on Roadmap last updated in November 2012 (http://www.firebirdsql.org/en/roadmap/).

It is really useful on object-oriented programming (OOP) and on porting from other RDMBS to Firebird.

Can we hope this improvement to be scheduled for Firebird 3?

@firebird-automations
Copy link
Collaborator Author

Commented by: @dyemanov

No, it's not planned for v3.0.

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue relate to CORE4339 [ CORE4339 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ] =>

@firebird-automations
Copy link
Collaborator Author

Commented by: Sean Palmer (seanpalmer65)

Any progress on this please?
It is extremely frustrating that this limitation still exists in Firebird and is severely restricting the use of Firebird for my projects where long identifiers are required and for porting from other DBMS such as MSSQL or MS Access!

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Link: This issue is duplicated by CORE5031 [ CORE5031 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

Fix Version: 4.0 Alpha 1 [ 10731 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-automations
Copy link
Collaborator Author

Commented by: Todd Manchester (todd710)

I appreciate all that you do! I too was hoping this would make it into v3.0. But understand there needs to be limits. Just my 2 cents.

@firebird-automations
Copy link
Collaborator Author

Commented by: @livius2

If we are talking about compatibility
then object names should be not 64 but 128 chars like in MSSQL

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

summary: Object names of at least 64bytes => Increase maximum length of object names to 64 characters

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @asfernandes

summary: Increase maximum length of object names to 64 characters => Increase maximum length of object names to 63 characters

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Resolved [ 5 ]

QA Status: Covered by another test(s)

Test Details: See test core_2350.fbt (no more troubles with this ticket issue, so it can be closed).

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @mrotteveel

Link: This issue block progress on JDBC467 [ JDBC467 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Sean Leyne (seanleyne)

Link: This issue relate to CORE5866 [ CORE5866 ]

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants