Changeset: 28d146874c0a for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=28d146874c0a
Modified Files:
sql/backends/monet5/sql_user.c
sql/test/emptydb/Tests/check.stable.out
sql/test/emptydb/Tests/check.stable.out.32bit
sql/test/emptydb/Tests/check.stable.out.int128
Branch: default
Log Message:
Use the same varchar sizes in the sys.users view as in the base tables.
diffs (56 lines):
diff --git a/sql/backends/monet5/sql_user.c b/sql/backends/monet5/sql_user.c
--- a/sql/backends/monet5/sql_user.c
+++ b/sql/backends/monet5/sql_user.c
@@ -296,8 +296,8 @@ monet5_create_privileges(ptr _mvc, sql_s
return ;
}
- mvc_create_column_(m, t, "name", "varchar", 1024);
- mvc_create_column_(m, t, "fullname", "varchar", 2024);
+ mvc_create_column_(m, t, "name", "varchar", 2048);
+ mvc_create_column_(m, t, "fullname", "varchar", 2048);
mvc_create_column_(m, t, "default_schema", "int", 9);
mvc_create_column_(m, t, "schema_path", "clob", 0);
diff --git a/sql/test/emptydb/Tests/check.stable.out
b/sql/test/emptydb/Tests/check.stable.out
--- a/sql/test/emptydb/Tests/check.stable.out
+++ b/sql/test/emptydb/Tests/check.stable.out
@@ -2144,8 +2144,8 @@ drop function pcre_replace(string, strin
[ "sys._columns", "types", "schema_id", "int", 32, 0,
NULL, true, 7, NULL ]
[ "sys._columns", "user_role", "login_id", "int", 32, 0,
NULL, true, 0, NULL ]
[ "sys._columns", "user_role", "role_id", "int", 32, 0,
NULL, true, 1, NULL ]
-[ "sys._columns", "users", "name", "varchar", 1024, 0,
NULL, true, 0, NULL ]
-[ "sys._columns", "users", "fullname", "varchar", 2024,
0, NULL, true, 1, NULL ]
+[ "sys._columns", "users", "name", "varchar", 2048, 0,
NULL, true, 0, NULL ]
+[ "sys._columns", "users", "fullname", "varchar", 2048,
0, NULL, true, 1, NULL ]
[ "sys._columns", "users", "default_schema", "int", 9,
0, NULL, true, 2, NULL ]
[ "sys._columns", "users", "schema_path", "clob", 0, 0,
NULL, true, 3, NULL ]
[ "sys._columns", "value_partitions", "table_id", "int", 32,
0, NULL, true, 0, NULL ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.32bit
b/sql/test/emptydb/Tests/check.stable.out.32bit
--- a/sql/test/emptydb/Tests/check.stable.out.32bit
+++ b/sql/test/emptydb/Tests/check.stable.out.32bit
@@ -2144,8 +2144,8 @@ drop function pcre_replace(string, strin
[ "sys._columns", "types", "schema_id", "int", 32, 0,
NULL, true, 7, NULL ]
[ "sys._columns", "user_role", "login_id", "int", 32, 0,
NULL, true, 0, NULL ]
[ "sys._columns", "user_role", "role_id", "int", 32, 0,
NULL, true, 1, NULL ]
-[ "sys._columns", "users", "name", "varchar", 1024, 0,
NULL, true, 0, NULL ]
-[ "sys._columns", "users", "fullname", "varchar", 2024,
0, NULL, true, 1, NULL ]
+[ "sys._columns", "users", "name", "varchar", 2048, 0,
NULL, true, 0, NULL ]
+[ "sys._columns", "users", "fullname", "varchar", 2048,
0, NULL, true, 1, NULL ]
[ "sys._columns", "users", "default_schema", "int", 9,
0, NULL, true, 2, NULL ]
[ "sys._columns", "users", "schema_path", "clob", 0, 0,
NULL, true, 3, NULL ]
[ "sys._columns", "value_partitions", "table_id", "int", 32,
0, NULL, true, 0, NULL ]
diff --git a/sql/test/emptydb/Tests/check.stable.out.int128
b/sql/test/emptydb/Tests/check.stable.out.int128
--- a/sql/test/emptydb/Tests/check.stable.out.int128
+++ b/sql/test/emptydb/Tests/check.stable.out.int128
@@ -2165,8 +2165,8 @@ drop function pcre_replace(string, strin
[ "sys._columns", "types", "schema_id", "int", 32, 0,
NULL, true, 7, NULL ]
[ "sys._columns", "user_role", "login_id", "int", 32, 0,
NULL, true, 0, NULL ]
[ "sys._columns", "user_role", "role_id", "int", 32, 0,
NULL, true, 1, NULL ]
-[ "sys._columns", "users", "name", "varchar", 1024, 0,
NULL, true, 0, NULL ]
-[ "sys._columns", "users", "fullname", "varchar", 2024,
0, NULL, true, 1, NULL ]
+[ "sys._columns", "users", "name", "varchar", 2048, 0,
NULL, true, 0, NULL ]
+[ "sys._columns", "users", "fullname", "varchar", 2048,
0, NULL, true, 1, NULL ]
[ "sys._columns", "users", "default_schema", "int", 9,
0, NULL, true, 2, NULL ]
[ "sys._columns", "users", "schema_path", "clob", 0, 0,
NULL, true, 3, NULL ]
[ "sys._columns", "value_partitions", "table_id", "int", 32,
0, NULL, true, 0, NULL ]
_______________________________________________
checkin-list mailing list
checkin-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/checkin-list
