function.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.
Caught Exception: CQL syntax error: syntax error around token 11 in position 82 while processing rule expr->expr_term
Statement with error = select * from CQL_TestPropertyTypes where PropertyString = UPPERCASE('Bert Rules', 'Not really')

Caught Exception: CQL syntax error: syntax error around token 11 in position 77 while processing rule expr->expr_term
Statement with error = select * from CQL_TestPropertyTypes where PropertyUint64 = STRINGTOUINT('32', '33')

Caught Exception: CQL syntax error: syntax error around token 11 in position 78 while processing rule expr->expr_term
Statement with error = select * from CQL_TestPropertyTypes where PropertySint64 = STRINGTOSINT('-32', '-33')

Caught Exception: CQL syntax error: syntax error around token 11 in position 80 while processing rule expr->expr_term
Statement with error = select * from CQL_TestPropertyTypes where PropertyReal64 = STRINGTOREAL('32.32', '33.33')

Caught Exception: CQL syntax error: syntax error around token 11 in position 84 while processing rule expr->expr_term
Statement with error = select * from CQL_TestPropertyTypes where PropertyStringSint = NUMERICTOSTRING(-743, -10)

There were 5 statements that did NOT parse.
=========Evaluate Query==============
=========     0     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE 63259462585000000 = DATETIMETOMICROSECOND(PropertyDateTime)

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
TRUE
=========     1     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE 1066666660424123456 = DATETIMETOMICROSECOND(PropertyInterval)

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     2     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE 464235 = DATETIMETOMICROSECOND()

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
ERROR!
Function DATETIMETOMICROSECOND has 0 parameters.  It must have between 1 and 1.

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
ERROR!
Function DATETIMETOMICROSECOND has 0 parameters.  It must have between 1 and 1.

=========     3     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE 464235 = DATETIMETOMICROSECOND(2344)

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
ERROR!
Parameter 1 for function DATETIMETOMICROSECOND has type Uint64.  It must be type DateTime.

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
ERROR!
Parameter 1 for function DATETIMETOMICROSECOND has type Uint64.  It must be type DateTime.

=========     4     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyString = UPPERCASE('Bert Rules')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     5     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyString = UPPERCASE('')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
FALSE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     6     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyString = UPPERCASE()

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
ERROR!
Function UPPERCASE has 0 parameters.  It must have between 1 and 1.

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
ERROR!
Function UPPERCASE has 0 parameters.  It must have between 1 and 1.

=========     7     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyString = UPPERCASE(PropertyReal32)

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
ERROR!
Parameter 1 for function UPPERCASE has type Real.  It must be type String.

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
ERROR!
Parameter 1 for function UPPERCASE has type Real.  It must be type String.

=========     8     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyString = UPPERCASE(-1.2343400000000000)

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
ERROR!
Parameter 1 for function UPPERCASE has type Real.  It must be type String.

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
ERROR!
Parameter 1 for function UPPERCASE has type Real.  It must be type String.

=========     9     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE STRINGTOUINT(PropertyStringUint) = 347

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
ERROR!
Error converting string to Uint64.  String cannot be empty.

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
TRUE
=========     10     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE STRINGTOSINT(PropertyStringSint) = -743

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
ERROR!
Error converting string to Sint64.  String cannot be empty.

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
TRUE
=========     11     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE STRINGTOREAL(PropertyStringReal) = 9.8670000000000002e1

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
ERROR!
Error converting string to Real64.  String cannot be empty.

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     12     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyUint32 = STRINGTOUINT('32.32')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     13     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyUint32 = STRINGTOUINT('32.72')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     14     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyUint32 = STRINGTOUINT('32.0')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     15     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyUint32 = STRINGTOUINT('0x01a9b')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
FALSE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
TRUE
=========     16     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertySint32 = STRINGTOSINT('-32.32')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     17     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertySint32 = STRINGTOSINT('-32.0')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     18     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertySint32 = STRINGTOSINT('-32.72')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     19     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertySint32 = STRINGTOSINT('-0x01a9b')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
FALSE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
TRUE
=========     20     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal32 = STRINGTOREAL('-32')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     21     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal32 = STRINGTOREAL('-32.0')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     22     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal32 = STRINGTOREAL('-.32e2')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     23     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal32 = STRINGTOREAL('-0.32E+02')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     24     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal32 = STRINGTOREAL('-0x20')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     25     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal32 = STRINGTOREAL('-00100000b')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     26     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal32 = STRINGTOREAL('-100000B')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     27     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal64 = STRINGTONUMERIC('+64')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     28     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal64 = STRINGTONUMERIC('+64.0')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     29     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal64 = STRINGTONUMERIC('+0x40')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     30     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal64 = STRINGTONUMERIC('+1000000b')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     31     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal64 = STRINGTONUMERIC('64')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     32     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal64 = STRINGTONUMERIC('64.0')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     33     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal64 = STRINGTONUMERIC('0x40')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     34     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal64 = STRINGTONUMERIC('1000000b')

-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1
TRUE
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2
FALSE
=========     35     =========
-----Query: SELECT * FROM CQL_TestPropertyTypes  WHERE PropertyReal64 = STRINGTONUMERIC('64.64')