Search found 369 matches

by Dave
Fri Oct 07, 2022 2:10 pm
Forum: Announcements
Topic: Rel version 3.016 now available!
Replies: 0
Views: 307

Rel version 3.016 now available!

This release of Rel , an implementation of Date & Darwen's Tutorial D database language, fixes a bug that prevented the Rel DBMS 'BACKUP' command working and thus prevented correct operation of DBrowser's backup facility, and changes the schema of the sys.Version relvar. Fix: Reorganisation of t...
by Dave
Sun Oct 02, 2022 8:40 pm
Forum: Announcements
Topic: Rel version 3.015 now available!
Replies: 0
Views: 123

Rel version 3.015 now available!

This release of Rel , an implementation of Date & Darwen's Tutorial D database language, upgrades some dependencies, adds more detailed logging to the DBrowser startup, fixes some issues, and provides a Maven-based build for Rel developers. The following enhancements have been made: Enhancement:...
by Dave
Wed Sep 25, 2019 8:28 pm
Forum: Announcements
Topic: Rel version 3.014 now available!
Replies: 0
Views: 14336

Rel version 3.014 now available!

This release of Rel , an implementation of Date & Darwen's Tutorial D database language, improves the user interface, adds Infinity and NaN (Not a Number) to the recognised RATIONAL literals, and fixes some bugs. The following enhancements have been made: - DBrowser: The command-line now provide...
by Dave
Sat Sep 21, 2019 12:20 pm
Forum: Report a Bug
Topic: Spurious sytax error with INSERT
Replies: 3
Views: 15455

Re: Spurious sytax error with INSERT

I see the problem -- it's with the mechanism in the DBrowser front-end that tries to detect whether you've entered an expression or one or more statements. It's surprisingly complex and it can be fooled. In this case, it's being fooled into thinking you've entered an expression by the slashes '//', ...
by Dave
Sat Sep 21, 2019 11:43 am
Forum: Report a Bug
Topic: Spurious sytax error with INSERT
Replies: 3
Views: 15455

Re: Spurious sytax error with INSERT

I'll do some tests on this to see if I can find a workaround. I know EXTEND can expose a grammar ambiguity (I don't recall the specifics, but I know it does) and this is likely related to it.
by Dave
Sat Sep 21, 2019 11:42 am
Forum: Report a Bug
Topic: insert sometimes doesn't insert anything
Replies: 1
Views: 7125

Re: insert sometimes doesn't insert anything

Sorry for the slow response - I've been on holiday. This sounds like a bug in transaction handling; maybe the INSERT has written in a "write" transaction but is being read in a "read" transaction whilst the "write" transaction is still open and uncommitted. I've examine...
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: 8916

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

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

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

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 mad...
by Dave
Thu Nov 29, 2018 10:07 pm
Forum: Report a Bug
Topic: WITH not available in a WHERE condition
Replies: 4
Views: 14195

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

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

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

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

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.