control substitution on

statement ok
CREATE EXTERNAL TABLE hmm_table STORED AS HMMDOMTAB LOCATION '$CARGO_MANIFEST_DIR/test-data/datasources/hmmdomtab/test.hmmdomtab';

query T
SELECT target_name FROM hmm_table LIMIT 1;
----
KanNP_rdsDRAFT_30000008001

statement ok
DROP TABLE hmm_table;

statement ok
CREATE EXTERNAL TABLE hmm_table STORED AS HMMDOMTAB PARTITIONED BY (sample) LOCATION '$CARGO_MANIFEST_DIR/test-data/datasources/hmmdomtab-partition/';

query T
SELECT sample, COUNT(*) cnt FROM hmm_table GROUP BY sample ORDER BY sample;
----
1 100
2 100

statement ok
DROP TABLE hmm_table;

query T
SELECT COUNT(*) FROM hmm_dom_tab_scan('$CARGO_MANIFEST_DIR/test-data/datasources/hmmdomtab/test.hmmdomtab');
----
100

query T
SELECT COUNT(*) FROM hmm_dom_tab_scan('$CARGO_MANIFEST_DIR/test-data/datasources/hmmdomtab-partition/');
----
200

query T
SELECT COUNT(*) FROM hmm_dom_tab_scan('$CARGO_MANIFEST_DIR/test-data/datasources/hmmdomtab/test.hmmdomtab.gz', 'gzip');
----
100