FrontBase 3.6e - Release Notes
FrontBase 3.6e - Bug fixes
Switching from PRESERVE SPACE to PRESERVE TIME for certain indexes, could cause subsequent UPDATE statements not to update properly.
Casting a TIMESTAMP value to VARCHAR produed incorrect results for "<leap year>-12-31" type of values.
Specifying ON UPDATE CASCADE on FOREIGN KEY constraints could result in integrity constraint errors (instead of cascading the UPDATE to the referencing table).
Specifying a GROUP BY clause on a SELECT that referenced an undefined table, could cause the server to enter an endless loop.
Certain UPDATE constructs (SET C0 = C0 + 10) failed to update properly.
PREPARE statements with a LEFT OUTER join table expression could cause the server to crash.
The TOP construct didn't work properly.
Security and Encryption
When the server is started with the -scomm option it generate a public key/private key pair to be used for exchange of session key with a client. As a consequence it is not required to specify any keys in conjunction with -scomm option.
The black and white list control if a connection from a client should be encrypted or not, by default connections from the local host is not encrypted, all other connections are.
sql92 command line tool 3.6e
The command line editing of the sql92 command line tool have been replaced.
The command line tool supports the following key-bindings:
| . Left arrow | Cursor left |
| . Right arrow | Cursor right |
| . Down arrow | Previous history line |
| . Up arrow | Next history line |
| . Crtl A | Cursor to beginning of line |
| . Crtl B | Cursor left |
| . Crtl C | Clear line |
| . Crtl D | End of file - exit sql92 |
| . Crtl E | Cursor to end of line |
| . Crtl F | Cursor Right |
| . Crtl H | Delete character in front of cursor |
| . Crtl I | Complete filename |
| . Crtl K | Delete from cursor to end of line |
| . Crtl M | Execute line |
| . Crtl N | Next history line |
| . Crtl P | Previous |
| . Crtl S | Enter search in history mode |
| . Crtl Z | Suspend |
| . Delete | Delete character in front of cursor |
| . Backspace | Delete character in front of cursor |
| . Return | Execute line |
When the command line is the search in history mode the following key-binding is in effect:
| . Down arrow | Previous matching history line |
| . Up arrow | Next matching history line |
| . Crtl D | End of file - exit sql92 |
| . Crtl S | Next matching history line |
| . Crtl H | Delete character in front of cursor |
| . Delete | Delete character in front of cursor |
| . Backspace | Delete character in front of cursor |
| . Crtl C | Exit search and do not update current line |
| . Esc | Exit search and do not update current line |
| . Crtl M | Exit search and update current line |
When the history search mode is entered the current line is used as the initial search string. When the search string is changed the search start from the most recent history line and search towards the oldest. A history line match a search string if the search string is a case and space blind prefix of the history line.
When a command is executed it is added to the history as the newest. If the new history line match a line already in the history that line is removed. The length of the history is limited to 500 lines.
The h; command print out the command history, !! recalls the newest history line, !<n> recalls the n'th history line.