[rt-devel] A bit of oracle clue?

[Jesse]

On Wed, Mar 21, 2001 at 04:44:37PM -0700, Robert Tarrall wrote:
> Jesse wrote:
> ->         So I've run into a minor issue with oracle. The following
> -> chunk of SQL is valid on mysql and postgres, but not on oracle.
> -> The oracle docs I have seem to claim that it's kosher.  Anyone have a helpfu
> -> suggestion for how to make oracle happy with this:
> -> 
> -> SELECT DISTINCT * from Tablename;
> 
> Works fine in Oracle 8i's sqlplus, and with Oraperl.  Maybe the error
> isn't in your syntax, but elsewhere?

Hrm. I've got an 8i (8.1.7) database running. 

with a default RT installation, using sqlplus, 'select * from Users;'
gets me a nice set of returned values.  

'select distinct * from Users;' gets me:

  select distinct * from Users
                  *
  ERROR at line 1:
  ORA-00932: inconsistent datatypes


Does that shed any light on it?

> 
>                        -Robert Tarrall.-
>                        Unix System/Network Admin
>                        E.Central/Neighborhood Link
> 

-- 
jesse reed vincent -- root at eruditorum.org -- jesse at fsck.com 
70EBAC90: 2A07 FC22 7DB4 42C1 9D71 0108 41A3 3FB3 70EB AC90

After all, it's not every day you meet up with an evil power
                                               -M. Bulgakov