-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathAllFS.sql
546 lines (546 loc) · 133 KB
/
AllFS.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
with q1 as (
select 'ADFS' [File system], 'Acorn Computers Ltd' [Creator], '1983' [Year of introduction], 'Acorn Electron (later Arthur/RISC OS)' [Original operating system]
union all select 'AdvFS' [File system], 'DEC' [Creator], '1993[4]' [Year of introduction], 'Digital Unix' [Original operating system]
union all select 'Amiga FFS' [File system], 'Commodore' [Creator], '1988' [Year of introduction], 'Amiga OS 1.3' [Original operating system]
union all select 'Amiga OFS' [File system], 'Metacomco for Commodore' [Creator], '1985' [Year of introduction], 'Amiga OS' [Original operating system]
union all select 'APFS' [File system], 'Apple' [Creator], '2016' [Year of introduction], 'macOS High Sierra, iOS 10.3' [Original operating system]
union all select 'Atari DOS' [File system], 'Atari' [Creator], '1979' [Year of introduction], 'Atari 8-bit' [Original operating system]
union all select 'bcachefs' [File system], 'Kent Overstreet' [Creator], '2015' [Year of introduction], 'Linux' [Original operating system]
union all select 'BFS' [File system], 'Be Inc. (D. Giampaolo, Cyril Meurillon)' [Creator], '1996' [Year of introduction], 'BeOS' [Original operating system]
union all select 'BeeGFS' [File system], 'Fraunhofer/ ThinkParQ' [Creator], '2005' [Year of introduction], 'Linux' [Original operating system]
union all select 'BlueStore/Cephfs' [File system], 'Red Hat, University of California, Santa Cruz' [Creator], '2017' [Year of introduction], 'Linux' [Original operating system]
union all select 'Btrfs' [File system], 'Chris Mason' [Creator], '2007' [Year of introduction], 'Linux' [Original operating system]
union all select 'CASL' [File system], 'Nimble Storage' [Creator], '2010' [Year of introduction], 'Linux' [Original operating system]
union all select 'CBM DOS' [File system], 'Commodore' [Creator], '1978' [Year of introduction], 'Commodore BASIC' [Original operating system]
union all select 'CHFS' [File system], 'University of Szeged' [Creator], '2011' [Year of introduction], 'NetBSD 6.0+' [Original operating system]
union all select 'CP/M file system' [File system], 'Digital Research (Gary Kildall)' [Creator], '1974' [Year of introduction], 'CP/M[1][2]' [Original operating system]
union all select 'DECtape' [File system], 'DEC' [Creator], '1964' [Year of introduction], 'PDP-6 Monitor' [Original operating system]
union all select 'DFS' [File system], 'Acorn Computers Ltd' [Creator], '1982' [Year of introduction], 'Acorn BBC Micro MOS' [Original operating system]
union all select 'Disk Operating System (GEC DOS)' [File system], 'GEC' [Creator], '1973' [Year of introduction], 'Core Operating System' [Original operating system]
union all select 'DOS 3.x' [File system], 'Apple' [Creator], '1978' [Year of introduction], 'Apple DOS' [Original operating system]
union all select 'Elektronika BK tape format' [File system], 'NPO "Scientific centre" (now Sitronics)' [Creator], '1985' [Year of introduction], 'Vilnius Basic, BK monitor program' [Original operating system]
union all select 'EROFS' [File system], 'Huawei[7]' [Creator], '2018' [Year of introduction], 'Android' [Original operating system]
union all select 'exFAT' [File system], 'Microsoft' [Creator], '2006' [Year of introduction], 'Windows CE 6.0' [Original operating system]
union all select 'ext' [File system], 'Rémy Card' [Creator], '1992' [Year of introduction], 'Linux' [Original operating system]
union all select 'ext2' [File system], 'Rémy Card' [Creator], '1993' [Year of introduction], 'Linux, Hurd' [Original operating system]
union all select 'ext3' [File system], 'Stephen Tweedie' [Creator], '1999' [Year of introduction], 'Linux' [Original operating system]
union all select 'ext4' [File system], 'various' [Creator], '2006' [Year of introduction], 'Linux' [Original operating system]
union all select 'F2FS' [File system], 'Samsung Electronics' [Creator], '2012' [Year of introduction], 'Linux' [Original operating system]
union all select 'FAT (8-bit)' [File system], 'Microsoft (Marc McDonald) for NCR' [Creator], '1977' [Year of introduction], 'Microsoft Standalone Disk BASIC-80 (later Microsoft Standalone Disk BASIC-86)' [Original operating system]
union all select 'FAT12' [File system], 'Seattle Computer Products (Tim Paterson)' [Creator], '1980' [Year of introduction], 'QDOS/86-DOS (later IBM PC DOS 1.0)' [Original operating system]
union all select 'FAT16' [File system], 'IBM, Microsoft' [Creator], '1984' [Year of introduction], 'PC DOS 3.0, MS-DOS 3.0' [Original operating system]
union all select 'FAT16B' [File system], 'Compaq' [Creator], '1987' [Year of introduction], 'Compaq MS-DOS 3.31' [Original operating system]
union all select 'FAT16X' [File system], 'Microsoft' [Creator], '1995' [Year of introduction], 'MS-DOS 7.0 / Windows 95' [Original operating system]
union all select 'FAT32' [File system], 'Microsoft' [Creator], '1996' [Year of introduction], 'MS-DOS 7.10 / Windows 95 OSR2[b]' [Original operating system]
union all select 'FAT32X' [File system], 'Microsoft' [Creator], '1996' [Year of introduction], 'MS-DOS 7.10 / Windows 95 OSR2[b]' [Original operating system]
union all select 'FATX' [File system], 'Microsoft' [Creator], '2002' [Year of introduction], 'Xbox' [Original operating system]
union all select 'FFS' [File system], 'Kirk McKusick' [Creator], '1983' [Year of introduction], '4.2BSD' [Original operating system]
union all select 'Fossil' [File system], 'Bell Labs' [Creator], '2003' [Year of introduction], 'Plan 9 version 4' [Original operating system]
union all select 'GEC DOS filing system extended' [File system], 'GEC' [Creator], '1977' [Year of introduction], 'OS4000' [Original operating system]
union all select 'GEMDOS' [File system], 'Digital Research' [Creator], '1985' [Year of introduction], 'Atari TOS' [Original operating system]
union all select 'George 3' [File system], 'ICT (later ICL)' [Creator], '1968' [Year of introduction], 'George 3' [Original operating system]
union all select 'GFS' [File system], 'Sistina (Red Hat)' [Creator], '2000' [Year of introduction], 'Linux' [Original operating system]
union all select 'GFS2' [File system], 'Red Hat' [Creator], '2006' [Year of introduction], 'Linux' [Original operating system]
union all select 'GlusterFS' [File system], 'Gluster Inc.' [Creator], '2005' [Year of introduction], 'Linux' [Original operating system]
union all select 'Google File System' [File system], 'Google' [Creator], '2003' [Year of introduction], 'Linux' [Original operating system]
union all select 'GPFS' [File system], 'IBM' [Creator], '1996' [Year of introduction], 'AIX, Linux' [Original operating system]
union all select 'HAMMER' [File system], 'Matthew Dillon' [Creator], '2008' [Year of introduction], 'DragonFly BSD 2.0' [Original operating system]
union all select 'HAMMER2' [File system], 'Matthew Dillon[6]' [Creator], '2017' [Year of introduction], 'DragonFly BSD 5.0' [Original operating system]
union all select 'HFS' [File system], 'Apple' [Creator], '1985' [Year of introduction], 'System 2.1' [Original operating system]
union all select 'HFS' [File system], 'IBM' [Creator], '1994' [Year of introduction], 'MVS/ESA (now z/OS)' [Original operating system]
union all select 'HFS+' [File system], 'Apple' [Creator], '1998' [Year of introduction], 'Mac OS 8.1' [Original operating system]
union all select 'High Sierra' [File system], 'Ecma International' [Creator], '1986' [Year of introduction], 'MSCDEX for MS-DOS 3.1/3.2[3]' [Original operating system]
union all select 'HPFS' [File system], 'IBM & Microsoft' [Creator], '1989' [Year of introduction], 'OS/2 1.2' [Original operating system]
union all select 'ISO 9660:1988' [File system], 'Ecma International, ISO' [Creator], '1988' [Year of introduction], 'MS-DOS, "classic" Mac OS, and AmigaOS' [Original operating system]
union all select 'ISO 9660:1999' [File system], 'Ecma International, ISO' [Creator], '1999' [Year of introduction], 'Microsoft Windows, Linux, "classic" Mac OS, FreeBSD, and AmigaOS' [Original operating system]
union all select 'JFS' [File system], 'IBM' [Creator], '1999' [Year of introduction], 'OS/2 Warp Server for e-business' [Original operating system]
union all select 'JFS1' [File system], 'IBM' [Creator], '1990' [Year of introduction], 'AIX[a]' [Original operating system]
union all select 'Joliet ("CDFS")' [File system], 'Microsoft' [Creator], '1995' [Year of introduction], 'Microsoft Windows, Linux, "classic" Mac OS, and FreeBSD' [Original operating system]
union all select 'JXFS' [File system], 'Hyperion Entertainment' [Creator], '2008' [Year of introduction], 'AmigaOS 4.1' [Original operating system]
union all select 'Level-D' [File system], 'DEC' [Creator], '1968' [Year of introduction], 'TOPS-10' [Original operating system]
union all select 'LFS' [File system], 'Margo Seltzer' [Creator], '1993' [Year of introduction], 'Berkeley Sprite' [Original operating system]
union all select 'LSFS' [File system], 'StarWind Software' [Creator], '2009' [Year of introduction], 'Linux, FreeBSD, Windows' [Original operating system]
union all select 'Lustre' [File system], 'Cluster File Systems[5]' [Creator], '2002' [Year of introduction], 'Linux' [Original operating system]
union all select 'MFS' [File system], 'Apple' [Creator], '1984' [Year of introduction], 'System 1' [Original operating system]
union all select 'Minix V1' [File system], 'Andrew S. Tanenbaum' [Creator], '1987' [Year of introduction], 'MINIX 1.0' [Original operating system]
union all select 'Minix V2' [File system], 'Andrew S. Tanenbaum' [Creator], '1997' [Year of introduction], 'MINIX 2.0' [Original operating system]
union all select 'Minix V3' [File system], 'Andrew S. Tanenbaum' [Creator], '2005' [Year of introduction], 'MINIX 3' [Original operating system]
union all select 'NILFS' [File system], 'NTT' [Creator], '2005' [Year of introduction], 'Linux' [Original operating system]
union all select 'Non-Volatile File System' [File system], 'Palm, Inc.' [Creator], '2004' [Year of introduction], 'Palm OS Garnet' [Original operating system]
union all select 'NOVA' [File system], 'UC, San Diego' [Creator], '2017' [Year of introduction], 'Linux' [Original operating system]
union all select 'NSS' [File system], 'Novell' [Creator], '1998' [Year of introduction], 'NetWare 5' [Original operating system]
union all select 'NTFS' [File system], 'Microsoft (Gary Kimura, Tom Miller)' [Creator], '1993' [Year of introduction], 'Windows NT 3.1' [Original operating system]
union all select 'NWFS' [File system], 'Novell' [Creator], '1985' [Year of introduction], 'NetWare 286' [Original operating system]
union all select 'OCFS' [File system], 'Oracle Corporation' [Creator], '2002' [Year of introduction], 'Linux' [Original operating system]
union all select 'OCFS2' [File system], 'Oracle Corporation' [Creator], '2005' [Year of introduction], 'Linux' [Original operating system]
union all select 'ODS-1' [File system], 'DEC' [Creator], '1975' [Year of introduction], 'RSX-11' [Original operating system]
union all select 'ODS-2' [File system], 'DEC' [Creator], '1979' [Year of introduction], 'OpenVMS' [Original operating system]
union all select 'ODS-5' [File system], 'DEC' [Creator], '1998' [Year of introduction], 'OpenVMS V7.2' [Original operating system]
union all select 'OrangeFS' [File system], 'Omnibond and others' [Creator], '2011' [Year of introduction], 'Linux' [Original operating system]
union all select 'OS/3x0 FS' [File system], 'IBM' [Creator], '1964' [Year of introduction], 'OS/360' [Original operating system]
union all select 'PolyServe File System (PSFS)' [File system], 'PolyServe' [Creator], '1998' [Year of introduction], 'Windows, Linux' [Original operating system]
union all select 'ProDOS' [File system], 'Apple' [Creator], '1980' [Year of introduction], 'Apple SOS (later ProDOS 8)' [Original operating system]
union all select 'QFS' [File system], 'Sun Microsystems' [Creator], '1996' [Year of introduction], 'Solaris' [Original operating system]
union all select 'ReFS' [File system], 'Microsoft' [Creator], '2012' [Year of introduction], 'Windows Server 2012' [Original operating system]
union all select 'Reiser4' [File system], 'Namesys' [Creator], '2004' [Year of introduction], 'Linux' [Original operating system]
union all select 'ReiserFS' [File system], 'Namesys' [Creator], '2001' [Year of introduction], 'Linux' [Original operating system]
union all select 'Rock Ridge' [File system], 'IEEE' [Creator], '1990 c. 1990' [Year of introduction], 'Unix' [Original operating system]
union all select 'RT-11 file' [File system], 'DEC' [Creator], '1973' [Year of introduction], 'RT-11' [Original operating system]
union all select 'SquashFS' [File system], 'Phillip Lougher, Robert Lougher' [Creator], '2002' [Year of introduction], 'Linux' [Original operating system]
union all select 'UCSD p-System' [File system], 'UCSD' [Creator], '1978' [Year of introduction], 'UCSD p-System' [Original operating system]
union all select 'UDF' [File system], 'ISO/ECMA/OSTA' [Creator], '1995' [Year of introduction], '—' [Original operating system]
union all select 'UFS1' [File system], 'Kirk McKusick' [Creator], '1994' [Year of introduction], '4.4BSD' [Original operating system]
union all select 'UFS2' [File system], 'Kirk McKusick' [Creator], '2002' [Year of introduction], 'FreeBSD 5.0' [Original operating system]
union all select 'UniFS' [File system], 'Nasuni' [Creator], '2009' [Year of introduction], 'Cloud' [Original operating system]
union all select 'Version 6 Unix file system (V6FS)' [File system], 'Bell Labs' [Creator], '1972' [Year of introduction], 'Version 6 Unix' [Original operating system]
union all select 'Version 7 Unix file system (V7FS)' [File system], 'Bell Labs' [Creator], '1979' [Year of introduction], 'Version 7 Unix' [Original operating system]
union all select 'VMFS2' [File system], 'VMware' [Creator], '2002' [Year of introduction], 'VMware ESX Server 2.0' [Original operating system]
union all select 'VMFS3' [File system], 'VMware' [Creator], '2005' [Year of introduction], 'VMware ESX Server 3.0' [Original operating system]
union all select 'VMFS5' [File system], 'VMware' [Creator], '2011' [Year of introduction], 'vSphere 5.0+' [Original operating system]
union all select 'VxFS' [File system], 'VERITAS' [Creator], '1991' [Year of introduction], 'SVR4.0' [Original operating system]
union all select 'WAFL' [File system], 'NetApp' [Creator], '1998' [Year of introduction], 'Data ONTAP' [Original operating system]
union all select 'XFS' [File system], 'SGI' [Creator], '1994' [Year of introduction], 'IRIX' [Original operating system]
union all select 'Xiafs' [File system], 'Q. Frank Xia' [Creator], '1993' [Year of introduction], 'Linux' [Original operating system]
union all select 'z/FS' [File system], 'IBM' [Creator], '2001' [Year of introduction], 'z/OS (backported to OS/390)' [Original operating system]
union all select 'ZFS' [File system], 'Sun Microsystems' [Creator], '2004' [Year of introduction], 'Solaris' [Original operating system]
)
, q2 as (
select 'AdvFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes' [Access control lists], 'No' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'APFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'Yes' [Last archive timestamps], 'Yes' [Access control lists], 'Yes' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'BeeGFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes' [Access control lists], '?' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'BFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'No' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'BlueStore/Cephfs' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], '?' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes' [Access control lists], 'Yes' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'Btrfs' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes' [Access control lists], 'Yes' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'CP/M file system' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'Yes[c]' [Creation timestamps], 'No' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'DECtape' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'Yes' [Creation timestamps], 'No' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'Elektronika BK tape format' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'No' [Creation timestamps], 'No' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'exFAT' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'ext' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'No' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'ext2' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes[l]' [Access control lists], 'Yes[l]' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'ext3' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes[l]' [Access control lists], 'Yes[l]' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'ext4' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes[l]' [Access control lists], 'Yes[l]' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'Partial[m]' [Metadata checksum/ ECC]
union all select 'F2FS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes[l]' [Access control lists], 'Yes[l]' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'FAT12' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'No[d]' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No[e]' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'FAT16' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'No[d]' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No[e]' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'FAT32' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'No[d]' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No[e]' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'FFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'Fossil' [File system], 'Yes' [Stores file owner], 'Yes[s]' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'GFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes[l]' [Access control lists], 'Yes[l]' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'GPFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes' [Access control lists], 'Yes' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'HAMMER' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], '?' [Last archive timestamps], 'Yes' [Access control lists], 'Yes' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'HFS' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'Yes' [Creation timestamps], 'No' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'Yes' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'HFS+' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'Yes' [Last archive timestamps], 'Yes' [Access control lists], '?' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'High Sierra' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'Yes' [Creation timestamps], 'No' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'HPFS' [File system], 'Yes[f]' [Stores file owner], 'No' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], '?' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'ISO 9660:1988' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'Yes' [Creation timestamps], 'No' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'ISO 9660:1999' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'Yes' [Creation timestamps], 'No' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'JFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes' [Access control lists], 'Yes' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'Joliet ("CDFS")' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'Yes' [Creation timestamps], 'No' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'Level-D' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes (date only)' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'Yes' [Last archive timestamps], 'Yes (FILDAE)' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'LFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'Lustre' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes' [Access control lists], 'Yes' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'Minix V1' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'No' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'Minix V2' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'Minix V3' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'NILFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'No' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'NOVA' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'NSS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes[o]' [Creation timestamps], 'Yes[o]' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'Yes[o]' [Last archive timestamps], 'Yes' [Access control lists], '?' [Security/ MAC labels], 'Yes[p][q]' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'NTFS' [File system], 'Yes' [Stores file owner], 'Yes[g]' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes' [Access control lists], 'Yes[h]' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'NWFS' [File system], 'Yes' [Stores file owner], '?' [POSIX file permissions], 'Yes[o]' [Creation timestamps], 'Yes[o]' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'Yes[o]' [Last archive timestamps], 'Yes' [Access control lists], '?' [Security/ MAC labels], 'Yes[p][q]' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'OCFS' [File system], 'No' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'No' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'Yes' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'OCFS2' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'ODS-5' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], '?' [Last access/ read timestamps], '?' [Last metadata change timestamps], 'Yes' [Last archive timestamps], 'Yes' [Access control lists], '?' [Security/ MAC labels], 'Yes[r]' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'QFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'Yes' [Last archive timestamps], 'Yes' [Access control lists], 'No' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'ReFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes' [Access control lists], '?' [Security/ MAC labels], 'Yes[i]' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'Reiser4' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'ReiserFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes[l]' [Access control lists], 'Yes[l]' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'Rock Ridge' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes[v]' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No[w]' [Access control lists], 'No[x]' [Security/ MAC labels], 'No[x]' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'RT-11' [File system], 'No' [Stores file owner], 'No' [POSIX file permissions], 'Yes (date only)' [Creation timestamps], 'No' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'SquashFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'No' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'Yes' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'UDF' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'Yes' [Last archive timestamps], 'Yes' [Access control lists], 'No' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'UFS1' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes[j]' [Access control lists], 'Yes[j]' [Security/ MAC labels], 'No[k]' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'UFS2' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes[j]' [Access control lists], 'Yes[j]' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'Partial' [Metadata checksum/ ECC]
union all select 'Version 6 Unix file system (V6FS)' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'Version 7 Unix file system (V7FS)' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'No' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'VMFS2' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'VMFS3' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'VxFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes' [Access control lists], '?' [Security/ MAC labels], 'Yes[l]' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'XFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Partial[n]' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'Yes' [Access control lists], 'Yes[l]' [Security/ MAC labels], 'Yes' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
union all select 'Xiafs' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'No' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'No' [Last archive timestamps], 'No' [Access control lists], 'No' [Security/ MAC labels], 'No' [Extended attributes/ Alternate data streams/ forks], 'No' [Metadata checksum/ ECC]
union all select 'ZFS' [File system], 'Yes' [Stores file owner], 'Yes' [POSIX file permissions], 'Yes' [Creation timestamps], 'Yes' [Last access/ read timestamps], 'Yes' [Last metadata change timestamps], 'Yes' [Last archive timestamps], 'Yes' [Access control lists], 'Yes[t]' [Security/ MAC labels], 'Yes[u]' [Extended attributes/ Alternate data streams/ forks], 'Yes' [Metadata checksum/ ECC]
)
, q3 as (
select 'APFS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], '?' [Block journaling], '?' [Metadata-only journaling], 'Optional' [Case-sensitive], 'Yes' [Case-preserving], '?' [File Change Log], '?' [XIP], '?' [Resident files (inline data)]
union all select 'BeeGFS' [File system], 'No' [Hard links], 'Yes' [Symbolic links], 'Yes' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'BFS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], '?' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'BlueStore/Cephfs' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'Btrfs' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes[au]' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], '?' [File Change Log], '?' [XIP], '?' [Resident files (inline data)]
union all select 'DECtape' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'No' [Case-sensitive], 'No' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'exFAT' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'Partial (with TexFAT only)' [Metadata-only journaling], 'No' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], 'No' [Resident files (inline data)]
union all select 'ext' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'ext2' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'Yes[ak]' [XIP], '?' [Resident files (inline data)]
union all select 'ext3' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes (2001) [al]' [Block journaling], 'Yes (2001)' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'Yes' [XIP], '?' [Resident files (inline data)]
union all select 'ext4' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes[al]' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes, optional [24]' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'Yes' [XIP], 'Yes (approximately 160 bytes)[25]' [Resident files (inline data)]
union all select 'F2FS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes[aj]' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'FAT12' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'Partial (with TFAT12 only)' [Metadata-only journaling], 'No' [Case-sensitive], 'Partial (with VFAT LFNs only)' [Case-preserving], 'No' [File Change Log], 'No' [XIP], 'No' [Resident files (inline data)]
union all select 'FAT16' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'Partial (with TFAT16 only)' [Metadata-only journaling], 'No' [Case-sensitive], 'Partial (with VFAT LFNs only)' [Case-preserving], 'No' [File Change Log], 'No' [XIP], 'No' [Resident files (inline data)]
union all select 'FAT16B' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'Partial (with TFAT16 only)' [Metadata-only journaling], 'No' [Case-sensitive], 'Partial (with VFAT LFNs only)' [Case-preserving], 'No' [File Change Log], 'No' [XIP], 'No' [Resident files (inline data)]
union all select 'FAT16X' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'Partial (with TFAT16 only)' [Metadata-only journaling], 'No' [Case-sensitive], 'Partial (with VFAT LFNs only)' [Case-preserving], 'No' [File Change Log], 'No' [XIP], 'No' [Resident files (inline data)]
union all select 'FAT32' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No?' [Block journaling], 'Partial (with TFAT32 only)' [Metadata-only journaling], 'No' [Case-sensitive], 'Partial (with VFAT LFNs only)' [Case-preserving], 'No' [File Change Log], 'No' [XIP], 'No' [Resident files (inline data)]
union all select 'FAT32X' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No?' [Block journaling], 'Partial (with TFAT32 only)' [Metadata-only journaling], 'No' [Case-sensitive], 'Partial (with VFAT LFNs only)' [Case-preserving], 'No' [File Change Log], 'No' [XIP], 'No' [Resident files (inline data)]
union all select 'FFS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], 'No' [Resident files (inline data)]
union all select 'Fossil' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'Yes' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'GFS' [File system], 'Yes' [Hard links], 'Yes[z]' [Symbolic links], 'Yes' [Block journaling], 'Yes[aa]' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'HAMMER' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], '?' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'HFS+' [File system], 'Yes[16]' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'Yes[ae]' [Metadata-only journaling], 'Optional[af]' [Case-sensitive], 'Yes' [Case-preserving], 'Yes[ag]' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'HPFS' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'No' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'ISO 9660' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'No' [Case-sensitive], 'No' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'JFS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes' [Block journaling], 'Yes (1990)' [Metadata-only journaling], 'Yes[ao]' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], '?' [XIP], '?' [Resident files (inline data)]
union all select 'Joliet ("CDFS")' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'No' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'Level-D' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'No' [Case-sensitive], 'No' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'LFS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes[aj]' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'Lustre' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes[al]' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'Yes' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'Minix V1' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'Minix V2' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'Minix V3' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'NILFS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes[aj]' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'NOVA' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'Yes' [XIP], '?' [Resident files (inline data)]
union all select 'NSS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], '?' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes[ap]' [Case-sensitive], 'Yes[ap]' [Case-preserving], 'Yes[aq]' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'NTFS' [File system], 'Yes' [Hard links], 'Yes[ab]' [Symbolic links], 'No[ac]' [Block journaling], 'Yes[ac] (2000)' [Metadata-only journaling], 'Yes[ad]' [Case-sensitive], 'Yes' [Case-preserving], 'Yes' [File Change Log], '?' [XIP], 'Yes (approximately 700 bytes)' [Resident files (inline data)]
union all select 'NWFS' [File system], 'Yes[ar]' [Hard links], 'Yes[ar]' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes[ap]' [Case-sensitive], 'Yes[ap]' [Case-preserving], 'Yes[aq]' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'OCFS' [File system], 'No' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'OCFS2' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'ODS-2' [File system], 'Yes' [Hard links], 'Yes[as]' [Symbolic links], 'No' [Block journaling], 'Yes' [Metadata-only journaling], 'No' [Case-sensitive], 'No' [Case-preserving], 'Yes' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'ODS-5' [File system], 'Yes' [Hard links], 'Yes[as]' [Symbolic links], 'No' [Block journaling], 'Yes' [Metadata-only journaling], 'No' [Case-sensitive], 'Yes' [Case-preserving], 'Yes' [File Change Log], '?' [XIP], '?' [Resident files (inline data)]
union all select 'QFS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'ReFS' [File system], 'Yes[av]' [Hard links], 'Yes' [Symbolic links], '?' [Block journaling], '?' [Metadata-only journaling], 'Yes[ad]' [Case-sensitive], 'Yes' [Case-preserving], '?' [File Change Log], '?' [XIP], '?' [Resident files (inline data)]
union all select 'Reiser4' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], '?' [XIP], '?' [Resident files (inline data)]
union all select 'ReiserFS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes[am]' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], '?' [XIP], '?' [Resident files (inline data)]
union all select 'Rock Ridge' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'RT-11' [File system], 'No' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'No' [Case-sensitive], 'No' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'SquashFS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'UDF' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes[aj]' [Block journaling], 'Yes[aj]' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'Yes' [XIP], 'Yes[27]' [Resident files (inline data)]
union all select 'UFS1' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], 'No' [Resident files (inline data)]
union all select 'UFS2' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'Yes[ah] [21] [ai]' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], '?' [XIP], 'No' [Resident files (inline data)]
union all select 'Version 6 Unix file system (V6FS)' [File system], 'Yes' [Hard links], 'No' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], 'No' [Resident files (inline data)]
union all select 'Version 7 Unix file system (V7FS)' [File system], 'Yes' [Hard links], 'No[y]' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], 'No' [Resident files (inline data)]
union all select 'VMFS2' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'VMFS3' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'VxFS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'Yes' [File Change Log], '?' [XIP], '?' [Resident files (inline data)]
union all select 'XFS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes' [Block journaling], 'Yes' [Metadata-only journaling], 'Yes[an]' [Case-sensitive], 'Yes' [Case-preserving], 'Yes' [File Change Log], '?' [XIP], '?' [Resident files (inline data)]
union all select 'Xiafs' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'No' [Block journaling], 'No' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
union all select 'ZFS' [File system], 'Yes' [Hard links], 'Yes' [Symbolic links], 'Yes[at]' [Block journaling], 'No[at]' [Metadata-only journaling], 'Yes' [Case-sensitive], 'Yes' [Case-preserving], 'No' [File Change Log], 'No' [XIP], '?' [Resident files (inline data)]
)
, q4 as (
select 'APFS' [File system], 'Yes' [Internal snapshotting / branching], 'Yes' [Encryption], 'Yes [28]' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Yes' [Compression], 'No' [Self-healing(aw)]
union all select 'BeeGFS' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'Yes' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Yes' [Compression], 'No' [Self-healing(aw)]
union all select 'BFS' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'BlueStore/Cephfs' [File system], 'Yes' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'Yes' [Data checksum/ ECC], 'Yes' [Persistent Cache], 'Yes' [Multiple Devices], 'Yes' [Compression], 'Yes' [Self-healing(aw)]
union all select 'Btrfs' [File system], 'Yes' [Internal snapshotting / branching], 'No' [Encryption], 'Yes' [Deduplication], 'Yes[be]' [Data checksum/ ECC], 'No' [Persistent Cache], 'Yes' [Multiple Devices], 'Yes[bf]' [Compression], 'Yes' [Self-healing(aw)]
union all select 'DECtape' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'exFAT' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'ext' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'ext2' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'ext3' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'ext4' [File system], 'No' [Internal snapshotting / branching], 'Yes, experimental [31]' [Encryption], 'No' [Deduplication], 'No[32]' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'F2FS' [File system], 'No' [Internal snapshotting / branching], 'Yes, experimental [33]' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Yes' [Compression], 'No' [Self-healing(aw)]
union all select 'FAT12' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Partial[ax]' [Compression], 'No' [Self-healing(aw)]
union all select 'FAT16' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Partial[ax]' [Compression], 'No' [Self-healing(aw)]
union all select 'FAT16B' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Partial[ax]' [Compression], 'No' [Self-healing(aw)]
union all select 'FAT16X' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Partial[ax]' [Compression], 'No' [Self-healing(aw)]
union all select 'FAT32' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'FAT32X' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'FFS' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'Fossil' [File system], 'Yes' [Internal snapshotting / branching], 'No' [Encryption], 'Yes' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Yes' [Compression], 'No' [Self-healing(aw)]
union all select 'GFS' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], '?' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'HAMMER' [File system], 'Yes' [Internal snapshotting / branching], 'No' [Encryption], 'Yes' [Deduplication], 'Yes' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'HFS+' [File system], 'No' [Internal snapshotting / branching], 'No[az]' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'HPFS' [File system], '?' [Internal snapshotting / branching], 'No' [Encryption], '?' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'ISO 9660' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No[bh]' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'JFS' [File system], '?' [Internal snapshotting / branching], 'No' [Encryption], '?' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'only in JFS1 on AIX[35]' [Compression], 'No' [Self-healing(aw)]
union all select 'Joliet ("CDFS")' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No[bh]' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'Level-D' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'LFS' [File system], 'Yes' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'Lustre' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'Yes' [Persistent Cache], 'Yes' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'Minix V1' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'Minix V2' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'Minix V3' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'NILFS' [File system], 'Yes, continuous[aj]' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'Yes' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'NOVA' [File system], 'Yes' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'Yes' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], '?' [Self-healing(aw)]
union all select 'NSS' [File system], 'Yes' [Internal snapshotting / branching], 'Yes' [Encryption], '?' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Yes' [Compression], 'No' [Self-healing(aw)]
union all select 'NTFS' [File system], 'No' [Internal snapshotting / branching], 'Yes' [Encryption], 'Yes[ay][30]' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Yes' [Compression], 'No' [Self-healing(aw)]
union all select 'NWFS' [File system], '?' [Internal snapshotting / branching], 'No' [Encryption], '?' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Yes' [Compression], 'No' [Self-healing(aw)]
union all select 'OCFS' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'OCFS2' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'ODS-2' [File system], 'Yes' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'ODS-5' [File system], 'Yes' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], '' [Self-healing(aw)]
union all select 'QFS' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'ReFS' [File system], '?' [Internal snapshotting / branching], 'No' [Encryption], 'Yes' [Deduplication], 'Yes[bg]' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'Yes' [Self-healing(aw)]
union all select 'Reiser4' [File system], '?' [Internal snapshotting / branching], 'Yes[ba]' [Encryption], '?' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Yes' [Compression], 'No' [Self-healing(aw)]
union all select 'ReiserFS' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'Rock Ridge' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No[bh]' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'RT-11' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'SquashFS' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'Yes' [Deduplication], 'Yes' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'Yes' [Compression], 'No' [Self-healing(aw)]
union all select 'UDF' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'UFS1' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'UFS2' [File system], 'Yes' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'Version 6 Unix file system (V6FS)' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'Version 7 Unix file system (V7FS)' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'VMFS2' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'VMFS3' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'VxFS' [File system], 'Yes[bb]' [Internal snapshotting / branching], 'No' [Encryption], 'Yes' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'XFS' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'Yes[34]' [Deduplication], 'No[32]' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'Xiafs' [File system], 'No' [Internal snapshotting / branching], 'No' [Encryption], 'No' [Deduplication], 'No' [Data checksum/ ECC], 'No' [Persistent Cache], 'No' [Multiple Devices], 'No' [Compression], 'No' [Self-healing(aw)]
union all select 'ZFS' [File system], 'Yes' [Internal snapshotting / branching], 'Yes[bc]' [Encryption], 'Yes' [Deduplication], 'Yes' [Data checksum/ ECC], 'Yes' [Persistent Cache], 'Yes' [Multiple Devices], 'Yes[bd]' [Compression], 'Yes' [Self-healing(aw)]
)
, q5 as (
select 'APFS' [File system], 'macOS' [Host OS], '?' [Offline grow], '?' [Online grow], '?' [Offline shrink], '?' [Online shrink], '?' [Add and remove physical volumes]
union all select 'BlueStore/Cephfs' [File system], 'Linux' [Host OS], 'No' [Offline grow], 'Yes' [Online grow], 'No' [Offline shrink], 'Yes' [Online shrink], 'Yes' [Add and remove physical volumes]
union all select 'Btrfs' [File system], 'Linux' [Host OS], 'Yes' [Offline grow], 'Yes' [Online grow], 'Yes' [Offline shrink], 'Yes' [Online shrink], 'Yes' [Add and remove physical volumes]
union all select 'exFAT' [File system], 'misc.' [Host OS], 'No' [Offline grow], 'No' [Online grow], 'No' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'ext2' [File system], 'Linux' [Host OS], 'Yes' [Offline grow], 'No' [Online grow], 'Yes' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'ext3' [File system], 'Linux' [Host OS], 'Yes' [Offline grow], 'Yes' [Online grow], 'Yes' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'ext4' [File system], 'Linux' [Host OS], 'Yes' [Offline grow], 'Yes' [Online grow], 'Yes' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'F2FS' [File system], 'Linux' [Host OS], 'Yes' [Offline grow], 'No' [Online grow], 'No' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'FAT16' [File system], 'misc.' [Host OS], 'Yes[bi]' [Offline grow], 'No' [Online grow], 'Yes[bi]' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'FAT16B' [File system], 'misc.' [Host OS], 'Yes[bi]' [Offline grow], 'No' [Online grow], 'Yes[bi]' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'FAT16X' [File system], 'misc.' [Host OS], 'Yes[bi]' [Offline grow], 'No' [Online grow], 'Yes[bi]' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'FAT32' [File system], 'misc.' [Host OS], 'Yes[bi]' [Offline grow], 'No' [Online grow], 'Yes[bi]' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'FAT32X' [File system], 'misc.' [Host OS], 'Yes[bi]' [Offline grow], 'No' [Online grow], 'Yes[bi]' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'HAMMER' [File system], 'DragonflyBSD' [Host OS], '?' [Offline grow], '?' [Online grow], '?' [Offline shrink], '?' [Online shrink], '?' [Add and remove physical volumes]
union all select 'HFS' [File system], 'macOS' [Host OS], 'No' [Offline grow], 'No' [Online grow], 'No' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'HFS+' [File system], 'macOS' [Host OS], 'No' [Offline grow], 'Yes' [Online grow], 'No' [Offline shrink], 'Yes' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'JFS' [File system], 'Linux' [Host OS], 'Yes' [Offline grow], 'No' [Online grow], 'No' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'JFS2' [File system], 'AIX' [Host OS], 'Yes' [Offline grow], 'Yes' [Online grow], 'Yes' [Offline shrink], 'Yes' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'Lustre' [File system], 'Linux' [Host OS], '?' [Offline grow], 'Yes' [Online grow], 'No' [Offline shrink], 'No' [Online shrink], 'Yes' [Add and remove physical volumes]
union all select 'NILFS' [File system], 'Linux' [Host OS], 'No' [Offline grow], 'Yes' [Online grow], 'No' [Offline shrink], 'Yes' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'NOVA' [File system], 'Linux' [Host OS], 'No' [Offline grow], 'No' [Online grow], 'No' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'NTFS' [File system], 'Windows' [Host OS], 'Yes' [Offline grow], 'Yes' [Online grow], 'Yes' [Offline shrink], 'Yes' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'NTFS' [File system], 'Linux' [Host OS], 'Yes' [Offline grow], 'No' [Online grow], 'Yes' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'ReFS' [File system], 'Windows' [Host OS], '?' [Offline grow], 'Yes' [Online grow], '?' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'Reiser4' [File system], 'Linux' [Host OS], 'Yes' [Offline grow], 'Yes' [Online grow], 'Yes' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'ReiserFS' [File system], 'Linux' [Host OS], 'Yes' [Offline grow], 'Yes' [Online grow], 'Yes' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'SquashFS' [File system], 'Linux' [Host OS], 'No' [Offline grow], 'No' [Online grow], 'No' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'UFS2' [File system], 'FreeBSD' [Host OS], 'Yes' [Offline grow], 'Yes (FreeBSD 10.0-RELEASE or later)' [Online grow], 'No' [Offline shrink], 'No' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'XFS' [File system], 'Linux' [Host OS], 'No' [Offline grow], 'Yes' [Online grow], 'No[43]' [Offline shrink], 'No[43]' [Online shrink], 'No' [Add and remove physical volumes]
union all select 'ZFS' [File system], 'misc.' [Host OS], 'No' [Offline grow], 'Yes' [Online grow], 'No' [Offline shrink], 'Partial[52]' [Online shrink], 'Yes' [Add and remove physical volumes]
)
, q6 as (
select 'APFS' [File system], 'Yes' [Sparse files], '?' [Block suballocation], '?' [Tail packing], 'Yes' [Extents], '?' [Variable file block size(bj)], 'Yes' [Allocate-on-flush], 'Yes' [Copy on write], 'Yes(54)(55)' [Trim support]
union all select 'BeeGFS' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'Yes' [Variable file block size(bj)], 'Yes' [Allocate-on-flush], 'Yes' [Copy on write], '?' [Trim support]
union all select 'BFS' [File system], '?' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], 'Yes (Haiku)' [Trim support]
union all select 'BlueStore/Cephfs' [File system], 'Yes' [Sparse files], '?' [Block suballocation], '?' [Tail packing], '?' [Extents], '?' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'Yes' [Copy on write], 'Yes' [Trim support]
union all select 'Btrfs' [File system], 'Yes' [Sparse files], 'Yes' [Block suballocation], 'Yes' [Tail packing], 'Yes' [Extents], 'Yes' [Variable file block size(bj)], 'Yes' [Allocate-on-flush], 'Yes' [Copy on write], 'Yes' [Trim support]
union all select 'DECtape' [File system], 'No' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'No' [Trim support]
union all select 'exFAT' [File system], 'No' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Partial (only if the file fits into one contiguous block range)' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'Yes (Linux)' [Trim support]
union all select 'ext' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'No' [Trim support]
union all select 'ext2' [File system], 'Yes' [Sparse files], 'No(bm)' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'Yes' [Trim support]
union all select 'ext3' [File system], 'Yes' [Sparse files], 'No(bm)' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'Yes' [Trim support]
union all select 'ext4' [File system], 'Yes' [Sparse files], 'No(bm)' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'Yes' [Allocate-on-flush], 'No' [Copy on write], 'Yes' [Trim support]
union all select 'F2FS' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Partial(bn)' [Extents], 'No' [Variable file block size(bj)], 'Yes' [Allocate-on-flush], 'Yes' [Copy on write], 'Yes(60)' [Trim support]
union all select 'FAT12' [File system], 'Partial (only inside of compressed volumes)(56)' [Sparse files], 'Partial (only inside of Stacker 3/4 and DriveSpace 3 compressed volumes(29))' [Block suballocation], 'No' [Tail packing], 'Partial (only inside of compressed volumes)(57)' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'Yes (Linux)' [Trim support]
union all select 'FAT16' [File system], 'Partial (only inside of compressed volumes)(56)' [Sparse files], 'Partial (only inside of Stacker 3/4 and DriveSpace 3 compressed volumes(29))' [Block suballocation], 'No' [Tail packing], 'Partial (only inside of compressed volumes)(57)' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'Yes (Linux)' [Trim support]
union all select 'FAT16B' [File system], 'Partial (only inside of compressed volumes)(56)' [Sparse files], 'Partial (only inside of Stacker 3/4 and DriveSpace 3 compressed volumes(29))' [Block suballocation], 'No' [Tail packing], 'Partial (only inside of compressed volumes)(57)' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'Yes (Linux)' [Trim support]
union all select 'FAT16X' [File system], 'Partial (only inside of compressed volumes)(56)' [Sparse files], 'Partial (only inside of Stacker 3/4 and DriveSpace 3 compressed volumes(29))' [Block suballocation], 'No' [Tail packing], 'Partial (only inside of compressed volumes)(57)' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'Yes (Linux)' [Trim support]
union all select 'FAT32' [File system], 'No' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'Yes (Linux)' [Trim support]
union all select 'FAT32X' [File system], 'No' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'Yes (Linux)' [Trim support]
union all select 'FFS' [File system], 'Yes' [Sparse files], '8:1(bl)' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], 'No' [Trim support]
union all select 'Fossil' [File system], '?' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], '?' [Trim support]
union all select 'GFS' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'Partial(bk)' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], 'Yes' [Trim support]
union all select 'HFS+' [File system], 'No' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], 'Yes (macOS)' [Trim support]
union all select 'HPFS' [File system], 'No' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], 'Yes (Linux)' [Trim support]
union all select 'ISO 9660' [File system], 'No' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes(bs)' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'No' [Trim support]
union all select 'JFS' [File system], 'Yes' [Sparse files], 'Yes' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], 'Yes (Linux)' [Trim support]
union all select 'Joliet ("CDFS")' [File system], 'No' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes(bs)' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'No' [Trim support]
union all select 'Level-D' [File system], 'No' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], '?' [Trim support]
union all select 'LFS' [File system], 'Yes' [Sparse files], '8:1(bl)' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'Yes' [Copy on write], '?' [Trim support]
union all select 'Lustre' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'Yes' [Allocate-on-flush], '?' [Copy on write], '?' [Trim support]
union all select 'NILFS' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'Yes' [Allocate-on-flush], 'Yes' [Copy on write], 'Yes (Linux NILFS2)' [Trim support]
union all select 'NOVA' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'Yes' [Copy on write], '?' [Trim support]
union all select 'NSS' [File system], '?' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'Yes' [Allocate-on-flush], '?' [Copy on write], '?' [Trim support]
union all select 'NTFS' [File system], 'Yes' [Sparse files], 'Partial' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], 'Yes (NT 6.1+; Linux)' [Trim support]
union all select 'NWFS' [File system], '?' [Sparse files], 'Yes(bq)' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], '?' [Trim support]
union all select 'OCFS' [File system], '?' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], '?' [Trim support]
union all select 'OCFS2' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], 'Yes (Linux)' [Trim support]
union all select 'ODS-5' [File system], '?' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], '?' [Trim support]
union all select 'QFS' [File system], '?' [Sparse files], 'Yes' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], '?' [Trim support]
union all select 'ReFS' [File system], 'Yes' [Sparse files], '?' [Block suballocation], '?' [Tail packing], '?' [Extents], 'No' [Variable file block size(bj)], '?' [Allocate-on-flush], 'Yes' [Copy on write], 'Yes (NT 6.1+)' [Trim support]
union all select 'Reiser4' [File system], 'Yes' [Sparse files], 'Yes(bo)' [Block suballocation], 'Yes' [Tail packing], 'Yes(bp)' [Extents], 'No' [Variable file block size(bj)], 'Yes' [Allocate-on-flush], '?' [Copy on write], 'Testing(61)' [Trim support]
union all select 'ReiserFS' [File system], 'Yes' [Sparse files], 'Yes(bo)' [Block suballocation], 'Yes' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], '?' [Trim support]
union all select 'Rock Ridge' [File system], 'No' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes(bs)' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'No' [Trim support]
union all select 'SquashFS' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'Yes' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], 'No' [Copy on write], 'No' [Trim support]
union all select 'UDF' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], '?(br)' [Allocate-on-flush], 'Yes, for write once read many media' [Copy on write], 'No' [Trim support]
union all select 'UFS1' [File system], 'Yes' [Sparse files], '8:1(bl)' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], 'No' [Trim support]
union all select 'UFS2' [File system], 'Yes' [Sparse files], '8:1(bl)' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'Yes' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], 'Yes(58)(59)' [Trim support]
union all select 'Version 6 Unix file system (V6FS)' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], 'No' [Trim support]
union all select 'Version 7 Unix file system (V7FS)' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], 'No' [Trim support]
union all select 'VMFS2' [File system], 'Yes' [Sparse files], 'Yes' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], '?' [Trim support]
union all select 'VMFS3' [File system], 'Yes' [Sparse files], 'Yes' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], '?' [Trim support]
union all select 'VxFS' [File system], 'Yes' [Sparse files], '?' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], '?' [Trim support]
union all select 'XFS' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'Yes' [Extents], 'No' [Variable file block size(bj)], 'Yes' [Allocate-on-flush], 'Yes, on request(62)' [Copy on write], 'Yes (Linux)' [Trim support]
union all select 'Xiafs' [File system], 'Yes' [Sparse files], 'No' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'No' [Variable file block size(bj)], 'No' [Allocate-on-flush], '?' [Copy on write], '?' [Trim support]
union all select 'ZFS' [File system], 'Yes' [Sparse files], 'Yes' [Block suballocation], 'No' [Tail packing], 'No' [Extents], 'Yes' [Variable file block size(bj)], 'Yes' [Allocate-on-flush], 'Yes' [Copy on write], 'Yes' [Trim support]
)
, q7 as (
select 'APFS' [File system], 'No' [DOS], 'Partial (read-only with apfs-fuse[64] or linux-apfs[65])' [Linux], 'Yes' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'BeeGFS' [File system], 'No' [DOS], 'Yes' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'DECtape' [File system], 'No' [DOS], 'No' [Linux], 'No' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'Level-D' [File system], 'No' [DOS], '?' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'RT-11' [File system], 'No' [DOS], 'No' [Linux], 'No' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'Version 6 Unix file system (V6FS)' [File system], 'No' [DOS], '?' [Linux], 'No' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'Version 7 Unix file system (V7FS)' [File system], 'No' [DOS], 'Yes' [Linux], 'No' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'exFAT' [File system], 'No' [DOS], 'Yes (since 5.4,[66] available as a kernel module or FUSE driver for earlier versions)' [Linux], 'Yes' [macOS], 'No' [Windows 9x], 'Yes (installable drivers for Windows XP, 2003. Included with Windows Vista SP1 and newer.)' [Windows NT], 'No' ["classic" Mac OS], 'Yes (available as a FUSE driver)' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'Yes (available as a FUSE driver)' [Solaris], 'No' [z/OS], 'With kernel 5.10' [Android(63)]
union all select 'FAT12' [File system], 'Yes' [DOS], 'Yes' [Linux], 'Yes' [macOS], 'Yes' [Windows 9x], 'Yes' [Windows NT], 'Yes' ["classic" Mac OS], 'Yes' [FreeBSD], 'Yes' [OS/2], 'Yes' [BeOS], 'Partial (via dosdir, dosread, doswrite)' [Minix], 'Yes' [Solaris], '?' [z/OS], 'Yes' [Android(63)]
union all select 'FAT16' [File system], 'Yes (FAT16 from DOS 3.0, FAT16B from DOS 3.31, FAT16X from DOS 7.0)' [DOS], 'Yes' [Linux], 'Yes' [macOS], 'Yes' [Windows 9x], 'Yes' [Windows NT], 'Yes' ["classic" Mac OS], 'Yes' [FreeBSD], 'Yes' [OS/2], 'Yes' [BeOS], 'Partial (via dosdir, dosread, doswrite, not FAT16X)' [Minix], 'Yes' [Solaris], '?' [z/OS], 'Yes' [Android(63)]
union all select 'FAT16B' [File system], 'Yes (FAT16 from DOS 3.0, FAT16B from DOS 3.31, FAT16X from DOS 7.0)' [DOS], 'Yes' [Linux], 'Yes' [macOS], 'Yes' [Windows 9x], 'Yes' [Windows NT], 'Yes' ["classic" Mac OS], 'Yes' [FreeBSD], 'Yes' [OS/2], 'Yes' [BeOS], 'Partial (via dosdir, dosread, doswrite, not FAT16X)' [Minix], 'Yes' [Solaris], '?' [z/OS], 'Yes' [Android(63)]
union all select 'FAT16X' [File system], 'Yes (FAT16 from DOS 3.0, FAT16B from DOS 3.31, FAT16X from DOS 7.0)' [DOS], 'Yes' [Linux], 'Yes' [macOS], 'Yes' [Windows 9x], 'Yes' [Windows NT], 'Yes' ["classic" Mac OS], 'Yes' [FreeBSD], 'Yes' [OS/2], 'Yes' [BeOS], 'Partial (via dosdir, dosread, doswrite, not FAT16X)' [Minix], 'Yes' [Solaris], '?' [z/OS], 'Yes' [Android(63)]
union all select 'FAT32' [File system], 'Yes (from DOS 7.10)' [DOS], 'Yes' [Linux], 'Yes' [macOS], 'Yes (from Windows 95 OSR2)' [Windows 9x], 'Yes (from Windows 2000)' [Windows NT], 'Yes?' ["classic" Mac OS], 'Yes' [FreeBSD], 'Yes' [OS/2], 'Yes' [BeOS], 'No' [Minix], 'Yes' [Solaris], '?' [z/OS], 'Yes' [Android(63)]
union all select 'FAT32X' [File system], 'Yes (from DOS 7.10)' [DOS], 'Yes' [Linux], 'Yes' [macOS], 'Yes (from Windows 95 OSR2)' [Windows 9x], 'Yes (from Windows 2000)' [Windows NT], 'Yes?' ["classic" Mac OS], 'Yes' [FreeBSD], 'Yes' [OS/2], 'Yes' [BeOS], 'No' [Minix], 'Yes' [Solaris], '?' [z/OS], 'Yes' [Android(63)]
union all select 'GFS' [File system], 'No' [DOS], 'Yes' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], '?' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'HPFS' [File system], 'Partial (with third-party drivers)' [DOS], 'Yes' [Linux], '?' [macOS], 'No' [Windows 9x], 'Partial (with NT 3.1 to 4.0 only)' [Windows NT], '?' ["classic" Mac OS], 'Yes' [FreeBSD], 'Yes (from OS/2 1.2)' [OS/2], '?' [BeOS], 'No' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'NTFS' [File system], 'Partial (with third-party drivers)' [DOS], 'Yes Native since Linux Kernel 5.15 NTFS3. Older kernels may use backported NTFS3 driver or ntfs-3g[67]' [Linux], 'Read only, write support needs Paragon NTFS or ntfs-3g' [macOS], 'Needs 3rd-party drivers like Paragon NTFS for Win98, DiskInternals NTFS Reader' [Windows 9x], 'Yes' [Windows NT], 'No' ["classic" Mac OS], 'Yes with ntfs-3g' [FreeBSD], '?' [OS/2], 'Yes with ntfs-3g' [BeOS], 'No' [Minix], 'Yes with ntfs-3g' [Solaris], '?' [z/OS], 'With third party tools' [Android(63)]
union all select 'HFS' [File system], 'No' [DOS], 'Yes' [Linux], 'No write support since Mac OS X 10.6 and no support at all since macOS 10.15' [macOS], 'No' [Windows 9x], 'Needs Paragon HFS+ [68]' [Windows NT], 'Yes' ["classic" Mac OS], 'No' [FreeBSD], '?' [OS/2], 'Yes' [BeOS], 'No' [Minix], '?' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'HFS+' [File system], 'No' [DOS], 'Partial - writing support only to unjournalled FS' [Linux], 'Yes' [macOS], 'No' [Windows 9x], 'Needs Paragon HFS+ [68]' [Windows NT], 'Yes from Mac OS 8.1' ["classic" Mac OS], 'No' [FreeBSD], '?' [OS/2], 'with addon' [BeOS], 'No' [Minix], '?' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'FFS' [File system], 'No' [DOS], '?' [Linux], 'Yes' [macOS], 'No' [Windows 9x], '?' [Windows NT], '?' ["classic" Mac OS], 'Yes' [FreeBSD], '?' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'UFS1' [File system], 'No' [DOS], 'Partial - read only' [Linux], 'Yes' [macOS], 'No' [Windows 9x], 'Partial (with ufs2tools, read only)' [Windows NT], '?' ["classic" Mac OS], 'Yes' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], 'Yes' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'UFS2' [File system], 'No' [DOS], 'Yes' [Linux], 'Yes' [macOS], 'No' [Windows 9x], 'Partial (with ufs2tools, read only)' [Windows NT], '?' ["classic" Mac OS], 'Yes' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'LFS' [File system], 'No' [DOS], '?' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'ext' [File system], 'No' [DOS], 'Yes - until 2.1.20' [Linux], 'No' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'Xiafs' [File system], 'No' [DOS], 'Yes - until 2.1.20' [Linux], 'No' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'ext2' [File system], 'No' [DOS], 'Yes' [Linux], 'Needs Paragon ExtFS [71] or ext2fsx' [macOS], 'Partial (read-only, with explore2fs)[72]' [Windows 9x], 'Needs Paragon ExtFS [73] or partial with Ext2 IFS[74] or ext2fsd[75]' [Windows NT], 'No' ["classic" Mac OS], 'Yes' [FreeBSD], 'No' [OS/2], 'Yes' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'ext3' [File system], 'No' [DOS], 'Yes' [Linux], 'Needs Paragon ExtFS [71] or partial with ext2fsx (journal not updated on writing)' [macOS], 'Partial (read-only, with explore2fs)[72]' [Windows 9x], 'Needs Paragon ExtFS [73] or partial with Ext2 IFS[74] or ext2fsd[75]' [Windows NT], 'Partial (read only)[citation needed]' ["classic" Mac OS], 'Yes[76]' [FreeBSD], 'No' [OS/2], 'with addon' [BeOS], '?' [Minix], 'Yes' [Solaris], '?' [z/OS], 'Yes' [Android(63)]
union all select 'ext4' [File system], 'No' [DOS], 'Yes' [Linux], 'Needs Paragon ExtFS [71]' [macOS], 'No' [Windows 9x], 'Needs Paragon ExtFS [73] or partial with Ext2 IFS[74] or ext2fsd[75]' [Windows NT], '?' ["classic" Mac OS], 'Yes since FreeBSD 12.0[76]' [FreeBSD], 'No' [OS/2], 'with addon' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'Yes' [Android(63)]
union all select 'NOVA' [File system], 'No' [DOS], 'Yes' [Linux], 'No' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'Lustre' [File system], 'No' [DOS], 'Yes[77]' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], '?' [OS/2], '?' [BeOS], '?' [Minix], 'Yes' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'NILFS' [File system], 'No' [DOS], 'Yes as an external kernel module' [Linux], '?' [macOS], 'No' [Windows 9x], '?' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], '?' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'F2FS' [File system], 'No' [DOS], 'Yes' [Linux], 'No' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'No' [z/OS], 'Yes' [Android(63)]
union all select 'ReiserFS' [File system], 'No' [DOS], 'Yes' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'Partial - Read Only from 6.0 to 10.x[78] and dropped in 11.0[79][80]' [FreeBSD], '?' [OS/2], 'with addon' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'Reiser4' [File system], 'No' [DOS], 'Yes with a kernel patch' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], '?' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'SpadFS' [File system], 'No' [DOS], 'Yes' [Linux], 'No' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], '?' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'OCFS' [File system], 'No' [DOS], 'Yes' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'OCFS2' [File system], 'No' [DOS], 'Yes' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'XFS' [File system], 'No' [DOS], 'Yes' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'Partial' [FreeBSD], '?' [OS/2], 'with addon (read only)' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'JFS' [File system], 'No' [DOS], 'Yes' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], 'Yes' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'QFS' [File system], 'No' [DOS], 'Partial - client only[81]' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], 'Yes' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'BFS' [File system], 'No' [DOS], 'Partial - read-only' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], 'Yes' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'NSS' [File system], 'No' [DOS], 'Yes via EVMS[bt]' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'NWFS' [File system], 'Partial (with Novell drivers)' [DOS], '?' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'Yes' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'ODS-2' [File system], 'No' [DOS], '?' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'ODS-5' [File system], 'No' [DOS], '?' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'UDF' [File system], 'No' [DOS], 'Yes' [Linux], 'Yes' [macOS], '?' [Windows 9x], 'Yes' [Windows NT], '?' ["classic" Mac OS], 'Yes' [FreeBSD], '?' [OS/2], '?' [BeOS], '?' [Minix], 'Yes' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'VxFS' [File system], 'No' [DOS], 'Yes' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], 'Yes' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'Fossil' [File system], 'No' [DOS], 'Yes[bu]' [Linux], 'Yes[bu]' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'Yes[bu]' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'Yes[bu]' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'ZFS' [File system], 'No' [DOS], 'Yes with FUSE[82] or as an external kernel module[83]' [Linux], 'Yes with Read/Write Developer Preview[84]' [macOS], 'No' [Windows 9x], 'Yes[85]' [Windows NT], 'No' ["classic" Mac OS], 'Yes' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'Yes' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'Btrfs' [File system], 'No' [DOS], 'Yes' [Linux], '?' [macOS], 'No' [Windows 9x], 'Yes with WinBtrfs[86]' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], '?' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'VMFS2' [File system], 'No' [DOS], '?' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'VMFS3' [File system], 'No' [DOS], '?' [Linux], '?' [macOS], 'No' [Windows 9x], 'No' [Windows NT], '?' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'IBM HFS' [File system], 'No' [DOS], 'No' [Linux], 'No' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'Yes' [z/OS], 'No' [Android(63)]
union all select 'IBM zFS' [File system], 'No' [DOS], 'No' [Linux], 'No' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'No' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'Yes' [z/OS], 'No' [Android(63)]
union all select 'ReFS' [File system], 'No' [DOS], 'Needs Paragon ReFS for Linux' [Linux], '?' [macOS], 'No' [Windows 9x], 'Yes (from Windows Server 2012 and from Windows 8.1)' [Windows NT], '?' ["classic" Mac OS], '?' [FreeBSD], '?' [OS/2], '?' [BeOS], '?' [Minix], '?' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'ISO 9660' [File system], 'Yes' [DOS], 'Yes' [Linux], 'Yes' [macOS], 'Yes' [Windows 9x], 'Yes' [Windows NT], 'Yes' ["classic" Mac OS], 'Yes' [FreeBSD], 'Yes' [OS/2], 'Yes' [BeOS], 'Yes' [Minix], 'Yes' [Solaris], 'Yes' [z/OS], 'No' [Android(63)]
union all select 'Rock Ridge' [File system], 'No' [DOS], 'Yes' [Linux], 'Yes' [macOS], 'No' [Windows 9x], 'No' [Windows NT], 'No' ["classic" Mac OS], 'Yes' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'Yes' [Minix], 'Yes' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'Joliet ("CDFS")' [File system], 'No' [DOS], 'Yes' [Linux], 'Yes' [macOS], 'Yes' [Windows 9x], 'Yes' [Windows NT], '?' ["classic" Mac OS], 'Yes' [FreeBSD], 'Yes' [OS/2], 'Yes' [BeOS], '?' [Minix], 'Yes' [Solaris], '?' [z/OS], 'No' [Android(63)]
union all select 'SquashFS' [File system], 'No' [DOS], 'Yes' [Linux], 'Partial (There are ports of unsquashfs and mksquashfs.)' [macOS], 'No' [Windows 9x], 'Partial (There are ports of unsquashfs and mksquashfs.)' [Windows NT], 'No' ["classic" Mac OS], 'Partial (There are ports of unsquashfs and mksquashfs and fusefs-port.[87][88])' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'No' [z/OS], 'No' [Android(63)]
union all select 'BlueStore/Cephfs' [File system], 'No' [DOS], 'Yes' [Linux], 'No[bv]' [macOS], 'No' [Windows 9x], 'No[bw]' [Windows NT], 'No' ["classic" Mac OS], 'No[bv]' [FreeBSD], 'No' [OS/2], 'No' [BeOS], 'No' [Minix], 'No' [Solaris], 'No' [z/OS], 'No' [Android(63)]
)
, q8 as (
select 'AdvFS' [File system], '255 characters' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '16 TiB (17.59 TB)' [Maximum file size], '16 TiB (17.59 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'APFS' [File system], '255 UTF-8 characters' [Maximum filename length], 'Unicode 9.0 encoded in UTF-8[89]' [Allowable characters in directory entries(bx)], '?' [Maximum pathname length], '8 EiB (9.223 EB)' [Maximum file size], '?' [Maximum volume size(by)], '263 [90]' [Max number of files]
union all select 'BeeGFS' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '16 EiB (18.44 EB)' [Maximum file size], '16 EiB (18.44 EB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'BFS' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '12,288 bytes to 260 GiB (279.1 GB)[cb]' [Maximum file size], '256 PiB (288.2 PB) to 2 EiB (2.305 EB)' [Maximum volume size(by)], 'Unlimited' [Max number of files]
union all select 'BlueStore/Cephfs' [File system], '?' [Maximum filename length], 'any byte, except null, "/"' [Allowable characters in directory entries(bx)], 'No limit defined' [Maximum pathname length], 'Max. 264 bytes, 1 TiB (1.099 TB) by default [91]' [Maximum file size], 'Not limited' [Maximum volume size(by)], 'Not limited, default is 100,000 files per directory [92]' [Max number of files]
union all select 'Btrfs' [File system], '255 bytes' [Maximum filename length], 'Any byte except / and NUL' [Allowable characters in directory entries(bx)], 'No limit defined' [Maximum pathname length], '16 EiB (18.44 EB)' [Maximum file size], '16 EiB (18.44 EB)' [Maximum volume size(by)], '264' [Max number of files]
union all select 'CBM DOS' [File system], '16 bytes' [Maximum filename length], 'Any byte except NUL' [Allowable characters in directory entries(bx)], '0 (no directory hierarchy)' [Maximum pathname length], '16 MiB (16.77 MB)' [Maximum file size], '16 MiB (16.77 MB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'CP/M file system' [File system], '44993' [Maximum filename length], 'ASCII except for < > . , ; : = ? * [ ]' [Allowable characters in directory entries(bx)], 'No directory hierarchy (but accessibility of files depends on user areas via USER command since CP/M 2.2)' [Maximum pathname length], '32 MiB (33.55 MB)' [Maximum file size], '512 MiB (536.8 MB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'DECtape' [File system], '44991' [Maximum filename length], 'A–Z, 0–9' [Allowable characters in directory entries(bx)], 'DTxN:FILNAM.EXT = 15' [Maximum pathname length], '369,280 bytes (577 * 640)' [Maximum file size], '369,920 bytes (578 * 640)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Disk Operating System (GEC DOS)' [File system], '?' [Maximum filename length], '?' [Allowable characters in directory entries(bx)], '?' [Maximum pathname length], '? at least 131,072 bytes' [Maximum file size], '?' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Elektronika BK tape format' [File system], '16 bytes' [Maximum filename length], '?' [Allowable characters in directory entries(bx)], 'No directory hierarchy' [Maximum pathname length], '64 KiB (65.53 KB)' [Maximum file size], 'Not limited. Approx. 800 KiB (819.2 KB) (one side) for 90 min cassette' [Maximum volume size(by)], '?' [Max number of files]
union all select 'exFAT' [File system], '255 UTF-16 characters' [Maximum filename length], '?' [Allowable characters in directory entries(bx)], '32,760 Unicode characters with each path component no more than 255 characters[93]' [Maximum pathname length], '16 EiB (18.44 EB)[93]' [Maximum file size], '64 ZiB (75.55 ZB) (276 bytes)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'ext' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '2 GiB (2.147 GB)' [Maximum file size], '2 GiB (2.147 GB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'ext2' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL, /[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '16 GiB (17.17 GB) to 2 TiB (2.199 TB)[by]' [Maximum file size], '2 TiB (2.199 TB) to 32 TiB (35.18 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'ext3' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL, /[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '16 GiB (17.17 GB) to 2 TiB (2.199 TB)[by]' [Maximum file size], '2 TiB (2.199 TB) to 32 TiB (35.18 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'ext4' [File system], '255 bytes[94]' [Maximum filename length], 'Any byte except NUL, /[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '16 GiB (17.17 GB) to 16 TiB (17.59 TB)[by][95]' [Maximum file size], '1 EiB (1.152 EB)' [Maximum volume size(by)], '232 (static inode limit specified at creation)' [Max number of files]
union all select 'F2FS' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL, /[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '4,228,213,756 KiB (4.329 TB)' [Maximum file size], '16 TiB (17.59 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'FAT (8-bit)' [File system], '6.3 (binary files) / 9 characters (ASCII files)' [Maximum filename length], 'ASCII (0x00 and 0xFF not allowed in first character)' [Allowable characters in directory entries(bx)], 'No directory hierarchy' [Maximum pathname length], '?' [Maximum file size], '?' [Maximum volume size(by)], '?' [Max number of files]
union all select 'FAT12' [File system], '8.3 (255 UCS-2 characters with LFN)[cc]' [Maximum filename length], 'SFN: OEM A-Z, 0-9, ! # $ % & '' ( ) - @ ^ _ ` { } ~, 0x80-0xFF, 0x20. LFN: Unicode except NUL, " * / : < > ? \ | [bx][bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '32 MiB (33.55 MB) (4 GiB (4.294 GB))[cd]' [Maximum file size], '1 MiB (1.048 MB) to 32 MiB (33.55 MB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'FAT16' [File system], '8.3 (255 UCS-2 characters with LFN)[cc]' [Maximum filename length], 'SFN: OEM A-Z, 0-9, ! # $ % & '' ( ) - @ ^ _ ` { } ~, 0x80-0xFF, 0x20. LFN: Unicode except NUL, " * / : < > ? \ | [bx][bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '32 MiB (33.55 MB) (4 GiB (4.294 GB))[cd]' [Maximum file size], '1 MiB (1.048 MB) to 32 MiB (33.55 MB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'FAT16B' [File system], '8.3 (255 UCS-2 characters with LFN)[cc]' [Maximum filename length], 'SFN: OEM A-Z, 0-9, ! # $ % & '' ( ) - @ ^ _ ` { } ~, 0x80-0xFF, 0x20. LFN: Unicode except NUL, " * / : < > ? \ | [bx][cc][bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '2 (4) GiB[cd] (2.147 GB)' [Maximum file size], '16 MiB (16.77 MB) to 2 (4) GiB (2.147 GB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'FAT16X' [File system], '8.3 (255 UCS-2 characters with LFN)[cc]' [Maximum filename length], 'SFN: OEM A-Z, 0-9, ! # $ % & '' ( ) - @ ^ _ ` { } ~, 0x80-0xFF, 0x20. LFN: Unicode except NUL, " * / : < > ? \ | [bx][cc][bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '2 (4) GiB[cd] (2.147 GB)' [Maximum file size], '16 MiB (16.77 MB) to 2 (4) GiB (2.147 GB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'FAT32' [File system], '8.3 (255 UCS-2 characters with LFN)[cc]' [Maximum filename length], 'SFN: OEM A-Z, 0-9, ! # $ % & '' ( ) - @ ^ _ ` { } ~, 0x80-0xFF, 0x20. LFN: Unicode except NUL, " * / : < > ? \ | [bx][cc][bz]' [Allowable characters in directory entries(bx)], '32,760 Unicode characters with each path component no more than 255 characters[93]' [Maximum pathname length], '4 GiB (4.294 GB)[93]' [Maximum file size], '512 MiB (536.8 MB) to 16 TiB (17.59 TB)[ce]' [Maximum volume size(by)], '?' [Max number of files]
union all select 'FAT32X' [File system], '8.3 (255 UCS-2 characters with LFN)[cc]' [Maximum filename length], 'SFN: OEM A-Z, 0-9, ! # $ % & '' ( ) - @ ^ _ ` { } ~, 0x80-0xFF, 0x20. LFN: Unicode except NUL, " * / : < > ? \ | [bx][cc][bz]' [Allowable characters in directory entries(bx)], '32,760 Unicode characters with each path component no more than 255 characters[93]' [Maximum pathname length], '4 GiB (4.294 GB)[93]' [Maximum file size], '512 MiB (536.8 MB) to 16 TiB (17.59 TB)[ce]' [Maximum volume size(by)], '?' [Max number of files]
union all select 'FATX' [File system], '42 bytes[cc]' [Maximum filename length], 'ASCII. Unicode not permitted.' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '2 GiB (2.147 GB)' [Maximum file size], '16 MiB (16.77 MB) to 2 GiB (2.147 GB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'FFS' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '4 GiB (4.294 GB)' [Maximum file size], '256 TiB (281.4 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Fossil' [File system], '?' [Maximum filename length], '?' [Allowable characters in directory entries(bx)], '?' [Maximum pathname length], '?' [Maximum file size], '?' [Maximum volume size(by)], '?' [Max number of files]
union all select 'GEC DOS filing system extended' [File system], '8 bytes' [Maximum filename length], 'A–Z, 0–9. Period was directory separator' [Allowable characters in directory entries(bx)], '? No limit defined (workaround for OS limit)' [Maximum pathname length], '? at least 131,072 bytes' [Maximum file size], '?' [Maximum volume size(by)], '?' [Max number of files]
union all select 'GEMDOS' [File system], '44993' [Maximum filename length], 'A-Z, a-z, 0-9 ! @ # $ % ^ & ( ) + - = ~ ` ; '' " , < > | [ ] ( ) _[97]' [Allowable characters in directory entries(bx)], '?' [Maximum pathname length], '?' [Maximum file size], '?' [Maximum volume size(by)], '?' [Max number of files]
union all select 'GFS2' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '100 TiB (109.95 TB) to 8 EiB (9.223 EB)[cf]' [Maximum file size], '100 TiB (109.95 TB) to 8 EiB (9.223 EB)[cg]' [Maximum volume size(by)], '?' [Max number of files]
union all select 'GFS' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '2 TiB (2.199 TB) to 8 EiB (9.223 EB)[ch]' [Maximum file size], '2 TiB (2.199 TB) to 8 EiB (9.223 EB)[ch]' [Maximum volume size(by)], '?' [Max number of files]
union all select 'GPFS' [File system], '255 UTF-8 codepoints' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '9 EiB (10.37 EB)' [Maximum file size], '524,288 YiB (299 bytes)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'HAMMER' [File system], '1023 bytes[100]' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], '?' [Maximum pathname length], '?' [Maximum file size], '1 EiB (1.152 EB)[101]' [Maximum volume size(by)], '?' [Max number of files]
union all select 'HFS' [File system], '31 bytes' [Maximum filename length], 'Any byte except :' [Allowable characters in directory entries(bx)], 'Unlimited' [Maximum pathname length], '2 GiB (2.147 GB)' [Maximum file size], '2 TiB (2.199 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'HFS+' [File system], '255 UTF-16 characters[ci]' [Maximum filename length], 'Any valid Unicode[bz][cj]' [Allowable characters in directory entries(bx)], 'Unlimited' [Maximum pathname length], 'slightly less than 8 EiB (9.223 EB)' [Maximum file size], 'slightly less than 8 EiB (9.223 EB)[102][103]' [Maximum volume size(by)], '?' [Max number of files]
union all select 'High Sierra' [File system], '?' [Maximum filename length], '?' [Allowable characters in directory entries(bx)], '?' [Maximum pathname length], '?' [Maximum file size], '?' [Maximum volume size(by)], '?' [Max number of files]
union all select 'HPFS' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[ck]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '2 GiB (2.147 GB)' [Maximum file size], '2 TiB (2.199 TB)[cl]' [Maximum volume size(by)], '?' [Max number of files]
union all select 'IBM SFS' [File system], '45146' [Maximum filename length], '?' [Allowable characters in directory entries(bx)], '?' [Maximum pathname length], 'Non-hierarchical[104]' [Maximum file size], '?' [Maximum volume size(by)], '?' [Max number of files]
union all select 'ISO 9660:1988' [File system], 'Level 1: 8.3,Level 2 & 3: ~ 180' [Maximum filename length], 'Depends on Level[cm]' [Allowable characters in directory entries(bx)], '~ 180 bytes?' [Maximum pathname length], '4 GiB (4.294 GB) (Level 1 & 2) to 8 TiB (8.796 TB) (Level 3)[cn]' [Maximum file size], '8 TiB (8.796 TB)[co]' [Maximum volume size(by)], '?' [Max number of files]
union all select 'ISO 9660:1999' [File system], '?' [Maximum filename length], '?' [Allowable characters in directory entries(bx)], '?' [Maximum pathname length], '?' [Maximum file size], '?' [Maximum volume size(by)], '?' [Max number of files]
union all select 'JFS' [File system], '255 bytes' [Maximum filename length], 'Any Unicode except NUL' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '4 PiB (4.503 PB)' [Maximum file size], '32 PiB (36.02 PB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'JFS1' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '8 EiB (9.223 EB)' [Maximum file size], '512 TiB (562.9 TB) to 4 PiB (4.503 PB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Joliet ("CDFS")' [File system], '64 Unicode characters' [Maximum filename length], 'All UCS-2 code except *, /, \, :, ;, and ?[105]' [Allowable characters in directory entries(bx)], '?' [Maximum pathname length], 'same as ISO 9660:1988' [Maximum file size], 'same as ISO 9660:1988' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Level-D' [File system], '44991' [Maximum filename length], 'A–Z, 0–9' [Allowable characters in directory entries(bx)], 'DEVICE:FILNAM.EXT[PROJCT,PROGRM] = 7 + 10 + 15 = 32; + 5*7 for SFDs = 67' [Maximum pathname length], '34,359,738,368 words (235); 206,158,430,208 SIXBIT bytes' [Maximum file size], 'Approx 12 GiB (12.88 GB) (64 * 178 MiB (186.6 MB))' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Lustre' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '16 EiB (18.44 EB) on ZFS' [Maximum file size], '16 EiB (18.44 EB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'MFS' [File system], '255 bytes' [Maximum filename length], 'Any byte except :' [Allowable characters in directory entries(bx)], 'No path (flat filesystem)' [Maximum pathname length], '256 MiB (268.4 MB)' [Maximum file size], '256 MiB (268.4 MB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'MicroDOS file system' [File system], '14 bytes' [Maximum filename length], '?' [Allowable characters in directory entries(bx)], '?' [Maximum pathname length], '16 MiB (16.77 MB)' [Maximum file size], '32 MiB (33.55 MB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Minix V1' [File system], '14 or 30 bytes, set at filesystem creation time' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '256.5 MiB (268.9 MB) [cp]' [Maximum file size], '64 MiB (67.10 MB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Minix V2' [File system], '14 or 30 bytes, set at filesystem creation time' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '2 GiB (2.147 GB) [cp]' [Maximum file size], '1 GiB (1.073 GB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Minix V3' [File system], '60 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '2 GiB (2.147 GB)' [Maximum file size], '4 GiB (4.294 GB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'NILFS' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '8 EiB (9.223 EB)' [Maximum file size], '8 EiB (9.223 EB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'NOVA' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL, /[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '16 EiB (18.44 EB)' [Maximum file size], '16 EiB (18.44 EB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'NSS' [File system], '256 characters' [Maximum filename length], 'Depends on namespace used[cq]' [Allowable characters in directory entries(bx)], 'Only limited by client' [Maximum pathname length], '8 TiB (8.796 TB)' [Maximum file size], '8 TiB (8.796 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'NTFS' [File system], '255 characters' [Maximum filename length], 'In Win32 namespace: any UTF-16 code unit (case-insensitive) except /\:*"?<>| as well as NUL' [Allowable characters in directory entries(bx)], '32,767 Unicode characters with each path component (directory or filename) up to 255 characters long[ca]' [Maximum pathname length], '16 TiB (17.59 TB) to 8 PiB (9.007 PB)[cr][107]' [Maximum file size], '16 TiB (17.59 TB) to 8 PiB (9.007 PB)[cr][107]' [Maximum volume size(by)], '232' [Max number of files]
union all select 'NWFS' [File system], '80 bytes[cs]' [Maximum filename length], 'Depends on namespace used[cq]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '4 GiB (4.294 GB)' [Maximum file size], '1 TiB (1.099 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'OCFS' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '8 TiB (8.796 TB)' [Maximum file size], '8 TiB (8.796 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'OCFS2' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '4 PiB (4.503 PB)' [Maximum file size], '4 PiB (4.503 PB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'ODS-5' [File system], '236 bytes[ct]' [Maximum filename length], '?' [Allowable characters in directory entries(bx)], '4,096 bytes[cu]' [Maximum pathname length], '1 TiB (1.099 TB)' [Maximum file size], '1 TiB (1.099 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'QFS' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '16 EiB (18.44 EB)[cv]' [Maximum file size], '4 PiB (4.503 PB)[cv]' [Maximum volume size(by)], '?' [Max number of files]
union all select 'ReFS' [File system], '255 UTF-16 characters[108]' [Maximum filename length], 'In Win32 namespace: any UTF-16 code unit (case-insensitive) except /\:*"?<>| as well as NUL' [Allowable characters in directory entries(bx)], '32,767 Unicode characters with each path component (directory or filename) up to 255 characters long[108]' [Maximum pathname length], '16 EiB (18.44 EB)[108][110]' [Maximum file size], '1 YiB (1.208 YB)[108]' [Maximum volume size(by)], '?' [Max number of files]
union all select 'ReiserFS' [File system], '4,032 bytes/255 characters' [Maximum filename length], 'Any byte except NUL or /[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '8 TiB (8.796 TB)[cw] (v3.6), 4 GiB (4.294 GB) (v3.5)' [Maximum file size], '16 TiB (17.59 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Reiser4' [File system], '3,976 bytes' [Maximum filename length], 'Any byte except / and NUL' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '8 TiB (8.796 TB) on x86' [Maximum file size], '?' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Rock Ridge' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL or /[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], 'same as ISO 9660:1988' [Maximum file size], 'same as ISO 9660:1988' [Maximum volume size(by)], '?' [Max number of files]
union all select 'RT-11' [File system], '44991' [Maximum filename length], 'A–Z, 0–9, $' [Allowable characters in directory entries(bx)], '0 (no directory hierarchy)' [Maximum pathname length], '33,554,432 bytes (65536 * 512)' [Maximum file size], '33,554,432 bytes' [Maximum volume size(by)], '?' [Max number of files]
union all select 'SquashFS' [File system], '256 bytes' [Maximum filename length], '?' [Allowable characters in directory entries(bx)], 'No limit defined' [Maximum pathname length], '16 EiB (18.44 EB)' [Maximum file size], '16 EiB (18.44 EB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'UDF' [File system], '255 bytes' [Maximum filename length], 'Any Unicode except NUL' [Allowable characters in directory entries(bx)], '1,023 bytes[cx]' [Maximum pathname length], '16 EiB (18.44 EB)' [Maximum file size], '512 MiB (536.8 MB) to 16 TiB (17.59 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'UFS1' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '16 GiB (17.17 GB) to 256 TiB (281.4 TB)' [Maximum file size], '16 EiB (18.44 EB)' [Maximum volume size(by)], 'Subdirectory per directory is 32,767[112]' [Max number of files]
union all select 'UFS2' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '512 GiB (549.7 GB) to 32 PiB (36.02 PB)' [Maximum file size], '512 ZiB (604.4 ZB)[113] (279 bytes)' [Maximum volume size(by)], 'Subdirectory per directory is 32,767[112]' [Max number of files]
union all select 'UniFS' [File system], 'No limit defined (depends on client)' [Maximum filename length], '?' [Allowable characters in directory entries(bx)], 'No limit defined (depends on client)' [Maximum pathname length], 'Available cache space at time of write (depends on platform)' [Maximum file size], 'No limit defined' [Maximum volume size(by)], 'No limit defined' [Max number of files]
union all select 'Version 6 Unix file system (V6FS)' [File system], '14 bytes' [Maximum filename length], 'Any byte except NUL and /[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '16 MiB (16.77 MB)[cy]' [Maximum file size], '32 MiB (33.55 MB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Version 7 Unix file system (V7FS)' [File system], '14 bytes' [Maximum filename length], 'Any byte except NUL or /[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '1 GiB (1.073 GB)[cz]' [Maximum file size], '2 TiB (2.199 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'VMFS2' [File system], '128' [Maximum filename length], 'Any byte except NUL or /[bz]' [Allowable characters in directory entries(bx)], '2,048' [Maximum pathname length], '4 TiB (4.398 TB)[da]' [Maximum file size], '64 TiB (70.36 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'VMFS3' [File system], '128' [Maximum filename length], 'Any byte except NUL or /[bz]' [Allowable characters in directory entries(bx)], '2,048' [Maximum pathname length], '2 TiB (2.199 TB)[da]' [Maximum file size], '64 TiB (70.36 TB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'VxFS' [File system], '255 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '16 EiB (18.44 EB)' [Maximum file size], '?' [Maximum volume size(by)], '?' [Max number of files]
union all select 'XFS' [File system], '255 bytes[db]' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '8 EiB (9.223 EB)[dc]' [Maximum file size], '8 EiB (9.223 EB)[dc]' [Maximum volume size(by)], '?' [Max number of files]
union all select 'Xiafs' [File system], '248 bytes' [Maximum filename length], 'Any byte except NUL[bz]' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '64 MiB (67.10 MB)' [Maximum file size], '2 GiB (2.147 GB)' [Maximum volume size(by)], '?' [Max number of files]
union all select 'ZFS' [File system], '255 bytes' [Maximum filename length], 'Any Unicode except NUL' [Allowable characters in directory entries(bx)], 'No limit defined[ca]' [Maximum pathname length], '16 EiB (18.44 EB)' [Maximum file size], '281,474,976,710,656 YiB (2128 bytes)' [Maximum volume size(by)], '2128' [Max number of files]
)
, w as (
select distinct e.[File system] from (
select [File system] from q1
union all select [File system] from q2
union all select [File system] from q3
union all select [File system] from q4
union all select [File system] from q5
union all select [File system] from q6
union all select [File system] from q7
union all select [File system] from q8
) e
)
select *
from w w1
left join q1 r1 on w1.[File system] = r1.[File system]
left join q2 r2 on w1.[File system] = r2.[File system]
left join q3 r3 on w1.[File system] = r3.[File system]
left join q4 r4 on w1.[File system] = r4.[File system]
left join q5 r5 on w1.[File system] = r5.[File system]
left join q6 r6 on w1.[File system] = r6.[File system]
left join q7 r7 on w1.[File system] = r7.[File system]
left join q8 r8 on w1.[File system] = r8.[File system]