Uploaded image for project: 'Calcite'
  1. Calcite
  2. CALCITE-3486

In JDBC adapter, when generating ROW value expression, generates the ROW keyword only if the dialect allows it

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.21.0
    • Fix Version/s: next
    • Component/s: core

      Description

      when we use mysql dialect unparse sql,the Mysql dialect does not have a ROW keyword,

      but the ROW keyword does exist in SQL

      SQL

      insert into emps values (1,'Fredkin')
      

      SqlNode.toString(MysqlSqlDialect.DEFAULT)

      insert into emps values ROW(1,'Fredkin')
      

      This syntax is problematic in mysql

       

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                danny0405 Danny Chen
                Reporter:
                quxiucheng quxiucheng
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 4h
                  4h