Tim,

1. SQL DDL parsing problem:

CREATE TABLE "TestSchedule" (
 "TestScheduleID" INTEGER NOT NULL
)
Returns Error #700. Error in check constraint. NOT NULL Doesn't work with
other
parameters also.

2. Scripts are not (always) executed in ElevateDBManager - only the first
statement is.

3. Server freezes every after every other SQL command... there seem to be
something
with sessions being disconnected and then it waits for 300 secs - which is
especially
strange for local connections.


Michael

Michael,

<< 1. SQL DDL parsing problem:

CREATE TABLE "TestSchedule" (
 "TestScheduleID" INTEGER NOT NULL
)
Returns Error #700. Error in check constraint. NOT NULL Doesn't work with
otherparameters also. >>

Fixed.  What other parameter combinations are not working ?

<< 2. Scripts are not (always) executed in ElevateDBManager - only the first
statement is. >>

This is "as-designed". If you want to run a multi-statement script you must
do so in the form of a stored procedure.  There are no scripts in EDB like
there were in DBISAM.

<< 3. Server freezes every after every other SQL command... there seem to be
something with sessions being disconnected and then it waits for 300 secs -
which is especially strange for local connections. >>

Any particular SQL statements ?  I'm running multiple SQL SELECT statements
here and they seem to be working okay.

--
Tim Young
Elevate Software
www.elevatesoft.com

>> Returns Error #700. Error in check constraint. NOT NULL Doesn't work with
>> otherparameters also. >>
>> Fixed.  What other parameter combinations are not working ?
Mmm, nothing works if there's NOT NULL in there. For example:

CREATE TABLE T (
  I INT DEFAULT 0 NOT NULL
)

Also, I'm not sure I understand your DDL syntax

<ColumnDefinition> =
<Name> <DataType>
[COMPRESSION <Compression>]
[GENERATED <GenerationOptions>|DEFAULT <DefaultExpression>]
[<ColumnConstraintDefinition>] [,<ColumnConstraintDefinition>]
[DESCRIPTION <Description>]

That comma in [,<ColumnConstraintDefinition>] is totally ambiguous,
it's not gonna work with the comma (and it doesn't).
I hope it's just a typo in the manual.


> << 3. Server freezes every after every other SQL command... there seem to be
> something with sessions being disconnected and then it waits for 300 secs -
> which is especially strange for local connections. >>
>
> Any particular SQL statements ?  I'm running multiple SQL SELECT statements
> here and they seem to be working okay.
It doesn't happen every time, and it is mostly with DDL statements.
I can figure out the sequence to reproduce it so far, but it did
freeze about 10 times yesterday (both local and remote).


Michael

Michael,

<< Also, I'm not sure I understand your DDL syntax

<ColumnDefinition> =
<Name> <DataType>
[COMPRESSION <Compression>]
[GENERATED <GenerationOptions>|DEFAULT <DefaultExpression>]
[<ColumnConstraintDefinition>] [,<ColumnConstraintDefinition>]
[DESCRIPTION <Description>]

That comma in [,<ColumnConstraintDefinition>] is totally ambiguous, it's
not gonna work with the comma (and it doesn't). I hope it's just a typo in
the manual. >>

It's a typo.

<< It doesn't happen every time, and it is mostly with DDL statements. I can
figure out the sequence to reproduce it so far, but it did freeze about 10
times yesterday (both local and remote). >>

I'm getting reports from others about this, but I haven't been able to
reproduce anything yet.

--
Tim Young
Elevate Software
www.elevatesoft.com