--disable_abort_on_error --disable_warnings drop table if exists t1 ; --enable_warnings # let $engine= innodb; CREATE TABLE t1 (f1 DOUBLE); INSERT INTO t1 SET f1 = -1.7976931348623e+308; # The value above 14 digit mantissa is harmless. # -1.79769313486231e+308; would cause a problem. SELECT f1 AS f1_direct FROM t1; let $my_stmt1= SELECT f1 AS f1_eval FROM t1; let $my_stmt2= SELECT f1 AS f1_prepared FROM t1; eval $my_stmt1; eval PREPARE my_sel FROM '$my_stmt2'; EXECUTE my_sel;