control substitution on

statement ok
CREATE EXTERNAL TABLE fastq_table STORED AS FASTQ LOCATION '$CARGO_MANIFEST_DIR/test-data/datasources/fastq/test.fastq';

query T
SELECT name, description, quality_scores, sequence FROM fastq_table LIMIT 2;
----
SEQ_ID This is a description !''*((((***+))%%%++)(%%%%).1***-+*''))**55CCF>>>>>>CCCCCCC65 GATTTGGGGTExonAAGCAGTATCGAExonAATAGTAAATCCATTTGTExonACExonCAGTTT
SEQ_ID2 NULL !''*((((***+))%%%++)(%%%%).1***-+*''))**55CCF>>>>>>CCCCCCC65 GATTTGGGGTExonAAGCAGTATCGAExonAATAGTAAATCCATTTGTExonACExonCAGTTT

statement ok
DROP TABLE fastq_table;

statement ok
CREATE EXTERNAL TABLE fastq_table STORED AS FASTQ LOCATION '$CARGO_MANIFEST_DIR/test-data/datasources/fastq/test.fastq.gz' OPTIONS (compression gzip);

query T
SELECT name, description, quality_scores, sequence FROM fastq_table LIMIT 2;
----
SEQ_ID This is a description !''*((((***+))%%%++)(%%%%).1***-+*''))**55CCF>>>>>>CCCCCCC65 GATTTGGGGTExonAAGCAGTATCGAExonAATAGTAAATCCATTTGTExonACExonCAGTTT
SEQ_ID2 NULL !''*((((***+))%%%++)(%%%%).1***-+*''))**55CCF>>>>>>CCCCCCC65 GATTTGGGGTExonAAGCAGTATCGAExonAATAGTAAATCCATTTGTExonACExonCAGTTT

statement ok
DROP TABLE fastq_table;

statement ok
CREATE EXTERNAL TABLE fastq_table STORED AS FASTQ LOCATION '$CARGO_MANIFEST_DIR/test-data/datasources/fastq/test.fastq.zst' OPTIONS (compression zstd);

query T
SELECT name, description, quality_scores, sequence FROM fastq_table LIMIT 2;
----
SEQ_ID This is a description !''*((((***+))%%%++)(%%%%).1***-+*''))**55CCF>>>>>>CCCCCCC65 GATTTGGGGTExonAAGCAGTATCGAExonAATAGTAAATCCATTTGTExonACExonCAGTTT
SEQ_ID2 NULL !''*((((***+))%%%++)(%%%%).1***-+*''))**55CCF>>>>>>CCCCCCC65 GATTTGGGGTExonAAGCAGTATCGAExonAATAGTAAATCCATTTGTExonACExonCAGTTT

statement ok
DROP TABLE fastq_table;

statement ok
CREATE EXTERNAL TABLE fastq_table STORED AS FASTQ PARTITIONED BY (sample) LOCATION '$CARGO_MANIFEST_DIR/test-data/datasources/fastq-partition';

query T
SELECT name, sample FROM fastq_table WHERE sample = '1' LIMIT 2;
----
SEQ_ID 1
SEQ_ID2 1

statement ok
DROP TABLE fastq_table;

query T
SELECT COUNT(*) FROM fastq_scan('$CARGO_MANIFEST_DIR/test-data/datasources/fastq/test.fastq');
----
2

query T
SELECT COUNT(*) FROM fastq_scan('$CARGO_MANIFEST_DIR/test-data/datasources/fastq-partition/');
----
4

query T
SELECT COUNT(*) FROM fastq_scan('$CARGO_MANIFEST_DIR/test-data/datasources/fastq/test.fastq.gz', 'gzip');
----
2

query T
SELECT COUNT(*) FROM fastq_scan('$CARGO_MANIFEST_DIR/test-data/datasources/fastq/test_bgzip.fastq.gz', 'gzip');
----
2

statement ok
CREATE EXTERNAL TABLE fastq_table STORED AS FASTQ OPTIONS (file_extension 'fq') LOCATION '$CARGO_MANIFEST_DIR/test-data/datasources/fq/test.fq';

query T
SELECT COUNT(*) FROM fastq_table;
----
2

query T
SELECT name, COUNT(*) FROM fastq_table GROUP BY name;
----
SEQ_ID 1
SEQ_ID2 1

statement ok
DROP TABLE fastq_table;