Reading CSV file in DBBeaver dropping characters

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](https://github.com/user-attachments/files/19117687/test.csv)
[test_2.csv](https://github.com/user-attachments/files/19117686/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