Changeset: a041bfde23a3 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=a041bfde23a3 Modified Files: sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.sql sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.stable.out Branch: Jul2015 Log Message:
Extended the test a bit to also include the combined NOT x NOT LIKE y diffs (27 lines): diff --git a/sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.sql b/sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.sql --- a/sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.sql +++ b/sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.sql @@ -7,4 +7,7 @@ SELECT * FROM foo WHERE NOT col LIKE 'b% -- This query works: SELECT * FROM foo WHERE (col NOT LIKE 'b%'); +-- Also test the combination: +SELECT * FROM foo WHERE NOT col NOT like 'b%'; + DROP TABLE foo; diff --git a/sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.stable.out b/sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.stable.out --- a/sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.stable.out +++ b/sql/test/BugTracker-2015/Tests/NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871.stable.out @@ -75,6 +75,12 @@ Ready. % col # name % char # type % 8 # length +#SELECT * FROM foo WHERE NOT col NOT like 'b%'; +% sys.foo # table_name +% col # name +% char # type +% 8 # length +[ "bee" ] #DROP TABLE foo; # 13:02:55 > _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
