Re: [firebird-support] is it a bug?

2020-07-28 Thread 'River~~' river14ap...@gmail.com [firebird-support]
I think this behaviour is consistent with the ANSI standard. The double quotes are necessary (if my memory serves me correctly) if there are characters in the user name that are not letters numbers and underscores. Maybe hyphens/minus are allowed also. But it's the dot that is annoying the

Re: [firebird-support] is it a bug?

2020-07-28 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
The firebird-support Yahoo Group has moved to Google Groups at https://groups.google.com/d/forum/firebird-support. Please subscribe and post your question there. Mark On 2020-07-28 15:23, hamacker sirhamac...@gmail.com [firebird-support] wrote: > If I try in FB3 (latest version):CREATE >

Re: [firebird-support] is it a bug?

2020-07-28 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
28.07.2020 15:23, hamacker sirhamac...@gmail.com [firebird-support] wrote: > I think that double quotes are used only if you want case sensitive They are required for any SQL identifier that contains non-allowed characters. -- WBR, SD.

[firebird-support] is it a bug?

2020-07-28 Thread hamacker sirhamac...@gmail.com [firebird-support]
If I try in FB3 (latest version): CREATE USER 'ROBOT.CUSTOS' -- wont run PASSWORD 'password' FIRSTNAME 'ROBOT' MIDDLENAME 'DE' LASTNAME 'CUSTOS' ; Not run! but If I try: CREATE USER "ROBOT.CUSTOS" -- it´s run PASSWORD 'password' FIRSTNAME 'ROBOT' MIDDLENAME 'DE' LASTNAME

Re: [firebird-support] Is this a bug in ROUND function?

2019-08-27 Thread Richard Damon rich...@damon-family.org [firebird-support]
On 8/19/19 4:46 AM, m.djo...@gmail.com [firebird-support] wrote: >   > > The following query shows that ROUND function does not give similar > results for similar values: > > > select >     round(cast(0.725 as double precision), 2), >     round(cast(1.725 as double precision), 2), >    

[firebird-support] Is this a bug in ROUND function?

2019-08-27 Thread m.djo...@gmail.com [firebird-support]
The following query shows that ROUND function does not give similar results for similar values: select round(cast(0.725 as double precision), 2), round(cast(1.725 as double precision), 2), round(cast(2.725 as double precision), 2), round(cast(3.725 as double precision), 2),

Re: [firebird-support] Is this a bug of Firebird?

2017-02-10 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
A warning would be enough. If after the INTO clause there are 2 or 3 variables, no problem, it will be very easy to detect the mistake. But sometimes that is not the case because there are 20+ variables and if variable 3 is called "lcName" and variable 24 is called "lcName" too, the programmer

RE: [firebird-support] Is this a bug of Firebird?

2017-02-09 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Doug, > Delphi's latest compiler provides a hint in these cases: > > var >   x: Int32; > begin >   try >     x := 0; >     x := 1; >     writeln(x); > end. > > [dcc32 Hint] Project1.dpr(14): H2077 Value assigned to 'x' never used > (Line 14 is the one assigning zero.) In hindsight my post

Re: [firebird-support] Is this a bug of Firebird?

2017-02-09 Thread hamacker sirhamac...@gmail.com [firebird-support]
Some times, I need to create a query where there is a 'where (0=0)' . it´s not logic for anyone. But to me, it´s significant because I need to certify that WHERE clausule always exists when populate my query with dinamic filters controlled by my application. In your example, I can espaculate that

Re: [firebird-support] Is this a bug of Firebird?

