Opened 12 years ago

Closed 12 years ago

#825 closed defect (fixed)

Sqlite provider : String Primary key on a view

Reported by: bscott Owned by: romicadascalescu
Priority: major Milestone: 3.6.0
Component: SQLite Provider Version: 3.6.0
Severity: 3 Keywords:
Cc: External ID:

Description

Actually when we have a view it's possible to force the primary key by setting the fdo_data_details = 2 on the fdo_columns table.

This trick works well except when the column type is string. We should modify the code to allow string sltMetadata.cpp, line 1252

Attachments (1)

strpk.patch (848 bytes ) - added by bscott 12 years ago.

Download all attachments as: .zip

Change History (8)

by bscott, 12 years ago

Attachment: strpk.patch added

comment:1 by bscott, 12 years ago

Sorry this patch does not fix everything, still working on it

comment:2 by bscott, 12 years ago

After many test, the patch is ok and it fixes the problem

comment:3 by traianstanev, 12 years ago

Owner: changed from traianstanev to romicadascalescu

comment:4 by traianstanev, 12 years ago

Romy, since you know more about views, can you review this and check in if it's ok?

comment:5 by romicadascalescu, 12 years ago

Where this change is needed? 3.6, 3.7, 3.8? Right now I committed it in 3.8 (trunk).

Romy.

comment:6 by bscott, 12 years ago

For my purpose i would need it in 3.6 and 3.7 also Bruno

comment:7 by romicadascalescu, 12 years ago

Resolution: fixed
Status: newclosed

Done, fix ported to 3.6, 3.7, 3.8

Note: See TracTickets for help on using tickets.