05-Comparison

Operator between and

1. Comparison of numeric types

2. Comparison of timestamp types

3. Multiple between and operators together

4. Boundary value for numeric types

5. Between and for tag columns

6. Invalid between and usage

7. Null value comparison

8. Mixed data types comparison

path: cases/10-Operators/05-Comparison/test_between_and.py

Operator In

1. Using IN operator with numeric types

2. Using IN operator with timestamp types

3. Using IN operator in an EXPLAIN statement

path: cases/10-Operators/05-Comparison/test_in.py

Operator like

1. Like in SELECT statements

2. Like in SHOW statements

3. Like in tag queries

1. Like wildcard

2. Like cnc wildcard

3. Like multi wildcard

4. Like escape character

5. Like unicode

6. Like special character

7. Like backslash

8. Like backslash and wildcard

9. Like backslash and escape character

10. Like backslash, wildcard and escape character

11. Like backslash, wildcard and cnc character

12. Like on super/child table

path: cases/10-Operators/05-Comparison/test_like.py

Operator match

Match and nmatch for regular expression matching

1. Match wildcard

2. Match cnc wildcard

3. Match error wildcard

4. Match multithread

6. Match regexp cnc wildcard

7. Match error regexp wildcard

8. Match regexp not cnc wildcard

9. Match on super/child table

path: cases/10-Operators/05-Comparison/test_match.py

Operator null

1. Usage of NULL in the IN operator

2. Comparison of NULL values

3. Operations involving NULL values

path: cases/10-Operators/05-Comparison/test_null.py