Database

A database is a structured set of data held in a computer, most often a server. Databases use a database management system (DBMS) that interacts with users, similar to a lookup table. Modern databases are designed to allow for creation, querying, updating, and administration of the data it holds.
Here are 23,087 public repositories matching this topic...
Enhancement
Actual:
mysql> CREATE TABLE t1 (a BINARY(16) PRIMARY KEY);
Query OK, 0 rows affected (0.02 sec)
mysql> INSERT INTO t1 VALUES (AES_ENCRYPT('a','a'));
Query OK, 1 row affected (0.00 sec)
mysql> INSERT INTO t1 VALUES (AES_ENCRYPT('a','a'));
ERROR 1062 (23000): Duplicate entry '{ W]�u����.�٧t' for key 'PRIMARY'
Expected:
mysql> CREATE TABLE t1 (a BI
While writing string data (example = "121212121212121" -> string of all integer characters) into excel.
while user download and see, the downloaded xl/CSV, the data is shown in exponential format. Is there a way to show the same data. without converting into exponential in this case.
-
Updated
Jun 10, 2022 - JavaScript
-
Updated
Jun 26, 2022 - Clojure
-
Updated
Jun 25, 2022 - TypeScript
Windows throw errors when we try to read a dump in the CI (maybe that actually happens everywhere?).
See the following action: https://github.com/meilisearch/meilisearch/runs/6215426608?check_suite_focus=true
This could be related to [this issue](https://documentation.red-gate.com/sbu7/errors-and-warnings/other-errors/system-error-32-the-process-cannot-access-the-file-because-it-is-being-used-
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
There are several optimization the execution engine can perform when evaluating LIKE
patterns with %
, which matches zero or any number of any character. For example, see #80073.
Sequential %
s can prevent these optimizations, but they are semantically equivalent to a single %
, so the optimizer should normalize them to a single %
.
For example:
-- The following expressions
-
Updated
Mar 18, 2022 - C++
-
Updated
Jun 23, 2022 - Python
Bug description
On windows, I run prisma format
and note the unusual file ending. The lines are all LF, but the very last line is CRLF.
This causes issue on my Linux CI where it formats it ending in LF's only, causing a diff to occur and the build to fail.
How to reproduce
- On windows do prisma format
- Open in HxD or similar
- See attached:
, compaction (performed via the admin API), and defragmentation (via etcdctl), one etcd process crashed with the following error message: