Changeset: 363e1caad004 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=363e1caad004
Added Files:
sql/test/BugTracker-2015/Tests/dropManyUsers.Bug-3764.sql
sql/test/BugTracker-2015/Tests/dropManyUsers.Bug-3764.test
sql/test/BugTracker-2015/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py
sql/test/BugTracker-2015/Tests/grantMonetdbToRegularUser.Bug-3771.SQL.py
sql/test/BugTracker-2015/Tests/grantMonetdbToSchemaOwner.Bug-3771.SQL.py
sql/test/BugTracker-2015/Tests/grantPrivilegesNonDefaultRole.Bug-3365.SQL.py
sql/test/BugTracker-2015/Tests/grantRevokeAndGrantAgain.Bug-3765.SQL.py
sql/test/BugTracker-2015/Tests/grantRole.Bug-3772.SQL.py
Removed Files:
sql/test/Users/Tests/dropManyUsers.Bug-3764.sql
sql/test/Users/Tests/dropManyUsers.Bug-3764.test
sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py
sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.stable.err
sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.stable.out
sql/test/Users/Tests/grantMonetdbToRegularUser.Bug-3771.SQL.py
sql/test/Users/Tests/grantMonetdbToRegularUser.Bug-3771.stable.err
sql/test/Users/Tests/grantMonetdbToRegularUser.Bug-3771.stable.out
sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.SQL.py
sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.stable.err
sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.stable.out
sql/test/Users/Tests/grantPrivilegesNonDefaultRole.Bug-3365.SQL.py
sql/test/Users/Tests/grantPrivilegesNonDefaultRole.Bug-3365.stable.err
sql/test/Users/Tests/grantPrivilegesNonDefaultRole.Bug-3365.stable.out
sql/test/Users/Tests/grantRevokeAndGrantAgain.Bug-3765.SQL.py
sql/test/Users/Tests/grantRevokeAndGrantAgain.Bug-3765.stable.err
sql/test/Users/Tests/grantRevokeAndGrantAgain.Bug-3765.stable.out
sql/test/Users/Tests/grantRole.Bug-3772.SQL.py
sql/test/Users/Tests/grantRole.Bug-3772.stable.err
sql/test/Users/Tests/grantRole.Bug-3772.stable.out
Modified Files:
sql/test/BugTracker-2015/Tests/All
sql/test/Users/Tests/All
Branch: mtest
Log Message:
Moved all tests for bug reports from Users to the proper BugTracker dir.
Also removed the .stable.{out,err} files, since all their info has been
incorporated into the tests
diffs (truncated from 1097 to 300 lines):
diff --git a/sql/test/BugTracker-2015/Tests/All
b/sql/test/BugTracker-2015/Tests/All
--- a/sql/test/BugTracker-2015/Tests/All
+++ b/sql/test/BugTracker-2015/Tests/All
@@ -1,75 +1,78 @@
-window_function_crash.Bug-3861
-expression_with_comparison.Bug-3854
-and_or_expression.Bug-3851
-long_insert.Bug-3845
-alter-table.Bug-3828-part1
-alter-table.Bug-3828-part2
+set_default_role.Bug-3364
+grantPrivilegesNonDefaultRole.Bug-3365 # NEW
+sharp-alias.Bug-3467
+grantAndRevokeUserLoggedIN.Bug-3476 # NEW
+string_split.Bug-3564
+reserved_keywords.Bug-3613
+acidity2-fail.Bug-3635
+inet-funcs.Bug-3645
inet-ordering.Bug-3646
-sharp-alias.Bug-3467
name_conflict.Bug-3650
and_or_in.Bug-3655
-HAVE_PYMONETDB?acidity2-fail.Bug-3635
inet-ordering.Bug-3660
row-value-constructor-crash.Bug-3662
incorrect-ROW_NUMBER.Bug-3663
string-to-inet.Bug-3666
negative_oid_crash.Bug-3667
ukey_check_unaligned.Bug-3669
-inet-funcs.Bug-3645
-reserved_keywords.Bug-3613
+is_null_limit.Bug-3684
operator-priority.Bug-3686
incorrect_result_type.Bug-3687
-with-columns-mismatch.Bug-3697
find_fk.Bug-3690
-is_null_limit.Bug-3684
-inf-nan-handling.Bug-3696
+float-space-parse.Bug-3691
project_rewrite.Bug-3693
project_rewrite.Bug-3693_2
+inf-nan-handling.Bug-3696
+with-columns-mismatch.Bug-3697
+ifthenelse.Bug-3699
+insert_into_merge_table_crash.Bug-3703
alias.Bug-3704
case_aggr.Bug-3705
assertHead.Bug-3706
-ifthenelse.Bug-3699
+schema_view.Bug-3708
readonly.Bug-3709
+schema-trigger.Bug-3710
crash_on_alter_set_not_null.Bug-3715
+adddrop_unknown_table.Bug-3718
convert-to-bit.Bug-3719
+leftjoin.Bug-3720
union_project.Bug-3723
-leftjoin.Bug-3720
-adddrop_unknown_table.Bug-3718
-schema_view.Bug-3708
outerjoin_project.Bug-3725
left_shift_inet.Bug-3730
true_or_predicate.Bug-3733
crash.Bug-3736
+savepoint.Bug-3738-1
+savepoint.Bug-3738-2
+null_is_null.Bug-3739
+epoch_now.Bug-3740
+trigger-old-row.Bug-3741
div_zero.Bug-3742
cast_to_num.Bug-3744
-null_is_null.Bug-3739
-trigger-old-row.Bug-3741
mergejoin_NULL.Bug-3747
-epoch_now.Bug-3740
+local-remotetable-crash.Bug-3754
+THREADS>=3?useless_casts.Bug-3756
+sessions_crash.Bug-3759
+apply_merge_distinct.Bug-3760
+cardinality.Bug-3761
+dropManyUsers.Bug-3764 # NEW
+grantRevokeAndGrantAgain.Bug-3765 # NEW
schema_view2.Bug-3766
+cast_on_groupby_col_crash.Bug-3769
create-temp-table-using-like.Bug-3767
crash_on_declared_table.Bug-3770
+grantMonetdbToRegularUser.Bug-3771 # NEW
+grantMonetdbToSchemaOwner.Bug-3771 # NEW
+grantRole.Bug-3772 # NEW
quantile_function_resolution.Bug-3773
+msqldump-merge-and-remote-tables.Bug-3774
backslash_predecing_separator.Bug-3775
-sessions_crash.Bug-3759
-cast_on_groupby_col_crash.Bug-3769
-apply_merge_distinct.Bug-3760
-cardinality.Bug-3761
-set_default_role.Bug-3364
-THREADS>=3?useless_casts.Bug-3756
+schemadiff.Bug-3778
sum_interval.Bug-3785
nil_cast.Bug-3787
HAVE_LIBPCRE?sql2pcre.Bug-3800
ambiguous.Bug-3803
+fractional_precision_limitation.Bug-3808
large_join.Bug-3809
-float-space-parse.Bug-3691
-insert_into_merge_table_crash.Bug-3703
-HAVE_PYMONETDB?local-remotetable-crash.Bug-3754
-savepoint.Bug-3738-1
-savepoint.Bug-3738-2
-string_split.Bug-3564
-HAVE_PYMONETDB?schemadiff.Bug-3778
-fractional_precision_limitation.Bug-3808
not-like-without-wildcard.Bug-3811
HAVE_LIBZ?copy_into.Bug-3813
select-tilde-arg.Bug-3814
@@ -79,25 +82,29 @@ crash_in_reduce_groupby.Bug-3818
duplicate-constraint.Bug-3820
case_type.Bug-3821
like-escape.Bug-3822
-#HAVE_PYMONETDB?concurrent-schema.Bug-3826
+#concurrent-schema.Bug-3826
uuid-compare.Bug-3827
+alter-table.Bug-3828-part1
+alter-table.Bug-3828-part2
select-push-crash.Bug-3829
coalesce.Bug-3830
null.Bug-3833
date_comparison_incorrect_results.Bug-3834
-HAVE_HGE?hugeint-wrong-value.Bug-3849
-missed-error.Bug-3842
constant-random.Bug-3836
-limit_dbl.Bug-3847
-limit_too_large_value.Bug-3857
-msqldump-merge-and-remote-tables.Bug-3774
update_with_without_parenthesis.Bug-3838
+missed-error.Bug-3842
+long_insert.Bug-3845
+limit_dbl.Bug-3847
+HAVE_HGE?hugeint-wrong-value.Bug-3849
+and_or_expression.Bug-3851
+expression_with_comparison.Bug-3854
+foreignkey_over_schemas.Bug-3855
+limit_too_large_value.Bug-3857
+window_function_crash.Bug-3861
+mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863
import-non-ascii.Bug-3864
-mserver-creates-but-not-accept-column-types-decimal19-decimal39.Bug-3863
NOT_x_LIKE-triggers-too_many_nested_operators-error.Bug-3871
-foreignkey_over_schemas.Bug-3855
mserver-crashes-under-specific-combination-of-JOIN-and-WHERE-conditions.Bug-3872
-schema-trigger.Bug-3710
many_union_all.Bug-3879
sys_tracelog.Bug-3887
diff --git a/sql/test/Users/Tests/dropManyUsers.Bug-3764.sql
b/sql/test/BugTracker-2015/Tests/dropManyUsers.Bug-3764.sql
rename from sql/test/Users/Tests/dropManyUsers.Bug-3764.sql
rename to sql/test/BugTracker-2015/Tests/dropManyUsers.Bug-3764.sql
diff --git a/sql/test/Users/Tests/dropManyUsers.Bug-3764.test
b/sql/test/BugTracker-2015/Tests/dropManyUsers.Bug-3764.test
rename from sql/test/Users/Tests/dropManyUsers.Bug-3764.test
rename to sql/test/BugTracker-2015/Tests/dropManyUsers.Bug-3764.test
diff --git a/sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py
b/sql/test/BugTracker-2015/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py
rename from sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py
rename to
sql/test/BugTracker-2015/Tests/grantAndRevokeUserLoggedIN.Bug-3476.SQL.py
diff --git a/sql/test/Users/Tests/grantMonetdbToRegularUser.Bug-3771.SQL.py
b/sql/test/BugTracker-2015/Tests/grantMonetdbToRegularUser.Bug-3771.SQL.py
rename from sql/test/Users/Tests/grantMonetdbToRegularUser.Bug-3771.SQL.py
rename to
sql/test/BugTracker-2015/Tests/grantMonetdbToRegularUser.Bug-3771.SQL.py
--- a/sql/test/Users/Tests/grantMonetdbToRegularUser.Bug-3771.SQL.py
+++ b/sql/test/BugTracker-2015/Tests/grantMonetdbToRegularUser.Bug-3771.SQL.py
@@ -7,7 +7,7 @@ from MonetDBtesting.sqltest import SQLTe
with SQLTestCase() as tc:
tc.connect(username="monetdb", password="monetdb")
- tc.execute("CREATE USER user_with_many_rights with password
'ThisIsAS3m1S3cur3P4ssw0rd' name 'user gets monetdb rights' schema sys;")
+ tc.execute("CREATE USER user_with_many_rights with password
'ThisIsAS3m1S3cur3P4ssw0rd' name 'user gets monetdb rights' schema
sys;").assertSucceeded()
tc.execute("CREATE SCHEMA
a_brand_new_schema_with_a_longer_name_than_usual;").assertSucceeded()
tc.execute("CREATE table
a_brand_new_schema_with_a_longer_name_than_usual.testTable(v1 int, v2
int);").assertSucceeded()
tc.execute("GRANT sysadmin to user_with_many_rights;").assertSucceeded()
diff --git a/sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.SQL.py
b/sql/test/BugTracker-2015/Tests/grantMonetdbToSchemaOwner.Bug-3771.SQL.py
rename from sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.SQL.py
rename to
sql/test/BugTracker-2015/Tests/grantMonetdbToSchemaOwner.Bug-3771.SQL.py
diff --git a/sql/test/Users/Tests/grantPrivilegesNonDefaultRole.Bug-3365.SQL.py
b/sql/test/BugTracker-2015/Tests/grantPrivilegesNonDefaultRole.Bug-3365.SQL.py
rename from sql/test/Users/Tests/grantPrivilegesNonDefaultRole.Bug-3365.SQL.py
rename to
sql/test/BugTracker-2015/Tests/grantPrivilegesNonDefaultRole.Bug-3365.SQL.py
diff --git a/sql/test/Users/Tests/grantRevokeAndGrantAgain.Bug-3765.SQL.py
b/sql/test/BugTracker-2015/Tests/grantRevokeAndGrantAgain.Bug-3765.SQL.py
rename from sql/test/Users/Tests/grantRevokeAndGrantAgain.Bug-3765.SQL.py
rename to
sql/test/BugTracker-2015/Tests/grantRevokeAndGrantAgain.Bug-3765.SQL.py
diff --git a/sql/test/Users/Tests/grantRole.Bug-3772.SQL.py
b/sql/test/BugTracker-2015/Tests/grantRole.Bug-3772.SQL.py
rename from sql/test/Users/Tests/grantRole.Bug-3772.SQL.py
rename to sql/test/BugTracker-2015/Tests/grantRole.Bug-3772.SQL.py
diff --git a/sql/test/Users/Tests/All b/sql/test/Users/Tests/All
--- a/sql/test/Users/Tests/All
+++ b/sql/test/Users/Tests/All
@@ -1,4 +1,3 @@
-dropManyUsers.Bug-3764
schema
role1
role2
@@ -17,12 +16,6 @@ changePasswordUser
renameUser
changeSchemaUser
role
-grantAndRevokeUserLoggedIN.Bug-3476
-grantRevokeAndGrantAgain.Bug-3765
-grantMonetdbToRegularUser.Bug-3771
-grantMonetdbToSchemaOwner.Bug-3771
-grantPrivilegesNonDefaultRole.Bug-3365
-grantRole.Bug-3772
grantMonetdb
copyinto
schemaRights
diff --git
a/sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.stable.err
b/sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.stable.err
deleted file mode 100644
--- a/sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.stable.err
+++ /dev/null
@@ -1,38 +0,0 @@
-stderr of test 'grantAndRevokeUserLoggedIN.Bug-3476` in directory
'sql/test/Users` itself:
-
-
-# 10:42:58 >
-# 10:42:58 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=33978" "--set"
"mapi_usock=/var/tmp/mtest-2062/.s.monetdb.33978" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/home/vera/Desktop/MonetDB/installation/var/MonetDB/mTests_sql_test_Users"
"--set" "mal_listing=0" "--set" "embedded_r=yes"
-# 10:42:58 >
-
-# builtin opt gdk_dbpath =
/home/vera/Desktop/MonetDB/installation/var/monetdb5/dbfarm/demo
-# builtin opt gdk_debug = 0
-# builtin opt gdk_vmtrim = no
-# builtin opt monet_prompt = >
-# builtin opt monet_daemon = no
-# builtin opt mapi_port = 50000
-# builtin opt mapi_open = false
-# builtin opt mapi_autosense = false
-# builtin opt sql_optimizer = default_pipe
-# builtin opt sql_debug = 0
-# cmdline opt gdk_nr_threads = 0
-# cmdline opt mapi_open = true
-# cmdline opt mapi_port = 33978
-# cmdline opt mapi_usock = /var/tmp/mtest-2062/.s.monetdb.33978
-# cmdline opt monet_prompt =
-# cmdline opt mal_listing = 2
-# cmdline opt gdk_dbpath =
/home/vera/Desktop/MonetDB/installation/var/MonetDB/mTests_sql_test_Users
-# cmdline opt mal_listing = 0
-# cmdline opt embedded_r = yes
-# cmdline opt gdk_debug = 536870922
-
-# 10:42:59 >
-# 10:42:59 > "/usr/bin/python2" "grantAndRevokeUserLoggedIN.SQL.py"
"grantAndRevokeUserLoggedIN"
-# 10:42:59 >
-
-
-
-# 10:42:59 >
-# 10:42:59 > "Done."
-# 10:42:59 >
-
diff --git
a/sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.stable.out
b/sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.stable.out
deleted file mode 100644
--- a/sql/test/Users/Tests/grantAndRevokeUserLoggedIN.Bug-3476.stable.out
+++ /dev/null
@@ -1,103 +0,0 @@
-stdout of test 'grantAndRevokeUserLoggedIN.Bug-3476` in directory
'sql/test/Users` itself:
-
-
-# 10:44:33 >
-# 10:44:33 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set"
"mapi_open=true" "--set" "mapi_port=39798" "--set"
"mapi_usock=/var/tmp/mtest-2273/.s.monetdb.39798" "--set" "monet_prompt="
"--forcemito" "--set" "mal_listing=2"
"--dbpath=/home/vera/Desktop/MonetDB/installation/var/MonetDB/mTests_sql_test_Users"
"--set" "mal_listing=0" "--set" "embedded_r=yes"
-# 10:44:33 >
-
-# MonetDB 5 server v11.22.0
-# This is an unreleased version
-# Serving database 'mTests_sql_test_Users', using 8 threads
-# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs and 128bit
integers dynamically linked
-# Found 3.746 GiB available main-memory.
-# Copyright (c) 1993-July 2008 CWI.
-# Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved
-# Visit http://www.monetdb.org/ for further information
-# Listening for connection requests on mapi:monetdb://buzu:39798/
-# Listening for UNIX domain connection requests on
mapi:monetdb:///var/tmp/mtest-2273/.s.monetdb.39798
-# Start processing logs sql/sql_logs version 52200
-# Finished processing logs sql/sql_logs
-# MonetDB/SQL module loaded
-# MonetDB/R module loaded
-
-# SQL catalog created, loading sql scripts once
-# loading sql script: 09_like.sql
-# loading sql script: 10_math.sql
-# loading sql script: 11_times.sql
-# loading sql script: 12_url.sql
-# loading sql script: 13_date.sql
-# loading sql script: 14_inet.sql
-# loading sql script: 15_querylog.sql
-# loading sql script: 16_tracelog.sql
-# loading sql script: 17_temporal.sql
-# loading sql script: 20_vacuum.sql
-# loading sql script: 21_dependency_functions.sql
-# loading sql script: 22_clients.sql
-# loading sql script: 23_skyserver.sql
-# loading sql script: 24_zorder.sql
-# loading sql script: 25_debug.sql
-# loading sql script: 26_sysmon.sql
-# loading sql script: 27_rejects.sql
-# loading sql script: 39_analytics.sql
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
