Changeset: 19244c9d2a14 for MonetDB
URL: http://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=19244c9d2a14
Added Files:
sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.sql
sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.stable.err
sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.stable.out
sql/test/BugTracker-2014/Tests/acidity-fail.Bug-3635.py
sql/test/BugTracker-2014/Tests/acidity-fail.Bug-3635.stable.err
sql/test/BugTracker-2014/Tests/acidity-fail.Bug-3635.stable.out
Removed Files:
sql/test/BugTracker-2008/Tests/too_may_nested_operators.SF-2102167.sql
sql/test/BugTracker-2008/Tests/too_may_nested_operators.SF-2102167.stable.err
sql/test/BugTracker-2008/Tests/too_may_nested_operators.SF-2102167.stable.out
Modified Files:
configure.ag
sql/scripts/Makefile.ag
sql/server/sql_datetime.c
sql/test/BugTracker-2008/Tests/All
sql/test/BugTracker-2014/Tests/All
sql/test/pg_regress/Tests/All
sql/test/pg_regress/Tests/alter_table.sql
sql/test/pg_regress/Tests/alter_table.stable.err
sql/test/pg_regress/Tests/alter_table.stable.out
sql/test/pg_regress/Tests/arrays.stable.err
sql/test/pg_regress/Tests/boolean.stable.err
sql/test/pg_regress/Tests/case.stable.err
sql/test/pg_regress/Tests/char.stable.err
sql/test/pg_regress/Tests/comments.stable.err
sql/test/pg_regress/Tests/create_aggregate.stable.err
sql/test/pg_regress/Tests/create_misc.stable.err
sql/test/pg_regress/Tests/create_operator.stable.err
sql/test/pg_regress/Tests/date.sql
sql/test/pg_regress/Tests/date.stable.err
sql/test/pg_regress/Tests/date.stable.out
sql/test/pg_regress/Tests/drop.stable.err
sql/test/pg_regress/Tests/float4.stable.err
sql/test/pg_regress/Tests/float8.stable.err
sql/test/pg_regress/Tests/horology.stable.err
sql/test/pg_regress/Tests/horology.stable.out
sql/test/pg_regress/Tests/inet.stable.err
sql/test/pg_regress/Tests/insert.stable.err
sql/test/pg_regress/Tests/int2.stable.err
sql/test/pg_regress/Tests/int4.stable.err
sql/test/pg_regress/Tests/int8.stable.err
sql/test/pg_regress/Tests/interval.sql
sql/test/pg_regress/Tests/interval.stable.err
sql/test/pg_regress/Tests/interval.stable.out
sql/test/pg_regress/Tests/limit.stable.err
sql/test/pg_regress/Tests/numeric.stable.err
sql/test/pg_regress/Tests/numeric_big.stable.err
sql/test/pg_regress/Tests/numerology.stable.err
sql/test/pg_regress/Tests/oid.stable.err
sql/test/pg_regress/Tests/reltime.stable.err
sql/test/pg_regress/Tests/reltime.stable.out
sql/test/pg_regress/Tests/select_into.stable.err
sql/test/pg_regress/Tests/strings.stable.err
sql/test/pg_regress/Tests/strings_cast.stable.err
sql/test/pg_regress/Tests/strings_concat.stable.err
sql/test/pg_regress/Tests/timestamp.sql
sql/test/pg_regress/Tests/timestamp.stable.err
sql/test/pg_regress/Tests/timestamp.stable.out
sql/test/pg_regress/Tests/timestamptz.sql
sql/test/pg_regress/Tests/timestamptz.stable.err
sql/test/pg_regress/Tests/timestamptz.stable.out
sql/test/pg_regress/Tests/varchar.stable.err
sql/test/pg_regress/Tests/without_oid.stable.err
testing/Mtest.py.in
testing/process.py
Branch: transaction-replication
Log Message:
Merge with default branch
diffs (truncated from 12745 to 300 lines):
diff --git a/configure.ag b/configure.ag
--- a/configure.ag
+++ b/configure.ag
@@ -1203,6 +1203,8 @@ if test "x$have_perl" != xno; then
AC_MSG_ERROR([Must specify --with-perl-libdir
when cross compiling])
fi
PERL_LIBDIR=`"$PERL" -MConfig -e
'$x=$Config{installvendorarch}; $x =~ s|$Config{vendorprefix}/||; print $x;'
2>/dev/null`
+ # On Darwin this starts with a slash, remove it
+ PERL_LIBDIR="${PERL_LIBDIR#/}"
;;
no) ;;
*)
diff --git a/sql/scripts/Makefile.ag b/sql/scripts/Makefile.ag
--- a/sql/scripts/Makefile.ag
+++ b/sql/scripts/Makefile.ag
@@ -20,7 +20,29 @@ MT_SAFE
headers_sql = {
HEADERS = sql
DIR = libdir/monetdb5/createdb
- SOURCES = 09_like.sql 10_math.sql 11_times.sql 12_url.sql 13_date.sql
14_inet.sql 15_querylog.sql 16_tracelog.sql 19_cluster.sql 20_vacuum.sql
21_dependency_functions.sql 22_clients.sql 23_skyserver.sql 24_zorder.sql
25_debug.sql 26_sysmon.sql 39_analytics.sql 40_json.sql 41_jsonstore.sql
45_uuid.sql 75_storagemodel.sql 80_statistics.sql 99_system.sql
+ SOURCES = 09_like.sql \
+ 10_math.sql \
+ 11_times.sql \
+ 12_url.sql \
+ 13_date.sql \
+ 14_inet.sql \
+ 15_querylog.sql \
+ 16_tracelog.sql \
+ 19_cluster.sql \
+ 20_vacuum.sql \
+ 21_dependency_functions.sql \
+ 22_clients.sql \
+ 23_skyserver.sql \
+ 24_zorder.sql \
+ 25_debug.sql \
+ 26_sysmon.sql \
+ 39_analytics.sql \
+ 40_json.sql \
+ 41_jsonstore.sql \
+ 45_uuid.sql \
+ 75_storagemodel.sql \
+ 80_statistics.sql \
+ 99_system.sql
}
headers_hge = {
diff --git a/sql/server/sql_datetime.c b/sql/server/sql_datetime.c
--- a/sql/server/sql_datetime.c
+++ b/sql/server/sql_datetime.c
@@ -262,6 +262,11 @@ parse_interval(mvc *sql, lng sign, char
}
return parse_interval_(sql, sign, n + 1, sk + 1, ek, sp, ep, i);
} else {
+ if (!n || *n) {
+ if (sql)
+ snprintf(sql->errstr, ERRSIZE, _("Interval type
miss match '%s'\n"), (!n)?"":n);
+ return -1;
+ }
return type;
}
}
diff --git a/sql/test/BugTracker-2008/Tests/All
b/sql/test/BugTracker-2008/Tests/All
--- a/sql/test/BugTracker-2008/Tests/All
+++ b/sql/test/BugTracker-2008/Tests/All
@@ -23,7 +23,7 @@ constraint_with_schemas.SF-2080219
groupby_with_NULL.SF-2155606
invalid_qualified_column_name.SF-2183288
update_error.SF-2254506
-too_may_nested_operators.SF-2102167
+too_many_nested_operators.SF-2102167
aborting_process.SF-2130710
server_aborts_on_nested_query_without_from_in_subquery.SF-2183292
group_by_in_subquery_fails.SF-2219131
diff --git
a/sql/test/BugTracker-2008/Tests/too_may_nested_operators.SF-2102167.sql
b/sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.sql
rename from
sql/test/BugTracker-2008/Tests/too_may_nested_operators.SF-2102167.sql
rename to
sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.sql
diff --git
a/sql/test/BugTracker-2008/Tests/too_may_nested_operators.SF-2102167.stable.err
b/sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.stable.err
rename from
sql/test/BugTracker-2008/Tests/too_may_nested_operators.SF-2102167.stable.err
rename to
sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.stable.err
---
a/sql/test/BugTracker-2008/Tests/too_may_nested_operators.SF-2102167.stable.err
+++
b/sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.stable.err
@@ -1,4 +1,4 @@
-stderr of test 'too_may_nested_operators.SF-2102167` in directory
'sql/test/BugTracker-2008` itself:
+stderr of test 'too_many_nested_operators.SF-2102167` in directory
'sql/test/BugTracker-2008` itself:
# 20:45:18 >
diff --git
a/sql/test/BugTracker-2008/Tests/too_may_nested_operators.SF-2102167.stable.out
b/sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.stable.out
rename from
sql/test/BugTracker-2008/Tests/too_may_nested_operators.SF-2102167.stable.out
rename to
sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.stable.out
---
a/sql/test/BugTracker-2008/Tests/too_may_nested_operators.SF-2102167.stable.out
+++
b/sql/test/BugTracker-2008/Tests/too_many_nested_operators.SF-2102167.stable.out
@@ -1,4 +1,4 @@
-stdout of test 'too_may_nested_operators.SF-2102167` in directory
'sql/test/BugTracker-2008` itself:
+stdout of test 'too_many_nested_operators.SF-2102167` in directory
'sql/test/BugTracker-2008` itself:
# 20:45:18 >
diff --git a/sql/test/BugTracker-2014/Tests/All
b/sql/test/BugTracker-2014/Tests/All
--- a/sql/test/BugTracker-2014/Tests/All
+++ b/sql/test/BugTracker-2014/Tests/All
@@ -64,3 +64,4 @@ stddev-empty.Bug-3628
ifthenelse.Bug-3629
order_by_incorrect_error.Bug-3630
incorrect_floating_point_cast.Bug-3633
+acidity-fail.Bug-3635
diff --git a/sql/test/BugTracker-2014/Tests/acidity-fail.Bug-3635.py
b/sql/test/BugTracker-2014/Tests/acidity-fail.Bug-3635.py
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2014/Tests/acidity-fail.Bug-3635.py
@@ -0,0 +1,73 @@
+try:
+ from MonetDBtesting import process
+except ImportError:
+ import process
+
+import sys, time, monetdb.sql, os
+
+def connect(autocommit):
+ return monetdb.sql.connect(database = os.getenv('TSTDB'),
+ hostname = '127.0.0.1',
+ port = int(os.getenv('MAPIPORT')),
+ username = 'monetdb',
+ password = 'monetdb',
+ autocommit = autocommit)
+
+def query(conn, sql):
+ cur = conn.cursor()
+ cur.execute(sql)
+ r = cur.fetchall()
+ cur.close()
+ return r
+
+# no timeout since we need to kill mserver5, not the inbetween Mtimeout
+s = process.server(stdin = process.PIPE, stdout = process.PIPE, stderr =
process.PIPE, notimeout = True)
+
+# boring setup and schema creation stuff:
+c1 = connect(True)
+c1.execute('create table foo (a int)')
+c1.execute('create table bar (a int)')
+c1.execute('insert into foo values (1),(2),(3)')
+# print query(c1, """select * from storage() where "table"='foo'""")
+print query(c1, 'select * from foo')
+
+# Run 'delete from foo' with store_nr_active > 1
+# This causes MonetDB to allocate a new file for foo rather than
+# wiping the existing one
+c2 = connect(True)
+c2.execute('start transaction')
+c1.execute('delete from foo')
+c2.execute('rollback')
+
+# Populate some new data into foo, and demonstrate that a new file has
+# been allocated
+c1.execute('insert into foo values (4),(5),(6)')
+# print query(c1, """select * from storage() where "table"='foo'""")
+
+# Generate at least 1000 changes, as required by store_manager() in
+# order to cause a logger restart
+c1.execute('insert into bar select * from generate_series(cast(0 as
int),1500)')
+
+# Wait at least 30 seconds in order to ensure store_manager() has done
+# the logger restart
+# An alternative would have been to generate at least SNAPSHOT_MINSIZE
+# rows in one statement, but this way is simpler
+time.sleep(31)
+print query(c1, 'select * from foo')
+
+os.kill(s.pid, 9)
+
+time.sleep(10)
+t = process.server(stdin = process.PIPE, stdout = process.PIPE, stderr =
process.PIPE)
+
+c3 = connect(True)
+# This prints the wrong data. It should print exactly the same as the
+# previous line: "[(4,), (5,), (6,)]" , but actually prints "[(1,),
+# (2,), (3,)]"
+print query(c3, 'select * from foo')
+
+# cleanup
+c3.execute('drop table foo')
+c3.execute('drop table bar')
+
+t.communicate()
diff --git a/sql/test/BugTracker-2014/Tests/acidity-fail.Bug-3635.stable.err
b/sql/test/BugTracker-2014/Tests/acidity-fail.Bug-3635.stable.err
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2014/Tests/acidity-fail.Bug-3635.stable.err
@@ -0,0 +1,15 @@
+stderr of test 'acidity-fail.Bug-3635` in directory 'sql/test/BugTracker-2014`
itself:
+
+
+# 15:25:29 >
+# 15:25:29 > "/usr/bin/python2" "acidity-fail.Bug-3635.py"
"acidity-fail.Bug-3635"
+# 15:25:29 >
+
+
+# 15:26:10 >
+# 15:26:10 > "Done."
+# 15:26:10 >
+
+
+
+
diff --git a/sql/test/BugTracker-2014/Tests/acidity-fail.Bug-3635.stable.out
b/sql/test/BugTracker-2014/Tests/acidity-fail.Bug-3635.stable.out
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2014/Tests/acidity-fail.Bug-3635.stable.out
@@ -0,0 +1,15 @@
+stdout of test 'acidity-fail.Bug-3635` in directory 'sql/test/BugTracker-2014`
itself:
+
+
+# 15:25:29 >
+# 15:25:29 > "/usr/bin/python2" "acidity-fail.Bug-3635.py"
"acidity-fail.Bug-3635"
+# 15:25:29 >
+
+[(1,), (2,), (3,)]
+[(4,), (5,), (6,)]
+[(4,), (5,), (6,)]
+
+# 15:26:10 >
+# 15:26:10 > "Done."
+# 15:26:10 >
+
diff --git a/sql/test/pg_regress/Tests/All b/sql/test/pg_regress/Tests/All
--- a/sql/test/pg_regress/Tests/All
+++ b/sql/test/pg_regress/Tests/All
@@ -47,7 +47,7 @@ reltime
inet
comments
#ToDo HAVE_GEOM?geometry
-#ToDo horology
+horology
#ToDo oidjoins
#ToDo type_sanity
#ToDo opr_sanity
diff --git a/sql/test/pg_regress/Tests/alter_table.sql
b/sql/test/pg_regress/Tests/alter_table.sql
--- a/sql/test/pg_regress/Tests/alter_table.sql
+++ b/sql/test/pg_regress/Tests/alter_table.sql
@@ -67,7 +67,7 @@ INSERT INTO tmp (a, b, c, d, e, f, g, h,
314159, '(1,1)', '512',
'1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)',
'(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["epoch" "infinity"]',
- cast('2014-11-14 16:27:15.0' as timestamp), '01:00:10',
'{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
+ cast('2014-11-14 16:27:15.0' as timestamp), '3610',
'{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
SELECT * FROM tmp;
@@ -137,7 +137,7 @@ INSERT INTO tmp (a, b, c, d, e, f, g, h,
314159, '(1,1)', '512',
'1 2 3 4 5 6 7 8', 'magnetic disk', '(1.1,1.1)', '(4.1,4.1,3.1,3.1)',
'(0,2,4.1,4.1,3.1,3.1)', '(4.1,4.1,3.1,3.1)', '["epoch" "infinity"]',
- cast('2014-11-14 23:59:59.9' as timestamptz), '01:00:10',
'{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
+ cast('2014-11-14 23:59:59.9' as timestamptz), '3610',
'{1.0,2.0,3.0,4.0}', '{1.0,2.0,3.0,4.0}', '{1,2,3,4}');
SELECT * FROM tmp;
diff --git a/sql/test/pg_regress/Tests/alter_table.stable.err
b/sql/test/pg_regress/Tests/alter_table.stable.err
--- a/sql/test/pg_regress/Tests/alter_table.stable.err
+++ b/sql/test/pg_regress/Tests/alter_table.stable.err
@@ -26,613 +26,613 @@ stderr of test 'alter_table` in director
# cmdline opt gdk_debug = 536870922
-MAPI = (monetdb) /var/tmp/mtest-26924/.s.monetdb.33500
+MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
QUERY = ALTER TABLE tmp RENAME TO tmp_new;
ERROR = !syntax error, unexpected RENAME, expecting DROP or SET or ALTER or
ADD in: "alter table tmp rename"
-MAPI = (monetdb) /var/tmp/mtest-26924/.s.monetdb.33500
+MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
QUERY = SELECT * FROM tmp_new;
ERROR = !SELECT: no such table 'tmp_new'
-MAPI = (monetdb) /var/tmp/mtest-26924/.s.monetdb.33500
+MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
QUERY = ALTER TABLE tmp RENAME TO tmp_new2;
ERROR = !syntax error, unexpected RENAME, expecting DROP or SET or ALTER or
ADD in: "alter table tmp rename"
-MAPI = (monetdb) /var/tmp/mtest-26924/.s.monetdb.33500
+MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
QUERY = SELECT * FROM tmp_new;
ERROR = !SELECT: no such table 'tmp_new'
-MAPI = (monetdb) /var/tmp/mtest-26924/.s.monetdb.33500
+MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
QUERY = SELECT * FROM tmp_new2;
ERROR = !SELECT: no such table 'tmp_new2'
-MAPI = (monetdb) /var/tmp/mtest-26924/.s.monetdb.33500
+MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
QUERY = DROP TABLE tmp_new;
ERROR = !DROP TABLE: no such table 'tmp_new'
-MAPI = (monetdb) /var/tmp/mtest-26924/.s.monetdb.33500
+MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
QUERY = DROP TABLE tmp_new2;
ERROR = !DROP TABLE: no such table 'tmp_new2'
-MAPI = (monetdb) /var/tmp/mtest-26924/.s.monetdb.33500
+MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
QUERY = ALTER INDEX onek_unique1 RENAME TO tmp_onek_unique1;
ERROR = !syntax error, unexpected INDEX, expecting USER or SEQUENCE or TABLE
in: "alter index"
-MAPI = (monetdb) /var/tmp/mtest-26924/.s.monetdb.33500
+MAPI = (monetdb) /var/tmp/mtest-21634/.s.monetdb.30139
QUERY = ALTER INDEX tmp_onek_unique1 RENAME TO onek_unique1;
ERROR = !syntax error, unexpected INDEX, expecting USER or SEQUENCE or TABLE
in: "alter index"
_______________________________________________
checkin-list mailing list
[email protected]
https://www.monetdb.org/mailman/listinfo/checkin-list
