We have this code which works well most of the time, except for a case I will describe slightly latter: /** * Recovers archived survey responses * * @param int $surveyId survey ID * @param string $...

@Entity public class Employee { @Id @GeneratedValue private long id; private String name; private String dept; private long salary; ............. } I am trying to get the result of ...

I am currently doing DBMS course. While studying DDL and DML I came to realize that DDL use Interpreter and DML use compiler. Interpreter execute codes line by line and Compiler executes whole code at ...

im working with a MySQL database where I have a column of type VARCHAR, but it stores numeric values. I created a B-Tree index on this column to optimize queries like: E.x > n n < E.x n = E.x (...

I am designing a system that records stock transactions for a product. Some product types record items by serial number for traceability, some products types do not serialize items. I record the ...

We are planning to shift from infi.clickhouse to ibis, so I was wondering, does ibis support the migration of old schema to new like infi.clickhouse? If not, then what could be the solution to this? ...

I have a Postgres table that has numerous columns which frequently show up in the where clause of select queries. The table has been indexed accordingly, with indexes on all of these columns (mostly ...

I have a system where transactions are initially marked as "Pending" in a relational database, if a payment transaction is not immediately successful by payment gateway, I need to fetch the ...

My OrientDB 3.2 application can have millions of vertices and edges. The query below fetches the records from superclass V. select FROM `V` where class_name = ['Database', 'Table'] AND is_asset_class !...

I have a user defined function which returns number, argument is also a number. There is an aggregate function(sum()) inside the UDF. I am calling this UDF from a select clause. It's giving me the ...

I have two queries, where I need to get the ID from the first query and pass it to the second query. How do I do this for all the ID's in the first query? select id, name from [ignite].[COND] --> ...

Does Cassandra offer any semantics similar to REPEATABLE READ? I believe you can do this within a "batched" LWT, but doesn't this incur significant network overhead due to PAXOS? REPEATABLE ...

When I tried in dms to load data from mysql to s3. Then task fail and show this Error: Last Error Failed in resolving configuration. Stop Reason FATAL_ERROR Error Level FATAL.

I'm using Postgres v16. I've got a unique index on my invoice table: CREATE UNIQUE INDEX unq_invoice_display_id ON invoice (tenant_id, display_id, expiry_timestamp) WHERE id = original_invoice_id; #...

I don't really understand how to delete columns using the dbms_redefinition utility. All the time there are some strange errors and data overwriting. Disabled foreign keys appear in other tables and ...