On Thu, 1 Jul 2004, Ilir Gashi wrote: > I saw this 'bug' reported in the Firebird SourceForge website for the > Firebird 1.0 server. They confirmed it as a bug! I tried it in PostgreSQL > 7.2 (I know its an old release but I do not have a newer version installed, > and in any case I am only using the server for reserach purposes). > PostgreSQL returns no rows for either of the queries. Of course this is the > case since the attributes F1 and F2 of Table T1 are of type Char whereas > the select query is making the test with an integer value. Is this the > intended behaviour?
Technically speaking, I believe the queries are simply invalid without the presence of casts from the spec's standpoint. Theoretically, I'd either expect both to give 0 rows (convert 3 into a string and compare) or both to give 1 row (convert '003' to an integer and compare) if it didn't error. What does Oracle do if you insert a value like 'XXX' into the column? ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
