test: enhance subquery tests with additional conditions and parameters

roxblnfk · roxblnfk · commit 09013c670cad · 2025-07-03T23:02:14.000+04:00
diff --git a/tests/Database/Functional/Driver/Common/Query/SelectQueryTest.php b/tests/Database/Functional/Driver/Common/Query/SelectQueryTest.php
@@ -2651,10 +2651,23 @@ public function testSelectFromSubQuery(): void
 
         $outerSelect = $this->database
             ->select()
-            ->from($injection);
+            ->from($injection)
+            ->where('u.id', '>', 10);
 
         $this->assertSameQuery(
-            'SELECT * FROM (SELECT * FROM {users} WHERE {name} = ?) AS {u}',
+            <<<SQL
+                SELECT *
+                FROM (SELECT * FROM {users} WHERE {name} = ?) AS {u}
+                WHERE {u}.{id} > ?
+                SQL,
+            $outerSelect,
+        );
+
+        $this->assertSameParameters(
+            [
+                'John Doe',
+                10,
+            ],
             $outerSelect,
         );
     }
@@ -2687,6 +2700,14 @@ public function testSelectFromTwoSubQuery(): void
                 SQL,
             $outerSelect,
         );
+
+        $this->assertSameParameters(
+            [
+                'John Doe',
+                12,
+            ],
+            $outerSelect,
+        );
     }
 
     public function testSelectSelectSubQuery(): void
@@ -2705,5 +2726,12 @@ public function testSelectSelectSubQuery(): void
             'SELECT *, (SELECT * FROM {users} WHERE {name} = ?) AS {u} FROM {apartments}',
             $outerSelect,
         );
+
+        $this->assertSameParameters(
+            [
+                'John Doe',
+            ],
+            $outerSelect,
+        );
     }
 }
