in core/src/main/scala/org/apache/pekko/persistence/r2dbc/journal/JournalDao.scala [237:255]
def readHighestSequenceNr(persistenceId: String, fromSequenceNr: Long): Future[Long] = {
val result = r2dbcExecutor
.select(s"select highest seqNr [$persistenceId]")(
connection =>
connection
.createStatement(selectHighestSequenceNrSql)
.bind(0, persistenceId)
.bind(1, fromSequenceNr),
row => {
val seqNr = row.get(0, classOf[java.lang.Long])
if (seqNr eq null) 0L else seqNr.longValue
})
.map(r => if (r.isEmpty) 0L else r.head)(ExecutionContexts.parasitic)
if (log.isDebugEnabled)
result.foreach(seqNr => log.debug("Highest sequence nr for persistenceId [{}]: [{}]", persistenceId, seqNr))
result
}