Issue 18074 - WHERE and HAVING clauses in MySQL SQL
Summary: WHERE and HAVING clauses in MySQL SQL
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC2
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: Frank Schönheit
QA Contact: issues@dba
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-09 15:58 UTC by Unknown
Modified: 2006-05-31 14:29 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Unknown 2003-08-09 15:58:46 UTC 
The sql asumes that a constant in a WHERE or HAVING statement is a colunm name.
eg SELECT * from table WHERE col1 = "N";

"N" is assumed to be a colunm.

SELECT 8 from table; would work.

The  ";" do not seem to be required in OO.
Comment 1 Unknown 2003-08-09 16:16:02 UTC 
The example which would work should be:
SELECT * from table;
the example which does not work inOO will work if submitted directly 
to MySQL providing the table and colunm names are valid.
Comment 2 Frank Schönheit 2003-08-11 08:13:47 UTC 
rabromley, I do not completely get you here.

Do you mean that
  SELECT * from table WHERE col1 = "N"
should work when submitted via OOo?

If so - this will no be the case, and this is no bug. The standard SQL
character for string constants is ', not ". MySQL implements an
extension of the standard by accepting ". OOo will not implement this
extension, because it's MySQL specific, and OOo is expected to work
with more databases than MySQL.

So unless so say that I misunderstood you here, I am going to mark
this here as INVALID.
Comment 3 Frank Schönheit 2003-09-02 11:38:57 UTC 
marking as INVALID due to missing response from the submitter for 3 weeks
Comment 4 Frank Schönheit 2003-09-02 11:40:23 UTC 
closing
Comment 5 hans_werner67 2004-02-02 13:00:49 UTC 
change subcomponent to 'none'