[Upstream] [hardy] CASE expressions are not supported

Bug #178867 reported by Christopher Yeleighton
2
Affects Status Importance Assigned to Milestone
OpenOffice
New
Unknown
openoffice.org (Ubuntu)
Won't Fix
Low
Unassigned

Bug Description

Binary package hint: openoffice.org

The following expression is considered invalid:
CASE 0 WHEN 0 THEN 0 END
A query containing CASE expressions can be executed in direct SQL mode only.

Revision history for this message
Chris Cheney (ccheney) wrote :

In what application and where in the application did you try to use the CASE expression?

Thanks,

Chris Cheney

Changed in openoffice.org:
assignee: nobody → ccheney
status: New → Incomplete
Revision history for this message
Christopher Yeleighton (giecrilj) wrote :

I was trying to design a database query; the database in question is connected via ODBC. I have to use direct SQL whenever I need CASE.

Chris Cheney (ccheney)
Changed in openoffice.org:
assignee: ccheney → nobody
status: Incomplete → New
Chris Cheney (ccheney)
Changed in openoffice.org:
importance: Undecided → Low
status: New → Confirmed
Changed in openoffice:
status: Unknown → New
Chris Cheney (ccheney)
Changed in openoffice.org:
status: Confirmed → Triaged
Chris Cheney (ccheney)
tags: added: hardy
Changed in openoffice.org (Ubuntu):
status: Triaged → Won't Fix
Revision history for this message
Björn Michaelsen (bjoern-michaelsen) wrote : migrating packaging from OpenOffice.org to Libreoffice

[This is an automated message.]
There are no new official OpenOffice.org releases in Ubuntu packaging anymore => Won't Fix

If the problem persists, please mark this bug as "also affects project Libreoffice" or "also affects distribution Libreoffice (Ubuntu)" if that has not happened already.

Please leave references to upstream OpenOffice.org bugs in place to allow cross pollination.

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.