-
Notifications
You must be signed in to change notification settings - Fork 4.1k
Syntax error when executing transaction with go pq sql driver library. #16309
Description
BUG REPORT
- Please supply the header (i.e. the first few lines) of your most recent
log file for each node in your cluster.
I170603 06:28:35.309149 61 util/log/clog.go:908 [config] file created at: 2017/06/03 06:28:35
I170603 06:28:35.309149 61 util/log/clog.go:908 [config] running on machine: cockroach-1
I170603 06:28:35.309149 61 util/log/clog.go:908 [config] binary: CockroachDB CCL v1.0 (linux amd64, built 2017/05/10 13:19:57, go1.8.1)
I170603 06:28:35.309149 61 util/log/clog.go:908 [config] arguments: [cockroach start --insecure --store /cockroachdata]
- Please describe the issue you observed:
- What did you do?
Ran a transaction with github.com/lib/pq and github.com/lib/pq
- What did you expect to see?
The transaction to execute correctly.
- What did you see instead?
2017/06/04 10:28:54 an error occured during billing: error billing due account 247821695300435969: pq: syntax error at or near "read"
BEGIN READ WRITE
The issue seems to be cockroachdb does not support the READ WRITE syntax used by the pq driver at the following line:
https://github.com/lib/pq/blob/8837942c3e09574accbc5f150e2c5e057189cace/conn_go18.go#L68