Michael MacIntyre wrote: > > Hello. > I do apologize if this (or like it) has been brought up before (or is > explained in the documentation and I was simply unable to grasp it) - I > found nothing on the list. > - I have a table (duh!) and I added a field (called deleted) of type > boolean. > - I set no default value. > - I ran an update statement (update <table> set deleted=false) > - I ran an update statement to change one row to TRUE (update <table> > set deleted=TRUE where <PK>=<some_id> > - then I ran the following queries: > 1) select * from <the_table> where not deleted > Results: 0 rows returned > I expected the row I set to true.... > > 2) select * from <the_table> where deleted=false > Results: total rows -1 (What I expected) > > 3) select * from <the_table> where deleted > Results: the row I marked DELETED=>TRUE + 25 other rows designated > as DELETED=>FALSE > > 4) select * from <the_table> where deleted=true > Results: 1 row - the one marked DELETED=true > > I am using ver. 7.4.3.32 (the last release of 7.4) Win XP SP2 AMD Athlon > 2100+ 512M RAM >
Thank you for reporting. There is a bug if a boolean column added with ALTER TABLE ADD or being the last key column is handled with a qualification <columnname> or a qualifiaction NOT <columnname>. If you specify <columnname> = FALSE resp. TRUE then everything is fine. > It's obvious (based on these examples) that I must use > <boolean_field>=<boolean_value>, I would like to know why. > Thank you in advance - BTW, no disrespect to MySql, but is there any > chance SAP will re-takeover SAPDB (hosting the site)? I found - find, > I still use it - even though I know it'll be decommissioned one day... > :-( the sapdb.org site easier to navigate, use etc - no hype, just the > stuff you need - and searching the archives seemed to be faster. There are no plans to do so, but who knows what will happen one day in let's say five or ten years.... Elke SAP Labs Berlin > Michael MacIntyre > > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
