Re^2: fetchall_arrayref hangs with placeholders query with no results

[afoken]

Maybe having no table confuses the system?

It should not. Executing a table-less query like

SELECT 42 AS result

works on most SQL databases. The remaining ones, Oracle being probably the most known example, always expects a dummy table or view, but also always provides that dummy table or view specifically for this purpose. Its name is DUAL on Oracle, and you need to use

SELECT 42 AS result FROM dual

on Oracle. Some databases also provide a table or view named DUAL just for Oracle compatibility.

See Wikipedia: DUAL table for a nice overview.

Alexander

[erix]

I know.

PostgreSQL, for instance, knows how to since time immemorial (and certainly all maintained versions).

SQL Server too (I checked all the same on sqlfiddle).

In fact, I was writing a post to Marshall containing pretty much everything that you said...

Anyhow, it seems the OP has lost interest, or maybe solved his problem.

[TieUpYourCamel]

Still interested, just busy. My problem isn't solved, but I have an okay workaround for now: I'm not using placeholders in any of my queries. The other things that cause the hang (specifying a TDS level and a query that produces no results) aren't really an option to not do. Connecting with no TDS level doesn't work on my production machine.