Search found 367 matches

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

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

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

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

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.
by Dave
Thu Aug 16, 2018 5:26 pm
Forum: Discussion
Topic: FYI on operator SEARCH
Replies: 1
Views: 1786

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

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

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

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

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

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

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
by Dave
Tue Apr 10, 2018 3:04 pm
Forum: Announcements
Topic: Rel version 3.012 now available!
Replies: 0
Views: 2037

Rel version 3.012 now available!

This release of Rel , an implementation of Date & Darwen’s Tutorial D database language, improves the user interface and fixes some bugs. The following enhancements have been made: – Rel DBMS: Now provides -q command-line option to disable startup/shutdown information messages. This is intended to m...
by Dave
Mon Apr 09, 2018 6:00 am
Forum: Report a Bug
Topic: Problem with ALTER TYPE_OF
Replies: 5
Views: 1929

Re: Problem with ALTER TYPE_OF

Try this:

Code: Select all

OPERATOR INTEGER(v CHAR) RETURNS INTEGER;
	RETURN CAST_AS_INTEGER(SUBSTRING(v, 1, LENGTH(v) - 1));
END OPERATOR;
by Dave
Sun Apr 08, 2018 4:24 pm
Forum: Report a Bug
Topic: Problem with ALTER TYPE_OF
Replies: 5
Views: 1929

Re: Problem with ALTER TYPE_OF

... Now try to apply the following changes to above relation: Change from character to integer: ALTER VAR T1 TYPE_OF B TO INTEGER; Returns: ERROR: RS0278: No run-time invocation targets found for INTEGER(CHARACTER) ... This isn't actually a bug, except to the extent that my poor (read: nonexistent)...
by Dave
Sun Apr 08, 2018 4:12 pm
Forum: Language Issues
Topic: Option to limit type violation to only the type
Replies: 1
Views: 1173

Re: Option to limit type violation to only the type

Interesting -- I'd never thought of these messages as being too much information. Rather, I'd sometimes thought they didn't provide enough information, as they provide just enough to be unambiguous. Any less detail, and there'd be some risk of ambiguity. Unfortunately, unambiguous error messages are...