(t *testing.T)
| 71 | } |
| 72 | |
| 73 | func TestReplaceTable_SubqueryInWhere(t *testing.T) { |
| 74 | stmt := mustParse(t, "SELECT * FROM users WHERE users.id IN (SELECT user_id FROM orders WHERE orders.active = true)") |
| 75 | err := Apply(stmt, ReplaceTable("orders", "purchases")) |
| 76 | if err != nil { |
| 77 | t.Fatal(err) |
| 78 | } |
| 79 | out := format(stmt) |
| 80 | assertContains(t, out, "purchases") |
| 81 | assertNotContains(t, out, "orders") |
| 82 | } |
| 83 | |
| 84 | func TestReplaceTable_InSubquery(t *testing.T) { |
| 85 | stmt := mustParse(t, "SELECT * FROM users WHERE EXISTS (SELECT 1 FROM orders WHERE orders.user_id = users.id)") |
nothing calls this directly
no test coverage detected