ClickHouse / clickhouse-go

Golang driver for ClickHouse
Apache License 2.0
2.82k stars 546 forks source link

PrepareBatch fails when insert into has no space before parentheses #1326

Closed ramzes642 closed 6 days ago

ramzes642 commented 3 weeks ago

Observed

PrepareBatch(ctx, "INSERT INTO rowtest(createDt, value)") Returns error:

code: 62, message: Syntax error: failed at position 20 ('('): (createDt, VALUES. Unmatched parentheses: (

Under debugger I see that query var is cut by insertMatch regexp to INSERT INTO rowtest(createDt,

Expected behaviour

No error

Code example

package code

batch, err := clickhouse.PrepareBatch(ctx, "INSERT INTO rowtest(createDt, value)")
if err != nil {
    log.Println(err) 
}

Error log

code: 62, message: Syntax error: failed at position 20 ('('): (createDt, VALUES. Unmatched parentheses: (

Details

Environment