function.query

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

#############
select * from CQL_TestPropertyTypes where PropertyStringUint = NUMERICTOSTRING(347)
select * from CQL_TestPropertyTypes where PropertyStringSint = NUMERICTOSTRING(-743)
select * from CQL_TestPropertyTypes where PropertyStringReal = NUMERICTOSTRING(91.25)
select * from CQL_TestPropertyTypes where PropertyStringReal = NUMERICTOSTRING(9.125e1)
select * from CQL_TestPropertyTypes where '255' = NUMERICTOSTRING(PropertyUint8)
select * from CQL_TestPropertyTypes where '-8' = NUMERICTOSTRING(PropertySint8)
select * from CQL_TestPropertyTypes where '9.1250000000000000E1' = NUMERICTOSTRING(91.25)
select * from CQL_TestPropertyTypes where '6.4000000000000000E1' = NUMERICTOSTRING(PropertyReal64)

# Errors
select * from CQL_TestPropertyTypes where PropertyStringSint = NUMERICTOSTRING(-743, -10)
select * from CQL_TestPropertyTypes where PropertyStringSint = NUMERICTOSTRING()
select * from CQL_TestPropertyTypes where PropertyStringSint = NUMERICTOSTRING(PropertyStringUint)


#############
# ReferenceToString
#############
select * FROM CQL_TestPropertyTypes where referencetostring(CQL_TestPropertyTypes) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2'

# Errors
select * FROM CQL_TestPropertyTypes where referencetostring() = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2'
select * FROM CQL_TestPropertyTypes where referencetostring(TestPropertyTypes) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2'

#############
# ClassName
#############
select * FROM CQL_TestPropertyTypes where classname() = 'CQL_TestPropertyTypes'
select * FROM CQL_TestPropertyTypes where classname(CQL_TestPropertyTypes) = 'CQL_TestPropertyTypes'
select * FROM CQL_TestPropertyTypes where classname('//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2') = 'CQL_TestPropertyTypes'

# Errors
select * FROM CQL_TestPropertyTypes where classname('//a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2') = 'CQL_TestPropertyTypes'
select * FROM CQL_TestPropertyTypes where classname(TestPropertyTypes) = 'CQL_TestPropertyTypes'


#############
# nameSpaceName
#############
select * FROM CQL_TestPropertyTypes where NamespaceName() = 'root/SampleProvider'
select * FROM CQL_TestPropertyTypes where NamespaceName(CQL_TestPropertyTypes) = 'root/SampleProvider'
select * FROM CQL_TestPropertyTypes where NamespaceName('//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2') = 'root/SampleProvider'

# Errors
select * FROM CQL_TestPropertyTypes where NamespaceName('//a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2') = 'root/SampleProvider'
select * FROM CQL_TestPropertyTypes where NamespaceName(TestPropertyTypes) = 'root/SampleProvider'


#############
# nameSpaceType
#############
# NOT SUPPORTED
select * FROM CQL_TestPropertyTypes where NamespaceType() = 'Function Not supported'

#############
# hostPort
#############
select * FROM CQL_TestPropertyTypes where HostPort(CQL_TestPropertyTypes) = 'a.b.com'
select * FROM CQL_TestPropertyTypes where HostPort('//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2') = 'a.b.com'

# Errors
select * FROM CQL_TestPropertyTypes where HostPort() = 'a.b.com'
select * FROM CQL_TestPropertyTypes where HostPort('//a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2') = 'a.b.com'
select * FROM CQL_TestPropertyTypes where HostPort(TestPropertyTypes) = 'a.b.com'


#############
# modelPath
#############
select * FROM CQL_TestPropertyTypes where ModelPath() = 'CQL_TestPropertyTypes.InstanceId=2'
select * FROM CQL_TestPropertyTypes where ModelPath(CQL_TestPropertyTypes) = 'CQL_TestPropertyTypes.InstanceId=2'
select * FROM CQL_TestPropertyTypes where ModelPath('//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2') = 'CQL_TestPropertyTypes.InstanceId=2'

# Errors
select * FROM CQL_TestPropertyTypes where ModelPath('//a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2') = 'CQL_TestPropertyTypes.InstanceId=2'
select * FROM CQL_TestPropertyTypes where ModelPath(TestPropertyTypes) = 'CQL_TestPropertyTypes.InstanceId=2'


#############
# classPath
#############
select * from CQL_TestPropertyTypes where referencetostring(classpath()) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes'
select * from CQL_TestPropertyTypes where referencetostring(classpath(CQL_TestPropertyTypes)) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes'
select * from CQL_TestPropertyTypes where referencetostring(classpath('//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2')) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes'

# Errors
select * from CQL_TestPropertyTypes where referencetostring(classpath(TestPropertyTypes)) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes'
select * from CQL_TestPropertyTypes where referencetostring(classpath('//a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2')) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes'


#############
# objectPath
#############
select * from CQL_TestPropertyTypes where referencetostring(objectPath()) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2'
select * from CQL_TestPropertyTypes where referencetostring(objectPath(CQL_TestPropertyTypes)) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2'
select * from CQL_TestPropertyTypes where referencetostring(objectPath('//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2')) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2'

# Errors
select * from CQL_TestPropertyTypes where referencetostring(objectPath(TestPropertyTypes)) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes'
select * from CQL_TestPropertyTypes where referencetostring(objectPath('//a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2')) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes'


#############
# instanceToReference
#############
select * from CQL_TestPropertyTypes where referencetostring(instanceToReference()) = 'root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2'
select * from CQL_TestPropertyTypes where referencetostring(instanceToReference(CQL_TestPropertyTypes)) = 'root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2'

# Errors
select * from CQL_TestPropertyTypes where referencetostring(instanceToReference('//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2')) = 'root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2'


#############
# currentDateTime
#############

select * FROM CQL_TestPropertyTypes where CURRENTDATETIME() > PropertyDateTime

# Invalid to pass a parm
select * FROM CQL_TestPropertyTypes where CURRENTDATETIME('0') > PropertyDateTime


#############
# dateTime
#############
select * FROM CQL_TestPropertyTypes where DATETIME('20040811105625.000000-360') = PropertyDateTime

# Errors
select * FROM CQL_TestPropertyTypes where DATETIME('2004081110562') = PropertyDateTime
select * FROM CQL_TestPropertyTypes where DATETIME('') = PropertyDateTime
select * FROM CQL_TestPropertyTypes where DATETIME() = PropertyDateTime
select * FROM CQL_TestPropertyTypes where DATETIME(54) = PropertyDateTime


#############
# microsecondToTimestamp
#############
select * FROM CQL_TestPropertyTypes where MICROSECONDTOTIMESTAMP(63259462585000000) = PropertyDateTime

# Errors
select * FROM CQL_TestPropertyTypes where MICROSECONDTOTIMESTAMP('63259370000') = PropertyDateTime
select * FROM CQL_TestPropertyTypes where MICROSECONDTOTIMESTAMP() = PropertyDateTime

#############
# microsecondToInterval
#############
select * FROM CQL_TestPropertyTypes where MICROSECONDTOINTERVAL(1066666660424123456) = PropertyInterval

# Errors
select * FROM CQL_TestPropertyTypes where MICROSECONDTOINTERVAL('1023456') = PropertyInterval
select * FROM CQL_TestPropertyTypes where MICROSECONDTOINTERVAL() = PropertyInterval