Re[2]: I can't understand

2001-03-12 Thread Rimantas Liubertas
Hello P.Peti, Monday, March 12, 2001, 11:17:16 PM, you wrote: PP> It just seems to be weird that a subset and its complement PP> does not equal the whole table. So the thing is: PP> #"!deleted" doesn't include "#NULL" as the set filtered by PP> the clause 'WHERE comment!="deleted"' doesn't i

Re: problems with tutorial

2001-03-08 Thread Rimantas Liubertas
Hello David, Thursday, March 08, 2001, 11:44:21 PM, you wrote: DP> folks, DP> I need help. I installed mysql on NT, everthing seems fine. I wanted to insert fields into a table, as described in the tutorial from a file. It said the default that delimits a field is a tab, DP> so I added fields

buggy support for cp1257

2001-03-08 Thread Rimantas Liubertas
Hello mysql, (Note: this post contains characters in windows-1257 encoding, they may appear incorectly in your e-mail clients). I believed everything is OK with MySQL support for cp1257 charset until I actually tried to sort records alphabeticly. What I find out was: 1. Typo in cp1257.conf sor

Re: UNIQUE with NULL columns

2001-03-07 Thread Rimantas Liubertas
Hello john, Thursday, March 08, 2001, 12:19:22 AM, you wrote: jrd> with MySQL 3.23.33 on Linux, shouldn't UNIQUE columns that contain NULL jrd> values still reject rows that are the same? this isn't working (it allows jrd> duplicate rows to be included if one of the columns is NULL). this seem