X-Git-Url: http://git.shadowcat.co.uk/gitweb/gitweb.cgi?a=blobdiff_plain;f=t%2F10test.t;h=d099cbd47631b8577760d3fc08270587df43be8f;hb=1b17d1b00216d488c5383096a8fdc5264492a6b0;hp=8f1ceae06612d80ae8f794a72724196d0539dc0e;hpb=56c0595d3a2f88097f6d985a3f12261632c3bf96;p=scpubgit%2FQ-Branch.git diff --git a/t/10test.t b/t/10test.t index 8f1ceae..d099cbd 100644 --- a/t/10test.t +++ b/t/10test.t @@ -99,20 +99,28 @@ my @sql_tests = ( }, { equal => 1, - todo => '( (x AND y) AND z ) should be reducable to ( x AND y AND z )', statements => [ q/SELECT foo FROM bar WHERE a = 1 AND b = 1 AND c = 1/, q/SELECT foo FROM bar WHERE (a = 1 AND b = 1) AND c = 1/, q/SELECT foo FROM bar WHERE a = 1 AND (b = 1 AND c = 1)/, + q/SELECT foo FROM bar WHERE ((((a = 1))) AND (b = 1 AND c = 1))/, ] }, { equal => 1, - todo => '( (x OR y) OR z ) should be reducable to ( x OR y OR z )', statements => [ q/SELECT foo FROM bar WHERE a = 1 OR b = 1 OR c = 1/, q/SELECT foo FROM bar WHERE (a = 1 OR b = 1) OR c = 1/, q/SELECT foo FROM bar WHERE a = 1 OR (b = 1 OR c = 1)/, + q/SELECT foo FROM bar WHERE a = 1 OR ((b = 1 OR (c = 1)))/, + ] + }, + { + equal => 1, + statements => [ + q/SELECT foo FROM bar WHERE (a = 1) AND (b = 1 OR c = 1 OR d = 1) AND (e = 1 AND f = 1)/, + q/SELECT foo FROM bar WHERE a = 1 AND (b = 1 OR c = 1 OR d = 1) AND e = 1 AND (f = 1)/, + q/SELECT foo FROM bar WHERE ( ((a = 1) AND ( b = 1 OR (c = 1 OR d = 1) )) AND ((e = 1)) AND f = 1) /, ] },