Ticket #42907: scratch_69.php

<?php

class test_meta_key_not_exists_query extends WP_UnitTestCase {

        function test_post() {
                $post_ids = $this->factory()->post->create_many( 7 );

                // Give first post nothing.

                // Give second post 1.
                add_post_meta( $post_ids[1], 'test', 1 );

                // Give third post 0.
                add_post_meta( $post_ids[2], 'test', 0 );

                // Give fourth post 200.
                add_post_meta( $post_ids[3], 'test', 200 );

                // Give fifth post 30.
                add_post_meta( $post_ids[4], 'test', 30 );

                // Give sixth post -5.
                add_post_meta( $post_ids[5], 'test', -5 );

                // Give the seventh post nothing.

                $query = new WP_Query(
                        array(
                                'fields' => 'ids',
                                'orderby' => array( 'meta_value_num' => 'DESC', 'date' => 'DESC', 'ID' => 'ASC' ),
                                'meta_query' => array(
                                        array(
                                                'key' => 'test',
                                                'default' => 0,
                                                'compare' => 'NONE',
                                        ),
                                ),
                        )
                );

                $this->assertSame(
                        array(
                                $post_ids[3], // 200
                                $post_ids[4], // 30
                                $post_ids[1], // 1
                                $post_ids[0], // empty
                                $post_ids[2], // 0
                                $post_ids[6], // empty
                                $post_ids[5], // -5
                        )
                        , $query->get_posts()
                );
        }

        function test_post_2() {
                $post_ids = $this->factory()->post->create_many( 7 );

                // Give first post nothing.
                add_post_meta( $post_ids[0], 'other', 'a' );

                // Give second post 1.
                add_post_meta( $post_ids[1], 'test', 1 );
                add_post_meta( $post_ids[1], 'other', 'b' );

                // Give third post 0.
                add_post_meta( $post_ids[2], 'test', 0 );
                add_post_meta( $post_ids[2], 'other', 'a' );

                // Give fourth post 200.
                add_post_meta( $post_ids[3], 'test', 200 );
                add_post_meta( $post_ids[3], 'other', 'a' );

                // Give fifth post 30.
                add_post_meta( $post_ids[4], 'test', 30 );

                // Give sixth post -5.
                add_post_meta( $post_ids[5], 'test', -5 );
                add_post_meta( $post_ids[5], 'other', 'a' );

                // Give the seventh post nothing.

                $query = new WP_Query(
                        array(
                                'fields' => 'ids',
                                'orderby' => array( 'meta_value_num' => 'DESC', 'date' => 'DESC' ),
                                'meta_query' => array(
                                        array(
                                                'key' => 'test',
                                                'default' => 0,
                                                'compare' => 'NONE',
                                        ),
                                        array(
                                                'key' => 'other',
                                                'value' => 'a',
                                        ),
                                ),
                        )
                );

                $this->assertSame(
                        array(
                                $post_ids[3], // 200
//                              $post_ids[4], // 30 (empty)
//                              $post_ids[1], // 1 (b)
                                $post_ids[0], // empty
                                $post_ids[2], // 0
//                              $post_ids[6], // empty (empty)
                                $post_ids[5], // -5
                        )
                        , $query->get_posts()
                );
        }
}