Project

General

Profile

Bug #7329

different format in query join between c_item_property and c_### tables

Added by Agathe Hubert over 6 years ago. Updated over 6 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Database & API changes
Target version:
Start date:
15/10/2014
Due date:
% Done:

0%

Estimated time:
Spent time:
Complexity:
Normal
SCRUM pts - complexity:
?

Description

Hi,

In the database the link between c_item_property and c_document seems wrong,isn't it ?
Indeed, in the join with have c_item_property.ref = c_document.id but c_document.id is int(10) and c_item_property.ref is int(11).
There are other c_##### tables that have id int(10).
Normaly when the elements of a join are different the query is not optimize.

Is it normal ?
Is the simple fix to change int(10) into int(11) ?

History

#1

Updated by Agathe Hubert over 6 years ago

  • Category set to Database & API changes

concerns the 1.9.6 version

#2

Updated by Yannick Warnier over 6 years ago

  • Target version set to 1.9.10
#3

Updated by Julio Montoya over 6 years ago

  • Target version changed from 1.9.10 to 2.0

This require a DB change. Can't be fixed in 1.9.x. Moving to v10

Also available in: Atom PDF