List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:November 21 2002 3:41am
Subject:Re: mysql query error
View as plain text  
In the last episode (Nov 21), ck nuke said:
> I have a problem about : mysql query
> I need help for this.
> Sever: mysql Version: 4.0.4-bata
>       SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t, 
> cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.dateline DESC LIMIT 
> 0,1
> When use this command, no result
> -------------------------------------------------------------------
>       SELECT p.pid, p.dateline, t.tid, t.replies FROM cdb_threads t, 
> cdb_posts p WHERE p.tid=t.tid AND t.fid='24' ORDER BY p.pid DESC LIMIT 0,1
> When use this command, have one result
> -------------------------------------------------------------------
>       SELECT pid FROM cdb_posts ORDER BY dateline DESC
> When use this command, have results
> -------------------------------------------------------------------
> Don't know where is the mistake???

Upgrade to 4.0.5.  From the changelog:

  * Fixed a newly introduced bug that caused 'ORDER BY ... LIMIT #' to
    not return all rows.

-- 
	Dan Nelson
	dnelson@stripped
Thread
mysql query errorck nuke21 Nov
  • Re: mysql query errorDan Nelson21 Nov
  • extracting submatches from regular expressionsMurad Nayal21 Nov