Re: [Firebird-docs] Is src/docs/refdocs/langref/langref25 safe to remove?
Mark, > Today I noticed that we have > src/docs/refdocs/langref/fblangref25 > and > src/docs/refdocs/langref/langref25 > The former seems to be the released Firebird 2.5 Language Reference, > while the latter seems to be an abandoned work-in-progress. Correct. > The presence > of both is a bit confusing. Yes. I suspect it happened when "whoever" transferred stuff from the old CMS. > Is it OK if I delete that last one > (src/docs/refdocs/langref/langref25)? Definitely. -- Best regards, Helenmailto:hele...@tpg.com.au -- This email has been checked for viruses by AVG. https://www.avg.com ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Missing 2.5.9 release notes in git
A couple of weeks ago Mark wrote > I just noticed that the release notes in git are still at 2.5.8. What > happened to the 2.5.9 release notes? Sorry for the delay replying. I have had a stroke with various negative effects that are not being rehabilitated very quickly. Working the github stuff is still defeating me. Can I send the updated 2.5.9 files to someone who could update the repository? Helen ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] German translation of ODBC/JDBC Driver manual
Brilliant job, Martin! Helen --- This email has been checked for viruses by AVG. https://www.avg.com ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] TEST:: Dumitru Rubey
I wrote: > Dumitru has indicated he is willing to translate some documentation to > Romanian. He has been trying to subscribe and has not had any kind of > feedback. Of course, under the privacy restrictions imposed last year > by Sourceforge, I can no longer check the subscriber list. > Dumitru, please reply to this message if you see it. Dumitru is seeing the messages now and will post when he is ready. Dumitru, there might be a short delay, as the first message from every new subscriber is held for moderation. I should receive a notification but I will watch from the admin interface for a few days, in case this Sourceforge hiccup is permanent. Helen -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] SourceForge CVS to GitHub migration done
Tuesday, November 28, 2017, 1:21:39 PM, PaulV wrote: > And this CHM file describes the ODBC driver? Yes, it's the same content as the PDF and the HTML with some edits to stop it exploding when you try to hit an external link. Oh, and about a zillion fewer Firebird logos. ;-) > So it naturally belongs to > the Fb-ODBC 2.0.5 documentation? Then I'd put the source files > - unzipped, for easier version control - in a subdir of refdocs/fbodbc205, > e.g. refdocs/fbodbc205/chm or whichever name you think is best. refdocs/fbodbc205/chm-source Helen -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] SourceForge CVS to GitHub migration done
Hello Mark, >> Next thing, I have source files for the build of the CHM file, for use >> with the M$ help compiler, all zipped up. Where should I put them? >> I'll write a little readme. > What are these CHM files for? You could consider just adding them > (unzipped) in a specific subfolder of the repository, or create a > separate repository for this. Ahm actually, I was asking PaulV that question...you may not be aware that we don't do CHM, but the ODBC fans seem to like them. Our DocBook system doesn't produce it but it turned out to be relatively simple to produce from the html that it does generate. I could probably produce VS help from them as well, some other time when I'm in an experimental frame of mind. Of course, both the CHM and VS help compilers are proprietary Microsoft products, so some might say it would be evil to encourage these people. ;-) So I was really just sounding out Paul as to where he thought might be a good place to put the source files for the CHM file - obviously (I thought) *where?* relative to the parent docbook source from which they evolved. A different repository does not make any sense. Tainted or not, it is still Firebird documentation. Helen -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] SourceForge CVS to GitHub migration done
Monday, November 13, 2017, 12:03:31 AM, Mark wrote: > The migration from SourceForge CVS to GitHub has been completed. The > repository is at > https://github.com/FirebirdSQL/firebird-documentation > (with clone URL > g...@github.com:FirebirdSQL/firebird-documentation.git or > https://github.com/FirebirdSQL/firebird-documentation.git ) > If there are any problems or questions, let me know. Over the weekend I did some commits. a few things: Paul, when you have a moment, could you look at what I did: 1. Created a new../refdocs/images subdir, currently containing the images for the ODBC manual. 2. Created a new ../refdocs/fbodbc205 directory containing the source for the ODBC manual. 3. Added fbodbc205 to refdocs.xml. I did all this with pushing from my local repo. Actually I had to do a minor update today as I'd left something out, so the commit messages don't all reflect what I did yesterday. ;-) Next thing, I have source files for the build of the CHM file, for use with the M$ help compiler, all zipped up. Where should I put them? I'll write a little readme. The other thing is - we don't seem to have a notification channel for checkins to this repository. Can something similar be done for this one as was done for the main Firebird repo? (After a lot of messing about, we finally got main repo notifications coming into firebird-checkins a few weeks ago. I'm not sure they are perfect yet, though) I'll need to do another lot, for the Developer's Guide, when I get the go-ahead from Denis. It's good to go Beta for reviewing, as far as I'm concerned, but I understand Denis still has a meaty job to do translating his source code downloads. That doesn't affect the production of the book at all, except that every chapter ends with a link to the respective source code pack and they are all at some stage of being re-done. I haven't heard from Denis for a couple of weeks, so I don't know exactly where we're at. If anyone is interested in taking a browse through the PDF or the HTML, the latest builds are in my repository at https://github.com/helebor/fbmanuals in the /dist subdirectory. Note that gitHub's PDF browser is not crash-hot; it's better to download it when the Download button appears. Helen -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Test repository CVS to git migration
Sunday, November 5, 2017, 1:42:35 AM, Mark wrote: >>> So what are the next steps? > I'm waiting on Helen to give the final go. Actually, I was waiting to see some comment from Paul V. I still seem to have one or two novice issues on this side but they are not showstoppers. Over the weekend I cloned the #4 test and used it to create a private local/remote repository for the Developer's Guide stuff, as I am using a couple of experimental changes to the build ingredients. All is well, so far, I think. It will be a while before I need to push anything to the main repo. I don't think it will be too much of a problem to do that "with rule-book in hand" and Google alongside. Hats off to you for your efforts with this and the other CVS repo's, Mark! Cheers, Helen -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Test repository CVS to git migration
Hello Mark, Monday, October 16, 2017, 3:41:43 AM, you wrote: > I have made a few more test runs, the end result is in > https://github.com/mrotteveel/test-firebird-documentation-3 > I think this would be the final run. > Difference against yesterday: > - Removed the d_jencks branch > - Added a .gitignore to ignore build files > - Added a .gitattributes with sane defaults for the project > As to the problem with line-endings, yesterday I looked cross-eyed, and > the problem with the four files were actual in reverse, they had LF in > CVS and CRLF in git. I have managed to normalize these files so future > updates to these files should not cause a large-scale whitespace update. I downloaded the zip from your repository and looked at a few of the .docbook files from the v.3.0.2 release notes with the editor I use for creating and updating them. They look OK to me. The ReadMe file in the base directory has messed-up line-endings, though. I guess we'll need to test what happens when one of the (currently good) source files gets updated. We definitely cannot do with extraneous white space in those files. Using the Github Desktop, I couldn't access the local copy of the unpacked zipfile but I cloned a new repository off it, which created the three git config files. It didn't copy anything else, so I file-copied all of the unpacked filesystem (except the git configuration files) into it. That sort of worked and it was able to link back to your github repository and log me in from the local config. I'm sure that's not how it's done but at least I am comfortable with the migrated file formats and filesystem structure, so far. It looks possible that I will be able to sync the working source files with the git ones, much as I was doing with CVS and SVN. Helen -- Kind regards, Helen Borrie -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] ATTN committers: SourceForge to terminate CVS support on November 30th
Thursday, October 12, 2017, 12:59:11 AM, Paul V. wrote: > Hi all, > Three people - one of them a committer - have expressed their preference > for moving to GitHub. > I have no problem with that, but I would also like to hear Helen's opinion, > as she is the heaviest user of the manual module. I guess I have to say (to quote my ex-Navy husband) "that's life in a blue suit." My preference would have been to convert to SVN and leave the repository on Sourceforge - don't fix what aint broke. But Github seems to dominate our (project) lives these days. Currently, with the CVS and SVN clients I use - necessarily on Windows, since our doc app is Windows-based - I can commit, check out, etc. from a right click on the /manual/ subdir, or any subdir beneath it. Given that I'm committing to multiple projects, this is a blessing that I will miss badly. After all these months with the core project on GitHub, I have yet to succeed in downloading the repository AT ALL to access the readme files in the core tree for use in the release notes. I have to rely on Dmitry sending me a link, from which I can view a file and copy/paste it into my local resource directory for that version. As for code control, I currently keep two copies of the /manual/ branch: one for working on and the other which I sync with the working one before committing. I have no idea how I will manage with the Github thing. Any docs I have read so far (and I have not tried in recent months) assumes that one is working on the entire source code tree. I do NOT want to keep a current copy of the entire tree. To consult core source code, it is simple for me to find what I want in the repository and copy/paste it, since I never commit changes to that code. I guess I just have to work something out. This is about the worst week Mark could have picked, from my POV, as I'm already burning the midnight oil on other project infrastructure problems and TRYING (in conjunction with Denis Simonov) to sort out the Ringlish translation of the FB Developer's Guide. Note that Denis will have to be "in" on any changes as, this time around, he is planning to convert the Word text to DocBook himself and (presumably) commit the DocBook source once he has built it successfully. Amongst other things, he has quite a number of screenshots there which, of course, are binary files. I have no idea how GH deals with image files but I guess we are going to find out soon enough. I can't walk him through it myself, since I am clueless about how it's going to work. Helen -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] What chapter to translate next?
Hello Martin, Saturday, May 13, 2017, 12:37:02 AM, you wrote: > Hi, > > I’ve committed the fblangref25-commons-de chapter to the manual > module. Which of the following is ready for translation? > > - DDL > - DML > - PSQL > - Security > - Transacs > Consider all of them ready. There has been no further reviewing since Aage Johansen died last year so let's assume that what we have is perfect. ;-) When I get time, I'll do the final editing on the source to remove the comments about review status. For now, assume they are already gone. Helen -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Consider migrating to GitHub?
On 18/12/2016 11:48:34 AM, Paul Vinkenoog <p...@vinkenoog.nl> wrote: Mark Rotteveel wrote: > Isn't it time to consider migrating the documentation repository from > SourceForge CVS to GitHub? > > SourceForge itself considers CVS deprecated, and having the repository > on GitHub might increase visibility and will likely lower the barrier > for contribution. Helen Borrie: I don't see how moving the source from one obscure repository to a different obscure repository would heighten visibility or lower any barrier. If there's a good reason to change, I'd go with it, albeit it currently aint broke so there be nothing to fix. PaulV has it nicely set up for use by the translators and it is all well documented, enough so that those of us who actually DO stuff regularly, rather than just talk about doing it, have our local setups that are more or less automated. One of us can always step in to assist people who don't want to work with a repository for whatever reason. I don't see how changing the repository would (or should) alter that. My personal experience so far with GitHub is that it is a dog to work with, actually, given that I don't upload or download any programming code, only documentation. I guess if I had to, I'd find a way to make it useful for me to use. I just can't think of a good reason right now to spend time and energy on creating a solution to a non-existent problem. Helen -- Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] [Firebird-checkins] manual/src/docs/refdocs/langref/fblangref25 fblangref25-datatypes.xml, 1.6, 1.7 fblangref25.xml, 1.22, 1.23
Update of /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25 In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv16889 Modified Files: fblangref25-datatypes.xml fblangref25.xml Log Message: Corrected text for floating-point data types (Build 0.906) Index: fblangref25-datatypes.xml === RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-datatypes.xml,v retrieving revision 1.6 retrieving revision 1.7 diff -u -d -r1.6 -r1.7 --- fblangref25-datatypes.xml 27 Mar 2016 21:20:47 - 1.6 +++ fblangref25-datatypes.xml 11 Aug 2016 08:52:46 - 1.7 @@ -262,9 +262,9 @@ Floating-Point Data Types -Floating-point data types are examples of data stored in the DBMS with the precision matching the -scale of the number. FLOAT and DOUBLE PRECISION (DOUBLE) -are examples. +Floating point data types are stored in an IEEE 754 binary format that comprises sign, +exponent and mantissa. Precision is dynamic, corresponding to the physical storage format of +the value, which is exactly 4 bytes for the FLOAT type and 8 bytes for DOUBLE PRECISION. Considering the peculiarities of storing floating-point numbers in a database, these data types are not recommended for storing monetary data. For the same reasons, columns with floating-point data are not recommended for use as keys or to have uniqueness constraints applied to them. Index: fblangref25.xml === RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25.xml,v retrieving revision 1.22 retrieving revision 1.23 diff -u -d -r1.22 -r1.23 --- fblangref25.xml 13 May 2016 10:14:26 - 1.22 +++ fblangref25.xml 11 Aug 2016 08:52:46 - 1.23 @@ -5,7 +5,7 @@ Firebird 2.5 Language Reference Beta Release 1 -12 May 2016, document version 0.905 +11 August 2016, document version 0.906 Dmitry -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://sdm.link/zohodev2dev ___ Firebird-checkins mailing list firebird-check...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-checkins -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://sdm.link/zohodev2dev ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Scale of number and precision on floating data types
Hello Martin, Thursday, August 11, 2016, 6:00:52 PM, you wrote: > The wording is OK. I will use it. Did you catch Dmitry's correction? > -Ursprüngliche Nachricht- > Von: Dmitry Yemanov [mailto:firebi...@yandex.ru] > Gesendet: Donnerstag, 11. August 2016 07:19 > An: Chatter regarding Firebird documentation > Betreff: Re: [Firebird-docs] Scale of number and precision on floating data > types > 11.08.2016 06:38, Helen Borrie wrote: >> >> Floating point data types are stored in an IEEE 754 binary format that >> comprises sign, exponent and mantissa. Precision is dynamic, >> corresponding to the physical storage format of the value, which may >> be up to 4 bytes for the FLOAT type and up to 8 bytes for DOUBLE >> PRECISION. > It's exactly either 4 or 8 bytes, not "up to". > Dmitry > -- > What NetFlow Analyzer can do for you? Monitors network bandwidth > and traffic patterns at an interface-level. Reveals which users, > apps, and protocols are consuming the most bandwidth. Provides > multi-vendor support for NetFlow, J-Flow, sFlow and other flows. > Make informed decisions using capacity planning reports. > http://sdm.link/zohodev2dev > ___ > Firebird-docs mailing list > Firebird-docs@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-docs > -- > What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic > patterns at an interface-level. Reveals which users, apps, and protocols are > consuming the most bandwidth. Provides multi-vendor support for NetFlow, > J-Flow, sFlow and other flows. Make informed decisions using capacity > planning reports. http://sdm.link/zohodev2dev > ___ > Firebird-docs mailing list > Firebird-docs@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-docs -- Kind regards, Helen Borrie -- What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic patterns at an interface-level. Reveals which users, apps, and protocols are consuming the most bandwidth. Provides multi-vendor support for NetFlow, J-Flow, sFlow and other flows. Make informed decisions using capacity planning reports. http://sdm.link/zohodev2dev ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Scale of number and precision on floating data types
Hello Dmitry,
Thursday, August 11, 2016, 9:42:48 AM, you wrote:
> Nope, floating point numbers are stored completely different to the
> fixed point numbers. FLOAT is single-precision format which occupies 4
> bytes. DOUBLE is double-precision format which occupies 8 bytes. But
> they have no relationship to INT/BIGINT despite the byte size (4/8
> bytes), the binary layout is different (see IEEE 754) and it embeds
> {sign, exponent, mantissa}.
> I suppose the intended meaning was something like: floating point data
> types represent data stored in the database with the dynamic precision
> corresponding its storage format (physical size of the value).
OK...how about this wording to substitute for the troublesome
translation:
"
Floating point data types are stored in an IEEE 754 binary format that
comprises sign, exponent and mantissa. Precision is dynamic,
corresponding to the physical storage format of the value, which may
be up to 4 bytes for the FLOAT type and up to 8 bytes for DOUBLE
PRECISION.
"
I would be loath to mention "scale" at all as it is not relevant for
floating-point types.
Comments? Enhancements? Martin, if that wording between the quotes
is a correct interpretation, would it work for your translation?
Helen
--
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are
consuming the most bandwidth. Provides multi-vendor support for NetFlow,
J-Flow, sFlow and other flows. Make informed decisions using capacity
planning reports. http://sdm.link/zohodev2dev
___
Firebird-docs mailing list
Firebird-docs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] Martin Koeditz (OFF-TOPIC POST)
Martin, your mail server is rejecting all my attempts to send you an email, from this address and 5 others! The rejection message in all cases is 5.3.0 - Other mail system problem 550-'5.7.1 Message rejected as spam by Content Filtering.' Is there some way you can whitelist at least this one? (hele...@iinet.net.au) Thanks! Helen -- ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] Translators: FbLangRef25 latest corrections
To translators: I just redirected the CVS notification regarding the latest batch of corrections in fblangref25-commons.xml and fblangref25-functions-vars.xml. In both cases, these are files that are marked as already reviewed. New builds (doc version 0.905) of both PDF and HTML are on the web site. The HTML was built using the new version of the stylesheet with the sub-TOCs. Cheers, Helen -- Mobile security can be enabling, not merely restricting. Employees who bring their own devices (BYOD) to work are irked by the imposition of MDM restrictions. Mobile Device Manager Plus allows you to control only the apps on BYO-devices by containerizing them, leaving personal data untouched! https://ad.doubleclick.net/ddm/clk/304595813;131938128;j ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] [Firebird-checkins] manual/src/docs/refdocs/langref/fblangref25 fblangref25-commons.xml, 1.8, 1.9 fblangref25-functions-vars.xml, 1.5, 1.6 fblangref25.xml, 1.21, 1.22
Update of /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25 In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv23534 Modified Files: fblangref25-commons.xml fblangref25-functions-vars.xml fblangref25.xml Log Message: Corrections from P. Vinkenoog and D. Simonov. Index: fblangref25-functions-vars.xml === RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-functions-vars.xml,v retrieving revision 1.5 retrieving revision 1.6 diff -u -d -r1.5 -r1.6 --- fblangref25-functions-vars.xml 27 Mar 2016 21:20:48 - 1.5 +++ fblangref25-functions-vars.xml 13 May 2016 10:14:26 - 1.6 @@ -5085,7 +5085,7 @@ Syntax - BIN_AND (number [, number ...]) + BIN_AND (number, number [, number ...]) @@ -5103,15 +5103,19 @@ number - A 32-bit or 64-bit integer + Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0) Result type - INTEGER or BIGINT + SMALLINT, INTEGER or BIGINT + + SMALLINT result is returned only if all the arguments are explicit SMALLINTs or NUMERIC(n, 0) +with n = 4; otherwise small integers return an INTEGER result. + Description Returns the result of the bitwise AND operation on the argument(s). @@ -5133,8 +5137,7 @@ Possible name conflict -YESRead details - +NO @@ -5159,19 +5162,23 @@ number - A 32-bit or 64-bit integer + Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0) Result type - INTEGER or BIGINT + SMALLINT, INTEGER or BIGINT + + SMALLINT result is returned only if all the arguments are explicit SMALLINTs or NUMERIC(n, 0) +with n = 4; otherwise small integers return an INTEGER result. + Description - Returns the result of the bitwise NOT operation on the argument, i.e., negation, -or ones complement. + Returns the result of the bitwise NOT operation on the argument, i.e., +ones complement. See also @@ -5196,7 +5203,7 @@ Syntax - BIN_OR (number [, number ...]) + BIN_OR (number, number [, number ...]) @@ -5214,15 +5221,19 @@ number - A number of an integer type + Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0) Result type - INTEGER or BIGINT + SMALLINT, INTEGER or BIGINT + + SMALLINT result is returned only if all the arguments are explicit SMALLINTs or NUMERIC(n, 0) +with n = 4; otherwise small integers return an INTEGER result. + Description Returns the result of the bitwise OR operation on the argument(s). @@ -5365,7 +5376,7 @@ Syntax - BIN_XOR (number [, number ...]) + BIN_XOR (number, number [, number ...]) @@ -5383,7 +5394,7 @@ number - A number of an integer type + Any integer number (literal, smallint/integer/bigint, numeric/decimal with scale 0) @@ -5394,8 +5405,12 @@ Result type - INTEGER or BIGINT + SMALLINT, INTEGER or BIGINT + + SMALLINT result is returned only if all the arguments are explicit SMALLINTs or NUMERIC(n, 0) +with
Re: [Firebird-docs] Improve TOC and searchability of Firebird Language Reference
Hello Paul, Wednesday, May 11, 2016, 1:03:39 AM, you wrote: > Helen wrote: > But notice that the (local) changes I made only apply to multipage HTML. > Of course we can do the same for monohtml (as you use for the rlsnotes), > but we can also leave that build as-is or make other adjustments. I've stopped using monohtml for release notes - so far, only the FB3 notes are multi-page but I have set up places in the web structure for the others, when I get around to building them. The reason for this is the lack of breadcrumbs in the monohtml. > PDF is very different and already has the navigation pane, so local > ToCs are probably less useful there. However, we can do it if we want. > I've added a PDF with chapter ToCs to the above page as an example. Actually, the PDF bookmarks do the job efficiently, without resorting to sub-TOCs - "not broke, don't fix" would be a good strategy, methinks. > I'll commit the '2-2-2' variant then for now. But shall I do it just for > the refdocs set or for all our HTML docs? It would likely make a big mess of release notes as, since v.2.0, AFAIR, the DDL and DML sections have a hard-coded "TOC" at the beginning of each of those chapters, anyway. I am loath to start mucking around with the sources of older release notes, which would put them out of synch with the translations. As for the other docs, I haven't worked with the sources of them. Perhaps Norm would like to comment. Helen -- Mobile security can be enabling, not merely restricting. Employees who bring their own devices (BYOD) to work are irked by the imposition of MDM restrictions. Mobile Device Manager Plus allows you to control only the apps on BYO-devices by containerizing them, leaving personal data untouched! https://ad.doubleclick.net/ddm/clk/304595813;131938128;j ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Improve TOC and searchability of Firebird Language Reference
Hello Paul, Monday, May 9, 2016, 12:08:27 AM, you wrote: > My preference would be the second variant (2 - 2 - 2), where no ToC > has more than 2 levels and section ToCs are single-level. Since each > top-level section has its own page, having a multilevel ToC at the > top is not very useful IMO, as the subsections are on the same page > and have their own ToCs. I prefer the second version too. It uses a bit more real estate but it means one doesn't have to keep reverting to the top-level TOC if browsing for a specific function while not knowing exactly the one you want. I guess time will tell, once we see the feature in action with the whole book and in the PDF. Got your corrections for the BIN* functions, thanks. I will probably defer a new build until I have the new template on board. Helen -- Mobile security can be enabling, not merely restricting. Employees who bring their own devices (BYOD) to work are irked by the imposition of MDM restrictions. Mobile Device Manager Plus allows you to control only the apps on BYO-devices by containerizing them, leaving personal data untouched! https://ad.doubleclick.net/ddm/clk/304595813;131938128;j ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] FbLangRef25 Translators & Reviewers
To those currently reviewing and translating the Language Reference, I have put up new PDF and HTML builds today - build 0.904 - and have updated the sources in CVS - see the diff file I sent to the list. These are small changes in the DDL and Commons chapters but they are in sections that are marked as "already reviewed". Cheers, Helen -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! https://ad.doubleclick.net/ddm/clk/302982198;130105516;z ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] [Firebird-checkins] manual/src/docs/refdocs/langref/fblangref25 fblangref25-commons.xml, 1.7, 1.8 fblangref25-ddl.xml, 1.10, 1.11 fblangref25.xml, 1.20, 1.21
Update of /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25 In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv24351 Modified Files: fblangref25-commons.xml fblangref25-ddl.xml fblangref25.xml Log Message: Another batch of suggested edits from Aage Johansen Index: fblangref25-commons.xml === RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-commons.xml,v retrieving revision 1.7 retrieving revision 1.8 diff -u -d -r1.7 -r1.8 --- fblangref25-commons.xml 28 Mar 2016 19:03:03 - 1.7 +++ fblangref25-commons.xml 26 Apr 2016 22:38:33 - 1.8 @@ -928,6 +928,12 @@ + + +Note about String Comparison +When CHAR and VARCHAR fields are compared for +equality, trailing spaces are ignored in all cases. + Other Comparison Predicates Index: fblangref25-ddl.xml === RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-ddl.xml,v retrieving revision 1.10 retrieving revision 1.11 diff -u -d -r1.10 -r1.11 --- fblangref25-ddl.xml 27 Mar 2016 21:20:47 - 1.10 +++ fblangref25-ddl.xml 26 Apr 2016 22:38:33 - 1.11 @@ -1792,13 +1792,13 @@ - Constraints - Four types of constraints can be specified. They are: - -Primary key (PRIMARY KEY) -Unique key (UNIQUE) -Foreign key (REFERENCES) -CHECK constraint (CHECK) +Constraints +Four types of constraints can be specified. They are: + + Primary key (PRIMARY KEY) + Unique key (UNIQUE) + Foreign key (REFERENCES) + CHECK constraint (CHECK) Constraints can be specified at column level (column constraints) @@ -1809,7 +1809,7 @@ whether the constraint is being defined at column or table level. A column-level constraint is specified during a column definition, after -all column attributes except COLLATION are specified, and can +all column attributes except COLLATION are specified, and can involve only the column specified in that definition Table-level constraints are specified after all of the column definitions. They are a more flexible way to set constraints, since they can cater for constraints @@ -1821,32 +1821,46 @@ The system automatically creates the corresponding index for a primary key (PRIMARY KEY), a unique key (UNIQUE) and a foreign key (REFERENCES for a column-level constraint, FOREIGN -KEY REFERENCES for one at the table level). If the name of the constraint is -specified, the automatically created index will have this name (if there is no explicit -USING clause). +KEY REFERENCES for one at the table level). - - The USING Clause - The USING clause allows you to specify a user-defined name for the index that is - created automatically and, optionally, to define the direction of the indexeither - ascending (the default) or descending. - + + Names for Constraints and Their Indexes + Column-level constraints and their indexes are named automatically: + + The constraint name has the form INTEG_n, where + nrepresents one or more numerals + The index name has the form RDB$PRIMARYn (for a + primary key index), RDB$FOREIGNn (for a foreign key index) + or RDB$n (for a unique key index). Again, n + represents one or more numerals + + + Automatic naming of table-level constraints and their indexes follows the same + pattern, unless the names are supplied explicitly. -If the constraint specification clause does not define a name for a constraint, -the DBMS will generate one for it automatically. However, you can specify a name for -any constraint. + +Named Constraints +A constraint can be named explicitly if the CONSTRAINT clause +is used for its definition. While the CONSTRAINT clause is optional +for defining column-level constraints, it is mandatory for table-level. By default, the +constraint index will have the same name as the constraint. If a different name is wanted +for the constraint index, a USING clause can be included. + - - Named Constraints - The optional CONSTRAINT clause defines the name of a - constraint. - + +The USING Clause +The USING clause allows you to
Re: [Firebird-docs] LangRef 2.5beta1 - a few more suggestions /5
Hello Aage, Monday, April 11, 2016, 6:23:52 AM, you wrote: > I'll have mostly non-Firebird things on my mind the next week, so I'm > just unloading my latest comments now! Hope it goes well for you Aage! I'm not ignoring your suggestions, just a bit swamped at the moment with customer work and Fb 3 release. Thanks again! Kia ora, Helen -- Find and fix application performance issues faster with Applications Manager Applications Manager provides deep performance insights into multiple tiers of your business applications. It resolves application problems quickly and reduces your MTTR. Get your free trial! http://pubads.g.doubleclick.net/ gampad/clk?id=1444514301=/ca-pub-7940484522588532 ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] LangRef 2.5beta1 - a few suggestions /3
Hello Aage, Friday, April 1, 2016, 10:28:51 AM, you wrote: > p.97 > Table 5.8. ALTER TABLE Statement Parameters > The pagebreak reveal an akward split between the parameter > 'collation" and its description. > This may be a pdf artifact, but I'm using "Adobe Acrobat Reader DC, > 2015 Release | Version 2015.010.20660". No, it's not a "PDF artifact" but the way the formatter handles vertical alignment in table rows. That is, it's not your reader that has the problem, but the PDF itself. I've changed the VI for that row to "bottom". Let's see in the next build whether that improves anything. Thanks. Hope you're recovering well from whatever landed you in the Big House! Cheers, Helen -- ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] [Firebird-checkins] manual/src/docs/refdocs/langref/fblangref25 fblangref25-commons.xml, 1.6, 1.7 fblangref25.xml, 1.19, 1.20
Update of /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25 In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv7265 Modified Files: fblangref25-commons.xml fblangref25.xml Log Message: Added a correction to arithmetic operator predence. Index: fblangref25-commons.xml === RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-commons.xml,v retrieving revision 1.6 retrieving revision 1.7 diff -u -d -r1.6 -r1.7 --- fblangref25-commons.xml 27 Mar 2016 21:20:47 - 1.6 +++ fblangref25-commons.xml 28 Mar 2016 19:03:03 - 1.7 @@ -403,17 +403,17 @@ / Division - 2 + 1 + Addition - 3 + 2 - Subtraction - 4 + 2 @@ -425,6 +425,10 @@ SET A = 4 + 1/(B-C)*D + +Where operators have the same precedence, they are evaluated in +left-to-right sequence. + Index: fblangref25.xml === RCS file: /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25.xml,v retrieving revision 1.19 retrieving revision 1.20 diff -u -d -r1.19 -r1.20 --- fblangref25.xml 27 Mar 2016 21:20:48 - 1.19 +++ fblangref25.xml 28 Mar 2016 19:03:03 - 1.20 @@ -5,7 +5,7 @@ Firebird 2.5 Language Reference Beta Release 1 -26 March 2016, document version 0.902 +29 March 2016, document version 0.903 Dmitry -- Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785471=/4140 ___ Firebird-checkins mailing list firebird-check...@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-checkins -- Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785471=/4140 ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] FbLangRef Build 0.902
Martin, Is there some way you can parse those "diffs" notifications from CVS to make them useful for your translation team's SVN? Helen -- Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140 ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] [Firebird-checkins] manual/src/docs/refdocs/langref/fblangref25 fblangref25-commons.xml, 1.5, 1.6 fblangref25-datatypes.xml, 1.5, 1.6 fblangref25-ddl.xml, 1.9, 1.10 fblangref25-functio
Update of /cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25
In directory sfp-cvs-1.v30.ch3.sourceforge.com:/tmp/cvs-serv17868
Modified Files:
fblangref25-commons.xml fblangref25-datatypes.xml
fblangref25-ddl.xml fblangref25-functions-vars.xml
fblangref25-structure.xml fblangref25.xml
Log Message:
Corrections and additions from reviewers Feb/Mar 2016. Translators please pick
up details of changes in firebird-docs.
Index: fblangref25-functions-vars.xml
===
RCS file:
/cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-functions-vars.xml,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -d -r1.4 -r1.5
--- fblangref25-functions-vars.xml 26 Jan 2016 21:01:21 - 1.4
+++ fblangref25-functions-vars.xml 27 Mar 2016 21:20:48 - 1.5
@@ -2,7 +2,7 @@
- Built-in functions and variables
+ Built-in functions and Variables
Index: fblangref25-commons.xml
===
RCS file:
/cvsroot/firebird/manual/src/docs/refdocs/langref/fblangref25/fblangref25-commons.xml,v
retrieving revision 1.5
retrieving revision 1.6
diff -u -d -r1.5 -r1.6
--- fblangref25-commons.xml 2 Feb 2016 21:10:21 - 1.5
+++ fblangref25-commons.xml 27 Mar 2016 21:20:47 - 1.6
@@ -5,7 +5,8 @@
Common Language Elements
This chapter covers the elements that are common throughout the
implementation of the
SQL languagethe expressions that are used to
extract and operate
-on facts from data and the predicates that test the
truth of those facts.
+on assertions about data and the predicates that
test the truth of those
+assertions.
Expressions
SQL expressions provide formal methods for evaluating, transforming
and comparing
@@ -34,7 +35,10 @@
Array element
-An expression may contain a reference to an
array element
+An expression may contain a reference to an
array member
+i.e., array_name[s],
+where s is the subscript of the member
in the array
+array_name
Arithmetic operators
@@ -81,7 +85,8 @@
Context variable
-An internally-defined context variable
+An internally-defined context
+variable
Local variable
@@ -118,13 +123,13 @@
Parentheses
Bracket pairs () used to group
expressions.
Operations inside the parentheses are performed before operations
outside them. When
-embedded parentheses are used, the most deeply embedded
expressions are evaluated
-first and then the evaluations move outward through the levels of
embedding
+nested parentheses are used, the most deeply nested expressions
are evaluated
+first and then the evaluations move outward through the levels of
nesting.
COLLATE clause
-Clause applied to CHAR and VARCHAR types to
specify the collation
-sequence to use in string comparisons
+Clause applied to CHAR and VARCHAR types to
specify the
+character-set-specific collation sequence to use in string
comparisons
NEXT VALUE FOR
sequence
@@ -161,6 +166,54 @@
The character set of a string constant is assumed to be the same
as the character set of
its destined storage.
+
+
+ String Constants in Hexadecimal Notation
+ From Firebird 2.5 forward, string literals can be entered in
hexadecimal notation,
+ so-called binary strings. Each pair of hex digits
defines one byte in
+ the string. Strings entered this way will have character set
OCTETS
+ by default but the introducer
+ syntax can be used to force a string to be
interpreted as another character set.
+
+Syntax
+
+
+{x|X}'hexstring'
+
+ hexstring> ::= an even number of
hexdigit
+ hexdigit ::= one of 0..9, A..F, a..f
+
+
+
+
+
+Examples
+
+select x'4E657276656E' from rdb$database
+ -- returns 4E657276656E, a 6-byte 'binary' string
+
+select _ascii x'4E657276656E' from rdb$database
+ -- returns 'Nerven' (same string, now interpreted as ASCII text)
+
+select _iso8859_1 x'53E46765' from rdb$database
+ -- returns 'Sge' (4 chars, 4 bytes)
+
+select _utf8 x'53C3A46765' from rdb$database
+ -- returns 'Sge' (4 chars, 5 bytes)
+
+
+
+Notes
+The client interface determines how binary strings are
displayed to the user.
+The isql
Re: [Firebird-docs] Getting started
Monday, March 21, 2016, 11:37:52 PM, Paul V. wrote: What I wrote: >> DML up to and including PROCEDURE has been done. Just the small >> objects remain, starting from PDF page 151 (pagination P. 137) at the >> EXTERNAL FUNCTION section. Paul corrected: > That's DDL up to and including PROCEDURE. Oops, sorry for that. DDL (Data Definition Language), i.e., Chapter 5. Helen -- Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140 ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Getting started
Hello james, Monday, March 21, 2016, 6:33:36 PM, you wrote: > >Hello Martin, Paul, Helen, and Mark. > I downloaded the latest version of the beta > Firebird_Language_Reference_25EN.pdf. I will begin by reviewing the > DML, PSQL and Functions chapters. DML up to and including PROCEDURE has been done. Just the small objects remain, starting from PDF page 151 (pagination P. 137) at the EXTERNAL FUNCTION section. > will review the InterBase6.0 beta LangRef If you mean "review for correctness, etc." then forget this one. It is about 16 years old and has never been updated in the Firebird era. > and the Firebird 2.5 LangRef. This is the one. It is a total replacement for the old InterBase LangRef and all of the Firebird LangRef Update volumes. Cheers, Helen -- Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785351=/4140 ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Hello from Seattle, WA
Hello James, Friday, March 18, 2016, 6:26:32 PM, you wrote: As others said already, your assistance would be very welcome. Paul Vinkenoog is the project's Docs coordinator. He's also one of our most prolific author/editors. At the moment, we have an urgent need for native speakers of English to complete the review of the Fb 2.5 Language Reference. If you could find time to go over the DML, PSQL and Functions chapters (any or all), you would be doing a great service. Some of the DDL chapter (as annotated) still remains to do, as well. It would be beneficial to take this opportunity to do a bit of recap. I'm coordinating this part of this project. What has worked well for the review so far is for the reviewer to keep a text file containing the existing text and his suggestions for improvements, corrections, et al. It is easiest to work with the PDF, quoting PDF page numbers and the immediate heading. Paul and Mark have been sending these files directly to me (hele...@iinet.net.au). For pieces that have already been reviewed, people just post the corrections directly to this list. As I complete a list of changes/reviews, I am posting the latest Docbook source to CVS and building a fresh set of PDF and HTML output to update the Docs at the web site. I hope to have a fresh build ready this weekend, touch wood. The released source code will become the base version for translations and future updates. Martin Koeditz and his colleagues have already begun the German, I believe. I think Tsutomu Hayashi is standing by to start on the Japanese. Dennis Simonov is translating back into Russian, with the Fb3 version in his sights. (The current Fb 2.5 text originated in Russian but not in Docbook format.) We're all volunteers in this team - so we do what we can, when we can. Kind regards, Helen -- Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785231=/4140 ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Publishing process of the FB LangRef translations
Hello Martin, Wednesday, March 16, 2016, 3:21:15 AM, you wrote: > How do we want to go on with the translated texts of the langref? > Should I translate the complete langref first or do we want to publish > finished sections? I think it is safe to proceed with translating the chapters and sections that have already been reviewed by Paul and Mark. That said, a few "tweaks" affecting those parts have been appearing. For example, I have a small list from Aage that will appear in the next update. > > Just for interest: > > Is there a script or something else refreshing the docs > automatically at night? Will they be updated after someone pushes > changed contents to the SVN repository? The Docs sources are in the CVS repository, not SVN. So far, the changes since the first Beta have been minimal and I have been re-posting the change report here. That tells you which file has changed and shows the old and new text. I am the only one pushing changes in the English sources. I am not tracking anyone else's changes and I hope I don't need to, whilst the langref is still in Beta. If a translator finds something missing or wrong in the checked sections, it is very important that you report it here so that the English source can be amended and all the other translators know about it. Note, also, that the publication date and the document version change whenever I push an updated version. That shows up in one or more of the CVS reports and also in the PDF, of course. The file that contains that information is fblangref25.xml. That is how is goes, for now. I am open to any better ideas Helen -- Transform Data into Opportunity. Accelerate data analysis in your applications with Intel Data Analytics Acceleration Library. Click to learn more. http://pubads.g.doubleclick.net/gampad/clk?id=278785231=/4140 ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Langref - Expressions/Constant
Title: Re: [Firebird-docs] Langref - Expressions/Constant Tuesday, February 2, 2016, 8:29:57 PM, Michal Ziemsk wrote: Column name _expression_: - Firebird converts table/column names to upper case internally. I think this should be explicitly stated as it's, I believe, failrly unique to firebird - double quotes can be used to make the field case sensitive and allow for some wild characters inside the symbol (spaces, parentheses and so on) - it'd be convenient to state which characters are allowed in a symbol name and which are allowed in a quoted symbol name Did you miss the section "Identifiers" in Chapter 2? (pdf p. 22). HB -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] [] Firebird 2.5 Language Reference Beta 1
In {firebird-devel] liviuslivius wrote:
Hi,
i do not know if this is good place to but:
on page 49 is:
"If you need to do a case-insensitive search for something enclosed inside a
string ( LIKE '%Abc%' ), use of the CONTAINING predicate is recommended, in
preference to the LIKE predicate."
and on page 50 is:
"A CONTAINING search is case-sensitive"
i am confused by "case-insensitive" and "case-sensitive" here
regards,
Karol Bieniaszewski
Good catch - should be "is NOT case-sensitive"
Helen
--
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140
___
Firebird-docs mailing list
Firebird-docs@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Langref - Expressions/Constant
Title: Re: [Firebird-docs] Langref - Expressions/Constant Hello , Monday, February 1, 2016, 8:25:55 PM, Michał Ziemski wrote: Hi! I've been going through the beta langref. In fblangref25-commons-expressions there is a description for "Constant": "A number; or a string literal enclosed in apostrophes" This should also include string literat with encoding provided, like: _utf8 'abc123' or _win1250 'abc123' The "introducer syntax" for forcing the character set of string literals is actually discussed in the DML chapter, under the INSERT statement. However, I agree with you, it should be in the "Common Elements", since it is not restricted to INSERT statements. Other discussions should link to that. It would be also helpful to expand somewhat on constant number format that - dot is the decimal spearator - exponential notation is supproted (like 2.3e-5) Amazingly, so far everyone except you has overlooked that exponential notation for numeric constants is valid but missing. And yes, I agree it is worth including a note that the "dot" character is the only valid decimal separator in SQL...and probably also that thousands separators (be they comma, dot or space) are not valid at all. Some more good catches! Cheers, Helen -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Where are the doclibs?
Title: Re: [Firebird-docs] Where are the doclibs? Hello Martin, Thursday, January 28, 2016, 8:18:12 PM, you wrote: Hi, I’ve just set up a new environment and downloaded the doc sources via CVS. I wanted to download the doclibs as mentioned in the readme. But when I use the URL http://www.firebirdsql.org/doclibs I’m getting error 404. So where can I find the libs? I had a search around the files and couldn't find them, so I've uploaded the three docwriters' tools files and linked to them from here: http://www.firebirdsql.org/en/reference-manuals/#doclibs I'm fairly sure these are the most recent version that (I think) PaulVink sent me in April last year. Certainly they are the ones I used to set up for the Language Reference project. Cheers, Helen -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
[Firebird-docs] Firebird Language Reference 2.5 (English) Beta 1
Hello all, Well, the review of the translated text has gotten this far, thanks to the efforts of Paul Vinkenoog and Mark Rotteveel. Unfortunately, we didn't get any more Englsh speakers to help with the review, so there is still a way to go. We decided to release what we have as a Beta. You can find it at http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/Firebird_Language_Reference_25EN.pdf and http://www.firebirdsql.org/file/documentation/reference_manuals/fblangref25-en/html/fblangref25.html For the translators, the English DocBook sources are in CVS. You can ssafely begin work on the completed chapters, which are as follows: fblangref25.xml fblangref25-intro.xml fblangref25-structure.xml fblangref25-datatypes.xml fblangref25-commons.xml fblangref25-ddl.xml, up to the completion of the PROCEDURE section then fblangref25-security.xml fblangref25-appx01-supplement.xml fblangref25-appx02-errorcodes.xml fblangref25-appx03-reskeywords.xml fblangref25-appx04-systables.xml fblangref25-appx05-montables.xml fblangref25-appx06-charsets.xml fblangref25-appx07-license.xml fblangref25-dochist.xml These chapters are still awaiting the technical and editorial review: fblangref25-dml.xml fblangref25-psql.xml fblangref25-functions-vars.xml fblangref25-transacs.xml We will update as more reviewed material evolves. Any English speakers who want to help us through these remaining chapters, we would love to hear from you. (Post a msg here). Huge thanks to everyone who made this happen. Helen -- Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311=/4140 ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Firebird 3 Authentication: passwords
Hi Stefan, I'm just reading through the Firebird 3 release notes. The chapter about Increased Password Length speaks of a maximum of 20 bytes. The second blue box in this chapter then asks: **Why is the password effectively limited to 20 characters? It is unclear from this documentation if this is about bytes or characters. What character set is used for storing passwords? Are these restricted to 7-Bit US-ASCII? (in this case, the number of bytes and characters would be the same). OTTOMH, password hashes are stored using character set OCTETS. No other charset would make sense, methinks. That would still leave open the possibility to enter passwords in multibyte charsets, but I don't know if this is supported. If it is, the 'effective length' as explained in the RelNotes would be 20 bytes, not characters. (I hope this is the right forum for this question, if not, please give me a hint.) No, it's not the right forum. The way it's documented now is what finally satisfied Alex Peshkov. Btw, we are talking about CHARACTERS, not bytes. There was argument in firebird-admin, since the potential length of passwords is now longer than anyone would remember and if you have to keep a file and copy/paste in order to log in, it all seems a bit much... Effective length has to do with the decoding algorithm (for potential brute force hacking, natch), although I haven't figured out exactly how. Alex insists that it's pointless having a pw longer than about 20 characters. So ask him on fb-devel and I'll watch and we might drag out something a bit more useful for the RC1 notes. Helen -- ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Firebird 3 QSG source
At 09:52 a.m. 23/07/2015, Paul Vinkenoog wrote: Hi all, Could someone please email me the file qsg3.xml (or quickstartguide-3.xml, or whatever) which lives in the manual/src/docs/firebirddocs directory of our CVS module? I'm on a slow and very unreliable link here and I've been struggling for hours to wrest this file from the *@$#@!! SourceForge servers, to no avail. The Web interface seems disappeared and they've set out a trail of false pointers in their online documentation. The CVS server just times out or hangs up on me. If someone could pick up this file from the repos (it's fairly recent) and get it to me so I can work on it, I'd be most grateful. In case anyone missed it, SF has been down for about a week, with little bits coming back up in fits and starts. I see CVS is still down. The mail lists (that are administered by me and some ghosts) finally came up a few hours ago so maybe it won't be too much longer till cvs and svn come up. Paul, sorry, my last update was in April so there's no sign of any qsg stuff for Fb 3. Oh, and a bit of happy news. The first half of the all-singing, all-dancing Language Reference is translated, edited and converted to Docbook. I should receive the rest of the raw translation next week or so. Helen -- ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] General Note about Firebird 2.5.3 Security Update 1 is missing
Tomneko, At 08:16 p.m. 27/03/2015, Tsutomu Hayashi wrote: Hi all I am planning to translate Firebird 2.5 Release Notes to Japanese. Therefore I checked the cvs repository at /firebird/manual/src/docs/rlsnotes/rlsnotes25/ . But, there is a GeneralNotes25.docbook not contained Security Update 1. Please give me correct location I must translate it. Adding rlsnotes25.xml is not updated too. --- edition22 July 2014 - Document v.0253_04 - for Firebird 2.5.3/edition --- Project web site shows 4 December 2014 - Document v.0253_05 - for Firebird 2.5.3 Security Update 1. I suggest waiting a few days, when I will upload the sources for the V.2.5.4 release notes, in which the mistakes you mentioned have already been corrected. Kia ora, Helen -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] General Note about Firebird 2.5.3 Security Update 1 is missing
At 12:31 a.m. 28/03/2015, Tsutomu Hayashi wrote: Hi Helen Thanks for your reply. Ok, I am waiting new release notes! Ready now. Kia ora, Helen -- Dive into the World of Parallel Programming The Go Parallel Website, sponsored by Intel and developed in partnership with Slashdot Media, is your hub for all things parallel software development, from weekly thought leadership blogs to news, videos, case studies, tutorials and more. Take a look and join the conversation now. http://goparallel.sourceforge.net/ ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Choosing the translation service
At 09:37 p.m. 10/11/2014, Alexey Kovyazin wrote: Hi All, As you know, we are going to translate recently completed Firebird Language Reference in Russian into English. For this purpose we are working with translation services. I need input from English speakers (native and not native :) about quality of the following test translation from one of the services: https://yadi.sk/i/uh1WeVY9ccChv Obviously, this translation needs some additional work, and also we can supply translator with some kind of guideline how to translate certain things in better way, but the question is: should we choose them or need to try another one? On a quick read, 1. I sense that this translator does not have a good command of the use of articles in English (the, a/an, some. and constructs with no article). At best, it makes the text awkward to read for an English native speaker; at worst, the misuse of articles can make a difference to meaning, which could be a problem when translating the English version to other languages. It is a tedious editing task to go through text and correct these errors. (Believe me, I'm doing that all the time!!) If the person is being paid to translate, we should not be put in the position of needing to do such basic corrections. 2. Vocabulary choice in some cases needs to be reviewed. Referring to statements as operators is a bad choice in a language reference. The term operator has a distinct meaning in SQL and it is not that one! Similarly, use of the word events when talking about operations will cause confusion, even to native English speakers, given that the word event has a specific meaning in Firebird's procedural language. I found some other examples where vocab choice was inappropriate. Possibly the translator(s) should be given a set vocab of the terms most used in English for the various concepts. 3. Is the merging of keywords into one invalid word intentional? e.g. DROPPROCEDURE and other examples. If so, why? As far as I can tell, this occurs only in the explanatory text, not in the syntax patterns or the examples. I downloaded the sample, in the hope that I will have more time to study it when I get clear of release notes for a while. Helen -- ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
Re: [Firebird-docs] Do we ever build release notes all together?
At 04:44 AM 19/10/2011, Paul Vinkenoog wrote: Hi Norman, Sorry, I cannot type: I'm wondering if this is something we might need to fix. I have had a look in rlsnotes20/install/Compatibility20x.docbook where at least one section has an id=compat-sql but I can find no cross refernce (or xref tags) to it anywhere. That should of course read : ... section has an id=rnfbtwo-compat but I can find no cross refernece ... Really? ;-) Can't think of any reason we'd ever want to build release notes all together. However, anyone who has this desire is welcome to do it after my death. ;-) Over the years release notes are a mish-mash of stuff from multiple sources. Things didn't start to come together until Paul sorted out the docbook framework during one of the Fb 1.5 sub-release cycles. At that point I spent a lot of time backporting Word and RTF sources into the framework for both Fb 1.5 and Vulcan. (AFAIR, the Vulcan release notes never made it into CVS.) A new mess began with v.2.1, when the notes that were done were a merger of new stuff in 2.1 and the stuff to date in 2.0.x. At that point, there were no Lang Updates so the merger was done to meet demand and the Ref Manual project was being subjected to a lengthy assassination. At that point also, the 2.0.x series was still being treated as an interim step towards the evolving new architectures. There was no expectation that 2.0.x would have six sub-releases and 2.1 would still be alive in 2011! It was further complicated by breaking out the bug fixes and compatibility/migration notes into separate documents. That was done to appease the kit builders who were complaining about the size of the PDF. Since then, it's not so relevant as I have NitroPDF and can shrink PDFs if there are complaints about their size. Furthermore, they took to including the Lang Updates in the kits and *those* are not getting any smaller! The id duplications occur (mostly) because the earlier 2.0 tags are repeated in the 2.1 notes and I gave up trying to catch them eventually. I doubt I ever will now - it's enough trouble and heartache trying to capture and verify content. ;-) Helen -- All the data continuously generated in your IT infrastructure contains a definitive record of customers, application performance, security threats, fraudulent activity and more. Splunk takes this data and makes sense of it. Business sense. IT sense. Common sense. http://p.sf.net/sfu/splunk-d2d-oct ___ Firebird-docs mailing list Firebird-docs@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-docs
