8000 Added missing test files · FirebirdSQL/python3-lib@133245f · GitHub
[go: up one dir, main page]
Skip to content

Commit 133245f

Browse files
pcisarpcisar
committed
Added missing test files
1 parent 146e59d commit 133245f

File tree

9 files changed

+6605
-0
lines changed

9 files changed

+6605
-0
lines changed

‎test/fbtest30.fdb

2.87 MB
Binary file not shown.

‎test/gstat30-a.out

Lines changed: 750 additions & 0 deletions
Large diffs are not rendered by default.

‎test/gstat30-d.out

Lines changed: 243 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,243 @@
1+
2+
Database "/home/fdb/test/FBTEST30.FDB"
3+
Gstat execution time Wed Apr 04 15:42:12 2018
4+
5+
Database header page information:
6+
Flags 0
7+
Generation 2177
8+
System Change Number 24
9+
Page size 8192
10+
ODS version 12.0
11+
Oldest transaction 179
12+
Oldest active 2142
13+
Oldest snapshot 2142
14+
Next transaction 2142
15+
Sequence number 0
16+
Next attachment ID 1202
17+
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
18+
Shadow count 0
19+
Page buffers 0
20+
Next header page 0
21+
Database dialect 3
22+
Creation date Nov 27, 2015 11:19:39
23+
Attributes force write
24+
25+
Variable header data:
26+
Database backup GUID: {F978F787-7023-4C4A-F79D-8D86645B0487}
27+
*END*
28+
29+
30+
Database file sequence:
31+
File /home/fdb/test/FBTEST30.FDB is the only file
32+
33+
Analyzing database pages ...
34+
AR (140)
35+
Primary pointer page: 297, Index root page: 299
36+
Pointer pages: 1, data page slots: 3
37+
Data pages: 3, average fill: 86%
38+
Primary pages: 1, secondary pages: 2, swept pages: 0
39+
Empty pages: 0, full pages: 1
40+
Fill distribution:
41+
0 - 19% = 0
42+
20 - 39% = 0
43+
40 - 59% = 0
44+
60 - 79% = 1
45+
80 - 99% = 2
46+
47+
COUNTRY (128)
48+
Primary pointer page: 182, Index root page: 183
49+
Pointer pages: 1, data page slots: 1
50+
Data pages: 1, average fill: 8%
51+
Primary pages: 1, secondary pages: 0, swept pages: 0
52+
Empty pages: 0, full pages: 0
53+
Fill distribution:
54+
0 - 19% = 1
55+
20 - 39% = 0
56+
40 - 59% = 0
57+
60 - 79% = 0
58+
80 - 99% = 0
59+
60+
CUSTOMER (137)
61+
Primary pointer page: 261, Index root page: 262
62+
Pointer pages: 1, data page slots: 1
63+
Data pages: 1, average fill: 26%
64+
Primary pages: 1, secondary pages: 0, swept pages: 0
65+
Empty pages: 0, full pages: 0
66+
Fill distribution:
67+
0 - 19% = 0
68+
20 - 39% = 1
69+
40 - 59% = 0
70+
60 - 79% = 0
71+
80 - 99% = 0
72+
73+
DEPARTMENT (130)
74+
Primary pointer page: 198, Index root page: 199
75+
Pointer pages: 1, data page slots: 1
76+
Data pages: 1, average fill: 24%
77+
Primary pages: 1, secondary pages: 0, swept pages: 1
78+
Empty pages: 0, full pages: 0
79+
Fill distribution:
80+
0 - 19% = 0
81+
20 - 39% = 1
82+
40 - 59% = 0
83+
60 - 79% = 0
84+
80 - 99% = 0
85+
86+
EMPLOYEE (131)
87+
Primary pointer page: 212, Index root page: 213
88+
Pointer pages: 1, data page slots: 1
89+
Data pages: 1, average fill: 44%
90+
Primary pages: 1, secondary pages: 0, swept pages: 1
91+
Empty pages: 0, full pages: 0
92+
Fill distribution:
93+
0 - 19% = 0
94+
20 - 39% = 0
95+
40 - 59% = 1
96+
60 - 79% = 0
97+
80 - 99% = 0
98+
99+
EMPLOYEE_PROJECT (134)
100+
Primary pointer page: 234, Index root page: 235
101+
Pointer pages: 1, data page slots: 1
102+
Data pages: 1, average fill: 10%
103+
Primary pages: 1, secondary pages: 0, swept pages: 0
104+
Empty pages: 0, full pages: 0
105+
Fill distribution:
106+
0 - 19% = 1
107+
20 - 39% = 0
108+
40 - 59% = 0
109+
60 - 79% = 0
110+
80 - 99% = 0
111+
112+
JOB (129)
113+
Primary pointer page: 189, Index root page: 190
114+
Pointer pages: 1, data page slots: 2
115+
Data pages: 2, average fill: 54%
116+
Primary pages: 1, secondary pages: 1, swept pages: 1
117+
Empty pages: 0, full pages: 0
118+
Fill distribution:
119+
0 - 19% = 0
120+
20 - 39% = 1
121+
40 - 59% = 0
122+
60 - 79% = 1
123+
80 - 99% = 0
124+
125+
PROJECT (133)
126+
Primary pointer page: 220, Index root page: 221
127+
Pointer pages: 1, data page slots: 2
128+
Data pages: 2, average fill: 7%
129+
Primary pages: 1, secondary pages: 1, swept pages: 1
130+
Empty pages: 0, full pages: 0
131+
Fill distribution:
132+
0 - 19% = 2
133+
20 - 39% = 0
134+
40 - 59% = 0
135+
60 - 79% = 0
136+
80 - 99% = 0
137+
138+
PROJ_DEPT_BUDGET (135)
139+
Primary pointer page: 239, Index root page: 248
140+
Pointer pages: 1, data page slots: 2
141+
Data pages: 2, average fill: 20%
142+
Primary pages: 1, secondary pages: 1, swept pages: 0
143+
Empty pages: 0, full pages: 0
144+
Fill distribution:
145+
0 - 19% = 1
146+
20 - 39% = 1
147+
40 - 59% = 0
148+
60 - 79% = 0
149+
80 - 99% = 0
150+
151+
SALARY_HISTORY (136)
152+
Primary pointer page: 253, Index root page: 254
153+
Pointer pages: 1, data page slots: 1
154+
Data pages: 1, average fill: 30%
155+
Primary pages: 1, secondary pages: 0, swept pages: 0
156+
Empty pages: 0, full pages: 0
157+
Fill distribution:
158+
0 - 19% = 0
159+
20 - 39% = 1
160+
40 - 59% = 0
161+
60 - 79% = 0
162+
80 - 99% = 0
163+
164+
SALES (138)
165+
Primary pointer page: 267, Index root page: 268
166+
Pointer pages: 1, data page slots: 1
167+
Data pages: 1, average fill: 35%
168+
Primary pages: 1, secondary pages: 0, swept pages: 0
169+
Empty pages: 0, full pages: 0
170+
Fill distribution:
171+
0 - 19% = 0
172+
20 - 39% = 1
173+
40 - 59% = 0
174+
60 - 79% = 0
175+
80 - 99% = 0
176+
177+
T (147)
178+
Primary pointer page: 323, Index root page: 324
179+
Pointer pages: 1, data page slots: 0
180+
Data pages: 0, average fill: 0%
181+
Primary pages: 0, secondary pages: 0, swept pages: 0
182+
Empty pages: 0, full pages: 0
183+
Fill distribution:
184+
0 - 19% = 0
185+
20 - 39% = 0
186+
40 - 59% = 0
187+
60 - 79% = 0
188+
80 - 99% = 0
189+
190+
T2 (142)
191+
Primary pointer page: 302, Index root page: 303
192+
Pointer pages: 1, data page slots: 2
193+
Data pages: 2, average fill: 8%
194+
Primary pages: 1, secondary pages: 1, swept pages: 0
195+
Empty pages: 0, full pages: 0
196+
Fill distribution:
197+
0 - 19% = 2
198+
20 - 39% = 0
199+
40 - 59% = 0
200+
60 - 79% = 0
201+
80 - 99% = 0
202+
203+
T3 (143)
204+
Primary pointer page: 305, Index root page: 306
205+
Pointer pages: 1, data page slots: 2
206+
Data pages: 2, average fill: 3%
207+
Primary pages: 1, secondary pages: 1, swept pages: 0
208+
Empty pages: 0, full pages: 0
209+
Fill distribution:
210+
0 - 19% = 2
211+
20 - 39% = 0
212+
40 - 59% = 0
213+
60 - 79% = 0
214+
80 - 99% = 0
215+
216+
T4 (144)
217+
Primary pointer page: 307, Index root page: 308
218+
Pointer pages: 1, data page slots: 1
219+
Data pages: 1, average fill: 3%
220+
Primary pages: 1, secondary pages: 0, swept pages: 0
221+
Empty pages: 0, full pages: 0
222+
Fill distribution:
223+
0 - 19% = 1
224+
20 - 39% = 0
225+
40 - 59% = 0
226+
60 - 79% = 0
227+
80 - 99% = 0
228+
229+
T5 (145)
230+
Primary pointer page: 315, Index root page: 316
231+
Pointer pages: 1, data page slots: 0
232+
Data pages: 0, average fill: 0%
233+
Primary pages: 0, secondary pages: 0, swept pages: 0
234+
Empty pages: 0, full pages: 0
235+
Fill distribution:
236+
0 - 19% = 0
237+
20 - 39% = 0
238+
40 - 59% = 0
239+
60 - 79% = 0
240+
80 - 99% = 0
241+
242+
Gstat completion time Wed Apr 04 15:42:12 2018
243+

