TestExplain.golden

&database.ExplainInfo{
    SQL:           "select ID,name from (select address from customer_list where SID=1 order by phone limit 50,10) a join customer_list l on (a.address=l.address) join city c on (c.city=l.city) order by phone desc;",
    ExplainFormat: 0,
    ExplainRows:   {
        &database.ExplainRow{
            ID:           1,
            SelectType:   "PRIMARY",
            TableName:    "country",
            Partitions:   "NULL",
            AccessType:   "index",
            PossibleKeys: {"PRIMARY"},
            Key:          "PRIMARY",
            KeyLen:       "2",
            Ref:          {""},
            Rows:         109,
            Filtered:     100,
            Scalability:  "O(n)",
            Extra:        "Using index; Using temporary; Using filesort",
        },
        &database.ExplainRow{
            ID:           1,
            SelectType:   "PRIMARY",
            TableName:    "city",
            Partitions:   "NULL",
            AccessType:   "ref",
            PossibleKeys: {"PRIMARY", "idx_fk_country_id"},
            Key:          "idx_fk_country_id",
            KeyLen:       "2",
            Ref:          {"sakila.country.country_id"},
            Rows:         5,
            Filtered:     100,
            Scalability:  "O(log n)",
            Extra:        "NULL",
        },
        &database.ExplainRow{
            ID:           1,
            SelectType:   "PRIMARY",
            TableName:    "c",
            Partitions:   "NULL",
            AccessType:   "ALL",
            PossibleKeys: {""},
            Key:          "NULL",
            KeyLen:       "",
            Ref:          {""},
            Rows:         600,
            Filtered:     10,
            Scalability:  "O(n)",
            Extra:        "Using where; Using join buffer (Block Nested Loop)",
        },
        &database.ExplainRow{
            ID:           1,
            SelectType:   "PRIMARY",
            TableName:    "a",
            Partitions:   "NULL",
            AccessType:   "ref",
            PossibleKeys: {"PRIMARY", "idx_fk_city_id"},
            Key:          "idx_fk_city_id",
            KeyLen:       "2",
            Ref:          {"sakila.city.city_id"},
            Rows:         1,
            Filtered:     100,
            Scalability:  "O(log n)",
            Extra:        "NULL",
        },
        &database.ExplainRow{
            ID:           1,
            SelectType:   "PRIMARY",
            TableName:    "cu",
            Partitions:   "NULL",
            AccessType:   "ref",
            PossibleKeys: {"idx_fk_address_id"},
            Key:          "idx_fk_address_id",
            KeyLen:       "2",
            Ref:          {"sakila.a.address_id"},
            Rows:         1,
            Filtered:     100,
            Scalability:  "O(log n)",
            Extra:        "NULL",
        },
        &database.ExplainRow{
            ID:           1,
            SelectType:   "PRIMARY",
            TableName:    "<derived2>",
            Partitions:   "NULL",
            AccessType:   "ref",
            PossibleKeys: {"<auto_key0>"},
            Key:          "<auto_key0>",
            KeyLen:       "152",
            Ref:          {"sakila.a.address"},
            Rows:         6,
            Filtered:     100,
            Scalability:  "O(log n)",
            Extra:        "Using index",
        },
        &database.ExplainRow{
            ID:           2,
            SelectType:   "DERIVED",
            TableName:    "a",
            Partitions:   "NULL",
            AccessType:   "ALL",
            PossibleKeys: {"PRIMARY", "idx_fk_city_id"},
            Key:          "NULL",
            KeyLen:       "",
            Ref:          {""},
            Rows:         603,
            Filtered:     100,
            Scalability:  "O(n)",
            Extra:        "Using filesort",
        },
        &database.ExplainRow{
            ID:           2,
            SelectType:   "DERIVED",
            TableName:    "cu",
            Partitions:   "NULL",
            AccessType:   "ref",
            PossibleKeys: {"idx_fk_store_id", "idx_fk_address_id"},
            Key:          "idx_fk_address_id",
            KeyLen:       "2",
            Ref:          {"sakila.a.address_id"},
            Rows:         1,
            Filtered:     54.42,
            Scalability:  "O(log n)",
            Extra:        "Using where",
        },
        &database.ExplainRow{
            ID:           2,
            SelectType:   "DERIVED",
            TableName:    "city",
            Partitions:   "NULL",
            AccessType:   "eq_ref",
            PossibleKeys: {"PRIMARY", "idx_fk_country_id"},
            Key:          "PRIMARY",
            KeyLen:       "2",
            Ref:          {"sakila.a.city_id"},
            Rows:         1,
            Filtered:     100,
            Scalability:  "O(log n)",
            Extra:        "NULL",
        },
        &database.ExplainRow{
            ID:           2,
            SelectType:   "DERIVED",
            TableName:    "country",
            Partitions:   "NULL",
            AccessType:   "eq_ref",
            PossibleKeys: {"PRIMARY"},
            Key:          "PRIMARY",
            KeyLen:       "2",
            Ref:          {"sakila.city.country_id"},
            Rows:         1,
            Filtered:     100,
            Scalability:  "O(log n)",
            Extra:        "Using index",
        },
    },
    ExplainJSON: (*database.ExplainJSON)(nil),
    Warnings:    nil,
    QueryCost:   0,
}