doltgresql icon indicating copy to clipboard operation
doltgresql copied to clipboard

support SEQUENCES

Open coffeegoddd opened this issue 4 months ago • 2 comments

Sysbench runner tests fail with:

Successfully started database server
time="2024-03-29T16:55:01Z" level=info msg=NewConnection DisableClientMultiStatements=false connectionID=1
time="2024-03-29T16:55:01Z" level=info msg=ConnectionClosed connectionID=1
sysbench 1.0.20 (using system LuaJIT 2.1.0-beta3)

time="2024-03-29T16:55:01Z" level=info msg=NewConnection DisableClientMultiStatements=false connectionID=2
Creating table 'sbtest1'...
time="2024-03-29T16:55:01Z" level=warning msg="descending indexes are not yet supported, ignoring sort order"
time="2024-03-29T16:55:01Z" level=warning msg="error running query" connectTime="2024-03-29 16:55:01.787581034 +0000 UTC m=+10.032900708" connectionDb=test connectionID=2 error="column type cannot be auto incremented"
FATAL: PQexec() failed: 7 column type cannot be auto incremented (errno 1105) (sqlstate HY000)
FATAL: failed query was: CREATE TABLE sbtest1(
  id SERIAL,
  k INTEGER DEFAULT '0' NOT NULL,
  c CHAR(120) DEFAULT '' NOT NULL,
  pad CHAR(60) DEFAULT '' NOT NULL,
  PRIMARY KEY (id)
)  
FATAL: `sysbench.cmdline.call_command' function failed: /usr/share/sysbench/oltp_common.lua:197: SQL error, errno = 0, state = 'XX000': column type cannot be auto incremented (errno 1105) (sqlstate HY000)
time="2024-03-29T16:55:01Z" level=info msg=ConnectionClosed connectionID=2
Successfully killed database server
2024/03/29 16:55:01 lstat : no such file or directory

coffeegoddd avatar Mar 29 '24 16:03 coffeegoddd