06-Logical

Logical and & or & in

1. And or with super table tags and columns

2. And or with normal table columns

3. And or with abs function

4. And or with boundary values

5. And or for byte

6. In on select clause

7. Is null / is not null on select clause

8. Between and on select clause

9. Not on select clause

10.In and not in on where clause

11.Query with timezone

path: cases/10-Operators/06-Logical/test_and_or.py

Logical and & or on col and tag

1. And/or on various data types of columns in ordinary table

2. And/or on various data types of tags in super table

3. And/or on timestamp and columns in ordinary table

4. And/or on join clauses

path: cases/10-Operators/06-Logical/test_and_or_coltag.py

If

1. Using in data columns and scalar functions within SELECT statements

2. Using in data columns within WHERE conditions

3. Using in data columns within GROUP BY statements

4. Using in data columns within STATE WINDOW

5. Using in aggregate functions while including the IS NULL operator

path: cases/10-Operators/06-Logical/test_if_smoking.py

Logical bugs

1. Jira TD-5757:

- Logical operator with IS NULL/IS NOT NULL and IN/NOT IN returns incorrect results

2. Jira TD-5760:

- Arithmetic operations on TIMESTAMP with negative numbers yield incorrect results

3. Jira TD-5758:

- Combining IN operator with BETWEEN clause yields incorrect results

4. Jira TD-5759:

- Combining BETWEEN clause with logical operators yields incorrect results

5. Jira TD-5823:

- Arithmetic operations on TIMESTAMP with various numeric data types yield incorrect results

6. Validate arithmetic operations on TIMESTAMP with different numeric data types:

- INT, BIGINT, SMALLINT, TINYINT, FLOAT, DOUBLE, etc.

path: cases/10-Operators/06-Logical/test_logical_bugs.py