Development Task

create a table:

CREATE TABLE `t` (
  `a` bigint(20) DEFAULT NULL,
  `b` bigint(20) DEFAULT NULL,
  KEY `idx` (`a`)
);

querying that table with an index hint which uses an undefined index aaa:

TiDB(root@127.0.0.1:test) > select /*+ force_index(aaa) */ * from t;
Empty set, 1 warning (0.00 sec)

TiDB(root@127.0.0.1:test) > show warnings;
+---

Issue Description

Is your feature request related to a problem? Please describe.

When doing some migrations, I would like to delete a column created in a previous migration.
However, this is not possible with the current code for some scenarios.

An example :
migration v3

'use strict';

let opts = {tableName: 'Exercises'};

module.exports = {
    up: (queryInterf

PG 12 supports AS MATERIALIZED and AS NOT MATERIALIZED syntax for user controller of CTE materialization. For example:

WITH x AS MATERIALIZED (SELECT * FROM very_large_table) SELECT * FROM x;

With this syntax, the user can override the optimizer's default decision to not materialize that table (since it's only referenced once).

WITH x AS NOT MATERIALIZED (SELECT * FROM very_s

There is an inconsistency in the table spec for process_open_pipes. The spec was placed in POSIX, while the table is only built for Linux. Might it actually support macOS if the CMake was modified? If not, should the spec be moved to linux?

https://github.com/osquery/osquery/pull/6142/files

We consider to introduce the SqlSessionManager on reference documentation. It provide thread safe implementation of SqlSession.

Related issues

• #1529

How to change color of menu bar and scrollings to dark color in darkest dark theme?
and light borders around the fields?
it looks strange in dark theme

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:

https://github.com/StackExchange/Dapper/blob/d19d6012e75feebf24d591ad21b16f13becc95f2/Dapper/SqlMapper.cs#L78

COLLECT_HIT_COUNT_MIN is defined as:
https://github.com/StackExchange/D

Environment

Knex version: 0.20.10
Database + version: Postgres 12

Bug

1. 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"),
])

2. Error message

FileSystemContext in presto-raptor can now be replaced by HdfsContext given presto-hive-metastore has been separated into a standalone module.

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.

Describe the bug or unexpected behaviour

milovidov-Pro-P30 :) SELECT toDateTime(1583851242, 'Asia/Shanghai')

SELECT toDateTime(1583851242, 'Asia/Shanghai')

┌─toDateTime(1583851242, 'Asia/Shanghai')─┐
│                     2020-03-10 22:40:42 │
└─────────────────────────────────────────┘

1 rows in set. Elapsed: 0.087 sec. 

milovidov-Pro-P30 :) SELECT toDateTimeOrNull(1583851

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

See: https://help.github.com/en/article

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 

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?

http://essql.nlpcn.org/ seems to be not working. Could you help me the page where can I get the full syntax for all supported queries like how to use

1. has_children
   2.has_parent,
2. like query (select * from index where field like 'test*'), here I need to use "test" as lower case and '*' which is not the same as sql.

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-

Right now the Equivalent Domains is sent from the client and stored on the server in plain text. This should be encrypted on the client the same as passwords/sites.

This isn't a huge security issue, but if the database was compromised then the list of domains would be available from each account. This list of domains would be ones that the user has accounts on creating a privacy issue.

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

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 API

Which database are you using (type & version)?

H2

Which operating system are you using?

Mac OSX

What did you do?

Create migration files using semantic version

What did you expect

We could use the Markdown format in topics, or for example use some parts of the documentation to display them on the administration panel as help.

This requires further investigation before an issue should be opened in pandas. Documented in tests here:

https://github.com/modin-project/modin/blob/master/modin/pandas/test/test_groupby.py#L149-L155

This behavior is different inside and outside of pytest. We need to check to see if any of the previous groupby calls are changing the apply output.

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