summaryrefslogtreecommitdiffstats
path: root/tests
diff options
context:
space:
mode:
authorMichal Čihař <michal@cihar.com>2017-02-20 08:00:20 +0100
committerGitHub <noreply@github.com>2017-02-20 08:00:20 +0100
commitbaf740af89571198045c007ebfc749aee87aef2e (patch)
tree278d8586006101b1e52b4cfb595a73854c86c9bf /tests
parent038f6039af65f19adabda279d9cae7e7dcaf01e4 (diff)
parentea60c287ff95a699359feca1ffc9abfb72370d26 (diff)
downloadsql-parser-baf740af89571198045c007ebfc749aee87aef2e.zip
sql-parser-baf740af89571198045c007ebfc749aee87aef2e.tar.gz
sql-parser-baf740af89571198045c007ebfc749aee87aef2e.tar.bz2
Merge pull request #141 from bigfoot90/inline-joins
Inline JOINs
Diffstat (limited to 'tests')
-rw-r--r--tests/Utils/FormatterTest.php7
1 files changed, 7 insertions, 0 deletions
diff --git a/tests/Utils/FormatterTest.php b/tests/Utils/FormatterTest.php
index b8a8ff2..c209d27 100644
--- a/tests/Utils/FormatterTest.php
+++ b/tests/Utils/FormatterTest.php
@@ -508,6 +508,13 @@ class FormatTest extends TestCase
'&nbsp;&nbsp;&nbsp;&nbsp;<span class="sql-variable">`query`</span> <span class="sql-keyword">TEXT</span> <span class="sql-reserved">NOT NULL</span>,' . '<br/>' .
'&nbsp;&nbsp;&nbsp;&nbsp;<span class="sql-reserved">PRIMARY KEY</span>(<span class="sql-variable">`id`</span>)',
),
+ 'join' => array(
+ 'query' => 'join tbl2 on c1=c2',
+ 'text' => 'JOIN tbl2 ON c1 = c2',
+ 'cli' => "\x1b[35mJOIN \x1b[39mtbl2 \x1b[35mON \x1b[39mc1 \x1b[39m= \x1b[39mc2" .
+ "\x1b[0m",
+ 'html' => '<span class="sql-reserved">JOIN</span> tbl2 <span class="sql-reserved">ON</span> c1 = c2',
+ ),
);
}
}