Add component build tests from CASE expressions with aliases

phpmyadmin · Oct 13, 2018 · 61343f6 · 61343f6
1 parent 6f76011
commit 61343f6
Showing 1 changed file with 28 additions and 0 deletions.
diff --git a/tests/Components/CaseExpressionTest.php b/tests/Components/CaseExpressionTest.php
@@ -83,4 +83,32 @@ public function testParseBuild6()
             'CASE WHEN 1=1 THEN "Some" WHEN 1=2 THEN "SomeOther" END'
         );
     }
+
+    public function testParseBuild7()
+    {
+        $caseExprQuery = 'case when 1=1 then "Some" '
+            . 'when 1=2 then "SomeOther" end AS foo';
+        $component = CaseExpression::parse(
+            new Parser(),
+            $this->getTokensList($caseExprQuery)
+        );
+        $this->assertEquals(
+            CaseExpression::build($component),
+            'CASE WHEN 1=1 THEN "Some" WHEN 1=2 THEN "SomeOther" END AS `foo`'
+        );
+    }
+
+    public function testParseBuild8()
+    {
+        $caseExprQuery = 'case when 1=1 then "Some" '
+            . 'when 1=2 then "SomeOther" end foo';
+        $component = CaseExpression::parse(
+            new Parser(),
+            $this->getTokensList($caseExprQuery)
+        );
+        $this->assertEquals(
+            CaseExpression::build($component),
+            'CASE WHEN 1=1 THEN "Some" WHEN 1=2 THEN "SomeOther" END AS `foo`'
+        );
+    }
 }