Changeset: 9f314aa4e901 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=9f314aa4e901 Modified Files: sql/test/subquery/Tests/subquery2.sql Branch: Nov2019 Log Message:
Merge heads. diffs (13 lines): diff --git a/sql/test/subquery/Tests/subquery2.sql b/sql/test/subquery/Tests/subquery2.sql --- a/sql/test/subquery/Tests/subquery2.sql +++ b/sql/test/subquery/Tests/subquery2.sql @@ -24,6 +24,9 @@ SELECT name, major FROM students s WHERE drop table students; drop table exams; +SELECT 1 IN (1, (SELECT 2)), 1 NOT IN (1, (SELECT 2)); + -- True, False + CREATE TABLE tbl_ProductSales (ColID int, Product_Category varchar(64), Product_Name varchar(64), TotalSales int); INSERT INTO tbl_ProductSales VALUES (1,'Game','Mobo Game',200),(2,'Game','PKO Game',400),(3,'Fashion','Shirt',500),(4,'Fashion','Shorts',100); CREATE TABLE another_T (col1 INT, col2 INT, col3 INT, col4 INT, col5 INT, col6 INT, col7 INT, col8 INT); _______________________________________________ checkin-list mailing list [email protected] https://www.monetdb.org/mailman/listinfo/checkin-list
