Title: [BUG] JSQLParser 5.4-SNAPSHOT : PostgreSQL : "generated always as" regression in 5.4-SNAPSHOT · Issue #2324 · JSQLParser/JSqlParser · GitHub
Open Graph Title: [BUG] JSQLParser 5.4-SNAPSHOT : PostgreSQL : "generated always as" regression in 5.4-SNAPSHOT · Issue #2324 · JSQLParser/JSqlParser
X Title: [BUG] JSQLParser 5.4-SNAPSHOT : PostgreSQL : "generated always as" regression in 5.4-SNAPSHOT · Issue #2324 · JSQLParser/JSqlParser
Description: Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram Failing SQL Feature: 5.4-SNAPSHOT currently introduces a regression: "generated always as" or "generated by default" makes the parser fail when encountering th...
Open Graph Description: Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram Failing SQL Feature: 5.4-SNAPSHOT currently introduces a regression: "generated always as" or "generated by default" ma...
X Description: Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram Failing SQL Feature: 5.4-SNAPSHOT currently introduces a regression: "generated always as" or "generated...
Opengraph URL: https://github.com/JSQLParser/JSqlParser/issues/2324
X: @github
Domain: github.com
{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"[BUG] JSQLParser 5.4-SNAPSHOT : PostgreSQL : \"generated always as\" regression in 5.4-SNAPSHOT","articleBody":"Always check against the **Latest SNAPSHOT of JSQLParser** and the [Syntax Diagram](https://jsqlparser.github.io/JSqlParser/syntax_snapshot.html)\n\n### Failing SQL Feature:\n- 5.4-SNAPSHOT currently introduces a regression: \"generated always as\" or \"generated by default\" makes the parser fail when encountering the keywords in `create table` statements, previously (5.3) this information was just added to `ColumnDefinition#getColumnSpecs`\n\n### SQL Example:\n- Simplified Query Example, focusing on the failing feature\n```sql\ncreate table if not exists book_type (\n id bigint not null generated always as identity\n);\n```\nthrows\n```\njava.lang.RuntimeException: net.sf.jsqlparser.parser.ParseException: Encountered: \u003cK_ALWAYS\u003e / \"always\", at line 2, column 32, in lexical state DEFAULT.\nWas expecting one of these terminals within expansion starting at 8213:17:\n \u003cK_COMMA\u003e (inside 8091:17) ...\n \u003cCLOSING_BRACKET\u003e (inside 8213:17) ...\n \".\" (inside 8553:13) ...\n \".\" (inside 8554:17) ...\n```\n\n### Software Information:\n- JSqlParser 5.4-SNAPSHOT\n- Database PostgreSQL","author":{"url":"https://github.com/LouizFC","@type":"Person","name":"LouizFC"},"datePublished":"2025-10-09T13:20:40.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":0},"url":"https://github.com/2324/JSqlParser/issues/2324"}
| route-pattern | /_view_fragments/issues/show/:user_id/:repository/:id/issue_layout(.:format) |
| route-controller | voltron_issues_fragments |
| route-action | issue_layout |
| fetch-nonce | v2:ae0a67a0-47de-4f3f-0885-33fd08b814f3 |
| current-catalog-service-hash | 81bb79d38c15960b92d99bca9288a9108c7a47b18f2423d0f6438c5b7bcd2114 |
| request-id | E2CA:AA45D:1E187BA:2963C11:6964C6AE |
| html-safe-nonce | 71a867344e07c1555e1bc07cbd13f624ddd9d874c59f847c9d20943baaa70692 |
| visitor-payload | eyJyZWZlcnJlciI6IiIsInJlcXVlc3RfaWQiOiJFMkNBOkFBNDVEOjFFMTg3QkE6Mjk2M0MxMTo2OTY0QzZBRSIsInZpc2l0b3JfaWQiOiI5NjI1ODk3NDcxODQ5Nzc1ODIiLCJyZWdpb25fZWRnZSI6ImlhZCIsInJlZ2lvbl9yZW5kZXIiOiJpYWQifQ== |
| visitor-hmac | f5f6f93f093fc1c8910b84fd815abd2f9ec65d63607c3b23909eceae7b5c5c32 |
| hovercard-subject-tag | issue:3499153661 |
| github-keyboard-shortcuts | repository,issues,copilot |
| google-site-verification | Apib7-x98H0j5cPqHWwSMm6dNU4GmODRoqxLiDzdx9I |
| octolytics-url | https://collector.github.com/github/collect |
| analytics-location | / |
| fb:app_id | 1401488693436528 |
| apple-itunes-app | app-id=1477376905, app-argument=https://github.com/_view_fragments/issues/show/JSQLParser/JSqlParser/2324/issue_layout |
| twitter:image | https://opengraph.githubassets.com/71d784944d112feb7ed06e50c7439bfe7f270dccd7543f4a90f3bd6726c4aa4d/JSQLParser/JSqlParser/issues/2324 |
| twitter:card | summary_large_image |
| og:image | https://opengraph.githubassets.com/71d784944d112feb7ed06e50c7439bfe7f270dccd7543f4a90f3bd6726c4aa4d/JSQLParser/JSqlParser/issues/2324 |
| og:image:alt | Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram Failing SQL Feature: 5.4-SNAPSHOT currently introduces a regression: "generated always as" or "generated by default" ma... |
| og:image:width | 1200 |
| og:image:height | 600 |
| og:site_name | GitHub |
| og:type | object |
| og:author:username | LouizFC |
| hostname | github.com |
| expected-hostname | github.com |
| None | 21df671ce2c9f1a16940ccbd3af6cb4f3f12a856929ca7eb1b4aea8e384ea442 |
| turbo-cache-control | no-preview |
| go-import | github.com/JSQLParser/JSqlParser git https://github.com/JSQLParser/JSqlParser.git |
| octolytics-dimension-user_id | 4643847 |
| octolytics-dimension-user_login | JSQLParser |
| octolytics-dimension-repository_id | 1944709 |
| octolytics-dimension-repository_nwo | JSQLParser/JSqlParser |
| octolytics-dimension-repository_public | true |
| octolytics-dimension-repository_is_fork | false |
| octolytics-dimension-repository_network_root_id | 1944709 |
| octolytics-dimension-repository_network_root_nwo | JSQLParser/JSqlParser |
| turbo-body-classes | logged-out env-production page-responsive |
| disable-turbo | false |
| browser-stats-url | https://api.github.com/_private/browser/stats |
| browser-errors-url | https://api.github.com/_private/browser/errors |
| release | 5707c685ac172d50a0bdd7533dde4f8aabcf8eef |
| ui-target | full |
| theme-color | #1e2327 |
| color-scheme | light dark |
Links:
Viewport: width=device-width