connecting.md: update AUTOCOMMIT behavior

Summary

• connecting.md: update AUTOCOMMIT behavior

---

• Close #415 (closed)

• Cherry-pick to: 25.1,

• Staging:

  • https://docs.binary.picodata.io/picodata/at/autocommit/