Error when using keyword queries which reference properties on a base class

[nanafan93]

Error when using keyword queries which reference properties on a base class

[nanafan93]

After some more experimentation, this query works as well

fun existsByXAndIsReversedFalse(x: X): Boolean.

So, If I pass in a full object reference (X) instead of a nested property like id (X.Id) then it works.

[mp911de]

Care to attach a minimal reproducer so that we can diagnose the issue quicker and more precise?

[nanafan93]

TLDR: I will close this issue as its behaving as expected. Sorry, I should have done this to begin with 😞
Here is how I tried to reproduce it.

package com.example.demo

import jakarta.persistence.*
import org.springframework.boot.CommandLineRunner
import org.springframework.boot.autoconfigure.SpringBootApplication
import org.springframework.boot.runApplication
import org.springframework.context.annotation.Bean
import org.springframework.data.jpa.repository.JpaRepository


@SpringBootApplication
class DemoApplication {
	@Bean
	fun runner(repository: EmployeeRepo): CommandLineRunner {
		return CommandLineRunner { args: Array<String?>? ->
			 repository.existsByDepartmentIdAndIsHandsomeFalse(25)
			println("I was expecting the above to crash but its fine")
		}
	}
}

fun main(args: Array<String>) {
	runApplication<DemoApplication>(*args)
}

interface SomeInterface {
	val id: Int
}


@Entity
@Table(name = "person")
@Inheritance(strategy = InheritanceType.JOINED)
open class Person: SomeInterface {
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	@Id
	override var id = 0

	@Column(name = "handsome")
	var isHandsome = false
}

@Entity
@Table(name = "employee")
open class Employee : Person() {

	@ManyToOne(fetch = FetchType.LAZY)
	var department: Department? = null
}

@Entity
open class Department {
	@Id
	@GeneratedValue(strategy = GenerationType.AUTO)
	var id: Long? = null
	var name: String? = null

	@OneToMany(fetch = FetchType.LAZY, mappedBy = "department")
	var employees: MutableList<Employee> = mutableListOf()

}



interface EmployeeRepo : JpaRepository<Employee?, Long?> {
	fun existsByDepartmentIdAndIsHandsomeFalse(departmentId: Long?): Boolean
}

This generates the following SQL

Hibernate: select e1_0.id from employee e1_0 join person e1_1 on e1_0.id=e1_1.id where e1_0.department_id=? and not(e1_1.handsome) fetch first ? rows only

This is working as expected but it does not work in my project with the same setup. Does the repository ultimately depend on the JDBC driver to generate the SQL ? We are using an extremely outdated version of mysql. The SQL I get in my project is the follow. It is missing the join to the "base" table and also crashes with a JDBC exception.

select n1_0.id from employee n1_0 where n1_0.department_id=? and not(n1_1.handsome) limit ?