shlomi-noach / common-schema-legacy

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

Routine dependencies returns column name from a join <using> clause #68

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
Which version of common_schema are you using? (specify
revision+distribution)
2.2.11
revision 523

Which component is failing? (specify the view, function, etc.)
get_routine_dependencies

What is the expected output? What do you see instead?
A select statement that uses the USING clause in a join expression causes the 
get_routine_dependencies to return the column name instead of the table name.
This is the result from testproc().

+-------------+-------------+-------------+--------+
| schema_name | object_name | object_type | action |
+-------------+-------------+-------------+--------+
| myschema    | col2        | table       | select |
| myschema    | tableA      | table       | select |
+-------------+-------------+-------------+--------+

Can you provide with sample data?
create procedure testproc()
begin
  select *
  from tableA
  join tableB using (col1, col2);
end //

(As of version 1.1), please provide output of
SELECT * FROM common_schema.status

                       project_name: common_schema
                            version: 2.2
                           revision: 523
                       install_time: 2014-10-31 08:31:35
                    install_success: 1
          base_components_installed: 1
 innodb_plugin_components_installed: 1
percona_server_components_installed: 0
              install_mysql_version: 5.6.17
                   install_sql_mode: NO_AUTO_VALUE_ON_ZERO,NO_ENGINE_SUBSTITUTION

Please provide any additional information below.

Original issue reported on code.google.com by lars.gra...@gmail.com on 31 Oct 2014 at 3:33

GoogleCodeExporter commented 9 years ago
Thank you -- routine dependencies are still in BETA, and are not being actively 
pursued. I don't expect this to be fixed (unless someone contributes a patch)

Original comment by shlomi.n...@gmail.com on 13 Dec 2014 at 7:22