diff options
| author | Damian Dlugosz <bigfootdd@gmail.com> | 2017-01-23 23:41:56 +0100 |
|---|---|---|
| committer | Damian Dlugosz <bigfootdd@gmail.com> | 2017-02-01 23:33:23 +0100 |
| commit | d92d5f996dd5ffa8f4300a684790ded68c375221 (patch) | |
| tree | c3f113a00ddc61a8cee47db425e440688f0e4da3 /tests/Utils | |
| parent | f810a7bf08ced39a5e731b8b824bc2ed642d96be (diff) | |
| download | sql-parser-d92d5f996dd5ffa8f4300a684790ded68c375221.zip sql-parser-d92d5f996dd5ffa8f4300a684790ded68c375221.tar.gz sql-parser-d92d5f996dd5ffa8f4300a684790ded68c375221.tar.bz2 | |
Testing distinct count
Diffstat (limited to 'tests/Utils')
| -rw-r--r-- | tests/Utils/FormatterTest.php | 12 |
1 files changed, 12 insertions, 0 deletions
diff --git a/tests/Utils/FormatterTest.php b/tests/Utils/FormatterTest.php index 355027b..22018e6 100644 --- a/tests/Utils/FormatterTest.php +++ b/tests/Utils/FormatterTest.php @@ -334,6 +334,18 @@ class FormatTest extends TestCase '<span class="sql-reserved">SELECT</span>' . '<br/>' . ' <span class="sql-keyword">HEX</span>(<span class="sql-string">"1"</span>)', ), + 'distinct count' => array( + 'query' => 'select distinct count(*)', + 'text' => + 'SELECT DISTINCT' . "\n" . + ' COUNT(*)', + 'cli' => + "\x1b[35mSELECT \x1b[35mDISTINCT" . "\n" . + " \x1b[95mCOUNT\x1b[39m(\x1b[39m*\x1b[39m)" . "\x1b[0m", + 'html' => + '<span class="sql-reserved">SELECT</span> <span class="sql-reserved">DISTINCT</span>' . '<br/>' . + ' <span class="sql-keyword">COUNT</span>(*)', + ), 'create procedure' => array( 'query' => 'create procedure test_procedure() begin from tbl select *; end', 'text' => |