Reading CSV file in DBBeaver dropping characters

[hohenstrater]

I am trying to data cleanse some csv with something like this

Input

22,"hjhjjh
Some text
",966542497

when i try and read this file using the following SQL (I want every newline as a new row)

select column0 A, from read_csv('test.csv', header = false, delim= '|', quote='$')

output

22,"hjhjjh
Some text
,966542497

however, the last line dropped the first char ".

if i change the data and add a space at the front of that row

Input 2

22,"hjhjjh
Some text
",966542497

select column0 A, from read_csv('test_2.csv', header = false, delim= '|', quote='$')

The first space char is removed, but keeps the " char

Output 2

22,"hjhjjh
Some text
",966542497

test.csv
test_2.csv

My expectation was that by defining the delimiter and quote to something non existing in the file, i would get the raw rows.

Duckdb version 2.0.0