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 10:31:01.000000000 +0200select_window_function_and_asterisk.Bug-6722.test.out.FILTERED 2019-09-12 10:31:01.000000000 +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 # 100 lines, 602 words, 3366 chars in all lines 4
5 5 5 5
..................
#from test_6722
42 #order by part, qty; 42 40 #order by part, qty; 40
43 % sys., sys., sys.test_6722, sys.test_6722 # table_name 43 + 41 % sys., sys., sys.test_6722, sys.test_6722, sys., sys. # table_name 41
44 # sys.L5, sys.L12, sys.test_6722, sys.test_6722 # table_name 44 + 42 # sys.L5, sys.L12, sys.test_6722, sys.test_6722, sys.L3, sys.L10 # table_name 42
45 % rank_id, row_id, part, qty # name 45 + 43 % rank_id, row_id, part, qty, L, L # name 43
46 % int, int, clob, double # type 46 ! 44 # rank_id, row_id, part, qty, L3, L10 # name 44
47 % 1, 2, 1, 24 # length 47 ! 45 % int, int, clob, double, int, int # type 45
48 [ 1, 1, "a", 13 ] 48 ! 46 % 1, 2, 1, 24, 1, 2 # length 46
49 [ 2, 2, "a", 16 ] 49 ! 47 [ 1, 1, "a", 13, 1, 1 ] 47
50 [ 3, 3, "a", 18 ] 50 ! 48 [ 2, 2, "a", 16, 2, 2 ] 48
51 [ 4, 4, "b", 15 ] 51 ! 49 [ 3, 3, "a", 18, 3, 3 ] 49
52 [ 5, 5, "b", 16 ] 52 ! 50 [ 4, 4, "b", 15, 4, 4 ] 50
53 [ 6, 6, "c", 12 ] 53 ! 51 [ 5, 5, "b", 16, 5, 5 ] 51
54 [ 7, 7, "c", 17 ] 54 ! 52 [ 6, 6, "c", 12, 6, 6 ] 52
55 [ 8, 8, "c", 18 ] 55 ! 53 [ 7, 7, "c", 17, 7, 7 ] 53
56 [ 9, 9, "d", 12 ] 56 ! 54 [ 8, 8, "c", 18, 8, 8 ] 54
57 [ 9, 10, "d", 12 ] 57 ! 55 [ 9, 9, "d", 12, 9, 9 ] 55
+ 56 [ 9, 10, "d", 12, 9, 10 ] 56
58 #select 58 57 #select 57
..................
#from test_6722
63 #order by part, qty; 63 62 #order by part, qty; 62
64 % sys., sys.test_6722, sys.test_6722, sys. # table_name 64 + 63 % sys., sys.test_6722, sys.test_6722, sys., sys. # table_name 63
65 # sys.L5, sys.test_6722, sys.test_6722, sys.L14 # table_name 65 + 64 # sys.L5, sys.test_6722, sys.test_6722, sys.L3, sys.L14 # table_name 64
66 % rank_id, part, qty, row_id # name 66 + 65 % rank_id, part, qty, L, row_id # name 65
67 % int, clob, double, int # type 67 ! 66 # rank_id, part, qty, L3, row_id # name 66
68 % 1, 1, 24, 2 # length 68 ! 67 % int, clob, double, int, int # type 67
69 [ 1, "a", 13, 1 ] 69 ! 68 % 1, 1, 24, 1, 2 # length 68
70 [ 2, "a", 16, 2 ] 70 ! 69 [ 1, "a", 13, 1, 1 ] 69
71 [ 3, "a", 18, 3 ] 71 ! 70 [ 2, "a", 16, 2, 2 ] 70
72 [ 4, "b", 15, 4 ] 72 ! 71 [ 3, "a", 18, 3, 3 ] 71
73 [ 5, "b", 16, 5 ] 73 ! 72 [ 4, "b", 15, 4, 4 ] 72
74 [ 6, "c", 12, 6 ] 74 ! 73 [ 5, "b", 16, 5, 5 ] 73
75 [ 7, "c", 17, 7 ] 75 ! 74 [ 6, "c", 12, 6, 6 ] 74
76 [ 8, "c", 18, 8 ] 76 ! 75 [ 7, "c", 17, 7, 7 ] 75
77 [ 9, "d", 12, 9 ] 77 ! 76 [ 8, "c", 18, 8, 8 ] 76
78 [ 9, "d", 12, 10 ] 78 ! 77 [ 9, "d", 12, 9, 9 ] 77
+ 78 [ 9, "d", 12, 9, 10 ] 78
79 #select 79 79 #select 79