Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Public Beta Tests » View Thread |
Messages 1 to 4 of 4 total |
First Testing Results |
Sat, Dec 16 2006 9:55 AM | Permanent Link |
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 | |
Sat, Dec 16 2006 5:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Sun, Dec 17 2006 8:32 AM | Permanent Link |
Michael Baytalsky | >> 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 |
Sun, Dec 17 2006 5:06 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |