#2 Security & Stability Test: where() and having()

[decMuc]

Discovery of a potential persistence bug in MysqliDb

While running a new series of comparison tests between PDOdb and ThingEngineer's MysqliDb, we encountered a potentially serious issue within the original MysqliDb class.

Test Purpose
The test suite was originally intended to benchmark and validate:

• Typing safety (whereInt(), whereDate() etc.) in PDOdb

• SQL injection resistance

• Comparison of performance and behavior in edge-case WHERE/HAVING conditions

However, during the initial invalid-WHERE tests, MysqliDb began to accumulate internal state across queries — even though each test should be independent. From that point onward, subsequent test results became polluted and unpredictable.

Root Cause (Assumed)
We suspect that once an invalid query (e.g. price === 100) is sent to MySQL and causes a syntax error, the internal _where, _join, or _query properties inside the MysqliDb object are not properly reset.

As a result:

• Old WHERE clauses remain attached to future queries.

• getLastQuery() outputs a concatenated mix of past and current fragments.

• The class appears to continue operating, but returns incorrect and dangerous queries.

Reproducibility
The issue is reproducible via the attached script. Specifically, the problem starts after this test:

['field' => 'price', 'operator' => '===', 'value' => 100]

The resulting query string is invalid (price === ?), and from that point onward, the internal state in Thing's MysqliDb object begins to accumulate instead of resetting.

Temporary Workaround

We introduced a custom method inside Thing's class for testing:

public function clearLastQuery(): void {
    $this->_lastQuery   = '';
    $this->_where       = array();
    $this->_having      = array();
    $this->_join        = array();
    $this->_joinAnd     = array();
    $this->_orderBy     = array();
    $this->_groupBy     = array();
    $this->_bindParams  = array('');
    $this->_query       = null;
}

Calling this before each test resets the internal state and temporarily solves the issue. However, this is not part of the original class and must not be seen as a final fix.

Important Difference to PDOdb
Our own PDOdb implementation stops execution early via throw if a query appears suspicious or syntactically invalid — no query is built at all in such cases. However, this also means that no lastQuery can be generated.

We now added a manual fallback by calling:

$db->clearLastQuery();

...before each test, until internal reset handling is fully implemented.

Heuristic WHERE Evaluation (PDOdb only)
PDOdb optionally attempts to analyze suspicious WHERE values heuristically, for example:

$db->where('id', '1; DROP TABLE x');

Instead of immediately blocking, PDOdb checks:

$tmpVal = filter_var($value, FILTER_VALIDATE_INT);
if ((string) $tmpVal !== (string) $value) {
   throw new Exception("Suspicious WHERE clause detected...");
}

This feature is toggled in the next release via:

define('PDOdb_HEURISTIC_WHERE_CHECK', true);

Disabling it (false) will block any suspicious input outright without type inspection.

⚠ However, enabling this adds a small overhead:
In our test case, time increased from 0.02 ms to 3.4 ms per WHERE call. In contrast, MysqliDb crashed at around 0.6 ms due to raw MySQL errors.

Summary

• PDOdb is stricter but more stable and secure under invalid input.

• MysqliDb shows persistent internal state pollution after query errors.

• The issue appears to be reproducible, serious, and not yet reported upstream.

Test Output Snapshot

Below is the raw output of the executed test suite (PDOdb vs MysqliDb) including query strings, result counts, exceptions and status:

This represents the actual $results[] array generated by the benchmark script.

Array
(
    [0] => Array
        (
            [engin] => PDOdb
            [index] => 0
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => id
            [operator] => =
            [value] => 1
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `id` = 1 LIMIT 2
            [query_debug] => 
            [result_count] => 1
            [duration_ms] => 2.12
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                )

        )

    [1] => Array
        (
            [engin] => THING
            [index] => 0
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => id
            [operator] => =
            [value] => 1
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  id = '1'  LIMIT 2
            [result_count] => 1
            [duration_ms] => 3.55
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                )

        )

    [2] => Array
        (
            [engin] => PDOdb
            [index] => 1
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => user_id
            [operator] => =
            [value] => 4
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `user_id` = 4 LIMIT 2
            [query_debug] => 
            [result_count] => 1
            [duration_ms] => 0.79
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 4
                            [user_id] => 4
                            [product_name] => Nose hair trimmer
                            [product_id] => 1219
                            [price] => 32.50
                            [status] => completed
                            [order_date] => 2015-01-02
                            [notes] => Note 2584
                        )

                )

        )

    [3] => Array
        (
            [engin] => THING
            [index] => 1
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => user_id
            [operator] => =
            [value] => 4
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  user_id = '4'  LIMIT 2
            [result_count] => 1
            [duration_ms] => 1.8
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 4
                            [user_id] => 4
                            [product_name] => Nose hair trimmer
                            [product_id] => 1219
                            [price] => 32.50
                            [status] => completed
                            [order_date] => 2015-01-02
                            [notes] => Note 2584
                        )

                )

        )

    [4] => Array
        (
            [engin] => PDOdb
            [index] => 2
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => product_name
            [operator] => LIKE
            [value] => %Tin%
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `product_name` LIKE '%Tin%' LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 1.28
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 9
                            [user_id] => 9
                            [product_name] => Tinfoil Hat Pack (3x)
                            [product_id] => 999001
                            [price] => 8.88
                            [status] => completed
                            [order_date] => 2015-01-06
                            [notes] => Note 4737
                        )

                    [1] => Array
                        (
                            [id] => 42
                            [user_id] => 42
                            [product_name] => Tinfoil Hat Pack (3x)
                            [product_id] => 999001
                            [price] => 8.88
                            [status] => canceled
                            [order_date] => 2015-01-27
                            [notes] => Note 4411
                        )

                )

        )

    [5] => Array
        (
            [engin] => THING
            [index] => 2
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => product_name
            [operator] => LIKE
            [value] => %Tin%
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  product_name LIKE '%Tin%'  LIMIT 2
            [result_count] => 2
            [duration_ms] => 1.59
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 9
                            [user_id] => 9
                            [product_name] => Tinfoil Hat Pack (3x)
                            [product_id] => 999001
                            [price] => 8.88
                            [status] => completed
                            [order_date] => 2015-01-06
                            [notes] => Note 4737
                        )

                    [1] => Array
                        (
                            [id] => 42
                            [user_id] => 42
                            [product_name] => Tinfoil Hat Pack (3x)
                            [product_id] => 999001
                            [price] => 8.88
                            [status] => canceled
                            [order_date] => 2015-01-27
                            [notes] => Note 4411
                        )

                )

        )

    [6] => Array
        (
            [engin] => PDOdb
            [index] => 3
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => product_id
            [operator] => >
            [value] => 1000
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `product_id` > 1000 LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.91
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [7] => Array
        (
            [engin] => THING
            [index] => 3
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => product_id
            [operator] => >
            [value] => 1000
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  product_id > '1000'  LIMIT 2
            [result_count] => 2
            [duration_ms] => 1.4
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [8] => Array
        (
            [engin] => PDOdb
            [index] => 4
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => price
            [operator] => <
            [value] => 100
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `price` < 100 LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.79
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                    [1] => Array
                        (
                            [id] => 4
                            [user_id] => 4
                            [product_name] => Nose hair trimmer
                            [product_id] => 1219
                            [price] => 32.50
                            [status] => completed
                            [order_date] => 2015-01-02
                            [notes] => Note 2584
                        )

                )

        )

    [9] => Array
        (
            [engin] => THING
            [index] => 4
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => price
            [operator] => <
            [value] => 100
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  price < '100'  LIMIT 2
            [result_count] => 2
            [duration_ms] => 1.65
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                    [1] => Array
                        (
                            [id] => 4
                            [user_id] => 4
                            [product_name] => Nose hair trimmer
                            [product_id] => 1219
                            [price] => 32.50
                            [status] => completed
                            [order_date] => 2015-01-02
                            [notes] => Note 2584
                        )

                )

        )

    [10] => Array
        (
            [engin] => PDOdb
            [index] => 5
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => price
            [operator] => BETWEEN
            [value] => [10,500]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `price` BETWEEN 10 AND 500 LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.96
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [11] => Array
        (
            [engin] => THING
            [index] => 5
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => price
            [operator] => BETWEEN
            [value] => [10,500]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  price BETWEEN '10' AND '500'  LIMIT 2
            [result_count] => 2
            [duration_ms] => 1.3
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [12] => Array
        (
            [engin] => PDOdb
            [index] => 6
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => status
            [operator] => =
            [value] => pending
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `status` = 'pending' LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.86
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                    [1] => Array
                        (
                            [id] => 7
                            [user_id] => 7
                            [product_name] => Door handle
                            [product_id] => 903234
                            [price] => 65.54
                            [status] => pending
                            [order_date] => 2015-01-04
                            [notes] => Note 6106
                        )

                )

        )

    [13] => Array
        (
            [engin] => THING
            [index] => 6
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => status
            [operator] => =
            [value] => pending
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  status = 'pending'  LIMIT 2
            [result_count] => 2
            [duration_ms] => 1.41
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                    [1] => Array
                        (
                            [id] => 7
                            [user_id] => 7
                            [product_name] => Door handle
                            [product_id] => 903234
                            [price] => 65.54
                            [status] => pending
                            [order_date] => 2015-01-04
                            [notes] => Note 6106
                        )

                )

        )

    [14] => Array
        (
            [engin] => PDOdb
            [index] => 7
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => status
            [operator] => IN
            [value] => ["completed"]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `status` IN ('completed') LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.95
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 3
                            [user_id] => 3
                            [product_name] => Dishes
                            [product_id] => 10300
                            [price] => 212.21
                            [status] => completed
                            [order_date] => 2015-01-02
                            [notes] => Note 2088
                        )

                    [1] => Array
                        (
                            [id] => 4
                            [user_id] => 4
                            [product_name] => Nose hair trimmer
                            [product_id] => 1219
                            [price] => 32.50
                            [status] => completed
                            [order_date] => 2015-01-02
                            [notes] => Note 2584
                        )

                )

        )

    [15] => Array
        (
            [engin] => THING
            [index] => 7
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => status
            [operator] => IN
            [value] => ["completed"]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  status IN ( 'completed' )  LIMIT 2
            [result_count] => 2
            [duration_ms] => 1.25
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 3
                            [user_id] => 3
                            [product_name] => Dishes
                            [product_id] => 10300
                            [price] => 212.21
                            [status] => completed
                            [order_date] => 2015-01-02
                            [notes] => Note 2088
                        )

                    [1] => Array
                        (
                            [id] => 4
                            [user_id] => 4
                            [product_name] => Nose hair trimmer
                            [product_id] => 1219
                            [price] => 32.50
                            [status] => completed
                            [order_date] => 2015-01-02
                            [notes] => Note 2584
                        )

                )

        )

    [16] => Array
        (
            [engin] => PDOdb
            [index] => 8
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => order_date
            [operator] => >=
            [value] => 2015-01-01
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `order_date` >= '2015-01-01' LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.93
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [17] => Array
        (
            [engin] => THING
            [index] => 8
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => order_date
            [operator] => >=
            [value] => 2015-01-01
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  order_date >= '2015-01-01'  LIMIT 2
            [result_count] => 2
            [duration_ms] => 1.31
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [18] => Array
        (
            [engin] => PDOdb
            [index] => 9
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => order_date
            [operator] => <=
            [value] => 2025-12-31
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `order_date` <= '2025-12-31' LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.82
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [19] => Array
        (
            [engin] => THING
            [index] => 9
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => order_date
            [operator] => <=
            [value] => 2025-12-31
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  order_date <= '2025-12-31'  LIMIT 2
            [result_count] => 2
            [duration_ms] => 1.33
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [20] => Array
        (
            [engin] => PDOdb
            [index] => 10
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => order_date
            [operator] => BETWEEN
            [value] => ["2015-01-01","2020-01-01"]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `order_date` BETWEEN '2015-01-01' AND '2020-01-01' LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.93
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [21] => Array
        (
            [engin] => THING
            [index] => 10
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => order_date
            [operator] => BETWEEN
            [value] => ["2015-01-01","2020-01-01"]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  order_date BETWEEN '2015-01-01' AND '2020-01-01'  LIMIT 2
            [result_count] => 2
            [duration_ms] => 1.28
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [22] => Array
        (
            [engin] => PDOdb
            [index] => 11
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => notes
            [operator] => LIKE
            [value] => %Note%
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `notes` LIKE '%Note%' LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.8
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [23] => Array
        (
            [engin] => THING
            [index] => 11
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => notes
            [operator] => LIKE
            [value] => %Note%
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  notes LIKE '%Note%'  LIMIT 2
            [result_count] => 2
            [duration_ms] => 1.4
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [24] => Array
        (
            [engin] => PDOdb
            [index] => 12
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => notes
            [operator] => LIKE
            [value] => %8432%
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `notes` LIKE '%8432%' LIMIT 2
            [query_debug] => 
            [result_count] => 1
            [duration_ms] => 15.52
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 700
                            [user_id] => 700
                            [product_name] => Uranium Sample (fake)
                            [product_id] => 123456
                            [price] => 0.01
                            [status] => pending
                            [order_date] => 2016-03-24
                            [notes] => Note 8432
                        )

                )

        )

    [25] => Array
        (
            [engin] => THING
            [index] => 12
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => notes
            [operator] => LIKE
            [value] => %8432%
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  notes LIKE '%8432%'  LIMIT 2
            [result_count] => 1
            [duration_ms] => 12.61
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 700
                            [user_id] => 700
                            [product_name] => Uranium Sample (fake)
                            [product_id] => 123456
                            [price] => 0.01
                            [status] => pending
                            [order_date] => 2016-03-24
                            [notes] => Note 8432
                        )

                )

        )

    [26] => Array
        (
            [engin] => PDOdb
            [index] => 13
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => id
            [operator] => !=
            [value] => 99999
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `id` != 99999 LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.99
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [27] => Array
        (
            [engin] => THING
            [index] => 13
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => id
            [operator] => !=
            [value] => 99999
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  id != '99999'  LIMIT 2
            [result_count] => 2
            [duration_ms] => 0.97
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [28] => Array
        (
            [engin] => PDOdb
            [index] => 14
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => status
            [operator] => NOT IN
            [value] => ["canceled"]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `status` NOT IN ('canceled') LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.76
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                    [1] => Array
                        (
                            [id] => 3
                            [user_id] => 3
                            [product_name] => Dishes
                            [product_id] => 10300
                            [price] => 212.21
                            [status] => completed
                            [order_date] => 2015-01-02
                            [notes] => Note 2088
                        )

                )

        )

    [29] => Array
        (
            [engin] => THING
            [index] => 14
            [section] => validWhere
            [description] => Test valid where clauses
            [type] => 1
            [field] => status
            [operator] => NOT IN
            [value] => ["canceled"]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE  status NOT IN ( 'canceled' )  LIMIT 2
            [result_count] => 2
            [duration_ms] => 0.96
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                    [1] => Array
                        (
                            [id] => 3
                            [user_id] => 3
                            [product_name] => Dishes
                            [product_id] => 10300
                            [price] => 212.21
                            [status] => completed
                            [order_date] => 2015-01-02
                            [notes] => Note 2088
                        )

                )

        )

    [30] => Array
        (
            [engin] => PDOdb
            [index] => 15
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => SUM(price)
            [operator] => =
            [value] => 100
            [expect] => 
            [exception] => Aggregate function 'SUM()' is not allowed in WHERE clause.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [31] => Array
        (
            [engin] => THING
            [index] => 15
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => SUM(price)
            [operator] => =
            [value] => 100
            [expect] => 
            [exception] => Invalid use of group function
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  LIMIT 2
            [result_count] => 
            [duration_ms] => 0.38
            [status] => ✅ PASS
            [result] => 
        )

    [32] => Array
        (
            [engin] => PDOdb
            [index] => 16
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => SLEEP(1)
            [operator] => =
            [value] => 1
            [expect] => 
            [exception] => Unsafe WHERE clause rejected: SLEEP(1)
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.04
            [status] => ✅ PASS
            [result] => 
        )

    [33] => Array
        (
            [engin] => THING
            [index] => 16
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => SLEEP(1)
            [operator] => =
            [value] => 1
            [expect] => 
            [exception] => Invalid use of group function
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  LIMIT 2
            [result_count] => 
            [duration_ms] => 0.31
            [status] => ✅ PASS
            [result] => 
        )

    [34] => Array
        (
            [engin] => PDOdb
            [index] => 17
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => price
            [operator] => ===
            [value] => 100
            [expect] => 
            [exception] => Unsafe WHERE clause rejected: price ===
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [35] => Array
        (
            [engin] => THING
            [index] => 17
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => price
            [operator] => ===
            [value] => 100
            [expect] => 
            [exception] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '== ?  LIMIT 2' at line 1
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  LIMIT 2
            [result_count] => 
            [duration_ms] => 0.43
            [status] => ✅ PASS
            [result] => 
        )

    [36] => Array
        (
            [engin] => PDOdb
            [index] => 18
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => price
            [operator] => BETWEEN
            [value] => [10]
            [expect] => 
            [exception] => BETWEEN expects exactly 2 values.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [37] => Array
        (
            [engin] => THING
            [index] => 18
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => price
            [operator] => BETWEEN
            [value] => [10]
            [expect] => 
            [exception] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '== ?  AND price BETWEEN ? AND ?  LIMIT 2' at line 1
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  LIMIT 2
            [result_count] => 
            [duration_ms] => 0.34
            [status] => ✅ PASS
            [result] => 
        )

    [38] => Array
        (
            [engin] => PDOdb
            [index] => 19
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => status
            [operator] => IN
            [value] => [["completed"]]
            [expect] => 
            [exception] => Invalid value type in array for WHERE clause.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.04
            [status] => ✅ PASS
            [result] => 
        )

    [39] => Array
        (
            [engin] => THING
            [index] => 19
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => status
            [operator] => IN
            [value] => [["completed"]]
            [expect] => 
            [exception] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '== ?  AND price BETWEEN ? AND ?  AND status IN ( ? )  LIMIT 2' at line 1
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  LIMIT 2
            [result_count] => 
            [duration_ms] => 0.58
            [status] => ✅ PASS
            [result] => 
        )

    [40] => Array
        (
            [engin] => PDOdb
            [index] => 20
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => id
            [operator] => =
            [value] => 1; DROP TABLE x
            [expect] => 
            [exception] => Suspicious value in WHERE clause: id = 1; DROP TABLE x
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.05
            [status] => ✅ PASS
            [result] => 
        )

    [41] => Array
        (
            [engin] => THING
            [index] => 20
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => id
            [operator] => =
            [value] => 1; DROP TABLE x
            [expect] => 
            [exception] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '== ?  AND price BETWEEN ? AND ?  AND status IN ( ? )  AND id = ?  LIMIT 2' at line 1
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  LIMIT 2
            [result_count] => 
            [duration_ms] => 0.54
            [status] => ✅ PASS
            [result] => 
        )

    [42] => Array
        (
            [engin] => PDOdb
            [index] => 21
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => 1abc
            [operator] => =
            [value] => 1
            [expect] => 
            [exception] => Unsafe WHERE clause rejected: 1abc
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [43] => Array
        (
            [engin] => THING
            [index] => 21
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => 1abc
            [operator] => =
            [value] => 1
            [expect] => 
            [exception] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '== ?  AND price BETWEEN ? AND ?  AND status IN ( ? )  AND id = ?  AND 1abc = ...' at line 1
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  LIMIT 2
            [result_count] => 
            [duration_ms] => 0.55
            [status] => ✅ PASS
            [result] => 
        )

    [44] => Array
        (
            [engin] => PDOdb
            [index] => 22
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => status
            [operator] => =
            [value] => completed OR 1=1
            [expect] => 
            [exception] => Suspicious value in WHERE clause: status = completed OR 1=1
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.04
            [status] => ✅ PASS
            [result] => 
        )

    [45] => Array
        (
            [engin] => THING
            [index] => 22
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => status
            [operator] => =
            [value] => completed OR 1=1
            [expect] => 
            [exception] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '== ?  AND price BETWEEN ? AND ?  AND status IN ( ? )  AND id = ?  AND 1abc = ...' at line 1
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  LIMIT 2
            [result_count] => 
            [duration_ms] => 0.57
            [status] => ✅ PASS
            [result] => 
        )

    [46] => Array
        (
            [engin] => PDOdb
            [index] => 23
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => id
            [operator] => =
            [value] => {"[F]":["NOW()","UUID()"]}
            [expect] => 
            [exception] => Invalid [F] value: must be array with one function
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.02
            [status] => ✅ PASS
            [result] => 
        )

    [47] => Array
        (
            [engin] => THING
            [index] => 23
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => id
            [operator] => =
            [value] => {"[F]":["NOW()","UUID()"]}
            [expect] => 
            [exception] => You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '== ?  AND price BETWEEN ? AND ?  AND status IN ( ? )  AND id = ?  AND 1abc = ...' at line 1
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.62
            [status] => ✅ PASS
            [result] => 
        )

    [48] => Array
        (
            [engin] => PDOdb
            [index] => 24
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => id
            [operator] => =
            [value] => {"x":1}
            [expect] => 
            [exception] => Object in WHERE must implement getSubQuery()
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [49] => Array
        (
            [engin] => THING
            [index] => 24
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => id
            [operator] => =
            [value] => {"x":1}
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.1
            [status] => ✅ PASS
            [result] => 
        )

    [50] => Array
        (
            [engin] => PDOdb
            [index] => 25
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => status
            [operator] => =
            [value] => ["canceled","pending"]
            [expect] => 
            [exception] => Operator '=' not allowed for array values.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.01
            [status] => ✅ PASS
            [result] => 
        )

    [51] => Array
        (
            [engin] => THING
            [index] => 25
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => status
            [operator] => =
            [value] => ["canceled","pending"]
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.01
            [status] => ✅ PASS
            [result] => 
        )

    [52] => Array
        (
            [engin] => PDOdb
            [index] => 26
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => order..date
            [operator] => =
            [value] => 2023-01-01
            [expect] => 
            [exception] => Unsafe WHERE clause rejected: order..date
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.02
            [status] => ✅ PASS
            [result] => 
        )

    [53] => Array
        (
            [engin] => THING
            [index] => 26
            [section] => noValidWhere
            [description] => Test no valid where clauses
            [type] => 1
            [field] => order..date
            [operator] => =
            [value] => 2023-01-01
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [54] => Array
        (
            [engin] => PDOdb
            [index] => 27
            [section] => validInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => status
            [operator] => IN
            [value] => ["pending","completed"]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `status` IN ('pending', 'completed') LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.87
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                    [1] => Array
                        (
                            [id] => 3
                            [user_id] => 3
                            [product_name] => Dishes
                            [product_id] => 10300
                            [price] => 212.21
                            [status] => completed
                            [order_date] => 2015-01-02
                            [notes] => Note 2088
                        )

                )

        )

    [55] => Array
        (
            [engin] => THING
            [index] => 27
            [section] => validInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => status
            [operator] => IN
            [value] => ["pending","completed"]
            [expect] => 1
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.06
            [status] => ❌ FAIL
            [result] => 
        )

    [56] => Array
        (
            [engin] => PDOdb
            [index] => 28
            [section] => validInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => status
            [operator] => NOT IN
            [value] => ["canceled"]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `status` NOT IN ('canceled') LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.81
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                    [1] => Array
                        (
                            [id] => 3
                            [user_id] => 3
                            [product_name] => Dishes
                            [product_id] => 10300
                            [price] => 212.21
                            [status] => completed
                            [order_date] => 2015-01-02
                            [notes] => Note 2088
                        )

                )

        )

    [57] => Array
        (
            [engin] => THING
            [index] => 28
            [section] => validInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => status
            [operator] => NOT IN
            [value] => ["canceled"]
            [expect] => 1
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.06
            [status] => ❌ FAIL
            [result] => 
        )

    [58] => Array
        (
            [engin] => PDOdb
            [index] => 29
            [section] => validInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => user_id
            [operator] => IN
            [value] => [67,565,34]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `user_id` IN (67, 565, 34) LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 1
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 34
                            [user_id] => 34
                            [product_name] => Dishes
                            [product_id] => 10300
                            [price] => 212.21
                            [status] => canceled
                            [order_date] => 2015-01-22
                            [notes] => Note 5219
                        )

                    [1] => Array
                        (
                            [id] => 67
                            [user_id] => 67
                            [product_name] => Sex toys
                            [product_id] => 6969
                            [price] => 69.69
                            [status] => pending
                            [order_date] => 2015-02-12
                            [notes] => Note 8422
                        )

                )

        )

    [59] => Array
        (
            [engin] => THING
            [index] => 29
            [section] => validInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => user_id
            [operator] => IN
            [value] => [67,565,34]
            [expect] => 1
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.06
            [status] => ❌ FAIL
            [result] => 
        )

    [60] => Array
        (
            [engin] => PDOdb
            [index] => 30
            [section] => validInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => user_id
            [operator] => NOT IN
            [value] => [10]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `user_id` NOT IN (10) LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.81
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [61] => Array
        (
            [engin] => THING
            [index] => 30
            [section] => validInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => user_id
            [operator] => NOT IN
            [value] => [10]
            [expect] => 1
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.06
            [status] => ❌ FAIL
            [result] => 
        )

    [62] => Array
        (
            [engin] => PDOdb
            [index] => 31
            [section] => validInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS
            [value] => null
            [expect] => 
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `notes` IS NULL LIMIT 2
            [query_debug] => 
            [result_count] => 0
            [duration_ms] => 9.11
            [status] => ✅ PASS
            [result] => Array
                (
                )

        )

    [63] => Array
        (
            [engin] => THING
            [index] => 31
            [section] => validInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS
            [value] => null
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.06
            [status] => ✅ PASS
            [result] => 
        )

    [64] => Array
        (
            [engin] => PDOdb
            [index] => 32
            [section] => validInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS NOT
            [value] => null
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders WHERE `notes` IS NOT NULL LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.75
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [65] => Array
        (
            [engin] => THING
            [index] => 32
            [section] => validInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS NOT
            [value] => null
            [expect] => 1
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.06
            [status] => ❌ FAIL
            [result] => 
        )

    [66] => Array
        (
            [engin] => PDOdb
            [index] => 33
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS
            [value] => null
            [expect] => 
            [exception] => IS / IS NOT only supports a real NULL value.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.02
            [status] => ✅ PASS
            [result] => 
        )

    [67] => Array
        (
            [engin] => THING
            [index] => 33
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS
            [value] => null
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [68] => Array
        (
            [engin] => PDOdb
            [index] => 34
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS NOT
            [value] => null
            [expect] => 
            [exception] => IS / IS NOT only supports a real NULL value.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.01
            [status] => ✅ PASS
            [result] => 
        )

    [69] => Array
        (
            [engin] => THING
            [index] => 34
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS NOT
            [value] => null
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [70] => Array
        (
            [engin] => PDOdb
            [index] => 35
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS
            [value] => {"[F]":["NOW()"]}
            [expect] => 
            [exception] => IS / IS NOT only supports a real NULL value.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.01
            [status] => ✅ PASS
            [result] => 
        )

    [71] => Array
        (
            [engin] => THING
            [index] => 35
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS
            [value] => {"[F]":["NOW()"]}
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [72] => Array
        (
            [engin] => PDOdb
            [index] => 36
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS NOT
            [value] => {"[F]":["UUID()"]}
            [expect] => 
            [exception] => IS / IS NOT only supports a real NULL value.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.01
            [status] => ✅ PASS
            [result] => 
        )

    [73] => Array
        (
            [engin] => THING
            [index] => 36
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS NOT
            [value] => {"[F]":["UUID()"]}
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [74] => Array
        (
            [engin] => PDOdb
            [index] => 37
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS
            [value] => NULL OR 1=1
            [expect] => 
            [exception] => IS / IS NOT only supports a real NULL value.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.01
            [status] => ✅ PASS
            [result] => 
        )

    [75] => Array
        (
            [engin] => THING
            [index] => 37
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS
            [value] => NULL OR 1=1
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [76] => Array
        (
            [engin] => PDOdb
            [index] => 38
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS NOT
            [value] => NULL; DROP TABLE x
            [expect] => 
            [exception] => IS / IS NOT only supports a real NULL value.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.43
            [status] => ✅ PASS
            [result] => 
        )

    [77] => Array
        (
            [engin] => THING
            [index] => 38
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS NOT
            [value] => NULL; DROP TABLE x
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.05
            [status] => ✅ PASS
            [result] => 
        )

    [78] => Array
        (
            [engin] => PDOdb
            [index] => 39
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS
            [value] => [null]
            [expect] => 
            [exception] => IS / IS NOT only supports a real NULL value.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.01
            [status] => ✅ PASS
            [result] => 
        )

    [79] => Array
        (
            [engin] => THING
            [index] => 39
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS
            [value] => [null]
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [80] => Array
        (
            [engin] => PDOdb
            [index] => 40
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS NOT
            [value] => [null]
            [expect] => 
            [exception] => IS / IS NOT only supports a real NULL value.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.01
            [status] => ✅ PASS
            [result] => 
        )

    [81] => Array
        (
            [engin] => THING
            [index] => 40
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS NOT
            [value] => [null]
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [82] => Array
        (
            [engin] => PDOdb
            [index] => 41
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS
            [value] => {"x":null}
            [expect] => 
            [exception] => Object in WHERE must implement getSubQuery()
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.01
            [status] => ✅ PASS
            [result] => 
        )

    [83] => Array
        (
            [engin] => THING
            [index] => 41
            [section] => noValidInAndNotIn
            [description] => Test is IN and NOT IN where clauses
            [type] => 1
            [field] => notes
            [operator] => IS
            [value] => {"x":null}
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.02
            [status] => ✅ PASS
            [result] => 
        )

    [84] => Array
        (
            [engin] => PDOdb
            [index] => 42
            [section] => validHaving
            [description] => Test valid HAVING clauses with groupBy
            [type] => 2
            [field] => SUM(price)
            [operator] => >
            [value] => 500
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders GROUP BY `user_id` HAVING SUM(price) > 500 LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 1.23
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 14
                            [user_id] => 14
                            [product_name] => Arm prosthesis
                            [product_id] => 41234
                            [price] => 8432.32
                            [status] => canceled
                            [order_date] => 2015-01-09
                            [notes] => Note 6784
                        )

                    [1] => Array
                        (
                            [id] => 23
                            [user_id] => 23
                            [product_name] => Half cow
                            [product_id] => 21252
                            [price] => 689.90
                            [status] => completed
                            [order_date] => 2015-01-15
                            [notes] => Note 5924
                        )

                )

        )

    [85] => Array
        (
            [engin] => THING
            [index] => 42
            [section] => validHaving
            [description] => Test valid HAVING clauses with groupBy
            [type] => 2
            [field] => SUM(price)
            [operator] => >
            [value] => 500
            [expect] => 1
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.08
            [status] => ❌ FAIL
            [result] => 
        )

    [86] => Array
        (
            [engin] => PDOdb
            [index] => 43
            [section] => validHaving
            [description] => Test valid HAVING clauses with groupBy
            [type] => 2
            [field] => COUNT(id)
            [operator] => >=
            [value] => 2
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders GROUP BY `user_id` HAVING COUNT(id) >= 2 LIMIT 2
            [query_debug] => 
            [result_count] => 1
            [duration_ms] => 33.42
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 338
                            [user_id] => 338
                            [product_name] => Uranium Sample (fake)
                            [product_id] => 123456
                            [price] => 0.01
                            [status] => pending
                            [order_date] => 2015-08-05
                            [notes] => Note 4927
                        )

                )

        )

    [87] => Array
        (
            [engin] => THING
            [index] => 43
            [section] => validHaving
            [description] => Test valid HAVING clauses with groupBy
            [type] => 2
            [field] => COUNT(id)
            [operator] => >=
            [value] => 2
            [expect] => 1
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.08
            [status] => ❌ FAIL
            [result] => 
        )

    [88] => Array
        (
            [engin] => PDOdb
            [index] => 44
            [section] => validHaving
            [description] => Test valid HAVING clauses with groupBy
            [type] => 2
            [field] => AVG(price)
            [operator] => BETWEEN
            [value] => [10,1000]
            [expect] => 1
            [exception] => 
            [query] => SELECT  * FROM test_orders GROUP BY `user_id` HAVING AVG(price) BETWEEN 10 AND 1000 LIMIT 2
            [query_debug] => 
            [result_count] => 2
            [duration_ms] => 0.96
            [status] => ✅ PASS
            [result] => Array
                (
                    [0] => Array
                        (
                            [id] => 1
                            [user_id] => 1
                            [product_name] => Chair
                            [product_id] => 10610
                            [price] => 456.00
                            [status] => canceled
                            [order_date] => 2015-01-01
                            [notes] => Note 4959
                        )

                    [1] => Array
                        (
                            [id] => 2
                            [user_id] => 2
                            [product_name] => Anonymous Mask Deluxe
                            [product_id] => 111222
                            [price] => 17.76
                            [status] => pending
                            [order_date] => 2015-01-01
                            [notes] => Note 5990
                        )

                )

        )

    [89] => Array
        (
            [engin] => THING
            [index] => 44
            [section] => validHaving
            [description] => Test valid HAVING clauses with groupBy
            [type] => 2
            [field] => AVG(price)
            [operator] => BETWEEN
            [value] => [10,1000]
            [expect] => 1
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.07
            [status] => ❌ FAIL
            [result] => 
        )

    [90] => Array
        (
            [engin] => PDOdb
            [index] => 45
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => SUM(price)
            [operator] => ===
            [value] => 500
            [expect] => 
            [exception] => Unsafe HAVING clause rejected: SUM(price) ===
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.04
            [status] => ✅ PASS
            [result] => 
        )

    [91] => Array
        (
            [engin] => THING
            [index] => 45
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => SUM(price)
            [operator] => ===
            [value] => 500
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [92] => Array
        (
            [engin] => PDOdb
            [index] => 46
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => COUNT(id)
            [operator] => =
            [value] => 1
            [expect] => 
            [exception] => Aggregate function 'COUNT()' is not allowed in WHERE clause.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.02
            [status] => ✅ PASS
            [result] => 
        )

    [93] => Array
        (
            [engin] => THING
            [index] => 46
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => COUNT(id)
            [operator] => =
            [value] => 1
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [94] => Array
        (
            [engin] => PDOdb
            [index] => 47
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => price
            [operator] => >
            [value] => 100
            [expect] => 
            [exception] => Invalid HAVING column 'price': must be an alias, aggregate or in GROUP BY
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.02
            [status] => ✅ PASS
            [result] => 
        )

    [95] => Array
        (
            [engin] => THING
            [index] => 47
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => price
            [operator] => >
            [value] => 100
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [96] => Array
        (
            [engin] => PDOdb
            [index] => 48
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => SUM(price)
            [operator] => =
            [value] => 500 OR 1=1
            [expect] => 
            [exception] => Suspicious value in HAVING: "500 OR 1=1"
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.09
            [status] => ✅ PASS
            [result] => 
        )

    [97] => Array
        (
            [engin] => THING
            [index] => 48
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => SUM(price)
            [operator] => =
            [value] => 500 OR 1=1
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [98] => Array
        (
            [engin] => PDOdb
            [index] => 49
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => AVG(price)
            [operator] => BETWEEN
            [value] => [1000]
            [expect] => 
            [exception] => HAVING operator 'BETWEEN' requires an array with exactly two values.
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.02
            [status] => ✅ PASS
            [result] => 
        )

    [99] => Array
        (
            [engin] => THING
            [index] => 49
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => AVG(price)
            [operator] => BETWEEN
            [value] => [1000]
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.03
            [status] => ✅ PASS
            [result] => 
        )

    [100] => Array
        (
            [engin] => PDOdb
            [index] => 50
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => COUNT(id)
            [operator] => =
            [value] => {"[F]":["NOW()"]}
            [expect] => 
            [exception] => Unsafe HAVING clause rejected: COUNT(id) [F]
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.02
            [status] => ✅ PASS
            [result] => 
        )

    [101] => Array
        (
            [engin] => THING
            [index] => 50
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => COUNT(id)
            [operator] => =
            [value] => {"[F]":["NOW()"]}
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.12
            [status] => ✅ PASS
            [result] => 
        )

    [102] => Array
        (
            [engin] => PDOdb
            [index] => 51
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => SUM(price)
            [operator] => =
            [value] => {"x":1}
            [expect] => 
            [exception] => Unsupported value type in HAVING: object
            [query] => 
            [query_debug] => 
            [result_count] => 
            [duration_ms] => 0.07
            [status] => ✅ PASS
            [result] => 
        )

    [103] => Array
        (
            [engin] => THING
            [index] => 51
            [section] => noValidHaving
            [description] => Test invalid HAVING clauses (syntax errors, misuse, injections)
            [type] => 2
            [field] => SUM(price)
            [operator] => =
            [value] => {"x":1}
            [expect] => 
            [exception] => Call to undefined method stdClass::getSubQuery()
            [query] => SELECT  * FROM test_orders WHERE  SUM(price) = '100'  AND SLEEP(1) = '100'  AND price === '1'  AND price BETWEEN '100' AND '1'  AND status IN ( '100' )  AND id = '100'  AND 1abc = '1'  AND status = '100'  AND id LIMIT 2
            [result_count] => 
            [duration_ms] => 0.05
            [status] => ✅ PASS
            [result] => 
        )

)