Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.
Bug 387430 - Add index expression support to SQLModel
Summary: Add index expression support to SQLModel
Status: RESOLVED FIXED
Alias: None
Product: Data Tools
Classification: Tools
Component: ModelBase (show other bugs)
Version: 1.10   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: 1.10.1   Edit
Assignee: Brian Payton CLA
QA Contact:
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-16 16:09 EDT by Don Clare CLA
Modified: 2013-05-29 18:28 EDT (History)
1 user (show)

See Also:

Attachments
Proposal documentation (72.59 KB, application/pdf)
2012-08-16 16:11 EDT, Don Clare CLA 		no flags Details
CVS patch for SQLModel metamodel changes (72.94 KB, text/plain)
2012-08-16 16:12 EDT, Don Clare CLA 		no flags Details
CVS patch for the SQL metamodel edit plugin changes (12.62 KB, patch)
2012-08-16 16:13 EDT, Don Clare CLA 		no flags Details | Diff
Add Index Expression to SQLModel, DTP v1.10.1 patch (14.89 KB, patch)
2012-08-22 13:51 EDT, Don Clare CLA 		no flags Details | Diff
Add Index Expression to SQLModel, DTP v1.8.2a patch (14.89 KB, patch)
2012-08-22 13:54 EDT, Don Clare CLA 		no flags Details | Diff
1.8.2a SQLModel patch (82.43 KB, patch)
2012-08-22 19:10 EDT, Don Clare CLA 		bpayton: iplog+
Details | Diff
1.8.2a SQLModel.edit patch (15.20 KB, patch)
2012-08-22 19:11 EDT, Don Clare CLA 		bpayton: iplog+
Details | Diff
1.10.1 SQLModel patch (82.46 KB, patch)
2012-08-22 19:11 EDT, Don Clare CLA 		bpayton: iplog+
Details | Diff
1.10.1 SQLModel.edit patch (15.20 KB, patch)
2012-08-22 19:12 EDT, Don Clare CLA 		bpayton: iplog+
Details | Diff
Show Obsolete (4) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Don Clare CLA 2012-08-16 16:09:50 EDT 
Expressions/Functions as index members are now supported by several relational databases.  Add support for this to the SQLModel metamodel.  Please see the attached documentation and patches for a more detailed description.
Comment 1 Don Clare CLA 2012-08-16 16:11:12 EDT 
Created attachment 219975 [details]
Proposal documentation
Comment 2 Don Clare CLA 2012-08-16 16:12:38 EDT 
Created attachment 219976 [details]
CVS patch for SQLModel metamodel changes
Comment 3 Don Clare CLA 2012-08-16 16:13:42 EDT 
Created attachment 219977 [details]
CVS patch for the SQL metamodel edit plugin changes
Comment 4 Brian Payton CLA 2012-08-20 21:22:10 EDT 
Hi Don, 

Unfortunately the SQLModel metamodel changes patch does not apply cleanly to the o.e.d.modelbase.sql plugin.  I get merge conflicts on SQLModel-Constraints.cat and SQLConstraintsPackageImpl.java

The patch needs to apply to both the DTP 1.10.1 stream and the 1.8.2.a stream.  (I see the same errors in both streams when applying the patch, so the modelbase.sql plugin might be the same in both.)

The SQL metamodel edit plugin changes apply OK in both streams.

Please update the SQLModel patch with a version created from the DTP stream.
Comment 5 Don Clare CLA 2012-08-22 13:46:30 EDT 
Patches attached on 2012-08-16 were for version at HEAD of obsolete CVS repository.  Adding attachments which can be applied to DTP branches 1.10.1 and 1.8.2a in GIT repository.
Comment 6 Don Clare CLA 2012-08-22 13:51:51 EDT 
Created attachment 220151 [details]
Add Index Expression to SQLModel, DTP v1.10.1 patch
Comment 7 Don Clare CLA 2012-08-22 13:54:11 EDT 
Created attachment 220152 [details]
Add Index Expression to SQLModel, DTP v1.8.2a patch
Comment 8 Don Clare CLA 2012-08-22 19:10:32 EDT 
Created attachment 220171 [details]
1.8.2a SQLModel patch
Comment 9 Don Clare CLA 2012-08-22 19:11:15 EDT 
Created attachment 220172 [details]
1.8.2a SQLModel.edit patch
Comment 10 Don Clare CLA 2012-08-22 19:11:57 EDT 
Created attachment 220173 [details]
1.10.1 SQLModel patch
Comment 11 Don Clare CLA 2012-08-22 19:12:29 EDT 
Created attachment 220174 [details]
1.10.1 SQLModel.edit patch
Comment 12 Don Clare CLA 2012-08-22 19:14:42 EDT 
Comment on attachment 220151 [details]
Add Index Expression to SQLModel, DTP v1.10.1 patch

Do not use, this is .zip
Comment 13 Don Clare CLA 2012-08-22 19:15:13 EDT 
Comment on attachment 220152 [details]
Add Index Expression to SQLModel, DTP v1.8.2a patch

Do not use, this is .zip