• Alexander Barkov's avatar
    MDEV-34025 Virtual columns do not check assignment cast validity · f151c5f3
    Alexander Barkov authored
    It was possible to create virtual columns with incompatible
    GENERATED ALWAYS expression data types:
    
      CREATE TABLE t1 (a INT, b POINT GENERATED ALWAYS AS (a));
      CREATE TABLE t1 (a POINT, b INT GENERATED ALWAYS AS (a));
    
    These data type combinations are not allowed in other cases,
    e.g. INSERT, UPDATE, SP variable assignment.
    
    Fix:
    
    Disallowing bad combinations of the column data type and its
    GENERATED ALWAYS expression data type.
    f151c5f3
gis.test 112 KB