Search found 371 matches

by Dave
Tue Nov 27, 2018 5:42 pm
Forum: Report a Bug
Topic: WITH not available in a WHERE condition
Replies: 4
Views: 18877

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

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

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

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 c...
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: 34270

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

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

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&q...
by Dave
Fri Aug 17, 2018 7:28 am
Forum: Language Issues
Topic: Fyi using the RANK operator with a rva
Replies: 3
Views: 11544

Re: Fyi using the RANK operator with a rva

You mentioned this causes a fatal error? 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.
by Dave
Thu Aug 16, 2018 5:26 pm
Forum: Discussion
Topic: FYI on operator SEARCH
Replies: 1
Views: 17495

Re: FYI on operator SEARCH

SEARCH(...) was developed as a an ad-hoc hack, purely to support the full-text search facility in the Rel user interface. If there are uses outside of that, that's excellent, but unintentional. :)
by Dave
Thu Aug 16, 2018 5:24 pm
Forum: Language Issues
Topic: SEARCH for multiple strings
Replies: 1
Views: 7338

Re: SEARCH for multiple strings

I'd guess there is a different regex that would work. It's based on the Java regex syntax, which has some unique quirks.
by Dave
Thu Aug 16, 2018 5:16 pm
Forum: Language Issues
Topic: Editing a rva
Replies: 1
Views: 7155

Re: Editing a rva

I have noted this in my "to do" list.
by Dave
Thu Jul 12, 2018 8:12 am
Forum: Report a Bug
Topic: Type Decimal identity crisis
Replies: 3
Views: 11691

Re: Type Decimal identity crisis

Ah, I see! It looks like there's a bug in the definition of the Decimal type, which is one of the provided Java-based user-defined type examples. At a quick glance, it looks like it's missing some Java method definitions that at one time weren't required, but are now required. I'll have a look at it...
by Dave
Thu Jul 12, 2018 6:22 am
Forum: Report a Bug
Topic: There's no escape
Replies: 1
Views: 8772

Re: There's no escape

I can confirm this is a bug, and I've made a note to include the fix in the next update.
by Dave
Thu Jul 12, 2018 6:19 am
Forum: Report a Bug
Topic: Type Decimal identity crisis
Replies: 3
Views: 11691

Re: Type Decimal identity crisis

This is correct behaviour. To perform MAX on DECIMAL values, you need to provide appropriate user-defined aggregate operators. See https://reldb.org/c/index.php/read/user ... operators/
by Dave
Tue Apr 10, 2018 4:04 pm
Forum: Getting Started
Topic: Export CSV from command line
Replies: 3
Views: 20362

Re: Export CSV from command line

In the latest 3.012 update, I've provided a command-line flag -- -q -- to silence the various startup and shutdown messages. For example:

Code: Select all

./RelDBMS -q < S_TO_CSV.rel > output.csv