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
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.
Michael MacIntyre
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
