summaryrefslogtreecommitdiff
path: root/storage/test_sql_discovery/mysql-test
Commit message (Collapse)AuthorAgeFilesLines
* Merge 10.5 into 10.6Marko Mäkelä2022-09-201-4/+4
|\
| * Merge remote-tracking branch 'origin/10.4' into 10.5Alexander Barkov2022-09-141-4/+4
| |\
| | * MDEV-29446 Change SHOW CREATE TABLE to display default collationAlexander Barkov2022-09-121-4/+4
| | |
* | | Merge 10.5 into 10.6Marko Mäkelä2021-10-281-0/+1
|\ \ \ | |/ /
| * | Merge 10.4 into 10.5Marko Mäkelä2021-10-281-0/+1
| |\ \ | | |/
| | * Merge 10.2 into 10.3Marko Mäkelä2021-10-281-0/+1
| | |\
| | | * Fix tests for PLUGIN_PARTITION=NOMarko Mäkelä2021-10-271-0/+1
| | | |
| | * | MDEV-19632 Replication aborts with ER_SLAVE_CONVERSION_FAILED upon CREATE ↵Alexander Barkov2020-08-011-1/+1
| | |/ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | ... SELECT in ORACLE mode - Adding optional qualifiers to data types: CREATE TABLE t1 (a schema.DATE); Qualifiers now work only for three pre-defined schemas: mariadb_schema oracle_schema maxdb_schema These schemas are virtual (hard-coded) for now, but may turn into real databases on disk in the future. - mariadb_schema.TYPE now always resolves to a true MariaDB data type TYPE without sql_mode specific translations. - oracle_schema.DATE translates to MariaDB DATETIME. - maxdb_schema.TIMESTAMP translates to MariaDB DATETIME. - Fixing SHOW CREATE TABLE to use a qualifier for a data type TYPE if the current sql_mode translates TYPE to something else. The above changes fix the reported problem, so this script: SET sql_mode=ORACLE; CREATE TABLE t2 AS SELECT mariadb_date_column FROM t1; is now replicated as: SET sql_mode=ORACLE; CREATE TABLE t2 (mariadb_date_column mariadb_schema.DATE); and the slave can unambiguously treat DATE as the true MariaDB DATE without ORACLE specific translation to DATETIME. Similar, SET sql_mode=MAXDB; CREATE TABLE t2 AS SELECT mariadb_timestamp_column FROM t1; is now replicated as: SET sql_mode=MAXDB; CREATE TABLE t2 (mariadb_timestamp_column mariadb_schema.TIMESTAMP); so the slave treats TIMESTAMP as the true MariaDB TIMESTAMP without MAXDB specific translation to DATETIME.
* | | MDEV-8334: Rename utf8 to utf8mb3Rucha Deodhar2021-05-191-1/+1
|/ / | | | | | | | | | | This patch changes the main name of 3 byte character set from utf8 to utf8mb3. New old_mode UTF8_IS_UTF8MB3 is added and set TRUE by default, so that utf8 would mean utf8mb3. If not set, utf8 would mean utf8mb4.
* | MDEV-19944 Remove GIS data types from keyword list in lex.hAlexander Barkov2019-07-041-1/+1
|/
* MDEV-13712 Spelling errors in the error messageSergei Golubchik2017-09-181-1/+1
|
* store/show vcols as item->print()Sergei Golubchik2016-12-121-1/+1
| | | | | | | | | | otherwise we'd need to store sql_mode *per vcol* (consider CREATE INDEX...) and how SHOW CREATE TABLE would support that? Additionally, get rid of vcol::expr_str, just to make sure the string is always generated and never leaked in the original form.
* do not quote numbers in the DEFAULT clause in SHOW CREATESergei Golubchik2016-08-271-1/+1
|
* Part of MDEV-10134 Add full support for DEFAULTMichael Widenius2016-06-301-1/+1
| | | | | | | Print default values for BLOB's. This is a part commit for automatic changes to make the real commit smaller. All changes here are related to that we now print DEFAULT NULL for blob and text fields, like we do for all other fields.
* MDEV-3929 Add system variable explicit_defaults_for_timestamp for ↵Alexander Barkov2015-09-222-2/+2
| | | | compatibility with MySQL
* MDEV-4955 discover of table non-existance on CREATESergei Golubchik2014-02-272-46/+0
| | | | | | Fix ha_table_exists() to take discovery into account correctly. It must be able to discover both table existence (when no frm is found) and table non-existance (when frm was found).
* 10.0-base mergeSergei Golubchik2014-02-031-1/+0
|\
| * make sequence and sql_discovery suites default tooSergei Golubchik2014-02-011-0/+7
| |
* | mtr: abort when a suite.pm fails to load, don't just ignore the errors.Sergei Golubchik2013-12-221-1/+1
| | | | | | | | Fix all suite.pm files that had errors and test files that were skipped because of that
* | Percona-Server-5.6.14-rel62.0 mergeSergei Golubchik2013-12-221-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | support ha_innodb.so as a dynamic plugin. * remove obsolete *,innodb_plugin.rdiff files * s/--plugin-load=/--plugin-load-add=/ * MYSQL_PLUGIN_IMPORT glob_hostname[] * use my_error instead of push_warning_printf(ER_DEFAULT) * don't use tdc_size and tc_size in a module update test cases (XtraDB is 5.6.14, InnoDB is 5.6.10) * copy new tests over * disable some tests for (old) InnoDB * delete XtraDB tests that no longer apply small compatibility changes: * s/HTON_EXTENDED_KEYS/HTON_SUPPORTS_EXTENDED_KEYS/ * revert unnecessary InnoDB changes to make it a bit closer to the upstream fix XtraDB to compile on Windows (both as a static and a dynamic plugin) disable XtraDB on Windows (deadlocks) and where no atomic ops are available (e.g. CentOS 5) storage/innobase/handler/ha_innodb.cc: revert few unnecessary changes to make it a bit closer to the original InnoDB storage/innobase/include/univ.i: correct the version to match what it was merged from
* | 10.0-base mergeSergei Golubchik2013-12-161-0/+8
|\ \ | |/
* | Fix a first timestamp column in the sql-based table discoverySergei Golubchik2013-11-251-1/+1
| |
* | MDEV-5260 discovery with sql is too restrictiveSergei Golubchik2013-11-102-9/+17
| | | | | | | | | | allow ENGINE=FOOBAR in the discovering create table statement, as long as the discovering engine is FOOBAR too
* | MDEV-4786 - merge 10.0-monty → 10.0Sergey Vojtovich2013-07-231-2/+2
|/ | | | | | | | | | | Fixed test_sql_discovery compilation failure. storage/test_sql_discovery/mysql-test/archive/discover.rdiff: archive.discover result has changed during merge. Adjusted discover.rdiff accordingly. storage/test_sql_discovery/test_sql_discovery.cc: Adjusted test_sql_discovery according to: WL#4305 - storage-engine private data area per physical table.
* MDEV-4450 misleading error messages from init_from_sql_statement_string()Sergei Golubchik2013-06-152-53/+45
|
* error messages: name the storage engine explicitly,Sergei Golubchik2013-04-091-12/+12
| | | | instead of "used storage engine" and similar changes.
* mysql-test fixesSergei Golubchik2013-04-092-11/+1
|
* * frm extra2 segment.Sergei Golubchik2013-04-091-0/+35
| | | | | | | | * persistent table versions in the extra2 * ha_archive::frm_compare using TABLE_SHARE::tabledef_version * distinguish between "important" and "optional" extra2 frm values * write engine-defined attributes (aka "table options") to extra2, not to extra, but still read from the old location, if they're found there.
* test_sql_discovery storage engineSergei Golubchik2013-04-0913-0/+380
use it to test main test cases with need_full_discover_for_existence > 0
View Lorry Controller Status