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

VotersWatch issueWatchersLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    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

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            danny0405 Danny Chen
            quxiucheng quxiucheng (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 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

                Slack

                  Issue deployment