Test select_window_function_and_asterisk.Bug-6722.sql (id fe8055a86502) (err)
select_window_function_and_asterisk.Bug-6722.stable.out.FILTERED 2019-09-12 11:26:05.467889000 +0200select_window_function_and_asterisk.Bug-6722.test.out.FILTERED 2019-09-12 11:26:05.467889000 +0200
1 Statistics about stdout of test 'select_window_function_and_asterisk.Bug-6722` in directory 'sql/test/BugTracker-2019`: 1 1 Statistics about stdout of test 'select_window_function_and_asterisk.Bug-6722` in directory 'sql/test/BugTracker-2019`: 1
2 45 lines, 276 words, 1063 chars in lines not matching '^$|^(\| |)#|^=` 2 ! 2 45 lines, 318 words, 1205 chars in lines not matching '^$|^(\| |)#|^=` 2
3 = 45 lines, 276 words, 1063 chars in lines not matching '^$|^(\| |)#` 3 ! 3 = 45 lines, 318 words, 1205 chars in lines not matching '^$|^(\| |)#` 3
4 # 100 lines, 553 words, 3188 chars in all lines 4 ! 4 # 99 lines, 586 words, 3103 chars in all lines 4
5 5 5 5
..................
#from test_6722
42 #order by part, qty; 42 39 #order by part, qty; 39
43 % sys., sys., sys.test_6722, sys.test_6722 # table_name 43 + 40 % sys., sys., sys.test_6722, sys.test_6722, sys., sys. # table_name 40
44 # sys.L5, sys.L12, sys.test_6722, sys.test_6722 # table_name 44 + 41 # sys.L5, sys.L12, sys.test_6722, sys.test_6722, sys.L3, sys.L10 # table_name 41
45 % rank_id, row_id, part, qty # name 45 + 42 % rank_id, row_id, part, qty, L, L # name 42
46 % int, int, clob, double # type 46 ! 43 # rank_id, row_id, part, qty, L3, L10 # name 43
47 % 1, 2, 1, 24 # length 47 ! 44 % int, int, clob, double, int, int # type 44
48 [ 1, 1, "a", 13 ] 48 ! 45 % 1, 2, 1, 24, 1, 2 # length 45
49 [ 2, 2, "a", 16 ] 49 ! 46 [ 1, 1, "a", 13, 1, 1 ] 46
50 [ 3, 3, "a", 18 ] 50 ! 47 [ 2, 2, "a", 16, 2, 2 ] 47
51 [ 4, 4, "b", 15 ] 51 ! 48 [ 3, 3, "a", 18, 3, 3 ] 48
52 [ 5, 5, "b", 16 ] 52 ! 49 [ 4, 4, "b", 15, 4, 4 ] 49
53 [ 6, 6, "c", 12 ] 53 ! 50 [ 5, 5, "b", 16, 5, 5 ] 50
54 [ 7, 7, "c", 17 ] 54 ! 51 [ 6, 6, "c", 12, 6, 6 ] 51
55 [ 8, 8, "c", 18 ] 55 ! 52 [ 7, 7, "c", 17, 7, 7 ] 52
56 [ 9, 9, "d", 12 ] 56 ! 53 [ 8, 8, "c", 18, 8, 8 ] 53
57 [ 9, 10, "d", 12 ] 57 ! 54 [ 9, 9, "d", 12, 9, 9 ] 54
+ 55 [ 9, 10, "d", 12, 9, 10 ] 55
58 #select 58 56 #select 56
..................
#from test_6722
63 #order by part, qty; 63 61 #order by part, qty; 61
64 % sys., sys.test_6722, sys.test_6722, sys. # table_name 64 + 62 % sys., sys.test_6722, sys.test_6722, sys., sys. # table_name 62
65 # sys.L5, sys.test_6722, sys.test_6722, sys.L14 # table_name 65 + 63 # sys.L5, sys.test_6722, sys.test_6722, sys.L3, sys.L14 # table_name 63
66 % rank_id, part, qty, row_id # name 66 + 64 % rank_id, part, qty, L, row_id # name 64
67 % int, clob, double, int # type 67 ! 65 # rank_id, part, qty, L3, row_id # name 65
68 % 1, 1, 24, 2 # length 68 ! 66 % int, clob, double, int, int # type 66
69 [ 1, "a", 13, 1 ] 69 ! 67 % 1, 1, 24, 1, 2 # length 67
70 [ 2, "a", 16, 2 ] 70 ! 68 [ 1, "a", 13, 1, 1 ] 68
71 [ 3, "a", 18, 3 ] 71 ! 69 [ 2, "a", 16, 2, 2 ] 69
72 [ 4, "b", 15, 4 ] 72 ! 70 [ 3, "a", 18, 3, 3 ] 70
73 [ 5, "b", 16, 5 ] 73 ! 71 [ 4, "b", 15, 4, 4 ] 71
74 [ 6, "c", 12, 6 ] 74 ! 72 [ 5, "b", 16, 5, 5 ] 72
75 [ 7, "c", 17, 7 ] 75 ! 73 [ 6, "c", 12, 6, 6 ] 73
76 [ 8, "c", 18, 8 ] 76 ! 74 [ 7, "c", 17, 7, 7 ] 74
77 [ 9, "d", 12, 9 ] 77 ! 75 [ 8, "c", 18, 8, 8 ] 75
78 [ 9, "d", 12, 10 ] 78 ! 76 [ 9, "d", 12, 9, 9 ] 76
+ 77 [ 9, "d", 12, 9, 10 ] 77
79 #select 79 78 #select 78