On 27-3-2018 16:12, Alex Peshkoff via Firebird-devel wrote:
On 03/27/18 14:32, Mark Rotteveel wrote:
On 26-3-2018 18:03, Alex Peshkoff via Firebird-devel wrote:
On 03/26/18 18:37, Mark Rotteveel wrote:
I just noticed that I should also have updated README.keywords in
https://github.com/FirebirdSQL/firebird/pull/150
But as I need to update it anyway, is it OK if I do a slightly more
thorough overhaul? I noticed that some of the words marked with *
are actually marked as (non-)reserved word in SQL:2016.
If not, which SQL standard was taken as a baseline?
In some old version (1.5? 2.0?) a lot of keywords were reserved.
Somewhere about 2.1 or 2.5 most of such reserved (in violation of any
standard) keywords were made non-reserved, as a baseline was taken
sql-2003 or 2008, but some keywords that caused massive conflicts
when getting non-reserved were left reserved. So we never exactly
followed some standard, just tried to get a bit closer to one.
Ok, thanks for the explanation.
Would it be OK if I update the *-marks for those keywords not
specified as reserved (or non-reserved) in SQL:2016?
And if you add missing fb4 keywords to it too.
Yes, I'll check if other keywords besides DECFLOAT need adding as well.
PS.
Usefulness of this file is suspicious for me. May be it's interesting
from histrical POV that keyword SKIP was added in 1.0 and made
non-reserved in 1.5 but I can hardly imagine any proctical use from it.
A list of keywords, mentioniong standard/extension &
reserverd/non-reserved, would be much more useful.
I actually find documentation like that very helpful when updating the
version-specific list of keywords for Jaybird (see
org.firebirdsql.jdbc.FirebirdVersionMetaData). I then still need to
compare against SQL:2003, as a JDBC driver needs to return only those
keywords not specified in SQL:2003.
Mark
--
Mark Rotteveel
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
