SQL

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 11,107 public repositories matching this topic...
Issue Description
What are you doing?
I have a model that contained precomputed fields including a column that is an array of int (tags_ids
). Here is its definition :
'use strict';
// This sub table is useful to save computation times for search
module.exports = (sequelize, DataTypes) => {
let Exercise_Metrics = sequelize.define('Exercise_Metrics', {
//
We currently store encoded protobuf messages in bytes
columns in many cases, as they neatly handle collecting and encoding system-specific fields. However currently this has the downside of making that column totally opaque to SQL interactions -- in order to manually read a given field, or even harder, manipulate one, we end up copy-pasting those bytes out protoc
or custom-written one-off prog
Document : https://osquery.io/schema/4.2.0
Table : md_devices [Software RAID array settings]
Column's :
- active_disks | INTEGER | Number of active disks in array
- failed_disks | INTEGER | Number of active disks in array
- spare_disks | INTEGER | Number of active disks in array
4.check_array_progress | TEXT | Progress of the resync activity
5.check_array_finish | TEXT | Estimated dur
We consider to introduce the SqlSessionManager
on reference documentation. It provide thread safe implementation of SqlSession
.
Related issues
- #1529
Now you can view common image files inside DBeaver when editing table data. You can open/save the binary data from/to filesystem. What would be very useful is the ability to open a CLOB value in external editor. For example storing pdf files into database would become convenient because the user could open the value in a pdf reader to check the contents of the value. Opening in external editor wou
In the documentation it states that the query cache is cleaned up, once in a while. However looking at the code it looks like it clears the entire cache every 1000 queries. This is due to the check in this line:
COLLECT_HIT_COUNT_MIN is defined as:
https://github.com/StackExchange/D
Environment
Knex version: 0.20.10
Database + version: Postgres 12
Bug
- Explain what kind of behaviour you are getting and how you think it should do
knex.raw("?", [
knex.insert({ id: "b", fields: { a: undefined } }).into("test"),
])
- Error message
Throw NullPointException when INSERT column and values mismatch.
It is better to throw suitable SQLException for JDBC-driver and proxy.
The tasks are:
- Throw suitable SQLException for JDBC-driver.
- Report suitable error packet with MySQL proxy.
- Report suitable error packet with PostgreSQL proxy.
We have a value_at_quantile
function for QDigest types. Occasionally, it's useful to also retrieve a quantile given a value (say, for X, which percentile in the QDigest does it fall under).
The signature would look like the following:
quantile_at_value(qdigest(T), DOUBLE) -> T
Where T is one of DOUBLE
, REAL
or BIGINT
.
for example,
i want it output,
+-EventID-+-----------EventTime-+-delta-+
| 1106 | 2016-11-24 00:00:04 | 0 |
| 1110 | 2016-11-24 00:00:10 | 1 |
+---------+---------------------+-------+
but now it outputs
┌─EventID─┬───────────EventTime─┬─delta─┐
│ 1106 │ 2016-11-24 00:00:04 │ 0 │
│ 1110 │ 2016-11-24 00:00:10 │ 1 │
└─────────┴─────────────────────┴───────┘
``
Issue description
GitHub changed how issue templates work. We should update ours:
You are using an old version of issue templates. Please update to the new issue template workflow. Learn more
We are suddenly running out of background workers and were told on Slack to increase timescaledb.max_background_workers
from 8 to 16.
The documentation makes it seem like the timescaledb-tune tool will automatically set the key to a correct value. However the tool [always sets the value to 8](https://github.com/timescale/timesca
-
Updated
Apr 21, 2020 - Java
I have been testing q and I've found something that could be an issue.
Issue
When I'm doing something like round(avg(c3),3)
when querying, is rounding this 32655,5265 to this 32655,526 instead of expected result: 32655,527.
I think that could be an issue, or should be configurable.
Cheers.
Using version 8.5.5
If I create a new field of type WYSIWYG, I can add the code below in the Options -> Advanced Options -> TinyMCE Options. It will work as expected and spellcheck will be performed while typing.
However, I cannot add the option after the field exists.
When trying to save, I get the error;
"Trouble processing the request. Try again after refreshing the page."
T
The on-line demo at http://kripken.github.io/sql.js/examples/GUI/ does not give error messages (for wrong SQL or missing tables or attributes).
The version of @lovasoa does: http://lovasoa.github.io/sql.js/GUI/
Documentation?
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:/
It looks like a great tool, is it possible to translate the documentation to English?
6.3版本REGEXP有问题
sql如下:select * from testreg where text.keyword <> REGEXP("?")
翻译的dsl如下:可以看到翻译的dsl是must,应该是must_not才对
{
"from": 0,
"size": 200,
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"regexp": {
"text.keyword": {
"value": "?",
"flags_value": 65535,
"max_determinized_states": 10000,
"boost":
-
Updated
Mar 8, 2020 - Go
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-
Hi,
Similar to issue #125 it would be good to allow the same for the letsencrypt certbot container, could you please add a bind IP question during the bitwarden.sh install part in the letsencrypt section.
And something similar with (or storing the information for later in the previous
## Python/Regex fix
This is a reminder for me or a task if anyone wants :P
Basically, The last two questions aren't really regex's questions.
To do:
- Move said questions to correct place.
- Add new regex questions (Python related!)?
- Maybe add a new ## Regex section, as it is a valuable skill
-
Updated
Apr 22, 2020 - Java
nopCommerce version: 4.30 beta
Steps to reproduce the problem:
Try to install the nopcommerce 4.30 beta ,
At installation page in SQL Password, text box type is change password to text
Here is the screenshot: https://prnt.sc/rsjawo
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
Description
As the title said, this task is aimed to improve the unit test coverage of package
planner
. You can generate the coverage report and view it in browser with the following commands: