Niklas Schmidtmer
Niklas Schmidtmer
The case below has been transferred to a separate issue: https://github.com/crate/crate/issues/15436 There is currently a file inconsistency in the Debian/Ubuntu repository. The issue is reproducible from EC2 instances in the...
I don't have an exact use case to reference here, it's more of a general request that comes up from time to time. Usually, people want to add a short...
Another case is the definition of object literals in views, such as: ```sql CREATE TABLE data (value_1 BOOLEAN, value_2 INTEGER); CREATE OR REPLACE VIEW data_view AS SELECT { value_1 =...
However, in your case, @matriv, the schema and table names are returned separately in `information_schema.tables`/`pg_tables`. In the `sys.snapshots` example, a fully qualified name is returned. I think not applying quoting...
> Hi @hammerhead. You added two commits here, but I accidentally destroyed them, apologies. Can you have a look at your local repository, if you still have it, and just...
Hi, Yes, upgrading to Ruby 3 totally makes sense. I think the currently used activerecord version doesn't support Ruby 3 yet, so we need to upgrade to a (slightly) more...
One example is the abortion of a benchmark run consisting of many queries, and you want to kill those before starting another run. The benchmark tool itself didn't manage to...
An example from a cluster that uses only partitioned tables: ```sql SELECT n.name, n.attributes['zone']::INTEGER AS zone, fs['total']['used'] / CAST(fs['total']['size'] AS FLOAT) * 100 AS used_percent, ROUND(fs['total']['available'] / power(1024, 3)) AS...
I recently had to reindex a large cluster (taking the `INSERT INTO SELECT` approach), here are some observations: * Reindexing large tables (1 TB) as a whole is not feasible,...
I ran into a similar case, also from a TPC-H-inspired star schema benchmark. This is the original query: ```sql SELECT c_nation, s_nation, d_year, SUM(lo_revenue) AS revenue FROM starschema.customer CROSS JOIN...