X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F11parser.t;h=eaf5616cfd1b86b0cbf72f31ccbe74127000b4fe;hb=c84a43217912905d7fdab027f7ca8641003665ea;hp=8735ffedb0d568b5222a9ba09f152aae2f0a56a6;hpb=3cb8f017c8746fa9c688540f3e8bda09363bda09;p=dbsrgits%2FSQL-Abstract.git diff --git a/t/11parser.t b/t/11parser.t index 8735ffe..eaf5616 100644 --- a/t/11parser.t +++ b/t/11parser.t @@ -619,7 +619,7 @@ is_deeply($sqlat->parse("SELECT x, y FROM foo WHERE x IN (?, ?, ?, ?)"), [ ] ], 'Lists parsed correctly'); -is_deeply($sqlat->parse('SELECT foo FROM bar ORDER BY x + ? DESC, oomph, y - ? DESC, unf, baz.g / ? ASC, buzz * 0 DESC, foo DESC, ickk ASC'), [ +is_deeply($sqlat->parse('SELECT foo FROM bar ORDER BY x + ? DESC, oomph, y - ? DESC, unf, baz.g / ? ASC, buzz * 0 DESC, foo LIKE ? DESC, ickk ASC'), [ [ "SELECT", [ @@ -776,11 +776,22 @@ is_deeply($sqlat->parse('SELECT foo FROM bar ORDER BY x + ? DESC, oomph, y - ? D "-DESC", [ [ - "-LITERAL", + "LIKE", [ - "foo" - ] - ] + [ + "-LITERAL", + [ + "foo" + ] + ], + [ + "-PLACEHOLDER", + [ + "?" + ] + ], + ], + ], ] ], [ @@ -1109,19 +1120,16 @@ is_deeply( $sqlat->parse("META SELECT * * FROM (SELECT *, FROM foobar baz buzz) ], ], [ - "max", - [ - [ "-DESC", [ [ "-MISC", [ [ - "-MISC", + "-DESC", [ [ - "-DESC", + "max", [ [ "-PAREN", @@ -1134,22 +1142,20 @@ is_deeply( $sqlat->parse("META SELECT * * FROM (SELECT *, FROM foobar baz buzz) ] ] ] - ] - ], - [ - "-LITERAL", - [ - "x" - ] - ], + ], + ] ] ], [ "-LITERAL", [ - "z" + "x" ] - ] + ], + [ + "-LITERAL", + [ + "z" ] ] ]