Hi all, I have a strange problem and I can't really understand what's going on!
mysql> SELECT n.nid, n.sticky, n.created FROM node n WHERE n.type='image' AND (n.uid = 1 OR n.status = 1) ORDER BY n.created desc; Empty set (0.00 sec) mysql> SELECT n.nid, n.sticky, n.created FROM node n WHERE n.type='image' AND (n.uid = 1 OR n.status = 1); +-----+--------+------------+ | nid | sticky | created | +-----+--------+------------+ | 73 | 0 | 1141048224 | | 75 | 0 | 1141736038 | ............................. | 93 | 0 | 1145039899 | | 97 | 0 | 1145189131 | +-----+--------+------------+ 51 rows in set (0.00 sec) I'm using a standar drupal installation: mysql> desc node; +----------+------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------+------------------+------+-----+---------+----------------+ | nid | int(10) unsigned | | PRI | NULL | auto_increment | | type | varchar(32) | | MUL | | | | title | varchar(128) | | MUL | | | | uid | int(10) | | MUL | 0 | | | status | int(4) | | MUL | 1 | | | created | int(11) | | MUL | 0 | | | changed | int(11) | | MUL | 0 | | | comment | int(2) | | | 0 | | | promote | int(2) | | MUL | 0 | | | moderate | int(2) | | MUL | 0 | | | sticky | int(2) | | | 0 | | | vid | int(10) unsigned | | | 0 | | +----------+------------------+------+-----+---------+----------------+ 12 rows in set (0.00 sec) | version | 4.1.12 CentOS release 4.2 (Final) Any idea ? Am I doing something wrong ? Did I hit a bug ? Many thanks, -- GNU/Linux registered user #224950 Proud Egyptian GNU/Linux User Group <www.eglug.org> Member. Life powered by Debian, Homepage: www.foolab.org -- Don't send me any attachment in Micro$oft (.DOC, .PPT) format please Read http://www.gnu.org/philosophy/no-word-attachments.html Preferable attachments: .PDF, .HTML, .TXT Thanx for adding this text to Your signature -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
