(t *testing.T)
| 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)") |
| 86 | err := Apply(stmt, ReplaceTable("orders", "purchases")) |
| 87 | if err != nil { |
| 88 | t.Fatal(err) |
| 89 | } |
| 90 | out := format(stmt) |
| 91 | assertContains(t, out, "purchases") |
| 92 | assertNotContains(t, out, "orders") |
| 93 | } |
| 94 | |
| 95 | func TestQualifyColumns_NestedExpressions(t *testing.T) { |
| 96 | stmt := mustParse(t, "SELECT COALESCE(name, email) FROM users WHERE active = true") |
nothing calls this directly
no test coverage detected