Search found 363 matches

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: 296

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: 282

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: 162

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: 611

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: 1083

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: 1528

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: 1528

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: 1083

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: 1083

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: 1528

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: 1528

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...
by Dave
Wed Nov 14, 2018 1:53 pm
Forum: Rel's "DBrowser": The Rel Graphical User Interface
Topic: Scroll bar disappears in Rel mode
Replies: 7
Views: 1528

Re: Scroll bar disappears in Rel mode

Do you mean the scroll bar in the single Database tab on the left displaying the tree of relvars, operators, types, etc.?

Or do you mean the contents in the tabs on the right?

Or both?
by Dave
Tue Nov 13, 2018 9:39 am
Forum: Language Issues
Topic: JOIN alternative for partial data?
Replies: 1
Views: 780

Re: JOIN alternative for partial data?

As this is a relatively broad question about Tutorial D in general rather than Rel in particular, I encourage you to join the TTM Forum at https://forum.thethirdmanifesto.com and ask your question there.
by Dave
Fri Aug 17, 2018 2:54 pm
Forum: Language Issues
Topic: Fyi using the RANK operator with a rva
Replies: 3
Views: 1708

Re: Fyi using the RANK operator with a rva

Looks like an even simpler example exhibits this bug. This throws the fatal error: RELATION {TUPLE {RVA RELATION {TUPLE {K 1}}}} EXTEND {RR := RVA RANK (ASC K AS R)} This works: RELATION {TUPLE {RVA RELATION {TUPLE {K 1}}}} EXTEND {RR := RVA {K} RANK (ASC K AS R)} I've noted this in my "to do" list.
by Dave
Fri Aug 17, 2018 7:28 am
Forum: Language Issues
Topic: Fyi using the RANK operator with a rva
Replies: 3
Views: 1708

Re: Fyi using the RANK operator with a rva

You mentioned this causes a fatal error?

Code: Select all

REL{TUP{KEY. 1,ID "A"},
    TUP{KEY. 2,ID "A"}, 
    TUP{KEY. 3,ID "B"},
    TUP{KEY. 4,ID "B"},
    TUP{KEY. 5,ID "B"}} 
    GROUP{KEY.} AS GRP.RVA 
    EXTEND {RANKS.RVA:=GRP.RVA{KEY.} RANK(ASC KEY. AS RANK.)}    
I tried it and it works.