Issue Details (XML | Word | Printable)

Key: DERBY-104
Type: Improvement Improvement
Status: Closed Closed
Resolution: Fixed
Priority: Minor Minor
Assignee: Bernt M. Johnsen
Reporter: Bernd Ruehlicke
Votes: 3
Watchers: 4
Operations

If you were logged in you would be able to see more operations.
Derby

Get rid of the Max lenght of 18 for constraint names

Created: 16/Dec/04 10:28 PM   Updated: 01/Jul/09 12:40 AM
Return to search
Component/s: SQL
Affects Version/s: 10.0.2.0, 10.0.2.1, 10.0.2.2, 10.1.1.0
Fix Version/s: 10.1.1.0

Time Tracking:
Issue & Sub-Tasks
Issue Only
Not Specified

File Attachments:
  Size
Text File Licensed for inclusion in ASF works derby-id-plus-renames-v2.patch 2004-12-17 12:39 PM Philipp Hug 93 kB

Resolution Date: 18/Jun/05 07:20 AM

Sub-Tasks  All   Open   
No sub-tasks match this view.

 Description  « Hide
If not unlimited than we should at least make them 80 (just to pick a abitrary number)

 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Repository Revision Date User Message
ASF #170069 Fri May 13 18:35:33 UTC 2005 bandaram DERBY-104: Increase ALL identifier lengths to 128.

Now all identifiers should have a max length of 128 (note: MAX_USERID_LENGTH is
unchanged).

What has been done:
1) Renamed DBLimit.java to Limits.java since it no longer contains
only DB2-compliant limits.
2) Changed DB2_MAX_IDENTIFIER_LENGTH18/30/128 to MAX_IDENTIFIER_LENGTH
and set it to 128
3) Updated the necessary tests and masters.
4) Extended lang/identifier.sql with positive and negative tests wrt
max id. length.


Fix submitted by Bernt Johnsen. (Bernt.Johnsen@Sun.COM)
Files Changed
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/diag/TransactionTable.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/sql/compile/TypeCompiler.java
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/odbc_metadata.out
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/GroupByList.java
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/metadata.out
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/dbMetaDataJdbc30.out
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/SelectNode.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/TypeId.java
DEL /incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/reference/DB2Limit.java
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/identifier.out
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/diag/StatementDuration.java
MODIFY /incubator/derby/code/trunk/java/drda/org/apache/derby/impl/drda/FdocaConstants.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/authentication/AuthenticationServiceBase.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/NumericTypeCompiler.java
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/identifier.sql
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/metadata.out
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/types/NumberDataType.java
MODIFY /incubator/derby/code/trunk/java/drda/org/apache/derby/impl/drda/AppRequester.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/catalog/DD_Version.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/OrderByList.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/EmbedDatabaseMetaData.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/conn/GenericLanguageConnectionContext.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/execute/SetSchemaConstantAction.java
ADD /incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/reference/Limits.java (from /incubator/derby/code/trunk/java/engine/org/apache/derby/iapi/reference/DB2Limit.java)
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/diag/ErrorMessages.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/diag/StatementCache.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/ColumnDefinitionNode.java
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/store/streamingColumn.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/load/ImportResultSetMetaData.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/CreateIndexNode.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/CreateAliasNode.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/CreateTableNode.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/jdbc/EmbedConnection30.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/CreateViewNode.java
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/odbc_metadata.out
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/sqlgrammar.jj
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/AlterTableNode.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/catalog/DataDictionaryImpl.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/store/raw/data/FileContainer.java
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/diag/ErrorLogReader.java
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/currentSchema.sql
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/dbMetaDataJdbc30.out
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/tests/lang/dbManagerLimits.java
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/odbc_metadata.out
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/currentSchema.out
MODIFY /incubator/derby/code/trunk/java/engine/org/apache/derby/impl/sql/compile/ConcatenationOperatorNode.java
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/metadata.out
MODIFY /incubator/derby/code/trunk/java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/dbMetaDataJdbc30.out