1回答
- 新しい順
- 投票が多い順
- コメントが多い順
0
You have hit a known issue that is on the roadmap. In the meantime, please rewrite your UPDATE statement as per below:
UPDATE #table2
SET Retail = a.Retail, Cost = a.Cost, GP = (a.Retail-a.Cost)/a.Retail * 100
FROM #table2 b, #table1 a
WHERE a.keyID = b.keyID
Important: make sure you are running the latest available version of Aurora PostgreSQL and Babelfish, which is this case is APG 14.5 and BBF 2.2. You can check the version through e.g. sqlcmd with:
SELECT CAST( SERVERPROPERTY('BabelfishVersion') AS VARCHAR )
回答済み 1年前
関連するコンテンツ
- AWS公式更新しました 1年前
- AWS公式更新しました 1年前