Project

General

Profile

bug #4957

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

Added by Andreas Müller over 3 years ago. Updated about 1 year ago.

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

0%

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 types New 12/05/2017

Associated revisions

Revision fb707701 (diff)
Added by Andreas Müller about 1 year ago

ref #4957 split terms into bulks of 2000 during termloading

History

#1 Updated by Katja Luther about 3 years ago

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

#2 Updated by Andreas Müller over 2 years ago

  • Target version changed from Release 4.0 to Release 4.1

#3 Updated by Andreas Müller over 2 years ago

  • Target version changed from Release 4.1 to Release 4.2

#4 Updated by Andreas Müller over 2 years ago

  • Target version changed from Release 4.2 to Release 4.3

#5 Updated by Andreas Müller about 2 years ago

  • Target version changed from Release 4.3 to Release 4.4

#6 Updated by Andreas Müller about 2 years ago

  • Target version changed from Release 4.4 to Release 4.5

#7 Updated by Andreas Müller almost 2 years ago

  • Target version changed from Release 4.5 to Release 4.6

#8 Updated by Andreas Müller almost 2 years ago

  • Target version changed from Release 4.6 to Release 4.7

#9 Updated by Andreas Müller over 1 year ago

  • Target version changed from Release 4.7 to Release 4.8

#10 Updated by Andreas Müller over 1 year ago

  • Target version changed from Release 4.8 to Release 4.9

#11 Updated by Andreas Müller over 1 year ago

  • Target version changed from Release 4.9 to Release 4.10

#12 Updated by Andreas Müller about 1 year ago

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

#15 Updated by Andreas Müller about 1 year 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

#16 Updated by Andreas Müller about 1 year ago

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

#17 Updated by Andreas Müller about 1 year 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

Also available in: Atom PDF

Add picture from clipboard (Maximum size: 40 MB)