Sign in Join

Live chat for Free Pascal, Lazarus, Delphi and every Pascal programmer.

Mailing lists / fpc-devel / 2007-11

SQLdb: bug added with a bugfix port (FPC 2.2.0 + fixes)

9 messages · 2 people · –

Reply by email Subscribe to this list Your subscription

Read-only archive. Use j and k to move between messages.

Alvise Nicoletti

Hi...

I wrote some mails to Joost van der Sluis notifying that there is a strange bug in FPC 2.2.1 (
http://svn.freepascal.org/svn/fpc/branches/fixes_2_2 ) regarding SQLdb.

When I select DECIMAL colums with mysql, I get a "Invalid field size" exception even if I don't use it (I don't fetcìh them with FieldByName). Joost said me that the cause is "a patch in r2.3.1 which shoudn't be merged to fpc 2.1.1. but someone did".
After that I didn't speak with him anymore.

My question is... how can I fix that?

I spent a lot of time to pass from 2.0.4.... to 2.2.0... and from 2.2.0... to 2.2.1. (maybe now that I have understand what to do I will do it faster).
However, I wouln'd like to pass to 2.3.x to to fix this and find new bugs... I have to use a stable version, cause every time I update to the last version I find new problems.
That "stable version + bugfixes" is exactly what I need, and I'm happy that you did it.

But can someone revert that patch?

Thank you in advance,
Alvise Nicoletti

p.s. I'm having that problem on AMD64.

Reply by email

Joost van der Sluis
to Alvise Nicoletti

Op woensdag 14-11-2007 om 11:08 uur [tijdzone +0100], schreef Alvise Nicoletti:

