facebook

SQL Results editing error when 2 columns have the same name

💡
Our Forums Have Moved

For help with installation, bugs reports or feature requests, please head over to our new forums.
Genuitec Community on GitHub

  1. MyEclipse Archived
  2.  > 
  3. Bugs
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • #244263 Reply

    If you run a query where the result set contains two (or more) columns with the same name and you put the cursor into the <b>first</b> column, the SQL Results pane will display the value from the <b>last</b> column in that row with the same name as the field you selected.

    A trivial example follows:

    select t1.table_name,t2.table_name from all_tables t1,all_tables t2
    where t1.table_name like ‘A%’ and t2.table_name like ‘B%’ — Adjust values as needed to avoid dups.

    Run this query and click on any value in the first column of any row in the SQL Results. The first field will display the value from the second field in that row.

    Found with JDK 1.4.2, Eclipse 3.1.1, myEclipse 4.0.3 on Windows XP.

    #244269

    Riyad Kalla
    Member

    Will file it, thank you bjorng.

Viewing 2 posts - 1 through 2 (of 2 total)
Reply To: SQL Results editing error when 2 columns have the same name

You must be logged in to post in the forum log in