2017-02-09 Thread Tim Ward t...@telensa.com [firebird-support]
Interesting. (I haven't used Delphi for decades, certainly not this century.) On 09/02/2017 13:17, DougC d...@moosemail.net [firebird-support] wrote: Delphi's latest compiler provides a hint in these cases: var x: Int32; begin try x := 0; x := 1; writeln(x); end. [dcc32 Hint]

Re: [firebird-support] Is this a bug of Firebird?

2017-02-09 Thread DougC d...@moosemail.net [firebird-support]
Delphi's latest compiler provides a hint in these cases: var x: Int32; begin try x := 0; x := 1; writeln(x); end. [dcc32 Hint] Project1.dpr(14): H2077 Value assigned to 'x' never used (Line 14 is the one assigning zero.) On Thu, 09 Feb 2017 04:30:06 -0500 Tim

Re: [firebird-support] Is this a bug of Firebird?

2017-02-09 Thread Marsupilami79 marsupilam...@gmx.de [firebird-support]
Hmm - Delphi and Free Pascal do exactly that - they emit a warning, that the first assigned value never gets used. Am 09.02.2017 um 10:30 schrieb Tim Ward t...@telensa.com [firebird-support]: > > > It' the equivalent in a conventional programming language of saying: > > x = a; > x = b; > >

Re: [firebird-support] Is this a bug of Firebird?

2017-02-09 Thread Tim Ward t...@telensa.com [firebird-support]
It' the equivalent in a conventional programming language of saying: x = a; x = b; where the compiler is expected to know that neither a not the first assignment have any side effects other than the assignment (and where the expression b doesn't depend on the value of x)(and where x isn't

Re: [firebird-support] Is this a bug of Firebird?

2017-02-08 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
The error is of the programmer, I agree with you, but to repeat the name of a variable without the Firebird showing any message of error is, at least for me, a bug. To have 2 or more variables with the same name after the INTO clause is useless. The compiler can be smart enough to detect such

RE: [firebird-support] Is this a bug of Firebird?

2017-02-08 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> Yes, but I can not know the value of the column X.ALU_NOMBRE > > And the idea, of course, is know that value, that's why it appears in the FOR > SELECT. If not, I can do nothing with X.ALU_NOMBRE You are asking for the system to evaluate the *intent* of logic. That is completely outside the

Re: [firebird-support] Is this a bug of Firebird?

2017-02-08 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
Yes, but I can not know the value of the column X.ALU_NOMBRE And the idea, of course, is know that value, that's why it appears in the FOR SELECT. If not, I can do nothing with X.ALU_NOMBRE Greetings. Walter. On Wed, Feb 8, 2017 at 12:02 PM, Dimitry Sibiryakov s...@ibphoenix.com

[firebird-support] Is this a bug of Firebird?

2017-02-08 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
CREATE PROCEDURE TEST RETURNS( lcName VARCHAR(40)) AS BEGIN FOR SELECT ALU_NOMBRE, ALU_APELLD FROM ALUMNOS INTO :lcName, :lcName DO SUSPEND; END; In the above stored procedure there are 2 columns in the FOR SELECT but just 1 variable name. It

Re: [firebird-support] It´s a bug or whatever?

2015-10-29 Thread setysvar setys...@gmail.com [firebird-support]
Den 29.10.2015 19:22, skrev hamacker sirhamac...@gmail.com [firebird-support]: Hi everybody. When I try: select (2183.48/(1-(37.25/100))) as valor from rdb$database As result Firebird: 3465,8412 But other databases(MSSQL) and spreadshets(Excel and Calc) the correct result is 3479,6494023904

[firebird-support] It´s a bug or whatever?

2015-10-29 Thread hamacker sirhamac...@gmail.com [firebird-support]
Hi everybody. When I try: select (2183.48/(1-(37.25/100))) as valor from rdb$database As result Firebird: 3465,8412 But other databases(MSSQL) and spreadshets(Excel and Calc) the correct result is 3479,6494023904 If I change (37.25/100) to 0.3725 as follow: select (2183.48/(1-0.3725)) as

Re: [firebird-support] It´s a bug or whatever?

2015-10-29 Thread 'Carlos H. Cantu' lis...@warmboot.com.br [firebird-support]

Re: [firebird-support] It´s a bug or whatever?

2015-10-29 Thread hamacker sirhamac...@gmail.com [firebird-support]
Thanks. One more question, It´s a firebird way or it´s a math general consensus? I try a lot of programs, and only firebird return wrong value. 2015-10-29 16:30 GMT-02:00 setysvar setys...@gmail.com [firebird-support] < firebird-support@yahoogroups.com>: > > > Den 29.10.2015 19:22, skrev

Re: [firebird-support] It´s a bug or whatever?

2015-10-29 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 29-10-2015 19:22, hamacker sirhamac...@gmail.com [firebird-support] wrote: > When I try: > select (2183.48/(1-(37.25/100))) as valor from rdb$database > > As result Firebird: 3465,8412 > But other databases(MSSQL) and spreadshets(Excel and Calc) the correct > result is 3479,6494023904 > > If

Re: [firebird-support] Is this a bug or common behaviour? (conversion error from string )

2015-06-24 Thread liviuslivius liviusliv...@poczta.onet.pl [firebird-support]
    W dniu 2015-06-23 10:38:25 użytkownik brucedickin...@wp.pl [firebird-support] firebird-support@yahoogroups.com napisał:   Hello guys, today I've stumbled on some strange (in my opinion) behaviour. Firstly, create these two structures: CREATE GLOBAL TEMPORARY TABLE GLB_CS_TEMP (  

[firebird-support] Is this a bug or common behaviour? (conversion error from string )

2015-06-23 Thread brucedickin...@wp.pl [firebird-support]
Hello guys, today I've stumbled on some strange (in my opinion) behaviour. Firstly, create these two structures: CREATE GLOBAL TEMPORARY TABLE GLB_CS_TEMP ( ID_MON_OBJECT INTEGER NOT NULL, ID_PARAM INTEGER NOT NULL, MEASUREMENT_DATE TIMESTAMP, PARAM_VALUE VARCHAR(64) DEFAULT '',

[firebird-support] Re: Strange plan? Bug?

2013-09-20 Thread Dmitry Yemanov
20.09.2013 13:36, Kjell Rilbe wrote: Strangely enough I SET's reply hasen't shown up in my inbox, and yes I did check the spam/garbage folder. Anyway, I know separate subplans are enumerated without comma, but it seems odd, then, that it doesn't prefix *all* subplans with PLAN. IIRC, unions

Re: [firebird-support] Re: Strange plan? Bug?

2013-09-20 Thread Kjell Rilbe

Re: [firebird-support] Weird query results - bug?

2013-01-23 Thread Thomas Steinmaurer
Kjell, Rows that are returned when there's a WHERE clause, but not if there's no WHERE clause doesn't make sense at all. What you could try, is to locate the error. If you do a backup restore, do you observe the same behaviour on the restored copy? If not, that indicates that there is an

Re: [firebird-support] Weird query results - bug?

2013-01-21 Thread Kjell Rilbe
Den 2013-01-21 10:03 skrev Svein Erling Tysvær såhär: Rows that are returned when there's a WHERE clause, but not if there's no WHERE clause doesn't make sense at all. What you could try, is to locate the error. If you do a backup restore, do you observe the same behaviour on the restored

Re: [firebird-support] Weird query results - bug?

2013-01-21 Thread Gary Benade
On 1/21/2013 10:36 AM, Kjell Rilbe wrote: Den 2013-01-21 09:23 skrev Gary Benade såhär: On 1/20/2013 10:31 PM, Kjell Rilbe wrote: Den 2013-01-19 08:27 skrev Gary Benade såhär: On 1/18/2013 2:48 PM, Kjell Rilbe wrote: Den 2013-01-18 13:30 skrev Gary Benade såhär: On 1/18/2013 2:02 PM, Kjell

Re: [firebird-support] Weird query results - bug?

2013-01-21 Thread Kjell Rilbe
Den 2013-01-21 11:24 skrev Gary Benade såhär: One last try, what does this give you? select B.* from Branschkod B inner join Branschkod B2 on B2.Namn = B.Namn and B.ECO_ID B2.ECO_ID Same 2533 records as usual. :-) Kjell -- -- Kjell Rilbe DataDIA AB

