Merge branch 'rightlib' into mergelibs-241120-1113

1 files changed, 21 insertions, 0 deletions

diff --git a/yql/essentials/tests/sql/suites/epochs/use_and_drop_anonymous.sql b/yql/essentials/tests/sql/suites/epochs/use_and_drop_anonymous.sql
new file mode 100644
index 0000000000..ee5c907dc9
--- /dev/null
+++ b/yql/essentials/tests/sql/suites/epochs/use_and_drop_anonymous.sql
@@ -0,0 +1,21 @@
+/* postgres can not */
+/* multirun can not */
+use plato;
+
+insert into @tmp select * from Input where key > "100";
+commit;
+
+insert into Output
+select * from @tmp where key != "150";
+
+drop table @tmp;
+commit;
+
+insert into @tmp select * from Input where key > "200";
+commit;
+
+insert into Output
+select * from @tmp where key != "150";
+
+drop table @tmp;
+commit;