wpdb::get_row never uses the cache

[Lacrymology]

wpdb::get_row never uses the cached results, look at this

	function get_row( $query = null, $output = OBJECT, $y = 0 ) {
		$this->func_call = "\$db->get_row(\"$query\",$output,$y)";
		if ( $query )
			$this->query( $query );
		else
			return null;
                // more code

and then

	function query( $query ) {
		if ( ! $this->ready )
			return false;

		// some queries are made before the plugins have been loaded, and thus cannot be filtered with this method
		if ( function_exists( 'apply_filters' ) )
			$query = apply_filters( 'query', $query );

		$return_val = 0;
		$this->flush();

See how the cache never gets called? if you write a query, the old one gets flushed without checking if it was the same as before, if you use null, null gets returned, an if($this->last_query != $query) needs to be put in ::query or the return null removed from ::get_row, I'd prefer the first solution.

[scribu]

The caching is done on top of WPDB, not through it.

Also, what about DML queries? (INSERT, DELETE etc.)

[Lacrymology]

well, then why does wpdb::last_results exist? and why does ::query call mysql_release_results before it returns? there's something either in the API or the implementation that's not coherent

[nacin]

It's only last_result, and it's used when iterating over cells and columns in get_col() and get_var(), among other things.