[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
InstantDB: distinct with * operator
- To: "instantDB" <instantDB@enhydra.org>
- Subject: InstantDB: distinct with * operator
- From: "Arno Schatz" <arno@lutris.com>
- Date: Mon, 22 May 2000 20:49:52 -0700
- Importance: Normal
- Reply-To: instantDB@Enhydra.ORG
- Sender: owner-instantDB@Enhydra.ORG
Hi, when I run the following query, it returns duplicate tuples from my db, the 'DISTINCT' is ignored. When I replace the 'Ev.*' and spell out all column names, it works correctly. Is this a bug? "SELECT DISTINCT Ev.* FROM Ev,calevent WHERE calevent.calid="+calid I am using instantDB 3.13 with Enhydra 3.0.1 on NT. Arno -- Arno Schatz Lutris Technologies, Inc. phone 831.460.7367 cell phone 831.234.6786 http://www.lutris.com Sponsor of http://www.enhydra.org ----------------------------------------------------------------------------- To unsubscribe from this mailing list, send email to majordomo@enhydra.org with the text "unsubscribe instantdb" in the body of the email. If you have other questions regarding this mailing list, send email to the list admin at owner-instantdb@enhydra.org. |
- Prev by Date: InstantDB: length of SQL statement?
- Next by Date: InstantDB: About prepared statements
- Prev by thread: RE: InstantDB: length of SQL statement?
- Next by thread: InstantDB: About prepared statements
- Index(es):
