1 david 1.1.2.1 #####################################
 2               # Symbolic Constant testing queries.#
 3               #####################################
 4               #Query on fully qualified symbolic constant comparison with integer. Result is TRUE
 5               select * from CIM_ComputerSystem where CIM_ComputerSystem.EnabledState#'Enabled' = 2
 6               
 7               #Query on fully qualified symbolic constant comparison with integer. Result is TRUE
 8               select * from CIM_ComputerSystem where 2 = CIM_ComputerSystem.EnabledState#'Enabled'
 9               
10               #Query on 2 fully qualified symbolic constants comparison. Result is FALSE
11               select * from CIM_ComputerSystem where CIM_ComputerSystem.EnabledState#'Enabled' = CIM_ComputerSystem.EnabledState#'Disabled'
12               
13               #Query on fully qualified symbolic constant comparison with SC qualified with property name. Result is FALSE 
14               select * from CIM_ComputerSystem where CIM_ComputerSystem.EnabledState#'Enabled' = EnabledState#'Disabled'
15               
16               #Query on fully qualified symbolic constant comparison with SC qualified with property name. Result is FALSE 
17               select * from CIM_ComputerSystem where EnabledState#'Enabled' = CIM_ComputerSystem.EnabledState#'Disabled'
18               
19               #Query on fully qualified symbolic constant comparison with unqualified SC. Result is FALSE 
20               select * from CIM_ComputerSystem where CIM_ComputerSystem.EnabledState#'Enabled' = #'Disabled'
21               
22 david 1.1.2.1 #Query on fully qualified symbolic constant comparison with unqualified SC. Result is FALSE 
23               select * from CIM_ComputerSystem where #'Enabled' = CIM_ComputerSystem.EnabledState#'Disabled'
24               
25               #Query on symbolic constant qualified with property name comparison with unqualified SC. Result is FALSE
26               select * from CIM_ComputerSystem where EnabledState#'Enabled' = #'Disabled'
27               
28               #Query on symbolic constant qualified with property name comparison with unqualified SC. Result is FALSE
29               select * from CIM_ComputerSystem where #'Enabled' = EnabledState#'Disabled'
30               

31 chuck 1.1.2.2 #Query on symbolic constant qualified with scope comparison with unqualified SC. Result is FALSE
32               #Note that the scope of the SC is not related to the FROM.
33               select * from CIM_ComputerSystem where CIM_LogicalDevice::OperationalStatus#'Error' = #'OK' 
34               
35               #Query on symbolic constant qualified with scope comparison with unqualified SC. Result is FALSE
36               #Note that the scope of the SC is not related to the FROM.
37               select * from CIM_ComputerSystem where #'OK' = CIM_LogicalDevice::OperationalStatus#'Error'
38               

39 david 1.1.2.1 #Query on 2 fully qualified symbolic constants comparison with an invalid SC name. Result Exception.

40 chuck 1.1.2.2 select * from CIM_ComputerSystem where CIM_ComputerSystem.EnabledState#'Enabled' = CIM_ComputerSystem.EnabledState#'Bogus'
41               
42               #Query on symbolic constant in chain with more than 1 element.
43               #First chain element is a property on the FROM.  
44               #Result Exception since the scope is missing on the second chain element.
45               select * from CIM_ComputerSystem where EnabledState.EnabledState#'Enabled' = 2 
46               
47               #Query on symbolic constant in chain with more than 1 element.
48               #First chain element is a class !=  FROM.  Result is TRUE
49               #Note that 'error' is lowercase to test case insensitivity.
50               select * from CIM_ComputerSystem where CIM_LogicalDevice.OperationalStatus#'error' = 6   
51               
52               #Query on symbolic constant in chain with more than 1 element.
53               #The FROM class doesn't exist. Result Exception.
54               select * from CIM_Bogus where CIM_ComputerSystem.EnabledState#'Enabled' = 2  

55 david 1.1.2.1 
56               #Query on 2 unqualified symbolic Constants. Result Exception
57               select * from CIM_ComputerSystem where #'Enabled' = #'Disabled'