Re: [firebird-support] Weird query results - bug?

2013-01-20 Thread Kjell Rilbe
Den 2013-01-19 08:27 skrev Gary Benade såhär: On 1/18/2013 2:48 PM, Kjell Rilbe wrote: Den 2013-01-18 13:30 skrev Gary Benade såhär: On 1/18/2013 2:02 PM, Kjell Rilbe wrote: Den 2013-01-18 12:56 skrev Kjell Rilbe såhär: Hi, This SQL returns 2533 records, none of which contain B.Kod

[firebird-support] Weird query results - bug?

2013-01-18 Thread Kjell Rilbe
Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly): select B.* from Branschkod B inner join Branschkod B2 on B2.Namn = B.Namn where B.ECO_ID B2.ECO_ID Now, I add a line to the WHERE: select B.* from Branschkod B inner join Branschkod

Re: [firebird-support] Weird query results - bug?

2013-01-18 Thread Kjell Rilbe
Den 2013-01-18 12:56 skrev Kjell Rilbe såhär: Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly): select B.* from Branschkod B inner join Branschkod B2 on B2.Namn = B.Namn where B.ECO_ID B2.ECO_ID Now, I add a line to the

Re: [firebird-support] Weird query results - bug?

2013-01-18 Thread Gary Benade
On 1/18/2013 2:02 PM, Kjell Rilbe wrote: Den 2013-01-18 12:56 skrev Kjell Rilbe såhär: Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly): select B.* from Branschkod B inner join Branschkod B2 on B2.Namn = B.Namn where B.ECO_ID

