How to use update extractor from data result view?

In the new version of the tool I cannot generate updates statement from tables that in the previous version worked ok. The problem is that the resulting statement does not include the table from the executed query but a default table name "MY_TABLE". Table from the query does have a pk.

Here is a short example:

-- Prepare test table
create table tmp_test2 (
  a int,
  b varchar2(50),
  constraint test2_pk primary key (a)
);
insert into tmp_test2 values (1,'2');

-- executre statement
select * from tmp_test2
;

-- returnint result from update extractor (ctrl + c)
UPDATE
MY_TABLE SET A = 1, B = '2';
5 comments
Comment actions Permalink

Hello,

I have created the issue, please follow https://youtrack.jetbrains.com/issue/DBE-1571 for updates. Btw what Datasource type do you use? Thanks.

0
Comment actions Permalink

Thanks,

it's an Oracle datasource.

0
Comment actions Permalink

Hello,

Please check with the latest EAP from https://confluence.jetbrains.com/display/DBE/0xDBE+142.4861+Released . Before using data extractor please Synchronize the Datasource. Does it work or if there are eny errors with synchronization? Thanks.

0
Comment actions Permalink

It works without any issue  :)  thank you.

0
Comment actions Permalink

Thanks for the information!

0

Please sign in to leave a comment.