René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"QAPage","mainEntity":{"@type":"Question","name":"Incorrect changes from 4.9 to 5.1","text":"
Hello, i have recently updated from 4.9 to 5.1. I have a lot of tests which failed after the migration to the newest version. I have successfully migrated the Visitors according to the Migration Guide.
\n
The first problem is with the dataType property:
\n4.9: According to me this is the correct representation, where The varchar length is stored in the argumentsStringList.
\n
\n
5.1: Incorrect representation where the length is part of the dataType
\n
\n
Another problem that i have discovered is with the UNSIGNED column specification:
\n4.9: Which I think is also the correct one:  the unsigned column spec is inside the columnSpecs list
\n
\n
5.1: Incorrect, where unsigned is part of the dataType
\n
\n
These are the ones that I have discovered for now, probably there are more.
\nWere these changes intentional or were changed by mistake?
","upvoteCount":1,"answerCount":2,"acceptedAnswer":{"@type":"Answer","text":"
Greetings,
\n
to be very honest: I don't care much about DDL statements and just try to get them parsed somehow (especially when there are parser errors).
\nThey have just too many RDBMS specific parts, far away from any standard to be useful in a RDBMS agnostic parser. And the Create/Alter Statement parts of the parser are grown over the time and not very well designed from begin.
\n
So your helping hand will be very much welcome when you are interested in this particular topic.
","upvoteCount":1,"url":"https://github.com/JSQLParser/JSqlParser/discussions/2162#discussioncomment-12120886"}}}