PATH=C:\cpanfly-5.24-32\var\megalib\bin;C:\Perl-5.24-32\site\bin;C:\Perl-5.24-32\bin;C:\MinGW-32\bin;C:\cygwin\bin;C:\instantclient_11_2-32;C:\p4;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Program Files\Git\cmd;C:\Program Files (x86)\CMake\bin
Start 2016-06-03T14:24:27
ActivePerl-2400 CPAN-2.10
PATH=C:/CPANFL~2.24-/var/libs/bin;C:\CPANFL~2.24-\var\megalib\bin;C:\PERL-5~2.24-\site\bin;C:\PERL-5~2.24-\bin;C:\MinGW-32\bin;C:\cygwin\bin;C:\INSTAN~3;C:\p4;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WINDOW~1\v1.0\;C:\PROGRA~1\Git\cmd;C:\PROGRA~2\CMake\bin
Reading 'C:\cpanfly-5.24-32\var\cpan\Metadata'
Database was generated on Fri, 03 Jun 2016 05:53:47 GMT
Checksum for C:\cpanfly-5.24-32\var\cpan\sources\authors\id\R\RE\REHSACK\SQL-Statement-1.410.tar.gz ok
SQL-Statement-1.410/
SQL-Statement-1.410/ARTISTIC-1.0
SQL-Statement-1.410/Changes
SQL-Statement-1.410/GPL-1
SQL-Statement-1.410/GPL-2.0
SQL-Statement-1.410/lib/
SQL-Statement-1.410/LICENSE
SQL-Statement-1.410/Makefile.PL
SQL-Statement-1.410/MANIFEST
SQL-Statement-1.410/MANIFEST.SKIP
SQL-Statement-1.410/META.json
SQL-Statement-1.410/META.yml
SQL-Statement-1.410/README
SQL-Statement-1.410/README.md
SQL-Statement-1.410/t/
SQL-Statement-1.410/t/00error.t
SQL-Statement-1.410/t/01prepare.t
SQL-Statement-1.410/t/02execute.t
SQL-Statement-1.410/t/03import.t
SQL-Statement-1.410/t/04idents.t
SQL-Statement-1.410/t/05simple.t
SQL-Statement-1.410/t/06virtual.t
SQL-Statement-1.410/t/08join.t
SQL-Statement-1.410/t/09ops.t
SQL-Statement-1.410/t/10limit.t
SQL-Statement-1.410/t/12eval.t
SQL-Statement-1.410/t/14parse.t
SQL-Statement-1.410/t/17quoting.t
SQL-Statement-1.410/t/23dialects.t
SQL-Statement-1.410/t/SQLtest.pm
SQL-Statement-1.410/t/TestLib.pm
SQL-Statement-1.410/lib/SQL/
SQL-Statement-1.410/lib/SQL/Dialects/
SQL-Statement-1.410/lib/SQL/Eval.pm
SQL-Statement-1.410/lib/SQL/Parser.pm
SQL-Statement-1.410/lib/SQL/Statement/
SQL-Statement-1.410/lib/SQL/Statement.pm
SQL-Statement-1.410/lib/SQL/Statement/Embed.pod
SQL-Statement-1.410/lib/SQL/Statement/Function.pm
SQL-Statement-1.410/lib/SQL/Statement/Functions.pm
SQL-Statement-1.410/lib/SQL/Statement/GetInfo.pm
SQL-Statement-1.410/lib/SQL/Statement/Operation.pm
SQL-Statement-1.410/lib/SQL/Statement/Placeholder.pm
SQL-Statement-1.410/lib/SQL/Statement/RAM.pm
SQL-Statement-1.410/lib/SQL/Statement/Roadmap.pod
SQL-Statement-1.410/lib/SQL/Statement/Structure.pod
SQL-Statement-1.410/lib/SQL/Statement/Syntax.pod
SQL-Statement-1.410/lib/SQL/Statement/Term.pm
SQL-Statement-1.410/lib/SQL/Statement/TermFactory.pm
SQL-Statement-1.410/lib/SQL/Statement/Util.pm
SQL-Statement-1.410/lib/SQL/Dialects/ANSI.pm
SQL-Statement-1.410/lib/SQL/Dialects/AnyData.pm
SQL-Statement-1.410/lib/SQL/Dialects/CSV.pm
SQL-Statement-1.410/lib/SQL/Dialects/Role.pm
Configuring R/RE/REHSACK/SQL-Statement-1.410.tar.gz with Makefile.PL
>>> C:\Perl-5.24-32\bin\perl.exe Makefile.PL
Warning: prerequisite Math::Base::Convert 0 not found.
Checking if your kit is complete...
Looks good
Generating a dmake-style Makefile
Writing Makefile for SQL::Statement
Writing MYMETA.yml and MYMETA.json
REHSACK/SQL-Statement-1.410.tar.gz
C:\Perl-5.24-32\bin\perl.exe Makefile.PL -- OK
Running make for R/RE/REHSACK/SQL-Statement-1.410.tar.gz
---- Unsatisfied dependencies detected during ----
---- REHSACK/SQL-Statement-1.410.tar.gz ----
Math::Base::Convert [build_requires]
Running test for module 'Math::Base::Convert'
Checksum for C:\cpanfly-5.24-32\var\cpan\sources\authors\id\M\MI\MIKER\Math-Base-Convert-0.11.tar.gz ok
Math-Base-Convert-0.11/
Math-Base-Convert-0.11/t/
Math-Base-Convert-0.11/t/isnotp2.t
Math-Base-Convert-0.11/t/vet.t
Math-Base-Convert-0.11/t/overload.t
Math-Base-Convert-0.11/t/basemap.t
Math-Base-Convert-0.11/t/frontend.t
Math-Base-Convert-0.11/t/useTObaseShortcuts.t
Math-Base-Convert-0.11/t/basefunct.t
Math-Base-Convert-0.11/t/benchmarkcnv.t
Math-Base-Convert-0.11/t/vetcontext.t
Math-Base-Convert-0.11/t/validbase.t
Math-Base-Convert-0.11/t/zstrings.t
Math-Base-Convert-0.11/t/useFROMbaseto32wide.t
Math-Base-Convert-0.11/t/backend.t
Math-Base-Convert-0.11/t/longmultiply.t
Math-Base-Convert-0.11/t/basemethods.t
Math-Base-Convert-0.11/t/benchmarkcalc.t
Math-Base-Convert-0.11/t/shiftright.t
Math-Base-Convert-0.11/t/convert.t
Math-Base-Convert-0.11/t/ascii.t
Math-Base-Convert-0.11/t/useFROMbaseShortcuts.t
Math-Base-Convert-0.11/MANIFEST
Math-Base-Convert-0.11/Changes
Math-Base-Convert-0.11/benchmarks/
Math-Base-Convert-0.11/benchmarks/benchmark1.txt
Math-Base-Convert-0.11/benchmarks/benchmark2.txt
Math-Base-Convert-0.11/benchmarks/benchmark3.txt
Math-Base-Convert-0.11/lib/
Math-Base-Convert-0.11/lib/Math/
Math-Base-Convert-0.11/lib/Math/Base/
Math-Base-Convert-0.11/lib/Math/Base/Convert/
Math-Base-Convert-0.11/lib/Math/Base/Convert/CalcPP.pm
Math-Base-Convert-0.11/lib/Math/Base/Convert/Shortcuts.pm
Math-Base-Convert-0.11/lib/Math/Base/Convert/Bases.pm
Math-Base-Convert-0.11/Convert.pm
Math-Base-Convert-0.11/MANIFEST.SKIP
Math-Base-Convert-0.11/README
Math-Base-Convert-0.11/bitmaps
Math-Base-Convert-0.11/Makefile.PL
Math-Base-Convert-0.11/recurse2txt
Math-Base-Convert-0.11/META.yml
Configuring M/MI/MIKER/Math-Base-Convert-0.11.tar.gz with Makefile.PL
>>> C:\Perl-5.24-32\bin\perl.exe Makefile.PL
MIKER/Math-Base-Convert-0.11.tar.gz
C:\Perl-5.24-32\bin\perl.exe Makefile.PL -- OK
Running make for M/MI/MIKER/Math-Base-Convert-0.11.tar.gz
>>> dmake
cp lib/Math/Base/Convert/Bases.pm blib\lib\Math\Base\Convert\Bases.pm
cp lib/Math/Base/Convert/CalcPP.pm blib\lib\Math\Base\Convert\CalcPP.pm
cp Convert.pm blib\lib\Math\Base\Convert.pm
cp lib/Math/Base/Convert/Bitmaps.pm blib\lib\Math\Base\Convert\Bitmaps.pm
cp lib/Math/Base/Convert/Shortcuts.pm blib\lib\Math\Base\Convert\Shortcuts.pm
MIKER/Math-Base-Convert-0.11.tar.gz
dmake -- OK
Running make test
>>> dmake test TEST_VERBOSE=1
"C:\Perl-5.24-32\bin\perl.exe" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(1, 'blib\lib', 'blib\arch')" t/*.t
t/ascii.t .................
1..2
ok 1
ok 2
ok
t/backend.t ...............
1..133
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13 # skipped: no BigInt or benchmark 2
ok 14 # skipped: no BigInt or benchmark 2
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
ok 52
ok 53
ok 54
ok 55
ok 56
ok 57
ok 58
ok 59
ok 60
ok 61
ok 62
ok 63
ok 64
ok 65
ok 66
ok 67
ok 68
ok 69
ok 70
ok 71
ok 72
ok 73
ok 74
ok 75
ok 76
ok 77
ok 78
ok 79
ok 80
ok 81
ok 82
ok 83
ok 84
ok 85
ok 86
ok 87
ok 88
ok 89
ok 90
ok 91
ok 92
ok 93
ok 94
ok 95
ok 96
ok 97
ok 98
ok 99
ok 100
ok 101
ok 102
ok 103
ok 104
ok 105
ok 106
ok 107
ok 108
ok 109
ok 110
ok 111
ok 112
ok 113
ok 114
ok 115
ok 116
ok 117
ok 118
ok 119
ok 120
ok 121
ok 122
ok 123
ok 124
ok 125
ok 126
ok 127 # skipped: no BigInt or benchmark 2
ok 128 # skipped: no BigInt or benchmark 2
ok 129 # skipped: no BigInt or benchmark 2
ok 130 # skipped: no BigInt or benchmark 2
ok 131 # skipped: no BigInt or benchmark 2
ok 132 # skipped: no BigInt or benchmark 2
ok 133 # skipped: no BigInt or benchmark 2
ok
t/basefunct.t .............
1..17
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok
t/basemap.t ...............
1..113
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
ok 52
ok 53
ok 54
ok 55
ok 56
ok 57
ok 58
ok 59
ok 60
ok 61
ok 62
ok 63
ok 64
ok 65
ok 66
ok 67
ok 68
ok 69
ok 70
ok 71
ok 72
ok 73
ok 74
ok 75
ok 76
ok 77
ok 78
ok 79
ok 80
ok 81
ok 82
ok 83
ok 84
ok 85
ok 86
ok 87
ok 88
ok 89
ok 90
ok 91
ok 92
ok 93
ok 94
ok 95
ok 96
ok 97
ok 98
ok 99
ok 100
ok 101
ok 102
ok 103
ok 104
ok 105
ok 106
ok 107
ok 108
ok 109
ok 110
ok 111
ok 112
ok 113
ok
t/basemethods.t ...........
1..17
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok
t/benchmarkcalc.t .........
1..70
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
ok 52
ok 53
ok 54
ok 55
ok 56
ok 57
ok 58
ok 59
ok 60
ok 61
ok 62
ok 63
ok 64
ok 65
ok 66
ok 67
ok 68
ok 69
ok 70 # skipped: benchmark 3
ok
t/benchmarkcnv.t ..........
1..157
ok 1
ok 2 # skipped: no BigInt or benchmark 1
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
ok 52
ok 53
ok 54
ok 55
ok 56
ok 57
ok 58
ok 59
ok 60
ok 61
ok 62
ok 63
ok 64
ok 65
ok 66
ok 67
ok 68
ok 69
ok 70
ok 71
ok 72
ok 73
ok 74
ok 75
ok 76
ok 77
ok 78
ok 79
ok 80
ok 81
ok 82
ok 83
ok 84
ok 85
ok 86
ok 87
ok 88
ok 89
ok 90
ok 91
ok 92
ok 93
ok 94
ok 95
ok 96
ok 97
ok 98
ok 99
ok 100
ok 101
ok 102
ok 103
ok 104
ok 105
ok 106
ok 107
ok 108
ok 109
ok 110
ok 111
ok 112
ok 113
ok 114
ok 115
ok 116
ok 117
ok 118
ok 119
ok 120
ok 121
ok 122
ok 123
ok 124
ok 125
ok 126
ok 127
ok 128
ok 129
ok 130
ok 131
ok 132
ok 133
ok 134
ok 135
ok 136
ok 137
ok 138
ok 139
ok 140
ok 141
ok 142
ok 143
ok 144
ok 145
ok 146
ok 147
ok 148
ok 149 # skipped: no BigInt or benchmark 1
ok 150 # skipped: no BigInt or benchmark 1
ok 151 # skipped: no BigInt or benchmark 1
ok 152 # skipped: no BigInt or benchmark 1
ok 153 # skipped: no BigInt or benchmark 1
ok 154 # skipped: no BigInt or benchmark 1
ok 155 # skipped: no BigInt or benchmark 1
ok 156 # skipped: no BigInt or benchmark 1
ok 157 # skipped: no BigInt or benchmark 1
ok
t/convert.t ...............
1..45
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok
t/frontend.t ..............
1..139
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19 # skipped: no BigInt or benchmark 2
ok 20 # skipped: no BigInt or benchmark 2
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
ok 52
ok 53
ok 54
ok 55
ok 56
ok 57
ok 58
ok 59
ok 60
ok 61
ok 62
ok 63
ok 64
ok 65
ok 66
ok 67
ok 68
ok 69
ok 70
ok 71
ok 72
ok 73
ok 74
ok 75
ok 76
ok 77
ok 78
ok 79
ok 80
ok 81
ok 82
ok 83
ok 84
ok 85
ok 86
ok 87
ok 88
ok 89
ok 90
ok 91
ok 92
ok 93
ok 94
ok 95
ok 96
ok 97
ok 98
ok 99
ok 100
ok 101
ok 102
ok 103
ok 104
ok 105
ok 106
ok 107
ok 108
ok 109
ok 110
ok 111
ok 112
ok 113
ok 114
ok 115
ok 116
ok 117
ok 118
ok 119
ok 120
ok 121
ok 122
ok 123
ok 124
ok 125
ok 126
ok 127
ok 128
ok 129
ok 130
ok 131
ok 132
ok 133 # skipped: no BigInt or benchmark 2
ok 134 # skipped: no BigInt or benchmark 2
ok 135 # skipped: no BigInt or benchmark 2
ok 136 # skipped: no BigInt or benchmark 2
ok 137 # skipped: no BigInt or benchmark 2
ok 138 # skipped: no BigInt or benchmark 2
ok 139 # skipped: no BigInt or benchmark 2
ok
t/isnotp2.t ...............
1..63
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
ok 52
ok 53
ok 54
ok 55
ok 56
ok 57
ok 58
ok 59
ok 60
ok 61
ok 62
ok 63
ok
t/longmultiply.t ..........
1..5
ok 1
ok 2
ok 3
ok 4
ok 5
ok
t/overload.t ..............
1..23
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7 # skipped: removed
ok 8 # skipped: removed
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18 # skipped: removed
ok 19 # skipped: removed
ok 20
ok 21
ok 22
ok 23
ok
t/shiftright.t ............
1..10
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok
t/useFROMbaseShortcuts.t ..
1..37
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33 # skipped: benchmark 3
ok 34 # skipped: benchmark 3
ok 35 # skipped: benchmark 3
ok 36 # skipped: benchmark 3
ok 37 # skipped: benchmark 3
ok
t/useFROMbaseto32wide.t ...
1..6
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok
t/useTObaseShortcuts.t ....
1..69
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
ok 52
ok 53
ok 54
ok 55
ok 56
ok 57
ok 58
ok 59
ok 60
ok 61
ok 62
ok 63
ok 64
ok 65 # skipped: benchmark 3
ok 66 # skipped: benchmark 3
ok 67 # skipped: benchmark 3
ok 68 # skipped: benchmark 3
ok 69 # skipped: benchmark 3
ok
t/validbase.t .............
1..40
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
ok 40
ok
t/vet.t ...................
1..34
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok
t/vetcontext.t ............
1..13
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok
t/zstrings.t ..............
1..4357
ok 1
ok 2
ok 3
ok 4
ok 5
ok 6
ok 7
ok 8
ok 9
ok 10
ok 11
ok 12
ok 13
ok 14
ok 15
ok 16
ok 17
ok 18
ok 19
ok 20
ok 21
ok 22
ok 23
ok 24
ok 25
ok 26
ok 27
ok 28
ok 29
ok 30
ok 31
ok 32
ok 33
ok 34
ok 35
ok 36
ok 37
ok 38
ok 39
ok 40
ok 41
ok 42
ok 43
ok 44
ok 45
ok 46
ok 47
ok 48
ok 49
ok 50
ok 51
ok 52
ok 53
ok 54
ok 55
ok 56
ok 57
ok 58
ok 59
ok 60
ok 61
ok 62
ok 63
ok 64
ok 65
ok 66
ok 67
ok 68
ok 69
ok 70
ok 71
ok 72
ok 73
ok 74
ok 75
ok 76
ok 77
ok 78
ok 79
ok 80
ok 81
ok 82
ok 83
ok 84
ok 85
ok 86
ok 87
ok 88
ok 89
ok 90
ok 91
ok 92
ok 93
ok 94
ok 95
ok 96
ok 97
ok 98
ok 99
ok 100
ok 101
ok 102
ok 103
ok 104
ok 105
ok 106
ok 107
ok 108
ok 109
ok 110
ok 111
ok 112
ok 113
ok 114
ok 115
ok 116
ok 117
ok 118
ok 119
ok 120
ok 121
ok 122
ok 123
ok 124
ok 125
ok 126
ok 127
ok 128
ok 129
ok 130
ok 131
ok 132
ok 133
ok 134
ok 135
ok 136
ok 137
ok 138
ok 139
ok 140
ok 141
ok 142
ok 143
ok 144
ok 145
ok 146
ok 147
ok 148
ok 149
ok 150
ok 151
ok 152
ok 153
ok 154
ok 155
ok 156
ok 157
ok 158
ok 159
ok 160
ok 161
ok 162
ok 163
ok 164
ok 165
ok 166
ok 167
ok 168
ok 169
ok 170
ok 171
ok 172
ok 173
ok 174
ok 175
ok 176
ok 177
ok 178
ok 179
ok 180
ok 181
ok 182
ok 183
ok 184
ok 185
ok 186
ok 187
ok 188
ok 189
ok 190
ok 191
ok 192
ok 193
ok 194
ok 195
ok 196
ok 197
ok 198
ok 199
ok 200
ok 201
ok 202
ok 203
ok 204
ok 205
ok 206
ok 207
ok 208
ok 209
ok 210
ok 211
ok 212
ok 213
ok 214
ok 215
ok 216
ok 217
ok 218
ok 219
ok 220
ok 221
ok 222
ok 223
ok 224
ok 225
ok 226
ok 227
ok 228
ok 229
ok 230
ok 231
ok 232
ok 233
ok 234
ok 235
ok 236
ok 237
ok 238
ok 239
ok 240
ok 241
ok 242
ok 243
ok 244
ok 245
ok 246
ok 247
ok 248
ok 249
ok 250
ok 251
ok 252
ok 253
ok 254
ok 255
ok 256
ok 257
ok 258
ok 259
ok 260
ok 261
ok 262
ok 263
ok 264
ok 265
ok 266
ok 267
ok 268
ok 269
ok 270
ok 271
ok 272
ok 273
ok 274
ok 275
ok 276
ok 277
ok 278
ok 279
ok 280
ok 281
ok 282
ok 283
ok 284
ok 285
ok 286
ok 287
ok 288
ok 289
ok 290
ok 291
ok 292
ok 293
ok 294
ok 295
ok 296
ok 297
ok 298
ok 299
ok 300
ok 301
ok 302
ok 303
ok 304
ok 305
ok 306
ok 307
ok 308
ok 309
ok 310
ok 311
ok 312
ok 313
ok 314
ok 315
ok 316
ok 317
ok 318
ok 319
ok 320
ok 321
ok 322
ok 323
ok 324
ok 325
ok 326
ok 327
ok 328
ok 329
ok 330
ok 331
ok 332
ok 333
ok 334
ok 335
ok 336
ok 337
ok 338
ok 339
ok 340
ok 341
ok 342
ok 343
ok 344
ok 345
ok 346
ok 347
ok 348
ok 349
ok 350
ok 351
ok 352
ok 353
ok 354
ok 355
ok 356
ok 357
ok 358
ok 359
ok 360
ok 361
ok 362
ok 363
ok 364
ok 365
ok 366
ok 367
ok 368
ok 369
ok 370
ok 371
ok 372
ok 373
ok 374
ok 375
ok 376
ok 377
ok 378
ok 379
ok 380
ok 381
ok 382
ok 383
ok 384
ok 385
ok 386
ok 387
ok 388
ok 389
ok 390
ok 391
ok 392
ok 393
ok 394
ok 395
ok 396
ok 397
ok 398
ok 399
ok 400
ok 401
ok 402
ok 403
ok 404
ok 405
ok 406
ok 407
ok 408
ok 409
ok 410
ok 411
ok 412
ok 413
ok 414
ok 415
ok 416
ok 417
ok 418
ok 419
ok 420
ok 421
ok 422
ok 423
ok 424
ok 425
ok 426
ok 427
ok 428
ok 429
ok 430
ok 431
ok 432
ok 433
ok 434
ok 435
ok 436
ok 437
ok 438
ok 439
ok 440
ok 441
ok 442
ok 443
ok 444
ok 445
ok 446
ok 447
ok 448
ok 449
ok 450
ok 451
ok 452
ok 453
ok 454
ok 455
ok 456
ok 457
ok 458
ok 459
ok 460
ok 461
ok 462
ok 463
ok 464
ok 465
ok 466
ok 467
ok 468
ok 469
ok 470
ok 471
ok 472
ok 473
ok 474
ok 475
ok 476
ok 477
ok 478
ok 479
ok 480
ok 481
ok 482
ok 483
ok 484
ok 485
ok 486
ok 487
ok 488
ok 489
ok 490
ok 491
ok 492
ok 493
ok 494
ok 495
ok 496
ok 497
ok 498
ok 499
ok 500
ok 501
ok 502
ok 503
ok 504
ok 505
ok 506
ok 507
ok 508
ok 509
ok 510
ok 511
ok 512
ok 513
ok 514
ok 515
ok 516
ok 517
ok 518
ok 519
ok 520
ok 521
ok 522
ok 523
ok 524
ok 525
ok 526
ok 527
ok 528
ok 529
ok 530
ok 531
ok 532
ok 533
ok 534
ok 535
ok 536
ok 537
ok 538
ok 539
ok 540
ok 541
ok 542
ok 543
ok 544
ok 545
ok 546
ok 547
ok 548
ok 549
ok 550
ok 551
ok 552
ok 553
ok 554
ok 555
ok 556
ok 557
ok 558
ok 559
ok 560
ok 561
ok 562
ok 563
ok 564
ok 565
ok 566
ok 567
ok 568
ok 569
ok 570
ok 571
ok 572
ok 573
ok 574
ok 575
ok 576
ok 577
ok 578
ok 579
ok 580
ok 581
ok 582
ok 583
ok 584
ok 585
ok 586
ok 587
ok 588
ok 589
ok 590
ok 591
ok 592
ok 593
ok 594
ok 595
ok 596
ok 597
ok 598
ok 599
ok 600
ok 601
ok 602
ok 603
ok 604
ok 605
ok 606
ok 607
ok 608
ok 609
ok 610
ok 611
ok 612
ok 613
ok 614
ok 615
ok 616
ok 617
ok 618
ok 619
ok 620
ok 621
ok 622
ok 623
ok 624
ok 625
ok 626
ok 627
ok 628
ok 629
ok 630
ok 631
ok 632
ok 633
ok 634
ok 635
ok 636
ok 637
ok 638
ok 639
ok 640
ok 641
ok 642
ok 643
ok 644
ok 645
ok 646
ok 647
ok 648
ok 649
ok 650
ok 651
ok 652
ok 653
ok 654
ok 655
ok 656
ok 657
ok 658
ok 659
ok 660
ok 661
ok 662
ok 663
ok 664
ok 665
ok 666
ok 667
ok 668
ok 669
ok 670
ok 671
ok 672
ok 673
ok 674
ok 675
ok 676
ok 677
ok 678
ok 679
ok 680
ok 681
ok 682
ok 683
ok 684
ok 685
ok 686
ok 687
ok 688
ok 689
ok 690
ok 691
ok 692
ok 693
ok 694
ok 695
ok 696
ok 697
ok 698
ok 699
ok 700
ok 701
ok 702
ok 703
ok 704
ok 705
ok 706
ok 707
ok 708
ok 709
ok 710
ok 711
ok 712
ok 713
ok 714
ok 715
ok 716
ok 717
ok 718
ok 719
ok 720
ok 721
ok 722
ok 723
ok 724
ok 725
ok 726
ok 727
ok 728
ok 729
ok 730
ok 731
ok 732
ok 733
ok 734
ok 735
ok 736
ok 737
ok 738
ok 739
ok 740
ok 741
ok 742
ok 743
ok 744
ok 745
ok 746
ok 747
ok 748
ok 749
ok 750
ok 751
ok 752
ok 753
ok 754
ok 755
ok 756
ok 757
ok 758
ok 759
ok 760
ok 761
ok 762
ok 763
ok 764
ok 765
ok 766
ok 767
ok 768
ok 769
ok 770
ok 771
ok 772
ok 773
ok 774
ok 775
ok 776
ok 777
ok 778
ok 779
ok 780
ok 781
ok 782
ok 783
ok 784
ok 785
ok 786
ok 787
ok 788
ok 789
ok 790
ok 791
ok 792
ok 793
ok 794
ok 795
ok 796
ok 797
ok 798
ok 799
ok 800
ok 801
ok 802
ok 803
ok 804
ok 805
ok 806
ok 807
ok 808
ok 809
ok 810
ok 811
ok 812
ok 813
ok 814
ok 815
ok 816
ok 817
ok 818
ok 819
ok 820
ok 821
ok 822
ok 823
ok 824
ok 825
ok 826
ok 827
ok 828
ok 829
ok 830
ok 831
ok 832
ok 833
ok 834
ok 835
ok 836
ok 837
ok 838
ok 839
ok 840
ok 841
ok 842
ok 843
ok 844
ok 845
ok 846
ok 847
ok 848
ok 849
ok 850
ok 851
ok 852
ok 853
ok 854
ok 855
ok 856
ok 857
ok 858
ok 859
ok 860
ok 861
ok 862
ok 863
ok 864
ok 865
ok 866
ok 867
ok 868
ok 869
ok 870
ok 871
ok 872
ok 873
ok 874
ok 875
ok 876
ok 877
ok 878
ok 879
ok 880
ok 881
ok 882
ok 883
ok 884
ok 885
ok 886
ok 887
ok 888
ok 889
ok 890
ok 891
ok 892
ok 893
ok 894
ok 895
ok 896
ok 897
ok 898
ok 899
ok 900
ok 901
ok 902
ok 903
ok 904
ok 905
ok 906
ok 907
ok 908
ok 909
ok 910
ok 911
ok 912
ok 913
ok 914
ok 915
ok 916
ok 917
ok 918
ok 919
ok 920
ok 921
ok 922
ok 923
ok 924
ok 925
ok 926
ok 927
ok 928
ok 929
ok 930
ok 931
ok 932
ok 933
ok 934
ok 935
ok 936
ok 937
ok 938
ok 939
ok 940
ok 941
ok 942
ok 943
ok 944
ok 945
ok 946
ok 947
ok 948
ok 949
ok 950
ok 951
ok 952
ok 953
ok 954
ok 955
ok 956
ok 957
ok 958
ok 959
ok 960
ok 961
ok 962
ok 963
ok 964
ok 965
ok 966
ok 967
ok 968
ok 969
ok 970
ok 971
ok 972
ok 973
ok 974
ok 975
ok 976
ok 977
ok 978
ok 979
ok 980
ok 981
ok 982
ok 983
ok 984
ok 985
ok 986
ok 987
ok 988
ok 989
ok 990
ok 991
ok 992
ok 993
ok 994
ok 995
ok 996
ok 997
ok 998
ok 999
ok 1000
ok 1001
ok 1002
ok 1003
ok 1004
ok 1005
ok 1006
ok 1007
ok 1008
ok 1009
ok 1010
ok 1011
ok 1012
ok 1013
ok 1014
ok 1015
ok 1016
ok 1017
ok 1018
ok 1019
ok 1020
ok 1021
ok 1022
ok 1023
ok 1024
ok 1025
ok 1026
ok 1027
ok 1028
ok 1029
ok 1030
ok 1031
ok 1032
ok 1033
ok 1034
ok 1035
ok 1036
ok 1037
ok 1038
ok 1039
ok 1040
ok 1041
ok 1042
ok 1043
ok 1044
ok 1045
ok 1046
ok 1047
ok 1048
ok 1049
ok 1050
ok 1051
ok 1052
ok 1053
ok 1054
ok 1055
ok 1056
ok 1057
ok 1058
ok 1059
ok 1060
ok 1061
ok 1062
ok 1063
ok 1064
ok 1065
ok 1066
ok 1067
ok 1068
ok 1069
ok 1070
ok 1071
ok 1072
ok 1073
ok 1074
ok 1075
ok 1076
ok 1077
ok 1078
ok 1079
ok 1080
ok 1081
ok 1082
ok 1083
ok 1084
ok 1085
ok 1086
ok 1087
ok 1088
ok 1089
ok 1090
ok 1091
ok 1092
ok 1093
ok 1094
ok 1095
ok 1096
ok 1097
ok 1098
ok 1099
ok 1100
ok 1101
ok 1102
ok 1103
ok 1104
ok 1105
ok 1106
ok 1107
ok 1108
ok 1109
ok 1110
ok 1111
ok 1112
ok 1113
ok 1114
ok 1115
ok 1116
ok 1117
ok 1118
ok 1119
ok 1120
ok 1121
ok 1122
ok 1123
ok 1124
ok 1125
ok 1126
ok 1127
ok 1128
ok 1129
ok 1130
ok 1131
ok 1132
ok 1133
ok 1134
ok 1135
ok 1136
ok 1137
ok 1138
ok 1139
ok 1140
ok 1141
ok 1142
ok 1143
ok 1144
ok 1145
ok 1146
ok 1147
ok 1148
ok 1149
ok 1150
ok 1151
ok 1152
ok 1153
ok 1154
ok 1155
ok 1156
ok 1157
ok 1158
ok 1159
ok 1160
ok 1161
ok 1162
ok 1163
ok 1164
ok 1165
ok 1166
ok 1167
ok 1168
ok 1169
ok 1170
ok 1171
ok 1172
ok 1173
ok 1174
ok 1175
ok 1176
ok 1177
ok 1178
ok 1179
ok 1180
ok 1181
ok 1182
ok 1183
ok 1184
ok 1185
ok 1186
ok 1187
ok 1188
ok 1189
ok 1190
ok 1191
ok 1192
ok 1193
ok 1194
ok 1195
ok 1196
ok 1197
ok 1198
ok 1199
ok 1200
ok 1201
ok 1202
ok 1203
ok 1204
ok 1205
ok 1206
ok 1207
ok 1208
ok 1209
ok 1210
ok 1211
ok 1212
ok 1213
ok 1214
ok 1215
ok 1216
ok 1217
ok 1218
ok 1219
ok 1220
ok 1221
ok 1222
ok 1223
ok 1224
ok 1225
ok 1226
ok 1227
ok 1228
ok 1229
ok 1230
ok 1231
ok 1232
ok 1233
ok 1234
ok 1235
ok 1236
ok 1237
ok 1238
ok 1239
ok 1240
ok 1241
ok 1242
ok 1243
ok 1244
ok 1245
ok 1246
ok 1247
ok 1248
ok 1249
ok 1250
ok 1251
ok 1252
ok 1253
ok 1254
ok 1255
ok 1256
ok 1257
ok 1258
ok 1259
ok 1260
ok 1261
ok 1262
ok 1263
ok 1264
ok 1265
ok 1266
ok 1267
ok 1268
ok 1269
ok 1270
ok 1271
ok 1272
ok 1273
ok 1274
ok 1275
ok 1276
ok 1277
ok 1278
ok 1279
ok 1280
ok 1281
ok 1282
ok 1283
ok 1284
ok 1285
ok 1286
ok 1287
ok 1288
ok 1289
ok 1290
ok 1291
ok 1292
ok 1293
ok 1294
ok 1295
ok 1296
ok 1297
ok 1298
ok 1299
ok 1300
ok 1301
ok 1302
ok 1303
ok 1304
ok 1305
ok 1306
ok 1307
ok 1308
ok 1309
ok 1310
ok 1311
ok 1312
ok 1313
ok 1314
ok 1315
ok 1316
ok 1317
ok 1318
ok 1319
ok 1320
ok 1321
ok 1322
ok 1323
ok 1324
ok 1325
ok 1326
ok 1327
ok 1328
ok 1329
ok 1330
ok 1331
ok 1332
ok 1333
ok 1334
ok 1335
ok 1336
ok 1337
ok 1338
ok 1339
ok 1340
ok 1341
ok 1342
ok 1343
ok 1344
ok 1345
ok 1346
ok 1347
ok 1348
ok 1349
ok 1350
ok 1351
ok 1352
ok 1353
ok 1354
ok 1355
ok 1356
ok 1357
ok 1358
ok 1359
ok 1360
ok 1361
ok 1362
ok 1363
ok 1364
ok 1365
ok 1366
ok 1367
ok 1368
ok 1369
ok 1370
ok 1371
ok 1372
ok 1373
ok 1374
ok 1375
ok 1376
ok 1377
ok 1378
ok 1379
ok 1380
ok 1381
ok 1382
ok 1383
ok 1384
ok 1385
ok 1386
ok 1387
ok 1388
ok 1389
ok 1390
ok 1391
ok 1392
ok 1393
ok 1394
ok 1395
ok 1396
ok 1397
ok 1398
ok 1399
ok 1400
ok 1401
ok 1402
ok 1403
ok 1404
ok 1405
ok 1406
ok 1407
ok 1408
ok 1409
ok 1410
ok 1411
ok 1412
ok 1413
ok 1414
ok 1415
ok 1416
ok 1417
ok 1418
ok 1419
ok 1420
ok 1421
ok 1422
ok 1423
ok 1424
ok 1425
ok 1426
ok 1427
ok 1428
ok 1429
ok 1430
ok 1431
ok 1432
ok 1433
ok 1434
ok 1435
ok 1436
ok 1437
ok 1438
ok 1439
ok 1440
ok 1441
ok 1442
ok 1443
ok 1444
ok 1445
ok 1446
ok 1447
ok 1448
ok 1449
ok 1450
ok 1451
ok 1452
ok 1453
ok 1454
ok 1455
ok 1456
ok 1457
ok 1458
ok 1459
ok 1460
ok 1461
ok 1462
ok 1463
ok 1464
ok 1465
ok 1466
ok 1467
ok 1468
ok 1469
ok 1470
ok 1471
ok 1472
ok 1473
ok 1474
ok 1475
ok 1476
ok 1477
ok 1478
ok 1479
ok 1480
ok 1481
ok 1482
ok 1483
ok 1484
ok 1485
ok 1486
ok 1487
ok 1488
ok 1489
ok 1490
ok 1491
ok 1492
ok 1493
ok 1494
ok 1495
ok 1496
ok 1497
ok 1498
ok 1499
ok 1500
ok 1501
ok 1502
ok 1503
ok 1504
ok 1505
ok 1506
ok 1507
ok 1508
ok 1509
ok 1510
ok 1511
ok 1512
ok 1513
ok 1514
ok 1515
ok 1516
ok 1517
ok 1518
ok 1519
ok 1520
ok 1521
ok 1522
ok 1523
ok 1524
ok 1525
ok 1526
ok 1527
ok 1528
ok 1529
ok 1530
ok 1531
ok 1532
ok 1533
ok 1534
ok 1535
ok 1536
ok 1537
ok 1538
ok 1539
ok 1540
ok 1541
ok 1542
ok 1543
ok 1544
ok 1545
ok 1546
ok 1547
ok 1548
ok 1549
ok 1550
ok 1551
ok 1552
ok 1553
ok 1554
ok 1555
ok 1556
ok 1557
ok 1558
ok 1559
ok 1560
ok 1561
ok 1562
ok 1563
ok 1564
ok 1565
ok 1566
ok 1567
ok 1568
ok 1569
ok 1570
ok 1571
ok 1572
ok 1573
ok 1574
ok 1575
ok 1576
ok 1577
ok 1578
ok 1579
ok 1580
ok 1581
ok 1582
ok 1583
ok 1584
ok 1585
ok 1586
ok 1587
ok 1588
ok 1589
ok 1590
ok 1591
ok 1592
ok 1593
ok 1594
ok 1595
ok 1596
ok 1597
ok 1598
ok 1599
ok 1600
ok 1601
ok 1602
ok 1603
ok 1604
ok 1605
ok 1606
ok 1607
ok 1608
ok 1609
ok 1610
ok 1611
ok 1612
ok 1613
ok 1614
ok 1615
ok 1616
ok 1617
ok 1618
ok 1619
ok 1620
ok 1621
ok 1622
ok 1623
ok 1624
ok 1625
ok 1626
ok 1627
ok 1628
ok 1629
ok 1630
ok 1631
ok 1632
ok 1633
ok 1634
ok 1635
ok 1636
ok 1637
ok 1638
ok 1639
ok 1640
ok 1641
ok 1642
ok 1643
ok 1644
ok 1645
ok 1646
ok 1647
ok 1648
ok 1649
ok 1650
ok 1651
ok 1652
ok 1653
ok 1654
ok 1655
ok 1656
ok 1657
ok 1658
ok 1659
ok 1660
ok 1661
ok 1662
ok 1663
ok 1664
ok 1665
ok 1666
ok 1667
ok 1668
ok 1669
ok 1670
ok 1671
ok 1672
ok 1673
ok 1674
ok 1675
ok 1676
ok 1677
ok 1678
ok 1679
ok 1680
ok 1681
ok 1682
ok 1683
ok 1684
ok 1685
ok 1686
ok 1687
ok 1688
ok 1689
ok 1690
ok 1691
ok 1692
ok 1693
ok 1694
ok 1695
ok 1696
ok 1697
ok 1698
ok 1699
ok 1700
ok 1701
ok 1702
ok 1703
ok 1704
ok 1705
ok 1706
ok 1707
ok 1708
ok 1709
ok 1710
ok 1711
ok 1712
ok 1713
ok 1714
ok 1715
ok 1716
ok 1717
ok 1718
ok 1719
ok 1720
ok 1721
ok 1722
ok 1723
ok 1724
ok 1725
ok 1726
ok 1727
ok 1728
ok 1729
ok 1730
ok 1731
ok 1732
ok 1733
ok 1734
ok 1735
ok 1736
ok 1737
ok 1738
ok 1739
ok 1740
ok 1741
ok 1742
ok 1743
ok 1744
ok 1745
ok 1746
ok 1747
ok 1748
ok 1749
ok 1750
ok 1751
ok 1752
ok 1753
ok 1754
ok 1755
ok 1756
ok 1757
ok 1758
ok 1759
ok 1760
ok 1761
ok 1762
ok 1763
ok 1764
ok 1765
ok 1766
ok 1767
ok 1768
ok 1769
ok 1770
ok 1771
ok 1772
ok 1773
ok 1774
ok 1775
ok 1776
ok 1777
ok 1778
ok 1779
ok 1780
ok 1781
ok 1782
ok 1783
ok 1784
ok 1785
ok 1786
ok 1787
ok 1788
ok 1789
ok 1790
ok 1791
ok 1792
ok 1793
ok 1794
ok 1795
ok 1796
ok 1797
ok 1798
ok 1799
ok 1800
ok 1801
ok 1802
ok 1803
ok 1804
ok 1805
ok 1806
ok 1807
ok 1808
ok 1809
ok 1810
ok 1811
ok 1812
ok 1813
ok 1814
ok 1815
ok 1816
ok 1817
ok 1818
ok 1819
ok 1820
ok 1821
ok 1822
ok 1823
ok 1824
ok 1825
ok 1826
ok 1827
ok 1828
ok 1829
ok 1830
ok 1831
ok 1832
ok 1833
ok 1834
ok 1835
ok 1836
ok 1837
ok 1838
ok 1839
ok 1840
ok 1841
ok 1842
ok 1843
ok 1844
ok 1845
ok 1846
ok 1847
ok 1848
ok 1849
ok 1850
ok 1851
ok 1852
ok 1853
ok 1854
ok 1855
ok 1856
ok 1857
ok 1858
ok 1859
ok 1860
ok 1861
ok 1862
ok 1863
ok 1864
ok 1865
ok 1866
ok 1867
ok 1868
ok 1869
ok 1870
ok 1871
ok 1872
ok 1873
ok 1874
ok 1875
ok 1876
ok 1877
ok 1878
ok 1879
ok 1880
ok 1881
ok 1882
ok 1883
ok 1884
ok 1885
ok 1886
ok 1887
ok 1888
ok 1889
ok 1890
ok 1891
ok 1892
ok 1893
ok 1894
ok 1895
ok 1896
ok 1897
ok 1898
ok 1899
ok 1900
ok 1901
ok 1902
ok 1903
ok 1904
ok 1905
ok 1906
ok 1907
ok 1908
ok 1909
ok 1910
ok 1911
ok 1912
ok 1913
ok 1914
ok 1915
ok 1916
ok 1917
ok 1918
ok 1919
ok 1920
ok 1921
ok 1922
ok 1923
ok 1924
ok 1925
ok 1926
ok 1927
ok 1928
ok 1929
ok 1930
ok 1931
ok 1932
ok 1933
ok 1934
ok 1935
ok 1936
ok 1937
ok 1938
ok 1939
ok 1940
ok 1941
ok 1942
ok 1943
ok 1944
ok 1945
ok 1946
ok 1947
ok 1948
ok 1949
ok 1950
ok 1951
ok 1952
ok 1953
ok 1954
ok 1955
ok 1956
ok 1957
ok 1958
ok 1959
ok 1960
ok 1961
ok 1962
ok 1963
ok 1964
ok 1965
ok 1966
ok 1967
ok 1968
ok 1969
ok 1970
ok 1971
ok 1972
ok 1973
ok 1974
ok 1975
ok 1976
ok 1977
ok 1978
ok 1979
ok 1980
ok 1981
ok 1982
ok 1983
ok 1984
ok 1985
ok 1986
ok 1987
ok 1988
ok 1989
ok 1990
ok 1991
ok 1992
ok 1993
ok 1994
ok 1995
ok 1996
ok 1997
ok 1998
ok 1999
ok 2000
ok 2001
ok 2002
ok 2003
ok 2004
ok 2005
ok 2006
ok 2007
ok 2008
ok 2009
ok 2010
ok 2011
ok 2012
ok 2013
ok 2014
ok 2015
ok 2016
ok 2017
ok 2018
ok 2019
ok 2020
ok 2021
ok 2022
ok 2023
ok 2024
ok 2025
ok 2026
ok 2027
ok 2028
ok 2029
ok 2030
ok 2031
ok 2032
ok 2033
ok 2034
ok 2035
ok 2036
ok 2037
ok 2038
ok 2039
ok 2040
ok 2041
ok 2042
ok 2043
ok 2044
ok 2045
ok 2046
ok 2047
ok 2048
ok 2049
ok 2050
ok 2051
ok 2052
ok 2053
ok 2054
ok 2055
ok 2056
ok 2057
ok 2058
ok 2059
ok 2060
ok 2061
ok 2062
ok 2063
ok 2064
ok 2065
ok 2066
ok 2067
ok 2068
ok 2069
ok 2070
ok 2071
ok 2072
ok 2073
ok 2074
ok 2075
ok 2076
ok 2077
ok 2078
ok 2079
ok 2080
ok 2081
ok 2082
ok 2083
ok 2084
ok 2085
ok 2086
ok 2087
ok 2088
ok 2089
ok 2090
ok 2091
ok 2092
ok 2093
ok 2094
ok 2095
ok 2096
ok 2097
ok 2098
ok 2099
ok 2100
ok 2101
ok 2102
ok 2103
ok 2104
ok 2105
ok 2106
ok 2107
ok 2108
ok 2109
ok 2110
ok 2111
ok 2112
ok 2113
ok 2114
ok 2115
ok 2116
ok 2117
ok 2118
ok 2119
ok 2120
ok 2121
ok 2122
ok 2123
ok 2124
ok 2125
ok 2126
ok 2127
ok 2128
ok 2129
ok 2130
ok 2131
ok 2132
ok 2133
ok 2134
ok 2135
ok 2136
ok 2137
ok 2138
ok 2139
ok 2140
ok 2141
ok 2142
ok 2143
ok 2144
ok 2145
ok 2146
ok 2147
ok 2148
ok 2149
ok 2150
ok 2151
ok 2152
ok 2153
ok 2154
ok 2155
ok 2156
ok 2157
ok 2158
ok 2159
ok 2160
ok 2161
ok 2162
ok 2163
ok 2164
ok 2165
ok 2166
ok 2167
ok 2168
ok 2169
ok 2170
ok 2171
ok 2172
ok 2173
ok 2174
ok 2175
ok 2176
ok 2177
ok 2178
ok 2179
ok 2180
ok 2181
ok 2182
ok 2183
ok 2184
ok 2185
ok 2186
ok 2187
ok 2188
ok 2189
ok 2190
ok 2191
ok 2192
ok 2193
ok 2194
ok 2195
ok 2196
ok 2197
ok 2198
ok 2199
ok 2200
ok 2201
ok 2202
ok 2203
ok 2204
ok 2205
ok 2206
ok 2207
ok 2208
ok 2209
ok 2210
ok 2211
ok 2212
ok 2213
ok 2214
ok 2215
ok 2216
ok 2217
ok 2218
ok 2219
ok 2220
ok 2221
ok 2222
ok 2223
ok 2224
ok 2225
ok 2226
ok 2227
ok 2228
ok 2229
ok 2230
ok 2231
ok 2232
ok 2233
ok 2234
ok 2235
ok 2236
ok 2237
ok 2238
ok 2239
ok 2240
ok 2241
ok 2242
ok 2243
ok 2244
ok 2245
ok 2246
ok 2247
ok 2248
ok 2249
ok 2250
ok 2251
ok 2252
ok 2253
ok 2254
ok 2255
ok 2256
ok 2257
ok 2258
ok 2259
ok 2260
ok 2261
ok 2262
ok 2263
ok 2264
ok 2265
ok 2266
ok 2267
ok 2268
ok 2269
ok 2270
ok 2271
ok 2272
ok 2273
ok 2274
ok 2275
ok 2276
ok 2277
ok 2278
ok 2279
ok 2280
ok 2281
ok 2282
ok 2283
ok 2284
ok 2285
ok 2286
ok 2287
ok 2288
ok 2289
ok 2290
ok 2291
ok 2292
ok 2293
ok 2294
ok 2295
ok 2296
ok 2297
ok 2298
ok 2299
ok 2300
ok 2301
ok 2302
ok 2303
ok 2304
ok 2305
ok 2306
ok 2307
ok 2308
ok 2309
ok 2310
ok 2311
ok 2312
ok 2313
ok 2314
ok 2315
ok 2316
ok 2317
ok 2318
ok 2319
ok 2320
ok 2321
ok 2322
ok 2323
ok 2324
ok 2325
ok 2326
ok 2327
ok 2328
ok 2329
ok 2330
ok 2331
ok 2332
ok 2333
ok 2334
ok 2335
ok 2336
ok 2337
ok 2338
ok 2339
ok 2340
ok 2341
ok 2342
ok 2343
ok 2344
ok 2345
ok 2346
ok 2347
ok 2348
ok 2349
ok 2350
ok 2351
ok 2352
ok 2353
ok 2354
ok 2355
ok 2356
ok 2357
ok 2358
ok 2359
ok 2360
ok 2361
ok 2362
ok 2363
ok 2364
ok 2365
ok 2366
ok 2367
ok 2368
ok 2369
ok 2370
ok 2371
ok 2372
ok 2373
ok 2374
ok 2375
ok 2376
ok 2377
ok 2378
ok 2379
ok 2380
ok 2381
ok 2382
ok 2383
ok 2384
ok 2385
ok 2386
ok 2387
ok 2388
ok 2389
ok 2390
ok 2391
ok 2392
ok 2393
ok 2394
ok 2395
ok 2396
ok 2397
ok 2398
ok 2399
ok 2400
ok 2401
ok 2402
ok 2403
ok 2404
ok 2405
ok 2406
ok 2407
ok 2408
ok 2409
ok 2410
ok 2411
ok 2412
ok 2413
ok 2414
ok 2415
ok 2416
ok 2417
ok 2418
ok 2419
ok 2420
ok 2421
ok 2422
ok 2423
ok 2424
ok 2425
ok 2426
ok 2427
ok 2428
ok 2429
ok 2430
ok 2431
ok 2432
ok 2433
ok 2434
ok 2435
ok 2436
ok 2437
ok 2438
ok 2439
ok 2440
ok 2441
ok 2442
ok 2443
ok 2444
ok 2445
ok 2446
ok 2447
ok 2448
ok 2449
ok 2450
ok 2451
ok 2452
ok 2453
ok 2454
ok 2455
ok 2456
ok 2457
ok 2458
ok 2459
ok 2460
ok 2461
ok 2462
ok 2463
ok 2464
ok 2465
ok 2466
ok 2467
ok 2468
ok 2469
ok 2470
ok 2471
ok 2472
ok 2473
ok 2474
ok 2475
ok 2476
ok 2477
ok 2478
ok 2479
ok 2480
ok 2481
ok 2482
ok 2483
ok 2484
ok 2485
ok 2486
ok 2487
ok 2488
ok 2489
ok 2490
ok 2491
ok 2492
ok 2493
ok 2494
ok 2495
ok 2496
ok 2497
ok 2498
ok 2499
ok 2500
ok 2501
ok 2502
ok 2503
ok 2504
ok 2505
ok 2506
ok 2507
ok 2508
ok 2509
ok 2510
ok 2511
ok 2512
ok 2513
ok 2514
ok 2515
ok 2516
ok 2517
ok 2518
ok 2519
ok 2520
ok 2521
ok 2522
ok 2523
ok 2524
ok 2525
ok 2526
ok 2527
ok 2528
ok 2529
ok 2530
ok 2531
ok 2532
ok 2533
ok 2534
ok 2535
ok 2536
ok 2537
ok 2538
ok 2539
ok 2540
ok 2541
ok 2542
ok 2543
ok 2544
ok 2545
ok 2546
ok 2547
ok 2548
ok 2549
ok 2550
ok 2551
ok 2552
ok 2553
ok 2554
ok 2555
ok 2556
ok 2557
ok 2558
ok 2559
ok 2560
ok 2561
ok 2562
ok 2563
ok 2564
ok 2565
ok 2566
ok 2567
ok 2568
ok 2569
ok 2570
ok 2571
ok 2572
ok 2573
ok 2574
ok 2575
ok 2576
ok 2577
ok 2578
ok 2579
ok 2580
ok 2581
ok 2582
ok 2583
ok 2584
ok 2585
ok 2586
ok 2587
ok 2588
ok 2589
ok 2590
ok 2591
ok 2592
ok 2593
ok 2594
ok 2595
ok 2596
ok 2597
ok 2598
ok 2599
ok 2600
ok 2601
ok 2602
ok 2603
ok 2604
ok 2605
ok 2606
ok 2607
ok 2608
ok 2609
ok 2610
ok 2611
ok 2612
ok 2613
ok 2614
ok 2615
ok 2616
ok 2617
ok 2618
ok 2619
ok 2620
ok 2621
ok 2622
ok 2623
ok 2624
ok 2625
ok 2626
ok 2627
ok 2628
ok 2629
ok 2630
ok 2631
ok 2632
ok 2633
ok 2634
ok 2635
ok 2636
ok 2637
ok 2638
ok 2639
ok 2640
ok 2641
ok 2642
ok 2643
ok 2644
ok 2645
ok 2646
ok 2647
ok 2648
ok 2649
ok 2650
ok 2651
ok 2652
ok 2653
ok 2654
ok 2655
ok 2656
ok 2657
ok 2658
ok 2659
ok 2660
ok 2661
ok 2662
ok 2663
ok 2664
ok 2665
ok 2666
ok 2667
ok 2668
ok 2669
ok 2670
ok 2671
ok 2672
ok 2673
ok 2674
ok 2675
ok 2676
ok 2677
ok 2678
ok 2679
ok 2680
ok 2681
ok 2682
ok 2683
ok 2684
ok 2685
ok 2686
ok 2687
ok 2688
ok 2689
ok 2690
ok 2691
ok 2692
ok 2693
ok 2694
ok 2695
ok 2696
ok 2697
ok 2698
ok 2699
ok 2700
ok 2701
ok 2702
ok 2703
ok 2704
ok 2705
ok 2706
ok 2707
ok 2708
ok 2709
ok 2710
ok 2711
ok 2712
ok 2713
ok 2714
ok 2715
ok 2716
ok 2717
ok 2718
ok 2719
ok 2720
ok 2721
ok 2722
ok 2723
ok 2724
ok 2725
ok 2726
ok 2727
ok 2728
ok 2729
ok 2730
ok 2731
ok 2732
ok 2733
ok 2734
ok 2735
ok 2736
ok 2737
ok 2738
ok 2739
ok 2740
ok 2741
ok 2742
ok 2743
ok 2744
ok 2745
ok 2746
ok 2747
ok 2748
ok 2749
ok 2750
ok 2751
ok 2752
ok 2753
ok 2754
ok 2755
ok 2756
ok 2757
ok 2758
ok 2759
ok 2760
ok 2761
ok 2762
ok 2763
ok 2764
ok 2765
ok 2766
ok 2767
ok 2768
ok 2769
ok 2770
ok 2771
ok 2772
ok 2773
ok 2774
ok 2775
ok 2776
ok 2777
ok 2778
ok 2779
ok 2780
ok 2781
ok 2782
ok 2783
ok 2784
ok 2785
ok 2786
ok 2787
ok 2788
ok 2789
ok 2790
ok 2791
ok 2792
ok 2793
ok 2794
ok 2795
ok 2796
ok 2797
ok 2798
ok 2799
ok 2800
ok 2801
ok 2802
ok 2803
ok 2804
ok 2805
ok 2806
ok 2807
ok 2808
ok 2809
ok 2810
ok 2811
ok 2812
ok 2813
ok 2814
ok 2815
ok 2816
ok 2817
ok 2818
ok 2819
ok 2820
ok 2821
ok 2822
ok 2823
ok 2824
ok 2825
ok 2826
ok 2827
ok 2828
ok 2829
ok 2830
ok 2831
ok 2832
ok 2833
ok 2834
ok 2835
ok 2836
ok 2837
ok 2838
ok 2839
ok 2840
ok 2841
ok 2842
ok 2843
ok 2844
ok 2845
ok 2846
ok 2847
ok 2848
ok 2849
ok 2850
ok 2851
ok 2852
ok 2853
ok 2854
ok 2855
ok 2856
ok 2857
ok 2858
ok 2859
ok 2860
ok 2861
ok 2862
ok 2863
ok 2864
ok 2865
ok 2866
ok 2867
ok 2868
ok 2869
ok 2870
ok 2871
ok 2872
ok 2873
ok 2874
ok 2875
ok 2876
ok 2877
ok 2878
ok 2879
ok 2880
ok 2881
ok 2882
ok 2883
ok 2884
ok 2885
ok 2886
ok 2887
ok 2888
ok 2889
ok 2890
ok 2891
ok 2892
ok 2893
ok 2894
ok 2895
ok 2896
ok 2897
ok 2898
ok 2899
ok 2900
ok 2901
ok 2902
ok 2903
ok 2904
ok 2905
ok 2906
ok 2907
ok 2908
ok 2909
ok 2910
ok 2911
ok 2912
ok 2913
ok 2914
ok 2915
ok 2916
ok 2917
ok 2918
ok 2919
ok 2920
ok 2921
ok 2922
ok 2923
ok 2924
ok 2925
ok 2926
ok 2927
ok 2928
ok 2929
ok 2930
ok 2931
ok 2932
ok 2933
ok 2934
ok 2935
ok 2936
ok 2937
ok 2938
ok 2939
ok 2940
ok 2941
ok 2942
ok 2943
ok 2944
ok 2945
ok 2946
ok 2947
ok 2948
ok 2949
ok 2950
ok 2951
ok 2952
ok 2953
ok 2954
ok 2955
ok 2956
ok 2957
ok 2958
ok 2959
ok 2960
ok 2961
ok 2962
ok 2963
ok 2964
ok 2965
ok 2966
ok 2967
ok 2968
ok 2969
ok 2970
ok 2971
ok 2972
ok 2973
ok 2974
ok 2975
ok 2976
ok 2977
ok 2978
ok 2979
ok 2980
ok 2981
ok 2982
ok 2983
ok 2984
ok 2985
ok 2986
ok 2987
ok 2988
ok 2989
ok 2990
ok 2991
ok 2992
ok 2993
ok 2994
ok 2995
ok 2996
ok 2997
ok 2998
ok 2999
ok 3000
ok 3001
ok 3002
ok 3003
ok 3004
ok 3005
ok 3006
ok 3007
ok 3008
ok 3009
ok 3010
ok 3011
ok 3012
ok 3013
ok 3014
ok 3015
ok 3016
ok 3017
ok 3018
ok 3019
ok 3020
ok 3021
ok 3022
ok 3023
ok 3024
ok 3025
ok 3026
ok 3027
ok 3028
ok 3029
ok 3030
ok 3031
ok 3032
ok 3033
ok 3034
ok 3035
ok 3036
ok 3037
ok 3038
ok 3039
ok 3040
ok 3041
ok 3042
ok 3043
ok 3044
ok 3045
ok 3046
ok 3047
ok 3048
ok 3049
ok 3050
ok 3051
ok 3052
ok 3053
ok 3054
ok 3055
ok 3056
ok 3057
ok 3058
ok 3059
ok 3060
ok 3061
ok 3062
ok 3063
ok 3064
ok 3065
ok 3066
ok 3067
ok 3068
ok 3069
ok 3070
ok 3071
ok 3072
ok 3073
ok 3074
ok 3075
ok 3076
ok 3077
ok 3078
ok 3079
ok 3080
ok 3081
ok 3082
ok 3083
ok 3084
ok 3085
ok 3086
ok 3087
ok 3088
ok 3089
ok 3090
ok 3091
ok 3092
ok 3093
ok 3094
ok 3095
ok 3096
ok 3097
ok 3098
ok 3099
ok 3100
ok 3101
ok 3102
ok 3103
ok 3104
ok 3105
ok 3106
ok 3107
ok 3108
ok 3109
ok 3110
ok 3111
ok 3112
ok 3113
ok 3114
ok 3115
ok 3116
ok 3117
ok 3118
ok 3119
ok 3120
ok 3121
ok 3122
ok 3123
ok 3124
ok 3125
ok 3126
ok 3127
ok 3128
ok 3129
ok 3130
ok 3131
ok 3132
ok 3133
ok 3134
ok 3135
ok 3136
ok 3137
ok 3138
ok 3139
ok 3140
ok 3141
ok 3142
ok 3143
ok 3144
ok 3145
ok 3146
ok 3147
ok 3148
ok 3149
ok 3150
ok 3151
ok 3152
ok 3153
ok 3154
ok 3155
ok 3156
ok 3157
ok 3158
ok 3159
ok 3160
ok 3161
ok 3162
ok 3163
ok 3164
ok 3165
ok 3166
ok 3167
ok 3168
ok 3169
ok 3170
ok 3171
ok 3172
ok 3173
ok 3174
ok 3175
ok 3176
ok 3177
ok 3178
ok 3179
ok 3180
ok 3181
ok 3182
ok 3183
ok 3184
ok 3185
ok 3186
ok 3187
ok 3188
ok 3189
ok 3190
ok 3191
ok 3192
ok 3193
ok 3194
ok 3195
ok 3196
ok 3197
ok 3198
ok 3199
ok 3200
ok 3201
ok 3202
ok 3203
ok 3204
ok 3205
ok 3206
ok 3207
ok 3208
ok 3209
ok 3210
ok 3211
ok 3212
ok 3213
ok 3214
ok 3215
ok 3216
ok 3217
ok 3218
ok 3219
ok 3220
ok 3221
ok 3222
ok 3223
ok 3224
ok 3225
ok 3226
ok 3227
ok 3228
ok 3229
ok 3230
ok 3231
ok 3232
ok 3233
ok 3234
ok 3235
ok 3236
ok 3237
ok 3238
ok 3239
ok 3240
ok 3241
ok 3242
ok 3243
ok 3244
ok 3245
ok 3246
ok 3247
ok 3248
ok 3249
ok 3250
ok 3251
ok 3252
ok 3253
ok 3254
ok 3255
ok 3256
ok 3257
ok 3258
ok 3259
ok 3260
ok 3261
ok 3262
ok 3263
ok 3264
ok 3265
ok 3266
ok 3267
ok 3268
ok 3269
ok 3270
ok 3271
ok 3272
ok 3273
ok 3274
ok 3275
ok 3276
ok 3277
ok 3278
ok 3279
ok 3280
ok 3281
ok 3282
ok 3283
ok 3284
ok 3285
ok 3286
ok 3287
ok 3288
ok 3289
ok 3290
ok 3291
ok 3292
ok 3293
ok 3294
ok 3295
ok 3296
ok 3297
ok 3298
ok 3299
ok 3300
ok 3301
ok 3302
ok 3303
ok 3304
ok 3305
ok 3306
ok 3307
ok 3308
ok 3309
ok 3310
ok 3311
ok 3312
ok 3313
ok 3314
ok 3315
ok 3316
ok 3317
ok 3318
ok 3319
ok 3320
ok 3321
ok 3322
ok 3323
ok 3324
ok 3325
ok 3326
ok 3327
ok 3328
ok 3329
ok 3330
ok 3331
ok 3332
ok 3333
ok 3334
ok 3335
ok 3336
ok 3337
ok 3338
ok 3339
ok 3340
ok 3341
ok 3342
ok 3343
ok 3344
ok 3345
ok 3346
ok 3347
ok 3348
ok 3349
ok 3350
ok 3351
ok 3352
ok 3353
ok 3354
ok 3355
ok 3356
ok 3357
ok 3358
ok 3359
ok 3360
ok 3361
ok 3362
ok 3363
ok 3364
ok 3365
ok 3366
ok 3367
ok 3368
ok 3369
ok 3370
ok 3371
ok 3372
ok 3373
ok 3374
ok 3375
ok 3376
ok 3377
ok 3378
ok 3379
ok 3380
ok 3381
ok 3382
ok 3383
ok 3384
ok 3385
ok 3386
ok 3387
ok 3388
ok 3389
ok 3390
ok 3391
ok 3392
ok 3393
ok 3394
ok 3395
ok 3396
ok 3397
ok 3398
ok 3399
ok 3400
ok 3401
ok 3402
ok 3403
ok 3404
ok 3405
ok 3406
ok 3407
ok 3408
ok 3409
ok 3410
ok 3411
ok 3412
ok 3413
ok 3414
ok 3415
ok 3416
ok 3417
ok 3418
ok 3419
ok 3420
ok 3421
ok 3422
ok 3423
ok 3424
ok 3425
ok 3426
ok 3427
ok 3428
ok 3429
ok 3430
ok 3431
ok 3432
ok 3433
ok 3434
ok 3435
ok 3436
ok 3437
ok 3438
ok 3439
ok 3440
ok 3441
ok 3442
ok 3443
ok 3444
ok 3445
ok 3446
ok 3447
ok 3448
ok 3449
ok 3450
ok 3451
ok 3452
ok 3453
ok 3454
ok 3455
ok 3456
ok 3457
ok 3458
ok 3459
ok 3460
ok 3461
ok 3462
ok 3463
ok 3464
ok 3465
ok 3466
ok 3467
ok 3468
ok 3469
ok 3470
ok 3471
ok 3472
ok 3473
ok 3474
ok 3475
ok 3476
ok 3477
ok 3478
ok 3479
ok 3480
ok 3481
ok 3482
ok 3483
ok 3484
ok 3485
ok 3486
ok 3487
ok 3488
ok 3489
ok 3490
ok 3491
ok 3492
ok 3493
ok 3494
ok 3495
ok 3496
ok 3497
ok 3498
ok 3499
ok 3500
ok 3501
ok 3502
ok 3503
ok 3504
ok 3505
ok 3506
ok 3507
ok 3508
ok 3509
ok 3510
ok 3511
ok 3512
ok 3513
ok 3514
ok 3515
ok 3516
ok 3517
ok 3518
ok 3519
ok 3520
ok 3521
ok 3522
ok 3523
ok 3524
ok 3525
ok 3526
ok 3527
ok 3528
ok 3529
ok 3530
ok 3531
ok 3532
ok 3533
ok 3534
ok 3535
ok 3536
ok 3537
ok 3538
ok 3539
ok 3540
ok 3541
ok 3542
ok 3543
ok 3544
ok 3545
ok 3546
ok 3547
ok 3548
ok 3549
ok 3550
ok 3551
ok 3552
ok 3553
ok 3554
ok 3555
ok 3556
ok 3557
ok 3558
ok 3559
ok 3560
ok 3561
ok 3562
ok 3563
ok 3564
ok 3565
ok 3566
ok 3567
ok 3568
ok 3569
ok 3570
ok 3571
ok 3572
ok 3573
ok 3574
ok 3575
ok 3576
ok 3577
ok 3578
ok 3579
ok 3580
ok 3581
ok 3582
ok 3583
ok 3584
ok 3585
ok 3586
ok 3587
ok 3588
ok 3589
ok 3590
ok 3591
ok 3592
ok 3593
ok 3594
ok 3595
ok 3596
ok 3597
ok 3598
ok 3599
ok 3600
ok 3601
ok 3602
ok 3603
ok 3604
ok 3605
ok 3606
ok 3607
ok 3608
ok 3609
ok 3610
ok 3611
ok 3612
ok 3613
ok 3614
ok 3615
ok 3616
ok 3617
ok 3618
ok 3619
ok 3620
ok 3621
ok 3622
ok 3623
ok 3624
ok 3625
ok 3626
ok 3627
ok 3628
ok 3629
ok 3630
ok 3631
ok 3632
ok 3633
ok 3634
ok 3635
ok 3636
ok 3637
ok 3638
ok 3639
ok 3640
ok 3641
ok 3642
ok 3643
ok 3644
ok 3645
ok 3646
ok 3647
ok 3648
ok 3649
ok 3650
ok 3651
ok 3652
ok 3653
ok 3654
ok 3655
ok 3656
ok 3657
ok 3658
ok 3659
ok 3660
ok 3661
ok 3662
ok 3663
ok 3664
ok 3665
ok 3666
ok 3667
ok 3668
ok 3669
ok 3670
ok 3671
ok 3672
ok 3673
ok 3674
ok 3675
ok 3676
ok 3677
ok 3678
ok 3679
ok 3680
ok 3681
ok 3682
ok 3683
ok 3684
ok 3685
ok 3686
ok 3687
ok 3688
ok 3689
ok 3690
ok 3691
ok 3692
ok 3693
ok 3694
ok 3695
ok 3696
ok 3697
ok 3698
ok 3699
ok 3700
ok 3701
ok 3702
ok 3703
ok 3704
ok 3705
ok 3706
ok 3707
ok 3708
ok 3709
ok 3710
ok 3711
ok 3712
ok 3713
ok 3714
ok 3715
ok 3716
ok 3717
ok 3718
ok 3719
ok 3720
ok 3721
ok 3722
ok 3723
ok 3724
ok 3725
ok 3726
ok 3727
ok 3728
ok 3729
ok 3730
ok 3731
ok 3732
ok 3733
ok 3734
ok 3735
ok 3736
ok 3737
ok 3738
ok 3739
ok 3740
ok 3741
ok 3742
ok 3743
ok 3744
ok 3745
ok 3746
ok 3747
ok 3748
ok 3749
ok 3750
ok 3751
ok 3752
ok 3753
ok 3754
ok 3755
ok 3756
ok 3757
ok 3758
ok 3759
ok 3760
ok 3761
ok 3762
ok 3763
ok 3764
ok 3765
ok 3766
ok 3767
ok 3768
ok 3769
ok 3770
ok 3771
ok 3772
ok 3773
ok 3774
ok 3775
ok 3776
ok 3777
ok 3778
ok 3779
ok 3780
ok 3781
ok 3782
ok 3783
ok 3784
ok 3785
ok 3786
ok 3787
ok 3788
ok 3789
ok 3790
ok 3791
ok 3792
ok 3793
ok 3794
ok 3795
ok 3796
ok 3797
ok 3798
ok 3799
ok 3800
ok 3801
ok 3802
ok 3803
ok 3804
ok 3805
ok 3806
ok 3807
ok 3808
ok 3809
ok 3810
ok 3811
ok 3812
ok 3813
ok 3814
ok 3815
ok 3816
ok 3817
ok 3818
ok 3819
ok 3820
ok 3821
ok 3822
ok 3823
ok 3824
ok 3825
ok 3826
ok 3827
ok 3828
ok 3829
ok 3830
ok 3831
ok 3832
ok 3833
ok 3834
ok 3835
ok 3836
ok 3837
ok 3838
ok 3839
ok 3840
ok 3841
ok 3842
ok 3843
ok 3844
ok 3845
ok 3846
ok 3847
ok 3848
ok 3849
ok 3850
ok 3851
ok 3852
ok 3853
ok 3854
ok 3855
ok 3856
ok 3857
ok 3858
ok 3859
ok 3860
ok 3861
ok 3862
ok 3863
ok 3864
ok 3865
ok 3866
ok 3867
ok 3868
ok 3869
ok 3870
ok 3871
ok 3872
ok 3873
ok 3874
ok 3875
ok 3876
ok 3877
ok 3878
ok 3879
ok 3880
ok 3881
ok 3882
ok 3883
ok 3884
ok 3885
ok 3886
ok 3887
ok 3888
ok 3889
ok 3890
ok 3891
ok 3892
ok 3893
ok 3894
ok 3895
ok 3896
ok 3897
ok 3898
ok 3899
ok 3900
ok 3901
ok 3902
ok 3903
ok 3904
ok 3905
ok 3906
ok 3907
ok 3908
ok 3909
ok 3910
ok 3911
ok 3912
ok 3913
ok 3914
ok 3915
ok 3916
ok 3917
ok 3918
ok 3919
ok 3920
ok 3921
ok 3922
ok 3923
ok 3924
ok 3925
ok 3926
ok 3927
ok 3928
ok 3929
ok 3930
ok 3931
ok 3932
ok 3933
ok 3934
ok 3935
ok 3936
ok 3937
ok 3938
ok 3939
ok 3940
ok 3941
ok 3942
ok 3943
ok 3944
ok 3945
ok 3946
ok 3947
ok 3948
ok 3949
ok 3950
ok 3951
ok 3952
ok 3953
ok 3954
ok 3955
ok 3956
ok 3957
ok 3958
ok 3959
ok 3960
ok 3961
ok 3962
ok 3963
ok 3964
ok 3965
ok 3966
ok 3967
ok 3968
ok 3969
ok 3970
ok 3971
ok 3972
ok 3973
ok 3974
ok 3975
ok 3976
ok 3977
ok 3978
ok 3979
ok 3980
ok 3981
ok 3982
ok 3983
ok 3984
ok 3985
ok 3986
ok 3987
ok 3988
ok 3989
ok 3990
ok 3991
ok 3992
ok 3993
ok 3994
ok 3995
ok 3996
ok 3997
ok 3998
ok 3999
ok 4000
ok 4001
ok 4002
ok 4003
ok 4004
ok 4005
ok 4006
ok 4007
ok 4008
ok 4009
ok 4010
ok 4011
ok 4012
ok 4013
ok 4014
ok 4015
ok 4016
ok 4017
ok 4018
ok 4019
ok 4020
ok 4021
ok 4022
ok 4023
ok 4024
ok 4025
ok 4026
ok 4027
ok 4028
ok 4029
ok 4030
ok 4031
ok 4032
ok 4033
ok 4034
ok 4035
ok 4036
ok 4037
ok 4038
ok 4039
ok 4040
ok 4041
ok 4042
ok 4043
ok 4044
ok 4045
ok 4046
ok 4047
ok 4048
ok 4049
ok 4050
ok 4051
ok 4052
ok 4053
ok 4054
ok 4055
ok 4056
ok 4057
ok 4058
ok 4059
ok 4060
ok 4061
ok 4062
ok 4063
ok 4064
ok 4065
ok 4066
ok 4067
ok 4068
ok 4069
ok 4070
ok 4071
ok 4072
ok 4073
ok 4074
ok 4075
ok 4076
ok 4077
ok 4078
ok 4079
ok 4080
ok 4081
ok 4082
ok 4083
ok 4084
ok 4085
ok 4086
ok 4087
ok 4088
ok 4089
ok 4090
ok 4091
ok 4092
ok 4093
ok 4094
ok 4095
ok 4096
ok 4097
ok 4098
ok 4099
ok 4100
ok 4101
ok 4102
ok 4103
ok 4104
ok 4105
ok 4106
ok 4107
ok 4108
ok 4109
ok 4110
ok 4111
ok 4112
ok 4113
ok 4114
ok 4115
ok 4116
ok 4117
ok 4118
ok 4119
ok 4120
ok 4121
ok 4122
ok 4123
ok 4124
ok 4125
ok 4126
ok 4127
ok 4128
ok 4129
ok 4130
ok 4131
ok 4132
ok 4133
ok 4134
ok 4135
ok 4136
ok 4137
ok 4138
ok 4139
ok 4140
ok 4141
ok 4142
ok 4143
ok 4144
ok 4145
ok 4146
ok 4147
ok 4148
ok 4149
ok 4150
ok 4151
ok 4152
ok 4153
ok 4154
ok 4155
ok 4156
ok 4157
ok 4158
ok 4159
ok 4160
ok 4161
ok 4162
ok 4163
ok 4164
ok 4165
ok 4166
ok 4167
ok 4168
ok 4169
ok 4170
ok 4171
ok 4172
ok 4173
ok 4174
ok 4175
ok 4176
ok 4177
ok 4178
ok 4179
ok 4180
ok 4181
ok 4182
ok 4183
ok 4184
ok 4185
ok 4186
ok 4187
ok 4188
ok 4189
ok 4190
ok 4191
ok 4192
ok 4193
ok 4194
ok 4195
ok 4196
ok 4197
ok 4198
ok 4199
ok 4200
ok 4201
ok 4202
ok 4203
ok 4204
ok 4205
ok 4206
ok 4207
ok 4208
ok 4209
ok 4210
ok 4211
ok 4212
ok 4213
ok 4214
ok 4215
ok 4216
ok 4217
ok 4218
ok 4219
ok 4220
ok 4221
ok 4222
ok 4223
ok 4224
ok 4225
ok 4226
ok 4227
ok 4228
ok 4229
ok 4230
ok 4231
ok 4232
ok 4233
ok 4234
ok 4235
ok 4236
ok 4237
ok 4238
ok 4239
ok 4240
ok 4241
ok 4242
ok 4243
ok 4244
ok 4245
ok 4246
ok 4247
ok 4248
ok 4249
ok 4250
ok 4251
ok 4252
ok 4253
ok 4254
ok 4255
ok 4256
ok 4257
ok 4258
ok 4259
ok 4260
ok 4261
ok 4262
ok 4263
ok 4264
ok 4265
ok 4266
ok 4267
ok 4268
ok 4269
ok 4270
ok 4271
ok 4272
ok 4273
ok 4274
ok 4275
ok 4276
ok 4277
ok 4278
ok 4279
ok 4280
ok 4281
ok 4282
ok 4283
ok 4284
ok 4285
ok 4286
ok 4287
ok 4288
ok 4289
ok 4290
ok 4291
ok 4292
ok 4293
ok 4294
ok 4295
ok 4296
ok 4297
ok 4298
ok 4299
ok 4300
ok 4301
ok 4302
ok 4303
ok 4304
ok 4305
ok 4306
ok 4307
ok 4308
ok 4309
ok 4310
ok 4311
ok 4312
ok 4313
ok 4314
ok 4315
ok 4316
ok 4317
ok 4318
ok 4319
ok 4320
ok 4321
ok 4322
ok 4323
ok 4324
ok 4325
ok 4326
ok 4327
ok 4328
ok 4329
ok 4330
ok 4331
ok 4332
ok 4333
ok 4334
ok 4335
ok 4336
ok 4337
ok 4338
ok 4339
ok 4340
ok 4341
ok 4342
ok 4343
ok 4344
ok 4345
ok 4346
ok 4347
ok 4348
ok 4349
ok 4350
ok 4351
ok 4352
ok 4353
ok 4354
ok 4355
ok 4356
ok 4357
ok
All tests successful.
Files=20, Tests=5350, 3 wallclock secs ( 0.62 usr + 0.06 sys = 0.69 CPU)
Result: PASS
MIKER/Math-Base-Convert-0.11.tar.gz
dmake test TEST_VERBOSE=1 -- OK
Fetching with LWP:
http://ppm.activestate.com/CPAN/authors/id/M/MI/MIKER/CHECKSUMS
Picked up abstract from Convert.pm
Michael Robinton <michael@bizsystems.com>very fast base to base conversion
>>> (cd C:\cpanfly-5.24-32\var\tmp\cpan_build\Math-Base-Convert-0.11-f5_WmK && tar cvf - Math-Base-Convert-0.11.ppd blib) | gzip -c >C:/cpanfly-5.24-32/var/REPO/M/MI/MIKER/Math-Base-Convert-0.11.tar.gz
Math-Base-Convert-0.11.ppd
blib/
blib/lib/
blib/lib/Math/
blib/lib/Math/Base/
blib/lib/Math/Base/Convert/
blib/lib/Math/Base/Convert/Bases.pm
blib/lib/Math/Base/Convert/Bitmaps.pm
blib/lib/Math/Base/Convert/CalcPP.pm
blib/lib/Math/Base/Convert/Shortcuts.pm
blib/lib/Math/Base/Convert.pm
>>> mv C:\cpanfly-5.24-32\var\tmp\cpan_build\Math-Base-Convert-0.11-f5_WmK/Math-Base-Convert-0.11.ppd C:/cpanfly-5.24-32/var/REPO/M/MI/MIKER
REHSACK/SQL-Statement-1.410.tar.gz
Has already been unwrapped into directory C:\cpanfly-5.24-32\var\tmp\cpan_build\SQL-Statement-1.410-ixKZe_
REHSACK/SQL-Statement-1.410.tar.gz
Has already been prepared
Running make for R/RE/REHSACK/SQL-Statement-1.410.tar.gz
Prepending C:\cpanfly-5.24-32\var\tmp\cpan_build\Math-Base-Convert-0.11-f5_WmK/blib/arch C:\cpanfly-5.24-32\var\tmp\cpan_build\Math-Base-Convert-0.11-f5_WmK/blib/lib to PERL5LIB for 'make'
>>> dmake
cp lib/SQL/Statement/Structure.pod blib\lib\SQL\Statement\Structure.pod
cp lib/SQL/Statement/Util.pm blib\lib\SQL\Statement\Util.pm
cp lib/SQL/Statement/Syntax.pod blib\lib\SQL\Statement\Syntax.pod
cp lib/SQL/Dialects/AnyData.pm blib\lib\SQL\Dialects\AnyData.pm
cp lib/SQL/Eval.pm blib\lib\SQL\Eval.pm
cp lib/SQL/Statement/Function.pm blib\lib\SQL\Statement\Function.pm
cp lib/SQL/Statement/Term.pm blib\lib\SQL\Statement\Term.pm
cp lib/SQL/Statement/Operation.pm blib\lib\SQL\Statement\Operation.pm
cp lib/SQL/Dialects/ANSI.pm blib\lib\SQL\Dialects\ANSI.pm
cp lib/SQL/Statement/Placeholder.pm blib\lib\SQL\Statement\Placeholder.pm
cp lib/SQL/Statement/TermFactory.pm blib\lib\SQL\Statement\TermFactory.pm
cp lib/SQL/Statement.pm blib\lib\SQL\Statement.pm
cp lib/SQL/Statement/Embed.pod blib\lib\SQL\Statement\Embed.pod
cp lib/SQL/Statement/Roadmap.pod blib\lib\SQL\Statement\Roadmap.pod
cp lib/SQL/Dialects/CSV.pm blib\lib\SQL\Dialects\CSV.pm
cp lib/SQL/Statement/GetInfo.pm blib\lib\SQL\Statement\GetInfo.pm
cp lib/SQL/Statement/RAM.pm blib\lib\SQL\Statement\RAM.pm
cp lib/SQL/Statement/Functions.pm blib\lib\SQL\Statement\Functions.pm
cp lib/SQL/Parser.pm blib\lib\SQL\Parser.pm
cp lib/SQL/Dialects/Role.pm blib\lib\SQL\Dialects\Role.pm
REHSACK/SQL-Statement-1.410.tar.gz
dmake -- OK
Prepending C:\cpanfly-5.24-32\var\tmp\cpan_build\Math-Base-Convert-0.11-f5_WmK/blib/arch C:\cpanfly-5.24-32\var\tmp\cpan_build\Math-Base-Convert-0.11-f5_WmK/blib/lib to PERL5LIB for 'test'
Running make test
>>> dmake test TEST_VERBOSE=1
"C:\Perl-5.24-32\bin\perl.exe" "-MExtUtils::Command::MM" "-MTest::Harness" "-e" "undef *Test::Harness::Switches; test_harness(1, 'blib\lib', 'blib\arch')" t/*.t xt/*.t
# # Using required:
# # SQL::Statement: 1.41
# # Using recommended:
# # DBD::CSV: 0.49
# # DBD::DBM: 0.08
# # DBD::File: 0.44
# # DBI: 1.636
t/00error.t .....
# Running tests for SQL::Statement
ok 1 - Parse "Junk" RaiseError=0 (default)
ok 2 - Execute function succeeded
ok 3 - Execute function no errstr
ok 4 - Execute RaiseError=0
ok 5 - Parse "Junk" RaiseError=1
ok 6 - Execute RaiseError=1
ok 7 - Execute "SELECT * FROM nonexistant" has errstr
# Running tests for DBD::File
ok 8 - Parse "Junk" RaiseError=0 (default)
ok 9 - Execute function succeeded
ok 10 - Execute function no errstr
ok 11 - Execute RaiseError=0
ok 12 - Parse "Junk" RaiseError=1
ok 13 - Execute RaiseError=1
ok 14 - Execute "SELECT * FROM nonexistant" has errstr
# Running tests for DBD::DBM
ok 15 - Parse "Junk" RaiseError=0 (default)
ok 16 - Execute function succeeded
ok 17 - Execute function no errstr
ok 18 - Execute RaiseError=0
ok 19 - Parse "Junk" RaiseError=1
ok 20 - Execute RaiseError=1
ok 21 - Execute "SELECT * FROM nonexistant" has errstr
# Running tests for DBD::CSV
ok 22 - Parse "Junk" RaiseError=0 (default)
ok 23 - Execute function succeeded
ok 24 - Execute function no errstr
ok 25 - Execute RaiseError=0
ok 26 - Parse "Junk" RaiseError=1
ok 27 - Execute RaiseError=1
ok 28 - Execute "SELECT * FROM nonexistant" has errstr
1..28
ok
t/01prepare.t ...
ok 1 - parse ' /* DROP TABLE */' using SQL::Statement
ok 2 - parse 'DROP TABLE foo' using SQL::Statement
ok 3 - parse 'DROP TABLE foo CASCADE' using SQL::Statement
ok 4 - parse 'DROP TABLE foo RESTRICT' using SQL::Statement
ok 5 - parse ' /* DELETE */' using SQL::Statement
ok 6 - parse 'DELETE FROM foo' using SQL::Statement
ok 7 - parse 'DELETE FROM foo WHERE id < 7' using SQL::Statement
ok 8 - parse ' /* UPDATE */' using SQL::Statement
ok 9 - parse 'UPDATE foo SET bar = 7' using SQL::Statement
ok 10 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' using SQL::Statement
ok 11 - parse ' /* INSERT */' using SQL::Statement
ok 12 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' using SQL::Statement
ok 13 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using SQL::Statement
ok 14 - parse 'INSERT INTO foo VALUES ( now(), trim(lower(user)), curdate-1 )' using SQL::Statement
ok 15 - parse 'INSERT INTO foo VALUES ( 'smile :-),(-: twice)', ' \' ) ' )' using SQL::Statement
ok 16 - parse 'INSERT INTO foo VALUES (1,'row'),(2,'rows')' using SQL::Statement
ok 17 - parse ' /* CREATE TABLE */' using SQL::Statement
ok 18 - parse 'CREATE TABLE foo ( id INT )' using SQL::Statement
ok 19 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' using SQL::Statement
ok 20 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using SQL::Statement
ok 21 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using SQL::Statement
ok 22 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' using SQL::Statement
ok 23 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using SQL::Statement
ok 24 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using SQL::Statement
ok 25 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' using SQL::Statement
ok 26 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' using SQL::Statement
ok 27 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' using SQL::Statement
ok 28 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' using SQL::Statement
ok 29 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' using SQL::Statement
ok 30 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' using SQL::Statement
ok 31 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' using SQL::Statement
ok 32 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' using SQL::Statement
ok 33 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", "phrase" ), CONSTRAINT "foo_fkey" FOREIGN KEY ( "id" ) REFERENCES "bar" ( "bar_id" ))' using SQL::Statement
ok 34 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' using SQL::Statement
ok 35 - parse 'CREATE TABLE foo ( id INTEGER, phrase CHAR(255), phrase2 VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", phrase, "phrase2" ), CONSTRAINT "foo_fkey" FOREIGN KEY ("id", "phrase", "phrase2") REFERENCES "bar" ("id2", "phrase2", "phase10"))' using SQL::Statement
ok 36 - parse ' /* JOINS */' using SQL::Statement
ok 37 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' using SQL::Statement
ok 38 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' using SQL::Statement
ok 39 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' using SQL::Statement
ok 40 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' using SQL::Statement
ok 41 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' using SQL::Statement
ok 42 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using SQL::Statement
ok 43 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using SQL::Statement
ok 44 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' using SQL::Statement
ok 45 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' using SQL::Statement
ok 46 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' using SQL::Statement
ok 47 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' using SQL::Statement
ok 48 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' using SQL::Statement
ok 49 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' using SQL::Statement
ok 50 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' using SQL::Statement
ok 51 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' using SQL::Statement
ok 52 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' using SQL::Statement
ok 53 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' using SQL::Statement
ok 54 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' using SQL::Statement
ok 55 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using SQL::Statement
ok 56 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using SQL::Statement
ok 57 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' using SQL::Statement
ok 58 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' using SQL::Statement
ok 59 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' using SQL::Statement
ok 60 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' using SQL::Statement
ok 61 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' using SQL::Statement
ok 62 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' using SQL::Statement
ok 63 - parse ' /* SELECT COLUMNS */' using SQL::Statement
ok 64 - parse 'SELECT id, phrase FROM foo' using SQL::Statement
ok 65 - parse 'SELECT * FROM foo' using SQL::Statement
ok 66 - parse 'SELECT DISTINCT * FROM foo' using SQL::Statement
ok 67 - parse 'SELECT ALL * FROM foo' using SQL::Statement
ok 68 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' using SQL::Statement
ok 69 - parse ' /* SET FUNCTIONS */' using SQL::Statement
ok 70 - parse 'SELECT MAX(foo) FROM bar' using SQL::Statement
ok 71 - parse 'SELECT MIN(foo) FROM bar' using SQL::Statement
ok 72 - parse 'SELECT AVG(foo) FROM bar' using SQL::Statement
ok 73 - parse 'SELECT SUM(foo) FROM bar' using SQL::Statement
ok 74 - parse 'SELECT COUNT(foo) FROM foo' using SQL::Statement
ok 75 - parse 'SELECT COUNT(*) FROM foo' using SQL::Statement
ok 76 - parse 'SELECT SUM(DISTINCT foo) FROM bar' using SQL::Statement
ok 77 - parse 'SELECT SUM(ALL foo) FROM bar' using SQL::Statement
ok 78 - parse ' /* ORDER BY */' using SQL::Statement
ok 79 - parse 'SELECT * FROM foo ORDER BY bar' using SQL::Statement
ok 80 - parse 'SELECT * FROM foo ORDER BY bar, baz' using SQL::Statement
ok 81 - parse 'SELECT * FROM foo ORDER BY bar DESC' using SQL::Statement
ok 82 - parse 'SELECT * FROM foo ORDER BY bar ASC' using SQL::Statement
ok 83 - parse ' /* LIMIT */' using SQL::Statement
ok 84 - parse 'SELECT * FROM foo LIMIT 5' using SQL::Statement
ok 85 - parse 'SELECT * FROM foo LIMIT 0, 5' using SQL::Statement
ok 86 - parse 'SELECT * FROM foo LIMIT 5, 10' using SQL::Statement
ok 87 - parse '/* DATE/TIME FUNCTIONS */' using SQL::Statement
ok 88 - parse 'SELECT CURRENT_DATE()' using SQL::Statement
ok 89 - parse 'SELECT CURRENT_TIME()' using SQL::Statement
ok 90 - parse 'SELECT CURRENT_TIMESTAMP()' using SQL::Statement
ok 91 - parse 'SELECT CURDATE()' using SQL::Statement
ok 92 - parse 'SELECT CURTIME()' using SQL::Statement
ok 93 - parse 'SELECT NOW()' using SQL::Statement
ok 94 - parse 'SELECT UNIX_TIMESTAMP() ' using SQL::Statement
ok 95 - parse 'SELECT CURRENT_TIME(2)' using SQL::Statement
ok 96 - parse 'SELECT CURRENT_TIMESTAMP(2)' using SQL::Statement
ok 97 - parse 'SELECT CURTIME(2)' using SQL::Statement
ok 98 - parse 'SELECT NOW(2)' using SQL::Statement
ok 99 - parse 'SELECT UNIX_TIMESTAMP(2)' using SQL::Statement
ok 100 - parse ' /* STRING FUNCTIONS */' using SQL::Statement
ok 101 - parse 'SELECT * FROM foo WHERE ASCII(status) = 65' using SQL::Statement
ok 102 - parse 'SELECT * FROM foo WHERE CHAR(code) = 'A'' using SQL::Statement
ok 103 - parse 'SELECT * FROM foo WHERE CHAR(chr1,chr2,chr3) = 'ABC'' using SQL::Statement
ok 104 - parse 'SELECT * FROM foo WHERE BIT_LENGTH(str) = 27' using SQL::Statement
ok 105 - parse 'SELECT * FROM foo WHERE CHARACTER_LENGTH(str) = 6' using SQL::Statement
ok 106 - parse 'SELECT * FROM foo WHERE CHAR_LENGTH(str) = 6' using SQL::Statement
ok 107 - parse 'SELECT * FROM foo WHERE COALESCE(NULL, status) = 'bar'' using SQL::Statement
ok 108 - parse 'SELECT * FROM foo WHERE NVL(NULL, status) = 'bar'' using SQL::Statement
ok 109 - parse 'SELECT * FROM foo WHERE IFNULL(NULL, status) = 'bar'' using SQL::Statement
ok 110 - parse 'SELECT * FROM foo WHERE CONCAT(str1, str2) = 'bar'' using SQL::Statement
ok 111 - parse 'SELECT * FROM foo WHERE DECODE(color,'White','W','Red','R','B') = 'W'' using SQL::Statement
ok 112 - parse 'SELECT * FROM foo WHERE INSERT(str1, 4, 5, str2) = 'foobarland'' using SQL::Statement
ok 113 - parse 'SELECT * FROM foo WHERE LEFT(phrase) = 'bar'' using SQL::Statement
ok 114 - parse 'SELECT * FROM foo WHERE RIGHT(phrase) = 'bar'' using SQL::Statement
ok 115 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2) = 2' using SQL::Statement
ok 116 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2, 3) = 5' using SQL::Statement
ok 117 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2) = 2' using SQL::Statement
ok 118 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2, 3) = 5' using SQL::Statement
ok 119 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' using SQL::Statement
ok 120 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'BAR'' using SQL::Statement
ok 121 - parse 'SELECT * FROM foo WHERE LCASE(phrase) = 'BAR'' using SQL::Statement
ok 122 - parse 'SELECT * FROM foo WHERE UCASE(phrase) = 'bar'' using SQL::Statement
ok 123 - parse 'SELECT * FROM foo WHERE LTRIM(str) = 'bar'' using SQL::Statement
ok 124 - parse 'SELECT * FROM foo WHERE RTRIM(str) = 'bar'' using SQL::Statement
ok 125 - parse 'SELECT * FROM foo WHERE OCTET_LENGTH(str) = 12' using SQL::Statement
ok 126 - parse 'SELECT * FROM foo WHERE REGEX(phrase, '/EF/i') = TRUE' using SQL::Statement
ok 127 - parse 'SELECT * FROM foo WHERE REPEAT(status, 3) = 'AAA'' using SQL::Statement
ok 128 - parse 'SELECT * FROM foo WHERE REPLACE(phrase, 's/z(.+)ky//i') = 'bar'' using SQL::Statement
ok 129 - parse 'SELECT * FROM foo WHERE SUBSTITUTE(phrase, 's/z(.+)ky//i') = 'bar'' using SQL::Statement
ok 130 - parse 'SELECT * FROM foo WHERE SOUNDEX(name1, name2) = TRUE' using SQL::Statement
ok 131 - parse 'SELECT * FROM foo WHERE SPACE(num) = ' '' using SQL::Statement
ok 132 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3 FOR 6)' using SQL::Statement
ok 133 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3)' using SQL::Statement
ok 134 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3, 6)' using SQL::Statement
ok 135 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3)' using SQL::Statement
ok 136 - parse 'SELECT * FROM foo WHERE blat = TRANSLATE(bar, set1, set2)' using SQL::Statement
ok 137 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'' using SQL::Statement
ok 138 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' using SQL::Statement
ok 139 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' using SQL::Statement
ok 140 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' using SQL::Statement
ok 141 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' using SQL::Statement
ok 142 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' using SQL::Statement
ok 143 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' using SQL::Statement
ok 144 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' using SQL::Statement
ok 145 - parse ' /* NUMERIC FUNCTIONS */' using SQL::Statement
ok 146 - parse 'SELECT * FROM bar WHERE ABS(-4) = 4' using SQL::Statement
ok 147 - parse 'SELECT * FROM bar WHERE CEILING(-4.5) = -4' using SQL::Statement
ok 148 - parse 'SELECT * FROM bar WHERE CEIL(-4.9) = -4' using SQL::Statement
ok 149 - parse 'SELECT * FROM bar WHERE FLOOR(4.999999999999) = 4' using SQL::Statement
ok 150 - parse 'SELECT * FROM bar WHERE LOG(6) = LOG10(6)' using SQL::Statement
ok 151 - parse 'SELECT * FROM bar WHERE LN(1) = EXP(1)' using SQL::Statement
ok 152 - parse 'SELECT * FROM bar WHERE MOD(8, 5) = 3' using SQL::Statement
ok 153 - parse 'SELECT * FROM bar WHERE POWER(2, 4) = 16' using SQL::Statement
ok 154 - parse 'SELECT * FROM bar WHERE POW(2, 4) = 16' using SQL::Statement
ok 155 - parse 'SELECT * FROM bar WHERE RAND(2) = 0' using SQL::Statement
ok 156 - parse 'SELECT * FROM bar WHERE RAND(2, UNIX_TIMESTAMP()) = 0' using SQL::Statement
ok 157 - parse 'SELECT * FROM bar WHERE ROUND(4.999999999999) = 5' using SQL::Statement
ok 158 - parse 'SELECT * FROM bar WHERE ROUND(4.542222222222, 1) = 4.5' using SQL::Statement
ok 159 - parse 'SELECT * FROM bar WHERE SIGN(-25.5) = -1' using SQL::Statement
ok 160 - parse 'SELECT * FROM bar WHERE SIGN(53645) = 1' using SQL::Statement
ok 161 - parse 'SELECT * FROM bar WHERE SIGN(0) = 0' using SQL::Statement
ok 162 - parse 'SELECT * FROM bar WHERE SIGN(NULL) = NULL' using SQL::Statement
ok 163 - parse 'SELECT * FROM bar WHERE SQRT(64) = 8' using SQL::Statement
ok 164 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.999999999999) = 4' using SQL::Statement
ok 165 - parse 'SELECT * FROM bar WHERE TRUNC(-4.9) = -4' using SQL::Statement
ok 166 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.934, 1) = 4.9' using SQL::Statement
ok 167 - parse 'SELECT * FROM bar WHERE TRUNC(-4.99999, 1) = -4.9' using SQL::Statement
ok 168 - parse ' /* TRIGONOMETRIC FUNCTIONS */' using SQL::Statement
ok 169 - parse 'SELECT * FROM test WHERE ACOS(x)' using SQL::Statement
ok 170 - parse 'SELECT * FROM test WHERE ACOSEC(x)' using SQL::Statement
ok 171 - parse 'SELECT * FROM test WHERE ACOSECH(x)' using SQL::Statement
ok 172 - parse 'SELECT * FROM test WHERE ACOSH(x)' using SQL::Statement
ok 173 - parse 'SELECT * FROM test WHERE ACOT(x)' using SQL::Statement
ok 174 - parse 'SELECT * FROM test WHERE ACOTAN(x)' using SQL::Statement
ok 175 - parse 'SELECT * FROM test WHERE ACOTANH(x)' using SQL::Statement
ok 176 - parse 'SELECT * FROM test WHERE ACOTH(x)' using SQL::Statement
ok 177 - parse 'SELECT * FROM test WHERE ACSC(x)' using SQL::Statement
ok 178 - parse 'SELECT * FROM test WHERE ACSCH(x)' using SQL::Statement
ok 179 - parse 'SELECT * FROM test WHERE ASEC(x)' using SQL::Statement
ok 180 - parse 'SELECT * FROM test WHERE ASECH(x)' using SQL::Statement
ok 181 - parse 'SELECT * FROM test WHERE ASIN(x)' using SQL::Statement
ok 182 - parse 'SELECT * FROM test WHERE ASINH(x)' using SQL::Statement
ok 183 - parse 'SELECT * FROM test WHERE ATAN(x)' using SQL::Statement
ok 184 - parse 'SELECT * FROM test WHERE ATAN2(y, x)' using SQL::Statement
ok 185 - parse 'SELECT * FROM test WHERE ATANH(x)' using SQL::Statement
ok 186 - parse 'SELECT * FROM test WHERE COS(x)' using SQL::Statement
ok 187 - parse 'SELECT * FROM test WHERE COSEC(x)' using SQL::Statement
ok 188 - parse 'SELECT * FROM test WHERE COSECH(x)' using SQL::Statement
ok 189 - parse 'SELECT * FROM test WHERE COSH(x)' using SQL::Statement
ok 190 - parse 'SELECT * FROM test WHERE COT(x)' using SQL::Statement
ok 191 - parse 'SELECT * FROM test WHERE COTAN(x)' using SQL::Statement
ok 192 - parse 'SELECT * FROM test WHERE COTANH(x)' using SQL::Statement
ok 193 - parse 'SELECT * FROM test WHERE COTH(x)' using SQL::Statement
ok 194 - parse 'SELECT * FROM test WHERE CSC(x)' using SQL::Statement
ok 195 - parse 'SELECT * FROM test WHERE CSCH(x)' using SQL::Statement
ok 196 - parse 'SELECT * FROM test WHERE DEG2DEG(deg)' using SQL::Statement
ok 197 - parse 'SELECT * FROM test WHERE RAD2RAD(rad)' using SQL::Statement
ok 198 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad)' using SQL::Statement
ok 199 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg)' using SQL::Statement
ok 200 - parse 'SELECT * FROM test WHERE DEG2RAD(deg)' using SQL::Statement
ok 201 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad)' using SQL::Statement
ok 202 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad)' using SQL::Statement
ok 203 - parse 'SELECT * FROM test WHERE RAD2DEG(rad)' using SQL::Statement
ok 204 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad)' using SQL::Statement
ok 205 - parse 'SELECT * FROM test WHERE DEGREES(rad)' using SQL::Statement
ok 206 - parse 'SELECT * FROM test WHERE RADIANS(deg)' using SQL::Statement
ok 207 - parse 'SELECT * FROM test WHERE DEG2DEG(deg, TRUE)' using SQL::Statement
ok 208 - parse 'SELECT * FROM test WHERE RAD2RAD(rad, TRUE)' using SQL::Statement
ok 209 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad, TRUE)' using SQL::Statement
ok 210 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg, TRUE)' using SQL::Statement
ok 211 - parse 'SELECT * FROM test WHERE DEG2RAD(deg, TRUE)' using SQL::Statement
ok 212 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad, TRUE)' using SQL::Statement
ok 213 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad, TRUE)' using SQL::Statement
ok 214 - parse 'SELECT * FROM test WHERE RAD2DEG(rad, TRUE)' using SQL::Statement
ok 215 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad, TRUE)' using SQL::Statement
ok 216 - parse 'SELECT * FROM test WHERE DEGREES(rad, TRUE)' using SQL::Statement
ok 217 - parse 'SELECT * FROM test WHERE RADIANS(deg, TRUE)' using SQL::Statement
ok 218 - parse 'SELECT * FROM test WHERE PI()' using SQL::Statement
ok 219 - parse 'SELECT * FROM test WHERE SEC(x)' using SQL::Statement
ok 220 - parse 'SELECT * FROM test WHERE SECH(x)' using SQL::Statement
ok 221 - parse 'SELECT * FROM test WHERE SIN(x)' using SQL::Statement
ok 222 - parse 'SELECT * FROM test WHERE SINH(x)' using SQL::Statement
ok 223 - parse 'SELECT * FROM test WHERE TAN(x)' using SQL::Statement
ok 224 - parse 'SELECT * FROM test WHERE TANH(x)' using SQL::Statement
ok 225 - parse ' /* SYSTEM FUNCTIONS */' using SQL::Statement
ok 226 - parse 'SELECT * FROM ztable WHERE DBNAME() = foobar' using SQL::Statement
ok 227 - parse 'SELECT * FROM ztable WHERE USERNAME() = foobar' using SQL::Statement
ok 228 - parse 'SELECT * FROM ztable WHERE USER() = foobar' using SQL::Statement
ok 229 - parse ' /* TABLE NAME ALIASES */' using SQL::Statement
ok 230 - parse 'SELECT * FROM test as T1' using SQL::Statement
ok 231 - parse 'SELECT * FROM test T1' using SQL::Statement
ok 232 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' using SQL::Statement
ok 233 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' using SQL::Statement
ok 234 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' using SQL::Statement
ok 235 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' using SQL::Statement
ok 236 - parse ' /* NUMERIC EXPRESSIONS */' using SQL::Statement
ok 237 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' using SQL::Statement
ok 238 - parse ' /* CASE OF IDENTIFIERS */' using SQL::Statement
ok 239 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' using SQL::Statement
ok 240 - parse ' /* PARENS */' using SQL::Statement
ok 241 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' using SQL::Statement
ok 242 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' using SQL::Statement
ok 243 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' using SQL::Statement
ok 244 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' using SQL::Statement
ok 245 - parse 'SELECT * from ztable WHERE sev IN (50,60)' using SQL::Statement
ok 246 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' using SQL::Statement
ok 247 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' using SQL::Statement
ok 248 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' using SQL::Statement
ok 249 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' using SQL::Statement
ok 250 - parse ' /* NOT */' using SQL::Statement
ok 251 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using SQL::Statement
ok 252 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' using SQL::Statement
ok 253 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' using SQL::Statement
ok 254 - parse ' /* IN */' using SQL::Statement
ok 255 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' using SQL::Statement
ok 256 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' using SQL::Statement
ok 257 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' using SQL::Statement
ok 258 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' using SQL::Statement
ok 259 - parse ' /* BETWEEN */' using SQL::Statement
ok 260 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' using SQL::Statement
ok 261 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' using SQL::Statement
ok 262 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' using SQL::Statement
ok 263 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' using SQL::Statement
not ok 264 - parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using SQL::Statement # TODO Analyze failures
# Failed (TODO) test 'parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using SQL::Statement'
# at t/01prepare.t line 312.
# Incomplete SET clause!
not ok 265 - parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using SQL::Statement # TODO Analyze failures
# Failed (TODO) test 'parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using SQL::Statement'
# at t/01prepare.t line 312.
#
# Execution ERROR: Unknown predicate '{$VAR1 = {};
# }' called from t/TestLib.pm at 190.
#
not ok 266 - parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using SQL::Statement # TODO Analyze failures
# Failed (TODO) test 'parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using SQL::Statement'
# at t/01prepare.t line 312.
#
# Execution ERROR: Unknown predicate '{$VAR1 = {};
# }' called from t/TestLib.pm at 190.
#
ok 267 - $sth->new
ok 268 - $sth->command
ok 269 - $sth->params
ok 270 - $sth->tables
ok 271 - $sth->where()->op
ok 272 - $sth->where()->left
ok 273 - $sth->where()->left->left
ok 274 - $sth->where()->left->right
ok 275 - $sth->limit
ok 276 - $sth->offset
# Command SELECT
# Num Pholders 1
# Columns
# Tables SQL::Statement::Table=HASH(0x350392c),SQL::Statement::Table=HASH(0x350323c)
# Where op AND
# Limit 2
# Offset 5
# Order Cols f,g
ok 277 - $stmt->row_values()
ok 278 - $stmt->row_values(0)
ok 279 - $stmt->row_values(0,1)
ok 280 - structure
ok 281 - command
ok 282 - distinct
ok 283 - parse ' /* DROP TABLE */' using DBD::CSV
ok 284 - parse 'DROP TABLE foo' using DBD::CSV
ok 285 - parse 'DROP TABLE foo CASCADE' using DBD::CSV
ok 286 - parse 'DROP TABLE foo RESTRICT' using DBD::CSV
ok 287 - parse ' /* DELETE */' using DBD::CSV
ok 288 - parse 'DELETE FROM foo' using DBD::CSV
ok 289 - parse 'DELETE FROM foo WHERE id < 7' using DBD::CSV
ok 290 - parse ' /* UPDATE */' using DBD::CSV
ok 291 - parse 'UPDATE foo SET bar = 7' using DBD::CSV
ok 292 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' using DBD::CSV
ok 293 - parse ' /* INSERT */' using DBD::CSV
ok 294 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' using DBD::CSV
ok 295 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using DBD::CSV
ok 296 - parse 'INSERT INTO foo VALUES ( now(), trim(lower(user)), curdate-1 )' using DBD::CSV
ok 297 - parse 'INSERT INTO foo VALUES ( 'smile :-),(-: twice)', ' \' ) ' )' using DBD::CSV
ok 298 - parse 'INSERT INTO foo VALUES (1,'row'),(2,'rows')' using DBD::CSV
ok 299 - parse ' /* CREATE TABLE */' using DBD::CSV
ok 300 - parse 'CREATE TABLE foo ( id INT )' using DBD::CSV
ok 301 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' using DBD::CSV
ok 302 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::CSV
ok 303 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::CSV
ok 304 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' using DBD::CSV
ok 305 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::CSV
ok 306 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::CSV
ok 307 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' using DBD::CSV
ok 308 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' using DBD::CSV
ok 309 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' using DBD::CSV
ok 310 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' using DBD::CSV
ok 311 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' using DBD::CSV
ok 312 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' using DBD::CSV
ok 313 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' using DBD::CSV
ok 314 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' using DBD::CSV
ok 315 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", "phrase" ), CONSTRAINT "foo_fkey" FOREIGN KEY ( "id" ) REFERENCES "bar" ( "bar_id" ))' using DBD::CSV
ok 316 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' using DBD::CSV
ok 317 - parse 'CREATE TABLE foo ( id INTEGER, phrase CHAR(255), phrase2 VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", phrase, "phrase2" ), CONSTRAINT "foo_fkey" FOREIGN KEY ("id", "phrase", "phrase2") REFERENCES "bar" ("id2", "phrase2", "phase10"))' using DBD::CSV
ok 318 - parse ' /* JOINS */' using DBD::CSV
ok 319 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' using DBD::CSV
ok 320 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' using DBD::CSV
ok 321 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::CSV
ok 322 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' using DBD::CSV
ok 323 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::CSV
ok 324 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::CSV
ok 325 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::CSV
ok 326 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::CSV
ok 327 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' using DBD::CSV
ok 328 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' using DBD::CSV
ok 329 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::CSV
ok 330 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' using DBD::CSV
ok 331 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' using DBD::CSV
ok 332 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' using DBD::CSV
ok 333 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' using DBD::CSV
ok 334 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::CSV
ok 335 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' using DBD::CSV
ok 336 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::CSV
ok 337 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::CSV
ok 338 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::CSV
ok 339 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::CSV
ok 340 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' using DBD::CSV
ok 341 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' using DBD::CSV
ok 342 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::CSV
ok 343 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' using DBD::CSV
ok 344 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' using DBD::CSV
ok 345 - parse ' /* SELECT COLUMNS */' using DBD::CSV
ok 346 - parse 'SELECT id, phrase FROM foo' using DBD::CSV
ok 347 - parse 'SELECT * FROM foo' using DBD::CSV
ok 348 - parse 'SELECT DISTINCT * FROM foo' using DBD::CSV
ok 349 - parse 'SELECT ALL * FROM foo' using DBD::CSV
ok 350 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' using DBD::CSV
ok 351 - parse ' /* SET FUNCTIONS */' using DBD::CSV
ok 352 - parse 'SELECT MAX(foo) FROM bar' using DBD::CSV
ok 353 - parse 'SELECT MIN(foo) FROM bar' using DBD::CSV
ok 354 - parse 'SELECT AVG(foo) FROM bar' using DBD::CSV
ok 355 - parse 'SELECT SUM(foo) FROM bar' using DBD::CSV
ok 356 - parse 'SELECT COUNT(foo) FROM foo' using DBD::CSV
ok 357 - parse 'SELECT COUNT(*) FROM foo' using DBD::CSV
ok 358 - parse 'SELECT SUM(DISTINCT foo) FROM bar' using DBD::CSV
ok 359 - parse 'SELECT SUM(ALL foo) FROM bar' using DBD::CSV
ok 360 - parse ' /* ORDER BY */' using DBD::CSV
ok 361 - parse 'SELECT * FROM foo ORDER BY bar' using DBD::CSV
ok 362 - parse 'SELECT * FROM foo ORDER BY bar, baz' using DBD::CSV
ok 363 - parse 'SELECT * FROM foo ORDER BY bar DESC' using DBD::CSV
ok 364 - parse 'SELECT * FROM foo ORDER BY bar ASC' using DBD::CSV
ok 365 - parse ' /* LIMIT */' using DBD::CSV
ok 366 - parse 'SELECT * FROM foo LIMIT 5' using DBD::CSV
ok 367 - parse 'SELECT * FROM foo LIMIT 0, 5' using DBD::CSV
ok 368 - parse 'SELECT * FROM foo LIMIT 5, 10' using DBD::CSV
ok 369 - parse '/* DATE/TIME FUNCTIONS */' using DBD::CSV
ok 370 - parse 'SELECT CURRENT_DATE()' using DBD::CSV
ok 371 - parse 'SELECT CURRENT_TIME()' using DBD::CSV
ok 372 - parse 'SELECT CURRENT_TIMESTAMP()' using DBD::CSV
ok 373 - parse 'SELECT CURDATE()' using DBD::CSV
ok 374 - parse 'SELECT CURTIME()' using DBD::CSV
ok 375 - parse 'SELECT NOW()' using DBD::CSV
ok 376 - parse 'SELECT UNIX_TIMESTAMP() ' using DBD::CSV
ok 377 - parse 'SELECT CURRENT_TIME(2)' using DBD::CSV
ok 378 - parse 'SELECT CURRENT_TIMESTAMP(2)' using DBD::CSV
ok 379 - parse 'SELECT CURTIME(2)' using DBD::CSV
ok 380 - parse 'SELECT NOW(2)' using DBD::CSV
ok 381 - parse 'SELECT UNIX_TIMESTAMP(2)' using DBD::CSV
ok 382 - parse ' /* STRING FUNCTIONS */' using DBD::CSV
ok 383 - parse 'SELECT * FROM foo WHERE ASCII(status) = 65' using DBD::CSV
ok 384 - parse 'SELECT * FROM foo WHERE CHAR(code) = 'A'' using DBD::CSV
ok 385 - parse 'SELECT * FROM foo WHERE CHAR(chr1,chr2,chr3) = 'ABC'' using DBD::CSV
ok 386 - parse 'SELECT * FROM foo WHERE BIT_LENGTH(str) = 27' using DBD::CSV
ok 387 - parse 'SELECT * FROM foo WHERE CHARACTER_LENGTH(str) = 6' using DBD::CSV
ok 388 - parse 'SELECT * FROM foo WHERE CHAR_LENGTH(str) = 6' using DBD::CSV
ok 389 - parse 'SELECT * FROM foo WHERE COALESCE(NULL, status) = 'bar'' using DBD::CSV
ok 390 - parse 'SELECT * FROM foo WHERE NVL(NULL, status) = 'bar'' using DBD::CSV
ok 391 - parse 'SELECT * FROM foo WHERE IFNULL(NULL, status) = 'bar'' using DBD::CSV
ok 392 - parse 'SELECT * FROM foo WHERE CONCAT(str1, str2) = 'bar'' using DBD::CSV
ok 393 - parse 'SELECT * FROM foo WHERE DECODE(color,'White','W','Red','R','B') = 'W'' using DBD::CSV
ok 394 - parse 'SELECT * FROM foo WHERE INSERT(str1, 4, 5, str2) = 'foobarland'' using DBD::CSV
ok 395 - parse 'SELECT * FROM foo WHERE LEFT(phrase) = 'bar'' using DBD::CSV
ok 396 - parse 'SELECT * FROM foo WHERE RIGHT(phrase) = 'bar'' using DBD::CSV
ok 397 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2) = 2' using DBD::CSV
ok 398 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2, 3) = 5' using DBD::CSV
ok 399 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2) = 2' using DBD::CSV
ok 400 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2, 3) = 5' using DBD::CSV
ok 401 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' using DBD::CSV
ok 402 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'BAR'' using DBD::CSV
ok 403 - parse 'SELECT * FROM foo WHERE LCASE(phrase) = 'BAR'' using DBD::CSV
ok 404 - parse 'SELECT * FROM foo WHERE UCASE(phrase) = 'bar'' using DBD::CSV
ok 405 - parse 'SELECT * FROM foo WHERE LTRIM(str) = 'bar'' using DBD::CSV
ok 406 - parse 'SELECT * FROM foo WHERE RTRIM(str) = 'bar'' using DBD::CSV
ok 407 - parse 'SELECT * FROM foo WHERE OCTET_LENGTH(str) = 12' using DBD::CSV
ok 408 - parse 'SELECT * FROM foo WHERE REGEX(phrase, '/EF/i') = TRUE' using DBD::CSV
ok 409 - parse 'SELECT * FROM foo WHERE REPEAT(status, 3) = 'AAA'' using DBD::CSV
ok 410 - parse 'SELECT * FROM foo WHERE REPLACE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::CSV
ok 411 - parse 'SELECT * FROM foo WHERE SUBSTITUTE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::CSV
ok 412 - parse 'SELECT * FROM foo WHERE SOUNDEX(name1, name2) = TRUE' using DBD::CSV
ok 413 - parse 'SELECT * FROM foo WHERE SPACE(num) = ' '' using DBD::CSV
ok 414 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3 FOR 6)' using DBD::CSV
ok 415 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3)' using DBD::CSV
ok 416 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3, 6)' using DBD::CSV
ok 417 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3)' using DBD::CSV
ok 418 - parse 'SELECT * FROM foo WHERE blat = TRANSLATE(bar, set1, set2)' using DBD::CSV
ok 419 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'' using DBD::CSV
ok 420 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' using DBD::CSV
ok 421 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' using DBD::CSV
ok 422 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' using DBD::CSV
ok 423 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' using DBD::CSV
ok 424 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' using DBD::CSV
ok 425 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' using DBD::CSV
ok 426 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' using DBD::CSV
ok 427 - parse ' /* NUMERIC FUNCTIONS */' using DBD::CSV
ok 428 - parse 'SELECT * FROM bar WHERE ABS(-4) = 4' using DBD::CSV
ok 429 - parse 'SELECT * FROM bar WHERE CEILING(-4.5) = -4' using DBD::CSV
ok 430 - parse 'SELECT * FROM bar WHERE CEIL(-4.9) = -4' using DBD::CSV
ok 431 - parse 'SELECT * FROM bar WHERE FLOOR(4.999999999999) = 4' using DBD::CSV
ok 432 - parse 'SELECT * FROM bar WHERE LOG(6) = LOG10(6)' using DBD::CSV
ok 433 - parse 'SELECT * FROM bar WHERE LN(1) = EXP(1)' using DBD::CSV
ok 434 - parse 'SELECT * FROM bar WHERE MOD(8, 5) = 3' using DBD::CSV
ok 435 - parse 'SELECT * FROM bar WHERE POWER(2, 4) = 16' using DBD::CSV
ok 436 - parse 'SELECT * FROM bar WHERE POW(2, 4) = 16' using DBD::CSV
ok 437 - parse 'SELECT * FROM bar WHERE RAND(2) = 0' using DBD::CSV
ok 438 - parse 'SELECT * FROM bar WHERE RAND(2, UNIX_TIMESTAMP()) = 0' using DBD::CSV
ok 439 - parse 'SELECT * FROM bar WHERE ROUND(4.999999999999) = 5' using DBD::CSV
ok 440 - parse 'SELECT * FROM bar WHERE ROUND(4.542222222222, 1) = 4.5' using DBD::CSV
ok 441 - parse 'SELECT * FROM bar WHERE SIGN(-25.5) = -1' using DBD::CSV
ok 442 - parse 'SELECT * FROM bar WHERE SIGN(53645) = 1' using DBD::CSV
ok 443 - parse 'SELECT * FROM bar WHERE SIGN(0) = 0' using DBD::CSV
ok 444 - parse 'SELECT * FROM bar WHERE SIGN(NULL) = NULL' using DBD::CSV
ok 445 - parse 'SELECT * FROM bar WHERE SQRT(64) = 8' using DBD::CSV
ok 446 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.999999999999) = 4' using DBD::CSV
ok 447 - parse 'SELECT * FROM bar WHERE TRUNC(-4.9) = -4' using DBD::CSV
ok 448 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.934, 1) = 4.9' using DBD::CSV
ok 449 - parse 'SELECT * FROM bar WHERE TRUNC(-4.99999, 1) = -4.9' using DBD::CSV
ok 450 - parse ' /* TRIGONOMETRIC FUNCTIONS */' using DBD::CSV
ok 451 - parse 'SELECT * FROM test WHERE ACOS(x)' using DBD::CSV
ok 452 - parse 'SELECT * FROM test WHERE ACOSEC(x)' using DBD::CSV
ok 453 - parse 'SELECT * FROM test WHERE ACOSECH(x)' using DBD::CSV
ok 454 - parse 'SELECT * FROM test WHERE ACOSH(x)' using DBD::CSV
ok 455 - parse 'SELECT * FROM test WHERE ACOT(x)' using DBD::CSV
ok 456 - parse 'SELECT * FROM test WHERE ACOTAN(x)' using DBD::CSV
ok 457 - parse 'SELECT * FROM test WHERE ACOTANH(x)' using DBD::CSV
ok 458 - parse 'SELECT * FROM test WHERE ACOTH(x)' using DBD::CSV
ok 459 - parse 'SELECT * FROM test WHERE ACSC(x)' using DBD::CSV
ok 460 - parse 'SELECT * FROM test WHERE ACSCH(x)' using DBD::CSV
ok 461 - parse 'SELECT * FROM test WHERE ASEC(x)' using DBD::CSV
ok 462 - parse 'SELECT * FROM test WHERE ASECH(x)' using DBD::CSV
ok 463 - parse 'SELECT * FROM test WHERE ASIN(x)' using DBD::CSV
ok 464 - parse 'SELECT * FROM test WHERE ASINH(x)' using DBD::CSV
ok 465 - parse 'SELECT * FROM test WHERE ATAN(x)' using DBD::CSV
ok 466 - parse 'SELECT * FROM test WHERE ATAN2(y, x)' using DBD::CSV
ok 467 - parse 'SELECT * FROM test WHERE ATANH(x)' using DBD::CSV
ok 468 - parse 'SELECT * FROM test WHERE COS(x)' using DBD::CSV
ok 469 - parse 'SELECT * FROM test WHERE COSEC(x)' using DBD::CSV
ok 470 - parse 'SELECT * FROM test WHERE COSECH(x)' using DBD::CSV
ok 471 - parse 'SELECT * FROM test WHERE COSH(x)' using DBD::CSV
ok 472 - parse 'SELECT * FROM test WHERE COT(x)' using DBD::CSV
ok 473 - parse 'SELECT * FROM test WHERE COTAN(x)' using DBD::CSV
ok 474 - parse 'SELECT * FROM test WHERE COTANH(x)' using DBD::CSV
ok 475 - parse 'SELECT * FROM test WHERE COTH(x)' using DBD::CSV
ok 476 - parse 'SELECT * FROM test WHERE CSC(x)' using DBD::CSV
ok 477 - parse 'SELECT * FROM test WHERE CSCH(x)' using DBD::CSV
ok 478 - parse 'SELECT * FROM test WHERE DEG2DEG(deg)' using DBD::CSV
ok 479 - parse 'SELECT * FROM test WHERE RAD2RAD(rad)' using DBD::CSV
ok 480 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad)' using DBD::CSV
ok 481 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg)' using DBD::CSV
ok 482 - parse 'SELECT * FROM test WHERE DEG2RAD(deg)' using DBD::CSV
ok 483 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad)' using DBD::CSV
ok 484 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad)' using DBD::CSV
ok 485 - parse 'SELECT * FROM test WHERE RAD2DEG(rad)' using DBD::CSV
ok 486 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad)' using DBD::CSV
ok 487 - parse 'SELECT * FROM test WHERE DEGREES(rad)' using DBD::CSV
ok 488 - parse 'SELECT * FROM test WHERE RADIANS(deg)' using DBD::CSV
ok 489 - parse 'SELECT * FROM test WHERE DEG2DEG(deg, TRUE)' using DBD::CSV
ok 490 - parse 'SELECT * FROM test WHERE RAD2RAD(rad, TRUE)' using DBD::CSV
ok 491 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad, TRUE)' using DBD::CSV
ok 492 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg, TRUE)' using DBD::CSV
ok 493 - parse 'SELECT * FROM test WHERE DEG2RAD(deg, TRUE)' using DBD::CSV
ok 494 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad, TRUE)' using DBD::CSV
ok 495 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad, TRUE)' using DBD::CSV
ok 496 - parse 'SELECT * FROM test WHERE RAD2DEG(rad, TRUE)' using DBD::CSV
ok 497 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad, TRUE)' using DBD::CSV
ok 498 - parse 'SELECT * FROM test WHERE DEGREES(rad, TRUE)' using DBD::CSV
ok 499 - parse 'SELECT * FROM test WHERE RADIANS(deg, TRUE)' using DBD::CSV
ok 500 - parse 'SELECT * FROM test WHERE PI()' using DBD::CSV
ok 501 - parse 'SELECT * FROM test WHERE SEC(x)' using DBD::CSV
ok 502 - parse 'SELECT * FROM test WHERE SECH(x)' using DBD::CSV
ok 503 - parse 'SELECT * FROM test WHERE SIN(x)' using DBD::CSV
ok 504 - parse 'SELECT * FROM test WHERE SINH(x)' using DBD::CSV
ok 505 - parse 'SELECT * FROM test WHERE TAN(x)' using DBD::CSV
ok 506 - parse 'SELECT * FROM test WHERE TANH(x)' using DBD::CSV
ok 507 - parse ' /* SYSTEM FUNCTIONS */' using DBD::CSV
ok 508 - parse 'SELECT * FROM ztable WHERE DBNAME() = foobar' using DBD::CSV
ok 509 - parse 'SELECT * FROM ztable WHERE USERNAME() = foobar' using DBD::CSV
ok 510 - parse 'SELECT * FROM ztable WHERE USER() = foobar' using DBD::CSV
ok 511 - parse ' /* TABLE NAME ALIASES */' using DBD::CSV
ok 512 - parse 'SELECT * FROM test as T1' using DBD::CSV
ok 513 - parse 'SELECT * FROM test T1' using DBD::CSV
ok 514 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' using DBD::CSV
ok 515 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' using DBD::CSV
ok 516 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' using DBD::CSV
ok 517 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' using DBD::CSV
ok 518 - parse ' /* NUMERIC EXPRESSIONS */' using DBD::CSV
ok 519 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' using DBD::CSV
ok 520 - parse ' /* CASE OF IDENTIFIERS */' using DBD::CSV
ok 521 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' using DBD::CSV
ok 522 - parse ' /* PARENS */' using DBD::CSV
ok 523 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' using DBD::CSV
ok 524 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' using DBD::CSV
ok 525 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' using DBD::CSV
ok 526 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' using DBD::CSV
ok 527 - parse 'SELECT * from ztable WHERE sev IN (50,60)' using DBD::CSV
ok 528 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' using DBD::CSV
ok 529 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' using DBD::CSV
ok 530 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' using DBD::CSV
ok 531 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' using DBD::CSV
ok 532 - parse ' /* NOT */' using DBD::CSV
ok 533 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using DBD::CSV
ok 534 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' using DBD::CSV
ok 535 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' using DBD::CSV
ok 536 - parse ' /* IN */' using DBD::CSV
ok 537 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' using DBD::CSV
ok 538 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' using DBD::CSV
ok 539 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' using DBD::CSV
ok 540 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' using DBD::CSV
ok 541 - parse ' /* BETWEEN */' using DBD::CSV
ok 542 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' using DBD::CSV
ok 543 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' using DBD::CSV
ok 544 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' using DBD::CSV
ok 545 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' using DBD::CSV
not ok 546 - parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using DBD::CSV # TODO Analyze failures
# Failed (TODO) test 'parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using DBD::CSV'
# at t/01prepare.t line 312.
# Incomplete SET clause!
not ok 547 - parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::CSV # TODO Analyze failures
# Failed (TODO) test 'parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::CSV'
# at t/01prepare.t line 312.
#
# Execution ERROR: Unknown predicate '{$VAR1 = {};
# }' called from C:/cpanfly-5.24-32/var/megalib/DBI/DBD/SqlEngine.pm at 335.
#
not ok 548 - parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::CSV # TODO Analyze failures
# Failed (TODO) test 'parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::CSV'
# at t/01prepare.t line 312.
#
# Execution ERROR: Unknown predicate '{$VAR1 = {};
# }' called from C:/cpanfly-5.24-32/var/megalib/DBI/DBD/SqlEngine.pm at 335.
#
ok 549 - $sth->new
ok 550 - $sth->command
ok 551 - $sth->params
ok 552 - $sth->tables
ok 553 - $sth->where()->op
ok 554 - $sth->where()->left
ok 555 - $sth->where()->left->left
ok 556 - $sth->where()->left->right
ok 557 - $sth->limit
ok 558 - $sth->offset
# Command SELECT
# Num Pholders 1
# Columns
# Tables SQL::Statement::Table=HASH(0x366c2dc),SQL::Statement::Table=HASH(0x366abcc)
# Where op AND
# Limit 2
# Offset 5
# Order Cols f,g
ok 559 - $stmt->row_values()
ok 560 - $stmt->row_values(0)
ok 561 - $stmt->row_values(0,1)
ok 562 - structure
ok 563 - command
ok 564 - distinct
ok 565 - parse ' /* DROP TABLE */' using DBD::File
ok 566 - parse 'DROP TABLE foo' using DBD::File
ok 567 - parse 'DROP TABLE foo CASCADE' using DBD::File
ok 568 - parse 'DROP TABLE foo RESTRICT' using DBD::File
ok 569 - parse ' /* DELETE */' using DBD::File
ok 570 - parse 'DELETE FROM foo' using DBD::File
ok 571 - parse 'DELETE FROM foo WHERE id < 7' using DBD::File
ok 572 - parse ' /* UPDATE */' using DBD::File
ok 573 - parse 'UPDATE foo SET bar = 7' using DBD::File
ok 574 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' using DBD::File
ok 575 - parse ' /* INSERT */' using DBD::File
ok 576 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' using DBD::File
ok 577 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using DBD::File
ok 578 - parse 'INSERT INTO foo VALUES ( now(), trim(lower(user)), curdate-1 )' using DBD::File
ok 579 - parse 'INSERT INTO foo VALUES ( 'smile :-),(-: twice)', ' \' ) ' )' using DBD::File
ok 580 - parse 'INSERT INTO foo VALUES (1,'row'),(2,'rows')' using DBD::File
ok 581 - parse ' /* CREATE TABLE */' using DBD::File
ok 582 - parse 'CREATE TABLE foo ( id INT )' using DBD::File
ok 583 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' using DBD::File
ok 584 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::File
ok 585 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::File
ok 586 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' using DBD::File
ok 587 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::File
ok 588 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::File
ok 589 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' using DBD::File
ok 590 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' using DBD::File
ok 591 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' using DBD::File
ok 592 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' using DBD::File
ok 593 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' using DBD::File
ok 594 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' using DBD::File
ok 595 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' using DBD::File
ok 596 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' using DBD::File
ok 597 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", "phrase" ), CONSTRAINT "foo_fkey" FOREIGN KEY ( "id" ) REFERENCES "bar" ( "bar_id" ))' using DBD::File
ok 598 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' using DBD::File
ok 599 - parse 'CREATE TABLE foo ( id INTEGER, phrase CHAR(255), phrase2 VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", phrase, "phrase2" ), CONSTRAINT "foo_fkey" FOREIGN KEY ("id", "phrase", "phrase2") REFERENCES "bar" ("id2", "phrase2", "phase10"))' using DBD::File
ok 600 - parse ' /* JOINS */' using DBD::File
ok 601 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' using DBD::File
ok 602 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' using DBD::File
ok 603 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::File
ok 604 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' using DBD::File
ok 605 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::File
ok 606 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::File
ok 607 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::File
ok 608 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::File
ok 609 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' using DBD::File
ok 610 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' using DBD::File
ok 611 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::File
ok 612 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' using DBD::File
ok 613 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' using DBD::File
ok 614 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' using DBD::File
ok 615 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' using DBD::File
ok 616 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::File
ok 617 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' using DBD::File
ok 618 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::File
ok 619 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::File
ok 620 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::File
ok 621 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::File
ok 622 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' using DBD::File
ok 623 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' using DBD::File
ok 624 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::File
ok 625 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' using DBD::File
ok 626 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' using DBD::File
ok 627 - parse ' /* SELECT COLUMNS */' using DBD::File
ok 628 - parse 'SELECT id, phrase FROM foo' using DBD::File
ok 629 - parse 'SELECT * FROM foo' using DBD::File
ok 630 - parse 'SELECT DISTINCT * FROM foo' using DBD::File
ok 631 - parse 'SELECT ALL * FROM foo' using DBD::File
ok 632 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' using DBD::File
ok 633 - parse ' /* SET FUNCTIONS */' using DBD::File
ok 634 - parse 'SELECT MAX(foo) FROM bar' using DBD::File
ok 635 - parse 'SELECT MIN(foo) FROM bar' using DBD::File
ok 636 - parse 'SELECT AVG(foo) FROM bar' using DBD::File
ok 637 - parse 'SELECT SUM(foo) FROM bar' using DBD::File
ok 638 - parse 'SELECT COUNT(foo) FROM foo' using DBD::File
ok 639 - parse 'SELECT COUNT(*) FROM foo' using DBD::File
ok 640 - parse 'SELECT SUM(DISTINCT foo) FROM bar' using DBD::File
ok 641 - parse 'SELECT SUM(ALL foo) FROM bar' using DBD::File
ok 642 - parse ' /* ORDER BY */' using DBD::File
ok 643 - parse 'SELECT * FROM foo ORDER BY bar' using DBD::File
ok 644 - parse 'SELECT * FROM foo ORDER BY bar, baz' using DBD::File
ok 645 - parse 'SELECT * FROM foo ORDER BY bar DESC' using DBD::File
ok 646 - parse 'SELECT * FROM foo ORDER BY bar ASC' using DBD::File
ok 647 - parse ' /* LIMIT */' using DBD::File
ok 648 - parse 'SELECT * FROM foo LIMIT 5' using DBD::File
ok 649 - parse 'SELECT * FROM foo LIMIT 0, 5' using DBD::File
ok 650 - parse 'SELECT * FROM foo LIMIT 5, 10' using DBD::File
ok 651 - parse '/* DATE/TIME FUNCTIONS */' using DBD::File
ok 652 - parse 'SELECT CURRENT_DATE()' using DBD::File
ok 653 - parse 'SELECT CURRENT_TIME()' using DBD::File
ok 654 - parse 'SELECT CURRENT_TIMESTAMP()' using DBD::File
ok 655 - parse 'SELECT CURDATE()' using DBD::File
ok 656 - parse 'SELECT CURTIME()' using DBD::File
ok 657 - parse 'SELECT NOW()' using DBD::File
ok 658 - parse 'SELECT UNIX_TIMESTAMP() ' using DBD::File
ok 659 - parse 'SELECT CURRENT_TIME(2)' using DBD::File
ok 660 - parse 'SELECT CURRENT_TIMESTAMP(2)' using DBD::File
ok 661 - parse 'SELECT CURTIME(2)' using DBD::File
ok 662 - parse 'SELECT NOW(2)' using DBD::File
ok 663 - parse 'SELECT UNIX_TIMESTAMP(2)' using DBD::File
ok 664 - parse ' /* STRING FUNCTIONS */' using DBD::File
ok 665 - parse 'SELECT * FROM foo WHERE ASCII(status) = 65' using DBD::File
ok 666 - parse 'SELECT * FROM foo WHERE CHAR(code) = 'A'' using DBD::File
ok 667 - parse 'SELECT * FROM foo WHERE CHAR(chr1,chr2,chr3) = 'ABC'' using DBD::File
ok 668 - parse 'SELECT * FROM foo WHERE BIT_LENGTH(str) = 27' using DBD::File
ok 669 - parse 'SELECT * FROM foo WHERE CHARACTER_LENGTH(str) = 6' using DBD::File
ok 670 - parse 'SELECT * FROM foo WHERE CHAR_LENGTH(str) = 6' using DBD::File
ok 671 - parse 'SELECT * FROM foo WHERE COALESCE(NULL, status) = 'bar'' using DBD::File
ok 672 - parse 'SELECT * FROM foo WHERE NVL(NULL, status) = 'bar'' using DBD::File
ok 673 - parse 'SELECT * FROM foo WHERE IFNULL(NULL, status) = 'bar'' using DBD::File
ok 674 - parse 'SELECT * FROM foo WHERE CONCAT(str1, str2) = 'bar'' using DBD::File
ok 675 - parse 'SELECT * FROM foo WHERE DECODE(color,'White','W','Red','R','B') = 'W'' using DBD::File
ok 676 - parse 'SELECT * FROM foo WHERE INSERT(str1, 4, 5, str2) = 'foobarland'' using DBD::File
ok 677 - parse 'SELECT * FROM foo WHERE LEFT(phrase) = 'bar'' using DBD::File
ok 678 - parse 'SELECT * FROM foo WHERE RIGHT(phrase) = 'bar'' using DBD::File
ok 679 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2) = 2' using DBD::File
ok 680 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2, 3) = 5' using DBD::File
ok 681 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2) = 2' using DBD::File
ok 682 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2, 3) = 5' using DBD::File
ok 683 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' using DBD::File
ok 684 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'BAR'' using DBD::File
ok 685 - parse 'SELECT * FROM foo WHERE LCASE(phrase) = 'BAR'' using DBD::File
ok 686 - parse 'SELECT * FROM foo WHERE UCASE(phrase) = 'bar'' using DBD::File
ok 687 - parse 'SELECT * FROM foo WHERE LTRIM(str) = 'bar'' using DBD::File
ok 688 - parse 'SELECT * FROM foo WHERE RTRIM(str) = 'bar'' using DBD::File
ok 689 - parse 'SELECT * FROM foo WHERE OCTET_LENGTH(str) = 12' using DBD::File
ok 690 - parse 'SELECT * FROM foo WHERE REGEX(phrase, '/EF/i') = TRUE' using DBD::File
ok 691 - parse 'SELECT * FROM foo WHERE REPEAT(status, 3) = 'AAA'' using DBD::File
ok 692 - parse 'SELECT * FROM foo WHERE REPLACE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::File
ok 693 - parse 'SELECT * FROM foo WHERE SUBSTITUTE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::File
ok 694 - parse 'SELECT * FROM foo WHERE SOUNDEX(name1, name2) = TRUE' using DBD::File
ok 695 - parse 'SELECT * FROM foo WHERE SPACE(num) = ' '' using DBD::File
ok 696 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3 FOR 6)' using DBD::File
ok 697 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3)' using DBD::File
ok 698 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3, 6)' using DBD::File
ok 699 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3)' using DBD::File
ok 700 - parse 'SELECT * FROM foo WHERE blat = TRANSLATE(bar, set1, set2)' using DBD::File
ok 701 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'' using DBD::File
ok 702 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' using DBD::File
ok 703 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' using DBD::File
ok 704 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' using DBD::File
ok 705 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' using DBD::File
ok 706 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' using DBD::File
ok 707 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' using DBD::File
ok 708 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' using DBD::File
ok 709 - parse ' /* NUMERIC FUNCTIONS */' using DBD::File
ok 710 - parse 'SELECT * FROM bar WHERE ABS(-4) = 4' using DBD::File
ok 711 - parse 'SELECT * FROM bar WHERE CEILING(-4.5) = -4' using DBD::File
ok 712 - parse 'SELECT * FROM bar WHERE CEIL(-4.9) = -4' using DBD::File
ok 713 - parse 'SELECT * FROM bar WHERE FLOOR(4.999999999999) = 4' using DBD::File
ok 714 - parse 'SELECT * FROM bar WHERE LOG(6) = LOG10(6)' using DBD::File
ok 715 - parse 'SELECT * FROM bar WHERE LN(1) = EXP(1)' using DBD::File
ok 716 - parse 'SELECT * FROM bar WHERE MOD(8, 5) = 3' using DBD::File
ok 717 - parse 'SELECT * FROM bar WHERE POWER(2, 4) = 16' using DBD::File
ok 718 - parse 'SELECT * FROM bar WHERE POW(2, 4) = 16' using DBD::File
ok 719 - parse 'SELECT * FROM bar WHERE RAND(2) = 0' using DBD::File
ok 720 - parse 'SELECT * FROM bar WHERE RAND(2, UNIX_TIMESTAMP()) = 0' using DBD::File
ok 721 - parse 'SELECT * FROM bar WHERE ROUND(4.999999999999) = 5' using DBD::File
ok 722 - parse 'SELECT * FROM bar WHERE ROUND(4.542222222222, 1) = 4.5' using DBD::File
ok 723 - parse 'SELECT * FROM bar WHERE SIGN(-25.5) = -1' using DBD::File
ok 724 - parse 'SELECT * FROM bar WHERE SIGN(53645) = 1' using DBD::File
ok 725 - parse 'SELECT * FROM bar WHERE SIGN(0) = 0' using DBD::File
ok 726 - parse 'SELECT * FROM bar WHERE SIGN(NULL) = NULL' using DBD::File
ok 727 - parse 'SELECT * FROM bar WHERE SQRT(64) = 8' using DBD::File
ok 728 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.999999999999) = 4' using DBD::File
ok 729 - parse 'SELECT * FROM bar WHERE TRUNC(-4.9) = -4' using DBD::File
ok 730 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.934, 1) = 4.9' using DBD::File
ok 731 - parse 'SELECT * FROM bar WHERE TRUNC(-4.99999, 1) = -4.9' using DBD::File
ok 732 - parse ' /* TRIGONOMETRIC FUNCTIONS */' using DBD::File
ok 733 - parse 'SELECT * FROM test WHERE ACOS(x)' using DBD::File
ok 734 - parse 'SELECT * FROM test WHERE ACOSEC(x)' using DBD::File
ok 735 - parse 'SELECT * FROM test WHERE ACOSECH(x)' using DBD::File
ok 736 - parse 'SELECT * FROM test WHERE ACOSH(x)' using DBD::File
ok 737 - parse 'SELECT * FROM test WHERE ACOT(x)' using DBD::File
ok 738 - parse 'SELECT * FROM test WHERE ACOTAN(x)' using DBD::File
ok 739 - parse 'SELECT * FROM test WHERE ACOTANH(x)' using DBD::File
ok 740 - parse 'SELECT * FROM test WHERE ACOTH(x)' using DBD::File
ok 741 - parse 'SELECT * FROM test WHERE ACSC(x)' using DBD::File
ok 742 - parse 'SELECT * FROM test WHERE ACSCH(x)' using DBD::File
ok 743 - parse 'SELECT * FROM test WHERE ASEC(x)' using DBD::File
ok 744 - parse 'SELECT * FROM test WHERE ASECH(x)' using DBD::File
ok 745 - parse 'SELECT * FROM test WHERE ASIN(x)' using DBD::File
ok 746 - parse 'SELECT * FROM test WHERE ASINH(x)' using DBD::File
ok 747 - parse 'SELECT * FROM test WHERE ATAN(x)' using DBD::File
ok 748 - parse 'SELECT * FROM test WHERE ATAN2(y, x)' using DBD::File
ok 749 - parse 'SELECT * FROM test WHERE ATANH(x)' using DBD::File
ok 750 - parse 'SELECT * FROM test WHERE COS(x)' using DBD::File
ok 751 - parse 'SELECT * FROM test WHERE COSEC(x)' using DBD::File
ok 752 - parse 'SELECT * FROM test WHERE COSECH(x)' using DBD::File
ok 753 - parse 'SELECT * FROM test WHERE COSH(x)' using DBD::File
ok 754 - parse 'SELECT * FROM test WHERE COT(x)' using DBD::File
ok 755 - parse 'SELECT * FROM test WHERE COTAN(x)' using DBD::File
ok 756 - parse 'SELECT * FROM test WHERE COTANH(x)' using DBD::File
ok 757 - parse 'SELECT * FROM test WHERE COTH(x)' using DBD::File
ok 758 - parse 'SELECT * FROM test WHERE CSC(x)' using DBD::File
ok 759 - parse 'SELECT * FROM test WHERE CSCH(x)' using DBD::File
ok 760 - parse 'SELECT * FROM test WHERE DEG2DEG(deg)' using DBD::File
ok 761 - parse 'SELECT * FROM test WHERE RAD2RAD(rad)' using DBD::File
ok 762 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad)' using DBD::File
ok 763 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg)' using DBD::File
ok 764 - parse 'SELECT * FROM test WHERE DEG2RAD(deg)' using DBD::File
ok 765 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad)' using DBD::File
ok 766 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad)' using DBD::File
ok 767 - parse 'SELECT * FROM test WHERE RAD2DEG(rad)' using DBD::File
ok 768 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad)' using DBD::File
ok 769 - parse 'SELECT * FROM test WHERE DEGREES(rad)' using DBD::File
ok 770 - parse 'SELECT * FROM test WHERE RADIANS(deg)' using DBD::File
ok 771 - parse 'SELECT * FROM test WHERE DEG2DEG(deg, TRUE)' using DBD::File
ok 772 - parse 'SELECT * FROM test WHERE RAD2RAD(rad, TRUE)' using DBD::File
ok 773 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad, TRUE)' using DBD::File
ok 774 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg, TRUE)' using DBD::File
ok 775 - parse 'SELECT * FROM test WHERE DEG2RAD(deg, TRUE)' using DBD::File
ok 776 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad, TRUE)' using DBD::File
ok 777 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad, TRUE)' using DBD::File
ok 778 - parse 'SELECT * FROM test WHERE RAD2DEG(rad, TRUE)' using DBD::File
ok 779 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad, TRUE)' using DBD::File
ok 780 - parse 'SELECT * FROM test WHERE DEGREES(rad, TRUE)' using DBD::File
ok 781 - parse 'SELECT * FROM test WHERE RADIANS(deg, TRUE)' using DBD::File
ok 782 - parse 'SELECT * FROM test WHERE PI()' using DBD::File
ok 783 - parse 'SELECT * FROM test WHERE SEC(x)' using DBD::File
ok 784 - parse 'SELECT * FROM test WHERE SECH(x)' using DBD::File
ok 785 - parse 'SELECT * FROM test WHERE SIN(x)' using DBD::File
ok 786 - parse 'SELECT * FROM test WHERE SINH(x)' using DBD::File
ok 787 - parse 'SELECT * FROM test WHERE TAN(x)' using DBD::File
ok 788 - parse 'SELECT * FROM test WHERE TANH(x)' using DBD::File
ok 789 - parse ' /* SYSTEM FUNCTIONS */' using DBD::File
ok 790 - parse 'SELECT * FROM ztable WHERE DBNAME() = foobar' using DBD::File
ok 791 - parse 'SELECT * FROM ztable WHERE USERNAME() = foobar' using DBD::File
ok 792 - parse 'SELECT * FROM ztable WHERE USER() = foobar' using DBD::File
ok 793 - parse ' /* TABLE NAME ALIASES */' using DBD::File
ok 794 - parse 'SELECT * FROM test as T1' using DBD::File
ok 795 - parse 'SELECT * FROM test T1' using DBD::File
ok 796 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' using DBD::File
ok 797 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' using DBD::File
ok 798 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' using DBD::File
ok 799 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' using DBD::File
ok 800 - parse ' /* NUMERIC EXPRESSIONS */' using DBD::File
ok 801 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' using DBD::File
ok 802 - parse ' /* CASE OF IDENTIFIERS */' using DBD::File
ok 803 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' using DBD::File
ok 804 - parse ' /* PARENS */' using DBD::File
ok 805 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' using DBD::File
ok 806 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' using DBD::File
ok 807 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' using DBD::File
ok 808 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' using DBD::File
ok 809 - parse 'SELECT * from ztable WHERE sev IN (50,60)' using DBD::File
ok 810 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' using DBD::File
ok 811 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' using DBD::File
ok 812 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' using DBD::File
ok 813 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' using DBD::File
ok 814 - parse ' /* NOT */' using DBD::File
ok 815 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using DBD::File
ok 816 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' using DBD::File
ok 817 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' using DBD::File
ok 818 - parse ' /* IN */' using DBD::File
ok 819 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' using DBD::File
ok 820 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' using DBD::File
ok 821 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' using DBD::File
ok 822 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' using DBD::File
ok 823 - parse ' /* BETWEEN */' using DBD::File
ok 824 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' using DBD::File
ok 825 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' using DBD::File
ok 826 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' using DBD::File
ok 827 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' using DBD::File
not ok 828 - parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using DBD::File # TODO Analyze failures
# Failed (TODO) test 'parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using DBD::File'
# at t/01prepare.t line 312.
# Incomplete SET clause!
not ok 829 - parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::File # TODO Analyze failures
# Failed (TODO) test 'parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::File'
# at t/01prepare.t line 312.
#
# Execution ERROR: Unknown predicate '{$VAR1 = {};
# }' called from C:/cpanfly-5.24-32/var/megalib/DBI/DBD/SqlEngine.pm at 335.
#
not ok 830 - parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::File # TODO Analyze failures
# Failed (TODO) test 'parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::File'
# at t/01prepare.t line 312.
#
# Execution ERROR: Unknown predicate '{$VAR1 = {};
# }' called from C:/cpanfly-5.24-32/var/megalib/DBI/DBD/SqlEngine.pm at 335.
#
ok 831 - $sth->new
ok 832 - $sth->command
ok 833 - $sth->params
ok 834 - $sth->tables
ok 835 - $sth->where()->op
ok 836 - $sth->where()->left
ok 837 - $sth->where()->left->left
ok 838 - $sth->where()->left->right
ok 839 - $sth->limit
ok 840 - $sth->offset
# Command SELECT
# Num Pholders 1
# Columns
# Tables SQL::Statement::Table=HASH(0x36857dc),SQL::Statement::Table=HASH(0x3682e54)
# Where op AND
# Limit 2
# Offset 5
# Order Cols f,g
ok 841 - $stmt->row_values()
ok 842 - $stmt->row_values(0)
ok 843 - $stmt->row_values(0,1)
ok 844 - structure
ok 845 - command
ok 846 - distinct
ok 847 - parse ' /* DROP TABLE */' using DBD::DBM
ok 848 - parse 'DROP TABLE foo' using DBD::DBM
ok 849 - parse 'DROP TABLE foo CASCADE' using DBD::DBM
ok 850 - parse 'DROP TABLE foo RESTRICT' using DBD::DBM
ok 851 - parse ' /* DELETE */' using DBD::DBM
ok 852 - parse 'DELETE FROM foo' using DBD::DBM
ok 853 - parse 'DELETE FROM foo WHERE id < 7' using DBD::DBM
ok 854 - parse ' /* UPDATE */' using DBD::DBM
ok 855 - parse 'UPDATE foo SET bar = 7' using DBD::DBM
ok 856 - parse 'UPDATE foo SET bar = 7 WHERE id > 7' using DBD::DBM
ok 857 - parse ' /* INSERT */' using DBD::DBM
ok 858 - parse 'INSERT INTO foo VALUES ( 'baz', 7, NULL )' using DBD::DBM
ok 859 - parse 'INSERT INTO foo (col1,col2,col7) VALUES ( 'baz', 7, NULL )' using DBD::DBM
ok 860 - parse 'INSERT INTO foo VALUES ( now(), trim(lower(user)), curdate-1 )' using DBD::DBM
ok 861 - parse 'INSERT INTO foo VALUES ( 'smile :-),(-: twice)', ' \' ) ' )' using DBD::DBM
ok 862 - parse 'INSERT INTO foo VALUES (1,'row'),(2,'rows')' using DBD::DBM
ok 863 - parse ' /* CREATE TABLE */' using DBD::DBM
ok 864 - parse 'CREATE TABLE foo ( id INT )' using DBD::DBM
ok 865 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT)' using DBD::DBM
ok 866 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::DBM
ok 867 - parse 'CREATE LOCAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::DBM
ok 868 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT)' using DBD::DBM
ok 869 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT DELETE ROWS' using DBD::DBM
ok 870 - parse 'CREATE GLOBAL TEMPORARY TABLE foo (id INT) ON COMMIT PRESERVE ROWS' using DBD::DBM
ok 871 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40) )' using DBD::DBM
ok 872 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE, phrase VARCHAR(40) UNIQUE )' using DBD::DBM
ok 873 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) UNIQUE )' using DBD::DBM
ok 874 - parse 'CREATE TABLE foo ( id INTEGER PRIMARY KEY, phrase VARCHAR(40) NOT NULL )' using DBD::DBM
ok 875 - parse 'CREATE TABLE foo ( id INTEGER NOT NULL, phrase VARCHAR(40) NOT NULL )' using DBD::DBM
ok 876 - parse 'CREATE TABLE foo ( id INTEGER UNIQUE NOT NULL, phrase VARCHAR(40) )' using DBD::DBM
ok 877 - parse 'CREATE TABLE foo ( phrase CHARACTER VARYING(255) )' using DBD::DBM
ok 878 - parse 'CREATE TABLE foo ( phrase NUMERIC(4,6) )' using DBD::DBM
ok 879 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", "phrase" ), CONSTRAINT "foo_fkey" FOREIGN KEY ( "id" ) REFERENCES "bar" ( "bar_id" ))' using DBD::DBM
ok 880 - parse 'CREATE TABLE foo ( id INTEGER, phrase VARCHAR(40), PRIMARY KEY ( "id" ), FOREIGN KEY ("id", "phrase") REFERENCES "bar" ("id2", "phrase2"))' using DBD::DBM
ok 881 - parse 'CREATE TABLE foo ( id INTEGER, phrase CHAR(255), phrase2 VARCHAR(40), CONSTRAINT "foo_pkey" PRIMARY KEY ( "id", phrase, "phrase2" ), CONSTRAINT "foo_fkey" FOREIGN KEY ("id", "phrase", "phrase2") REFERENCES "bar" ("id2", "phrase2", "phase10"))' using DBD::DBM
ok 882 - parse ' /* JOINS */' using DBD::DBM
ok 883 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL INNER JOIN zUpper' using DBD::DBM
ok 884 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL LEFT JOIN zUpper' using DBD::DBM
ok 885 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::DBM
ok 886 - parse 'SELECT Lnum,Llet,Ulet FROM zLower NATURAL FULL JOIN zUpper' using DBD::DBM
ok 887 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::DBM
ok 888 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::DBM
ok 889 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::DBM
ok 890 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::DBM
ok 891 - parse 'SELECT Lnum,Llet,Ulet FROM zLower INNER JOIN zUpper USING(num)' using DBD::DBM
ok 892 - parse 'SELECT Lnum,Llet,Ulet FROM zLower LEFT JOIN zUpper USING(num)' using DBD::DBM
ok 893 - parse 'SELECT Lnum,Llet,Ulet FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::DBM
ok 894 - parse 'SELECT Lnum,Llet,Ulet FROM zLower FULL JOIN zUpper USING(num)' using DBD::DBM
ok 895 - parse 'SELECT Lnum,Llet,Ulet FROM zLower,zUpper WHERE Lnum = Unum' using DBD::DBM
ok 896 - parse 'SELECT * FROM zLower NATURAL INNER JOIN zUpper' using DBD::DBM
ok 897 - parse 'SELECT * FROM zLower NATURAL LEFT JOIN zUpper' using DBD::DBM
ok 898 - parse 'SELECT * FROM zLower NATURAL RIGHT JOIN zUpper' using DBD::DBM
ok 899 - parse 'SELECT * FROM zLower NATURAL FULL JOIN zUpper' using DBD::DBM
ok 900 - parse 'SELECT * FROM zLower INNER JOIN zUpper ON Lnum = Unum' using DBD::DBM
ok 901 - parse 'SELECT * FROM zLower LEFT JOIN zUpper ON Lnum = Unum' using DBD::DBM
ok 902 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper ON Lnum = Unum' using DBD::DBM
ok 903 - parse 'SELECT * FROM zLower FULL JOIN zUpper ON Lnum = Unum' using DBD::DBM
ok 904 - parse 'SELECT * FROM zLower INNER JOIN zUpper USING(num)' using DBD::DBM
ok 905 - parse 'SELECT * FROM zLower LEFT JOIN zUpper USING(num)' using DBD::DBM
ok 906 - parse 'SELECT * FROM zLower RIGHT JOIN zUpper USING(num)' using DBD::DBM
ok 907 - parse 'SELECT * FROM zLower FULL JOIN zUpper USING(num)' using DBD::DBM
ok 908 - parse 'SELECT * FROM zLower,zUpper WHERE Lnum = Unum' using DBD::DBM
ok 909 - parse ' /* SELECT COLUMNS */' using DBD::DBM
ok 910 - parse 'SELECT id, phrase FROM foo' using DBD::DBM
ok 911 - parse 'SELECT * FROM foo' using DBD::DBM
ok 912 - parse 'SELECT DISTINCT * FROM foo' using DBD::DBM
ok 913 - parse 'SELECT ALL * FROM foo' using DBD::DBM
ok 914 - parse 'SELECT A.*,B.* FROM A,B WHERE A.id=B.id' using DBD::DBM
ok 915 - parse ' /* SET FUNCTIONS */' using DBD::DBM
ok 916 - parse 'SELECT MAX(foo) FROM bar' using DBD::DBM
ok 917 - parse 'SELECT MIN(foo) FROM bar' using DBD::DBM
ok 918 - parse 'SELECT AVG(foo) FROM bar' using DBD::DBM
ok 919 - parse 'SELECT SUM(foo) FROM bar' using DBD::DBM
ok 920 - parse 'SELECT COUNT(foo) FROM foo' using DBD::DBM
ok 921 - parse 'SELECT COUNT(*) FROM foo' using DBD::DBM
ok 922 - parse 'SELECT SUM(DISTINCT foo) FROM bar' using DBD::DBM
ok 923 - parse 'SELECT SUM(ALL foo) FROM bar' using DBD::DBM
ok 924 - parse ' /* ORDER BY */' using DBD::DBM
ok 925 - parse 'SELECT * FROM foo ORDER BY bar' using DBD::DBM
ok 926 - parse 'SELECT * FROM foo ORDER BY bar, baz' using DBD::DBM
ok 927 - parse 'SELECT * FROM foo ORDER BY bar DESC' using DBD::DBM
ok 928 - parse 'SELECT * FROM foo ORDER BY bar ASC' using DBD::DBM
ok 929 - parse ' /* LIMIT */' using DBD::DBM
ok 930 - parse 'SELECT * FROM foo LIMIT 5' using DBD::DBM
ok 931 - parse 'SELECT * FROM foo LIMIT 0, 5' using DBD::DBM
ok 932 - parse 'SELECT * FROM foo LIMIT 5, 10' using DBD::DBM
ok 933 - parse '/* DATE/TIME FUNCTIONS */' using DBD::DBM
ok 934 - parse 'SELECT CURRENT_DATE()' using DBD::DBM
ok 935 - parse 'SELECT CURRENT_TIME()' using DBD::DBM
ok 936 - parse 'SELECT CURRENT_TIMESTAMP()' using DBD::DBM
ok 937 - parse 'SELECT CURDATE()' using DBD::DBM
ok 938 - parse 'SELECT CURTIME()' using DBD::DBM
ok 939 - parse 'SELECT NOW()' using DBD::DBM
ok 940 - parse 'SELECT UNIX_TIMESTAMP() ' using DBD::DBM
ok 941 - parse 'SELECT CURRENT_TIME(2)' using DBD::DBM
ok 942 - parse 'SELECT CURRENT_TIMESTAMP(2)' using DBD::DBM
ok 943 - parse 'SELECT CURTIME(2)' using DBD::DBM
ok 944 - parse 'SELECT NOW(2)' using DBD::DBM
ok 945 - parse 'SELECT UNIX_TIMESTAMP(2)' using DBD::DBM
ok 946 - parse ' /* STRING FUNCTIONS */' using DBD::DBM
ok 947 - parse 'SELECT * FROM foo WHERE ASCII(status) = 65' using DBD::DBM
ok 948 - parse 'SELECT * FROM foo WHERE CHAR(code) = 'A'' using DBD::DBM
ok 949 - parse 'SELECT * FROM foo WHERE CHAR(chr1,chr2,chr3) = 'ABC'' using DBD::DBM
ok 950 - parse 'SELECT * FROM foo WHERE BIT_LENGTH(str) = 27' using DBD::DBM
ok 951 - parse 'SELECT * FROM foo WHERE CHARACTER_LENGTH(str) = 6' using DBD::DBM
ok 952 - parse 'SELECT * FROM foo WHERE CHAR_LENGTH(str) = 6' using DBD::DBM
ok 953 - parse 'SELECT * FROM foo WHERE COALESCE(NULL, status) = 'bar'' using DBD::DBM
ok 954 - parse 'SELECT * FROM foo WHERE NVL(NULL, status) = 'bar'' using DBD::DBM
ok 955 - parse 'SELECT * FROM foo WHERE IFNULL(NULL, status) = 'bar'' using DBD::DBM
ok 956 - parse 'SELECT * FROM foo WHERE CONCAT(str1, str2) = 'bar'' using DBD::DBM
ok 957 - parse 'SELECT * FROM foo WHERE DECODE(color,'White','W','Red','R','B') = 'W'' using DBD::DBM
ok 958 - parse 'SELECT * FROM foo WHERE INSERT(str1, 4, 5, str2) = 'foobarland'' using DBD::DBM
ok 959 - parse 'SELECT * FROM foo WHERE LEFT(phrase) = 'bar'' using DBD::DBM
ok 960 - parse 'SELECT * FROM foo WHERE RIGHT(phrase) = 'bar'' using DBD::DBM
ok 961 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2) = 2' using DBD::DBM
ok 962 - parse 'SELECT * FROM foo WHERE LOCATE(str1, str2, 3) = 5' using DBD::DBM
ok 963 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2) = 2' using DBD::DBM
ok 964 - parse 'SELECT * FROM foo WHERE POSITION(str1, str2, 3) = 5' using DBD::DBM
ok 965 - parse 'SELECT * FROM foo WHERE LOWER(phrase) = 'bar'' using DBD::DBM
ok 966 - parse 'SELECT * FROM foo WHERE UPPER(phrase) = 'BAR'' using DBD::DBM
ok 967 - parse 'SELECT * FROM foo WHERE LCASE(phrase) = 'BAR'' using DBD::DBM
ok 968 - parse 'SELECT * FROM foo WHERE UCASE(phrase) = 'bar'' using DBD::DBM
ok 969 - parse 'SELECT * FROM foo WHERE LTRIM(str) = 'bar'' using DBD::DBM
ok 970 - parse 'SELECT * FROM foo WHERE RTRIM(str) = 'bar'' using DBD::DBM
ok 971 - parse 'SELECT * FROM foo WHERE OCTET_LENGTH(str) = 12' using DBD::DBM
ok 972 - parse 'SELECT * FROM foo WHERE REGEX(phrase, '/EF/i') = TRUE' using DBD::DBM
ok 973 - parse 'SELECT * FROM foo WHERE REPEAT(status, 3) = 'AAA'' using DBD::DBM
ok 974 - parse 'SELECT * FROM foo WHERE REPLACE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::DBM
ok 975 - parse 'SELECT * FROM foo WHERE SUBSTITUTE(phrase, 's/z(.+)ky//i') = 'bar'' using DBD::DBM
ok 976 - parse 'SELECT * FROM foo WHERE SOUNDEX(name1, name2) = TRUE' using DBD::DBM
ok 977 - parse 'SELECT * FROM foo WHERE SPACE(num) = ' '' using DBD::DBM
ok 978 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3 FOR 6)' using DBD::DBM
ok 979 - parse 'SELECT * FROM foo WHERE blat = SUBSTRING(bar FROM 3)' using DBD::DBM
ok 980 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3, 6)' using DBD::DBM
ok 981 - parse 'SELECT * FROM foo WHERE blat = SUBSTR(bar, 3)' using DBD::DBM
ok 982 - parse 'SELECT * FROM foo WHERE blat = TRANSLATE(bar, set1, set2)' using DBD::DBM
ok 983 - parse 'SELECT * FROM foo WHERE TRIM( str ) = 'bar'' using DBD::DBM
ok 984 - parse 'SELECT * FROM foo WHERE TRIM( LEADING FROM str ) = 'bar'' using DBD::DBM
ok 985 - parse 'SELECT * FROM foo WHERE TRIM( TRAILING FROM str ) = 'bar'' using DBD::DBM
ok 986 - parse 'SELECT * FROM foo WHERE TRIM( BOTH FROM str ) = 'bar'' using DBD::DBM
ok 987 - parse 'SELECT * FROM foo WHERE TRIM( LEADING ';' FROM str ) = 'bar'' using DBD::DBM
ok 988 - parse 'SELECT * FROM foo WHERE TRIM( UPPER(phrase) ) = 'bar'' using DBD::DBM
ok 989 - parse 'SELECT * FROM foo WHERE TRIM( LOWER(phrase) ) = 'bar'' using DBD::DBM
ok 990 - parse 'UPDATE foo SET bar='baz', bop=7, bump=bar+8, blat=SUBSTRING(bar FROM 3 FOR 6)' using DBD::DBM
ok 991 - parse ' /* NUMERIC FUNCTIONS */' using DBD::DBM
ok 992 - parse 'SELECT * FROM bar WHERE ABS(-4) = 4' using DBD::DBM
ok 993 - parse 'SELECT * FROM bar WHERE CEILING(-4.5) = -4' using DBD::DBM
ok 994 - parse 'SELECT * FROM bar WHERE CEIL(-4.9) = -4' using DBD::DBM
ok 995 - parse 'SELECT * FROM bar WHERE FLOOR(4.999999999999) = 4' using DBD::DBM
ok 996 - parse 'SELECT * FROM bar WHERE LOG(6) = LOG10(6)' using DBD::DBM
ok 997 - parse 'SELECT * FROM bar WHERE LN(1) = EXP(1)' using DBD::DBM
ok 998 - parse 'SELECT * FROM bar WHERE MOD(8, 5) = 3' using DBD::DBM
ok 999 - parse 'SELECT * FROM bar WHERE POWER(2, 4) = 16' using DBD::DBM
ok 1000 - parse 'SELECT * FROM bar WHERE POW(2, 4) = 16' using DBD::DBM
ok 1001 - parse 'SELECT * FROM bar WHERE RAND(2) = 0' using DBD::DBM
ok 1002 - parse 'SELECT * FROM bar WHERE RAND(2, UNIX_TIMESTAMP()) = 0' using DBD::DBM
ok 1003 - parse 'SELECT * FROM bar WHERE ROUND(4.999999999999) = 5' using DBD::DBM
ok 1004 - parse 'SELECT * FROM bar WHERE ROUND(4.542222222222, 1) = 4.5' using DBD::DBM
ok 1005 - parse 'SELECT * FROM bar WHERE SIGN(-25.5) = -1' using DBD::DBM
ok 1006 - parse 'SELECT * FROM bar WHERE SIGN(53645) = 1' using DBD::DBM
ok 1007 - parse 'SELECT * FROM bar WHERE SIGN(0) = 0' using DBD::DBM
ok 1008 - parse 'SELECT * FROM bar WHERE SIGN(NULL) = NULL' using DBD::DBM
ok 1009 - parse 'SELECT * FROM bar WHERE SQRT(64) = 8' using DBD::DBM
ok 1010 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.999999999999) = 4' using DBD::DBM
ok 1011 - parse 'SELECT * FROM bar WHERE TRUNC(-4.9) = -4' using DBD::DBM
ok 1012 - parse 'SELECT * FROM bar WHERE TRUNCATE(4.934, 1) = 4.9' using DBD::DBM
ok 1013 - parse 'SELECT * FROM bar WHERE TRUNC(-4.99999, 1) = -4.9' using DBD::DBM
ok 1014 - parse ' /* TRIGONOMETRIC FUNCTIONS */' using DBD::DBM
ok 1015 - parse 'SELECT * FROM test WHERE ACOS(x)' using DBD::DBM
ok 1016 - parse 'SELECT * FROM test WHERE ACOSEC(x)' using DBD::DBM
ok 1017 - parse 'SELECT * FROM test WHERE ACOSECH(x)' using DBD::DBM
ok 1018 - parse 'SELECT * FROM test WHERE ACOSH(x)' using DBD::DBM
ok 1019 - parse 'SELECT * FROM test WHERE ACOT(x)' using DBD::DBM
ok 1020 - parse 'SELECT * FROM test WHERE ACOTAN(x)' using DBD::DBM
ok 1021 - parse 'SELECT * FROM test WHERE ACOTANH(x)' using DBD::DBM
ok 1022 - parse 'SELECT * FROM test WHERE ACOTH(x)' using DBD::DBM
ok 1023 - parse 'SELECT * FROM test WHERE ACSC(x)' using DBD::DBM
ok 1024 - parse 'SELECT * FROM test WHERE ACSCH(x)' using DBD::DBM
ok 1025 - parse 'SELECT * FROM test WHERE ASEC(x)' using DBD::DBM
ok 1026 - parse 'SELECT * FROM test WHERE ASECH(x)' using DBD::DBM
ok 1027 - parse 'SELECT * FROM test WHERE ASIN(x)' using DBD::DBM
ok 1028 - parse 'SELECT * FROM test WHERE ASINH(x)' using DBD::DBM
ok 1029 - parse 'SELECT * FROM test WHERE ATAN(x)' using DBD::DBM
ok 1030 - parse 'SELECT * FROM test WHERE ATAN2(y, x)' using DBD::DBM
ok 1031 - parse 'SELECT * FROM test WHERE ATANH(x)' using DBD::DBM
ok 1032 - parse 'SELECT * FROM test WHERE COS(x)' using DBD::DBM
ok 1033 - parse 'SELECT * FROM test WHERE COSEC(x)' using DBD::DBM
ok 1034 - parse 'SELECT * FROM test WHERE COSECH(x)' using DBD::DBM
ok 1035 - parse 'SELECT * FROM test WHERE COSH(x)' using DBD::DBM
ok 1036 - parse 'SELECT * FROM test WHERE COT(x)' using DBD::DBM
ok 1037 - parse 'SELECT * FROM test WHERE COTAN(x)' using DBD::DBM
ok 1038 - parse 'SELECT * FROM test WHERE COTANH(x)' using DBD::DBM
ok 1039 - parse 'SELECT * FROM test WHERE COTH(x)' using DBD::DBM
ok 1040 - parse 'SELECT * FROM test WHERE CSC(x)' using DBD::DBM
ok 1041 - parse 'SELECT * FROM test WHERE CSCH(x)' using DBD::DBM
ok 1042 - parse 'SELECT * FROM test WHERE DEG2DEG(deg)' using DBD::DBM
ok 1043 - parse 'SELECT * FROM test WHERE RAD2RAD(rad)' using DBD::DBM
ok 1044 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad)' using DBD::DBM
ok 1045 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg)' using DBD::DBM
ok 1046 - parse 'SELECT * FROM test WHERE DEG2RAD(deg)' using DBD::DBM
ok 1047 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad)' using DBD::DBM
ok 1048 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad)' using DBD::DBM
ok 1049 - parse 'SELECT * FROM test WHERE RAD2DEG(rad)' using DBD::DBM
ok 1050 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad)' using DBD::DBM
ok 1051 - parse 'SELECT * FROM test WHERE DEGREES(rad)' using DBD::DBM
ok 1052 - parse 'SELECT * FROM test WHERE RADIANS(deg)' using DBD::DBM
ok 1053 - parse 'SELECT * FROM test WHERE DEG2DEG(deg, TRUE)' using DBD::DBM
ok 1054 - parse 'SELECT * FROM test WHERE RAD2RAD(rad, TRUE)' using DBD::DBM
ok 1055 - parse 'SELECT * FROM test WHERE GRAD2GRAD(grad, TRUE)' using DBD::DBM
ok 1056 - parse 'SELECT * FROM test WHERE DEG2GRAD(deg, TRUE)' using DBD::DBM
ok 1057 - parse 'SELECT * FROM test WHERE DEG2RAD(deg, TRUE)' using DBD::DBM
ok 1058 - parse 'SELECT * FROM test WHERE GRAD2DEG(grad, TRUE)' using DBD::DBM
ok 1059 - parse 'SELECT * FROM test WHERE GRAD2RAD(grad, TRUE)' using DBD::DBM
ok 1060 - parse 'SELECT * FROM test WHERE RAD2DEG(rad, TRUE)' using DBD::DBM
ok 1061 - parse 'SELECT * FROM test WHERE RAD2GRAD(rad, TRUE)' using DBD::DBM
ok 1062 - parse 'SELECT * FROM test WHERE DEGREES(rad, TRUE)' using DBD::DBM
ok 1063 - parse 'SELECT * FROM test WHERE RADIANS(deg, TRUE)' using DBD::DBM
ok 1064 - parse 'SELECT * FROM test WHERE PI()' using DBD::DBM
ok 1065 - parse 'SELECT * FROM test WHERE SEC(x)' using DBD::DBM
ok 1066 - parse 'SELECT * FROM test WHERE SECH(x)' using DBD::DBM
ok 1067 - parse 'SELECT * FROM test WHERE SIN(x)' using DBD::DBM
ok 1068 - parse 'SELECT * FROM test WHERE SINH(x)' using DBD::DBM
ok 1069 - parse 'SELECT * FROM test WHERE TAN(x)' using DBD::DBM
ok 1070 - parse 'SELECT * FROM test WHERE TANH(x)' using DBD::DBM
ok 1071 - parse ' /* SYSTEM FUNCTIONS */' using DBD::DBM
ok 1072 - parse 'SELECT * FROM ztable WHERE DBNAME() = foobar' using DBD::DBM
ok 1073 - parse 'SELECT * FROM ztable WHERE USERNAME() = foobar' using DBD::DBM
ok 1074 - parse 'SELECT * FROM ztable WHERE USER() = foobar' using DBD::DBM
ok 1075 - parse ' /* TABLE NAME ALIASES */' using DBD::DBM
ok 1076 - parse 'SELECT * FROM test as T1' using DBD::DBM
ok 1077 - parse 'SELECT * FROM test T1' using DBD::DBM
ok 1078 - parse 'SELECT T1.id, T2.num FROM test as T1 JOIN test2 as T2 USING(id)' using DBD::DBM
ok 1079 - parse 'SELECT id FROM test as T1 WHERE T1.num < 7' using DBD::DBM
ok 1080 - parse 'SELECT id FROM test as T1 ORDER BY T1.num' using DBD::DBM
ok 1081 - parse 'SELECT a.x,b.y FROM foo AS a, bar b WHERE a.baz = b.bop ORDER BY a.blat' using DBD::DBM
ok 1082 - parse ' /* NUMERIC EXPRESSIONS */' using DBD::DBM
ok 1083 - parse 'SELECT * FROM foo WHERE 1 = 0 AND baz < (6*foo+11-r)' using DBD::DBM
ok 1084 - parse ' /* CASE OF IDENTIFIERS */' using DBD::DBM
ok 1085 - parse 'SELECT ID, phRase FROM tEst AS tE WHERE te.id < 3 ORDER BY TE.phrasE' using DBD::DBM
ok 1086 - parse ' /* PARENS */' using DBD::DBM
ok 1087 - parse 'SELECT * FROM ztable WHERE NOT data IN ('one','two')' using DBD::DBM
ok 1088 - parse 'SELECT * from ztable WHERE (aaa > 'AAA')' using DBD::DBM
ok 1089 - parse 'SELECT * from ztable WHERE sev = 50 OR sev = 60' using DBD::DBM
ok 1090 - parse 'SELECT * from ztable WHERE (sev = 50 OR sev = 60)' using DBD::DBM
ok 1091 - parse 'SELECT * from ztable WHERE sev IN (50,60)' using DBD::DBM
ok 1092 - parse 'SELECT * from ztable WHERE rc > 200 AND ( sev IN(50,60) )' using DBD::DBM
ok 1093 - parse 'SELECT * FROM ztable WHERE data NOT IN ('one','two')' using DBD::DBM
ok 1094 - parse 'SELECT * from ztable WHERE (aaa > 'AAA') AND (zzz < 'ZZZ')' using DBD::DBM
ok 1095 - parse 'SELECT * from ztable WHERE (sev IN(50,60))' using DBD::DBM
ok 1096 - parse ' /* NOT */' using DBD::DBM
ok 1097 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND bop = 7 OR NOT blat = bar' using DBD::DBM
ok 1098 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR NOT blat = bar' using DBD::DBM
ok 1099 - parse 'SELECT * FROM foo WHERE NOT bar = 'baz' AND NOT bop = 7 OR blat IS NOT NULL' using DBD::DBM
ok 1100 - parse ' /* IN */' using DBD::DBM
ok 1101 - parse 'SELECT * FROM bar WHERE foo IN ('aa','ab','ba','bb')' using DBD::DBM
ok 1102 - parse 'SELECT * FROM bar WHERE foo IN (3.14,2.72,1.41,9.81)' using DBD::DBM
ok 1103 - parse 'SELECT * FROM bar WHERE foo NOT IN ('aa','ab','ba','bb')' using DBD::DBM
ok 1104 - parse 'SELECT * FROM bar WHERE foo NOT IN (3.14,2.72,1.41,9.81)' using DBD::DBM
ok 1105 - parse ' /* BETWEEN */' using DBD::DBM
ok 1106 - parse 'SELECT * FROM bar WHERE foo BETWEEN ('aa','bb')' using DBD::DBM
ok 1107 - parse 'SELECT * FROM bar WHERE foo BETWEEN (1.41,9.81)' using DBD::DBM
ok 1108 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN ('aa','bb')' using DBD::DBM
ok 1109 - parse 'SELECT * FROM bar WHERE foo NOT BETWEEN (1.41,9.81)' using DBD::DBM
not ok 1110 - parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using DBD::DBM # TODO Analyze failures
# Failed (TODO) test 'parse 'UPDATE foo SET bar=REPEAT(status, BIT_LENGTH(str)), bop=7, bump=bar+POSITION(str1, str2), blat=SUBSTRING(bar FROM ASCII(status) FOR CHAR_LENGTH(str))' using DBD::DBM'
# at t/01prepare.t line 312.
# Incomplete SET clause!
not ok 1111 - parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::DBM # TODO Analyze failures
# Failed (TODO) test 'parse 'SELECT * FROM bar WHERE EXP(1) = SINH(1)+COSH(1)' using DBD::DBM'
# at t/01prepare.t line 312.
#
# Execution ERROR: Unknown predicate '{$VAR1 = {};
# }' called from C:/cpanfly-5.24-32/var/megalib/DBI/DBD/SqlEngine.pm at 335.
#
not ok 1112 - parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::DBM # TODO Analyze failures
# Failed (TODO) test 'parse 'SELECT * FROM bar WHERE LOG(8, 2) = LOG10(8) / LOG10(2)' using DBD::DBM'
# at t/01prepare.t line 312.
#
# Execution ERROR: Unknown predicate '{$VAR1 = {};
# }' called from C:/cpanfly-5.24-32/var/megalib/DBI/DBD/SqlEngine.pm at 335.
#
ok 1113 - $sth->new
ok 1114 - $sth->command
ok 1115 - $sth->params
ok 1116 - $sth->tables
ok 1117 - $sth->where()->op
ok 1118 - $sth->where()->left
ok 1119 - $sth->where()->left->left
ok 1120 - $sth->where()->left->right
ok 1121 - $sth->limit
ok 1122 - $sth->offset
# Command SELECT
# Num Pholders 1
# Columns
# Tables SQL::Statement::Table=HASH(0x36708fc),SQL::Statement::Table=HASH(0x36714cc)
# Where op AND
# Limit 2
# Offset 5
# Order Cols f,g
ok 1123 - $stmt->row_values()
ok 1124 - $stmt->row_values(0)
ok 1125 - $stmt->row_values(0,1)
ok 1126 - structure
ok 1127 - command
ok 1128 - distinct
1..1128
ok
t/02execute.t ...
# # Using required:
# # SQL::Statement: 1.41
# # Using recommended:
# # DBD::CSV: 0.49
# # DBD::DBM: 0.08
# # DBD::File: 0.44
# # DBI: 1.636
# # MLDBM: 2.05
# Running tests for SQL::Statement
ok 1 - CREATE Tmp
ok 2 - placeholder insert with named cols
ok 3 - placeholder insert without named cols
ok 4 - placeholder delete
ok 5 - placeholder update
ok 6 - placeholder update
ok 7 - multiline insert
ok 8 - prepare 'SELECT id,phrase FROM Tmp ORDER BY id'
ok 9 - verify table contents
ok 10 - prepare 'SELECT id,phrase FROM Tmp WHERE (id or id>?) and phrase LIKE ? ORDER BY id'
ok 11 - verify placeholder processing
ok 12 - DROP TABLE
ok 13 - CREATE
ok 14 - INSERT
ok 15 - INSERT
ok 16 - INSERT
ok 17 - UPDATE
ok 18 - DELETE
ok 19 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase'
ok 20 - SELECT
ok 21 - COUNT *
ok 22 - DROP TEMP TABLE
ok 23 - COMPUTED COLUMNS IN SELECT LIST
ok 24 - CREATE FUNCTION from script
# < CREATE TEMP TABLE a (b INT, c CHAR)>
ok 25 - $stmt->execute " CREATE TEMP TABLE a (b INT, c CHAR)" (CREATE)
# < INSERT INTO a VALUES(1,'abc')>
ok 26 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT)
# < INSERT INTO a VALUES(2,'efg')>
ok 27 - $stmt->execute " INSERT INTO a VALUES(2,'efg')" (INSERT)
# < INSERT INTO a VALUES(3,'hij')>
ok 28 - $stmt->execute " INSERT INTO a VALUES(3,'hij')" (INSERT)
# < INSERT INTO a VALUES(4,'klm')>
ok 29 - $stmt->execute " INSERT INTO a VALUES(4,'klm')" (INSERT)
# < INSERT INTO a VALUES(5,'nmo')>
ok 30 - $stmt->execute " INSERT INTO a VALUES(5,'nmo')" (INSERT)
# < INSERT INTO a VALUES(6,'pqr')>
ok 31 - $stmt->execute " INSERT INTO a VALUES(6,'pqr')" (INSERT)
# < INSERT INTO a VALUES(7,'stu')>
ok 32 - $stmt->execute " INSERT INTO a VALUES(7,'stu')" (INSERT)
# < INSERT INTO a VALUES(8,'vwx')>
ok 33 - $stmt->execute " INSERT INTO a VALUES(8,'vwx')" (INSERT)
# < INSERT INTO a VALUES(9,'yz')>
ok 34 - $stmt->execute " INSERT INTO a VALUES(9,'yz')" (INSERT)
# < SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC">
ok 35 - $stmt->execute " SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"" (SELECT)
ok 36 - $stmt->where_hash
ok 37 - $stmt->columns
ok 38 - $stmt->column_names
ok 39 - $stmt->order
ok 40 - $stmt->fetch
ok 41 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT)
ok 42 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)
ok 43 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT)
ok 44 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')
ok 45 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT)
ok 46 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')
ok 47 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT)
ok 48 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)
ok 49 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT)
ok 50 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)
ok 51 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT)
ok 52 - SELECT b,c FROM a WHERE b BETWEEN (5,7)
ok 53 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT)
ok 54 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')
ok 55 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT)
ok 56 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')
ok 57 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT)
ok 58 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')
ok 59 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT)
ok 60 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')
ok 61 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT)
ok 62 - SELECT b,c FROM a WHERE b IN (2,3,5,7)
ok 63 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT)
ok 64 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)
ok 65 - CREATE FUNCTION from module
ok 66 - CREATE FUNCTION from module with argument
ok 67 - LOAD FUNCTIONS
ok 68 - CREATE pauli test table
ok 69 - UPDATE with placeholders
ok 70 - UPDATE with placeholder updates correct
# Running tests for DBD::File
ok 71 - CREATE Tmp
ok 72 - placeholder insert with named cols
ok 73 - placeholder insert without named cols
ok 74 - placeholder delete
ok 75 - placeholder update
ok 76 - placeholder update
ok 77 - multiline insert
ok 78 - prepare 'SELECT id,phrase FROM Tmp ORDER BY id'
ok 79 - verify table contents
ok 80 - prepare 'SELECT id,phrase FROM Tmp WHERE (id or id>?) and phrase LIKE ? ORDER BY id'
ok 81 - verify placeholder processing
ok 82 - DROP TABLE
ok 83 - CREATE
ok 84 - INSERT
ok 85 - INSERT
ok 86 - INSERT
ok 87 - UPDATE
ok 88 - DELETE
ok 89 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase'
ok 90 - SELECT
ok 91 - COUNT *
ok 92 - DROP TEMP TABLE
ok 93 - COMPUTED COLUMNS IN SELECT LIST
ok 94 - CREATE FUNCTION from script
# < CREATE TEMP TABLE a (b INT, c CHAR)>
ok 95 - $stmt->execute " CREATE TEMP TABLE a (b INT, c CHAR)" (CREATE)
# < INSERT INTO a VALUES(1,'abc')>
ok 96 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT)
# < INSERT INTO a VALUES(2,'efg')>
ok 97 - $stmt->execute " INSERT INTO a VALUES(2,'efg')" (INSERT)
# < INSERT INTO a VALUES(3,'hij')>
ok 98 - $stmt->execute " INSERT INTO a VALUES(3,'hij')" (INSERT)
# < INSERT INTO a VALUES(4,'klm')>
ok 99 - $stmt->execute " INSERT INTO a VALUES(4,'klm')" (INSERT)
# < INSERT INTO a VALUES(5,'nmo')>
ok 100 - $stmt->execute " INSERT INTO a VALUES(5,'nmo')" (INSERT)
# < INSERT INTO a VALUES(6,'pqr')>
ok 101 - $stmt->execute " INSERT INTO a VALUES(6,'pqr')" (INSERT)
# < INSERT INTO a VALUES(7,'stu')>
ok 102 - $stmt->execute " INSERT INTO a VALUES(7,'stu')" (INSERT)
# < INSERT INTO a VALUES(8,'vwx')>
ok 103 - $stmt->execute " INSERT INTO a VALUES(8,'vwx')" (INSERT)
# < INSERT INTO a VALUES(9,'yz')>
ok 104 - $stmt->execute " INSERT INTO a VALUES(9,'yz')" (INSERT)
# < SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC">
ok 105 - $stmt->execute " SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"" (SELECT)
ok 106 - $stmt->where_hash
ok 107 - $stmt->columns
ok 108 - $stmt->column_names
ok 109 - $stmt->order
ok 110 - $stmt->fetch
ok 111 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT)
ok 112 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')
ok 113 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT)
ok 114 - SELECT b,c FROM a WHERE b IN (2,3,5,7)
ok 115 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT)
ok 116 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)
ok 117 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT)
ok 118 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')
ok 119 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT)
ok 120 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')
ok 121 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT)
ok 122 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')
ok 123 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT)
ok 124 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)
ok 125 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT)
ok 126 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)
ok 127 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT)
ok 128 - SELECT b,c FROM a WHERE b BETWEEN (5,7)
ok 129 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT)
ok 130 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')
ok 131 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT)
ok 132 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')
ok 133 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT)
ok 134 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)
ok 135 - CREATE FUNCTION from module
ok 136 - CREATE FUNCTION from module with argument
ok 137 - LOAD FUNCTIONS
ok 138 - CREATE pauli test table
ok 139 - UPDATE with placeholders
ok 140 - UPDATE with placeholder updates correct
# Running tests for DBD::DBM
ok 141 - CREATE Tmp
ok 142 - placeholder insert with named cols
ok 143 - placeholder insert without named cols
ok 144 - placeholder delete
ok 145 - placeholder update
ok 146 - placeholder update
ok 147 - multiline insert
ok 148 - prepare 'SELECT id,phrase FROM Tmp ORDER BY id'
ok 149 - verify table contents
ok 150 - prepare 'SELECT id,phrase FROM Tmp WHERE (id or id>?) and phrase LIKE ? ORDER BY id'
ok 151 - verify placeholder processing
ok 152 - DROP TABLE
ok 153 - CREATE
ok 154 - INSERT
ok 155 - INSERT
ok 156 - INSERT
ok 157 - UPDATE
ok 158 - DELETE
ok 159 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase'
ok 160 - SELECT
ok 161 - COUNT *
ok 162 - DROP TABLE
ok 163 - COMPUTED COLUMNS IN SELECT LIST
ok 164 - CREATE FUNCTION from script
# < CREATE TABLE a (b INT, c CHAR)>
ok 165 - $stmt->execute " CREATE TABLE a (b INT, c CHAR)" (CREATE)
# < INSERT INTO a VALUES(1,'abc')>
ok 166 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT)
# < INSERT INTO a VALUES(2,'efg')>
ok 167 - $stmt->execute " INSERT INTO a VALUES(2,'efg')" (INSERT)
# < INSERT INTO a VALUES(3,'hij')>
ok 168 - $stmt->execute " INSERT INTO a VALUES(3,'hij')" (INSERT)
# < INSERT INTO a VALUES(4,'klm')>
ok 169 - $stmt->execute " INSERT INTO a VALUES(4,'klm')" (INSERT)
# < INSERT INTO a VALUES(5,'nmo')>
ok 170 - $stmt->execute " INSERT INTO a VALUES(5,'nmo')" (INSERT)
# < INSERT INTO a VALUES(6,'pqr')>
ok 171 - $stmt->execute " INSERT INTO a VALUES(6,'pqr')" (INSERT)
# < INSERT INTO a VALUES(7,'stu')>
ok 172 - $stmt->execute " INSERT INTO a VALUES(7,'stu')" (INSERT)
# < INSERT INTO a VALUES(8,'vwx')>
ok 173 - $stmt->execute " INSERT INTO a VALUES(8,'vwx')" (INSERT)
# < INSERT INTO a VALUES(9,'yz')>
ok 174 - $stmt->execute " INSERT INTO a VALUES(9,'yz')" (INSERT)
# < SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC">
ok 175 - $stmt->execute " SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"" (SELECT)
ok 176 - $stmt->where_hash
ok 177 - $stmt->columns
ok 178 - $stmt->column_names
ok 179 - $stmt->order
ok 180 - $stmt->fetch
ok 181 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT)
ok 182 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')
ok 183 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT)
ok 184 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')
ok 185 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT)
ok 186 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')
ok 187 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT)
ok 188 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')
ok 189 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT)
ok 190 - SELECT b,c FROM a WHERE b IN (2,3,5,7)
ok 191 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT)
ok 192 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)
ok 193 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT)
ok 194 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')
ok 195 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT)
ok 196 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)
ok 197 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT)
ok 198 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)
ok 199 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT)
ok 200 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)
ok 201 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT)
ok 202 - SELECT b,c FROM a WHERE b BETWEEN (5,7)
ok 203 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT)
ok 204 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')
ok 205 - CREATE FUNCTION from module
ok 206 - CREATE FUNCTION from module with argument
ok 207 - LOAD FUNCTIONS
ok 208 - CREATE pauli test table
ok 209 - UPDATE with placeholders
ok 210 - UPDATE with placeholder updates correct
# Running tests for DBD::CSV
ok 211 - CREATE Tmp
ok 212 - placeholder insert with named cols
ok 213 - placeholder insert without named cols
ok 214 - placeholder delete
ok 215 - placeholder update
ok 216 - placeholder update
ok 217 - multiline insert
ok 218 - prepare 'SELECT id,phrase FROM Tmp ORDER BY id'
ok 219 - verify table contents
ok 220 - prepare 'SELECT id,phrase FROM Tmp WHERE (id or id>?) and phrase LIKE ? ORDER BY id'
ok 221 - verify placeholder processing
ok 222 - DROP TABLE
ok 223 - CREATE
ok 224 - INSERT
ok 225 - INSERT
ok 226 - INSERT
ok 227 - UPDATE
ok 228 - DELETE
ok 229 - prepare 'SELECT UPPER('a') AS A,phrase FROM phrase'
ok 230 - SELECT
ok 231 - COUNT *
ok 232 - DROP TABLE
ok 233 - COMPUTED COLUMNS IN SELECT LIST
ok 234 - CREATE FUNCTION from script
# < CREATE TABLE a (b INT, c CHAR)>
ok 235 - $stmt->execute " CREATE TABLE a (b INT, c CHAR)" (CREATE)
# < INSERT INTO a VALUES(1,'abc')>
ok 236 - $stmt->execute " INSERT INTO a VALUES(1,'abc')" (INSERT)
# < INSERT INTO a VALUES(2,'efg')>
ok 237 - $stmt->execute " INSERT INTO a VALUES(2,'efg')" (INSERT)
# < INSERT INTO a VALUES(3,'hij')>
ok 238 - $stmt->execute " INSERT INTO a VALUES(3,'hij')" (INSERT)
# < INSERT INTO a VALUES(4,'klm')>
ok 239 - $stmt->execute " INSERT INTO a VALUES(4,'klm')" (INSERT)
# < INSERT INTO a VALUES(5,'nmo')>
ok 240 - $stmt->execute " INSERT INTO a VALUES(5,'nmo')" (INSERT)
# < INSERT INTO a VALUES(6,'pqr')>
ok 241 - $stmt->execute " INSERT INTO a VALUES(6,'pqr')" (INSERT)
# < INSERT INTO a VALUES(7,'stu')>
ok 242 - $stmt->execute " INSERT INTO a VALUES(7,'stu')" (INSERT)
# < INSERT INTO a VALUES(8,'vwx')>
ok 243 - $stmt->execute " INSERT INTO a VALUES(8,'vwx')" (INSERT)
# < INSERT INTO a VALUES(9,'yz')>
ok 244 - $stmt->execute " INSERT INTO a VALUES(9,'yz')" (INSERT)
# < SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC">
ok 245 - $stmt->execute " SELECT b,c FROM a WHERE c LIKE '%b%' ORDER BY c DESC"" (SELECT)
ok 246 - $stmt->where_hash
ok 247 - $stmt->columns
ok 248 - $stmt->column_names
ok 249 - $stmt->order
ok 250 - $stmt->fetch
ok 251 - $stmt->execute "SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')" (SELECT)
ok 252 - SELECT b,c FROM a WHERE c BETWEEN ('abc','nmo')
ok 253 - $stmt->execute "SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')" (SELECT)
ok 254 - SELECT b,c FROM a WHERE c NOT BETWEEN ('abc','nmo')
ok 255 - $stmt->execute "SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')" (SELECT)
ok 256 - SELECT b,c FROM a WHERE NOT c IN ('abc','klm','pqr','vwx','yz')
ok 257 - $stmt->execute "SELECT b,c FROM a WHERE b IN (2,3,5,7)" (SELECT)
ok 258 - SELECT b,c FROM a WHERE b IN (2,3,5,7)
ok 259 - $stmt->execute "SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')" (SELECT)
ok 260 - SELECT b,c FROM a WHERE NOT c BETWEEN ('abc','nmo')
ok 261 - $stmt->execute "SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)" (SELECT)
ok 262 - SELECT b,c FROM a WHERE NOT b IN (2,3,5,7)
ok 263 - $stmt->execute "SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)" (SELECT)
ok 264 - SELECT b,c FROM a WHERE b NOT IN (2,3,5,7)
ok 265 - $stmt->execute "SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')" (SELECT)
ok 266 - SELECT b,c FROM a WHERE c NOT IN ('abc','klm','pqr','vwx','yz')
ok 267 - $stmt->execute "SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')" (SELECT)
ok 268 - SELECT b,c FROM a WHERE c IN ('abc','klm','pqr','vwx','yz')
ok 269 - $stmt->execute "SELECT b,c FROM a WHERE b BETWEEN (5,7)" (SELECT)
ok 270 - SELECT b,c FROM a WHERE b BETWEEN (5,7)
ok 271 - $stmt->execute "SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)" (SELECT)
ok 272 - SELECT b,c FROM a WHERE b NOT BETWEEN (5,7)
ok 273 - $stmt->execute "SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)" (SELECT)
ok 274 - SELECT b,c FROM a WHERE NOT b BETWEEN (5,7)
ok 275 - CREATE FUNCTION from module
ok 276 - CREATE FUNCTION from module with argument
ok 277 - LOAD FUNCTIONS
ok 278 - CREATE pauli test table
ok 279 - UPDATE with placeholders
ok 280 - UPDATE with placeholder updates correct
1..280
ok
cannot unlink file for C:\cpanfly-5.24-32\var\tmp\cpan_build\SQL-Statement-1.410-ixKZe_\test_output_3196\sqlite.db: Permission denied at t/TestLib.pm line 20.
cannot remove directory for C:\cpanfly-5.24-32\var\tmp\cpan_build\SQL-Statement-1.410-ixKZe_\test_output_3196: Directory not empty at t/TestLib.pm line 20.
t/03import.t ....
# # Using required:
# # SQL::Statement: 1.41
# # Using recommended:
# # DBD::CSV: 0.49
# # DBD::DBM: 0.08
# # DBD::File: 0.44
# # DBD::SQLite: 1.5
# # DBI: 1.636
# # MLDBM: 2.05
# Running tests for SQL::Statement
ok 1 - IMPORT($AoA)
ok 2 - IMPORT($AoH)
ok 3 # skip Need DBI statement handle - can't use when executing direct
ok 4 # skip Need DBI statement handle - can't use when executing direct
ok 5 # skip Need DBI statement handle - can't use when executing direct
ok 6 # skip Need DBI statement handle - can't use when executing direct
ok 7 # skip Need DBI statement handle - can't use when executing direct
ok 8 # skip Need DBI statement handle - can't use when executing direct
ok 9 # skip Need DBI statement handle - can't use when executing direct
ok 10 - SELECT IMPORT($external_sth)
ok 11 # skip Need DBI statement handle - can't use when executing direct
ok 12 # skip Need DBI statement handle - can't use when executing direct
# Running tests for DBD::DBM
ok 13 - IMPORT($AoA)
ok 14 - IMPORT($AoH)
ok 15 - CREATE AS IMPORT($aoh)
ok 16 - SELECT FROM IMPORTED($AoH)
ok 17 - CREATE AS IMPORT($aoa)
ok 18 - SELECT FROM IMPORTED($AoA)
ok 19 - CREATE AS SELECT *
ok 20 - SELECT FROM "SELECTED(*)" tbl_copy
ok 21 - CREATE AS SELECT * with quoted restriction
ok 22 - SELECT FROM "SELECTED(*)" tbl_extract
ok 23 - IMPORT($internal_sth)
ok 24 - SELECT IMPORT($external_sth)
ok 25 - CREATE AS IMPORT($sth)
ok 26 - SELECT FROM IMPORTED ($external_sth)
# Running tests for DBD::CSV
ok 27 - IMPORT($AoA)
ok 28 - IMPORT($AoH)
ok 29 - CREATE AS IMPORT($aoh)
ok 30 - SELECT FROM IMPORTED($AoH)
ok 31 - CREATE AS IMPORT($aoa)
ok 32 - SELECT FROM IMPORTED($AoA)
ok 33 - CREATE AS SELECT *
ok 34 - SELECT FROM "SELECTED(*)" tbl_copy
ok 35 - CREATE AS SELECT * with quoted restriction
ok 36 - SELECT FROM "SELECTED(*)" tbl_extract
ok 37 - IMPORT($internal_sth)
ok 38 - SELECT IMPORT($external_sth)
ok 39 - CREATE AS IMPORT($sth)
ok 40 - SELECT FROM IMPORTED ($external_sth)
# Running tests for DBD::File
ok 41 - IMPORT($AoA)
ok 42 - IMPORT($AoH)
ok 43 - CREATE AS IMPORT($aoh)
ok 44 - SELECT FROM IMPORTED($AoH)
ok 45 - CREATE AS IMPORT($aoa)
ok 46 - SELECT FROM IMPORTED($AoA)
ok 47 - CREATE AS SELECT *
ok 48 - SELECT FROM "SELECTED(*)" tbl_copy
ok 49 - CREATE AS SELECT * with quoted restriction
ok 50 - SELECT FROM "SELECTED(*)" tbl_extract
ok 51 - IMPORT($internal_sth)
ok 52 - SELECT IMPORT($external_sth)
ok 53 - CREATE AS IMPORT($sth)
ok 54 - SELECT FROM IMPORTED ($external_sth)
1..54
ok
t/04idents.t ....
# # Using required:
# # SQL::Statement: 1.41
# # Using recommended:
# # DBD::CSV: 0.49
# # DBD::DBM: 0.08
# # DBD::File: 0.44
# # DBD::SQLite: 1.5
# # DBI: 1.636
# Running tests for SQL::Statement
ok 1 - Column Names: select list = *
ok 2 - Column Names: select list = named
ok 3 - Column Names: select list = aliased
ok 4 - Column Names: select list with function
ok 5 - Column Names: select list with function = aliased
ok 6 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased)
ok 7 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (camelcased)
ok 8 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (reserved names)
ok 9 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (reserved names)
ok 10 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (not quoted)
ok 11 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (not quoted)
ok 12 - ->{all_cols} structure does not grow beyond control
ok 13 - execute for 'lower/lower'
ok 14 - lower/lower
ok 15 - execute for 'lower/upper'
ok 16 - lower/upper
ok 17 - execute for 'lower/mixed'
ok 18 - lower/mixed
ok 19 - execute for 'lower/asterisked'
ok 20 - lower/asterisked
ok 21 - execute for 'upper/lower'
ok 22 - upper/lower
ok 23 - execute for 'upper/upper'
ok 24 - upper/upper
ok 25 - execute for 'upper/mixed'
ok 26 - upper/mixed
ok 27 - execute for 'upper/asterisked'
ok 28 - upper/asterisked
ok 29 - execute for 'mixed/lower'
ok 30 - mixed/lower
ok 31 - execute for 'mixed/upper'
ok 32 - mixed/upper
ok 33 - execute for 'mixed/mixed'
ok 34 - mixed/mixed
ok 35 - execute for 'mixed/asterisked'
ok 36 - mixed/asterisked
ok 37 # skip Need DBI statement handle - can't use when executing direct
# Running tests for DBD::CSV
ok 38 - Column Names: select list = *
ok 39 - Column Names: select list = named
ok 40 - Column Names: select list = aliased
ok 41 - Column Names: select list with function
ok 42 - Column Names: select list with function = aliased
ok 43 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased)
ok 44 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (camelcased)
ok 45 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (reserved names)
ok 46 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (reserved names)
ok 47 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (not quoted)
ok 48 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (not quoted)
ok 49 - ->{all_cols} structure does not grow beyond control
ok 50 - execute for 'lower/lower'
ok 51 - lower/lower
ok 52 - execute for 'lower/upper'
ok 53 - lower/upper
ok 54 - execute for 'lower/mixed'
ok 55 - lower/mixed
ok 56 - execute for 'lower/asterisked'
ok 57 - lower/asterisked
ok 58 - execute for 'upper/lower'
ok 59 - upper/lower
ok 60 - execute for 'upper/upper'
ok 61 - upper/upper
ok 62 - execute for 'upper/mixed'
ok 63 - upper/mixed
ok 64 - execute for 'upper/asterisked'
ok 65 - upper/asterisked
ok 66 - execute for 'mixed/lower'
ok 67 - mixed/lower
ok 68 - execute for 'mixed/upper'
ok 69 - mixed/upper
ok 70 - execute for 'mixed/mixed'
ok 71 - mixed/mixed
ok 72 - execute for 'mixed/asterisked'
ok 73 - mixed/asterisked
ok 74 - imported table : lower
ok 75 - imported table : upper
ok 76 - imported table : mixed
ok 77 - imported table : asterisked
# Running tests for DBD::DBM
ok 78 - Column Names: select list = *
ok 79 - Column Names: select list = named
ok 80 - Column Names: select list = aliased
ok 81 - Column Names: select list with function
ok 82 - Column Names: select list with function = aliased
ok 83 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased)
ok 84 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (camelcased)
ok 85 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (reserved names)
ok 86 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (reserved names)
ok 87 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (not quoted)
ok 88 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (not quoted)
ok 89 - ->{all_cols} structure does not grow beyond control
ok 90 - execute for 'lower/lower'
ok 91 - lower/lower
ok 92 - execute for 'lower/upper'
ok 93 - lower/upper
ok 94 - execute for 'lower/mixed'
ok 95 - lower/mixed
ok 96 - execute for 'lower/asterisked'
ok 97 - lower/asterisked
ok 98 - execute for 'upper/lower'
ok 99 - upper/lower
ok 100 - execute for 'upper/upper'
ok 101 - upper/upper
ok 102 - execute for 'upper/mixed'
ok 103 - upper/mixed
ok 104 - execute for 'upper/asterisked'
ok 105 - upper/asterisked
ok 106 - execute for 'mixed/lower'
ok 107 - mixed/lower
ok 108 - execute for 'mixed/upper'
ok 109 - mixed/upper
ok 110 - execute for 'mixed/mixed'
ok 111 - mixed/mixed
ok 112 - execute for 'mixed/asterisked'
ok 113 - mixed/asterisked
ok 114 - imported table : lower
ok 115 - imported table : upper
ok 116 - imported table : mixed
ok 117 - imported table : asterisked
# Running tests for DBD::File
ok 118 - Column Names: select list = *
ok 119 - Column Names: select list = named
ok 120 - Column Names: select list = aliased
ok 121 - Column Names: select list with function
ok 122 - Column Names: select list with function = aliased
ok 123 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (camelcased)
ok 124 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (camelcased)
ok 125 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (reserved names)
ok 126 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (reserved names)
ok 127 - Raw SQL hidden absent from column name [rt.cpan.org \#34121] (not quoted)
ok 128 - Raw SQL hidden absent from table name [rt.cpan.org \#34121] (not quoted)
ok 129 - ->{all_cols} structure does not grow beyond control
ok 130 - execute for 'lower/lower'
ok 131 - lower/lower
ok 132 - execute for 'lower/upper'
ok 133 - lower/upper
ok 134 - execute for 'lower/mixed'
ok 135 - lower/mixed
ok 136 - execute for 'lower/asterisked'
ok 137 - lower/asterisked
ok 138 - execute for 'upper/lower'
ok 139 - upper/lower
ok 140 - execute for 'upper/upper'
ok 141 - upper/upper
ok 142 - execute for 'upper/mixed'
ok 143 - upper/mixed
ok 144 - execute for 'upper/asterisked'
ok 145 - upper/asterisked
ok 146 - execute for 'mixed/lower'
ok 147 - mixed/lower
ok 148 - execute for 'mixed/upper'
ok 149 - mixed/upper
ok 150 - execute for 'mixed/mixed'
ok 151 - mixed/mixed
ok 152 - execute for 'mixed/asterisked'
ok 153 - mixed/asterisked
ok 154 - imported table : lower
ok 155 - imported table : upper
ok 156 - imported table : mixed
ok 157 - imported table : asterisked
1..157
ok
t/05simple.t ....
# # Using required:
# # SQL::Statement: 1.41
# # Using recommended:
# # DBD::CSV: 0.49
# # DBD::DBM: 0.08
# # DBD::File: 0.44
# # DBI: 1.636
# # MLDBM: 2.05
# Running tests for SQL::Statement
ok 1 - prepare