Jean T. Anderson wrote:
Ken Johanson wrote:
This syntax:
select 1
Seems to always throw a:
SQLException: Syntax error: Encountered "<EOF>" at line 1, column 8.
Is this table-less syntax going to be supported at some point, and what
would be the next best means to do table-less select (such as for
testing scalars, etc)
Of course this exmaple is also common for database connection pings, in
systems where the connection may timeout or FIFO.. but is there a better
(and equally efficient) approach to pinging?
I also tried `select values (1)`.
Does this do what you need?
ij> values 1;
1
-----------
1
1 row selected
yes, thank you!!! I'll use that.
I'd vote for also adding the SELECT syntax, someday; I'd never heard of
or used the VALUES syntax, so I couldn't figure out that it was
literally that simple (I kept prepending SELECT...) I suspect others may
experience the same.
Best,
ken
