📄 function.query.resgood
字号:
-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1FALSE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 36 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyReal64 = STRINGTONUMERIC('646.4e-01')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1FALSE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 37 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyReal64 = STRINGTONUMERIC('6.464E+01')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1FALSE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 38 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyReal64 = STRINGTONUMERIC('.6464e2')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1FALSE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 39 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyReal64 = STRINGTONUMERIC('0.6464e2')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1FALSE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 40 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyReal64 = STRINGTOREAL('+64.64')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1FALSE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 41 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyReal32 = STRINGTOREAL('32.2')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1FALSE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 42 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyUint8 = STRINGTOUINT('+255')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 43 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyUint8 = STRINGTOUINT('+0xFF')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 44 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyUint8 = STRINGTOUINT('+11111111b')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 45 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyUint64 = STRINGTOUINT('+18446744073709551615')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 46 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyUint64 = STRINGTOUINT('+0xFFFFffffFFFFffff')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 47 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyUint64 = STRINGTOUINT('+1111111111111111111111111111111111111111111111111111111111111111B')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 48 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint8Lower = STRINGTOSINT('-128')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 49 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint8Lower = STRINGTOSINT('-0x80')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 50 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint8Lower = STRINGTOSINT('-10000000b')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 51 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint8Upper = STRINGTOSINT('127')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 52 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint8Upper = STRINGTOSINT('0x7f')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 53 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint8Upper = STRINGTOSINT('01111111B')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2TRUE========= 54 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint64Lower = STRINGTOSINT('-9223372036854775808')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 55 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint64Lower = STRINGTOSINT('-0x8000000000000000')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 56 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint64Lower = STRINGTOSINT('-1000000000000000000000000000000000000000000000000000000000000000b')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 57 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint64Upper = STRINGTOSINT('9223372036854775807')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 58 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint64Upper = STRINGTOSINT('0x7fffFFFFffffFFFF')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 59 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint64Upper = STRINGTOSINT('0111111111111111111111111111111111111111111111111111111111111111B')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1TRUE-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2FALSE========= 60 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyUint64 = STRINGTOUINT('18446744073709551616')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Uint64. String '18446744073709551616' caused an overflow.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Uint64. String '18446744073709551616' caused an overflow.========= 61 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyUint64 = STRINGTOUINT('0x10000000000000000')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Uint64. String '0x10000000000000000' caused an overflow.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Uint64. String '0x10000000000000000' caused an overflow.========= 62 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyUint64 = STRINGTOUINT('10000000000000000000000000000000000000000000000000000000000000000B')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Uint64. String '10000000000000000000000000000000000000000000000000000000000000000B' caused an overflow.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Uint64. String '10000000000000000000000000000000000000000000000000000000000000000B' caused an overflow.========= 63 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint64Lower = STRINGTOSINT('-9223372036854775809')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Sint64. String '-9223372036854775809' caused an overflow.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Sint64. String '-9223372036854775809' caused an overflow.========= 64 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint64Lower = STRINGTOSINT('-0x8000000000000001')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Sint64. String '-0x8000000000000001' caused an overflow.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Sint64. String '-0x8000000000000001' caused an overflow.========= 65 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint64Lower = STRINGTOSINT('-1000000000000000000000000000000000000000000000000000000000000001b')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Sint64. String '-1000000000000000000000000000000000000000000000000000000000000001b' caused an overflow.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Sint64. String '-1000000000000000000000000000000000000000000000000000000000000001b' caused an overflow.========= 66 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE CQL_TestPropertyTypes.PropertySint64Upper = STRINGTOSINT('9223372036854775808')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Sint64. String '9223372036854775808' caused an overflow.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Sint64. String '9223372036854775808' caused an overflow.========= 67 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint64Upper = STRINGTOSINT('0x8000000000000000')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Sint64. String '0x8000000000000000' caused an overflow.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Sint64. String '0x8000000000000000' caused an overflow.========= 68 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertySint64Upper = STRINGTOSINT('1000000000000000000000000000000000000000000000000000000000000000B')-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Error converting string to Sint64. String '1000000000000000000000000000000000000000000000000000000000000000B' caused an overflow.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Error converting string to Sint64. String '1000000000000000000000000000000000000000000000000000000000000000B' caused an overflow.========= 69 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyUint64 = STRINGTOUINT()-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Function STRINGTOUINT has 0 parameters. It must have between 1 and 1.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Function STRINGTOUINT has 0 parameters. It must have between 1 and 1.========= 70 =========-----Query: SELECT * FROM CQL_TestPropertyTypes WHERE PropertyUint64 = STRINGTOUINT(33)-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=1ERROR!Parameter 1 for function STRINGTOUINT has type Uint64. It must be type String.-----Instance: //a.b.com/root/SampleProvider:CQL_TestPropertyTypes.InstanceId=2ERROR!Parameter 1 for function STRINGTOUINT has type Uint64. It must be type String.
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -