📄 function.query.resgood
字号:
Parameter 1 for function STRINGTOREAL has type Real. It must be type String.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Parameter 1 for function STRINGTOREAL has type Real. It must be type String.========= 98 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyReal64 = STRINGTOREAL('')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Real64. String cannot be empty.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Real64. String cannot be empty.========= 99 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyReal64 = STRINGTOREAL('32.')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Real64. String '32.' must have a digit character following the decimal point.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Real64. String '32.' must have a digit character following the decimal point.========= 100 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyReal64 = STRINGTOREAL('3a3.32')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Real64. Character 'a' in string '3a3.32' is not a decimal digit.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Real64. Character 'a' in string '3a3.32' is not a decimal digit.========= 101 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyReal64 = STRINGTOREAL('32.3a3')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Real64. Character 'a' in string '32.3a3` is invalid.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Real64. Character 'a' in string '32.3a3` is invalid.========= 102 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyReal64 = STRINGTOREAL('32.33E-a2')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Real64. String '32.33E-a2' has a badly formed exponent. Character 'a' is invalid.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Real64. String '32.33E-a2' has a badly formed exponent. Character 'a' is invalid.========= 103 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyStringUint = NUMERICTOSTRING(347)-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1FALSE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 104 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyStringSint = NUMERICTOSTRING(-743)-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1FALSE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 105 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyStringReal = NUMERICTOSTRING(9.1250000000000000e1)-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1FALSE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 106 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyStringReal = NUMERICTOSTRING(9.1250000000000000e1)-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1FALSE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 107 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE '255' = NUMERICTOSTRING(PropertyUint8)-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 108 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE '-8' = NUMERICTOSTRING(PropertySint8)-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 109 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE '9.1250000000000000E1' = NUMERICTOSTRING(9.1250000000000000e1)-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 110 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE '6.4000000000000000E1' = NUMERICTOSTRING(PropertyReal64)-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 111 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyStringSint = NUMERICTOSTRING()-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Function NUMERICTOSTRING has 0 parameters. It must have between 1 and 1.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Function NUMERICTOSTRING has 0 parameters. It must have between 1 and 1.========= 112 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyStringSint = NUMERICTOSTRING(PropertyStringUint)-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Parameter 1 for function NUMERICTOSTRING has type String. It must be type Integer or Real.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Parameter 1 for function NUMERICTOSTRING has type String. It must be type Integer or Real.========= 113 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE REFERENCETOSTRING(CQL_TestPropertyTypes) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1FALSE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 114 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE REFERENCETOSTRING() = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Function REFERENCETOSTRING has 0 parameters. It must have between 1 and 1.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Function REFERENCETOSTRING has 0 parameters. It must have between 1 and 1.========= 115 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE REFERENCETOSTRING(TestPropertyTypes) = '//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Parameter 1 for function REFERENCETOSTRING has type NULL. It must be type Reference, or Object.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Parameter 1 for function REFERENCETOSTRING has type NULL. It must be type Reference, or Object.========= 116 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE CLASSNAME() = 'CQL_TestPropertyTypes'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 117 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE CLASSNAME(CQL_TestPropertyTypes) = 'CQL_TestPropertyTypes'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 118 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE CLASSNAME('//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2') = 'CQL_TestPropertyTypes'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 119 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE CLASSNAME('//a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2') = 'CQL_TestPropertyTypes'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!malformed object name: //a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!malformed object name: //a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2========= 120 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE CLASSNAME(TestPropertyTypes) = 'CQL_TestPropertyTypes'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Parameter 1 for function CLASSNAME has type NULL. It must be type Reference, String, or Object.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Parameter 1 for function CLASSNAME has type NULL. It must be type Reference, String, or Object.========= 121 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE NAMESPACENAME() = 'root/SampleProvider'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 122 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE NAMESPACENAME(CQL_TestPropertyTypes) = 'root/SampleProvider'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 123 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE NAMESPACENAME('//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2') = 'root/SampleProvider'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 124 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE NAMESPACENAME('//a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2') = 'root/SampleProvider'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!malformed object name: //a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!malformed object name: //a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2========= 125 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE NAMESPACENAME(TestPropertyTypes) = 'root/SampleProvider'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Parameter 1 for function NAMESPACENAME has type NULL. It must be type Reference, String, or Object.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Parameter 1 for function NAMESPACENAME has type NULL. It must be type Reference, String, or Object.========= 126 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE NAMESPACETYPE() = 'Function Not supported'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Function NAMESPACETYPE is not supported.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Function NAMESPACETYPE is not supported.========= 127 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE HOSTPORT(CQL_TestPropertyTypes) = 'a.b.com'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 128 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE HOSTPORT('//a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2') = 'a.b.com'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 129 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE HOSTPORT() = 'a.b.com'-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Function HOSTPORT has 0 parameters. It must have between 1 and 1.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Function HOSTPORT has 0 parameters. It must have between 1 and 1.========= 130 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE HOSTPORT('//a.b.com/root/SampleProvider/CQL_TestPropertyTypes.InstanceId=2') = 'a.b.com'
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -