mysql trouble referencing parameterized select column in derived table -

mysql trouble referencing parameterized select column in derived table -

is working designed? mysql not giving me visibility in parmeterized column derived table. in next example, i'd expect both column1value , column2value returned, it's not returning column2value, parameterized value.

mysql> select version(); +--------------------+ | version() | +--------------------+ | 5.1.56-rel12.7-log | +--------------------+ 1 row in set (0.00 sec) mysql> prepare stmt1 'select a.* (select "column1value" column1, ? column2) a'; query ok, 0 rows affected (0.00 sec) statement prepared mysql> set @a = 'column2value'; query ok, 0 rows affected (0.00 sec) mysql> execute stmt1 using @a; +--------------+ | column1 | +--------------+ | column1value | +--------------+ 1 row in set (0.00 sec)

mysql