RE: [firebird-support] Weird query results - bug?

2013-01-18 Thread Svein Erling Tysvær
Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly): select B.* from Branschkod B inner join Branschkod B2 on B2.Namn = B.Namn where B.ECO_ID B2.ECO_ID Now, I add a line to the WHERE: select B.* from Branschkod B inner join

Re: [firebird-support] Weird query results - bug?

2013-01-18 Thread Kjell Rilbe
Den 2013-01-18 13:30 skrev Gary Benade såhär: On 1/18/2013 2:02 PM, Kjell Rilbe wrote: Den 2013-01-18 12:56 skrev Kjell Rilbe såhär: Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly): select B.* from Branschkod B inner join

Re: [firebird-support] Weird query results - bug?

2013-01-18 Thread Kjell Rilbe
Den 2013-01-18 13:31 skrev Svein Erling Tysvær såhär: Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly): select B.* from Branschkod B inner join Branschkod B2 on B2.Namn = B.Namn where B.ECO_ID B2.ECO_ID Now, I add

Re: [firebird-support] Weird query results - bug?

2013-01-18 Thread Gary Benade
On 1/18/2013 2:48 PM, Kjell Rilbe wrote: Den 2013-01-18 13:30 skrev Gary Benade såhär: On 1/18/2013 2:02 PM, Kjell Rilbe wrote: Den 2013-01-18 12:56 skrev Kjell Rilbe såhär: Hi, This SQL returns 2533 records, none of which contain B.Kod starting with 1711 or 2111 (checked thoroughly):

[firebird-support] impossible behaviour ... FB bug ...or I need shaper eyes :)

2012-02-04 Thread peppepolpo
plainly said, an impossible thing is happening with a few simple stored procedures in FB 2.1 . I asked for paid help at http://www.vworker.com/RentACoder/misc/BidRequests/ShowBidRequest.asp?lngBidRequestId=1824928 If you want to help for free, you can download db and explanations from this

[firebird-support] Is this a bug in firebird .net provider?

2011-12-08 Thread firebirdsql
I have a table with a timestamp column in Firebird 2.5. The format for timestamps in Firebird is dd-MM- hh:mm:ss:f (microseconds). However, when the .net data provider is returning the column data, it doesn't send the microseconds. example: using(FbDataReader reader =

Re: [firebird-support] Is this a bug in firebird .net provider?

2011-12-08 Thread Mark Rotteveel
On Thu, 08 Dec 2011 13:53:43 -, firebirdsql firebird...@yahoo.com wrote: I have a table with a timestamp column in Firebird 2.5. The format for timestamps in Firebird is dd-MM- hh:mm:ss:f (microseconds). However, when the .net data provider is returning the column data, it