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 11,107 public repositories matching this topic...

zz-jason
zz-jason commented Mar 25, 2020

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:

cd planner
go test -coverprofile=coverage.out # runs the unit test, writes the coverage profile to coverage.out
go tool cover -html=coverage.out   # displays the coverage report in your b
jy95
jy95 commented Dec 15, 2019

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', {
        // 
dt
dt commented Apr 15, 2020

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

JLsushmaumesh
JLsushmaumesh commented Mar 31, 2020

Document : https://osquery.io/schema/4.2.0
Table : md_devices [Software RAID array settings]

Column's :

  1. active_disks | INTEGER | Number of active disks in array
  2. failed_disks | INTEGER | Number of active disks in array
  3. 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
dbeaver
rojares
rojares commented Dec 2, 2018

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

presto
tdcmeehan
tdcmeehan commented Apr 21, 2020

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.

ClickHouse
l1t1
l1t1 commented Apr 22, 2020

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 │
└─────────┴─────────────────────┴───────┘
``
ComputerCarl
ComputerCarl commented Apr 10, 2020

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

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:/

ZQbd
ZQbd commented Sep 10, 2019

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":

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-
server
surister
surister commented Jan 21, 2020

This is a reminder for me or a task if anyone wants :P

imagen

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
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

Created by Donald D. Chamberlin, Raymond F. Boyce

Released 1986

Wikipedia
Wikipedia

Related Topics

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