Changeset: 0bf85f9281e3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=0bf85f9281e3 Modified Files: sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test sql/test/BugTracker-2018/Tests/copy-into-doubled.Bug-6666.test Branch: unlock Log Message:
locked is gone, ie use copy into without diffs (truncated from 405 to 300 lines): diff --git a/sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test b/sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test --- a/sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test +++ b/sql/test/BugTracker-2017/Tests/crash_after_oidx_on_sys_statistics.Bug-6251.test @@ -8,23 +8,279 @@ ANALYZE sys.statistics query TIIIIITT rowsort SELECT "type", width, "sample", "count", "unique", nils, sorted, revsorted FROM sys.statistics WHERE "type" <> 'timestamp' ORDER BY column_id ---- -88 values hashing to fa7a56aab06b99577844b9b68431ab23 +bigint +8 +4 +4 +4 +0 +True +False +bigint +8 +5 +5 +5 +0 +True +False +bigint +8 +6 +6 +6 +0 +True +False +bigint +8 +7 +7 +1 +0 +True +True +boolean +1 +10 +10 +2 +0 +False +False +boolean +1 +11 +11 +2 +0 +False +False +clob +1 +1 +1 +1 +0 +True +True +clob +1 +8 +8 +5 +1 +False +False +clob +1 +9 +9 +7 +1 +False +False +int +4 +0 +0 +0 +0 +True +True +int +4 +2 +2 +2 +0 +False +True query TIIIIITT rowsort -- update the values of: sample, count, unique, nils, minval, maxval, sorted, revsorted of sys.statistics ANALYZE sys.statistics ---- -88 values hashing to fa7a56aab06b99577844b9b68431ab23 +bigint +8 +4 +4 +4 +0 +True +False +bigint +8 +5 +5 +5 +0 +True +False +bigint +8 +6 +6 +6 +0 +True +False +bigint +8 +7 +7 +1 +0 +True +True +boolean +1 +10 +10 +2 +0 +False +False +boolean +1 +11 +11 +2 +0 +False +False +clob +1 +1 +1 +1 +0 +True +True +clob +1 +8 +8 +5 +1 +False +False +clob +1 +9 +9 +7 +1 +False +False +int +4 +0 +0 +0 +0 +True +True +int +4 +2 +2 +2 +0 +False +True query TIIIIITT rowsort SELECT "type", width, "sample", "count", "unique", nils, sorted, revsorted FROM sys.statistics WHERE "type" <> 'timestamp' ORDER BY column_id ---- -88 values hashing to e19d7ecd15ac7c1ead9005b72feb9b3c - -query TIIIIITT rowsort --- ALTER TABLE sys.statistics SET READ ONLY ----- -88 values hashing to e19d7ecd15ac7c1ead9005b72feb9b3c +bigint +8 +16 +16 +16 +0 +True +False +bigint +8 +17 +17 +17 +0 +True +False +bigint +8 +18 +18 +12 +0 +False +False +bigint +8 +19 +19 +2 +0 +False +False +boolean +1 +22 +22 +2 +0 +False +False +boolean +1 +23 +23 +2 +0 +False +False +clob +1 +13 +13 +5 +0 +False +False +clob +1 +20 +20 +8 +1 +False +False +clob +2 +21 +21 +16 +1 +False +False +int +4 +12 +12 +12 +0 +True +False +int +4 +14 +14 +3 +0 +False +False statement ok CREATE ORDERED INDEX stat_oidx ON sys.statistics (width) @@ -32,13 +288,94 @@ CREATE ORDERED INDEX stat_oidx ON sys.st query TIIIIITT rowsort SELECT "type", width, "sample", "count", "unique", nils, sorted, revsorted FROM sys.statistics WHERE "type" <> 'timestamp' ORDER BY column_id ---- -88 values hashing to e19d7ecd15ac7c1ead9005b72feb9b3c - -query TIIIIITT rowsort --- now mserver5 is crashed !! --- ALTER TABLE sys.statistics SET READ WRITE _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
