1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
|
# name: test/sql/extensions/sqlite_alter_table_add_pk.test
# description: Test that altering the table to add a primary key throws a not implemented exception.
# group: [extensions]
require-env LOCAL_EXTENSION_REPO
require sqlite_scanner
statement ok
SET autoinstall_known_extensions=true;
statement ok
SET autoload_known_extensions=true;
statement ok
ATTACH '__TEST_DIR__/my_sqlite' AS sqlite_db (TYPE SQLITE);
statement ok
CREATE TABLE sqlite_db.main.tbl (i INT);
statement ok
INSERT INTO sqlite_db.main.tbl VALUES (1);
statement error
ALTER TABLE sqlite_db.main.tbl ADD PRIMARY KEY (i);
----
<REGEX>:Not implemented Error.*BindAlterAddIndex not supported by this catalog.*
|
