})
	})
	assertEqualSQL(t, `SELECT * FROM users ORDER BY id DESC`, sql)
}

// assertEqualSQL for assert that the sql is equal, this method will ignore quote, and dialect specials.
func assertEqualSQL(t *testing.T, expected string, actually string) {
	t.Helper()

	// replace SQL quote, convert into postgresql like ""
	expected = replaceQuoteInSQL(expected)

        // Test special characters
        String specialText = "テスト@#$%^&*()";
        String specialId = SuggestUtil.createSuggestTextId(specialText);
        assertNotNull(specialId);
        assertEquals(Base64.getEncoder().encodeToString(specialText.getBytes(CoreLibConstants.CHARSET_UTF_8)), specialId);
    }

    @Test

		ilmMG,
		scannerMG,
		auditMG,
		loggerWebhookMG,
	}

	// Bucket metrics are special, they always include the bucket label. These
	// metrics required a list of buckets to be passed to the loader, and the list
	// of buckets is not known until the request is made. So we keep a separate
	// map for bucket metrics and handle them specially.

	// Add the serverName and poolIndex labels to all non-cluster metrics.
	//

		return
	case 1:
		target = &a[0]
	case 2:
		// Special 2-operand jumps.
		if p.arch.Family == sys.ARM64 && arch.IsARM64ADR(op) {
			// ADR label, R. Label is in From.
			target = &a[0]
			prog.To = a[1]
			targetAddr = &prog.From
		} else {
			target = &a[1]
			prog.From = a[0]
		}
	case 3:
		if p.arch.Family == sys.PPC64 {
			// Special 3-operand jumps.

    client = TestClient(mod.app)
    return client


def test_post_all(client: TestClient):
    data = {
        "name": "Special Offer",
        "description": "This is a special offer",
        "price": 38.6,
        "items": [
            {
                "name": "Foo",
                "description": "A very nice Item",
                "price": 35.4,

        String specialPath = "test/file with spaces and $pecial #chars!.txt";
        trans2QueryPathInfo = new Trans2QueryPathInformation(config, specialPath, TEST_INFO_LEVEL);

        byte[] buffer = new byte[512];
        int written = trans2QueryPathInfo.writeParametersWireFormat(buffer, 0);

        // Should handle special characters properly
        assertTrue(written > specialPath.length());

    }

    @Test
    public void test_execute_withSpecialCharactersInConfig() {
        // Configure field and index names with special characters
        expiresFieldName = "expires-field.with@special#chars";
        documentUpdateIndex = "fess.update-index$special%chars";

        // Re-register FessConfig with updated values
        fessConfig = new TestFessConfig() {
            @Override

        assertEquals("abc", permissionHelper.encode("abc"));
        assertEquals("abc", permissionHelper.decode("abc"));

        assertEquals("special@chars", permissionHelper.encode("special@chars"));
        assertEquals("special@chars", permissionHelper.decode("special@chars"));
    }

    @Test
    public void test_toString_withSpecialCharacters() {
        // Test toString with special characters
        String name = "special[]param";
        String[] values = { "[value]", ",comma,", "quote\"test" };
        RequestParameter param = new RequestParameter(name, values);

        String expected = "[special[]param, [[value], ,comma,, quote\"test]]";
        assertEquals(expected, param.toString());
    }

    @Test
    @DisplayName("Test with special characters in paths")
    void testWithSpecialCharacters() {
        // Test path with spaces and special characters
        String specialPath = "/share/folder name/file with spaces & special!@#$%.txt";
        testImplementation.setPath(specialPath);
        assertEquals(specialPath, testImplementation.getPath());

        // Test UNC path with special characters