春天JPA @Query注释，在SQL地理位置错误

我想基于地理位置与本地查询来获取表项，使用MariaDB的10.0.36（与InnoDB引擎）和Spring数据。

这里是我的方法签名：

@Query(value = "SELECT j "
        + "FROM Car j "
        + "WHERE distance(j.localization.point, POINT((?2), (?3))) AS sdistance < 10 "
        + "AND (j.name LIKE %?1% "
        + "OR j.carCategory.name LIKE %?1% "
        + "OR j.description LIKE %?1%) "
        + "ORDER BY sdistance "
        + "LIMIT 25", nativeQuery = true)
List<Car> getNearestCars(String text, double lat, double lon);

这里是我的本地化实体：

@Entity
@Table(name = "localizations")
public class Localization {

    @Id
    @GeneratedValue(strategy = GenerationType.AUTO)
    private long id;
    @OneToOne(fetch = FetchType.LAZY)
    private User assossiatedUser;
    private String zipCode;
    private String state;
    @Column(length=200)
    private String city;
    @Column(length=200)
    private String number;
    @Column(length=200)
    private String neighbourhood;
    @Column(length=16)
    private String publicPlaceType;
    @Column(length=200)
    private String publicPlace;
    @Column(length=200)
    private String complement;
    private double coordX;
    private double coordY;
    @Column(columnDefinition = "POINT")
    private Point point;
    public long getId() {
        return id;
    }
    public void setId(long id) {
        this.id = id;
    }
    public User getAssossiatedUser() {
        return assossiatedUser;
    }
    public void setAssossiatedUser(User assossiatedUser) {
        this.assossiatedUser = assossiatedUser;
    }
    public String getZipCode() {
        return zipCode;
    }
    public void setZipCode(String zipCode) {
        this.zipCode = zipCode;
    }
    public String getState() {
        return state;
    }
    public void setState(String state) {
        this.state = state;
    }
    public String getCity() {
        return city;
    }
    public void setCity(String city) {
        this.city = city;
    }
    public String getComplement() {
        return complement;
    }
    public void setComplement(String complement) {
        this.complement = complement;
    }
    public double getCoordX() {
        return coordX;
    }
    public void setCoordX(double coordX) {
        this.coordX = coordX;
    }
    public double getCoordY() {
        return coordY;
    }
    public void setCoordY(double coordY) {
        this.coordY = coordY;
    }
    public String getNeighbourhood() {
        return neighbourhood;
    }
    public void setNeighbourhood(String neighbourhood) {
        this.neighbourhood = neighbourhood;
    }
    public String getPublicPlaceType() {
        return publicPlaceType;
    }
    public void setPublicPlaceType(String publicPlaceType) {
        this.publicPlaceType = publicPlaceType;
    }
    public String getNumber() {
        return number;
    }
    public void setNumber(String number) {
        this.number = number;
    }
    public String getPublicPlace() {
        return publicPlace;
    }
    public void setPublicPlace(String publicPlace) {
        this.publicPlace = publicPlace;
    }
    public Point getPoint() {
        return point;
    }
    public void setPoint(Point point) {
        this.point = point;
    }
}

我创建具有以下（发现在指令的功能距离https://www.scribd.com/presentation/2569355/Geo-Distance-Search-with-MySQL）：

DELIMITER $$

CREATE FUNCTION `distance`(a POINT, b POINT) RETURNS double DETERMINISTIC
BEGIN
    DECLARE d double;
    SET d = round(glength(linestringfromwkb(linestring(asbinary(a),asbinary(b)))));
    RETURN d;
END $$

DELIMITER ;

这里是application.yml：

server.port: 8080
server.context-path: /api
enter code here

spring:
  datasource:
    url: jdbc:mariadb://localhost:3306/databasename
    driverClassName: org.mariadb.jdbc.Driver
    username: root
    password: root
  jpa:
    hibernate:
      ddl-auto: create
      dialect: org.hibernate.dialect.MySQL5InnoDBDialect
      hbm2ddl.auto: update
      show_sql: false

logging:
   level: 
      org.springframework: ERROR

当我访问方法getNearestJobs，我得到的错误如下：

org.mariadb.jdbc.internal.util.dao.QueryException：您的SQL语法错误; 查手册对应于您MariaDB的服务器版本正确的语法使用近“AS sdistance <10 AND（j.name LIKE‘％eteste10％’或j.jobCategory.name LIKE‘％ETE’位于第1行的查询是： SELECTĴFROM工作j，其中距离（j.localization.point，要点（（？），（？）））AS sdistance <10 AND（j.name LIKE 2 OR j.jobCategory.name LIKE 2 OR j.description LIKE？ ）ORDER BY sdistance LIMIT 25，参数[-5​​.1797161，-40.6646966， '％eteste10％'， '％eteste10％'， '％eteste10％']

我究竟做错了什么？