import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.sql.ResultSet;

public class mariadb_bug
{
    public static void main(String[] args) throws SQLException
    {
        Connection connection =
            DriverManager.getConnection(
                "jdbc:mariadb://localhost/somedatabase?allowMultiQueries=true",
                "someuser",
                "xxxxxx");
        Statement statement = connection.createStatement();
        boolean is_result_set = 
            statement.execute(
                "create table if not exists content (value varchar(2) null); " +
                "create table if not exists cover (value varchar(2) null);");
        for (;;)
        {
            System.out.println("attempting to get next result:");
            if (is_result_set)
            {
                System.out.println("  result is a result set");
                ResultSet result_set = statement.getResultSet();
                if (result_set == null)
                    System.out.println("  result set is null");
            }
            else
            {
                int update_count = statement.getUpdateCount();
                if (update_count == -1)
                {
                    System.out.println("  no result");
                    break;
                }
                System.out.println("  result is an update count");
                System.out.println("  update count = " + update_count);
            }
            is_result_set = statement.getMoreResults();
        }
    }
}

