Différences

Ci-dessous, les différences entre deux révisions de la page.

--- informatique:wordpress:wp_mysql_inner_join [29/09/2020 17:19] – cyrille
+++ informatique:wordpress:wp_mysql_inner_join [07/09/2021 20:52] (Version actuelle) – [Le bug dans le core WP] cyrille
@@ Ligne 298: / Ligne 298: @@
   ),
 )
+</code>
+===== Le bug dans le core WP =====
+''class-wp-meta-query.php'' ligne 557.
+<code php>
+// JOIN clauses for NOT EXISTS have their own syntax.
+if ( 'NOT EXISTS' === $meta_compare ) {
+	$join .= " LEFT JOIN $this->meta_table";
+	$join .= $i ? " AS $alias" : '';
+	if ( 'LIKE' === $meta_compare_key ) {
+		$join .= $wpdb->prepare( " ON ($this->primary_table.$this->primary_id_column = $alias.$this->meta_id_column AND $alias.meta_key LIKE %s )", '%' . $wpdb->esc_like( $clause['key'] ) . '%' );
+	} else {
+		$join .= $wpdb->prepare( " ON ($this->primary_table.$this->primary_id_column = $alias.$this->meta_id_column AND $alias.meta_key = %s )", $clause['key'] );
+	}
+// All other JOIN clauses.
+} else {
+ $join .= " INNER JOIN $this->meta_table";
+ $join .= $i ? " AS $alias" : '';
+ $join .= " ON ( $this->primary_table.$this->primary_id_column = $alias.$this->meta_id_column )";
+ // Ce qu'il faudrait à la place :
+ //$join .= $wpdb->prepare(
+ //    " ON ($this->primary_table.$this->primary_id_column = $alias.$this->meta_id_column
+ //      AND $alias.meta_key = %s )", $clause['key'] );
+}
 </code>