Storm

Raw 'SELECT 1' causes problems with Oracle

Bug #389135 reported by Jason Baker on 2009-06-18

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	Storm	New	Undecided	Unassigned

Bug Description

In /tests/store/base.py, there are several tests that execute a raw SELECT 1 against the backend it's testing. Unfortunately, this isn't a valid Oracle query (it should be SELECT 1 FROM DUAL). I've put together a patch that will create a DUMMY_SELECT attribute on the StoreTest class that is set to SELECT 1. This way, the child class may override it.

Tags:

Revision history for this message

Jason Baker (jbaker) wrote on 2009-06-18:

A patch to create a DUMMY_SELECT attribute. Edit (1.8 KiB, text/plain)

Revision history for this message

James Henstridge (jamesh) wrote on 2009-08-19:

Given that store.execute() will hit the compile() infrastructure, perhaps it would be better to adjust the tests to pass Select(1) in these cases, and adjust the Oracle compile code to add "FROM DUAL" to Select expressions with no tables?