control substitution on

statement ok
CREATE EXTERNAL TABLE bed STORED AS BED LOCATION '$CARGO_MANIFEST_DIR/test-data/datasources/bed/test.bed';

query T
SELECT * FROM bed LIMIT 1
----
chr1 11874 12227 NR_046018_exon_0_0_chr1_11874_f NULL + NULL NULL NULL NULL NULL NULL

query T
SELECT COUNT(*) as cnt FROM bed;
----
10

statement ok
DROP TABLE bed;

statement ok
CREATE EXTERNAL TABLE bed STORED AS BED PARTITIONED BY (sample) LOCATION '$CARGO_MANIFEST_DIR/test-data/datasources/bed-partition/'

query T
SELECT * FROM bed WHERE sample = '1' LIMIT 1;
----
chr1 11874 12227 NR_046018_exon_0_0_chr1_11874_f NULL + NULL NULL NULL NULL NULL NULL 1

statement ok
DROP TABLE bed;

query T
SELECT COUNT(*) FROM bed_scan('$CARGO_MANIFEST_DIR/test-data/datasources/bed/test.bed');
----
10

query T
SELECT COUNT(*) FROM bed_scan('$CARGO_MANIFEST_DIR/test-data/datasources/bed-partition/');
----
20

query T
SELECT COUNT(*) FROM bed_scan('$CARGO_MANIFEST_DIR/test-data/datasources/bed/test.bed.gz', 'gzip');
----
1

statement ok
CREATE EXTERNAL TABLE bed STORED AS BED LOCATION '$CARGO_MANIFEST_DIR/test-data/datasources/bed/name_256bytes.one.bed';

query T
SELECT name FROM bed LIMIT 1;
----
PURK_peak_11,INH_SST_peak_18b,INH_SST_peak_18c,GC_peak_40a,GC_peak_40b,GC_peak_40c,OPC_peak_30b,OPC_peak_30c,MOL_peak_32c,INH_VIP_peak_18a,NFOL_peak_32e,NFOL_peak_32f,AST_CER_peak_48e,AST_CER_peak_48f,ENDO_peak_7,AST_peak_17c,GP_peak_20,ASTP_peak_19e,INH_V

statement ok
DROP TABLE bed;