Last modified: 2013-03-16 23:17:43 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T21351, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 19351 - DB2 v8 does not support multi-line SQL comment syntax
DB2 v8 does not support multi-line SQL comment syntax
Status: RESOLVED INVALID
Product: MediaWiki
Classification: Unclassified
Database (Other open bugs)
1.15.x
All All
: Low enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2009-06-22 16:33 UTC by Jared Pearson
Modified: 2013-03-16 23:17 UTC (History)
1 user (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Jared Pearson 2009-06-22 16:33:03 UTC
When installing MediaWiki 1.15.0 on DB2 v8.0 the error below occurs.  DB2 v8 does not support the "/* */" multi-line SQL comment syntax.  The Database class (includes/db/Database.php) seems to be injecting the comment into the statement during the query() method before execution.

Warning: db2_exec() [function.db2-exec]: Statement Execute Failed in C:\httpd\mediawiki\includes\db\DatabaseIbm_db2.php on line 595


SELECT /*   */ COUNT(*) FROM SYSIBM.SYSTABLES ST
WHERE ST.NAME = 'cur' AND ST.CREATOR = 'mediawiki'

SQL error: [IBM][CLI Driver][DB2/NT] SQL0104N An unexpected token "SELECT /* */ COUNT(*)" was found following "BEGIN-OF-STATEMENT". Expected tokens may include: "<space>". SQLSTATE=42601 SQLCODE=-104

Backtrace:

#0 C:\httpd\mediawiki\includes\db\Database.php(595): DatabaseIbm_db2->doQuery('SELECT /* */ ...')
#1 C:\httpd\mediawiki\includes\db\DatabaseIbm_db2.php(626): Database->query('SELECT COUNT(*)...')
#2 C:\httpd\mediawiki\config\index.php(1039): DatabaseIbm_db2->tableExists('cur')
#3 {main}
Comment 1 db [inactive,noenotif] 2013-03-16 23:17:43 UTC
db2 support dropped with Gerrit change #50764

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links