| (object Petal | |
| version 50 | |
| _written "Rose 2006.0.0.060314" | |
| charSet 0) | |
| (object Class_Category "SQLQueryModel" | |
| is_unit TRUE | |
| is_loaded TRUE | |
| attributes (list Attribute_Set | |
| (object Attribute | |
| tool "Ecore" | |
| name "basePackage" | |
| value (value Text "org.eclipse.datatools.modelbase.sql")) | |
| (object Attribute | |
| tool "Ecore" | |
| name "packageName" | |
| value (value Text "query")) | |
| (object Attribute | |
| tool "Ecore" | |
| name "prefix" | |
| value (value Text "SQLQueryModel")) | |
| (object Attribute | |
| tool "Ecore" | |
| name "nsURI" | |
| value (value Text "http:///org/eclipse/datatools/modelbase/sql/query/SQLQueryModel.ecore"))) | |
| quid "40467E9F03A6" | |
| visible_categories (list visibility_relationship_list | |
| (object Visibility_Relationship | |
| quid "3B38F6F300A9" | |
| supplier "Logical View::rdbschema" | |
| quidu "3738A5FB0023") | |
| (object Visibility_Relationship | |
| quid "3B9D19DC01B5" | |
| supplier "Logical View::rlogic" | |
| quidu "3947FCCA01F9") | |
| (object Visibility_Relationship | |
| quid "404E1CF70346" | |
| supplier "Logical View::SQLModel" | |
| quidu "3E9B1F8201C1")) | |
| exportControl "Public" | |
| logical_models (list unit_reference_list | |
| (object Class "QueryStatement" | |
| quid "3B3785180139" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404683B4025D" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB") | |
| (object Inheritance_Relationship | |
| quid "40490B870362" | |
| supplier "Logical View::SQLModel::Statements::SQLDataStatement" | |
| quidu "4049092B0395")) | |
| abstract TRUE) | |
| (object Class "QueryDeleteStatement" | |
| quid "3B378546017C" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "40490F1701B4" | |
| supplier "Logical View::SQLQueryModel::QueryChangeStatement" | |
| quidu "40490E600298"))) | |
| (object Class "QueryInsertStatement" | |
| quid "3B3785520223" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "40490F1301D7" | |
| supplier "Logical View::SQLQueryModel::QueryChangeStatement" | |
| quidu "40490E600298"))) | |
| (object Class "QuerySelectStatement" | |
| quid "3B37856000BB" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B3785C7018B" | |
| supplier "Logical View::SQLQueryModel::QueryStatement" | |
| quidu "3B3785180139"))) | |
| (object Class "QueryUpdateStatement" | |
| quid "3B3785760076" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "40490F090074" | |
| supplier "Logical View::SQLQueryModel::QueryChangeStatement" | |
| quidu "40490E600298"))) | |
| (object Class "UpdateAssignmentExpression" | |
| quid "3B378BF6015F" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404CFC4100D1" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "CursorReference" | |
| quid "3B378C08021A" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404CFC3B01B9" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "QuerySearchCondition" | |
| quid "3B378C160224" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404C48A2002A" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB") | |
| (object Inheritance_Relationship | |
| quid "404CD97202A5" | |
| supplier "Logical View::SQLModel::Expressions::SearchCondition" | |
| quidu "3FABEC590086")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "negatedCondition" | |
| quid "3BE32A19004F" | |
| documentation "This represents NOT ( <searchCondition> ). This attribute and paren can not both be true at the same time." | |
| type "boolean" | |
| exportControl "Public")) | |
| abstract TRUE) | |
| (object Class "QueryExpressionBody" | |
| quid "3B37924A01CC" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37EF4C0061" | |
| supplier "Logical View::SQLQueryModel::TableExpression" | |
| quidu "3B37EE600288")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "rowFetchLimit" | |
| quid "49D166C4029F" | |
| type "int" | |
| exportControl "Public")) | |
| abstract TRUE) | |
| (object Class "QueryValueExpression" | |
| quid "3B3792520160" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404CDEDD0137" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB") | |
| (object Inheritance_Relationship | |
| quid "404CDF0500DA" | |
| supplier "Logical View::SQLModel::Expressions::ValueExpression" | |
| quidu "3F4D273D00A9")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "unaryOperator" | |
| quid "3B3A5FE902E7" | |
| type "ValueExpressionUnaryOperator" | |
| quidu "3B3A5E0F015F" | |
| exportControl "Public") | |
| (object ClassAttribute "dataType" | |
| quid "41647AC1029F" | |
| type "DataType" | |
| quidu "3E9B3F3400BF" | |
| exportControl "Public")) | |
| abstract TRUE) | |
| (object Class "QueryExpressionRoot" | |
| quid "3B37968301D1" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "4049122F007D" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB") | |
| (object Inheritance_Relationship | |
| quid "404CD86A02F5" | |
| supplier "Logical View::SQLModel::Expressions::QueryExpression" | |
| quidu "3F392200019B"))) | |
| (object Class "ValuesRow" | |
| quid "3B3796910130" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404E4A8F00C1" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "QueryValues" | |
| quid "3B37969E01ED" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37F45F0131" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionBody" | |
| quidu "3B37924A01CC"))) | |
| (object Class "TableReference" | |
| quid "3B37EE200178" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404922A50195" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB")) | |
| abstract TRUE) | |
| (object Class "TableExpression" | |
| quid "3B37EE600288" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3C1FB7ED00E8" | |
| supplier "Logical View::SQLQueryModel::TableReference" | |
| quidu "3B37EE200178")) | |
| abstract TRUE) | |
| (object Class "TableJoined" | |
| quid "3B37EEB00323" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3C1FB7EA0080" | |
| supplier "Logical View::SQLQueryModel::TableReference" | |
| quidu "3B37EE200178")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "joinOperator" | |
| quid "3B3A113D0369" | |
| type "TableJoinedOperator" | |
| quidu "3B3A10F70322" | |
| exportControl "Public"))) | |
| (object Class "WithTableSpecification" | |
| quid "3B37EEBD019C" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "41F9707402EF" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "Predicate" | |
| quid "3B37F1C2039C" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37F1EE03E5" | |
| supplier "Logical View::SQLQueryModel::QuerySearchCondition" | |
| quidu "3B378C160224")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "negatedPredicate" | |
| quid "3DEE9E260007" | |
| documentation | |
| |This attribute adds the NOT keyword in front of a predicate, so when true you have NOT <predicate>. If attribute "paren" in the superclass is also true, you get ( NOT <predicate> ). If attribute "notParen" in the superclass is true, you get NOT ( NOT <predicate> ). | |
| type "boolean" | |
| exportControl "Public") | |
| (object ClassAttribute "hasSelectivity" | |
| quid "3B3B7EF800D1" | |
| type "boolean" | |
| exportControl "Public") | |
| (object ClassAttribute "selectivityValue" | |
| quid "3B3B7F0F017E" | |
| type "Integer" | |
| exportControl "Public")) | |
| abstract TRUE) | |
| (object Class "SearchConditionCombined" | |
| quid "3B37F1CF032C" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37F1F101C3" | |
| supplier "Logical View::SQLQueryModel::QuerySearchCondition" | |
| quidu "3B378C160224")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "combinedOperator" | |
| quid "3B3A0FFB0316" | |
| type "SearchConditionCombinedOperator" | |
| quidu "3B3A0FC50214" | |
| exportControl "Public"))) | |
| (object Class "OrderByValueExpression" | |
| quid "3B37F35A0212" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D165700D4" | |
| supplier "Logical View::SQLQueryModel::OrderBySpecification" | |
| quidu "404D14E20381"))) | |
| (object Class "QueryCombined" | |
| quid "3B37F42D0189" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37F464012E" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionBody" | |
| quidu "3B37924A01CC")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "combinedOperator" | |
| quid "3B3A1FAD0237" | |
| type "QueryCombinedOperator" | |
| quidu "3B3A1F54022F" | |
| exportControl "Public"))) | |
| (object Class "QuerySelect" | |
| quid "3B37F44F02C8" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37F4610260" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionBody" | |
| quidu "3B37924A01CC")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "distinct" | |
| quid "3B3A0DA101EE" | |
| type "boolean" | |
| exportControl "Public"))) | |
| (object Class "GroupingSpecification" | |
| quid "3B37F63D0369" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404CF96100D3" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB")) | |
| abstract TRUE) | |
| (object Class "QueryResultSpecification" | |
| quid "3B37F66102FD" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404E2B7E0181" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB")) | |
| abstract TRUE) | |
| (object Class "ResultTableAllColumns" | |
| quid "3B37F93B0085" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37F953033D" | |
| supplier "Logical View::SQLQueryModel::QueryResultSpecification" | |
| quidu "3B37F66102FD"))) | |
| (object Class "ResultColumn" | |
| quid "3B37F947006F" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37F95502F0" | |
| supplier "Logical View::SQLQueryModel::QueryResultSpecification" | |
| quidu "3B37F66102FD"))) | |
| (object Class "PredicateBasic" | |
| quid "3B37FA6F011F" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37FAEB00EB" | |
| supplier "Logical View::SQLQueryModel::Predicate" | |
| quidu "3B37F1C2039C")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "comparisonOperator" | |
| quid "3B3A0B9200B0" | |
| type "PredicateComparisonOperator" | |
| quidu "3B3A0A6F00D9" | |
| exportControl "Public"))) | |
| (object Class "PredicateQuantified" | |
| quid "3B37FA7E008A" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37FAED0039" | |
| supplier "Logical View::SQLQueryModel::Predicate" | |
| quidu "3B37F1C2039C")) | |
| abstract TRUE) | |
| (object Class "PredicateBetween" | |
| quid "3B37FA98004B" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37FAF0028D" | |
| supplier "Logical View::SQLQueryModel::Predicate" | |
| quidu "3B37F1C2039C")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "notBetween" | |
| quid "3B3A0C65015D" | |
| type "boolean" | |
| exportControl "Public"))) | |
| (object Class "PredicateExists" | |
| quid "3B37FAA50158" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37FAF302C3" | |
| supplier "Logical View::SQLQueryModel::Predicate" | |
| quidu "3B37F1C2039C"))) | |
| (object Class "PredicateIn" | |
| quid "3B37FAB303B1" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37FAF90376" | |
| supplier "Logical View::SQLQueryModel::Predicate" | |
| quidu "3B37F1C2039C")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "notIn" | |
| quid "3B3A0C83000C" | |
| type "boolean" | |
| exportControl "Public")) | |
| abstract TRUE) | |
| (object Class "PredicateLike" | |
| quid "3B37FAC702A2" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37FAFC0095" | |
| supplier "Logical View::SQLQueryModel::Predicate" | |
| quidu "3B37F1C2039C")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "notLike" | |
| quid "3B3A0CA5019B" | |
| type "boolean" | |
| exportControl "Public"))) | |
| (object Class "PredicateIsNull" | |
| quid "3B37FAD50324" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37FAFF02CA" | |
| supplier "Logical View::SQLQueryModel::Predicate" | |
| quidu "3B37F1C2039C")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "notNull" | |
| quid "3B3A0CE2026B" | |
| type "boolean" | |
| exportControl "Public"))) | |
| (object Class "PredicateQuantifiedValueSelect" | |
| quid "3B37FB9C03C0" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37FBCF0360" | |
| supplier "Logical View::SQLQueryModel::PredicateQuantified" | |
| quidu "3B37FA7E008A")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "quantifiedType" | |
| quid "3B3A0AE50025" | |
| type "PredicateQuantifiedType" | |
| quidu "3B3A0500009D" | |
| exportControl "Public") | |
| (object ClassAttribute "comparisonOperator" | |
| quid "3B3A0B0C02F2" | |
| type "PredicateComparisonOperator" | |
| quidu "3B3A0A6F00D9" | |
| exportControl "Public"))) | |
| (object Class "PredicateQuantifiedRowSelect" | |
| quid "3B37FBB7024D" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37FBD201F1" | |
| supplier "Logical View::SQLQueryModel::PredicateQuantified" | |
| quidu "3B37FA7E008A")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "quantifiedType" | |
| quid "3B3A0BC60123" | |
| type "PredicateQuantifiedType" | |
| quidu "3B3A0500009D" | |
| exportControl "Public"))) | |
| (object Class "PredicateInValueSelect" | |
| quid "3B37FBE4017F" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37FC2D01A2" | |
| supplier "Logical View::SQLQueryModel::PredicateIn" | |
| quidu "3B37FAB303B1"))) | |
| (object Class "PredicateInValueList" | |
| quid "3B37FBF403E5" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37FC2A039C" | |
| supplier "Logical View::SQLQueryModel::PredicateIn" | |
| quidu "3B37FAB303B1"))) | |
| (object Class "PredicateInValueRowSelect" | |
| quid "3B37FC0B03C0" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B37FC31016C" | |
| supplier "Logical View::SQLQueryModel::PredicateIn" | |
| quidu "3B37FAB303B1"))) | |
| (object Class "ValueExpressionSimple" | |
| quid "3B389E9103C5" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D00100110" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionAtomic" | |
| quidu "404CFF9003B4")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "value" | |
| quid "3B3A11EB01F7" | |
| type "String" | |
| exportControl "Public"))) | |
| (object Class "ValueExpressionColumn" | |
| quid "3B389EAF00BB" | |
| documentation "This is a VEC" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D003D00C4" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionAtomic" | |
| quidu "404CFF9003B4"))) | |
| (object Class "ValueExpressionVariable" | |
| quid "3B389EC5029D" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D00350311" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionAtomic" | |
| quidu "404CFF9003B4"))) | |
| (object Class "ValueExpressionScalarSelect" | |
| quid "3B389EE1015D" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D0046023A" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionAtomic" | |
| quidu "404CFF9003B4"))) | |
| (object Class "ValueExpressionLabeledDuration" | |
| quid "3B389EF70385" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D00230320" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionAtomic" | |
| quidu "404CFF9003B4")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "labeledDurationType" | |
| quid "3B3A625801E8" | |
| type "ValueExpressionLabeledDurationType" | |
| quidu "3B3A62830230" | |
| exportControl "Public"))) | |
| (object Class "ValueExpressionCase" | |
| quid "3B389F19026C" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D0086030E" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionAtomic" | |
| quidu "404CFF9003B4")) | |
| abstract TRUE) | |
| (object Class "ValueExpressionCast" | |
| quid "3B389F33029B" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D005E0021" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionAtomic" | |
| quidu "404CFF9003B4"))) | |
| (object Class "ValueExpressionNullValue" | |
| quid "3B389F460086" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D00650216" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionAtomic" | |
| quidu "404CFF9003B4"))) | |
| (object Class "ValueExpressionDefaultValue" | |
| quid "3B389F5E013E" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D007200FC" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionAtomic" | |
| quidu "404CFF9003B4"))) | |
| (object Class "ValueExpressionFunction" | |
| quid "3B389F78002D" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D0054037A" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionAtomic" | |
| quidu "404CFF9003B4")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "specialRegister" | |
| quid "3B3A167402DD" | |
| type "boolean" | |
| exportControl "Public") | |
| (object ClassAttribute "distinct" | |
| quid "3C5F00D1036B" | |
| type "boolean" | |
| exportControl "Public") | |
| (object ClassAttribute "columnFunction" | |
| quid "3C5F011003C6" | |
| type "boolean" | |
| exportControl "Public"))) | |
| (object Class "ValueExpressionCombined" | |
| quid "3B389F8603D1" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B38A03D0153" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "combinedOperator" | |
| quid "3B3A601100FA" | |
| type "ValueExpressionCombinedOperator" | |
| quidu "3B3A5E3B0357" | |
| exportControl "Public"))) | |
| (object Class "GroupingSets" | |
| quid "3B38A4DC01A4" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B38A50302FF" | |
| supplier "Logical View::SQLQueryModel::GroupingSpecification" | |
| quidu "3B37F63D0369"))) | |
| (object Class "Grouping" | |
| quid "3B38A4EC0266" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B38A506030D" | |
| supplier "Logical View::SQLQueryModel::GroupingSpecification" | |
| quidu "3B37F63D0369")) | |
| abstract TRUE) | |
| (object Class "GroupingSetsElement" | |
| quid "3B38A510018B" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404CF96B0377" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB")) | |
| abstract TRUE) | |
| (object Class "GroupingSetsElementSublist" | |
| quid "3B38A54D0297" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B38A57C03CB" | |
| supplier "Logical View::SQLQueryModel::GroupingSetsElement" | |
| quidu "3B38A510018B"))) | |
| (object Class "GroupingSetsElementExpression" | |
| quid "3B38A56901C5" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B38A57F0040" | |
| supplier "Logical View::SQLQueryModel::GroupingSetsElement" | |
| quidu "3B38A510018B"))) | |
| (object Class "SuperGroup" | |
| quid "3B38A6570326" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B38A67601B8" | |
| supplier "Logical View::SQLQueryModel::Grouping" | |
| quidu "3B38A4EC0266")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "superGroupType" | |
| quid "3B39FDB60343" | |
| type "SuperGroupType" | |
| quidu "3B39FEAC03A1" | |
| exportControl "Public"))) | |
| (object Class "GroupingExpression" | |
| quid "3B38A6670094" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B38A679000E" | |
| supplier "Logical View::SQLQueryModel::Grouping" | |
| quidu "3B38A4EC0266"))) | |
| (object Class "SuperGroupElement" | |
| quid "3B38A6870389" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404CF9D0014B" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB")) | |
| abstract TRUE) | |
| (object Class "SuperGroupElementSublist" | |
| quid "3B38A6A1037C" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B38A6C40391" | |
| supplier "Logical View::SQLQueryModel::SuperGroupElement" | |
| quidu "3B38A6870389"))) | |
| (object Class "SuperGroupElementExpression" | |
| quid "3B38A6AF026E" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B38A6C70074" | |
| supplier "Logical View::SQLQueryModel::SuperGroupElement" | |
| quidu "3B38A6870389"))) | |
| (object Class "ValueExpressionCaseSearch" | |
| quid "3B38A8D00055" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B38A92E00B4" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCase" | |
| quidu "3B389F19026C"))) | |
| (object Class "ValueExpressionCaseSimple" | |
| quid "3B38A8EF0082" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3B38A93003BA" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCase" | |
| quidu "3B389F19026C"))) | |
| (object Class "ValueExpressionCaseElse" | |
| quid "3B38A90D01A7" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D07300361" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "ValueExpressionCaseSearchContent" | |
| quid "3B38A9A7034D" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D08840021" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "ValueExpressionCaseSimpleContent" | |
| quid "3B38A9C1019C" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D086F0338" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "SuperGroupType" | |
| quid "3B39FEAC03A1" | |
| stereotype "enumeration" | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "CUBE" | |
| quid "404C388500E6" | |
| exportControl "Public") | |
| (object ClassAttribute "GRANDTOTAL" | |
| quid "404C388F01F9" | |
| exportControl "Public") | |
| (object ClassAttribute "ROLLUP" | |
| quid "404C393003E5" | |
| exportControl "Public"))) | |
| (object Class "PredicateQuantifiedType" | |
| quid "3B3A0500009D" | |
| stereotype "enumeration" | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "SOME" | |
| quid "404C4FBA0266" | |
| exportControl "Public") | |
| (object ClassAttribute "ANY" | |
| quid "404C4FBF00BE" | |
| exportControl "Public") | |
| (object ClassAttribute "ALL" | |
| quid "404C4FC30060" | |
| exportControl "Public"))) | |
| (object Class "PredicateComparisonOperator" | |
| quid "3B3A0A6F00D9" | |
| stereotype "enumeration" | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "EQUAL" | |
| quid "404C4FFB0038" | |
| exportControl "Public") | |
| (object ClassAttribute "NOT_EQUAL" | |
| quid "404C4FFF02BF" | |
| exportControl "Public") | |
| (object ClassAttribute "LESS_THAN" | |
| quid "404C500D019D" | |
| exportControl "Public") | |
| (object ClassAttribute "GREATER_THAN" | |
| quid "404C5013035E" | |
| exportControl "Public") | |
| (object ClassAttribute "LESS_THAN_OR_EQUAL" | |
| quid "404C501E027E" | |
| exportControl "Public") | |
| (object ClassAttribute "GREATER_THAN_OR_EQUAL" | |
| quid "404C5025013D" | |
| exportControl "Public"))) | |
| (object Class "SearchConditionCombinedOperator" | |
| quid "3B3A0FC50214" | |
| stereotype "enumeration" | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "AND" | |
| quid "404C519C004C" | |
| exportControl "Public") | |
| (object ClassAttribute "OR" | |
| quid "404C51A002B5" | |
| exportControl "Public"))) | |
| (object Class "TableJoinedOperator" | |
| quid "3B3A10F70322" | |
| stereotype "enumeration" | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "DEFAULT_INNER" | |
| quid "4049232D006E" | |
| exportControl "Public") | |
| (object ClassAttribute "EXPLICIT_INNER" | |
| quid "4049233501BA" | |
| exportControl "Public") | |
| (object ClassAttribute "LEFT_OUTER" | |
| quid "404923460218" | |
| exportControl "Public") | |
| (object ClassAttribute "RIGHT_OUTER" | |
| quid "4049234B0284" | |
| exportControl "Public") | |
| (object ClassAttribute "FULL_OUTER" | |
| quid "40492353025D" | |
| exportControl "Public"))) | |
| (object Class "QueryCombinedOperator" | |
| quid "3B3A1F54022F" | |
| documentation | |
| |UNION=1 | |
| |UNION_ALL=2 | |
| |INTERSECT=3 | |
| |INTERSECT_ALL=4 | |
| |EXCEPT=5 | |
| |EXCEPT_ALL=6 | |
| stereotype "enumeration" | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "UNION" | |
| quid "4049175800CC" | |
| exportControl "Public") | |
| (object ClassAttribute "UNION_ALL" | |
| quid "4049177101D7" | |
| exportControl "Public") | |
| (object ClassAttribute "INTERSECT" | |
| quid "4049178B02ED" | |
| exportControl "Public") | |
| (object ClassAttribute "INTERSECT_ALL" | |
| quid "404917940028" | |
| exportControl "Public") | |
| (object ClassAttribute "EXCEPT" | |
| quid "4049179D01E4" | |
| exportControl "Public") | |
| (object ClassAttribute "EXCEPT_ALL" | |
| quid "404917A20213" | |
| exportControl "Public"))) | |
| (object Class "ValueExpressionUnaryOperator" | |
| quid "3B3A5E0F015F" | |
| stereotype "enumeration" | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "NONE" | |
| quid "404D097D0065" | |
| exportControl "Public") | |
| (object ClassAttribute "PLUS" | |
| quid "404D0987015A" | |
| exportControl "Public") | |
| (object ClassAttribute "MINUS" | |
| quid "404D098B00DD" | |
| exportControl "Public"))) | |
| (object Class "ValueExpressionCombinedOperator" | |
| quid "3B3A5E3B0357" | |
| stereotype "enumeration" | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "ADD" | |
| quid "404CE20400FB" | |
| exportControl "Public") | |
| (object ClassAttribute "SUBTRACT" | |
| quid "404CE20800D9" | |
| exportControl "Public") | |
| (object ClassAttribute "MULTIPLY" | |
| quid "404CE20C037D" | |
| exportControl "Public") | |
| (object ClassAttribute "DIVIDE" | |
| quid "404CE2120209" | |
| exportControl "Public") | |
| (object ClassAttribute "CONCATENATE" | |
| quid "404CE2160183" | |
| exportControl "Public"))) | |
| (object Class "ValueExpressionLabeledDurationType" | |
| quid "3B3A62830230" | |
| stereotype "enumeration" | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "YEARS" | |
| quid "404CE14E0153" | |
| exportControl "Public") | |
| (object ClassAttribute "MONTHS" | |
| quid "404CE143011B" | |
| exportControl "Public") | |
| (object ClassAttribute "DAYS" | |
| quid "404CE12301F2" | |
| exportControl "Public") | |
| (object ClassAttribute "HOURS" | |
| quid "404CE12900F6" | |
| exportControl "Public") | |
| (object ClassAttribute "MINUTES" | |
| quid "404CE13E01B5" | |
| exportControl "Public") | |
| (object ClassAttribute "SECONDS" | |
| quid "404CE148010F" | |
| exportControl "Public") | |
| (object ClassAttribute "MICROSECONDS" | |
| quid "404CE1320398" | |
| exportControl "Public"))) | |
| (object Class "TableInDatabase" | |
| quid "3BF3D3560327" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3BF3D3DA011E" | |
| supplier "Logical View::SQLQueryModel::TableExpression" | |
| quidu "3B37EE600288"))) | |
| (object Class "TableFunction" | |
| quid "3BF3D3E801A0" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "3BF3D3F70129" | |
| supplier "Logical View::SQLQueryModel::TableExpression" | |
| quidu "3B37EE600288"))) | |
| (object Class "SQLQueryObject" | |
| quid "4046839E02AB" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404683B902A0" | |
| supplier "Logical View::SQLModel::Schema::SQLObject" | |
| quidu "3E9B3EB5002B")) | |
| operations (list Operations | |
| (object Operation "getSQL" | |
| quid "404776F300CD" | |
| result "String" | |
| concurrency "Sequential" | |
| opExportControl "Public" | |
| uid 0) | |
| (object Operation "setSQL" | |
| quid "4193EFDF01E7" | |
| parameters (list Parameters | |
| (object Parameter "sqlText" | |
| quid "4193EFF503DE" | |
| type "String")) | |
| result "void" | |
| concurrency "Sequential" | |
| opExportControl "Public" | |
| uid 0)) | |
| abstract TRUE) | |
| (object Class "QueryChangeStatement" | |
| quid "40490E600298" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "40490EDD0342" | |
| supplier "Logical View::SQLQueryModel::QueryStatement" | |
| quidu "3B3785180139") | |
| (object Inheritance_Relationship | |
| quid "40490F930040" | |
| supplier "Logical View::SQLModel::Statements::SQLDataChangeStatement" | |
| quidu "40490973001D")) | |
| abstract TRUE) | |
| (object Class "ColumnName" | |
| quid "4049226F035A" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404923E20186" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "TableNested" | |
| quid "404924F0038D" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "40492517032F" | |
| supplier "Logical View::SQLQueryModel::TableReference" | |
| quidu "3B37EE200178"))) | |
| (object Class "QueryMergeStatement" | |
| quid "404C2AAB0232" | |
| documentation | |
| |SQL syntax: | |
| |MERGE INTO <target table> [ [ AS] <merge correlation name> ] | |
| |USING <table reference> | |
| |ON <search condition> | |
| |<merge operation specificaion list> | |
| | | |
| |where: | |
| |<merge operation specification list> ::= | |
| | <merge operation specification> [<merge operation specification ...] | |
| |<merge operation specification> ::= | |
| | <merge update specification> | <merge insert specification> | |
| | | |
| |Note: a non-syntactic rule is that the operation specification list can contain at most one update specification and one insert specification. | |
| | | |
| |Example: | |
| |MERGE INTO inventory AS in | |
| |USING | |
| | (SELECT partno, description, count | |
| | FROM shipment | |
| | WHERE shipment.partno IS NOT NULL) AS sh | |
| |ON (in.partno = sh.partno) | |
| |WHEN MATCHED THEN | |
| | UPDATE SET | |
| | description = sh.description, | |
| | quantity = in.quantity + sh.count | |
| |WHEN NOT MATCHED THEN | |
| | INSERT (partno, description, quantity) | |
| | VALUES (sh.partno, sh.description, sh.count) | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404C2AD802CD" | |
| supplier "Logical View::SQLQueryModel::QueryChangeStatement" | |
| quidu "40490E600298"))) | |
| (object Class "SearchConditionNested" | |
| quid "404C491D033E" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404C4949003E" | |
| supplier "Logical View::SQLQueryModel::QuerySearchCondition" | |
| quidu "3B378C160224"))) | |
| (object Class "ValueExpressionNested" | |
| quid "404CFF7601CC" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D00AA0067" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160"))) | |
| (object Class "ValueExpressionAtomic" | |
| quid "404CFF9003B4" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D00B20108" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160")) | |
| abstract TRUE) | |
| (object Class "OrderBySpecification" | |
| quid "404D14E20381" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D177802CE" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "descending" | |
| quid "404D15D90390" | |
| type "boolean" | |
| exportControl "Public") | |
| (object ClassAttribute "OrderingSpecOption" | |
| quid "435960AB0302" | |
| type "OrderingSpecType" | |
| quidu "43596054009A" | |
| exportControl "Public") | |
| (object ClassAttribute "NullOrderingOption" | |
| quid "435960E503C4" | |
| type "NullOrderingType" | |
| quidu "43595F9F031B" | |
| exportControl "Public")) | |
| abstract TRUE) | |
| (object Class "OrderByOrdinal" | |
| quid "404D1615021A" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "404D164E0244" | |
| supplier "Logical View::SQLQueryModel::OrderBySpecification" | |
| quidu "404D14E20381")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "ordinalValue" | |
| quid "404D18240069" | |
| type "int" | |
| exportControl "Public"))) | |
| (object Class "TableCorrelation" | |
| quid "412F8BD80253" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "412F9AEA0288" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "UpdateSource" | |
| quid "4176D9920095" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "417D47620183" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "UpdateSourceExprList" | |
| quid "4176DB070150" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "4176DB1E0118" | |
| supplier "Logical View::SQLQueryModel::UpdateSource" | |
| quidu "4176D9920095"))) | |
| (object Class "UpdateSourceQuery" | |
| quid "4176DB2502C7" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "4176DB3500B8" | |
| supplier "Logical View::SQLQueryModel::UpdateSource" | |
| quidu "4176D9920095"))) | |
| (object Class "OrderByResultColumn" | |
| quid "41AB8B39017F" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "41AB8B390193" | |
| supplier "Logical View::SQLQueryModel::OrderBySpecification" | |
| quidu "404D14E20381"))) | |
| (object Class "WithTableReference" | |
| quid "41F971470060" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "41F9736403D7" | |
| supplier "Logical View::SQLQueryModel::TableExpression" | |
| quidu "3B37EE600288"))) | |
| (object Class "NullOrderingType" | |
| quid "43595F9F031B" | |
| stereotype "enumeration" | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "NONE" | |
| quid "4359602403C6" | |
| exportControl "Public") | |
| (object ClassAttribute "NULLS_FIRST" | |
| quid "4359600E02FC" | |
| exportControl "Public") | |
| (object ClassAttribute "NULLS_LAST" | |
| quid "4359601A03CC" | |
| exportControl "Public"))) | |
| (object Class "OrderingSpecType" | |
| quid "43596054009A" | |
| stereotype "enumeration" | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "NONE" | |
| quid "435960820349" | |
| exportControl "Public") | |
| (object ClassAttribute "ASC" | |
| quid "435960720075" | |
| exportControl "Public") | |
| (object ClassAttribute "DESC" | |
| quid "4359607903BE" | |
| exportControl "Public"))) | |
| (object Class "QueryNested" | |
| quid "4445534B01A5" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "4445535D0014" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionBody" | |
| quidu "3B37924A01CC"))) | |
| (object Class "ValueExpressionRow" | |
| quid "486BD0B001FE" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "486BD0EC01DE" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160"))) | |
| (object Class "MergeTargetTable" | |
| quid "49717CEF01B5" | |
| documentation | |
| |SQL syntax: | |
| |<target table> [[AS] <merge correlation name>] | |
| | | |
| |where: | |
| |<target table> is a simple or qualified table name. | |
| |<merge correlation name> is a simple identifier | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "49718C4D0119" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "MergeSourceTable" | |
| quid "49717F4B0271" | |
| documentation | |
| |SQL syntax: | |
| |<table reference> | |
| | | |
| |The source table reference can be a table name, a query (SELECT expression), a joined table, a table function... | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "49718C5002FD" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "MergeOnCondition" | |
| quid "4971822C0148" | |
| documentation | |
| |SQL syntax: | |
| |<search condition> | |
| | | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "49718C5501E4" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "MergeUpdateSpecification" | |
| quid "4971844B003E" | |
| documentation | |
| |SQL syntax: | |
| |WHEN MATCHED THEN UPDATE SET <set clause list> | |
| | | |
| |where | |
| |<set clause list> is a list of assignement expressions, such as | |
| | description = sh.description | |
| | | |
| |The assignment expression list is modelled as a list of UpdateAssignementExpression objects, which in the general case can have a query exrpession as the assignement source, but for Merge only simple assignment list is allowed. | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "498A42D50148" | |
| supplier "Logical View::SQLQueryModel::MergeOperationSpecification" | |
| quidu "498A415902FD"))) | |
| (object Class "MergeInsertSpecification" | |
| quid "497185E60242" | |
| documentation | |
| |SQL syntax: | |
| |WHEN NOT MATCHED THEN | |
| |INSERT <target column list> | |
| |VALUES <insert value list> | |
| | | |
| |where | |
| |<target column list> is a simple list of column names | |
| |<insert value list> is a list of value expressions | |
| | | |
| |Note that the MergeInsertSpecification object does not "own" the column objects in the target column list. They are "owned" by the table object in the MergeTargetTable | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "498A42D90271" | |
| supplier "Logical View::SQLQueryModel::MergeOperationSpecification" | |
| quidu "498A415902FD"))) | |
| (object Class "MergeOperationSpecification" | |
| quid "498A415902FD" | |
| documentation | |
| |SQL syntax: | |
| |<merge update specification> | <merge insert specification> | |
| | | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "498A4354034B" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "UpdateOfColumn" | |
| quid "49C49424033C" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "49C4946702FD" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "UpdatabilityType" | |
| quid "49C6948D0242" | |
| stereotype "enumeration" | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "READ_ONLY" | |
| quid "49C6956500DA" | |
| exportControl "Public") | |
| (object ClassAttribute "UPDATE" | |
| quid "49C695890000" | |
| exportControl "Public"))) | |
| (object Class "UpdatabilityExpression" | |
| quid "49C69615004E" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "49C6965C000F" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB")) | |
| class_attributes (list class_attribute_list | |
| (object ClassAttribute "updatabilityType" | |
| quid "49C6967C0213" | |
| type "UpdatabilityType" | |
| quidu "49C6948D0242" | |
| exportControl "Public"))) | |
| (object Class "CallStatement" | |
| quid "4B50CD41004E" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "4B50CD550213" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB") | |
| (object Inheritance_Relationship | |
| quid "4B50CD59037A" | |
| supplier "Logical View::SQLModel::Statements::SQLControlStatement" | |
| quidu "4049095A0220"))) | |
| (object Class "ProcedureReference" | |
| quid "4BC79E0202DE" | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "4BC79E290203" | |
| supplier "Logical View::SQLQueryModel::SQLQueryObject" | |
| quidu "4046839E02AB"))) | |
| (object Class "TableQueryLateral" | |
| quid "4E98855000BB" | |
| documentation | |
| |A "lateral" table query is a query that appears in the FROM clause. However it is semantically different from a regular FROM clause query in that the lateral table query can itself contain references to other tables defined before (that is, to the left of it) in the same FROM clause. Regular FROM clause queries can only refer to tables defined at a higher level in the statement. In ISO SQL a lateral table query expression is prefixed by the keyword LATERAL. (The DB2 SQL dialects prefix the lateral query table with the keyword TABLE.) | |
| | | |
| |For example, here is a statement containing a lateral table query expression: | |
| | | |
| |SELECT d.dept_name, e.emp_name | |
| | FROM dept d, LATERAL( | |
| | SELECT emp_id, emp_name | |
| | FROM emp | |
| | WHERE emp_dept = d.dept_id ) as e | |
| | | |
| |The reference to d.dept_id is legal in a lateral table query, but would not be legal in a regular table query expression. | |
| superclasses (list inheritance_relationship_list | |
| (object Inheritance_Relationship | |
| quid "4E98856A034B" | |
| supplier "Logical View::SQLQueryModel::TableExpression" | |
| quidu "3B37EE600288"))) | |
| (object Association "$UNNAMED$0" | |
| quid "3B37928901A5" | |
| roles (list role_list | |
| (object Role "updateStatement" | |
| quid "3B37928A002A" | |
| label "updateStatement" | |
| supplier "Logical View::SQLQueryModel::QueryUpdateStatement" | |
| quidu "3B3785760076" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "assignmentClause" | |
| quid "3B37928A0034" | |
| label "assignmentClause" | |
| supplier "Logical View::SQLQueryModel::UpdateAssignmentExpression" | |
| quidu "3B378BF6015F" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$1" | |
| quid "3B37928B0298" | |
| roles (list role_list | |
| (object Role "updateStatement" | |
| quid "3B37928C009B" | |
| label "updateStatement" | |
| supplier "Logical View::SQLQueryModel::QueryUpdateStatement" | |
| quidu "3B3785760076" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "whereCurrentOfClause" | |
| quid "3B37928C00A5" | |
| label "whereCurrentOfClause" | |
| supplier "Logical View::SQLQueryModel::CursorReference" | |
| quidu "3B378C08021A" | |
| client_cardinality (value cardinality "0..1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$2" | |
| quid "3B37928F0153" | |
| roles (list role_list | |
| (object Role "updateStatement" | |
| quid "3B37928F0352" | |
| label "updateStatement" | |
| supplier "Logical View::SQLQueryModel::QueryUpdateStatement" | |
| quidu "3B3785760076" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "whereClause" | |
| attributes (list Attribute_Set | |
| (object Attribute | |
| tool "Ecore" | |
| name "isUnsettable" | |
| value TRUE)) | |
| quid "3B37928F035C" | |
| label "whereClause" | |
| supplier "Logical View::SQLQueryModel::QuerySearchCondition" | |
| quidu "3B378C160224" | |
| client_cardinality (value cardinality "0..1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$3" | |
| quid "3B3792910387" | |
| roles (list role_list | |
| (object Role "updateStatement" | |
| attributes (list Attribute_Set) | |
| quid "3B379292028E" | |
| label "updateStatement" | |
| supplier "Logical View::SQLQueryModel::QueryUpdateStatement" | |
| quidu "3B3785760076" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "targetTable" | |
| attributes (list Attribute_Set | |
| (object Attribute | |
| tool "Ecore" | |
| name "isUnsettable" | |
| value TRUE)) | |
| quid "3B3792920298" | |
| label "targetTable" | |
| supplier "Logical View::SQLQueryModel::TableInDatabase" | |
| quidu "3BF3D3560327" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$4" | |
| quid "3B37935D03C6" | |
| roles (list role_list | |
| (object Role "assignmentExprTarget" | |
| quid "3B37935E01D3" | |
| label "assignmentExprTarget" | |
| supplier "Logical View::SQLQueryModel::UpdateAssignmentExpression" | |
| quidu "3B378BF6015F" | |
| is_navigable TRUE) | |
| (object Role "targetColumnList" | |
| quid "3B37935E01DD" | |
| label "targetColumnList" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionColumn" | |
| quidu "3B389EAF00BB" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$5" | |
| quid "3B3795650049" | |
| roles (list role_list | |
| (object Role "deleteStatement" | |
| quid "3B379565025C" | |
| label "deleteStatement" | |
| supplier "Logical View::SQLQueryModel::QueryDeleteStatement" | |
| quidu "3B378546017C" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "whereCurrentOfClause" | |
| quid "3B3795650266" | |
| label "whereCurrentOfClause" | |
| supplier "Logical View::SQLQueryModel::CursorReference" | |
| quidu "3B378C08021A" | |
| client_cardinality (value cardinality "0..1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$6" | |
| quid "3B3795670010" | |
| roles (list role_list | |
| (object Role "deleteStatement" | |
| quid "3B379567018C" | |
| label "deleteStatement" | |
| supplier "Logical View::SQLQueryModel::QueryDeleteStatement" | |
| quidu "3B378546017C" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "whereClause" | |
| attributes (list Attribute_Set | |
| (object Attribute | |
| tool "Ecore" | |
| name "isUnsettable" | |
| value TRUE)) | |
| quid "3B3795670196" | |
| label "whereClause" | |
| supplier "Logical View::SQLQueryModel::QuerySearchCondition" | |
| quidu "3B378C160224" | |
| client_cardinality (value cardinality "0..1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$7" | |
| quid "3B379568031E" | |
| roles (list role_list | |
| (object Role "deleteStatement" | |
| quid "3B3795690167" | |
| label "deleteStatement" | |
| supplier "Logical View::SQLQueryModel::QueryDeleteStatement" | |
| quidu "3B378546017C" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "targetTable" | |
| attributes (list Attribute_Set | |
| (object Attribute | |
| tool "Ecore" | |
| name "isUnsettable" | |
| value TRUE)) | |
| quid "3B3795690171" | |
| label "targetTable" | |
| supplier "Logical View::SQLQueryModel::TableInDatabase" | |
| quidu "3BF3D3560327" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$8" | |
| quid "3B37973E0021" | |
| roles (list role_list | |
| (object Role "insertStatement" | |
| quid "3B37973E02AC" | |
| label "insertStatement" | |
| supplier "Logical View::SQLQueryModel::QueryInsertStatement" | |
| quidu "3B3785520223" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "sourceQuery" | |
| quid "3B37973E02B6" | |
| label "sourceQuery" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionRoot" | |
| quidu "3B37968301D1" | |
| client_cardinality (value cardinality "0..1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$9" | |
| quid "3B37974000CE" | |
| roles (list role_list | |
| (object Role "insertStatement" | |
| quid "3B3797400309" | |
| label "insertStatement" | |
| supplier "Logical View::SQLQueryModel::QueryInsertStatement" | |
| quidu "3B3785520223" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "sourceValuesRowList" | |
| quid "3B379740030B" | |
| label "sourceValuesRowList" | |
| supplier "Logical View::SQLQueryModel::ValuesRow" | |
| quidu "3B3796910130" | |
| client_cardinality (value cardinality "0..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$10" | |
| quid "3B3797480120" | |
| roles (list role_list | |
| (object Role "insertStatement" | |
| attributes (list Attribute_Set) | |
| quid "3B3797480396" | |
| label "insertStatement" | |
| supplier "Logical View::SQLQueryModel::QueryInsertStatement" | |
| quidu "3B3785520223" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "targetTable" | |
| attributes (list Attribute_Set | |
| (object Attribute | |
| tool "Ecore" | |
| name "isUnsettable" | |
| value TRUE)) | |
| quid "3B37974803AB" | |
| label "targetTable" | |
| supplier "Logical View::SQLQueryModel::TableInDatabase" | |
| quidu "3BF3D3560327" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$11" | |
| quid "3B37974E00C4" | |
| roles (list role_list | |
| (object Role "valuesRow" | |
| quid "3B37974E02D7" | |
| label "valuesRow" | |
| supplier "Logical View::SQLQueryModel::ValuesRow" | |
| quidu "3B3796910130" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "exprList" | |
| quid "3B37974E02D9" | |
| label "exprList" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$12" | |
| quid "3B37EF760210" | |
| roles (list role_list | |
| (object Role "tableJoined" | |
| quid "3B37EF770117" | |
| label "tableJoined" | |
| supplier "Logical View::SQLQueryModel::TableJoined" | |
| quidu "3B37EEB00323" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "joinCondition" | |
| quid "3B37EF770121" | |
| label "joinCondition" | |
| supplier "Logical View::SQLQueryModel::QuerySearchCondition" | |
| quidu "3B378C160224" | |
| client_cardinality (value cardinality "0..1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$13" | |
| quid "3B37EFFB0315" | |
| roles (list role_list | |
| (object Role "tableJoinedRight" | |
| quid "3B37EFFD01CE" | |
| label "tableJoinedRight" | |
| supplier "Logical View::SQLQueryModel::TableJoined" | |
| quidu "3B37EEB00323" | |
| client_cardinality (value cardinality "1") | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "tableRefRight" | |
| quid "3B37EFFD01D8" | |
| label "tableRefRight" | |
| supplier "Logical View::SQLQueryModel::TableReference" | |
| quidu "3B37EE200178" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$14" | |
| quid "3B37F011008C" | |
| roles (list role_list | |
| (object Role "tableJoinedLeft" | |
| quid "3B37F01200E8" | |
| label "tableJoinedLeft" | |
| supplier "Logical View::SQLQueryModel::TableJoined" | |
| quidu "3B37EEB00323" | |
| client_cardinality (value cardinality "1") | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "tableRefLeft" | |
| quid "3B37F01200F2" | |
| label "tableRefLeft" | |
| supplier "Logical View::SQLQueryModel::TableReference" | |
| quidu "3B37EE200178" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$15" | |
| quid "3B37F2020023" | |
| roles (list role_list | |
| (object Role "combinedLeft" | |
| quid "3B37F203013C" | |
| label "combinedLeft" | |
| supplier "Logical View::SQLQueryModel::SearchConditionCombined" | |
| quidu "3B37F1CF032C" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "leftCondition" | |
| quid "3B37F2030147" | |
| label "leftCondition" | |
| supplier "Logical View::SQLQueryModel::QuerySearchCondition" | |
| quidu "3B378C160224" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$16" | |
| quid "3B37F20B027E" | |
| roles (list role_list | |
| (object Role "combinedRight" | |
| quid "3B37F20C0262" | |
| label "combinedRight" | |
| supplier "Logical View::SQLQueryModel::SearchConditionCombined" | |
| quidu "3B37F1CF032C" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "rightCondition" | |
| quid "3B37F20C0264" | |
| label "rightCondition" | |
| supplier "Logical View::SQLQueryModel::QuerySearchCondition" | |
| quidu "3B378C160224" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$17" | |
| quid "3B37F3F302B2" | |
| roles (list role_list | |
| (object Role "selectStatement" | |
| quid "3B37F3F400A1" | |
| label "selectStatement" | |
| supplier "Logical View::SQLQueryModel::QuerySelectStatement" | |
| quidu "3B37856000BB" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "queryExpr" | |
| quid "3B37F3F400A3" | |
| label "queryExpr" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionRoot" | |
| quidu "3B37968301D1" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$18" | |
| quid "3B37F3F503CD" | |
| roles (list role_list | |
| (object Role "selectStatement" | |
| quid "3B37F3F6018A" | |
| label "selectStatement" | |
| supplier "Logical View::SQLQueryModel::QuerySelectStatement" | |
| quidu "3B37856000BB" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "orderByClause" | |
| quid "3B37F3F60194" | |
| label "orderByClause" | |
| supplier "Logical View::SQLQueryModel::OrderBySpecification" | |
| quidu "404D14E20381" | |
| client_cardinality (value cardinality "0..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$19" | |
| quid "3B37F3F80183" | |
| roles (list role_list | |
| (object Role "orderByValueExpr" | |
| quid "3B37F3F80350" | |
| label "orderByValueExpr" | |
| supplier "Logical View::SQLQueryModel::OrderByValueExpression" | |
| quidu "3B37F35A0212" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExpr" | |
| quid "3B37F3F80352" | |
| label "valueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$20" | |
| quid "3B37F3FB0368" | |
| roles (list role_list | |
| (object Role "queryExpressionRoot " | |
| quid "3B37F3FC0189" | |
| label "queryExpressionRoot " | |
| supplier "Logical View::SQLQueryModel::QueryExpressionRoot" | |
| quidu "3B37968301D1" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "withClause" | |
| quid "3B37F3FC0193" | |
| label "withClause" | |
| supplier "Logical View::SQLQueryModel::WithTableSpecification" | |
| quidu "3B37EEBD019C" | |
| client_cardinality (value cardinality "0..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$21" | |
| quid "3B37F408023A" | |
| roles (list role_list | |
| (object Role "queryExpression" | |
| quid "3B37F40900F1" | |
| label "queryExpression" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionRoot" | |
| quidu "3B37968301D1" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "query" | |
| quid "3B37F40900FB" | |
| label "query" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionBody" | |
| quidu "3B37924A01CC" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$22" | |
| quid "3B37F67B01C4" | |
| roles (list role_list | |
| (object Role "querySelectHaving" | |
| quid "3B37F67C007B" | |
| label "querySelectHaving" | |
| supplier "Logical View::SQLQueryModel::QuerySelect" | |
| quidu "3B37F44F02C8" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "havingClause" | |
| attributes (list Attribute_Set | |
| (object Attribute | |
| tool "Ecore" | |
| name "isUnsettable" | |
| value TRUE)) | |
| quid "3B37F67C0085" | |
| label "havingClause" | |
| supplier "Logical View::SQLQueryModel::QuerySearchCondition" | |
| quidu "3B378C160224" | |
| client_cardinality (value cardinality "0..1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$23" | |
| quid "3B37F67E0204" | |
| roles (list role_list | |
| (object Role "querySelectWhere" | |
| quid "3B37F67F013D" | |
| label "querySelectWhere" | |
| supplier "Logical View::SQLQueryModel::QuerySelect" | |
| quidu "3B37F44F02C8" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "whereClause" | |
| attributes (list Attribute_Set | |
| (object Attribute | |
| tool "Ecore" | |
| name "isUnsettable" | |
| value TRUE)) | |
| quid "3B37F67F013F" | |
| label "whereClause" | |
| supplier "Logical View::SQLQueryModel::QuerySearchCondition" | |
| quidu "3B378C160224" | |
| client_cardinality (value cardinality "0..1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$24" | |
| quid "3B37F6880259" | |
| roles (list role_list | |
| (object Role "querySelect" | |
| quid "3B37F6890174" | |
| label "querySelect" | |
| supplier "Logical View::SQLQueryModel::QuerySelect" | |
| quidu "3B37F44F02C8" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "groupByClause" | |
| quid "3B37F6890176" | |
| label "groupByClause" | |
| supplier "Logical View::SQLQueryModel::GroupingSpecification" | |
| quidu "3B37F63D0369" | |
| client_cardinality (value cardinality "0..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$25" | |
| quid "3B37F6900264" | |
| roles (list role_list | |
| (object Role "querySelect" | |
| quid "3B37F69102CA" | |
| label "querySelect" | |
| supplier "Logical View::SQLQueryModel::QuerySelect" | |
| quidu "3B37F44F02C8" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "selectClause" | |
| quid "3B37F69102CC" | |
| label "selectClause" | |
| supplier "Logical View::SQLQueryModel::QueryResultSpecification" | |
| quidu "3B37F66102FD" | |
| client_cardinality (value cardinality "0..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$26" | |
| quid "3B37F69401CA" | |
| roles (list role_list | |
| (object Role "querySelect" | |
| quid "3B37F69403B4" | |
| label "querySelect" | |
| supplier "Logical View::SQLQueryModel::QuerySelect" | |
| quidu "3B37F44F02C8" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "fromClause" | |
| quid "3B37F69403BE" | |
| label "fromClause" | |
| supplier "Logical View::SQLQueryModel::TableReference" | |
| quidu "3B37EE200178" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$27" | |
| quid "3B37F9D90051" | |
| roles (list role_list | |
| (object Role "resultColumn" | |
| quid "3B37F9D901AF" | |
| label "resultColumn" | |
| supplier "Logical View::SQLQueryModel::ResultColumn" | |
| quidu "3B37F947006F" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExpr" | |
| quid "3B37F9D901B1" | |
| label "valueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$28" | |
| quid "3B37FB2D01EA" | |
| roles (list role_list | |
| (object Role "basicRight" | |
| quid "3B37FB2D03A3" | |
| label "basicRight" | |
| supplier "Logical View::SQLQueryModel::PredicateBasic" | |
| quidu "3B37FA6F011F" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "rightValueExpr" | |
| quid "3B37FB2D03A5" | |
| label "rightValueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$29" | |
| quid "3B37FB2F0215" | |
| roles (list role_list | |
| (object Role "basicLeft" | |
| quid "3B37FB2F03CE" | |
| label "basicLeft" | |
| supplier "Logical View::SQLQueryModel::PredicateBasic" | |
| quidu "3B37FA6F011F" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "leftValueExpr" | |
| quid "3B37FB2F03D0" | |
| label "leftValueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$30" | |
| quid "3B37FB5501D4" | |
| roles (list role_list | |
| (object Role "likePattern" | |
| quid "3B37FB550396" | |
| label "likePattern" | |
| supplier "Logical View::SQLQueryModel::PredicateLike" | |
| quidu "3B37FAC702A2" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "patternValueExpr" | |
| quid "3B37FB550398" | |
| label "patternValueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$31" | |
| quid "3B37FB580282" | |
| roles (list role_list | |
| (object Role "likeMatching" | |
| quid "3B37FB59003F" | |
| label "likeMatching" | |
| supplier "Logical View::SQLQueryModel::PredicateLike" | |
| quidu "3B37FAC702A2" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "matchingValueExpr" | |
| quid "3B37FB590049" | |
| label "matchingValueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$32" | |
| quid "3B37FB600107" | |
| roles (list role_list | |
| (object Role "predicateNull" | |
| quid "3B37FB6002E8" | |
| label "predicateNull" | |
| supplier "Logical View::SQLQueryModel::PredicateIsNull" | |
| quidu "3B37FAD50324" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExpr" | |
| quid "3B37FB6002F2" | |
| label "valueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$33" | |
| quid "3B37FCD10176" | |
| roles (list role_list | |
| (object Role "inValueListRight" | |
| quid "3B37FCD20005" | |
| label "inValueListRight" | |
| supplier "Logical View::SQLQueryModel::PredicateInValueList" | |
| quidu "3B37FBF403E5" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExprList" | |
| quid "3B37FCD20007" | |
| label "valueExprList" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$34" | |
| quid "3B37FCD40044" | |
| roles (list role_list | |
| (object Role "inValueListLeft" | |
| quid "3B37FCD401AC" | |
| label "inValueListLeft" | |
| supplier "Logical View::SQLQueryModel::PredicateInValueList" | |
| quidu "3B37FBF403E5" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExpr" | |
| quid "3B37FCD401AE" | |
| label "valueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$35" | |
| quid "3B37FD6F00A1" | |
| roles (list role_list | |
| (object Role "inValueRowSelectLeft" | |
| quid "3B37FD6F0259" | |
| label "inValueRowSelectLeft" | |
| supplier "Logical View::SQLQueryModel::PredicateInValueRowSelect" | |
| quidu "3B37FC0B03C0" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExprList" | |
| quid "3B37FD6F0263" | |
| label "valueExprList" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$36" | |
| quid "3B37FD710234" | |
| roles (list role_list | |
| (object Role "inValueRowSelectRight" | |
| quid "3B37FD7103A7" | |
| label "inValueRowSelectRight" | |
| supplier "Logical View::SQLQueryModel::PredicateInValueRowSelect" | |
| quidu "3B37FC0B03C0" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "queryExpr" | |
| quid "3B37FD7103B1" | |
| label "queryExpr" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionRoot" | |
| quidu "3B37968301D1" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$37" | |
| quid "3B37FD7702A1" | |
| roles (list role_list | |
| (object Role "inValueSelectRight" | |
| quid "3B37FD780090" | |
| label "inValueSelectRight" | |
| supplier "Logical View::SQLQueryModel::PredicateInValueSelect" | |
| quidu "3B37FBE4017F" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "queryExpr" | |
| quid "3B37FD78009A" | |
| label "queryExpr" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionRoot" | |
| quidu "3B37968301D1" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$38" | |
| quid "3B37FD79036C" | |
| roles (list role_list | |
| (object Role "inValueSelectLeft" | |
| quid "3B37FD7A0165" | |
| label "inValueSelectLeft" | |
| supplier "Logical View::SQLQueryModel::PredicateInValueSelect" | |
| quidu "3B37FBE4017F" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExpr" | |
| quid "3B37FD7A016F" | |
| label "valueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$39" | |
| quid "3B37FD810255" | |
| roles (list role_list | |
| (object Role "quantifiedRowSelectRight" | |
| quid "3B37FD820044" | |
| label "quantifiedRowSelectRight" | |
| supplier "Logical View::SQLQueryModel::PredicateQuantifiedRowSelect" | |
| quidu "3B37FBB7024D" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "queryExpr" | |
| quid "3B37FD820046" | |
| label "queryExpr" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionRoot" | |
| quidu "3B37968301D1" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$40" | |
| quid "3B37FD83038F" | |
| roles (list role_list | |
| (object Role "quantifiedRowSelectLeft" | |
| quid "3B37FD840173" | |
| label "quantifiedRowSelectLeft" | |
| supplier "Logical View::SQLQueryModel::PredicateQuantifiedRowSelect" | |
| quidu "3B37FBB7024D" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExprList" | |
| quid "3B37FD840175" | |
| label "valueExprList" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$41" | |
| quid "3B37FD8502FB" | |
| roles (list role_list | |
| (object Role "quantifiedValueSelectRight" | |
| quid "3B37FD8600D6" | |
| label "quantifiedValueSelectRight" | |
| supplier "Logical View::SQLQueryModel::PredicateQuantifiedValueSelect" | |
| quidu "3B37FB9C03C0" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "queryExpr" | |
| quid "3B37FD8600E0" | |
| label "queryExpr" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionRoot" | |
| quidu "3B37968301D1" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$42" | |
| quid "3B37FD87024A" | |
| roles (list role_list | |
| (object Role "quantifiedValueSelectLeft" | |
| quid "3B37FD880010" | |
| label "quantifiedValueSelectLeft" | |
| supplier "Logical View::SQLQueryModel::PredicateQuantifiedValueSelect" | |
| quidu "3B37FB9C03C0" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExpr" | |
| quid "3B37FD880012" | |
| label "valueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$43" | |
| quid "3B37FE4D00D2" | |
| roles (list role_list | |
| (object Role "betweenLeft" | |
| quid "3B37FE4E0110" | |
| label "betweenLeft" | |
| supplier "Logical View::SQLQueryModel::PredicateBetween" | |
| quidu "3B37FA98004B" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "leftValueExpr" | |
| quid "3B37FE4E011A" | |
| label "leftValueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$44" | |
| quid "3B37FE530185" | |
| roles (list role_list | |
| (object Role "betweenRight1" | |
| quid "3B37FE540078" | |
| label "betweenRight1" | |
| supplier "Logical View::SQLQueryModel::PredicateBetween" | |
| quidu "3B37FA98004B" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "rightValueExpr1" | |
| quid "3B37FE540083" | |
| label "rightValueExpr1" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$45" | |
| quid "3B37FE560229" | |
| roles (list role_list | |
| (object Role "betweenRight2" | |
| quid "3B37FE570068" | |
| label "betweenRight2" | |
| supplier "Logical View::SQLQueryModel::PredicateBetween" | |
| quidu "3B37FA98004B" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "rightValueExpr2" | |
| quid "3B37FE570072" | |
| label "rightValueExpr2" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$46" | |
| quid "3B38A0AF031A" | |
| roles (list role_list | |
| (object Role "valueExpr" | |
| quid "3B38A0B00343" | |
| label "valueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "valueExprCast" | |
| quid "3B38A0B00375" | |
| label "valueExprCast" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCast" | |
| quidu "3B389F33029B" | |
| is_navigable TRUE | |
| is_aggregate TRUE))) | |
| (object Association "$UNNAMED$47" | |
| quid "3B38A10F0282" | |
| roles (list role_list | |
| (object Role "parameterList" | |
| quid "3B38A11800D6" | |
| label "parameterList" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "0..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "valueExprFunction" | |
| quid "3B38A1180108" | |
| label "valueExprFunction" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionFunction" | |
| quidu "3B389F78002D" | |
| is_navigable TRUE | |
| is_aggregate TRUE))) | |
| (object Association "$UNNAMED$48" | |
| quid "3B38A1D3032E" | |
| roles (list role_list | |
| (object Role "leftValueExpr" | |
| quid "3B38A1DD011F" | |
| label "leftValueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "valueExprCombinedLeft" | |
| quid "3B38A1DD015B" | |
| label "valueExprCombinedLeft" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCombined" | |
| quidu "3B389F8603D1" | |
| is_navigable TRUE | |
| is_aggregate TRUE))) | |
| (object Association "$UNNAMED$49" | |
| quid "3B38A25500FA" | |
| roles (list role_list | |
| (object Role "valueExprCombinedRight" | |
| quid "3B38A25C01FE" | |
| label "valueExprCombinedRight" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCombined" | |
| quidu "3B389F8603D1" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "rightValueExpr" | |
| quid "3B38A25C0208" | |
| label "rightValueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$50" | |
| quid "3B38A5230323" | |
| roles (list role_list | |
| (object Role "groupingSets" | |
| quid "3B38A5240112" | |
| label "groupingSets" | |
| supplier "Logical View::SQLQueryModel::GroupingSets" | |
| quidu "3B38A4DC01A4" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "groupingSetsElementList" | |
| quid "3B38A524011C" | |
| label "groupingSetsElementList" | |
| supplier "Logical View::SQLQueryModel::GroupingSetsElement" | |
| quidu "3B38A510018B" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$51" | |
| quid "3B38A5C0021A" | |
| roles (list role_list | |
| (object Role "groupingSetsElementExprList" | |
| quid "3B38A5C20368" | |
| label "groupingSetsElementExprList" | |
| supplier "Logical View::SQLQueryModel::GroupingSetsElementExpression" | |
| quidu "3B38A56901C5" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "groupingSetsElementSublist" | |
| quid "3B38A5C20372" | |
| label "groupingSetsElementSublist" | |
| supplier "Logical View::SQLQueryModel::GroupingSetsElementSublist" | |
| quidu "3B38A54D0297" | |
| is_navigable TRUE | |
| is_aggregate TRUE))) | |
| (object Association "$UNNAMED$52" | |
| quid "3B38A62A029F" | |
| roles (list role_list | |
| (object Role "groupingSetsElementExpr" | |
| quid "3B38A62C005D" | |
| label "groupingSetsElementExpr" | |
| supplier "Logical View::SQLQueryModel::GroupingSetsElementExpression" | |
| quidu "3B38A56901C5" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "grouping " | |
| quid "3B38A62C0067" | |
| label "grouping " | |
| supplier "Logical View::SQLQueryModel::Grouping" | |
| quidu "3B38A4EC0266" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$53" | |
| quid "3B38A70101E0" | |
| roles (list role_list | |
| (object Role "superGroupElementSublist" | |
| quid "3B38A7020340" | |
| label "superGroupElementSublist" | |
| supplier "Logical View::SQLQueryModel::SuperGroupElementSublist" | |
| quidu "3B38A6A1037C" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "superGroupElementExprList" | |
| quid "3B38A7020342" | |
| label "superGroupElementExprList" | |
| supplier "Logical View::SQLQueryModel::SuperGroupElementExpression" | |
| quidu "3B38A6AF026E" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$54" | |
| quid "3B38A731009E" | |
| roles (list role_list | |
| (object Role "superGroup" | |
| quid "3B38A7310289" | |
| label "superGroup" | |
| supplier "Logical View::SQLQueryModel::SuperGroup" | |
| quidu "3B38A6570326" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "superGroupElementList" | |
| quid "3B38A7310293" | |
| label "superGroupElementList" | |
| supplier "Logical View::SQLQueryModel::SuperGroupElement" | |
| quidu "3B38A6870389" | |
| client_cardinality (value cardinality "0..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$55" | |
| quid "3B38A78A002E" | |
| roles (list role_list | |
| (object Role "groupingExpr" | |
| quid "3B38A78A01FB" | |
| label "groupingExpr" | |
| supplier "Logical View::SQLQueryModel::GroupingExpression" | |
| quidu "3B38A6670094" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExpr" | |
| quid "3B38A78A0205" | |
| label "valueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$56" | |
| quid "3B38A7A50376" | |
| roles (list role_list | |
| (object Role "groupingExpr" | |
| quid "3B38A7A9015F" | |
| label "groupingExpr" | |
| supplier "Logical View::SQLQueryModel::GroupingExpression" | |
| quidu "3B38A6670094" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "superGroupElementExpr" | |
| quid "3B38A7A90169" | |
| label "superGroupElementExpr" | |
| supplier "Logical View::SQLQueryModel::SuperGroupElementExpression" | |
| quidu "3B38A6AF026E" | |
| is_navigable TRUE | |
| is_aggregate TRUE))) | |
| (object Association "$UNNAMED$57" | |
| quid "3B38A97000B9" | |
| roles (list role_list | |
| (object Role "valueExprCase" | |
| quid "3B38A9700362" | |
| label "valueExprCase" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCase" | |
| quidu "3B389F19026C" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "caseElse" | |
| quid "3B38A970036C" | |
| label "caseElse" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCaseElse" | |
| quidu "3B38A90D01A7" | |
| client_cardinality (value cardinality "0..1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$58" | |
| quid "3B38AA3102F2" | |
| roles (list role_list | |
| (object Role "valueExprCaseSimple" | |
| quid "3B38AA3200EA" | |
| label "valueExprCaseSimple" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCaseSimple" | |
| quidu "3B38A8EF0082" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "contentList" | |
| quid "3B38AA3200EC" | |
| label "contentList" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCaseSimpleContent" | |
| quidu "3B38A9C1019C" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$59" | |
| quid "3B38AAA4013E" | |
| roles (list role_list | |
| (object Role "valueExprCaseElse" | |
| quid "3B38AAA50077" | |
| label "valueExprCaseElse" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCaseElse" | |
| quidu "3B38A90D01A7" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExpr" | |
| quid "3B38AAA50081" | |
| label "valueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "0..1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$60" | |
| quid "3B38AACF019A" | |
| roles (list role_list | |
| (object Role "valueExprCaseSimple" | |
| quid "3B38AAD000E7" | |
| label "valueExprCaseSimple" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCaseSimple" | |
| quidu "3B38A8EF0082" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExpr" | |
| quid "3B38AAD000E9" | |
| label "valueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$61" | |
| quid "3B38AB040128" | |
| roles (list role_list | |
| (object Role "valueExprCaseSimpleContentWhen" | |
| quid "3B38AB0800CA" | |
| label "valueExprCaseSimpleContentWhen" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCaseSimpleContent" | |
| quidu "3B38A9C1019C" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "whenValueExpr" | |
| quid "3B38AB0800D4" | |
| label "whenValueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$62" | |
| quid "3B38AB0F02BF" | |
| roles (list role_list | |
| (object Role "valueExprCaseSimpleContentResult" | |
| quid "3B38AB1201DD" | |
| label "valueExprCaseSimpleContentResult" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCaseSimpleContent" | |
| quidu "3B38A9C1019C" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "resultValueExpr" | |
| quid "3B38AB1201DF" | |
| label "resultValueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$63" | |
| quid "3B38AB1701C6" | |
| roles (list role_list | |
| (object Role "valueExprCaseSearchContent" | |
| quid "3B38AB1903B3" | |
| label "valueExprCaseSearchContent" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCaseSearchContent" | |
| quidu "3B38A9A7034D" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "valueExpr" | |
| quid "3B38AB1903B5" | |
| label "valueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$64" | |
| quid "3B38ABC6011D" | |
| roles (list role_list | |
| (object Role "valueExprCaseSearchContent" | |
| quid "3B38ABC60330" | |
| label "valueExprCaseSearchContent" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCaseSearchContent" | |
| quidu "3B38A9A7034D" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "searchCondition" | |
| quid "3B38ABC60332" | |
| label "searchCondition" | |
| supplier "Logical View::SQLQueryModel::QuerySearchCondition" | |
| quidu "3B378C160224" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$65" | |
| quid "3B3A0F03019D" | |
| roles (list role_list | |
| (object Role "combinedLeft" | |
| quid "3B3A0F060101" | |
| label "combinedLeft" | |
| supplier "Logical View::SQLQueryModel::QueryCombined" | |
| quidu "3B37F42D0189" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "leftQuery" | |
| quid "3B3A0F06011F" | |
| label "leftQuery" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionBody" | |
| quidu "3B37924A01CC" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$66" | |
| quid "3B3A0F090214" | |
| roles (list role_list | |
| (object Role "combinedRight" | |
| quid "3B3A0F0C00CD" | |
| label "combinedRight" | |
| supplier "Logical View::SQLQueryModel::QueryCombined" | |
| quidu "3B37F42D0189" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "rightQuery" | |
| quid "3B3A0F0C00E1" | |
| label "rightQuery" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionBody" | |
| quidu "3B37924A01CC" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$67" | |
| quid "3B3A5AE7026B" | |
| roles (list role_list | |
| (object Role "predicateExists" | |
| quid "3B3A5AE800C8" | |
| label "predicateExists" | |
| supplier "Logical View::SQLQueryModel::PredicateExists" | |
| quidu "3B37FAA50158" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "queryExpr" | |
| quid "3B3A5AE800D2" | |
| label "queryExpr" | |
| supplier "Logical View::SQLQueryModel::QueryExpressionBody" | |
| quidu "3B37924A01CC" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$68" | |
| quid "3B3A5B53039D" | |
| roles (list role_list | |
| (object Role "likeEscape" | |
| quid "3B3A5B54018C" | |
| label "likeEscape" | |
| supplier "Logical View::SQLQueryModel::PredicateLike" | |
| quidu "3B37FAC702A2" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "escapeValueExpr" | |
| quid "3B3A5B54018E" | |
| label "escapeValueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "0..1") | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$69" | |
| quid "3B3A5BBF0226" | |
| roles (list role_list | |
| (object Role "querySelect" | |
| quid "3B3A5BC0003C" | |
| label "querySelect" | |
| supplier "Logical View::SQLQueryModel::QuerySelect" | |
| quidu "3B37F44F02C8" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "intoClause" | |
| quid "3B3A5BC00046" | |
| label "intoClause" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionVariable" | |
| quidu "3B389EC5029D" | |
| client_cardinality (value cardinality "0..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$70" | |
| quid "3B3A684C0244" | |
| roles (list role_list | |
| (object Role "valueExpr" | |
| quid "3B3A684F0176" | |
| label "valueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "valueExprLabeledDuration" | |
| quid "3B3A684F01D0" | |
| label "valueExprLabeledDuration" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionLabeledDuration" | |
| quidu "3B389EF70385" | |
| is_navigable TRUE | |
| is_aggregate TRUE))) | |
| (object Association "$UNNAMED$71" | |
| quid "3B8C1E7D0239" | |
| roles (list role_list | |
| (object Role "parentTableExpr" | |
| attributes (list Attribute_Set | |
| (object Attribute | |
| tool "Ecore" | |
| name "isUnsettable" | |
| value TRUE)) | |
| quid "3B8C1E7E0168" | |
| label "parentTableExpr" | |
| supplier "Logical View::SQLQueryModel::TableExpression" | |
| quidu "3B37EE600288" | |
| client_cardinality (value cardinality "1") | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "columnList" | |
| attributes (list Attribute_Set | |
| (object Attribute | |
| tool "eCore" | |
| name "isTransient" | |
| value FALSE)) | |
| quid "3B8C1E7E0172" | |
| label "columnList" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionColumn" | |
| quidu "3B389EAF00BB" | |
| client_cardinality (value cardinality "0..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$72" | |
| quid "3BDE1A410126" | |
| roles (list role_list | |
| (object Role "valueExprCaseSearch" | |
| quid "3BDE1A4103C5" | |
| label "valueExprCaseSearch" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCaseSearch" | |
| quidu "3B38A8D00055" | |
| is_navigable TRUE | |
| is_aggregate TRUE) | |
| (object Role "searchContentList" | |
| quid "3BDE1A4103D0" | |
| label "searchContentList" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionCaseSearchContent" | |
| quidu "3B38A9A7034D" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$73" | |
| quid "404925200025" | |
| roles (list role_list | |
| (object Role "nestedTableRef" | |
| quid "404925230029" | |
| label "nestedTableRef" | |
| supplier "Logical View::SQLQueryModel::TableReference" | |
| quidu "3B37EE200178" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "nest" | |
| quid "404925230034" | |
| label "nest" | |
| supplier "Logical View::SQLQueryModel::TableNested" | |
| quidu "404924F0038D" | |
| is_navigable TRUE | |
| is_aggregate TRUE))) | |
| (object Association "$UNNAMED$74" | |
| quid "404C4A000222" | |
| roles (list role_list | |
| (object Role "nestedCondition" | |
| quid "404C4A030384" | |
| label "nestedCondition" | |
| supplier "Logical View::SQLQueryModel::QuerySearchCondition" | |
| quidu "3B378C160224" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "nest" | |
| quid "404C4A030398" | |
| label "nest" | |
| supplier "Logical View::SQLQueryModel::SearchConditionNested" | |
| quidu "404C491D033E" | |
| is_navigable TRUE | |
| is_aggregate TRUE))) | |
| (object Association "$UNNAMED$75" | |
| quid "404D1D93022C" | |
| roles (list role_list | |
| (object Role "nestedValueExpr" | |
| quid "404D1D9602EE" | |
| label "nestedValueExpr" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "nest" | |
| quid "404D1D960316" | |
| label "nest" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionNested" | |
| quidu "404CFF7601CC" | |
| is_navigable TRUE | |
| is_aggregate TRUE))) | |
| (object Association "$UNNAMED$76" | |
| quid "412F75A3032D" | |
| roles (list role_list | |
| (object Role "databaseTable " | |
| quid "412F75A50055" | |
| label "databaseTable " | |
| supplier "Logical View::SQLModel::Tables::Table" | |
| quidu "3E9B1FB60047" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Reference" | |
| is_navigable TRUE) | |
| (object Role "$UNNAMED$77" | |
| quid "412F75A50073" | |
| supplier "Logical View::SQLQueryModel::TableInDatabase" | |
| quidu "3BF3D3560327"))) | |
| (object Association "$UNNAMED$78" | |
| quid "412F8CBC0208" | |
| roles (list role_list | |
| (object Role "tableCorrelation" | |
| quid "412F8CBE0297" | |
| label "tableCorrelation" | |
| supplier "Logical View::SQLQueryModel::TableCorrelation" | |
| quidu "412F8BD80253" | |
| client_cardinality (value cardinality "0..1") | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "tableExpr" | |
| quid "412F8CBE02BF" | |
| label "tableExpr" | |
| supplier "Logical View::SQLQueryModel::TableExpression" | |
| quidu "3B37EE600288" | |
| is_navigable TRUE | |
| is_aggregate TRUE))) | |
| (object Association "$UNNAMED$79" | |
| quid "412F8DAA01C1" | |
| roles (list role_list | |
| (object Role "columnNameList" | |
| quid "412F8DAB02BD" | |
| label "columnNameList" | |
| supplier "Logical View::SQLQueryModel::ColumnName" | |
| quidu "4049226F035A" | |
| client_cardinality (value cardinality "0..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "tableCorrelation" | |
| quid "412F8DAB02C7" | |
| label "tableCorrelation" | |
| supplier "Logical View::SQLQueryModel::TableCorrelation" | |
| quidu "412F8BD80253" | |
| is_navigable TRUE | |
| is_aggregate TRUE))) | |
| (object Association "$UNNAMED$80" | |
| quid "412F99C002F9" | |
| roles (list role_list | |
| (object Role "targetColumnList" | |
| quid "412F99C102FA" | |
| label "targetColumnList" | |
| supplier "Logical View::SQLQueryModel::ValueExpressionColumn" | |
| quidu "3B389EAF00BB" | |
| client_cardinality (value cardinality "0..n") | |
| Constraints "ordered" | |
| Containment "By Reference" | |
| is_navigable TRUE) | |
| (object Role "insertStatement" | |
| quid "412F99C1030F" | |
| label "insertStatement" | |
| supplier "Logical View::SQLQueryModel::QueryInsertStatement" | |
| quidu "3B3785520223" | |
| is_navigable TRUE))) | |
| (object Association "$UNNAMED$81" | |
| quid "4176D9FF033E" | |
| roles (list role_list | |
| (object Role "updateSource" | |
| quid "4176DA000335" | |
| label "updateSource" | |
| supplier "Logical View::SQLQueryModel::UpdateSource" | |
| quidu "4176D9920095" | |
| client_cardinality (value cardinality "1") | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "updateAssignmentExpr" | |
| quid "4176DA000337" | |
| label "updateAssignmentExpr" | |
| supplier "Logical View::SQLQueryModel::UpdateAssignmentExpression" | |
| quidu "3B378BF6015F" | |
| is_navigable TRUE | |
| is_aggregate TRUE))) | |
| (object Association "$UNNAMED$82" | |
| quid "4176DB4E0000" | |
| roles (list role_list | |
| (object Role "valueExprList" | |
| quid "4176DB4F03C3" | |
| label "valueExprList" | |
| supplier "Logical View::SQLQueryModel::QueryValueExpression" | |
| quidu "3B3792520160" | |
| client_cardinality (value cardinality "1..n") | |
| Constraints "ordered" | |
| Containment "By Value" | |
| is_navigable TRUE) | |
| (object Role "updateSourceExprList" | |
| quid "4176DB4F03D7" | |
| label "updateSourceExprList" | |
| supplier "Logical View::SQLQueryModel::UpdateSourceExprList" | |
| quidu "4176DB070150" | |