[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
InstantDB: SELECT DISTINCT and NULL
- To: "instantDB" <instantDB@enhydra.org>, <lennart.esklund@zenon.se>
- Subject: InstantDB: SELECT DISTINCT and NULL
- From: "Peter Hearty" <peter.hearty@lutris.com>
- Date: Wed, 19 Jul 2000 07:31:10 +0100
- Reply-To: instantDB@Enhydra.ORG
- Sender: owner-instantDB@Enhydra.ORG
Lennart I'm afraid this looks like a bug. It'll probably be a couple of weeks before there's a fix available for this. Regards Peter Hearty Lutris Technologies UK Ltd. > Hello, > > the SQL statement > > SELECT DISTINCT colname FROM table WHERE colname IS NULL > > gives a result set with one row for each row in table where colname IS NULL. > > Is there any work-around? It is a show-stopper for using InstantDB in a > product we are developing. > > Regards > > Lennart Esklund > Zenon AB > Sollentuna, Sweden ----------------------------------------------------------------------------- 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: Re: InstantDB: Error message "Column null not found"
- Next by Date: Re: InstantDB: Error message "Column null not found"
- Prev by thread: Re: InstantDB: Error message "Column null not found"
- Next by thread: Re: InstantDB: SELECT DISTINCT and NULL
- Index(es):
