Comments (6)
so this is not technically a bug since timestamp
is by definition without timezone. The AST produces the same syntax regardless of variations. Does that make sense?
https://www.postgresql.org/docs/9.1/datatype-datetime.html
So in your example, the type wasn't actually changed, but the syntax expressing it was.
from pgsql-parser.
two queries can create the same AST. One AST, however, can only create one query.
from pgsql-parser.
Curious, it makes sense but I don't understand why the query fingerprint changed. Isn't finger print supposed to remain same for various syntaxes of the same query? 🤔
from pgsql-parser.
Thank you, but do you think that fingerprint of two queries which produce the same AST should be the same?
from pgsql-parser.
what I'm suggesting is that, the deparser is not a bijective function, in other words It's lossy. So I think the fingerprints of two different queries should each be unique, however, once they are passed through the parser/deparser and back, they would only ever produce one query and thus one fingerprint.
from pgsql-parser.
Got it, thank you for taking the time to explain.
from pgsql-parser.
Related Issues (20)
- PRs from postgres-ast-deparser for reference
- Use in client side HOT 1
- supabase artifact not found HOT 6
- Queries with CTEs (WITH clause) that have column aliases cause syntax error HOT 6
- Question: why not async? HOT 2
- New release of pgsql-parser for macOS SDK Issue HOT 3
- PG 14 upgrade HOT 5
- PG 15 upgrade HOT 7
- Error installing the package on Windows 10 HOT 1
- CREATE INDEX with expression missing extra parenthesis
- transformArrays slow for large queries HOT 2
- Error: List is not implemented: HOT 2
- Bug - Column names with a only capital letters are not surrounded by quotes on deparse.
- Reliably identify table names?
- new node 20 version for pre-builds HOT 1
- logo
- PG 16 upgrade HOT 4
- Segmentation fault
- Incorrect parsing of quotes in create aggregate
- deparser bug: Incorrect string escaping
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pgsql-parser.