Search found 363 matches

by Dave
Thu Aug 16, 2018 5:26 pm
Forum: Discussion
Topic: FYI on operator SEARCH
Replies: 1
Views: 1409

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

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

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

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

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

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

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

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

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

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

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...
by Dave
Wed Mar 28, 2018 9:19 am
Forum: Report a Bug
Topic: Old database treated as a new one
Replies: 1
Views: 965

Re: Old database treated as a new one

If you click the "Install Rev" button on the Welcome screen, it will create various additional relvars to support Rel functionality including the visual query language (aka Rev), command history, etc., plus it will provide a checkbox on the Welcome screen to turn off the Welcome screen.
by Dave
Wed Mar 28, 2018 9:11 am
Forum: Report a Bug
Topic: Problem using code to access external data
Replies: 1
Views: 731

Re: Problem using code to access external data

This VAR declaration to access data in sql server 2016 worked as expected in Rel v3.004 but does not work with v3.010 or v3.011: VAR TEST4 EXTERNAL JDBC "jdbc:jtds:sqlserver://localhost:1433;databaseName=JUDYDB1,**,********,TEST1"; It returns the error: ERROR: Encountered "VAR" at line 12, column 1...
by Dave
Sun Mar 04, 2018 9:26 am
Forum: Language Issues
Topic: Aditional operator functionality
Replies: 2
Views: 1108

Re: Aditional operator functionality

You could define something similar to CAST_AS_CHARACTER(OPERATOR) by retrieving the operator's source code (I assume it's the source code that would be returned by CAST_AS_CHARACTER?) from the sys.Operators relvar. You can perhaps achieve something akin to CAST_AS_OPERATOR(CHARACTER) by using EXECUT...
by Dave
Mon Feb 12, 2018 2:38 pm
Forum: Getting Started
Topic: Export CSV from command line
Replies: 3
Views: 2090

Re: Export CSV from command line

Does the RelDBMS command line tool support CSV as well? Not directly, no. You could create a script named, say, S_TO_CSV.rel with the following contents: FOR S ORDER(ASC SNAME); WRITELN S# || "," || SNAME || "," || STATUS || "," || CITY; END FOR; Then invoke it with something like... ./RelDBMS < S_...