Function TestDMLUpdate

tests/integration/dml_test.go:171–241

TestDMLUpdate tests UPDATE variations

(t *testing.T)

// TestDMLUpdate tests UPDATE variations
func TestDMLUpdate(t *testing.T) {
	// Create and populate test table
	mustExec(t, testHarness.DuckgresDB, "CREATE TABLE dml_update_test (id INTEGER, name TEXT, status TEXT, counter INTEGER)")
	mustExec(t, testHarness.DuckgresDB, `
		INSERT INTO dml_update_test VALUES
		(1, 'Alice', 'active', 10),
		(2, 'Bob', 'active', 20),
		(3, 'Charlie', 'inactive', 30),
		(4, 'Diana', 'active', 40),
		(5, 'Eve', 'inactive', 50)
	`)

	t.Run("update_single_column", func(t *testing.T) {
		result, err := testHarness.DuckgresDB.Exec("UPDATE dml_update_test SET status = 'updated' WHERE id = 1")
		if err != nil {
			t.Fatalf("Update failed: %v", err)
		}
		affected, _ := result.RowsAffected()
		if affected != 1 {
			t.Errorf("Expected 1 row affected, got %d", affected)
		}
	})

	t.Run("update_multiple_columns", func(t *testing.T) {
		result, err := testHarness.DuckgresDB.Exec("UPDATE dml_update_test SET status = 'modified', counter = 100 WHERE id = 2")
		if err != nil {
			t.Fatalf("Update failed: %v", err)
		}
		affected, _ := result.RowsAffected()
		if affected != 1 {
			t.Errorf("Expected 1 row affected, got %d", affected)
		}
	})

	t.Run("update_with_expression", func(t *testing.T) {
		_, err := testHarness.DuckgresDB.Exec("UPDATE dml_update_test SET counter = counter + 5 WHERE id = 3")
		if err != nil {
			t.Fatalf("Update with expression failed: %v", err)
		}
		// Verify
		result, _ := ExecuteQuery(testHarness.DuckgresDB, "SELECT counter FROM dml_update_test WHERE id = 3")
		if result.Rows[0][0].(int64) != 35 {
			t.Errorf("Expected counter=35, got %v", result.Rows[0][0])
		}
	})

	t.Run("update_multiple_rows", func(t *testing.T) {
		result, err := testHarness.DuckgresDB.Exec("UPDATE dml_update_test SET status = 'batch_updated' WHERE status = 'inactive'")
		if err != nil {
			t.Fatalf("Batch update failed: %v", err)
		}
		affected, _ := result.RowsAffected()
		if affected < 1 {
			t.Errorf("Expected at least 1 row affected, got %d", affected)
		}
	})

	t.Run("update_all_rows", func(t *testing.T) {