Problem with Slick generating sql for count with hsqldb

gistfile1.scala

// sample query using count
val c =
  for {
    d <- Databases if (d.name like s"$name%") && (d.hasDistinctCount === true)
  } yield t.count
println(c.selectStatement)

// generates this sql for h2
select select count(1) from "Databases" x2 where (x2."name" like 'world%') and (x2."hasDistinctCount" = true)

// generates this incorrect statement for hsqldb
select select count(1) from (VALUES (0)) from "Databases" x2 where (x2."name" like cast('world%' as varchar(16777216))) and (x2."hasDistinctCount" = true)

If I change the query to

val c =
  (for {
    t <- Databases if (t.name like s"$name%") && (t.hasDistinctCount === true)
  } yield t.name.count)

then I get following statement

select count(x2."name") from "Databases" x2 where (x2."name" like cast('world%' as varchar(16777216))) and (x2."hasDistinctCount" = true)

which is syntactically correct. But the "like" query doesn't work properly. If there r 2 records with name = "world1" and "world2", the select returns a count of 1.