Uploaded image for project: 'CUBRID APIs'
  1. CUBRID APIs
  2. APIS-443

Fetch error in using openrowset() call in sql server

    Details

      Description

      In SQL Server 2008
      Run command:

      {code:sql}
      select * from openrowset('MSDASQL',
      'driver={CUBRID_8.4.1.4001.x64-debug};server=10.34.64.67;uid=dba;pwd=;db_name=demodb;port=30000;fetch_size=100',
      'select orderby_num(), host_year from record order by host_year for orderby_num() <= 150') as a{code}

      lost 99 records.
      output rows is

      {code}
      1
      101
      102
      ...
      150
      ====={code}

        Activity

        Hide
        cn15800 谢韦华[Bert] added a comment -

        The issue has been fixed.

        Show
        cn15800 谢韦华[Bert] added a comment - The issue has been fixed.

          People

          • Assignee:
            cn15800 谢韦华[Bert]
            Reporter:
            xiaoshan78 李成龙[이성룡]
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: