Results of 1 - 10 of about 20 for rollback (0.002 sec.)
- Transaction Management 13051
- DuckDB supports ACID database transactions . Transactions provide isolation, i.e., changes made by a transaction are not visible from concurrent transactions until it is committed. A transaction can also be aborted, which discards any chang
...n, also known as rolling back, will discard any changes the transaction made to the database. To abort a transaction, run: ROLLBACK; You can also use the abort command, which has an identical behavior: ABORT; If you are not in an active transaction, the...ES ('Ada', 52); COMMIT; BEGIN TRANSACTION; DELETE FROM person WHERE name = 'Ada'; INSERT INTO person VALUES ('Bruce', 39); ROLLBACK; SELECT * FROM person; The first transaction (inserting “Ada”) was committed but the second (deleting “Ada” and inserting... - https://man.mtool.work/duckdb/2.0/sql/statements/transactions.html
- ODBC Extension Functions 11368
- odbc_begin_transaction odbc_bind_params odbc_close odbc_commit odbc_connect odbc_copy odbc_create_params odbc_list_data_sources odbc_list_drivers odbc_query odbc_rollback odbc_begin_transaction odbc_begin_transaction(conn_handle BIGINT) ->
...e to SQL_AUTOCOMMIT_OFF on the specified connection thus effectively starting an implicit transaction. odbc_commit or odbc_rollback must be called on such connection to complete the transaction. The completion starts another implicit transaction on this...getvariable('conn'), 'SELECT CAST(? AS NVARCHAR2(2)) || CAST(? AS VARCHAR2(5)) FROM dual', params=row('?', 'quack') ) odbc_rollback odbc_rollback(conn_handle BIGINT) -> VARCHAR Calls SQLEndTran with SQL_ROLLBACK argument on the specified connection, comp...BIGINT ): ODBC connection handle created with odbc_connect Returns: Always returns NULL ( VARCHAR ). Example: SELECT odbc_rollback(getvariable('conn'))... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/functions.html
- Python DB API 10519
- The standard DuckDB Python API provides a SQL interface compliant with the DB-API 2.0 specification described by PEP 249 similar to the SQLite Python API . Connection To use the module, you must first create a DuckDBPyConnection object that
..., con.sql(query).pl() or con.sql(query).to_arrow_reader() , which streams. Transactions con.begin() , con.commit() and con.rollback() start, commit and roll back a transaction, as the BEGIN , COMMIT and ROLLBACK statements do. Inside a transaction, any s...mit() rolls the transaction back without raising an error, and any other statement raises a TransactionException until you roll back: con.begin() con.execute("INSERT INTO items VALUES ('drill', 80, 1)") try: con.execute("SELECT * FROM missing_table") exc...ELECT count(*) FROM items") _duckdb.TransactionException: TransactionContext Error: Current transaction is aborted (please ROLLBACK) con.rollback() con.execute("SELECT count(*) FROM items").fetchall() [(5,)]... - https://man.mtool.work/duckdb/2.0/clients/python/dbapi.html
- Iceberg Functions 9669
- The iceberg extension provides the following functions: Function Description iceberg_scan(source) Reads an Iceberg table from a path. iceberg_metadata(source) Returns the manifest entries of an Iceberg table. iceberg_snapshots(source) Retur
...fied schema. remove_iceberg_schema_properties(schema, property_list) Removes properties from the specified schema. iceberg_rollback_to_snapshot(table, snapshot_id) Rolls back an Iceberg table to an earlier snapshot. iceberg_rewrite_data_files(table) Comp...ckDB cannot parse. SELECT * FROM iceberg_view_metadata('my_datalake.default.my_view'); Table Maintenance Functions iceberg_rollback_to_snapshot The iceberg_rollback_to_snapshot(table, snapshot_id) function sets the current snapshot of a table in an attac...aken from iceberg_snapshots . The function returns the previous_snapshot_id and the new current_snapshot_id . CALL iceberg_rollback_to_snapshot('my_datalake.default.t', ⟨snapshot_id⟩); iceberg_rewrite_data_files The iceberg_rewrite_data_files(table) func... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_functions.html
- ALTER VIEW Statement 9669
- The ALTER VIEW statement changes the schema of an existing view in the catalog. Examples Rename a view: ALTER VIEW view1 RENAME TO view2; ALTER VIEW changes the schema of an existing view. All the changes made by ALTER VIEW fully respect th
...ional semantics, i.e., they will not be visible to other transactions until committed, and can be fully reverted through a rollback. Note that other views that rely on the view are not automatically updated.... - https://man.mtool.work/duckdb/2.0/sql/statements/alter_view.html
- AutoComplete Extension 9465
- The autocomplete extension adds support for autocomplete in the CLI client . The extension is shipped by default with the CLI client. Behavior For the behavior of the autocomplete extension, see the documentation of the CLI client . Functio
...tion_start SELECT 0 DELETE 0 INSERT 0 CALL 0 LOAD 0 CALL 0 ALTER 0 BEGIN 0 EXPORT 0 CREATE 0 PREPARE 0 EXECUTE 0 EXPLAIN 0 ROLLBACK 0 DESCRIBE 0 SUMMARIZE 0 CHECKPOINT 0 DEALLOCATE 0 UPDATE 0 DROP 0... - https://man.mtool.work/duckdb/2.0/core_extensions/autocomplete.html
- ODBC Extension 9465
- Please note that DuckDB also offers an ODBC client , which allows you to connect to DuckDB via ODBC from other applications. The odbc_scanner extension allows connecting to other databases (using their ODBC drivers ) and run queries with th
...expected to have auto-commit mode enabled by default. As a general rule, transaction commands BEGIN TRANSACTION / COMMIT / ROLLBACK are not supposed to be sent over ODBC as SQL commands. Doing so may or may not be supported by the particular driver. Inst...es the API to manage transactions. This API is exposed in the following functions: odbc_begin_transaction odbc_commit odbc_rollback When odbc_begin_transaction is called on the connection, the auto-commit mode on this connection is disabled and an implic...ly no support for enabling auto-commit back on such connection. After the transaction is started, call odbc_commit or odbc_rollback to complete this transaction. After the completion is performed, new implicit transaction is started on this connection au... - https://man.mtool.work/duckdb/2.0/core_extensions/odbc/overview.html
- Run Queries 8615
- Overview Because the Go client implements database/sql , queries run through the standard methods: Exec and ExecContext send statements that do not return rows, such as INSERT or DDL, and report the number of affected rows. Query , QueryCon
...ns a *sql.Tx whose Exec and Query methods run inside it. Commit the transaction with tx.Commit() , or roll it back with tx.Rollback() : tx, err := db.BeginTx(ctx, nil) if err != nil { log.Fatal(err) } if _, err := tx.ExecContext(ctx, `INSERT INTO users V...ALUES ('gru', 25)`); err != nil { tx.Rollback() log.Fatal(err) } if err := tx.Commit(); err != nil { log.Fatal(err) } Scanning Results QueryContext returns a *sql.Rows... - https://man.mtool.work/duckdb/2.0/clients/go/querying.html
- Jupyter Notebooks 8615
- DuckDB's Python client can be used directly in Jupyter notebooks with no additional configuration, as the first section shows. Additional libraries can simplify SQL query development; the rest of this guide uses the JupySQL package. See oth
...the open transaction of the SQLAlchemy connection. Later statements then fail with Current transaction is aborted (please ROLLBACK) until you run %sql ROLLBACK . Querying DuckDB Single line SQL queries can be run using %sql at the start of a line. Query... - https://man.mtool.work/duckdb/2.0/guides/python/jupyter.html
- MySQL Extension 8190
- The mysql extension allows DuckDB to directly read and write data from/to a running MySQL instance. The data can be queried directly from the underlying MySQL database. Data can be loaded from MySQL tables into DuckDB tables, or vice versa.
...ABLE mysql_db.tmp (i INTEGER); BEGIN; INSERT INTO mysql_db.tmp VALUES (42); SELECT * FROM mysql_db.tmp; This returns: i 42 ROLLBACK; SELECT * FROM mysql_db.tmp; This returns an empty table. The DDL statements are not transactional in MySQL. Running SQL Q...se filter pushdown (without predicate analyzer) true mysql_enable_transactions Whether to run START TRANSACTION / COMMIT / ROLLBACK on MySQL connections true mysql_incomplete_dates_as_nulls Whether to return DATE s with a zero month or day as NULL s fals... - https://man.mtool.work/duckdb/2.0/core_extensions/mysql.html
DuckDB 2.0 Documentation / man.mtool.work