Changeset: 57501ab6c9c5 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=57501ab6c9c5 Removed Files: sql/test/BugConstraints/Tests/add_constraint_1643522_bam.sql.src sql/test/BugConstraints/Tests/add_constraint_1643522_bam.stable.err sql/test/BugConstraints/Tests/add_constraint_1643522_bam.stable.out sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.SQL.py.src sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.stable.err sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.stable.out sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658_bam.sql.src sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658_bam.stable.err sql/test/BugDay_2005-11-09_2.8/Tests/ORDER_BY_evaluation_error.SF-1023658_bam.stable.out sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677_bam.sql.src sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677_bam.stable.err sql/test/BugTracker-2008/Tests/sql_command_kills_db.SF-2233677_bam.stable.out sql/test/BugTracker-2009/Tests/mclient-lsql-D_bam.SQL.sh.src sql/test/BugTracker-2009/Tests/mclient-lsql-D_bam.stable.err sql/test/BugTracker-2009/Tests/mclient-lsql-D_bam.stable.out sql/test/BugTracker-2009/Tests/name_clash_with_dump.SF-2780395_bam.sql.src sql/test/BugTracker-2009/Tests/name_clash_with_dump.SF-2780395_bam.stable.err sql/test/BugTracker-2009/Tests/name_clash_with_dump.SF-2780395_bam.stable.out sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552_bam.sql.src sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552_bam.stable.err sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552_bam.stable.out sql/test/BugTracker-2010/Tests/limit_in_prepare.Bug-2552_bam.stable.out.32bit sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808_bam.sql.src sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808_bam.stable.err sql/test/BugTracker-2011/Tests/count-count-distinct.Bug-2808_bam.stable.out sql/test/BugTracker-2011/Tests/exists-select.Bug-2933_bam.sql.src sql/test/BugTracker-2011/Tests/exists-select.Bug-2933_bam.stable.err sql/test/BugTracker-2011/Tests/exists-select.Bug-2933_bam.stable.out sql/test/BugTracker-2011/Tests/interrupted-initialization.Bug-2875_bam.py.src sql/test/BugTracker-2011/Tests/interrupted-initialization.Bug-2875_bam.stable.err sql/test/BugTracker-2011/Tests/interrupted-initialization.Bug-2875_bam.stable.out sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085_bam.sql.src sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085_bam.stable.err sql/test/BugTracker-2012/Tests/aggregate_vs_positional_column_crash.Bug-3085_bam.stable.out sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332_bam.sql.src sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332_bam.stable.err sql/test/BugTracker-2013/Tests/qualified_aggrname.Bug-3332_bam.stable.out sql/test/BugTracker-2014/Tests/select-having.Bug-3458_bam.sql.src sql/test/BugTracker-2014/Tests/select-having.Bug-3458_bam.stable.err sql/test/BugTracker-2014/Tests/select-having.Bug-3458_bam.stable.out sql/test/BugTracker/Tests/multi-column-constraint.SF-1964587_bam.sql.src sql/test/BugTracker/Tests/multi-column-constraint.SF-1964587_bam.stable.err sql/test/BugTracker/Tests/multi-column-constraint.SF-1964587_bam.stable.out sql/test/BugTracker/Tests/rank_over.SF-1691098_bam.sql.src sql/test/BugTracker/Tests/rank_over.SF-1691098_bam.stable.err sql/test/BugTracker/Tests/rank_over.SF-1691098_bam.stable.out sql/test/BugTracker/Tests/with_only_once.SF-1720293_bam.sql.src sql/test/BugTracker/Tests/with_only_once.SF-1720293_bam.stable.err sql/test/BugTracker/Tests/with_only_once.SF-1720293_bam.stable.out sql/test/DropCascade/Tests/drop_columns_cascade_bam.sql.src sql/test/DropCascade/Tests/drop_columns_cascade_bam.stable.err sql/test/DropCascade/Tests/drop_columns_cascade_bam.stable.out sql/test/DropCascade/Tests/drop_pkey_cascade_bam.sql.src sql/test/DropCascade/Tests/drop_pkey_cascade_bam.stable.err sql/test/DropCascade/Tests/drop_pkey_cascade_bam.stable.out sql/test/Dump/Tests/dump-empty_bam.SQL.py.src sql/test/Dump/Tests/dump-empty_bam.stable.err sql/test/Dump/Tests/dump-empty_bam.stable.out sql/test/Dump/Tests/dump_bam.SQL.py.src sql/test/Dump/Tests/dump_bam.stable.err sql/test/Dump/Tests/dump_bam.stable.out sql/test/UserDump/Tests/create_bam.SQL.py.src sql/test/UserDump/Tests/create_bam.stable.err sql/test/UserDump/Tests/create_bam.stable.out sql/test/bugs/Tests/crash_order_by_bam.sql.src sql/test/bugs/Tests/crash_order_by_bam.stable.err sql/test/bugs/Tests/crash_order_by_bam.stable.out sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566_bam.sql.src sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566_bam.stable.err sql/test/bugs/Tests/groupby_having_charlength-bug-sf-943566_bam.stable.out sql/test/bugs/Tests/insert_delete-bug-sf-904025_bam.sql.src sql/test/bugs/Tests/insert_delete-bug-sf-904025_bam.stable.err sql/test/bugs/Tests/insert_delete-bug-sf-904025_bam.stable.out sql/test/bugs/Tests/simple_view_bam.sql.src sql/test/bugs/Tests/simple_view_bam.stable.err sql/test/bugs/Tests/simple_view_bam.stable.out sql/test/bugs/Tests/subselect_multiple_unionall_where_1=1-bug-sf-1005596_bam.sql.src sql/test/bugs/Tests/subselect_multiple_unionall_where_1=1-bug-sf-1005596_bam.stable.err sql/test/bugs/Tests/subselect_multiple_unionall_where_1=1-bug-sf-1005596_bam.stable.out sql/test/mapi/Tests/php_monetdb_bam.SQL.sh.src sql/test/mapi/Tests/php_monetdb_bam.stable.err sql/test/mapi/Tests/php_monetdb_bam.stable.out sql/test/testdb/Tests/testdb-dump_bam.SQL.py.src sql/test/testdb/Tests/testdb-dump_bam.stable.err sql/test/testdb/Tests/testdb-dump_bam.stable.out Modified Files: sql/test/BugConstraints/Tests/All sql/test/BugDay_2005-10-06_2.8/Tests/All sql/test/BugDay_2005-11-09_2.8/Tests/All sql/test/BugTracker-2008/Tests/All sql/test/BugTracker-2009/Tests/All sql/test/BugTracker-2010/Tests/All sql/test/BugTracker-2011/Tests/All sql/test/BugTracker-2012/Tests/All sql/test/BugTracker-2013/Tests/All sql/test/BugTracker-2014/Tests/All sql/test/BugTracker/Tests/All sql/test/DropCascade/Tests/All sql/test/Dump/Tests/All sql/test/UserDump/Tests/All sql/test/bugs/Tests/All sql/test/mapi/Tests/All sql/test/testdb/Tests/All sql/test/testdb/Tests/testdb-load.stable.err sql/test/testdb/Tests/testdb-load.stable.out Branch: bamloader Log Message:
Backout of changeset b95d9e5134d0. Changeset 6dc4f761ad93 solves most of the problem. diffs (truncated from 194018 to 300 lines): diff --git a/sql/test/BugConstraints/Tests/All b/sql/test/BugConstraints/Tests/All --- a/sql/test/BugConstraints/Tests/All +++ b/sql/test/BugConstraints/Tests/All @@ -1,5 +1,4 @@ -!HAVE_SAMTOOLS?add_constraint_1643522 -HAVE_SAMTOOLS?add_constraint_1643522_bam +add_constraint_1643522 delete_primarykey_1643845 drop_column_1643542 update_primarykey_1643375 diff --git a/sql/test/BugConstraints/Tests/add_constraint_1643522_bam.sql.src b/sql/test/BugConstraints/Tests/add_constraint_1643522_bam.sql.src deleted file mode 100644 --- a/sql/test/BugConstraints/Tests/add_constraint_1643522_bam.sql.src +++ /dev/null @@ -1,1 +0,0 @@ -$RELSRCDIR/../add_constraint_1643522.sql diff --git a/sql/test/BugConstraints/Tests/add_constraint_1643522_bam.stable.err b/sql/test/BugConstraints/Tests/add_constraint_1643522_bam.stable.err deleted file mode 100644 --- a/sql/test/BugConstraints/Tests/add_constraint_1643522_bam.stable.err +++ /dev/null @@ -1,38 +0,0 @@ -stderr of test 'add_constraint_1643522_bam` in directory 'sql/test/BugConstraints` itself: - - -# 09:51:19 > -# 09:51:19 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36394" "--set" "mapi_usock=/var/tmp/mtest-13054/.s.monetdb.36394" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/home/robin/MonetDB/PREFIX/var/MonetDB/mTests_sql_test_BugConstraints" "--set" "mal_listing=0" -# 09:51:19 > - -# builtin opt gdk_dbpath = /home/robin/MonetDB/PREFIX/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 = 36394 -# cmdline opt mapi_usock = /var/tmp/mtest-13054/.s.monetdb.36394 -# cmdline opt monet_prompt = -# cmdline opt mal_listing = 2 -# cmdline opt gdk_dbpath = /home/robin/MonetDB/PREFIX/var/MonetDB/mTests_sql_test_BugConstraints -# cmdline opt mal_listing = 0 -# cmdline opt gdk_debug = 536870922 - -# 09:51:19 > -# 09:51:19 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-13054" "--port=36394" -# 09:51:19 > - -MAPI = (monetdb) /var/tmp/mtest-13054/.s.monetdb.36394 -QUERY = alter table t1 add constraint id_p primary key(id); -ERROR = !CONSTRAINT PRIMARY KEY: key 'id_p' already exists - -# 09:51:20 > -# 09:51:20 > "Done." -# 09:51:20 > diff --git a/sql/test/BugConstraints/Tests/add_constraint_1643522_bam.stable.out b/sql/test/BugConstraints/Tests/add_constraint_1643522_bam.stable.out deleted file mode 100644 --- a/sql/test/BugConstraints/Tests/add_constraint_1643522_bam.stable.out +++ /dev/null @@ -1,83 +0,0 @@ -stdout of test 'add_constraint_1643522_bam` in directory 'sql/test/BugConstraints` itself: - - -# 09:51:19 > -# 09:51:19 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=36394" "--set" "mapi_usock=/var/tmp/mtest-13054/.s.monetdb.36394" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/home/robin/MonetDB/PREFIX/var/MonetDB/mTests_sql_test_BugConstraints" "--set" "mal_listing=0" -# 09:51:19 > - -# MonetDB 5 server v11.18.0 -# This is an unreleased version -# Serving database 'mTests_sql_test_BugConstraints', using 4 threads -# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked -# Found 7.333 GiB available main-memory. -# Copyright (c) 1993-July 2008 CWI. -# Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved -# Visit http://www.monetdb.org/ for further information -# Listening for connection requests on mapi:monetdb://robin-xps13:36394/ -# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-13054/.s.monetdb.36394 -# MonetDB/SQL module loaded - -Ready. -# 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: 19_cluster.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: 39_analytics.sql -# loading sql script: 40_json.sql -# loading sql script: 41_jsonstore.sql -# loading sql script: 45_uuid.sql -# loading sql script: 75_storagemodel.sql -# loading sql script: 80_statistics.sql -# loading sql script: 80_udf.sql -# loading sql script: 85_bam.sql -# loading sql script: 99_system.sql - -# 09:51:19 > -# 09:51:19 > "mclient" "-lsql" "-ftest" "-Eutf-8" "-i" "-e" "--host=/var/tmp/mtest-13054" "--port=36394" -# 09:51:19 > - -#create table t1(id int, name varchar(1024)); -#alter table t1 add constraint id_p primary key(id); -#select name from keys; -% sys.keys # table_name -% name # name -% varchar # type -% 18 # length -[ "files_pkey_file_id" ] -[ "sq_pkey_sn_file_id" ] -[ "sq_fkey_file_id" ] -[ "rg_pkey_id_file_id" ] -[ "rg_fkey_file_id" ] -[ "pg_pkey_id_file_id" ] -[ "pg_fkey_file_id" ] -[ "id_p" ] -#drop table t1; -#select name from keys; -% sys.keys # table_name -% name # name -% varchar # type -% 18 # length -[ "files_pkey_file_id" ] -[ "sq_pkey_sn_file_id" ] -[ "sq_fkey_file_id" ] -[ "rg_pkey_id_file_id" ] -[ "rg_fkey_file_id" ] -[ "pg_pkey_id_file_id" ] -[ "pg_fkey_file_id" ] - -# 09:51:20 > -# 09:51:20 > "Done." -# 09:51:20 > diff --git a/sql/test/BugDay_2005-10-06_2.8/Tests/All b/sql/test/BugDay_2005-10-06_2.8/Tests/All --- a/sql/test/BugDay_2005-10-06_2.8/Tests/All +++ b/sql/test/BugDay_2005-10-06_2.8/Tests/All @@ -1,6 +1,5 @@ select_null -!HAVE_SAMTOOLS?MapiClient-dump.SF-905851 -HAVE_SAMTOOLS?MapiClient-dump.SF-905851_bam +MapiClient-dump.SF-905851 double_commit.SF-916584 mixed_type.SF-917372 union-SF.918078 diff --git a/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.SQL.py.src b/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.SQL.py.src deleted file mode 100644 --- a/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.SQL.py.src +++ /dev/null @@ -1,1 +0,0 @@ -$RELSRCDIR/MapiClient-dump.SF-905851.SQL.py \ No newline at end of file diff --git a/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.stable.err b/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.stable.err deleted file mode 100644 --- a/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.stable.err +++ /dev/null @@ -1,50 +0,0 @@ -stderr of test 'MapiClient-dump.SF-905851_bam` in directory 'sql/test/BugDay_2005-10-06_2.8` itself: - - -# 09:57:11 > -# 09:57:11 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39049" "--set" "mapi_usock=/var/tmp/mtest-13702/.s.monetdb.39049" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/home/robin/MonetDB/PREFIX/var/MonetDB/mTests_sql_test_BugDay_2005-10-06_2.8" "--set" "mal_listing=0" -# 09:57:11 > - -# builtin opt gdk_dbpath = /home/robin/MonetDB/PREFIX/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 = 39049 -# cmdline opt mapi_usock = /var/tmp/mtest-13702/.s.monetdb.39049 -# cmdline opt monet_prompt = -# cmdline opt mal_listing = 2 -# cmdline opt gdk_dbpath = /home/robin/MonetDB/PREFIX/var/MonetDB/mTests_sql_test_BugDay_2005-10-06_2.8 -# cmdline opt mal_listing = 0 -# cmdline opt gdk_debug = 536870922 - -# 09:57:11 > -# 09:57:11 > "/usr/bin/python2" "MapiClient-dump.SF-905851_bam.SQL.py" "MapiClient-dump.SF-905851_bam" -# 09:57:11 > - - -# 09:57:11 > -# 09:57:11 > Mtimeout -timeout 60 mclient -lsql -ftest -Eutf-8 -i -e --host=/var/tmp/mtest-13702 --port=39049 --database=mTests_sql_test_BugDay_2005-10-06_2.8 < "/home/robin/MonetDB/SOURCE/sql/test/BugDay_2005-10-06_2.8/Tests/JdbcClient_create_tables.sql" -# 09:57:11 > - - -# 09:57:11 > -# 09:57:11 > Mtimeout -timeout 60 mclient -lsql -ftest -Eutf-8 -i -e --host=/var/tmp/mtest-13702 --port=39049 --database=mTests_sql_test_BugDay_2005-10-06_2.8 < "/home/robin/MonetDB/SOURCE/sql/test/BugDay_2005-10-06_2.8/Tests/JdbcClient_inserts_selects.sql" -# 09:57:11 > - - -# 09:57:11 > -# 09:57:11 > Mtimeout -timeout 60 msqldump -q --host=/var/tmp/mtest-13702 --port=39049 --database=mTests_sql_test_BugDay_2005-10-06_2.8 -# 09:57:11 > - - -# 09:57:12 > -# 09:57:12 > "Done." -# 09:57:12 > diff --git a/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.stable.out b/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.stable.out deleted file mode 100644 --- a/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.stable.out +++ /dev/null @@ -1,256 +0,0 @@ -stdout of test 'MapiClient-dump.SF-905851_bam` in directory 'sql/test/BugDay_2005-10-06_2.8` itself: - - -# 09:57:11 > -# 09:57:11 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=39049" "--set" "mapi_usock=/var/tmp/mtest-13702/.s.monetdb.39049" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/home/robin/MonetDB/PREFIX/var/MonetDB/mTests_sql_test_BugDay_2005-10-06_2.8" "--set" "mal_listing=0" -# 09:57:11 > - -# MonetDB 5 server v11.18.0 -# This is an unreleased version -# Serving database 'mTests_sql_test_BugDay_2005-10-06_2.8', using 4 threads -# Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked -# Found 7.333 GiB available main-memory. -# Copyright (c) 1993-July 2008 CWI. -# Copyright (c) August 2008-2014 MonetDB B.V., all rights reserved -# Visit http://www.monetdb.org/ for further information -# Listening for connection requests on mapi:monetdb://robin-xps13:39049/ -# Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-13702/.s.monetdb.39049 -# MonetDB/SQL module loaded - -Ready. -#WARNING To speedup sql.password a bulk operator implementation is needed -#WARNING To speedup sql.password a bulk operator implementation is needed -#WARNING To speedup sql.password a bulk operator implementation is needed -#WARNING To speedup sql.password a bulk operator implementation is needed -#WARNING To speedup sql.get_value a bulk operator implementation is needed -#WARNING To speedup sql.get_value a bulk operator implementation is needed -#WARNING To speedup sql.get_value a bulk operator implementation is needed -#WARNING To speedup sql.get_value a bulk operator implementation is needed - -# 09:57:11 > -# 09:57:11 > "/usr/bin/python2" "MapiClient-dump.SF-905851_bam.SQL.py" "MapiClient-dump.SF-905851_bam" -# 09:57:11 > - - -# 09:57:11 > -# 09:57:11 > Mtimeout -timeout 60 mclient -lsql -ftest -Eutf-8 -i -e --host=/var/tmp/mtest-13702 --port=39049 --database=mTests_sql_test_BugDay_2005-10-06_2.8 < "/home/robin/MonetDB/SOURCE/sql/test/BugDay_2005-10-06_2.8/Tests/JdbcClient_create_tables.sql" -# 09:57:11 > - -#START TRANSACTION; -#CREATE TABLE allnewtriples ( -# id integer NOT NULL, -# subject integer NOT NULL, -# predicate integer NOT NULL, -# object integer NOT NULL, -# explicit boolean NOT NULL, -# PRIMARY KEY(id), -# CONSTRAINT unique_key UNIQUE(subject, predicate, object) -#); -#CREATE INDEX allnewtriples_subject_idx ON allnewtriples (subject); -#CREATE INDEX allnewtriples_predicate_idx ON allnewtriples (predicate); -#CREATE INDEX allnewtriples_object_idx ON allnewtriples (object); -#CREATE TABLE "foreign" ( -# id integer NOT NULL, -# subject integer NOT NULL, -# predicate integer NOT NULL, -# object integer NOT NULL, -# FOREIGN KEY (id) REFERENCES allnewtriples (id), -# FOREIGN KEY (subject, predicate, object) REFERENCES allnewtriples (subject, predicate, object) -#); -#CREATE TABLE "triples" ( -# "id" int NOT NULL, -# "subject" int NOT NULL, -# "predicate" int NOT NULL, -# "object" int NOT NULL, -# "explicit" boolean NOT NULL, -# CONSTRAINT "triples_subject_predicate_object_unique" UNIQUE ("subject", "predicate", "object") -#); -#CREATE INDEX "triples_object_idx" ON "triples" ("object"); -#CREATE INDEX "triples_predicate_idx" ON "triples" ("predicate"); -#CREATE INDEX "triples_predicate_object_idx" ON "triples" ("predicate", "object"); -#CREATE INDEX "triples_subject_idx" ON "triples" ("subject"); -#CREATE INDEX "triples_subject_object_idx" ON "triples" ("subject", "object"); -#CREATE INDEX "triples_subject_predicate_idx" ON "triples" ("subject", "predicate"); -#COMMIT; - _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
