[fpc-pascal] Master Detail relationship in SQLdb

[Martin Schreiber]

On Saturday 14 July 2007 16.26, Michael Van Canneyt wrote:
> On Sat, 14 Jul 2007, Martin Schreiber wrote:
> > On Saturday 14 July 2007 12.55, Michael Van Canneyt wrote:
> > > > I spent about 150-200 hours to find, report and fix bugs in the FPC
> > > > DB area BTW. :-)
> > >
> > > Which I appreciate: There are indeed 15 bugs in Mantis about this.
> > > (spending on average 10-13 hours per bug is a lot)
> >
> > Yes it was a hard time. :-)
> > The worst (a spurious SIGSEGV in TBufDataset) I hunted a whole week.
> > Because MSEgui must work with the latest stable FPC version I had to find
> > workarounds for every bug, a very time consuming process.
> > If I count right, I posted 114 FPC reports up to now, some of them in the
> > pre Mantis era.
>
> 45 in Mantis, to be exact. 15 of which are database bugs.
>
Here is the complete list:

1	0005085: Error in libc header transcription.
2	0005084: Error in pwidechar pointerarithmetic
3	0005094: AV in dynamic array assignment
4	0005087: Errors in libc header transcription.
5	0005095: Error in windows unit
6	0005096: Streaming of widestrings and widechars does not work.
7	0005113: {$if false} uncorrect
8	0005112: tobject.afterconstruction not called
9	0005154: Stack error in with statement
10	0005188: Abstract error in private section
11	0005193: VMT error in private section (related to 3179)
12	0005194: Error in set procedure parameter
13	0005199: Typeinfo() does not work with classes
14	0005206: Error in reference counting
15	0005228: Long strings as out proc parameters not finalized
16	0005331: Wrong type definition for wchar_t
17	0005332: Memory leak in copy function
18	0005341: No error message in interface conversion
19	0005346: Checkpointer error in open array
20	0005347: Function called twice in open array
21	0005371: Streaming of widestrings
22	0005561: Internal error 9999
23	0005563: Error in TBinaryObjectReader.SkipValue
24	0005578: Objecttext format of wide strings
25	0005565: Local directive CHECKPOINTER not documented
26	0005562: AV in copy function
27	0005564: Checkpointer error by string -> pchar conversion
28	0005636: Inline not supported in objecttext
29	0005643: No check for data and bss in CheckPointer procedure
30	0005655: csSubComponent not supported
31	0005716: Memory leak in dynamic array
32	0005727: Object text format of widestrings
33	0005772: AV in copy function
34	0005780: Missed cdecl in libc.sigaction
35	0005824: Error in win32 header translation
36	0005825: Accessing protected procedures in with statement
37	0006378: AV in TDatabase
38	0006035: AV by interface access
39	0006036: getinterface for corba style interfaces
40	0006034: Missing win32 procedure header
41	0006037: RTTI for interfaces
42	0006690: RTTI for inherited interfaces
43	0006060: Widestrings on Windows
44	0006065: AV in with statement
45	0006123: Overloaded functions
46	0006127: Error in widestring constant
47	0006168: SysTryResizeMem and heaptrace
48	0006205: Typeinfos are not unique
49	0006214: Widestring default procedure parameters
50	0006217: Missing Win32 procedure header
51	0006280: pthread_cond_t for NPTL
52	0006336: Multi threading on win32
53	0006346: Memory leak in registerinitcomponenthandler
54	0006706: Properties with nodefault and stored true options
55	0006427: FloatToStr with 1e100
56	0006426: ObjectBinaryToText with empty strings
57	0006468: Win32CompareWideString on windows98
58	0006865: Compiler crash with -Fcutf8
59	0006873: cwstring and threads
60	0006881: Dataevents in TDataset.MoveBy
61	0006882: Record insert at eof in TSQLQuery
62	0006883: Compile error without -B
63	0006650: Optimization and signed/unsigned comparison
64	0006889: AV in TSQLQuery.Cancel
65	0006892: AV in TSQLQuery.RecNo
66	0006893: Invalid TDatalink.FirstRecord
67	0006897: TSQLQuery.First returns wrong data
68	0006898: AV in TSQLQuery
69	0006899: TDataset.Insert shows record at wrong position
70	0006909: Property option stored false
71	0006919: AV in TBufDataset
72	0006931: Error in Libc header
73	0006938: AV inTBufDataset.CancelUpdates
74	0006988: Twriter.WriteDescendent with component properties
75	0007006: AV in fpc_widestr_inc_ref
76	0007007: Wrong TDataLink.ActiveRecord after append-cancel
77	0007048: AV in DisposeWideString
78	0007049: Memory error with wide strings
79	0007050: Error 204 in heaptrc.pp
80	0007052: Widechars are not streamed
81	0007144: AV in TSQLQuery
82	0007157: InternalCalcFields are not implemented
83	0007266: TBufDataset crash with empty table
84	0007267: TBufDataset crash with one row table
85	0007269: TField.as* properties do not raise exception
86	0007294: TBufDataset does not fire OnCalcFields
87	0007295: TBufDataset in dsCalcFields state
88	0007323: Invalid TBufDAtaset state after ApplyUpdates
89	0007324: Memory leak in TBufDataset ApplyUpdates
90	0007366: Wrong field values in TBufDataset
91	0007367: TSQLQuery does not call BindFields
92	0007446: Overloading with open array of integer parameter
93	0007565: TSQLQuery does not check pfInUpdate
94	0007654: dovarop and varCurrency
95	0007813: ObjectBinaryToText uses localized float strings
96	0008103: Memory error in cwstring
97	0008104: Non ASCII source code
98	0008140: Overloaded functions in interfaces
99	0008245: ObjectBinaryToText and apostrophe in string property
100	0008286: Type of TLargeintField.Value
101	0008386: Quoted decimal separator in FormatFloat
102	0008388: Single quoted string in FormatFloat
103	0008477: Potential memory error in TStringField.SetAsString
104	0008480: Bug in fpc_WideStr_Assign and fpc_WideStr_Incr_Ref
105	0008481: Bug in widestring assignment
106	0008482: TComponent.Name accepts any character
107	0009093: TfieldDef.Name not published
108	0009094: TFieldDef.DisplayName not published
109	0009115: TComponent.Name can not be set to ''
110	0009170: Erroneous finalizing of const widestring array
111	0009179: Error by record copy
112	0009187: win32 widestring copy error
113	0009190: win32 widestring parameter copy error
114	0009242: Debugging broken on win32 with PII
115	0009309: Wrong high(<openarray>) result

It seems I counted right, 115 is from today. :-)

Martin