1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
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 )
répondu il y a un an
Contenus pertinents
- demandé il y a un an
- demandé il y a 2 mois
- Réponse acceptéedemandé il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a un an
- AWS OFFICIELA mis à jour il y a 2 ans