"SELECT * FROM `users` INNER JOIN `articles` ON `articles`.`id` = `users`.`id` LEFT JOIN `companies` USING (`company_name`)", nil,
		},
	}

	for idx, result := range results {
		t.Run(fmt.Sprintf("case #%v", idx), func(t *testing.T) {
			checkBuildClauses(t, result.Clauses, result.Result, result.Vars)
		})
	}

		}
		for i := 1; i < len(result.Pets); i++ {
			if result.Pets[i-1].Name > result.Pets[i].Name {
				t.Fatalf("Preload user %v pets not ordered correctly, last %v, cur %v", result.Name, result.Pets[i-1], result.Pets[i])
			}
		}
		for i := 1; i < len(result.Pets); i++ {
			if result.Pets[i-1].Name > result.Pets[i].Name {

        /**
         * The total number of pages in the search results.
         */
        protected int pageCount;
        /**
         * Indicates if there is a next page of search results.
         */
        protected boolean nextPage;
        /**
         * Indicates if there is a previous page of search results.
         */
        protected boolean prevPage;
        /**

			}},
			"SELECT * FROM `users` GROUP BY `role`,`gender` HAVING `role` = ? AND `gender` <> ?",
			[]interface{}{"admin", "U"},
		},
	}

	for idx, result := range results {
		t.Run(fmt.Sprintf("case #%v", idx), func(t *testing.T) {
			checkBuildClauses(t, result.Clauses, result.Result, result.Vars)
		})
	}

			"SELECT * FROM `users` FOR UPDATE SKIP LOCKED", nil,
		},
	}

	for idx, result := range results {
		t.Run(fmt.Sprintf("case #%v", idx), func(t *testing.T) {
			checkBuildClauses(t, result.Clauses, result.Result, result.Vars)
		})
	}

        String result = server.toString();

        assertNotNull(result);
        assertTrue(result.startsWith("ServerInfo1["));
        assertTrue(result.contains("name=SERVER01"));
        assertTrue(result.contains("versionMajor=6"));
        assertTrue(result.contains("versionMinor=1"));
        assertTrue(result.contains("type=0x00000801"));
        assertTrue(result.contains("commentOrMasterBrowser=Test server"));

        if (!attrList.isEmpty()) {
            consumer.accept(attrList.get(0));
        }
    }

    /**
     * Gets a list of attribute values from search results.
     *
     * @param result the list of search results
     * @param name the attribute name
     * @return a list of attribute values
     */

import org.apache.maven.api.services.Request;
import org.apache.maven.api.services.Result;

/**
 * Interface for caching request results in Maven. This cache implementation provides
 * methods for executing and optionally caching both single requests and batches of requests.
 * <p>
 * The cache behavior is determined by the cache retention specified in the request's metadata.
 * Results can be cached at different policies (forever, session, request, or not at all)

				},
			},
			"SELECT * FROM `users` ORDER BY FIELD(id, ?,?,?)",
			[]interface{}{1, 2, 3},
		},
	}

	for idx, result := range results {
		t.Run(fmt.Sprintf("case #%v", idx), func(t *testing.T) {
			checkBuildClauses(t, result.Clauses, result.Result, result.Vars)
		})
	}

        String[] results = relatedQueryHelper.getRelatedQueries("java");
        assertEquals(2, results.length);
        assertEquals("programming", results[0]);
        assertEquals("tutorial", results[1]);

        results = relatedQueryHelper.getRelatedQueries("python");
        assertEquals(2, results.length);
        assertEquals("scripting", results[0]);
        assertEquals("data science", results[1]);