Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Bug]: Incorrect or outdated content in "Differences between Babelfish and SQL Server"? #262

Open
1 task done
rhbecker opened this issue Apr 7, 2023 · 0 comments
Open
1 task done
Labels
bug Something isn't working

Comments

@rhbecker
Copy link

rhbecker commented Apr 7, 2023

Describe the bug

There appears to be discrepancies between the Babelfish docs and AWS's Aurora docs for Babelfish, regarding which SQL Server features are currently supported. Is the former outdated, or is the latter incorrect?

As an example, built-in functions related to JSON ...

built-in function Babelfish docs Aurora docs
ISJSON ✔ as of v1.2.1
JSON_ARRAY unmentioned unmentioned
JSON_MODIFY ✔ as of v2.3.0
JSON_OBJECT unmentioned unmentioned
JSON_PATH_EXISTS unmentioned unmentioned
JSON_QUERY ✔ as of v1.2.1
JSON_VALUE ✔ as of v1.2.1
OPENJSON ✔ as of v2.1.0

The Babelfish docs also list a JSON function as unsupported (❌), but I'm not aware of a built-in function with that name, and wonder if that's a typo, intending to represent one of the otherwise unmentioned built-in functions.

The Aurora docs also list FOR JSON among its table of built-in functions, which seems possibly misplaced (doesn't seem like a built-in function), but I at least appreciate that I can see it's supposedly supported (✔), as of v2.3.0.

Code of Conduct

  • I agree to follow this project's Code of Conduct.
@rhbecker rhbecker added the bug Something isn't working label Apr 7, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant