Changeset: 022c39d34058 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=022c39d34058 Added Files: sql/test/BugTracker-2016/Tests/simpletest.sql Branch: default Log Message:
Added a simple test The SQL parser should not forbid IF expressions that can be used in a SET command diffs (39 lines): diff --git a/sql/test/BugTracker-2016/Tests/simpletest.sql b/sql/test/BugTracker-2016/Tests/simpletest.sql new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2016/Tests/simpletest.sql @@ -0,0 +1,34 @@ +create table simple1(i integer); + +insert into simple values(1); + +create procedure correct() +begin + declare b boolean; + declare i integer; + set i = (select count(*)); + set b= (i>0); + if (b) + then + insert into simple1 values(2); + end if; +end; + +create procedure correct1() +begin + declare b boolean; + set b= (select count(*)>0); + if (b) + then + insert into simple1 values(2); + end if; +end; + +-- questionable wrong SQL expression +create procedure wrong2() +begin + if (select count(*)>0) + then + insert into simple1 values(3); + end if; +end; _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
