On 2021-09-01 15:40, Molnár Attila wrote:
Ok, I understand it's not "wrong", works as designed/intended. Just
put into documentation.
Also, how do you expect to people to leave dialect 1 when dialect 3
gives no benefit, in both dialect extra effort needed to get
calculations right, plain operation and funcation usage is not enought
to get correct results:
dialect 1 requires rounding everywhere because the everything is a
float
dialect 3 requires double precition cast and rounding in case of
division because of low precision/scale during calculation
A new dialect or a new option should do the job.
I think most Firebird users either have no problems with the
NUMERIC/DECIMAL behaviour in dialect 3, or have otherwise learned to
live with it over the past 21+ years.
The benefit of dialect 3 over dialect 1 is BIGINT, generators generating
values exceeding 2^31 - 1, actual NUMERIC/DECIMAL with precision over 9
(instead of a DOUBLE PRECISION with a NUMERIC/DECIMAL label slapped on),
TIME/DATE/TIMESTAMP vs DATE that is actually a TIMESTAMP, SQL standard
use of single quote for string literals, allowing quoted object names
(using double quotes), which allows you to have 1) case-sensitive
identifiers, and 2) use reserved words as identifiers. I may have missed
some more.
Personally, I consider the division behaviour of dialect 3 an
improvement over dialect 1, but on the other hand I think I hardly ever
use division in SQL.
Mark
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
