-
The jdbc input (via the mixin) will, under some circumstances, attempt to count the number of rows the query will return
-
My reading of the documentation for the sequel library that the input is based on is that it implements .count by doing a SELECT count(...) ... LIMIT 1
-
Firebird does not support LIMIT 1, it uses FIRST 1 instead
-
The jdbc mixin should be detecting that .count does not work and stop using it, so you should get this error once but everything works as expected
-
I would expect you to be seeing these two warnings
"Attempting a count query raised an error, the generated count statement is most likely incorrect but check networking, authentication or your statement syntax"
"Ongoing count statement generation is being prevented"