(t *testing.T)
| 309 | } |
| 310 | |
| 311 | func TestQuery_JSONBExistsOperator(t *testing.T) { |
| 312 | // Test the ? operator (key existence check) |
| 313 | q := Q().Space("SELECT * FROM tasks"). |
| 314 | Where("payload ?? 'schema_version'") |
| 315 | sql, args, err := q.ToSQL() |
| 316 | require.NoError(t, err) |
| 317 | require.Equal(t, "SELECT * FROM tasks WHERE payload ? 'schema_version'", sql) |
| 318 | require.Empty(t, args) |
| 319 | } |
| 320 | |
| 321 | func TestQuery_JSONBExistsAnyOperator(t *testing.T) { |
| 322 | // Test the ?| operator (any key exists) |