Search found 371 matches
- Tue Nov 27, 2018 5:42 pm
- Forum: Report a Bug
- Topic: WITH not available in a WHERE condition
- Replies: 4
- Views: 21857
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...
- Tue Nov 20, 2018 4:59 pm
- Forum: Report a Bug
- Topic: WITH not available in a WHERE condition
- Replies: 4
- Views: 21857
Re: WITH not available in a WHERE condition
Try
I'll make a note to look at operator precedence around WHERE and WITH.
Code: Select all
r WHERE (WITH (x := TRUE) : x)
- 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: 40253
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...
- 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: 40253
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...
- 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: 40253
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?
Or do you mean the contents in the tabs on the right?
Or both?
- Tue Nov 13, 2018 9:39 am
- Forum: Language Issues
- Topic: JOIN alternative for partial data?
- Replies: 1
- Views: 16622
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.
- Fri Aug 17, 2018 2:54 pm
- Forum: Language Issues
- Topic: Fyi using the RANK operator with a rva
- Replies: 3
- Views: 13563
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...
- Fri Aug 17, 2018 7:28 am
- Forum: Language Issues
- Topic: Fyi using the RANK operator with a rva
- Replies: 3
- Views: 13563
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.
- Thu Aug 16, 2018 5:26 pm
- Forum: Discussion
- Topic: FYI on operator SEARCH
- Replies: 1
- Views: 20844
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.
- Thu Aug 16, 2018 5:24 pm
- Forum: Language Issues
- Topic: SEARCH for multiple strings
- Replies: 1
- Views: 9002
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.
- Thu Aug 16, 2018 5:16 pm
- Forum: Language Issues
- Topic: Editing a rva
- Replies: 1
- Views: 8870
Re: Editing a rva
I have noted this in my "to do" list.
- Thu Jul 12, 2018 8:12 am
- Forum: Report a Bug
- Topic: Type Decimal identity crisis
- Replies: 3
- Views: 13567
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...
- Thu Jul 12, 2018 6:22 am
- Forum: Report a Bug
- Topic: There's no escape
- Replies: 1
- Views: 10550
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.
- Thu Jul 12, 2018 6:19 am
- Forum: Report a Bug
- Topic: Type Decimal identity crisis
- Replies: 3
- Views: 13567
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/
- Tue Apr 10, 2018 4:04 pm
- Forum: Getting Started
- Topic: Export CSV from command line
- Replies: 3
- Views: 25749
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