GV

GeezerVison

The World Wide Web, restored to 800 pixels of glory.

Home|About|Gaming cabinet|Archives|How it works|Starter sites

On this site

  • Sign in
  • ActionsCI/CD and automation
  • CodespacesCloud development environments
  • All Features
  • Documentation
  • Training
  • Certifications
  • Build with Copilot
  • Customize Copilot
  • Integrations
  • Trending repos
  • GitHub Sponsors
  • Developer articles
  • Enterprises

This view

  • Original page
  • New address

GeezerVison is showing github.com — [BUG] JSQLParser Version : 4.6 : please add convert() support · Issue #1767 · JSQLParser/JSqlParser

[BUG] JSQLParser Version : 4.6 : please add convert() support #1767

New issue
Copy link
New issue
Copy link
Closed
#1778
Closed
[BUG] JSQLParser Version : 4.6 : please add convert() support#1767
#1778
Copy link

Description

@xm0012008
xm0012008
opened on Apr 19, 2023
Issue body actions

Always check against the Latest SNAPSHOT of JSQLParser and the Syntax Diagram

Failing SQL Feature:

  • convert(student_name using gbk) can't be parsed
  • Exception in thread "main" net.sf.jsqlparser.JSQLParserException: net.sf.jsqlparser.parser.ParseException: Encountered unexpected token: "(" "("
    at line 1, column 54.

SQL Example:

  • Simplified Query Example, focusing on the failing feature
    select * from tb_student_information order by convert(student_name using gbk) COLLATE gbk_chinese_ci desc

Software Information:

  • 4.6
  • mysql

Tips:

Please write in English and avoid Screenshots (as we can't copy and paste content from it).
Try your example online with the latest JSQLParser and share the link in the error report.
Do provide Links or References to the specific Grammar and Syntax you are trying to use.

Activity

  1. manticore-projects commented on Apr 30, 2023

    @manticore-projects
    manticore-projects
    on Apr 30, 2023
    Contributor
    More actions

    "ChatGPT, show how to implement a SQL:2016 compliant CONVERT expression in JSQLParser"

  2. manticore-projects commented on Apr 30, 2023

    @manticore-projects
    manticore-projects
    on Apr 30, 2023
    Contributor
    More actions

    Duplicate #1257

  3. manticore-projects
    added a commit that references this issue on Apr 30, 2023

    feat: implement SQL:2016 Convert() and Trim()

    This issue will close once commit 3a27a9d is merged into the 'master' branch.
    3a27a9d
  4. xm0012008 commented on May 9, 2023

    @xm0012008
    xm0012008
    on May 9, 2023
    Author
    More actions

    thanks!

  5. manticore-projects
    closed this as completedin #1778on Jun 1, 2023
  6. manticore-projects
    closed this as completedin 41b6fceon Jun 1, 2023
  7. manticore-projects
    added a commit that references this issue on Jun 15, 2023

    Assorted Fixes #8 (#1807)

    This issue will close once commit a815f5f is merged into the 'master' branch.
    a815f5f
  8. manticore-projects
    added a commit that references this issue on Jun 27, 2023

    Backslash Quotation of Single-Quote `'\\''` (#1813)

    This issue will close once commit c79dfff is merged into the 'master' branch.
    c79dfff
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions

      You are visitor 01402520 — GeezerVison does not store the pages you look up.
      Best viewed with Netscape Navigator 4.7 or Internet Explorer 6 at 800×600. No cookies required.