validateproperties.query.resgood

Pegasus is an open-source implementationof the DMTF CIM and WBEM standards. It is designed to be por

Using root/SampleProvider as default namespace.
======Validate Properties Results=======
======================================0
SELECT NonExistent FROM CQL_TestElement 
-----The property NonExistent does not exist on class CQL_TestElement.
======================================1
SELECT * FROM CQL_TestElement  WHERE NonExistent = 3
-----The property NonExistent does not exist on class CQL_TestElement.
======================================2
SELECT PropertyString FROM CQL_TestElement 
-----The property PropertyString does not exist on class CQL_TestElement.
======================================3
SELECT * FROM CQL_TestElement  WHERE PropertyString = 'abc'
-----The property PropertyString does not exist on class CQL_TestElement.
======================================4
SELECT InstanceID,NotThere FROM CQL_TestElement 
-----The property NotThere does not exist on class CQL_TestElement.
======================================5
SELECT NotThere1,NotThere2 FROM CQL_TestElement 
-----The property NotThere1 does not exist on class CQL_TestElement.
======================================6
SELECT * FROM CQL_TestElement  WHERE InstanceID = 3 AND NotThere = 'abc'
-----The property NotThere does not exist on class CQL_TestElement.
======================================7
SELECT InstanceID FROM CQL_TestElement 
----- validate ok
======================================8
SELECT * FROM CQL_TestElement  WHERE InstanceID = 3
----- validate ok
======================================9
SELECT InstanceID FROM CQL_TestPropertyTypes 
----- validate ok
======================================10
SELECT * FROM CQL_TestPropertyTypes  WHERE InstanceID = 3
----- validate ok
======================================11
SELECT CQL_NonExistent.InstanceID FROM CQL_TestElement 
-----The identifier InstanceID of CQL_TestElement.CQL_NonExistent.InstanceID must use the scope operator.
======================================12
SELECT * FROM CQL_TestElement  WHERE CQL_NonExistent.InstanceID = 3
-----The identifier InstanceID of CQL_TestElement.CQL_NonExistent.InstanceID must use the scope operator.
======================================13
SELECT CQL_TestElement.InstanceID FROM CQL_TestElement 
----- validate ok
======================================14
SELECT * FROM CQL_TestElement  WHERE CQL_TestElement.InstanceID = 3
----- validate ok
======================================15
SELECT alias.InstanceID FROM CQL_TestElement AS alias 
----- validate ok
======================================16
SELECT * FROM CQL_TestElement AS alias  WHERE alias.InstanceID = 3
----- validate ok
======================================17
SELECT CQL_TestElement.NotThere FROM CQL_TestElement 
-----The property NotThere does not exist on class CQL_TestElement.
======================================18
SELECT * FROM CQL_TestElement  WHERE CQL_TestElement.NotThere = 3
-----The property NotThere does not exist on class CQL_TestElement.
======================================19
SELECT alias.NotThere FROM CQL_TestElement AS alias 
-----The property NotThere does not exist on class CQL_TestElement.
======================================20
SELECT * FROM CQL_TestElement AS alias  WHERE alias.NotThere = 3
-----The property NotThere does not exist on class CQL_TestElement.
======================================21
SELECT CQL_NotThere::someprop FROM CQL_TestElement 
-----The class CQL_NotThere does not exist.
======================================22
SELECT CQL_TestElement.CQL_NotThere::someprop FROM CQL_TestElement 
-----The class CQL_NotThere does not exist.
======================================23
SELECT alias.CQL_NotThere::someprop FROM CQL_TestElement AS alias 
-----The class CQL_NotThere does not exist.
======================================24
SELECT CIM_ComputerSystem::EnabledState FROM CQL_TestElement 
-----The class CIM_ComputerSystem is not a superclass, subclass, or the same class as CQL_TestElement.
======================================25
SELECT CQL_TestElement.CIM_ComputerSystem::EnabledState FROM CQL_TestElement AS alias 
-----The class CIM_ComputerSystem is not a superclass, subclass, or the same class as CQL_TestElement.
======================================26
SELECT alias.CIM_ComputerSystem::EnabledState FROM CQL_TestElement AS alias 
-----The class CIM_ComputerSystem is not a superclass, subclass, or the same class as CQL_TestElement.
======================================27
SELECT CQL_TestElement::InstanceID FROM CQL_TestPropertyTypes 
----- validate ok
======================================28
SELECT CQL_TestPropertyTypes.CQL_TestElement::InstanceID FROM CQL_TestPropertyTypes 
----- validate ok
======================================29
SELECT alias.CQL_TestElement::InstanceID FROM CQL_TestPropertyTypes AS alias 
----- validate ok
======================================30
SELECT CQL_TestPropertyTypes::InstanceID FROM CQL_TestPropertyTypes 
----- validate ok
======================================31
SELECT CQL_TestPropertyTypes.CQL_TestPropertyTypes::InstanceID FROM CQL_TestPropertyTypes 
----- validate ok
======================================32
SELECT alias.CQL_TestPropertyTypes::InstanceID FROM CQL_TestPropertyTypes AS alias 
----- validate ok
======================================33
SELECT CQL_TestPropertyTypes::PropertyString FROM CQL_TestPropertyTypes 
----- validate ok
======================================34
SELECT CQL_TestPropertyTypes.CQL_TestPropertyTypes::PropertyString FROM CQL_TestPropertyTypes 
----- validate ok
======================================35
SELECT alias.CQL_TestPropertyTypes::PropertyString FROM CQL_TestPropertyTypes AS alias 
----- validate ok
======================================36
SELECT alias::InstanceID FROM CQL_TestPropertyTypes AS alias 
----- validate ok
======================================37
SELECT CQL_TestPropertyTypes.alias::InstanceID FROM CQL_TestPropertyTypes AS alias 
----- validate ok
======================================38
SELECT alias.alias::InstanceID FROM CQL_TestPropertyTypes AS alias 
----- validate ok
======================================39
SELECT alias::PropertyString FROM CQL_TestPropertyTypes AS alias 
----- validate ok
======================================40
SELECT CQL_TestPropertyTypes.alias::PropertyString FROM CQL_TestPropertyTypes AS alias 
----- validate ok
======================================41
SELECT alias.alias::PropertyString FROM CQL_TestPropertyTypes AS alias 
----- validate ok
======================================42
SELECT CQL_TestPropertyTypes::InstanceID FROM CQL_TestElement 
----- validate ok
======================================43
SELECT CQL_TestElement.CQL_TestPropertyTypes::InstanceID FROM CQL_TestElement 
----- validate ok
======================================44
SELECT alias.CQL_TestPropertyTypes::InstanceID FROM CQL_TestElement AS alias 
----- validate ok
======================================45
SELECT CQL_TestPropertyTypes::PropertyString FROM CQL_TestElement 
----- validate ok
======================================46
SELECT CQL_TestElement.CQL_TestPropertyTypes::PropertyString FROM CQL_TestElement 
----- validate ok
======================================47
SELECT alias.CQL_TestPropertyTypes::PropertyString FROM CQL_TestElement AS alias 
----- validate ok
======================================48
SELECT CQL_TestElement::PropertyString FROM CQL_TestPropertyTypes 
-----The property PropertyString does not exist on class CQL_TestElement.
======================================49
SELECT CQL_TestPropertyTypes.CQL_TestElement::PropertyString FROM CQL_TestPropertyTypes 
-----The property PropertyString does not exist on class CQL_TestElement.
======================================50
SELECT alias.CQL_TestElement::PropertyString FROM CQL_TestPropertyTypes AS alias 
-----The property PropertyString does not exist on class CQL_TestElement.
======================================51
SELECT CQL_TestElement::PropertyString FROM CQL_TestElement 
-----The property PropertyString does not exist on class CQL_TestElement.
======================================52
SELECT CQL_TestElement.CQL_TestElement::PropertyString FROM CQL_TestElement 
-----The property PropertyString does not exist on class CQL_TestElement.
======================================53
SELECT alias.CQL_TestElement::PropertyString FROM CQL_TestElement AS alias 
-----The property PropertyString does not exist on class CQL_TestElement.
======================================54
SELECT EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::EnabledState,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.*,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString,EmbObjBase.CQL_EmbeddedTestElement::SomeString,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyReal64Array,EmbObjSub,EmbObjBase.CQL_EmbeddedTestElement::TE.CQL_TestElement::InstanceId,EmbObjSub.*,EmbObjSub.CQL_EmbeddedTestPropertyTypes::SomeUint8,EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::Description FROM CQL_EmbeddedSubClass 
----- validate ok
======================================55
SELECT EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::EnabledState,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.*,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString,EmbObjBase.CQL_EmbeddedTestElement::SomeString,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_NonExistent::propertyReal64Array,EmbObjSub,EmbObjBase.CQL_EmbeddedTestElement::TE.CQL_TestElement::InstanceId,EmbObjSub.*,EmbObjSub.CQL_EmbeddedTestPropertyTypes::SomeUint8,EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::Description FROM CQL_EmbeddedSubClass 
-----The class CQL_NonExistent does not exist.
======================================56
SELECT EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::EnabledState,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.*,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString,EmbObjBase.CQL_EmbeddedTestElement::SomeString,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyReal64Array,EmbObjSub,EmbObjBase.CQL_EmbeddedTestElement::NotThere.CQL_TestElement::InstanceId,EmbObjSub.*,EmbObjSub.CQL_EmbeddedTestPropertyTypes::SomeUint8,EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::Description FROM CQL_EmbeddedSubClass 
-----The property NotThere does not exist on class CQL_EmbeddedTestElement.
======================================57
SELECT EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::EnabledState,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.*,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString,EmbObjBase.CQL_EmbeddedTestElement::SomeString,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT,EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyReal64Array,EmbObjSub,EmbObjBase.CQL_EmbeddedTestElement::TE.CQL_TestElement::InstanceId,EmbObjSub.*,EmbObjSub.CQL_EmbeddedTestPropertyTypes::SomeUint8.CQL_TestPropertyTypes::propertyString,EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::Description FROM CQL_EmbeddedSubClass 
-----The property SomeUint8 must be an embedded object.
======================================58
SELECT * FROM CQL_EmbeddedSubClass  WHERE EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::EnabledState = 2 AND EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString = 'abc' AND EmbObjBase.CQL_EmbeddedTestElement::SomeString = 'abc' AND EmbObjBase.CQL_EmbeddedTestElement::TE.CQL_TestElement::InstanceId = 3 AND EmbObjSub.CQL_EmbeddedTestPropertyTypes::SomeUint8 = 3 AND EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::Description = 'abc'
----- validate ok
======================================59
SELECT * FROM CQL_EmbeddedSubClass  WHERE EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::EnabledState = 2 AND EmbObjSub.CQL_EmbeddedTestPropertyTypes::TPT.CQL_TestPropertyTypes::propertyString = 'abc' AND EmbObjBase.CQL_EmbeddedTestElement::SomeString = 'abc' AND EmbObjBase.CQL_EmbeddedTestElement::TE.CQL_TestElement::NotThere = 3 AND EmbObjSub.CQL_EmbeddedTestPropertyTypes::SomeUint8 = 3 AND EmbObjBase.CQL_EmbeddedTestElement::CS.CIM_ComputerSystem::Description = 'abc'
-----The property NotThere does not exist on class CQL_TestElement.
======================================60
SELECT * FROM CQL_TestPropertyTypes  WHERE CQL_TestPropertyTypes ISA CQL_NonExistent
-----The class CQL_NonExistent does not exist.
======================================61
SELECT * FROM CQL_TestPropertyTypes  WHERE CQL_TestPropertyTypes ISA CQL_TestElement
----- validate ok
======================================62
SELECT * FROM CQL_TestPropertyTypes  WHERE CQL_TestPropertyTypes ISA CQL_TestElement AND CQL_TestPropertyTypes.BogusProperty ISA CQL_TestElement
-----The property BogusProperty does not exist on class CQL_TestPropertyTypes.