• Sergei Golubchik's avatar
    MDEV-15391 Server crashes in JOIN::fix_all_splittings_in_plan or Assertion... · a4251d6f
    Sergei Golubchik authored
    MDEV-15391 Server crashes in JOIN::fix_all_splittings_in_plan or Assertion `join->best_read < double(1.79...e+308L)' failed
    
    vers_setup_conds() used to AND all conditions on row_start/row_end
    columns and store it either in the WHERE clause or in the ON
    clause for some table. In some cases this caused ON clause
    to have conditions for tables that aren't part of that ON's join.
    
    Fixed to put a table's condition always in the ON clause of the
    corresponding table.
    
    Removed unnecessary ... `OR row_end IS NULL` clause, it's not needed
    in the ON clause.
    
    Simplified handling on PS and SP.
    a4251d6f
sql_lex.h 128 KB