unsupported_locking_test.go 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263
  1. package pgserver
  2. import (
  3. "bytes"
  4. "testing"
  5. )
  6. // errorField extracts a named field from an ErrorResponse.
  7. func errorField(t *testing.T, msg *Message, want byte) string {
  8. t.Helper()
  9. if msg == nil || msg.Type != MsgErrorResponse {
  10. t.Fatalf("message type = %v, want ErrorResponse", msg)
  11. }
  12. data := msg.Data
  13. for i := 0; i < len(data); {
  14. if data[i] == 0 {
  15. break
  16. }
  17. field := data[i]
  18. i++
  19. end := bytes.IndexByte(data[i:], 0)
  20. if end < 0 {
  21. break
  22. }
  23. value := string(data[i : i+end])
  24. if field == want {
  25. return value
  26. }
  27. i += end + 1
  28. }
  29. return ""
  30. }
  31. func TestLockingClauseSupportedShapeOverSimpleQuery(t *testing.T) {
  32. c, client := newDataConnection(t)
  33. runQuery(t, c, client, &Message{Type: MsgQuery, Data: append([]byte("CREATE TABLE t (id INTEGER PRIMARY KEY)"), 0)})
  34. msgs := runQuery(t, c, client, &Message{Type: MsgQuery, Data: append([]byte("SELECT * FROM t FOR UPDATE"), 0)})
  35. if code := errorCode(msgs[0]); code != "" {
  36. t.Fatalf("locking query error = %q", code)
  37. }
  38. }
  39. func TestLockingClauseRejectsUnsupportedShapes(t *testing.T) {
  40. c, client := newDataConnection(t)
  41. for _, sql := range []string{
  42. "CREATE TABLE t (id INTEGER PRIMARY KEY)",
  43. "CREATE TABLE u (id INTEGER PRIMARY KEY)",
  44. } {
  45. runQuery(t, c, client, &Message{Type: MsgQuery, Data: append([]byte(sql), 0)})
  46. }
  47. for _, sql := range []string{
  48. "SELECT * FROM t a JOIN u b ON a.id = b.id FOR UPDATE",
  49. "SELECT COUNT(*) FROM t FOR UPDATE",
  50. "SELECT DISTINCT id FROM t FOR UPDATE",
  51. "SELECT id FROM t UNION SELECT id FROM u FOR UPDATE",
  52. } {
  53. msgs := runQuery(t, c, client, &Message{Type: MsgQuery, Data: append([]byte(sql), 0)})
  54. if code := errorCode(msgs[0]); code != ErrCodeFeatureNotSupported {
  55. t.Fatalf("%s: error code = %q, want %q", sql, code, ErrCodeFeatureNotSupported)
  56. }
  57. }
  58. }