Rob Verschoor
Rob Verschoor
Once Babelfish supports the new PG 17 features and thus supports T-SQL MERGE, the Compass -rewrite option will be retired for the Babelfish version in which that support is padded.
Compass follows the actual implementation of features in Babelfish. As to whether/when MERGE will be fully supported, it is on the long-term roadmap.
I cannot reproduce this issue. On 4.3.0 as well as on earlier versions it works correctly for me: ``` 1> select 1 as c1 into #tmp 2> select @@rowcount 3>...
Metadata for #tmp table columns is not currently in the Babelfish catalogs. Only object name can be obtained as shown above. There is a trick to get the metadata anyway:...
Warning: There is a big difference in transactional behaviour between this workaround and IGNORE_DUP_KEY, especially when multiple rows are inserted in the transaction. In addition, there is no guarantee that...
What is the use case for specifying a hex value here? Why is it preferred over just specifying the actual datetime value?
I understand the underlying logic - but my question is for what purpose would you have a SQL-based application want to convert a hex constant to a datetime? It seems...
This difference has not been intentional. Features that fail in T-SQL but do not fail in Babelfish have just not been a priority. For the SSMS failure, could you share...
You wrote `if you connect babelfish via SSMS, they also fail` Could you elaborate a bit on how you are connecting? When I connect to BBF with SSMS v.18.12.1 through...
Thanks, it is clear.