Georg, You read my email wrong. All I wanted to know was that this is a problem for Oracle because it doesn't understand the SQL 92 keywords true and false, and I needed to know what to do about it.
I simply can't handle reading 3 pages of text to tell me that we need a 0/1 mapping. I was in San Franscisco all of last week and spent yesterday reading over 1000 emails and postings, so cut me a little slack. Now that there is a but report, this is on my todo list, and I'll get to it when I can. If you want to write a patch, I will be more then happy to apply it. -dain Georg Schmid wrote: > Dain, > > this is a quite obvious bug (if you ever tried to select on a boolean EB > field backed by > an Oracle table), so why are you so cool about it?? > > I have a EB with a mostRecent boolean field, and because of this bug > there is no way > to make a custom finder like > > select object(myEB) > from MyEBTable > where myEB.mostRecent = true > > work. > > Please don't get into the habit of thinking your users are idiots... > > --- five lines of additional rant suppressed -- > > Georg > > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] On Behalf Of Dain > Sundstrom > Sent: Tuesday, May 14, 2002 07:35 > To: Stephen Coy > Cc: jboss-user > Subject: Re: [JBoss-user] Fwd: Bug when converting EJB QL boolean > comparisons from true and false to 1 and 0 > > > Cool, can you post a bug report, so I don't forget to make the change? > > Thanks, > > -dain > > Stephen Coy wrote: > > >>Sorry Dain, >> >>I was trying to point out that not all SQL implementations support the >>use of literal "true" and "false" values. >> >>Therefore, we need to get them mapped to "1" and "0" respectively in >>this situation. >> >>On Tuesday, May 14, 2002, at 02:53 PM, Dain Sundstrom wrote: >> >> >>>This is like pulling teeth. Just tell me what you want and why, short >>>and sweet. Think 72 words. >>> >>>I should true map to 1 and false to 0 in Oracle, SQLServer and MySQL? >>>I add some more metadata for this. >>> >>> >>The short answer is yes. >> >> >>_______________________________________________________________ >> >>Have big pipes? SourceForge.net is looking for download mirrors. We >>supply the hardware. You get the recognition. Email Us: >>[EMAIL PROTECTED] >>_______________________________________________ >>JBoss-user mailing list >>[EMAIL PROTECTED] >>https://lists.sourceforge.net/lists/listinfo/jboss-user >> > > -- xxxxxxxxxxxxxxxxxxxxxxxxx Dain Sundstrom Chief Architect, JBossCMP JBoss Group, LLC xxxxxxxxxxxxxxxxxxxxxxxxx _______________________________________________________________ Have big pipes? SourceForge.net is looking for download mirrors. We supply the hardware. You get the recognition. Email Us: [EMAIL PROTECTED] _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
