control substitution on

statement ok
CREATE EXTERNAL TABLE mzml_table STORED AS MZML LOCATION '$CARGO_MANIFEST_DIR/test-data/datasources/mzml-pyoteomics/pyoteomics.mzML'

statement ok
SELECT * FROM mzml_table LIMIT 1;

query I
SELECT contains_peak(mz.mz, 200.0, 1.0) AS has_peak FROM mzml_table LIMIT 1;
----
true

query I
SELECT contains_peak(mz.mz, 0.0, 1.0) AS has_peak FROM mzml_table LIMIT 1;
----
false

statement error
SELECT contains_peak(mz.mz) AS has_peak FROM mzml_table LIMIT 1;

query T
SELECT bin_vectors(mz.mz, intensity.intensity, 200.0, 10, 1.0) AS bins FROM mzml_table LIMIT 1;
----
[0.0, 0.0, 0.0, 0.0, 203667.40002441406, 0.0, 0.0, 0.0, 0.0, 0.0]

statement ok
DROP TABLE mzml_table

statement ok
CREATE TABLE mzml_table AS SELECT [1.0, 2.0, 3.0] AS mz, [1.0, 2.0, 3.0] AS intensity;

query T
SELECT bin_vectors(mz, intensity, 1.0, 3, 1.0) AS bins FROM mzml_table;
----
[1.0, 2.0, 3.0]

statement ok
DROP TABLE mzml_table

query T
SELECT COUNT(*) FROM mzml_scan('$CARGO_MANIFEST_DIR/test-data/datasources/mzml-pyoteomics/pyoteomics.mzML')
----
2

query T
SELECT COUNT(*) FROM mzml_scan('$CARGO_MANIFEST_DIR/test-data/datasources/mzml/test.mzML.gz', 'gzip')
----
2

statement ok
CREATE EXTERNAL TABLE mzml_table STORED AS MZML PARTITIONED BY (sample) LOCATION '$CARGO_MANIFEST_DIR/test-data/datasources/mzml-partition/';

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