1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
|
<?php
declare(strict_types=1);
namespace PhpMyAdmin\SqlParser\Tests\Parser;
use PhpMyAdmin\SqlParser\Parser;
use PhpMyAdmin\SqlParser\Tests\TestCase;
class SelectStatementTest extends TestCase
{
public function testSelectOptions()
{
$data = $this->getData('parser/parseSelect');
$parser = new Parser($data['query']);
$stmt = $parser->statements[0];
$this->assertEquals(10, $stmt->options->has('MAX_STATEMENT_TIME'));
}
/**
* @param mixed $test
*
* @dataProvider selectProvider
*/
public function testSelect($test)
{
$this->runParserTest($test);
}
public function selectProvider()
{
return [
['parser/parseSelect2'],
['parser/parseSelect3'],
['parser/parseSelect4'],
['parser/parseSelect5'],
['parser/parseSelect6'],
['parser/parseSelect7'],
['parser/parseSelect8'],
['parser/parseSelect9'],
['parser/parseSelect10'],
['parser/parseSelect11'],
['parser/parseSelectErr1'],
['parser/parseSelectErr2'],
['parser/parseSelectNested'],
['parser/parseSelectCase1'],
['parser/parseSelectCase2'],
['parser/parseSelectCase3'],
['parser/parseSelectCase4'],
['parser/parseSelectCase5'],
['parser/parseSelectCaseErr1'],
['parser/parseSelectCaseErr2'],
['parser/parseSelectCaseErr3'],
['parser/parseSelectCaseErr4'],
['parser/parseSelectCaseErr5'],
['parser/parseSelectCaseAlias1'],
['parser/parseSelectCaseAlias2'],
['parser/parseSelectCaseAlias3'],
['parser/parseSelectCaseAlias4'],
['parser/parseSelectCaseAlias5'],
['parser/parseSelectCaseAlias6'],
['parser/parseSelectCaseAliasErr1'],
['parser/parseSelectCaseAliasErr2'],
['parser/parseSelectCaseAliasErr3'],
['parser/parseSelectCaseAliasErr4'],
['parser/parseSelectIntoOptions1'],
['parser/parseSelectIntoOptions2'],
['parser/parseSelectIntoOptions3'],
['parser/parseSelectJoinCross'],
['parser/parseSelectJoinNatural'],
['parser/parseSelectJoinNaturalLeft'],
['parser/parseSelectJoinNaturalRight'],
['parser/parseSelectJoinNaturalLeftOuter'],
['parser/parseSelectJoinNaturalRightOuter'],
['parser/parseSelectJoinMultiple'],
['parser/parseSelectJoinMultiple2'],
['parser/parseSelectWrongOrder'],
['parser/parseSelectWrongOrder2'],
['parser/parseSelectEndOptions1'],
['parser/parseSelectEndOptions2'],
['parser/parseSelectEndOptionsErr'],
['parser/parseSelectUnion'],
['parser/parseSelectUnion2'],
['parser/parseSelectIndexHint1'],
['parser/parseSelectIndexHint2'],
['parser/parseSelectIndexHintErr1'],
['parser/parseSelectIndexHintErr2'],
['parser/parseSelectIndexHintErr3'],
['parser/parseSelectIndexHintErr4'],
['parser/parseSelectWithParenthesis'],
];
}
}
|
