search

shlomi-noach / common-schema-legacy

Automatically exported from code.google.com/p/common-schema
5 stars 6 forks source link

_wrap_select_list_columns does not work properly on full qualified column names #38

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 

root@mysql-5.1.51> set @q := 'select City.name, City.population from world.City 
limit 10';

root@mysql-5.1.51> call _wrap_select_list_columns(@q, 2, @e);

root@mysql-5.1.51> select @q, @e;
+---------------------------------------------------------------+------+
| @q                                                            | @e   |
+---------------------------------------------------------------+------+
| select  City AS col1,  City. AS col2 from world.City limit 10 | NULL |
+---------------------------------------------------------------+------+

Original issue reported on code.google.com by shlomi.n...@gmail.com on 8 Jan 2013 at 12:04

GoogleCodeExporter commented 9 years ago 
This issue was closed by revision r415.

Original comment by shlomi.n...@gmail.com on 9 Jan 2013 at 9:41

GoogleCodeExporter commented 9 years ago 
Fixed in revision 415: now produces:

select  City.name AS col1,  City.population  AS col2 from world.City limit 10 ;

Original comment by shlomi.n...@gmail.com on 9 Jan 2013 at 9:42