##### defines data for handcrafted database with pseudo-duplicates - one wide table

[maptable_001]
data=<<DATA
type_001/a_001 type_002/a_001	type_003/a_001	type_004/a_001
type_001/a_111 type_002/a_111	type_003/a_111	type_004/a_111
type_001/a_111 type_002/a_111	type_003/a_111	NULL
type_001/a_111 type_002/a_111	NULL    	type_004/a_111
type_001/a_111 type_002/a_111	NULL		NULL
type_001/a_111 NULL		type_003/a_111	type_004/a_111
type_001/a_111 NULL		type_003/a_111	NULL
type_001/a_111 NULL		NULL		type_004/a_111
type_001/a_111 NULL		NULL		NULL
NULL	       type_002/a_111	type_003/a_111	NULL
NULL	       type_002/a_111	NULL    	type_004/a_111
NULL	       type_002/a_111	NULL		NULL
NULL	       NULL		type_003/a_111	type_004/a_111
NULL	       NULL		type_003/a_111	NULL
NULL	       NULL		NULL		type_004/a_111
DATA

[type_001_master]
data=<<DATA
type_001/a_000
type_001/a_001
type_001/a_111
DATA

[type_002_master]
data=<<DATA
type_002/a_000
type_002/a_001
type_002/a_111
DATA

# type_003_master & type_multi_master are for testing load_implicit_masters
[type_003_master]
data=<<DATA
type_003/a_001
type_003/a_111
DATA

[type_004_master]
data=<<DATA
type_004/a_001
type_004/a_111
DATA

# correct ur
[ur]
data=<<DATA
type_001/a_001 type_002/a_001	type_003/a_001	type_004/a_001
type_001/a_111 type_002/a_111	type_003/a_111	type_004/a_111
type_001/a_111 type_002/a_111	type_003/a_111	NULL
type_001/a_111 type_002/a_111	NULL    	type_004/a_111
type_001/a_111 type_002/a_111	NULL		NULL
type_001/a_111 NULL		type_003/a_111	type_004/a_111
type_001/a_111 NULL		type_003/a_111	NULL
type_001/a_111 NULL		NULL		type_004/a_111
type_001/a_111 NULL		NULL		NULL
NULL	       type_002/a_111	type_003/a_111	NULL
NULL	       type_002/a_111	NULL    	type_004/a_111
NULL	       type_002/a_111	NULL		NULL
NULL	       NULL		type_003/a_111	type_004/a_111
NULL	       NULL		type_003/a_111	NULL
NULL	       NULL		NULL		type_004/a_111
type_001/a_000 NULL		NULL		NULL
NULL	       type_002/a_000	NULL		NULL
DATA

[ur_selection]
data=<<DATA
type_001/a_001  type_004/a_001
type_001/a_111  type_004/a_111
type_001/a_111  NULL
NULL		type_004/a_111
type_001/a_000  NULL
DATA

[basics]
data=<<DATA
type_001/a_001 type_002/a_001	type_003/a_001	type_004/a_001
type_001/a_111 type_002/a_111	type_003/a_111	type_004/a_111
DATA

[basics_validate]
data=<<DATA
type_001/a_001      1  type_003/a_001
type_001/a_111      1  type_003/a_111
type_001/a_000      1  NULL
type_001/a_011      0  NULL
type_001/a_110      0  NULL
type_001/a_invalid  0  NULL
DATA

[basics_filter]
data=<<DATA
type_001/a_111 type_002/a_111	type_003/a_111	type_004/a_111
DATA

[filter_all]
data=<<DATA
type_001/a_001  type_002/a_001  type_003/a_001  type_004/a_001
type_001/a_111  type_002/a_111  type_003/a_111  type_004/a_111
DATA

[filter_one]
data=<<DATA
type_001/a_111  type_002/a_111	type_003/a_111	type_004/a_111
DATA

[filter_one_undef]
data=<<DATA
type_001/a_111  type_002/a_111	type_003/a_111	type_004/a_111
DATA

[basics_all]
data=<<DATA
type_001/a_001 type_002/a_001	type_003/a_001	type_004/a_001
type_001/a_111 type_002/a_111	type_003/a_111	type_004/a_111
DATA

# test one id for each input idtype
[type_001]
data=<<DATA
type_001/a_111  type_001/a_111 type_002/a_111	type_003/a_111	type_004/a_111
DATA

[type_002]
data=<<DATA
type_002/a_111  type_001/a_111 type_002/a_111	type_003/a_111	type_004/a_111
DATA

[type_003]
data=<<DATA
type_003/a_111  type_001/a_111 type_002/a_111	type_003/a_111	type_004/a_111
DATA

[type_004]
data=<<DATA
type_004/a_111  type_001/a_111 type_002/a_111	type_003/a_111	type_004/a_111
DATA