• Monty's avatar
    MDEV-12325 Unexpected data type and truncation when using CTE · a5a9fcdf
    Monty authored
    When creating a recursive CTE, the column types are taken from the
    non recursive part of the CTE (this is according to the SQL standard).
    
    This patch adds code to abort the CTE if the calculated values in the
    recursive part does not fit in the fields in the created temporary table.
    
    The new code only affects recursive CTE, so it should not cause any notable
    problems for old applications.
    
    Other things:
    - Fixed that we get correct row numbers for warnings generated with
      WITH RECURSIVE
    
    Reviewer: Alexander Barkov <bar@mariadb.com>
    a5a9fcdf
sql_union.cc 66.2 KB