Show quoted text 13 lines
Hi... I wrote some mails to Joost van der Sluis notifying that there is a strange bug in FPC 2.2.1 ( http://svn.freepascal.org/svn/fpc/branches/fixes_2_2 ) regarding SQLdb. When I select DECIMAL colums with mysql, I get a "Invalid field size" exception even if I don't use it (I don't fetcìh them with FieldByName). Joost said me that the cause is "a patch in r2.3.1 which shoudn't be merged to fpc 2.1.1. but someone did". After that I didn't speak with him anymore. My question is... how can I fix that?

I've merged the patches to fix this problem to fpc 2.1.1. So you can use the snapshot from tomorrow.

Thereafter you can use that version until you encounter a certain problem which is fixed in a newer version of fpc 2.1.1. At that point you have to decide if you update again...

Joost

Reply by email

Alvise Nicoletti
to Joost van der Sluis

Joost van der Sluis ha scritto:

Show quoted text 27 lines
Op woensdag 14-11-2007 om 11:08 uur [tijdzone +0100], schreef Alvise Nicoletti: > Hi... > > I wrote some mails to Joost van der Sluis notifying that there is a > strange bug in FPC 2.2.1 ( > http://svn.freepascal.org/svn/fpc/branches/fixes_2_2 ) regarding SQLdb. > > When I select DECIMAL colums with mysql, I get a "Invalid field size" > exception even if I don't use it (I don't fetcìh them with FieldByName). > Joost said me that the cause is "a patch in r2.3.1 which shoudn't be > merged to fpc 2.1.1. but someone did". > After that I didn't speak with him anymore. > > My question is... how can I fix that? > I've merged the patches to fix this problem to fpc 2.1.1. So you can use the snapshot from tomorrow. Thereafter you can use that version until you encounter a certain problem which is fixed in a newer version of fpc 2.1.1. At that point you have to decide if you update again... Joost

Thank you so much...

However: no problem to downgrade a little, but didn't you said me once that to use sqldb on linux 64 bit I have to use at least 2.2 ? The last time I was with an older version of fpc I had the "could not connect" error...

Also, can you say me what svn repository to use?
http://svn.freepascal.org/svn/fpc/tags/

Is it 2.1.2?

Will it work with lazarus 0.9.23?

Thank you again,
Alvise

Show quoted text 7 lines
_______________________________________________ fpc-devel maillist - http://lists.freepascal.org/mailman/listinfo/fpc-devel

Reply by email

Joost van der Sluis
to Alvise Nicoletti

Op vrijdag 16-11-2007 om 10:14 uur [tijdzone +0100], schreef Alvise Nicoletti:

Show quoted text 6 lines
However: no problem to downgrade a little, but didn't you said me once that to use sqldb on linux 64 bit I have to use at least 2.2 ? The last time I was with an older version of fpc I had the "could not connect" error...

I meant that it's fixed in 2.2.1 now

Joost

Reply by email

Alvise Nicoletti
to Joost van der Sluis

Joost van der Sluis ha scritto:

Show quoted text 14 lines
Op vrijdag 16-11-2007 om 10:14 uur [tijdzone +0100], schreef Alvise Nicoletti: > However: no problem to downgrade a little, but didn't you said me > once > that to use sqldb on linux 64 bit I have to use at least 2.2 ? > The last time I was with an older version of fpc I had the "could not > connect" error... > I meant that it's fixed in 2.2.1 now Joost

Hi...

I svn-updated today (from
//svn.freepascal.org/svn/fpc/branches/fixes_2_2) and, recompiling with the sql query that select a DECIMAL column, I still get the exception "Invalid field size" even if I don't fetch it.

Before re-compiling the application I did only a "compile after a clean" of the SQLdbLaz component, should I have done something else (like a rebuild of the ide)?

Alvise

Show quoted text 11 lines
_______________________________________________ fpc-devel maillist - http://lists.freepascal.org/mailman/listinfo/fpc-devel

Reply by email

Joost van der Sluis
to Alvise Nicoletti

Op woensdag 21-11-2007 om 12:26 uur [tijdzone +0100], schreef Alvise Nicoletti:

Show quoted text 25 lines
Joost van der Sluis ha scritto: > Op vrijdag 16-11-2007 om 10:14 uur [tijdzone +0100], schreef Alvise > Nicoletti: > >> However: no problem to downgrade a little, but didn't you said me >> once >> that to use sqldb on linux 64 bit I have to use at least 2.2 ? >> The last time I was with an older version of fpc I had the "could not >> connect" error... >> > > I meant that it's fixed in 2.2.1 now > > Joost > Hi... I svn-updated today (from //svn.freepascal.org/svn/fpc/branches/fixes_2_2) and, recompiling with the sql query that select a DECIMAL column, I still get the exception "Invalid field size" even if I don't fetch it. Before re-compiling the application I did only a "compile after a clean" of the SQLdbLaz component, should I have done something else (like a rebuild of the ide)?

Make sure that the right compiler is used. Look in the environment-options which compiler is used, and do a -v to ask the compiler version and date

Joost

Reply by email

Alvise Nicoletti
to Joost van der Sluis

Joost van der Sluis ha scritto:

Show quoted text 37 lines
Op woensdag 21-11-2007 om 12:26 uur [tijdzone +0100], schreef Alvise Nicoletti: > Joost van der Sluis ha scritto: > >> Op vrijdag 16-11-2007 om 10:14 uur [tijdzone +0100], schreef Alvise >> Nicoletti: >> >> >>> However: no problem to downgrade a little, but didn't you said me >>> once >>> that to use sqldb on linux 64 bit I have to use at least 2.2 ? >>> The last time I was with an older version of fpc I had the "could not >>> connect" error... >>> >>> >> I meant that it's fixed in 2.2.1 now >> >> Joost >> >> > Hi... > > I svn-updated today (from > //svn.freepascal.org/svn/fpc/branches/fixes_2_2) and, recompiling with > the sql query that select a DECIMAL column, I still get the exception > "Invalid field size" even if I don't fetch it. > > Before re-compiling the application I did only a "compile after a clean" > of the SQLdbLaz component, should I have done something else (like a > rebuild of the ide)? > Make sure that the right compiler is used. Look in the environment-options which compiler is used, and do a -v to ask the compiler version and date

Sorry... so I have to re-make the compiler with the make clean
make all
make install
procedure?

In the past, updating svn and recompilie the IDE was enough to "import" the bugfixes.... however I'm using that as compiler: /usr/lib/fpc/2.2.1/ppcx64
# /usr/lib/fpc/2.2.1/ppcx64 -V
Free Pascal Compiler version 2.2.1 [2007/11/05] for x86_64 Copyright (c) 1993-2007 by Florian Klaempfl

Let me know...

Show quoted text 9 lines
Joost _______________________________________________ fpc-devel maillist - http://lists.freepascal.org/mailman/listinfo/fpc-devel

Reply by email

Joost van der Sluis
to Alvise Nicoletti

Op vrijdag 23-11-2007 om 09:43 uur [tijdzone +0100], schreef Alvise Nicoletti:

Show quoted text 43 lines
Joost van der Sluis ha scritto: > Op woensdag 21-11-2007 om 12:26 uur [tijdzone +0100], schreef Alvise > Nicoletti: > >> Joost van der Sluis ha scritto: >> >>> Op vrijdag 16-11-2007 om 10:14 uur [tijdzone +0100], schreef Alvise >>> Nicoletti: >>> >>> >>>> However: no problem to downgrade a little, but didn't you said me >>>> once >>>> that to use sqldb on linux 64 bit I have to use at least 2.2 ? >>>> The last time I was with an older version of fpc I had the "could not >>>> connect" error... >>>> >>>> >>> I meant that it's fixed in 2.2.1 now >>> >>> Joost >>> >>> >> Hi... >> >> I svn-updated today (from >> //svn.freepascal.org/svn/fpc/branches/fixes_2_2) and, recompiling with >> the sql query that select a DECIMAL column, I still get the exception >> "Invalid field size" even if I don't fetch it. >> >> Before re-compiling the application I did only a "compile after a clean" >> of the SQLdbLaz component, should I have done something else (like a >> rebuild of the ide)? >> > > Make sure that the right compiler is used. Look in the > environment-options which compiler is used, and do a -v to ask the > compiler version and date > Sorry... so I have to re-make the compiler with the make clean make all make install procedure?

Yes.

Show quoted text 6 lines
In the past, updating svn and recompilie the IDE was enough to "import" the bugfixes.... however I'm using that as compiler: /usr/lib/fpc/2.2.1/ppcx64 # /usr/lib/fpc/2.2.1/ppcx64 -V Free Pascal Compiler version 2.2.1 [2007/11/05] for x86_64 Copyright (c) 1993-2007 by Florian Klaempfl

If there are bugfixes for the IDE, that's ok. If you have updated your compiler, you have to recompile the compiler.

Joost

Reply by email

Alvise Nicoletti
to Joost van der Sluis

Joost van der Sluis ha scritto:

Show quoted text 69 lines
Op vrijdag 23-11-2007 om 09:43 uur [tijdzone +0100], schreef Alvise Nicoletti: > Joost van der Sluis ha scritto: > >> Op woensdag 21-11-2007 om 12:26 uur [tijdzone +0100], schreef Alvise >> Nicoletti: >> >> >>> Joost van der Sluis ha scritto: >>> >>> >>>> Op vrijdag 16-11-2007 om 10:14 uur [tijdzone +0100], schreef Alvise >>>> Nicoletti: >>>> >>>> >>>> >>>>> However: no problem to downgrade a little, but didn't you said me >>>>> once >>>>> that to use sqldb on linux 64 bit I have to use at least 2.2 ? >>>>> The last time I was with an older version of fpc I had the "could not >>>>> connect" error... >>>>> >>>>> >>>>> >>>> I meant that it's fixed in 2.2.1 now >>>> >>>> Joost >>>> >>>> >>>> >>> Hi... >>> >>> I svn-updated today (from >>> //svn.freepascal.org/svn/fpc/branches/fixes_2_2) and, recompiling with >>> the sql query that select a DECIMAL column, I still get the exception >>> "Invalid field size" even if I don't fetch it. >>> >>> Before re-compiling the application I did only a "compile after a clean" >>> of the SQLdbLaz component, should I have done something else (like a >>> rebuild of the ide)? >>> >>> >> Make sure that the right compiler is used. Look in the >> environment-options which compiler is used, and do a -v to ask the >> compiler version and date >> >> > Sorry... so I have to re-make the compiler with the > make clean > make all > make install > procedure? > Yes. > In the past, updating svn and recompilie the IDE was enough to "import" > the bugfixes.... however I'm using that as compiler: > /usr/lib/fpc/2.2.1/ppcx64 > # /usr/lib/fpc/2.2.1/ppcx64 -V > Free Pascal Compiler version 2.2.1 [2007/11/05] for x86_64 > Copyright (c) 1993-2007 by Florian Klaempfl > If there are bugfixes for the IDE, that's ok. If you have updated your compiler, you have to recompile the compiler.

Thank you, I didn't know the compiler was changed.

Now it works perfectly.

Bye

Show quoted text 9 lines
Joost _______________________________________________ fpc-devel maillist - http://lists.freepascal.org/mailman/listinfo/fpc-devel

Reply by email