Github user gatorsmile commented on a diff in the pull request:
https://github.com/apache/spark/pull/19451#discussion_r144687477
--- Diff: sql/core/src/test/resources/sql-tests/inputs/except.sql ---
@@ -0,0 +1,43 @@
+-- Tests different scenarios of except operation
+create temporary view t1 as select * from values
+ ("one", 1),
+ ("two", 2),
+ ("three", 3)
+ as t1(k, v);
+
+create temporary view t2 as select * from values
+ ("one", 1),
+ ("two", 22),
+ ("one", 5)
+ as t2(k, v);
+
+create temporary view t3 as select * from t1 where v <> 1 and v <> 2;
+
+create temporary view t4 as select * from t1 where v <> 2 and v >= 3;
+
+create temporary view t5 as select * from t2 where v >= 1 and v <> 22;
+
+SELECT * FROM t1;
+
+SELECT * FROM t2;
+
+SELECT * FROM t3;
+
+SELECT * FROM t4;
+
+SELECT * FROM t5;
--- End diff --
Line 14 to 28 are not needed. You can embed the temp view into the line 31
-43 queries.
---
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
