Search found 367 matches

by Dave
Wed Sep 25, 2019 8:28 pm
Forum: Announcements
Topic: Rel version 3.014 now available!
Replies: 0
Views: 588

Rel version 3.014 now available!

This release of Rel , an implementation of Date & Darwen's Tutorial D database language, improves the user interface, adds Infinity and NaN (Not a Number) to the recognised RATIONAL literals, and fixes some bugs. The following enhancements have been made: - DBrowser: The command-line now provides Ex...
by Dave
Sat Sep 21, 2019 12:20 pm
Forum: Report a Bug
Topic: Spurious sytax error with INSERT
Replies: 3
Views: 648

Re: Spurious sytax error with INSERT

I see the problem -- it's with the mechanism in the DBrowser front-end that tries to detect whether you've entered an expression or one or more statements. It's surprisingly complex and it can be fooled. In this case, it's being fooled into thinking you've entered an expression by the slashes '//', ...
by Dave
Sat Sep 21, 2019 11:43 am
Forum: Report a Bug
Topic: Spurious sytax error with INSERT
Replies: 3
Views: 648

Re: Spurious sytax error with INSERT

I'll do some tests on this to see if I can find a workaround. I know EXTEND can expose a grammar ambiguity (I don't recall the specifics, but I know it does) and this is likely related to it.
by Dave
Sat Sep 21, 2019 11:42 am
Forum: Report a Bug
Topic: insert sometimes doesn't insert anything
Replies: 1
Views: 303

Re: insert sometimes doesn't insert anything

Sorry for the slow response - I've been on holiday. This sounds like a bug in transaction handling; maybe the INSERT has written in a "write" transaction but is being read in a "read" transaction whilst the "write" transaction is still open and uncommitted. I've examined the code and can't see anyth...
by Dave
Sun Jan 27, 2019 8:56 pm
Forum: Report a Bug
Topic: RENAME in V3.013 incompatible with previous versions
Replies: 2
Views: 997

Re: RENAME in V3.013 incompatible with previous versions

It's an effect of making RENAME parallel. An expression like REL {TUP {X1 1}} RENAME {SUFFIX '1' AS '', X AS Y} now fails because for a parallel rename to work, the <old_name> of each <old_name> AS <new_name> pair must exist in the tuple/relation operand expression. By the way, apologies for the slo...
by Dave
Sun Dec 16, 2018 9:59 pm
Forum: Language Issues
Topic: IMPLIES via IF THEN
Replies: 1
Views: 1102

Re: IMPLIES via IF THEN

The trailing END IF, END CASE, or just END is needed to disambiguate the end of the conditional subexpression from the remainder of the expression.
by Dave
Sun Dec 16, 2018 9:57 pm
Forum: Language Issues
Topic: Why is NOT IN not interpreted
Replies: 1
Views: 635

Re: Why is NOT IN not interpreted

I suppose it could be added as a Rel-specific extension, but I don't recall Tutorial D specifying NOT IN or equivalent.
by Dave
Fri Dec 07, 2018 2:52 pm
Forum: Announcements
Topic: Rel version 3.013 now available!
Replies: 0
Views: 1448

Rel version 3.013 now available!

This release of Rel , an implementation of Date & Darwen's Tutorial D database language, improves the user interface, fixes some bugs, adds support for outer joins, and significantly reduces the size of the Rel distribution whilst improving startup speed. The following enhancements have been made: -...
by Dave
Thu Nov 29, 2018 10:07 pm
Forum: Report a Bug
Topic: WITH not available in a WHERE condition
Replies: 4
Views: 2026

Re: WITH not available in a WHERE condition

I've looked into this and have reminded myself why it works the way it does. There is a parsing ambiguity when using WITH (and similarly, TUPLE FROM, FROM, and TCLOSE) within WHERE, which I'll illustrate with an example. Given the following expression: WHERE WITH (p := x * 3): p > 2 AND x = 7 Does A...
by Dave
Tue Nov 27, 2018 10:05 pm
Forum: Rel's "DBrowser": The Rel Graphical User Interface
Topic: Scroll bar disappears in Rel mode
Replies: 7
Views: 3242

Re: Scroll bar disappears in Rel mode

I have fixed it.

The fix will be in the forthcoming update.
by Dave
Tue Nov 27, 2018 9:45 pm
Forum: Rel's "DBrowser": The Rel Graphical User Interface
Topic: Scroll bar disappears in Rel mode
Replies: 7
Views: 3242

Re: Scroll bar disappears in Rel mode

I've found a problem with resizing the Rel window when in "Rel" mode and using "Edit" to edit relvar contents. Whilst I haven't been able to precisely replicate the scrollbars disappearing, I suspect that problem and the resizing problem are related.

I'm working on fixing it.
by Dave
Tue Nov 27, 2018 5:42 pm
Forum: Report a Bug
Topic: WITH not available in a WHERE condition
Replies: 4
Views: 2026

Re: WITH not available in a WHERE condition

Yes, I did later think of using parens, but our grammar does specify WHERE <bool exp> . There's a bit of oddness in the Rel grammar around how WHERE <bool exp> is handled -- particularly as ... WHERE <bool exp> ... can appear as a subexpression within a <bool exp> -- and how WITH is handled. In sho...
by Dave
Tue Nov 20, 2018 4:59 pm
Forum: Report a Bug
Topic: WITH not available in a WHERE condition
Replies: 4
Views: 2026

Re: WITH not available in a WHERE condition

Try

Code: Select all

r WHERE (WITH (x := TRUE) : x)
I'll make a note to look at operator precedence around WHERE and WITH.
by Dave
Tue Nov 20, 2018 10:50 am
Forum: Rel's "DBrowser": The Rel Graphical User Interface
Topic: Scroll bar disappears in Rel mode
Replies: 7
Views: 3242

Re: Scroll bar disappears in Rel mode

I've experimented with this, and what happens on my Windows system (at least, the one I tested -- I'll try others later) is that the scroll bar appears when the relvar contents are displayed as it is by default, is still there when the relvar is edited (via 'Edit'), and when I select 'Show' to displ...
by Dave
Fri Nov 16, 2018 10:23 am
Forum: Rel's "DBrowser": The Rel Graphical User Interface
Topic: Scroll bar disappears in Rel mode
Replies: 7
Views: 3242

Re: Scroll bar disappears in Rel mode

I've been able to duplicate this by selecting "Preferences | Command-line | Use an alternative output display ..." I presume you're using the alternative output display? I've made a note in my To Do list to fix this. As a short-term (though somewhat inconvenient) workaround, I've found I can make th...