Project

General

Profile

Actions

bug #4957

closed

MS SQL Server not functional as it does not allow more than 2100 parameters

Added by Andreas Müller over 6 years ago. Updated about 4 years ago.

Status:
Closed
Priority:
Priority13
Category:
cdmlib
Target version:
Start date:
10/14/2015
Due date:
% Done:

0%

Estimated time:
Severity:
normal
Found in Version:

Description

... for an SQL statement.

But e.g. the term loading uses >2100 parameters (all uuids) to load all managed data.

We need to find ways to avoid that many parameters, e.g. by splitting queries if SQL Server is database type.


Related issues

Related to Edit - bug #7113: Adapt SQL Server dialect to support all data typesNewAndreas Müller12/05/2017

Actions
Actions #1

Updated by Katja Luther over 6 years ago

  • Target version deleted (Unassigned CDM tickets)
  • Priority changed from New to Priority13
Actions #2

Updated by Andreas Müller over 5 years ago

  • Target version changed from Release 4.0 to Release 4.1
Actions #3

Updated by Andreas Müller over 5 years ago

  • Target version changed from Release 4.1 to Release 4.2
Actions #4

Updated by Andreas Müller over 5 years ago

  • Target version changed from Release 4.2 to Release 4.3
Actions #5

Updated by Andreas Müller over 5 years ago

  • Target version changed from Release 4.3 to Release 4.4
Actions #6

Updated by Andreas Müller about 5 years ago

  • Target version changed from Release 4.4 to Release 4.5
Actions #7

Updated by Andreas Müller about 5 years ago

  • Target version changed from Release 4.5 to Release 4.6
Actions #8

Updated by Andreas Müller almost 5 years ago

  • Target version changed from Release 4.6 to Release 4.7
Actions #9

Updated by Andreas Müller over 4 years ago

  • Target version changed from Release 4.7 to Release 4.8
Actions #10

Updated by Andreas Müller over 4 years ago

  • Target version changed from Release 4.8 to Release 4.9
Actions #11

Updated by Andreas Müller over 4 years ago

  • Target version changed from Release 4.9 to Release 4.10
Actions #12

Updated by Andreas Müller over 4 years ago

  • Description updated (diff)
  • Target version changed from Release 4.10 to Release 4.12
Actions #15

Updated by Andreas Müller over 4 years ago

  • Subject changed from SQL Server not functional as it does not allow more than 2100 parameters to MS SQL Server not functional as it does not allow more than 2100 parameters
Actions #16

Updated by Andreas Müller about 4 years ago

  • Related to bug #7113: Adapt SQL Server dialect to support all data types added
Actions #17

Updated by Andreas Müller about 4 years ago

  • Status changed from New to Closed
  • Private changed from Yes to No

This is fixed, but there is another issue with SQL Server: #7113

Actions

Also available in: Atom PDF