在内存数据库中使用数组的JUnit不能在SQL中使用“h2”函数。

<dependency>
    <groupId>com.h2database</groupId>
    <artifactId>h2</artifactId>
    <version>1.4.200</version>
    <scope>test</scope>
</dependency>

import org.junit.jupiter.api.BeforeEach;
import org.junit.jupiter.api.Test;

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

public class H2Test {

    private Connection connection;
    private Statement statement;

    @BeforeEach
    public void setUp() throws SQLException {
        // 启动 H2 内存数据库
        connection = DriverManager.getConnection("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1");
        statement = connection.createStatement();

        // 创建测试表
        statement.execute("CREATE TABLE test (id INT PRIMARY KEY, name VARCHAR(255))");
    }

    @Test
    public void testH2Function() throws SQLException {
        // 插入测试数据
        statement.execute("INSERT INTO test (id, name) VALUES (1, 'John Doe')");

        // 使用 H2 函数查询数据
        var resultSet = statement.executeQuery("SELECT * FROM test WHERE id = 1");

        // 验证查询结果
        if (resultSet.next()) {
            System.out.println("Name: " + resultSet.getString("name"));
        } else {
            System.out.println("No data found");
        }
    }
}