Bug #9963

Quoting problem with COUNT(*)

Details

Submitted	2007-01-29 10:14 UTC
From	lukas dot ruetz at gmx dot at
Assigned	quipo
Status	Closed
Package	MDB_QueryTool
PHP Version	5.2.0
OS	SuSE Linux (2.6.18)
Roadmaps	(Not assigned)

Comments

[2007-01-29 10:14 UTC] lukas dot ruetz at gmx dot at

Description:
------------
The new version 1.2.0 quotes a COUNT(*) like
SELECT "COUNT(*") FROM ..

Test script:
---------------
$qt->setSelect( 'COUNT(*)' );
$qt->getAll();

Actual result:
--------------
MDB_QueryTool::_doQuery: [Error message: Could not execute statement] [Last executed query: SELECT "COUNT(*") FROM mytable ] [Native message: FEHLER: Error »Syntaxerror« at »)« char 17] (2262)