 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
 [12.0.191 Pro] - BUG:Ctrl+clicking updated table (Postgres) |
 |
When Ctrl+clicking the table name in an UPDATE statement, SA incorrectly tries to fetch the data from a table with the name of the column in the SET part instead of the actual table name given in the UPDATE part. On the other hand, clicking the column retrieves the data in that column so it seems that SA can correctly decode the table name, it simply does not use it when clicking the table name.
Check this short video here.
UPDATE: also applies to INSERT statements;
|
|
| Wed Jan 12, 2022 4:43 am |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Acknowledged. Many thanks for reporting this issue, we will try to fix it as quickly as possible.
|
|
| Wed Jan 12, 2022 11:23 am |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
Quick question, is this issue reproducible with standalone SQL statements which are not within procedural code?
|
|
| Wed Jan 12, 2022 11:28 am |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
Yes, it is. It also seems irrelevant what's in the SET part. My last observation is that it always uses the name of the first column instead of the table name.
|
|
| Thu Jan 13, 2022 12:50 am |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
