test special pages SQL queries against supported Proprietary DBs (Oracle, MSSQL)
Closed, DeclinedPublic
Actions

Assigned To

None

Authored By

	MarkAHershberger
	Dec 21 2011, 3:18 AM

Project Tags

Referenced Files

None

Subscribers

Description

Split off from Bug #32118

Per Brion comment on bug 31913:
We should be having unit tests running all the query page queries to make sure
they work.

As an example: Microsoft SQL does not support column alias in GROUP BY clause
(bug 31913).

Version: unspecified
Severity: normal

• bzimport raised the priority of this task from to Medium.Nov 22 2014, 12:03 AM

• bzimport set Reference to bz33290.

• bzimport added a subscriber: Unknown Object (MLST).

Just saw this note from Tim in wikitech-l:

Definitely thanks for adding it in, and I hope we can get DB2 added to our
unit test suites at some point!

You can get the "Express-C" version for free.

db2 support was dropped with gerrit 50764

freak wrote:

Just tested with Oracle (11gR2), works nice.

Mssql support being dropped in gerrit change 95651.

(In reply to comment #4)

Mssql support being dropped in Gerrit change #95651.

Reverted. People still use this database. Please discuss changes before self-approve things like this.

Closing old/generic task. Please report specific problems about a specific query page not working on a specific DB backend.