Changeset: b95d9e5134d0 for MonetDB URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=b95d9e5134d0 Added 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:
Fixed most tests in sql/test, the only ones that remain are complicated cases that also have conditionals on HAVE_GEOM and HAVE_GSL 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,4 +1,5 @@ -add_constraint_1643522 +!HAVE_SAMTOOLS?add_constraint_1643522 +HAVE_SAMTOOLS?add_constraint_1643522_bam 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 new file mode 100644 --- /dev/null +++ b/sql/test/BugConstraints/Tests/add_constraint_1643522_bam.sql.src @@ -0,0 +1,1 @@ +$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 new file mode 100644 --- /dev/null +++ b/sql/test/BugConstraints/Tests/add_constraint_1643522_bam.stable.err @@ -0,0 +1,38 @@ +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 new file mode 100644 --- /dev/null +++ b/sql/test/BugConstraints/Tests/add_constraint_1643522_bam.stable.out @@ -0,0 +1,83 @@ +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,5 +1,6 @@ select_null -MapiClient-dump.SF-905851 +!HAVE_SAMTOOLS?MapiClient-dump.SF-905851 +HAVE_SAMTOOLS?MapiClient-dump.SF-905851_bam 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 new file mode 100644 --- /dev/null +++ b/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.SQL.py.src @@ -0,0 +1,1 @@ +$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 new file mode 100644 --- /dev/null +++ b/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.stable.err @@ -0,0 +1,50 @@ +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 new file mode 100644 --- /dev/null +++ b/sql/test/BugDay_2005-10-06_2.8/Tests/MapiClient-dump.SF-905851_bam.stable.out @@ -0,0 +1,256 @@ +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