‎test/gstat30-e.out

Lines changed: 33 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,33 @@
1+
2+
Database "/home/fdb/test/FBTEST30.FDB"
3+
Gstat execution time Wed Apr 04 15:45:06 2018
4+
5+
Database header page information:
6+
Flags 0
7+
Generation 2181
8+
System Change Number 24
9+
Page size 8192
10+
ODS version 12.0
11+
Oldest transaction 179
12+
Oldest active 2146
13+
Oldest snapshot 2146
14+
Next transaction 2146
15+
Sequence number 0
16+
Next attachment ID 1214
17+
Implementation HW=AMD/Intel/x64 little-endian OS=Linux CC=gcc
18+
Shadow count 0
19+
Page buffers 0
20+
Next header page 0
21+
Database dialect 3
22+
Creation date Nov 27, 2015 11:19:39
23+
Attributes force write
24+
25+
Variable header data:
26+
Database backup GUID: {F978F787-7023-4C4A-F79D-8D86645B0487}
27+
*END*
28+
29+
Data pages: total 121, encrypted 0, non-crypted 121
30+
Index pages: total 96, encrypted 0, non-crypted 96
31+
Blob pages: total 11, encrypted 0, non-crypted 11
32+
Gstat completion time Wed Apr 04 15:45:06 2018
33+

0 commit comments

Comments
 (0)
0