Test upgrade.SQL.py (id 350cc55cd57a) (err)
upgrade.stable.out.32bit.FILTERED 2018-12-07 02:22:38.102651600 +0100upgrade.test.out.FILTERED 2018-12-07 02:22:38.102651600 +0100
1 Statistics about stdout of test 'upgrade` in directory 'sql/test/testdb-upgrade`: 1 1 Statistics about stdout of test 'upgrade` in directory 'sql/test/testdb-upgrade`: 1
2 15 lines, 81 words, 522 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 2 lines, 17 words, 124 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 15 lines, 81 words, 522 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 2 lines, 17 words, 124 chars in lines not matching '^$|^(\| |)#` 3
4 # 47 lines, 220 words, 1724 chars in all lines 4 ! 4 # 25 lines, 110 words, 914 chars in all lines 4
5 5 5 5
..................
# 47 lines, 220 words,
8 8 8 8
9 # 21:49:40 > 9 ! 9 # 02:22:37 > 9
10 # 21:49:40 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=30515" "--set" "mapi_usock=/var/tmp/mtest-14642/.s.monetdb.30515" "--set" "monet_prompt=" "--forcemito" "--set" "mal_listing=2" "--dbpath=/ufs/sjoerd/Monet-devel/var/MonetDB/mTests_sql_test_testdb-upgrade" "--set" "mal_listing=0" 10 ! 10 # 02:22:37 > "mserver5" "--debug=10" "--set" "gdk_nr_threads=0" "--set" "mapi_open=true" "--set" "mapi_port=33672" "--set" "monet_prompt=" "--forcemito" "--dbpath=C:\monettesting\350cc55cd57a-9-1-2\tests\sql\dbfarm\mTests_sql_test_testdb-upgrade" "--set" "embedded_c=true" 10
11 # 21:49:40 > 11 ! 11 # 02:22:37 > 11
12 12 ! 12 12
13 # MonetDB 5 server v11.16.0 (hg id: fd9db07674cf+) 13 ! 13 # MonetDB 5 server v11.32.0 (default-350cc55cd57a) 13
14 # This is an unreleased version 14 ! 14 # Serving database 'mTests_sql_test_testdb-upgrade', using 6 threads 14
15 # Serving database 'mTests_sql_test_testdb-upgrade', using 8 threads 15 ! 15 # Compiled for i686-pc-winnt/32bit 15
16 # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs dynamically linked 16 ! 16 # Found 1.999 GiB available main-memory. 16
17 # Found 15.591 GiB available main-memory. 17 ! 17 # Copyright (c) 1993 - July 2008 CWI. 17
18 # Copyright (c) 1993-July 2008 CWI. 18 ! 18 # Copyright (c) August 2008 - 2018 MonetDB B.V., all rights reserved 18
19 # Copyright (c) August 2008-2015 MonetDB B.V., all rights reserved 19 ! 19 # Visit https://www.monetdb.org/ for further information 19
20 # Visit http://www.monetdb.org/ for further information 20 ! 20 # Listening for connection requests on mapi:monetdb://win2k12r2:33672/ 20
21 # Listening for connection requests on mapi:monetdb://madrid.da.cwi.nl:34708/ 21 -
22 # Listening for UNIX domain connection requests on mapi:monetdb:///var/tmp/mtest-11915/.s.monetdb.34708 22 -
23 # MonetDB/GIS module loaded 23 21 # MonetDB/GIS module loaded 21
24 Running database upgrade commands: 24 ! 22 22
25 set schema sys; 25 ! 23 23
26 drop table sys.systemfunctions; 26 ! 24 ! Server not ready; skipping attempt to start client! 24
27 create view sys.systemfunctions as select id as function_id from sys.functions where system; 27 ! 25 25
28 grant select on sys.systemfunctions to public; 28 ! 26 26
29 update sys._tables set system = true where name = 'systemfunctions' and schema_id = (select id from sys.schemas where name = 'sys'); 29 ! 27 # 02:22:38 > 27
30 set schema "sys"; 30 ! 28 # 02:22:38 > "Done." 28
31 commit; 31 ! 29 # 02:22:38 > 29
32 32 -
33 # MonetDB/SQL module loaded 33 -
34 34 -
35 Ready. 35 -
36 36 -
37 # 16:03:28 > 37 -
38 # 16:03:28 > "/usr/bin/python" "upgrade.SQL.py" "upgrade" 38 -
39 # 16:03:28 > 39 -
40 40 -
41 #select count(*) from testschema.smallstring; 41 -
42 % testschema.L3 # table_name 42 -
43 % L # name 43 -
44 # L3 # name 44 -
45 % bigint # type 45 -
46 % 2 # length 46 -
47 [ 66 ] 47 -
48 48 -
49 # 21:49:42 > 49 -
50 # 21:49:42 > "Done." 50 -
51 # 21:49:42 > 51 -
52 52 30 30