doltgresql
doltgresql copied to clipboard
support SEQUENCES
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