summaryrefslogtreecommitdiff
path: root/mysql-test/t/variables.test
Commit message (Collapse)AuthorAgeFilesLines
* A patch for Bug#34820: log_output can be set to illegal value.anozdrin/alik@quad.opbmk2008-03-281-0/+17
| | | | | | | | | | We have "set" variables, which can accept empty values (like sql_mode), and which can not (like log_output). The problem was that the code does not distinguish them and allow empty values for every set variable. The fix is to introduce an attribute of a set variable telling whether it can accept empty values.
* variables.result, variables.test:serg@janus.mylan2007-12-211-1/+1
| | | | test case fixed
* Merge janus.mylan:/usr/home/serg/Abk/mysql-5.0serg@janus.mylan2007-12-191-3/+3
|\ | | | | | | into janus.mylan:/usr/home/serg/Abk/mysql-5.1
| * correct invalid values in SET GLOBAL var=DEFAULTserg@janus.mylan2007-12-191-1/+1
| | | | | | | | bug#33382
| * Merge tnurnberg@bk-internal.mysql.com:/home/bk/mysql-5.0-opttnurnberg@white.intern.koehntopp.de2007-12-061-1/+1
| |\ | | | | | | | | | into mysql.com:/misc/mysql/31177/50-31177
| | * Bug#31177: Server variables can't be set to their current valuestnurnberg@mysql.com/white.intern.koehntopp.de2007-12-031-1/+1
| | | | | | | | | | | | additional fixes for 64-bit
| * | Merge tnurnberg@bk-internal.mysql.com:/home/bk/mysql-5.0-opttnurnberg@white.intern.koehntopp.de2007-12-021-1/+1
| |\ \ | | |/ | | | | | | into mysql.com:/misc/mysql/31177/50-31177
| | * Bug#31177: Server variables can't be set to their current valuestnurnberg@mysql.com/white.intern.koehntopp.de2007-11-301-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Default values of variables were not subject to upper/lower bounds and step, while setting variables was. Bounds and step are also applied to defaults now; defaults are corrected quietly, values given by the user are corrected, and a correction-warning is thrown as needed. Lastly, very large values could wrap around, starting from 0 again. They are bounded at the maximum value for the respective data-type now if no lower maximum is specified in the variable's definition.
| * | Merge mysql.com:/home/gluh/MySQL/Merge/5.0gluh@eagle.(none)2007-11-141-1/+1
| |\ \ | | |/ | |/| | | | into mysql.com:/home/gluh/MySQL/Merge/5.0-opt
| | * Post-merge fixistruewing@stella.local2007-11-011-1/+1
| | |
| * | Merge polly.(none):/home/kaa/src/opt/bug29131/my50-bug29131kaa@polly.(none)2007-10-291-0/+14
| |\ \ | | |/ | |/| | | | into polly.(none):/home/kaa/src/opt/mysql-5.0-opt
| | * Fix for bug #29131: SHOW VARIABLES reports variable 'log' but SETkaa@polly.(none)2007-10-251-0/+14
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | doesn't recognize it This is a 5.0 version of the patch, it will be null-merged to 5.1 Problem: 'log' and 'log_slow_queries' were "fixed" variables, i.e. they showed up in SHOW VARIABLES, but could not be used in expressions like "select @@log". Also, using them in the SET statement produced an incorrect "unknown system variable" error. Solution: Make 'log' and 'log_slow_queries' read-only dynamic variables to make them available for use in expressions, and produce a correct error about the variable being read-only when used in the SET statement.
| * | Merge mysql.com:/home/gluh/MySQL/Merge/5.0gluh@eagle.(none)2007-10-231-1/+8
| |\ \ | | | | | | | | | | | | into mysql.com:/home/gluh/MySQL/Merge/5.0-opt
* | \ \ Merge stella.local:/home2/mydev/mysql-5.1-amainistruewing@stella.local2007-10-311-1/+1
|\ \ \ \ | | | | | | | | | | | | | | | into stella.local:/home2/mydev/mysql-5.1-axmrg
| * | | | Post-merge fixistruewing@stella.local2007-10-301-1/+1
| | | | |
* | | | | Merge mysql.com:/home/gluh/MySQL/Merge/5.1gluh@eagle.(none)2007-10-231-1/+8
|\ \ \ \ \ | |/ / / / |/| | | | | | | | | into mysql.com:/home/gluh/MySQL/Merge/5.1-opt
| * | | | Merge sin.intern.azundris.com:/misc/mysql/31588/50-31588tnurnberg@sin.intern.azundris.com2007-10-181-1/+8
| |\ \ \ \ | | | |/ / | | |/| | | | | | | into sin.intern.azundris.com:/misc/mysql/31588/51-31588
| | * | | Merge sin.intern.azundris.com:/misc/mysql/31588/41-31588tnurnberg@sin.intern.azundris.com2007-10-181-1/+8
| | |\ \ \ | | | |_|/ | | |/| | | | | | | into sin.intern.azundris.com:/misc/mysql/31588/50-31588
| | | * | Bug#31588: buffer overrun when setting variablestnurnberg@sin.intern.azundris.com2007-10-181-1/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Buffer used when setting variables was not dimensioned to accomodate trailing '\0'. An overflow by one character was therefore possible. CS corrects limits to prevent such overflows.
* | | | | Merge polly.(none):/home/kaa/src/maint/bug5731/my50-bug5731kaa@polly.(none)2007-10-041-0/+1
|\ \ \ \ \ | |/ / / / |/| | | / | | |_|/ | |/| | into polly.(none):/home/kaa/src/maint/bug5731/my51-bug5731
| * | | Issue a warning if a user sets an option or a variable to a value that is ↵kaa@polly.(none)2007-10-041-0/+1
| |/ / | | | | | | | | | | | | | | | greater than a defined maximum for the option/variable. This is for bug #29446 "Specifying a myisam_sort_buffer > 4GB on 64 bit machines not possible". Support for myisam_sort_buffer_size > 4 GB on 64-bit Windows will be looked at later in 5.2.
* | | Simplify logging code a bit (to make code smaller and faster)monty@mysql.com/nosik.monty.fi2007-08-031-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | Moved duplicated code to inline function store_timestamp() Save thd->time_zone_used when logging to table as CSV internally cases it to be changed Added MYSQL_LOCK_IGNORE_FLUSH to log tables to avoid deadlock in case of flush tables. Mark log tables with TIMESTAMP_NO_AUTO_SET to avoid automatic timestamping Set TABLE->no_replicate on open
* | | Slow query log to file now displays queries with microsecond precissionmonty@mysql.com/nosik.monty.fi2007-07-301-1/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | --long-query-time is now given in seconds with microseconds as decimals --min_examined_row_limit added for slow query log long_query_time user variable is now double with 6 decimals Added functions to get time in microseconds Added faster time() functions for system that has gethrtime() (Solaris) We now do less time() calls. Added field->in_read_set() and field->in_write_set() for easier field manipulation by handlers set_var.cc and my_getopt() can now handle DOUBLE variables. All time() calls changed to my_time() my_time() now does retry's if time() call fails. Added debug function for stopping in mysql_admin_table() when tables are locked Some trivial function and struct variable renames to avoid merge errors. Fixed compiler warnings Initialization of some time variables on windows moved to my_init()
* | | Bug#28580 Repeatation of status variablesgluh@mysql.com/eagle.(none)2007-06-061-0/+6
| | | | | | | | | | | | removed duplicated variable declarations
* | | Merge bk-internal.mysql.com:/home/bk/mysql-5.1-enginesistruewing@chilla.local2007-04-271-8/+8
|\ \ \ | | | | | | | | | | | | into chilla.local:/home/mydev/mysql-5.1-wl2936-two
| * \ \ Merge bk-internal.mysql.com:/home/bk/mysql-5.1serg@sergbook.mysql.com2007-04-161-8/+8
| |\ \ \ | | | | | | | | | | | | | | | into sergbook.mysql.com:/usr/home/serg/Abk/mysql-5.1-wl2936
| | * | | WL#2936antony@ppcg5.local2007-03-021-8/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | "Server Variables for Plugins" Implement support for plugins to declare server variables. Demonstrate functionality by removing InnoDB specific code from sql/* New feature for HASH - HASH_UNIQUE flag New feature for DYNAMIC_ARRAY - initializer accepts preallocated ptr. Completed support for plugin reference counting.
* | | | | Merge mysql.com:/home/bar/mysql-5.0-rplbar@mysql.com2007-04-091-0/+24
|\ \ \ \ \ | |/ / / / |/| | / / | | |/ / | |/| | into mysql.com:/home/bar/mysql-5.1-new-rpl
| * | | Bug#22648 LC_TIME_NAMES: Setting GLOBAL has no effectbar@mysql.com2007-04-091-0/+24
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Problem: setting/displaying @@LC_TIME_NAMES didn't distinguish between GLOBAL and SESSION variable types - always SESSION variable was set/shonw. Fix: set either global or session value. Also, "mysqld --lc-time-names" was added to set "global default" value.
* | | | Make sure tests drops objects created and restore variables to default msvensson@pilot.blaudden2007-03-011-4/+4
| | | |
* | | | Merge pilot.blaudden:/home/msvensson/mysql/bug20166/my50-bug20166msvensson@pilot.blaudden2007-02-201-0/+11
|\ \ \ \ | |/ / / | | / / | |/ / |/| | into pilot.blaudden:/home/msvensson/mysql/bug20166/my51-bug20166
| * | Bug#20166 mysql-test-run.pl does not test system privilege tables creationmsvensson@pilot.blaudden2007-02-201-0/+11
| | | | | | | | | | | | - Part 2, add @@hostname system variable
* | | Merge mysql.com:/usr/home/bar/mysql-5.0.b22645bar@bar.intranet.mysql.r18.ru2006-12-051-0/+44
|\ \ \ | |/ / | | | | | | into mysql.com:/usr/home/bar/mysql-5.1.b22645
| * | Merge mysql.com:/usr/home/bar/mysql-4.1.b22645bar@mysql.com/bar.intranet.mysql.r18.ru2006-12-051-0/+44
| |\ \ | | |/ | | | | | | into mysql.com:/usr/home/bar/mysql-5.0.b22645
| | * Bug#22645 LC_TIME_NAMES: Statement not replicatedbar@mysql.com/bar.intranet.mysql.r18.ru2006-12-051-0/+44
| | | | | | | | | | | | | | | | | | | | | Problem: replication of LC_TIME_NAMES didn't work. Thus, INSERTS or UPDATES using date_format() always worked with en_US on the slave side. Fix: adding ONE_SHOT implementation for LC_TIME_NAMES.
* | | Merge mysql.com:/users/lthalmann/bkroot/mysql-5.1-new-rpllars/lthalmann@dl145j.mysql.com2006-09-151-0/+50
|\ \ \ | | | | | | | | | | | | into mysql.com:/users/lthalmann/bk/MERGE/mysql-5.1-merge
| * | | WL#3247,#3248: Adding [GLOBAL|SESSION]_STATUS and [GLOBAL|SESSION]_VARIABLESaivanov/alexi@mysql.com/mysqld.localdomain2006-09-141-0/+50
| | | | | | | | | | | | | | | | tables to INFORMATION_SCHEMA.
* | | | Merge maint1.mysql.com:/data/localhome/cmiller/bug20908/my50-bug20908cmiller@maint1.mysql.com2006-08-151-0/+11
|\ \ \ \ | |/ / / |/| / / | |/ / into maint1.mysql.com:/data/localhome/cmiller/bug20908/my51-bug20908
| * | Bug #20908: Crash if select @@""cmiller@maint1.mysql.com2006-08-151-0/+11
| | | | | | | | | | | | | | | | | | Zero-length variables caused failures when using the length to look up the name in a hash. Instead, signal that no zero-length name can ever be found and that to encounter one is a syntax error.
* | | Merge zippy.(none):/home/cmiller/work/mysql/merge/tmp_mergecmiller@zippy.(none)2006-07-101-0/+16
|\ \ \ | |/ / | | | | | | into zippy.(none):/home/cmiller/work/mysql/merge/mysql-5.1
| * | Additional test for Bugs#20392: INSERT_ID session variable has weird valuebar@mysql.com2006-06-221-0/+6
| | | | | | | | | | | | | | | sys_var_insert_id returned LAST_INSERT_ID instead of INSERT_ID, as Guilhem suggested.
| * | Bugs#20392: INSERT_ID session variable has weird valuebar@mysql.com2006-06-221-0/+10
| | | | | | | | | | | | sys_var_insert_id returned LAST_INSERT_ID instead of INSERT_ID.
* | | Merge mysql.com:/home/jimw/my/mysql-5.0-cleanjimw@mysql.com2006-05-191-3/+36
|\ \ \ | |/ / | | | | | | into mysql.com:/home/jimw/my/mysql-5.1-clean
| * | Merge mysql.com:/home/jimw/my/mysql-5.0-1039jimw@mysql.com2006-05-191-3/+36
| |\ \ | | | | | | | | | | | | into mysql.com:/home/jimw/my/mysql-5.0-clean
| | * | Bug #1039: tmpdir and datadir not available via @@ system variable syntaxjimw@mysql.com2006-05-081-0/+30
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Bug #19606: ssl variables are not displayed in show variables Bug #19616: log_queries_not_using_indexes is not listed in show variables Make basedir, datadir, tmpdir, log_queries_not_using_indexes, ssl_ca, ssl_capath, ssl_cert, ssl_cipher, and ssl_key all available both from SHOW VARIABLES and as @@variables. As a side-effect of this change, log_queries_not_using_indexes can be changed at runtime (but only globally, not per-connection).
* | | | Merge mysql.com:/home/tmp_mergetnurnberg@mysql.com2006-05-161-0/+62
|\ \ \ \ | |/ / / | | | | | | | | into mysql.com:/home/mysql-5.1-18997e
| * | | Bug#19263: variables.test doesn't clean up after itselftnurnberg@mysql.com2006-05-081-0/+62
| |/ / | | | | | | | | | save global server variables before fiddling with them and restore them later
* | | Merge mysql.com:/home/jimw/my/tmp_mergejimw@mysql.com2006-04-301-2/+38
|\ \ \ | |/ / | | | | | | into mysql.com:/home/jimw/my/mysql-5.1-clean
| * | Merge mysql.com:/home/jimw/my/mysql-5.0-12792jimw@mysql.com2006-04-261-1/+18
| |\ \ | | | | | | | | | | | | into mysql.com:/home/jimw/my/mysql-5.0-clean
| | * | Bug #12792: @@system_time_zone is not SELECTablejimw@mysql.com2006-04-201-2/+19
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Bug #15684: @@version_* are not all SELECTable Added the appropriate information as read-only system variables, and also removed some special-case handling of @@version along the way. @@version_bdb was added, but isn't included in the test because it depends on the presence of BDB.
View Lorry Controller Status