teragrep / pth_10

Data Processing Language (DPL) translator for Apache Spark
GNU Affero General Public License v3.0
0 stars 6 forks source link

where command does not work as expected with boolean expressions #277

Closed Abigael-JT closed 5 days ago

Abigael-JT commented 2 months ago

Describe the bug

This query does not return the correct results %dpl index=index earliest="01/01/2021:00:00:00" | where _raw > 80 AND _raw < 100

Also combining more than one boolean expression does not return expected results | where (success="true" AND target = "Daniel") OR (success="true" AND target = "Alice")

Expected behavior

The above queries should return column values either within the given limits or equivalent to what is specified and nothing outside that

How to reproduce

Run the above query in QA

Screenshots

Software version

pth_10 version: 5.5.0-2-g5f9746ea pth_03 version: 6.1.4

Desktop (please complete the following information if relevant):

Additional context

Abigael-JT commented 1 month ago

unit tests disabled due to this issue will be looked at in https://github.com/teragrep/pth_10/issues/295

Abigael-JT commented 3 weeks ago

Added AND/OR to get operation in eval statement Draft PR: https://github.com/teragrep/pth_10/pull/365