Page 1 of 1

EXPLAIN queries fail

Posted: Fri Feb 22, 2013 11:45 pm
by JakaJancar
I'm connecting to Vertica via ODBC. Normal queries work:

Code: Select all

$db->query("SELECT 1")->fetchAll();
However EXPLAIN queries:

Code: Select all

$db->query("EXPLAIN SELECT 1")->fetchAll();
fail with error:

Code: Select all

PDOException: SQLSTATE[SL009]: <<Unknown error>>: 0 [unixODBC][Driver Manager]No columns were bound prior to calling SQLFetch or SQLFetchScroll (SQLFetchScroll[0] at /usr/src/php5.4/source/php5-5.4.10/ext/pdo_odbc/odbc_stmt.c:537)
Any ideas?