client_spec.rb

context "Multiple results sets" do
  before(:each) do
    @multi_client = Mysql2::Client.new(DatabaseCredentials['root'].merge(:flags => Mysql2::Client::MULTI_STATEMENTS))
  end

  it "should raise an exception when one of multiple statements fails" do
    @multi_client.query("SELECT 1 as 'set_1'; SELECT * FROM invalid_table_name;")
    lambda {
      @multi_client.next_result
    }.should raise_error(Mysql2::Error)
  end
end