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-issue-importer opened this issue Sep 17, 2003 · 26 comments
Closed

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 17, 2006

Modified by: @pcisar

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

assignee: Dmitry Yemanov [ dimitr ]

SF_ID: 807895 =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 6, 2006

Modified by: @pcisar

assignee: Dmitry Yemanov [ dimitr ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 16, 2006

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 16, 2007

Modified by: Sean Leyne (seanleyne)

Link: This issue is duplicated by CORE1262 [ CORE1262 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 21, 2008

Modified by: @dyemanov

Link: This issue is duplicated by CORE1948 [ CORE1948 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 15, 2009

Modified by: @dyemanov

Link: This issue is duplicated by CORE2375 [ CORE2375 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 3, 2011

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 11, 2011

Modified by: Sean Leyne (seanleyne)

Link: This issue is duplicated by CORE3659 [ CORE3659 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented May 21, 2012

Commented by: Tim Kelly (m00bh000)

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

Cheers,

Tim

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 24, 2012

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 24, 2012

Commented by: @dyemanov

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Feb 14, 2014

Modified by: Sean Leyne (seanleyne)

Link: This issue relate to CORE4339 [ CORE4339 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 3, 2014

Modified by: @dyemanov

assignee: Dmitry Yemanov [ dimitr ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 4, 2014

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 24, 2015

Modified by: @dyemanov

Link: This issue is duplicated by CORE5031 [ CORE5031 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 9, 2016

Modified by: @dyemanov

Fix Version: 4.0 Alpha 1 [ 10731 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 6, 2016

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Apr 29, 2016

Commented by: @livius2

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 10, 2016

Modified by: @asfernandes

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 10, 2016

Modified by: @asfernandes

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

resolution: Fixed [ 1 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jun 13, 2016

Modified by: @asfernandes

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 18, 2016

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Oct 18, 2016

Modified by: @pavel-zotov

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Dec 19, 2016

Modified by: @mrotteveel

Link: This issue block progress on JDBC467 [ JDBC467 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jul 9, 2018

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
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants