##### 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