control substitution on

query III
SELECT * FROM fasta_indexed_scan('$CARGO_MANIFEST_DIR/test-data/datasources/fasta-indexed/test.fasta', 'a');
----
a NULL ATCG

query III
SELECT * FROM fasta_indexed_scan('$CARGO_MANIFEST_DIR/test-data/datasources/fasta-indexed/test.fasta', 'a:3-4');
----
a:3-4 NULL CG

query III
SELECT * FROM fasta_indexed_scan('s3://test-bucket/test-indexed.fasta', 'a:1-2');
----
a:1-2 NULL AT

query III
SELECT * FROM fasta_indexed_scan('$CARGO_MANIFEST_DIR/test-data/datasources/fasta-indexed/test.fasta', '$CARGO_MANIFEST_DIR/test-data/datasources/fasta-indexed/region.txt') ORDER BY id;
----
a:1-2 NULL AT
a:3-4 NULL CG

# TODO: figure out why the gz file can't be found on github
# query III
# SELECT * FROM fasta_indexed_scan('$CARGO_MANIFEST_DIR/test-data/datasources/fasta-indexed/test.fasta.gz', '$CARGO_MANIFEST_DIR/test-data/datasources/fasta-indexed/region.txt') ORDER BY id;
# ----
# a:1-2 NULL AT
# a:3-4 NULL CG

query III
SELECT * FROM fasta_indexed_scan('s3://test-bucket/test-indexed.fasta', '$CARGO_MANIFEST_DIR/test-data/datasources/fasta-indexed/region.txt') ORDER BY id;
----
a:1-2 NULL AT
a:3-4 NULL CG

statement error Indexed FASTA from remote storage only supports uncompressed files.
SELECT * FROM fasta_indexed_scan('s3://test-bucket/test-indexed.fasta.gz', '$CARGO_MANIFEST_DIR/test-data/datasources/fasta-indexed/region.txt') ORDER BY id;

query III
SELECT * FROM fasta_indexed_scan('$CARGO_MANIFEST_DIR/test-data/datasources/fasta-indexed/test.fasta', 's3://test-bucket/region.txt') ORDER BY id;
----
a:1-2 NULL AT
a:3-4 NULL CG