jennifersp
jennifersp
Fixed a case of table has `col1` and it's used in the query for referencing this column, and using it for alias name for this column and using it for...
In MySQL: ``` mysql> with recursive t (n) as (select sum(1) from dual union all select (2.00) from dual) select sum(n) from t; +--------+ | sum(n) | +--------+ | 3.00...
In MySQL: ``` >SELECT DISTINCT val FROM (values row(1.00), row(1), row(2), row(2)) a (val); +------+ | val | +------+ | 1.00 | | 2.00 | +------+ ``` In Dolt: ```...
Syntax is supported for [this issue](https://github.com/dolthub/dolt/issues/2203), but some cases returns incorrect result. The query returning incorrect result: ``` select a.* from one_pk_two_idx a LEFT JOIN (one_pk_two_idx i JOIN one_pk_three_idx j...
When FK check is off, we currently ignore all FK constraints for any statements. According to [MySql documentations on FK check](https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_foreign_key_checks), there are couple cases that needs FK constraints check:...
These tests are consistently failing with error message: `# rm: cannot remove '/d/a/batstmp/dolt-bats-tests-l7bG5X/remotes-1377/test-org/test-repo/3e2k5sldj7srhghkvts1tcihmpv86hks': Device or resource busy` - garbage_collection.bats - git-dolt.bats - remotes.bats - sql-server-config.bats - sql-server-schema-fragments.bats - sql-server.bats -...
Repro enginetest: ``` { Name: "simple decimal type insert", SetUpScript: []string{ "CREATE TABLE test(id int primary key auto_increment, decimal_col DECIMAL(9,2))", }, Assertions: []queries.ScriptTestAssertion{ { Query: "INSERT INTO test(decimal_col) VALUES (?)",...
Currently, `dolt dump` does not include `CREATE DATABASE IF NOT EXISTS ...; USE db;` queries for sql file dumps. If the dump is imported to dolt in non database directory,...
``` Dolt> select 2000.0 / 250000000.0 * (24.0 * 6.0 * 6.25 * 10.0); +---------------------------------------------------+ | 2000.0 / 250000000.0 * (24.0 * 6.0 * 6.25 * 10.0) | +---------------------------------------------------+ |...