Changeset: c5ba1242f774 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c5ba1242f774 Added Files: sql/backends/monet5/Tests/rapi17.stable.err sql/backends/monet5/Tests/rapi17.stable.out sql/test/BugTracker-2015/Tests/case_type.Bug-3821.sql sql/test/BugTracker-2015/Tests/case_type.Bug-3821.stable.err sql/test/BugTracker-2015/Tests/case_type.Bug-3821.stable.out sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.sql sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.stable.err sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.stable.out sql/test/BugTracker-2015/Tests/crash_in_reduce_groupby.Bug-3818.stable.out.int128 sql/test/BugTracker-2015/Tests/crash_timestamp_convert.Bug-3816.sql sql/test/BugTracker-2015/Tests/crash_timestamp_convert.Bug-3816.stable.err sql/test/BugTracker-2015/Tests/crash_timestamp_convert.Bug-3816.stable.out sql/test/BugTracker-2015/Tests/duplicate-constraint.Bug-3820.sql sql/test/BugTracker-2015/Tests/duplicate-constraint.Bug-3820.stable.err sql/test/BugTracker-2015/Tests/duplicate-constraint.Bug-3820.stable.out sql/test/BugTracker-2015/Tests/fractional_precision_limitation.Bug-3808.sql sql/test/BugTracker-2015/Tests/fractional_precision_limitation.Bug-3808.stable.err sql/test/BugTracker-2015/Tests/fractional_precision_limitation.Bug-3808.stable.out sql/test/BugTracker-2015/Tests/like-escape.Bug-3822.sql sql/test/BugTracker-2015/Tests/like-escape.Bug-3822.stable.err sql/test/BugTracker-2015/Tests/like-escape.Bug-3822.stable.out sql/test/BugTracker-2015/Tests/local-remotetable-crash.Bug-3754.SQL.py sql/test/BugTracker-2015/Tests/timestamp_convert.Bug-3815.sql sql/test/BugTracker-2015/Tests/timestamp_convert.Bug-3815.stable.err sql/test/BugTracker-2015/Tests/timestamp_convert.Bug-3815.stable.out sql/test/Users/Tests/schemaRights.SQL.py sql/test/Users/Tests/schemaRights.stable.err sql/test/Users/Tests/schemaRights.stable.out testing/Mfilter.py Removed Files: gdk/gdk_mapreduce.c gdk/gdk_mapreduce.h sql/test/BugTracker-2015/Tests/local-remotetable-crash.Bug-3754.sql testing/Mfilter.py.in Modified Files: .hgtags MonetDB.spec NT/installer32/MonetDB-ODBC-Installer.vdproj NT/installer32/MonetDB5-Geom-Module.vdproj NT/installer32/MonetDB5-SQL-Installer.vdproj NT/installer64/MonetDB-ODBC-Installer.vdproj NT/installer64/MonetDB5-Geom-Module.vdproj NT/installer64/MonetDB5-SQL-Installer.vdproj NT/monetdb_config.h.in NT/rules.msc clients/ChangeLog-Archive clients/ChangeLog.Jul2015 clients/R/Tests/testrandom.R clients/Tests/MAL-signatures.stable.out clients/Tests/MAL-signatures.stable.out.int128 clients/Tests/SQL-dump.stable.out clients/Tests/SQL-dump.stable.out.int128 clients/Tests/exports.stable.out clients/mapiclient/mclient.c clients/mapiclient/tomograph.c clients/mapilib/mapi.rc clients/odbc/driver/driver.rc clients/odbc/winsetup/setup.rc clients/php/examples/query.php clients/php/lib/php_monetdb.php clients/python2/setup.py clients/python3/setup.py clients/ruby/lib/MonetDB.rb clients/ruby/lib/MonetDBConnection.rb clients/ruby/lib/MonetDBData.rb configure.ag debian/changelog debian/monetdb-testing-python.install gdk/Makefile.ag gdk/gdk_bat.c gdk/gdk_join.c gdk/gdk_private.h gdk/libbat.rc java/Makefile.ag java/build.properties java/pom.xml java/release.txt java/src/main/java/nl/cwi/monetdb/jdbc/MonetConnection.java java/src/main/java/nl/cwi/monetdb/jdbc/MonetDatabaseMetaData.java libversions monetdb5/extras/rapi/rapi.c monetdb5/modules/atoms/json.c monetdb5/modules/kernel/aggr.c monetdb5/modules/mal/Tests/remote12.stable.out monetdb5/modules/mal/pcre.c monetdb5/tools/libmonetdb5.rc sql/ChangeLog sql/backends/monet5/Tests/All sql/backends/monet5/Tests/rapi14.sql sql/backends/monet5/Tests/rapi14.stable.err sql/backends/monet5/Tests/rapi14.stable.out sql/backends/monet5/UDF/Tests/udf-fuse.stable.out sql/backends/monet5/UDF/Tests/udf-reverse.stable.out sql/backends/monet5/sql.c sql/backends/monet5/sql.mal sql/backends/monet5/sql_gencode.c sql/backends/monet5/sql_gencode.h sql/backends/monet5/sql_scenario.h sql/benchmarks/ssbm/Tests/01-explain.stable.out sql/benchmarks/ssbm/Tests/02-explain.stable.out sql/benchmarks/ssbm/Tests/03-explain.stable.out sql/benchmarks/ssbm/Tests/04-explain.stable.out sql/benchmarks/ssbm/Tests/05-explain.stable.out sql/benchmarks/ssbm/Tests/06-explain.stable.out sql/benchmarks/ssbm/Tests/07-explain.stable.out sql/benchmarks/ssbm/Tests/08-explain.stable.out sql/benchmarks/ssbm/Tests/09-explain.stable.out sql/benchmarks/ssbm/Tests/10-explain.stable.out sql/benchmarks/ssbm/Tests/11-explain.stable.out sql/benchmarks/ssbm/Tests/12-explain.stable.out sql/benchmarks/ssbm/Tests/13-explain.stable.out sql/benchmarks/tpch/Tests/01-explain.stable.out sql/benchmarks/tpch/Tests/01-explain.stable.out.32bit sql/benchmarks/tpch/Tests/01-explain.stable.out.int128 sql/benchmarks/tpch/Tests/03-explain.stable.out sql/benchmarks/tpch/Tests/04-explain.stable.out sql/benchmarks/tpch/Tests/04-explain.stable.out.32bit sql/benchmarks/tpch/Tests/05-explain.stable.out sql/benchmarks/tpch/Tests/05-explain.stable.out.32bit sql/benchmarks/tpch/Tests/05-explain.stable.out.int128 sql/benchmarks/tpch/Tests/06-explain.stable.out sql/benchmarks/tpch/Tests/06-explain.stable.out.int128 sql/benchmarks/tpch/Tests/07-explain.stable.out sql/benchmarks/tpch/Tests/08-explain.stable.out sql/benchmarks/tpch/Tests/09-explain.stable.out sql/benchmarks/tpch/Tests/10-explain.stable.out sql/benchmarks/tpch/Tests/10-explain.stable.out.int128 sql/benchmarks/tpch/Tests/11-explain.stable.out sql/benchmarks/tpch/Tests/11-explain.stable.out.int128 sql/benchmarks/tpch/Tests/12-explain.stable.out sql/benchmarks/tpch/Tests/12-explain.stable.out.int128 sql/benchmarks/tpch/Tests/14-explain.stable.out sql/benchmarks/tpch/Tests/14-explain.stable.out.int128 sql/benchmarks/tpch/Tests/15-explain.stable.out sql/benchmarks/tpch/Tests/15-explain.stable.out.int128 sql/benchmarks/tpch/Tests/17-explain.stable.out sql/benchmarks/tpch/Tests/17-explain.stable.out.int128 sql/benchmarks/tpch/Tests/18-explain.stable.out sql/benchmarks/tpch/Tests/19-explain.stable.out sql/benchmarks/tpch/Tests/19-explain.stable.out.int128 sql/benchmarks/tpch/Tests/20-explain.stable.out sql/benchmarks/tpch/Tests/20-explain.stable.out.32bit sql/benchmarks/tpch/Tests/20-explain.stable.out.int128 sql/benchmarks/tpch/Tests/22-explain.stable.out sql/benchmarks/tpch/Tests/22-explain.stable.out.32bit sql/common/sql_types.c sql/common/sql_types.h sql/server/rel_dump.c sql/server/rel_dump.h sql/server/rel_optimizer.c sql/server/rel_psm.c sql/server/rel_schema.c sql/server/rel_select.c sql/server/rel_sequence.c sql/server/sql_privileges.c sql/server/sql_privileges.h sql/server/sql_semantic.c sql/server/sql_semantic.h sql/storage/store.c sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out sql/test/BugTracker-2008/Tests/auto_coersion_bug.SF-2075157.stable.out.int128 sql/test/BugTracker-2010/Tests/LIMIT_OFFSET_big-endian.Bug-2622.stable.out sql/test/BugTracker-2010/Tests/rank-over-crash.SF-2926454.stable.out sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out sql/test/BugTracker-2011/Tests/crash_on_alias.Bug-2798.stable.out.int128 sql/test/BugTracker-2011/Tests/func_iter_vs_bulk.Bug-2826.stable.out sql/test/BugTracker-2012/Tests/rewrite_like_into_likesubselect.Bug-3179.stable.out sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.int128.single sql/test/BugTracker-2013/Tests/between.Bug-3259.stable.out.single sql/test/BugTracker-2015/Tests/All sql/test/BugTracker-2015/Tests/ambiguous.Bug-3803.stable.out.int128 sql/test/BugTracker-2015/Tests/backslash_predecing_separator.Bug-3775.stable.err sql/test/BugTracker-2015/Tests/crash.Bug-3736.stable.out sql/test/BugTracker-2015/Tests/incorrect_result_type.Bug-3687.stable.out.int128 sql/test/BugTracker-2015/Tests/large_join.Bug-3809.sql sql/test/BugTracker-2015/Tests/large_join.Bug-3809.stable.out sql/test/BugTracker-2015/Tests/local-remotetable-crash.Bug-3754.stable.err sql/test/BugTracker-2015/Tests/sql2pcre.Bug-3800.stable.out sql/test/BugTracker-2015/Tests/useless_casts.Bug-3756.stable.out sql/test/BugTracker/Tests/jdbc_no_debug.SF-1739356.stable.out.32bit sql/test/Users/Tests/All sql/test/Users/Tests/columnRights.stable.err sql/test/Users/Tests/columnRights.stable.out sql/test/Users/Tests/dropManyUsers.Bug-3764.stable.out sql/test/Users/Tests/grantAndRevokeUserLogedIN.Bug-3476.SQL.py sql/test/Users/Tests/grantAndRevokeUserLogedIN.Bug-3476.stable.err sql/test/Users/Tests/grantAndRevokeUserLogedIN.Bug-3476.stable.out sql/test/Users/Tests/grantMonetdb.SQL.py sql/test/Users/Tests/grantMonetdbToRegularUser.Bug-3771.SQL.py sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.SQL.py sql/test/Users/Tests/grantMonetdbToSchemaOwner.Bug-3771.stable.err sql/test/Users/Tests/grantPrivilegesNonDefaultRole.Bug-3365.stable.err 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/leaks/Tests/check0.stable.out sql/test/leaks/Tests/check0.stable.out.int128 sql/test/leaks/Tests/check1.stable.out sql/test/leaks/Tests/check1.stable.out.int128 sql/test/leaks/Tests/check2.stable.out sql/test/leaks/Tests/check2.stable.out.int128 sql/test/leaks/Tests/check3.stable.out sql/test/leaks/Tests/check3.stable.out.int128 sql/test/leaks/Tests/check4.stable.out sql/test/leaks/Tests/check4.stable.out.int128 sql/test/leaks/Tests/check5.stable.out sql/test/leaks/Tests/check5.stable.out.int128 sql/test/leaks/Tests/drop3.stable.out sql/test/leaks/Tests/select1.stable.out sql/test/leaks/Tests/select2.stable.out sql/test/leaks/Tests/temp1.stable.out sql/test/leaks/Tests/temp2.stable.out sql/test/leaks/Tests/temp2.stable.out.int128 sql/test/leaks/Tests/temp3.stable.out sql/test/leaks/Tests/temp3.stable.out.int128 sql/test/mapi/Tests/sql_int128.stable.out sql/test/pg_regress/Tests/int2.stable.out sql/test/pg_regress/Tests/int8.stable.out sql/test/pg_regress/Tests/int8.stable.out.int128 sql/test/pg_regress/Tests/select_views.stable.out sql/test/pg_regress/Tests/strings.stable.err.int128 sql/test/pg_regress/Tests/strings.stable.out sql/test/testdb-upgrade-chain-hge/Tests/dump.SQL.py sql/test/testdb-upgrade-chain-hge/Tests/dump.stable.out sql/test/testdb-upgrade-chain/Tests/dump.SQL.py sql/test/testdb-upgrade-chain/Tests/dump.stable.out sql/test/testdb-upgrade-chain/Tests/dump.stable.out.Windows sql/test/testdb-upgrade-hge/Tests/dump.SQL.py sql/test/testdb-upgrade-hge/Tests/dump.stable.out sql/test/testdb-upgrade/Tests/dump.SQL.py sql/test/testdb-upgrade/Tests/dump.stable.out sql/test/testdb-upgrade/Tests/dump.stable.out.Windows sql/test/testdb/Tests/testdb-dump.SQL.py sql/test/testdb/Tests/testdb-dump.stable.out sql/test/testdb/Tests/testdb-dump.stable.out.Windows testing/Makefile.ag testing/Mtest.py.in tools/mserver/mserver5.c vertoo.data Branch: leftmart Log Message:
Merge with default branch. diffs (truncated from 38525 to 300 lines): diff --git a/.hgtags b/.hgtags --- a/.hgtags +++ b/.hgtags @@ -605,3 +605,5 @@ 30be7bd4aec0b5daf3d2f3a26a1043c04b88bb6d c7c0a76e663e34bcddae683b385c8e5a919ffd84 Jul2015_5 30be7bd4aec0b5daf3d2f3a26a1043c04b88bb6d Jul2015_release c7c0a76e663e34bcddae683b385c8e5a919ffd84 Jul2015_release +d1bce2fabbc36a3a3b996b09e55e764a626026a8 Jul2015_7 +d1bce2fabbc36a3a3b996b09e55e764a626026a8 Jul2015_SP1_release diff --git a/MonetDB.spec b/MonetDB.spec --- a/MonetDB.spec +++ b/MonetDB.spec @@ -91,7 +91,7 @@ Vendor: MonetDB BV <i...@monetdb.org> Group: Applications/Databases License: MPL - http://www.monetdb.org/Legal/MonetDBLicense URL: http://www.monetdb.org/ -Source: http://dev.monetdb.org/downloads/sources/Jul2015/%{name}-%{version}.tar.bz2 +Source: http://dev.monetdb.org/downloads/sources/Jul2015-SP1/%{name}-%{version}.tar.bz2 BuildRequires: bison BuildRequires: bzip2-devel @@ -920,7 +920,6 @@ developer, but if you do want to test, t # %exclude %{_bindir}/*.pyc # %exclude %{_bindir}/*.pyo %{_bindir}/Mapprove.py -%{_bindir}/Mfilter.py %{_bindir}/Mtest.py %dir %{python_sitelib}/MonetDBtesting %{python_sitelib}/MonetDBtesting/* @@ -996,6 +995,42 @@ rm -f %{buildroot}%{_bindir}/Maddlog %postun -p /sbin/ldconfig %changelog +* Tue Oct 20 2015 Sjoerd Mullender <sjo...@acm.org> - 11.21.7-20151020 +- Rebuilt. +- BZ#3789: Query on large string table fails on HEAPextend +- BZ#3794: table function sys.rejects() and view sys.rejects() are listed + are metadata objects but give an (incorrect) error when they are queried +- BZ#3797: COPY INTO with incorrect number columns +- BZ#3798: SELECT query with INTERSECT causes assertion failure +- BZ#3800: LIKE is broken for many patterns +- BZ#3802: Disk space never freed: a logical ref is keeped on a deleted + BATs +- BZ#3803: SQL query parser fails to parse valid SELECT query with a + CASE .. END in it. It fails with parser error: identifier 'x' ambiguous +- BZ#3804: `monetdb status` command crashes under certain conditions +- BZ#3809: Inefficient plan is generated for queries with many (>= 24) + joined tables which take a long time or an HEAPalloc error. I get Error: + GDK reported error. HEAPalloc: Insufficient space for HEAP of 400000000 + bytes. +- BZ#3810: Fix statistics gathering +- BZ#3811: NOT LIKE not working if the operand doesn't contains wildcards. +- BZ#3813: COPY INTO fails on perfectly clean CSV file +- BZ#3814: Server crash when using bitwise NOT operation in SQL query +- BZ#3818: Crash when performing UNION/GROUP BY over tables with + different columns +- BZ#3819: order of tables in FROM-clause has negative impact on generated + plan (using crossproducts instead of joins) +- BZ#3820: mclient accepts table with repeated constraint which causes + crash on insert +- BZ#3821: Unexpected error when using a number instead of a boolean +- BZ#3822: Yet another LIKE operator issue +- BZ#3825: MonetDB not cleaning intermediate results which leads to + filling up disk space and ultimately server crash + +* Sun Aug 30 2015 Sjoerd Mullender <sjo...@acm.org> - 11.21.7-20151020 +- clients: In the SQL formatter of mclient (the default) we now properly align + East Asian wide characters. + * Mon Aug 24 2015 Sjoerd Mullender <sjo...@acm.org> - 11.21.5-20150824 - Rebuilt. - BZ#3730: SAMPLE function not sampling randomly diff --git a/NT/monetdb_config.h.in b/NT/monetdb_config.h.in --- a/NT/monetdb_config.h.in +++ b/NT/monetdb_config.h.in @@ -205,6 +205,9 @@ /* Define to 1 if you have the `gettimeofday' function. */ /* #undef HAVE_GETTIMEOFDAY */ +/* Define to 1 if you have the `_get_timezone' function. */ +#define HAVE__GET_TIMEZONE 1 + /* Define if you have the gsl library */ /* #undef HAVE_GSL */ diff --git a/clients/ChangeLog-Archive b/clients/ChangeLog-Archive --- a/clients/ChangeLog-Archive +++ b/clients/ChangeLog-Archive @@ -1,6 +1,10 @@ # DO NOT EDIT THIS FILE -- MAINTAINED AUTOMATICALLY # This file contains past ChangeLog entries +* Sun Aug 30 2015 Sjoerd Mullender <sjo...@acm.org> - 11.21.7-20151020 +- In the SQL formatter of mclient (the default) we now properly align + East Asian wide characters. + * Thu Feb 19 2015 Sjoerd Mullender <sjo...@acm.org> - 11.21.1-20150807 - Added a new output format to mclient: --format=expanded (or -fx). In this format, column values are shown in full and below each other. diff --git a/clients/ChangeLog.Jul2015 b/clients/ChangeLog.Jul2015 --- a/clients/ChangeLog.Jul2015 +++ b/clients/ChangeLog.Jul2015 @@ -1,7 +1,3 @@ # ChangeLog file for clients # This file is updated with Maddlog -* Sun Aug 30 2015 Sjoerd Mullender <sjo...@acm.org> -- In the SQL formatter of mclient (the default) we now properly align - East Asian wide characters. - diff --git a/clients/R/Tests/testrandom.R b/clients/R/Tests/testrandom.R --- a/clients/R/Tests/testrandom.R +++ b/clients/R/Tests/testrandom.R @@ -18,7 +18,7 @@ stopifnot(dbIsValid(db)) # End Mtest boilerplate out <- NULL -for ( i in 1:1000 ){ +for ( i in 1:100 ){ out <- c(out, dbGetQuery(db , "SELECT * FROM (SELECT 1 AS col UNION ALL SELECT 2 AS col) AS temp SAMPLE 0.5")) } dbDisconnect(db) diff --git a/clients/Tests/MAL-signatures.stable.out b/clients/Tests/MAL-signatures.stable.out --- a/clients/Tests/MAL-signatures.stable.out +++ b/clients/Tests/MAL-signatures.stable.out @@ -40760,6 +40760,10 @@ pattern sql.restart{unsafe}(sname:str,se address mvc_restart_seq; comment restart the sequence with value start +pattern sql.register(mod:str,fname:str,rel_stmt:str,sig:str):int +address RAstatement2; +comment Compile the relational statement (rel_smt) and register it as mal function, mod.fname(signature) + function sql.sql_environment() (name:bat[:oid,:str],value:bat[:oid,:str]); pattern sql.shrink(sch:str,tbl:str):void address SQLshrink; diff --git a/clients/Tests/MAL-signatures.stable.out.int128 b/clients/Tests/MAL-signatures.stable.out.int128 --- a/clients/Tests/MAL-signatures.stable.out.int128 +++ b/clients/Tests/MAL-signatures.stable.out.int128 @@ -51699,6 +51699,10 @@ pattern sql.restart{unsafe}(sname:str,se address mvc_restart_seq; comment restart the sequence with value start +pattern sql.register(mod:str,fname:str,rel_stmt:str,sig:str):int +address RAstatement2; +comment Compile the relational statement (rel_smt) and register it as mal function, mod.fname(signature) + function sql.sql_environment() (name:bat[:oid,:str],value:bat[:oid,:str]); pattern sql.shrink(sch:str,tbl:str):void address SQLshrink; diff --git a/clients/Tests/SQL-dump.stable.out b/clients/Tests/SQL-dump.stable.out --- a/clients/Tests/SQL-dump.stable.out +++ b/clients/Tests/SQL-dump.stable.out @@ -1497,234 +1497,237 @@ 2149 "statement" "varchar" 2048 0 2139 N 2151 "id" "int" 32 0 2150 NULL true 0 NULL 2152 "name" "varchar" 1024 0 2150 NULL true 1 NULL 2153 "nr" "int" 32 0 2150 NULL true 2 NULL -5145 "id" "int" 32 0 5144 NULL true 0 NULL -5146 "name" "varchar" 1024 0 5144 NULL true 1 NULL -5147 "schema_id" "int" 32 0 5144 NULL true 2 NULL -5148 "query" "varchar" 2048 0 5144 NULL true 3 NULL -5149 "type" "smallint" 16 0 5144 NULL true 4 NULL -5150 "system" "boolean" 1 0 5144 NULL true 5 NULL -5151 "commit_action" "smallint" 16 0 5144 NULL true 6 NULL -5152 "access" "smallint" 16 0 5144 NULL true 7 NULL -5153 "temporary" "smallint" 16 0 5144 NULL true 8 NULL -5155 "id" "int" 32 0 5154 NULL true 0 NULL -5156 "name" "varchar" 1024 0 5154 NULL true 1 NULL -5157 "type" "varchar" 1024 0 5154 NULL true 2 NULL -5158 "type_digits" "int" 32 0 5154 NULL true 3 NULL -5159 "type_scale" "int" 32 0 5154 NULL true 4 NULL -5160 "table_id" "int" 32 0 5154 NULL true 5 NULL -5161 "default" "varchar" 2048 0 5154 NULL true 6 NULL -5162 "null" "boolean" 1 0 5154 NULL true 7 NULL -5163 "number" "int" 32 0 5154 NULL true 8 NULL -5164 "storage" "varchar" 2048 0 5154 NULL true 9 NULL -5171 "name" "varchar" 1024 0 5170 NULL true 0 NULL -5172 "fullname" "varchar" 2048 0 5170 NULL true 1 NULL -5173 "default_schema" "int" 9 0 5170 NULL true 2 NULL -5177 "name" "varchar" 1024 0 5176 NULL true 0 NULL -5178 "fullname" "varchar" 2024 0 5176 NULL true 1 NULL -5179 "default_schema" "int" 9 0 5176 NULL true 2 NULL -5181 "login_id" "int" 32 0 5180 NULL true 0 NULL -5182 "role_id" "int" 32 0 5180 NULL true 1 NULL -5184 "id" "int" 32 0 5183 NULL true 0 NULL -5185 "name" "varchar" 1024 0 5183 NULL true 1 NULL -5186 "grantor" "int" 32 0 5183 NULL true 2 NULL -5188 "obj_id" "int" 32 0 5187 NULL true 0 NULL -5189 "auth_id" "int" 32 0 5187 NULL true 1 NULL -5190 "privileges" "int" 32 0 5187 NULL true 2 NULL -5191 "grantor" "int" 32 0 5187 NULL true 3 NULL -5192 "grantable" "int" 32 0 5187 NULL true 4 NULL -5401 "id" "oid" 63 0 5409 NULL true 0 NULL -5402 "owner" "clob" 0 0 5409 NULL true 1 NULL -5403 "defined" "timestamp" 7 0 5409 NULL true 2 NULL -5404 "query" "clob" 0 0 5409 NULL true 3 NULL -5405 "pipe" "clob" 0 0 5409 NULL true 4 NULL -5406 "plan" "clob" 0 0 5409 NULL true 5 NULL -5407 "mal" "int" 32 0 5409 NULL true 6 NULL -5408 "optimize" "bigint" 64 0 5409 NULL true 7 NULL -5411 "id" "oid" 63 0 5420 NULL true 0 NULL -5412 "start" "timestamp" 7 0 5420 NULL true 1 NULL -5413 "stop" "timestamp" 7 0 5420 NULL true 2 NULL -5414 "arguments" "clob" 0 0 5420 NULL true 3 NULL -5415 "tuples" "wrd" 64 0 5420 NULL true 4 NULL -5416 "run" "bigint" 64 0 5420 NULL true 5 NULL -5417 "ship" "bigint" 64 0 5420 NULL true 6 NULL -5418 "cpu" "int" 32 0 5420 NULL true 7 NULL -5419 "io" "int" 32 0 5420 NULL true 8 NULL -5422 "id" "oid" 63 0 5438 NULL true 0 NULL -5423 "owner" "clob" 0 0 5438 NULL true 1 NULL -5424 "defined" "timestamp" 7 0 5438 NULL true 2 NULL -5425 "query" "clob" 0 0 5438 NULL true 3 NULL -5426 "pipe" "clob" 0 0 5438 NULL true 4 NULL -5427 "plan" "clob" 0 0 5438 NULL true 5 NULL -5428 "mal" "int" 32 0 5438 NULL true 6 NULL -5429 "optimize" "bigint" 64 0 5438 NULL true 7 NULL -5430 "start" "timestamp" 7 0 5438 NULL true 8 NULL -5431 "stop" "timestamp" 7 0 5438 NULL true 9 NULL -5432 "arguments" "clob" 0 0 5438 NULL true 10 NULL -5433 "tuples" "wrd" 64 0 5438 NULL true 11 NULL -5434 "run" "bigint" 64 0 5438 NULL true 12 NULL -5435 "ship" "bigint" 64 0 5438 NULL true 13 NULL -5436 "cpu" "int" 32 0 5438 NULL true 14 NULL -5437 "io" "int" 32 0 5438 NULL true 15 NULL -5464 "event" "int" 32 0 5477 NULL true 0 NULL -5465 "clk" "varchar" 20 0 5477 NULL true 1 NULL -5466 "pc" "varchar" 50 0 5477 NULL true 2 NULL -5467 "thread" "int" 32 0 5477 NULL true 3 NULL -5468 "ticks" "bigint" 64 0 5477 NULL true 4 NULL -5469 "rrsmb" "bigint" 64 0 5477 NULL true 5 NULL -5470 "vmmb" "bigint" 64 0 5477 NULL true 6 NULL -5471 "reads" "bigint" 64 0 5477 NULL true 7 NULL -5472 "writes" "bigint" 64 0 5477 NULL true 8 NULL -5473 "minflt" "bigint" 64 0 5477 NULL true 9 NULL -5474 "majflt" "bigint" 64 0 5477 NULL true 10 NULL -5475 "nvcsw" "bigint" 64 0 5477 NULL true 11 NULL -5476 "stmt" "clob" 0 0 5477 NULL true 12 NULL -5611 "user" "clob" 0 0 5617 NULL true 0 NULL -5612 "login" "timestamp" 7 0 5617 NULL true 1 NULL -5613 "sessiontimeout" "bigint" 64 0 5617 NULL true 2 NULL -5614 "lastcommand" "timestamp" 7 0 5617 NULL true 3 NULL -5615 "querytimeout" "bigint" 64 0 5617 NULL true 4 NULL -5616 "active" "boolean" 1 0 5617 NULL true 5 NULL -5694 "name" "clob" 0 0 5697 NULL true 0 NULL -5695 "def" "clob" 0 0 5697 NULL true 1 NULL -5696 "status" "clob" 0 0 5697 NULL true 2 NULL -5703 "name" "clob" 0 0 5705 NULL true 0 NULL -5704 "value" "clob" 0 0 5705 NULL true 1 NULL -5737 "qtag" "bigint" 64 0 5745 NULL true 0 NULL -5738 "user" "clob" 0 0 5745 NULL true 1 NULL -5739 "started" "timestamp" 7 0 5745 NULL true 2 NULL -5740 "estimate" "timestamp" 7 0 5745 NULL true 3 NULL -5741 "progress" "int" 32 0 5745 NULL true 4 NULL -5742 "status" "clob" 0 0 5745 NULL true 5 NULL -5743 "tag" "oid" 63 0 5745 NULL true 6 NULL -5744 "query" "clob" 0 0 5745 NULL true 7 NULL -5771 "rowid" "bigint" 64 0 5775 NULL true 0 NULL -5772 "fldid" "int" 32 0 5775 NULL true 1 NULL -5773 "message" "clob" 0 0 5775 NULL true 2 NULL -5774 "input" "clob" 0 0 5775 NULL true 3 NULL -6395 "keyword" "varchar" 40 0 6398 NULL false 0 NULL -6400 "table_type_id" "smallint" 16 0 6406 NULL false 0 NULL -6403 "table_type_name" "varchar" 25 0 6406 NULL false 1 NULL -6408 "dependency_type_id" "smallint" 16 0 6414 NULL false 0 NULL -6411 "dependency_type_name" "varchar" 15 0 6414 NULL false 1 NULL -6429 "file_id" "int" 32 0 6431 NULL true 0 NULL -6430 "location" "char" 256 0 6431 NULL true 1 NULL -6433 "dim_id" "int" 32 0 6437 NULL true 0 NULL -6434 "file_id" "int" 32 0 6437 NULL true 1 NULL -6435 "name" "varchar" 64 0 6437 NULL true 2 NULL -6436 "length" "int" 32 0 6437 NULL true 3 NULL -6439 "var_id" "int" 32 0 6445 NULL true 0 NULL -6440 "file_id" "int" 32 0 6445 NULL true 1 NULL -6441 "name" "varchar" 64 0 6445 NULL true 2 NULL -6442 "vartype" "varchar" 64 0 6445 NULL true 3 NULL -6443 "ndim" "int" 32 0 6445 NULL true 4 NULL -6444 "coord_dim_id" "int" 32 0 6445 NULL true 5 NULL -6447 "var_id" "int" 32 0 6451 NULL true 0 NULL -6448 "dim_id" "int" 32 0 6451 NULL true 1 NULL -6449 "file_id" "int" 32 0 6451 NULL true 2 NULL -6450 "dimpos" "int" 32 0 6451 NULL true 3 NULL -6453 "obj_name" "varchar" 256 0 6459 NULL true 0 NULL -6454 "att_name" "varchar" 256 0 6459 NULL true 1 NULL -6455 "att_type" "varchar" 64 0 6459 NULL true 2 NULL -6456 "value" "clob" 0 0 6459 NULL true 3 NULL -6457 "file_id" "int" 32 0 6459 NULL true 4 NULL -6458 "gr_name" "varchar" 256 0 6459 NULL true 5 NULL -6484 "schema" "clob" 0 0 6498 NULL true 0 NULL -6485 "table" "clob" 0 0 6498 NULL true 1 NULL -6486 "column" "clob" 0 0 6498 NULL true 2 NULL -6487 "type" "clob" 0 0 6498 NULL true 3 NULL -6488 "mode" "clob" 0 0 6498 NULL true 4 NULL -6489 "location" "clob" 0 0 6498 NULL true 5 NULL -6490 "count" "bigint" 64 0 6498 NULL true 6 NULL -6491 "typewidth" "int" 32 0 6498 NULL true 7 NULL -6492 "columnsize" "bigint" 64 0 6498 NULL true 8 NULL -6493 "heapsize" "bigint" 64 0 6498 NULL true 9 NULL -6494 "hashes" "bigint" 64 0 6498 NULL true 10 NULL -6495 "phash" "boolean" 1 0 6498 NULL true 11 NULL _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
