• unknown's avatar
    Fixed bug #19714. · 1e442594
    unknown authored
    DESCRIBE returned the type BIGINT for a column of a view if the column
    was specified by an expression over values of the type INT.
        
    E.g. for the view defined as follows:
      CREATE VIEW v1 SELECT COALESCE(f1,f2) FROM t1
    DESCRIBE returned type BIGINT for the only column of the view if f1,f2 are
    columns of the INT type.
    At the same time DESCRIBE returned type INT for the only column of the table
    defined by the statement:
      CREATE TABLE t2 SELECT COALESCE(f1,f2) FROM t1.
        
    This inconsistency was removed by the patch.
    
    Now the code chooses between INT/BIGINT depending on the
    precision of the aggregated column type.
     
    Thus both DESCRIBE commands above returns type INT for v1 and t2.
     
    
    
    mysql-test/r/analyse.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/bigint.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/create.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/olap.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/ps_2myisam.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/ps_3innodb.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/ps_4heap.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/ps_5merge.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/ps_6bdb.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/ps_7ndb.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/sp.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/subselect.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/type_ranges.result:
      Adjusted the results after having fixed bug #19714.
    mysql-test/r/view.result:
      Added a test case for bug #19714.
    mysql-test/t/view.test:
      Added a test case for bug #19714.
    1e442594
ps_5merge.result 201 KB