I have a DB from a user of my software, with a lot of accented (French) characters in it. The character set is UTF8. When I do: SELECT DISTINCT...
118223
Michael Ludwig
mludwig71
Jun 1, 2012 3:40 pm
Follow-up on a recent thread and some pointers to GBAK docs: Re: Copy of the current db not updating generators ...
118224
Alec Swan
aukcioner
Jun 1, 2012 4:16 pm
I verified that FIREBIRD_TMP environment variable can be used to control where temporary files are written. But TempDirectories in firebird.conf seems to have...
118225
dancooperstock
Jun 1, 2012 4:20 pm
Two small follow-up points. First, I'm using FB version 2.0.3. Second, the following also fails with "Malformed String": SELECT f_GenerateSndxIndex(column)...
118226
dancooperstock
Jun 1, 2012 4:27 pm
OK, did some more experimentation. I can force the error with just this SQL: SELECT f_GenerateSndxIndex('ÉLISE') FROM rdb$database...
118227
Ann Harrison
annwharrison
Jun 1, 2012 4:30 pm
... Sigh. It looks as if the UDF doesn't handle UT8 character representation - a very common limitation. You may be able to force the conversion from the ...
118228
Michael Ludwig
mludwig71
Jun 1, 2012 5:17 pm
Database Startup and Shutdown >> Database Shutdown http://www.firebirdsql.org/manual/gfix-dbstartstop.html I've just been reading parts of the GFIX manual. It...
118229
Michael Ludwig
mludwig71
Jun 1, 2012 5:30 pm
... Doesn't sound exactly relevant for the issue you're facing, but maybe you can make sense of the discussion and so gain some insights: TempDirectories...
118230
Michael Ludwig
mludwig71
Jun 1, 2012 5:32 pm
... GFIX - Firebird Administration >> Database Shutdown http://www.destructor.de/firebird/gfix.htm -- Stefan Heymann, last change 2010-01-11 This has been...
118231
Michael Ludwig
mludwig71
Jun 1, 2012 5:40 pm
... Would using an introducer help? Along the lines of: SQL> show table z; A VARCHAR(20) CHARACTER SET UTF8 Nullable SQL> insert into z values ('Übel'); ...
118232
Alec Swan
aukcioner
Jun 1, 2012 5:55 pm
Thanks, Michael. The issue you pointed out is similar to mine and the resolution was to set FIREBIRD_TMP environment variable. But this approach does not allow...
118233
Michael Ludwig
mludwig71
Jun 1, 2012 6:17 pm
... That does sound unhealthy. Have you figured out what query or queries are causing these exorbitant temporary sort files? There might be ways of tailoring...
118234
Alec Swan
aukcioner
Jun 1, 2012 6:28 pm
We are working on tracking those queries down, but fixing them will require an upgrade which the customer does not want to do. Moreover, their db size is 12GB,...
118235
dancooperstock
Jun 1, 2012 6:33 pm
Michael, the character set is set to UTF8. Frankly I think this is most likely a bug/weakness in the UDF....
118236
dancooperstock
Jun 1, 2012 6:43 pm
Thanks, Ann. Unfortunately, I tried: SELECT f_GenerateSndxIndex(_LATIN1 'ÉLISE') FROM rdb$database; and it still gives the same error. ("_LATIN1"; is clearly...
118237
Alec Swan
aukcioner
Jun 1, 2012 10:31 pm
Hello, We tracked down the query that generated a 10GB temp file running against a 1.5GB database. Can anybody explain why the query is not using an index on...
118238
Michael Ludwig
mludwig71
Jun 2, 2012 7:19 am
... Your query is essentially: SELECT FIRST (1000) PHYSICAL_COPY."ID", […], COPY_CLASSIFICATION."IS_DIRTY" FROM PHYSICAL_COPY INNER JOIN COPY ON...
118239
Dmitry Kuzmenko
dkuzmenko
Jun 2, 2012 9:11 am
Hello, Alec! Saturday, June 2, 2012, 2:31:36 AM, you wrote: AS> We tracked down the query that generated a 10GB temp file running AS> against a 1.5GB database....
118240
dancooperstock
Jun 2, 2012 2:43 pm
I just solved my own problem, and wanted to help anyone else with the same problem! I'm trying to write a UDF that returns memory allocated with...
118241
softdestek
Jun 2, 2012 5:47 pm
ACCOUNTS.DEBT is double ACCOUNTS.RECEIVABLES is double MY QUERY SELECT SUM(ACCOUNTS.DEBT), SUM(ACCOUNTS.RECEIVABLES), ...
118242
Alec Swan
aukcioner
Jun 2, 2012 5:50 pm
Hello Michael and Dmitry, Michael, the index on PHYSICAL_COPY."COMMIT_NUMBER" is ascending, so in theory it should be used. Dmitry, I simplified the query by...
118243
Mark Rotteveel
mark@...
Jun 2, 2012 6:06 pm
... Double precision is not exact due to the way it represents numbers, see http://docs.oracle.com/cd/E19957-01/806-3568/ncg_goldberg.html for a thorough...
118244
Alec Swan
aukcioner
Jun 2, 2012 7:28 pm
Hello, I am using FB 2.5 and execute SQL using Flamerobin. I am trying to specify a plan for a query that has ORDER BY clause. I get a "invalid token PLAN"...
118245
Dmitry Kuzmenko
dkuzmenko
Jun 2, 2012 8:30 pm
Hello, Alec! Saturday, June 2, 2012, 11:28:52 PM, you wrote: AS> Hello, AS> I am using FB 2.5 and execute SQL using Flamerobin. I am trying to AS> specify a...
118246
Dmitry Kuzmenko
dkuzmenko
Jun 2, 2012 8:31 pm
Hello, Alec! Saturday, June 2, 2012, 11:28:52 PM, you wrote: AS> specify a plan for a query that has ORDER BY clause. I get a "invalid AS> token PLAN" error if...
118247
Alec Swan
aukcioner
Jun 2, 2012 9:09 pm
Dmitry, We create indexes programmatically and we we generate their names based on their definition, such the columns they index. In fact the plan I am trying ...
118248
Dmitry Kuzmenko
dkuzmenko
Jun 2, 2012 9:17 pm
Hello, Alec! AS> The question is why FB complains about PLAN token after ORDER BY clause? the answer is that PLAN is wrong. ORDER BY in query affects PLAN, it ...
118249
Alec Swan
aukcioner
Jun 2, 2012 9:37 pm
Dmitry, If you look at the plans in my original post they both have "PHYSICAL_COPY ORDER "IDX_214/CmDhH936xtHXcXNQKg==" INDEX" just like you suggested. Sorry...
118250
Michel.Francoeur@...
francoemic
Jun 2, 2012 10:05 pm
[Non-text portions of this message have been removed]...
118251
Dmitry Kuzmenko
dkuzmenko
Jun 2, 2012 10:34 pm
Hello, Alec! AS> 2. Changed the query to "A INNER JOIN B ORDER BY X PLAN P", where P is the AS> plan generated by FB in #1. Received "Unexpected token PLAN"...
