"Can not open a Resultset" msg on SELECT ... INTO

[expired user #1113]'s profile image [expired user #1113] posted 17 years ago in General Permalink
When issuing a SQL like:
SELECT ... INTO OUTFILE ...

I get an error message with

Can not open a Resultset



The SQL is properly executed and the required data is written to the
specified file as it should be, so this is just a minor annoyance.

I guess the program expects for a SELECT statement to have a result set and this one does not have one.
ansgar's profile image ansgar posted 17 years ago Permalink
HS assumes that there will be a resultset if your query starts with "SELECT". The problem is in general that our database-layer needs to know if there will be a result BEFORE it executes a query.

Please login to leave a reply, or register at first.