Skip to content
#

SQL

sql logo

SQL stands for structured query language. It uses commands such as "select", "insert", "update", "delete". Some common relational database management systems that use SQL are: Oracle, MySQL, Microsoft SQL Server, PostgreSQL, etc.

Here are 9,981 public repositories matching this topic...

RaduBerinde
RaduBerinde commented Dec 16, 2019

See example below. Best plan is a lookup join, but we don't get that with the semi-join. The reason is that each side is projecting a tuple, and we are constraining those to be equal. A rule that detects this projection and converts to multiple equalities should fix this.

exec-ddl
CREATE TABLE ab (
  a INT,
  b INT,
  PRIMARY KEY (a,b)
)
----


exec-ddl
CREATE TABLE cd (
  c INT
KOLANICH
KOLANICH commented Jan 11, 2019

Sometimes it is needed to store compressed data in the DB. Unfortunately not all the DBs have built-in compression and FUSE compressed FSes are not available for every OS. So it may make sense to store compressed binary blobs in the DB.

Unfortunately when one sees them in DBeaver he sees them compressed, but often they are needed uncompressed. So it'd be nice to have a feature to decompress the

dsbrgg
dsbrgg commented Dec 11, 2019

Environment

Knex version: 0.20.3
Database + version: psql (PostgreSQL) 12.1
OS: macOS 10.14.6

Bug

The expirationChecker property on the connection object is not being called to recreate the connection object with new credentials for the database, even though the timeout was reached.

The first time that a request is being made, it works fine but after the timeout, it won't all

presto
mbasmanova
mbasmanova commented Dec 11, 2019

TupleDomainFilters for IN predicates are optimized to use hash tables for lookups and offer O(1) performance, but NOT IN filters are not optimized and give O(n) performance. Yet, there is no reason why IN predicate optimization couldn't apply to NOT IN. We could extend BytesValues and BigintValues to add a flag indicating that this is a NOT filter and add logic to com.facebook.presto.orc.TupleDoma

Har01d
Har01d commented Dec 19, 2019

We have a simple MergeTree table with ~1M records. Sometimes we need to get last 10 records ordered by id, but we’d also like to get the total number of rows returned by the query if there were no limit.

SELECT count()
FROM blocks

┌─count()─┐
│  600000 │
└─────────┘

Запрос

SELECT id
FROM blocks
ORDER BY id DESC
LIMIT 10
FORMAT JSON

ClickHouse v.19.17.5.18

comicfans
comicfans commented Dec 12, 2019

Relevant system information:

  • OS: archlinux 64bit kernel 5.1.15
  • PostgreSQL version (output of postgres --version): postgres (PostgreSQL) 11.2
  • TimescaleDB version (output of \dx in psql): 1.5.1
  • Installation method: compile from source

Describe the bug

before upgrade, I'm using timescaledb 1.3, pg_dump gives no warning

pg_dump -U myname --format=custom 
willvousden
willvousden commented Oct 13, 2018

Is the README the only documentation available for this project? I find myself having to read the source to understand the interface and features that are available (e.g., context managers, bulk_query, etc.).

In the case of bulk_query, the arguments are simply passed through to the underlying SQLAlchemy engine, with no explanation. I tracked it down in [SQLAlchemy's documentation](https:/

benhaynes
benhaynes commented Nov 28, 2018

We already have most of our Directus API 2.x endpoints/params within Paw for testing. We could finish adding all of these and then potentially use their code generators to create SDKs for our secondary languages.

https://paw.cloud/docs/extensions/create-code-generator

We also have a Swagger file for 98% of API 1.1 — so we could update that (and make sure that OpenAPI allows for our filteri

JeanGolang
JeanGolang commented Feb 7, 2017

Hello Philip!
I think there is an issue with this part of the code of rqlite (store/store.go).

func (s *Store) Database(leader bool) ([]byte, error) {
	if leader && s.raft.State() != raft.Leader {
		return nil, ErrNotLeader
	}
	// Ensure only one snapshot can take place at once, and block all queries.
	s.mu.Lock()
	defer s.mu.Unlock()

	f, err := ioutil.TempFile("", "rqlilte-snap-
flyway
reitzmichnicht
reitzmichnicht commented Apr 13, 2018
Which version and edition of Flyway are you using?

5.0.7

Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)

Java with Hibernate

The linked Stackoverflow entry is only for Hibernate 4.x
I found this way to include Flyway with Hibernate 5.x for example in Wildfly >= 10
Perhaps it is worth for documentation:

import java.util.Map;
i
server
wbjrpub
wbjrpub commented Oct 18, 2019

My bitwarden-mssql docker container shows this
2019-10-17 23:59:01.42 spid52 BackupDiskFile::CreateMedia: Backup device '/etc/bitwarden/mssql/backups/vault_FULL_20191017_235901.BAK' failed to create. Operating system error 2(The system cannot find the file specified.).

I checked that within the docker container I could create this file using 'touch',
and I can see this file appear on the

jeduardo824
jeduardo824 commented Jul 18, 2019

After facing an issue caused by Ransack interpreting 1/'t' as true and some unsuccessful research, I found about the sanitize args and the recommended way to skip them. The documentation never mentions that ransackable_scopes_sanitize_args must be a class method and the example shown defines an instance method.

I think that's worth a documentation update, making more clear how to use th

ahmadkq
ahmadkq commented Nov 16, 2019

nopCommerce version: 4.2

Steps to reproduce the problem:
I wanted to show how much money remaining for free shipment. I couldn't find a widget inside the OrderSummary/default.cshtml before the
@await Component.InvokeAsync("OrderTotals", new { isEditable = Model.IsEditable }) line

It is good to have a widget there so we can add any warning message there

Created by Donald D. Chamberlin, Raymond F. Boyce

Released 1986

Wikipedia
Wikipedia

Related Topics

database php mysql
You can’t perform that action at this time.