https://bugzilla.wikimedia.org/show_bug.cgi?id=19351

       Web browser: ---
           Summary: DB2 v8 does not support multi-line SQL comment syntax
           Product: MediaWiki
           Version: 1.15.0
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: enhancement
          Priority: Normal
         Component: Database
        AssignedTo: [email protected]
        ReportedBy: [email protected]


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}


-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to