Changeset: 19eeda8004ba for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=19eeda8004ba
Modified Files:
sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.sql
sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.stable.out
Branch: default
Log Message:
Improve test: make it independent of content of sys.tables and limit it to 3
rows output
Approve output.
diffs (106 lines):
diff --git a/sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.sql
b/sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.sql
--- a/sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.sql
+++ b/sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.sql
@@ -3,7 +3,14 @@ select
then (true)
else (false)
end
-from sys.tables;
+from sys.table_types limit 3;
+
+select
+ case when EXISTS ( select count(hashes) from sys.tablestoragemodel )
+ then (true)
+ else (false)
+ end
+from sys.table_types limit 3;
insert into sys.privileges values (
diff --git
a/sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.stable.out
b/sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.stable.out
--- a/sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.stable.out
+++ b/sql/test/BugTracker-2017/Tests/exist-bigint-missing.Bug-6315.stable.out
@@ -29,69 +29,24 @@ Ready.
# then (true)
# else (false)
# end
-#from sys.tables;
+#from sys.table_types limit 3;
% .L72 # table_name
% L72 # name
% boolean # type
% 5 # length
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
-[ true ]
+[ false ]
+[ false ]
+[ false ]
+#select
+# case when EXISTS ( select count(hashes) from sys.tablestoragemodel )
+# then (true)
+# else (false)
+# end
+#from sys.table_types limit 3;
+% .L72 # table_name
+% L72 # name
+% boolean # type
+% 5 # length
[ true ]
[ true ]
[ true ]
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
