summaryrefslogtreecommitdiff
path: root/sql/sql_parse.cc
Commit message (Collapse)AuthorAgeFilesLines
* Fixed handling of lower_case_table_names in SHOW TABLE STATUS, ↵unknown2003-01-291-16/+9
| | | | | | | | | | | | | | | | | | | | | | | mysql_list_fields() and mysql_table_dump(). This fixes some Errcode 13 errors on Windows when deleting tables. sql/mysql_priv.h: Moved lower case conversion of database names to check_db_name() sql/mysqld.cc: Fix to be able to use 4.0 error message files sql/sql_db.cc: Moved lower case conversion of database names to check_db_name() sql/sql_parse.cc: Moved lower case conversion of database names to check_db_name() Added checking of lower_case_table_names for mysql_table_dump() and mysql_list_fields() sql/sql_show.cc: Moved lower case conversion of database names to check_db_name() sql/table.cc: Convert database names to lower case in check_db-name() if --lower-case-table-names is used.
* fixed double-free bug in COM_CHANGE_USERunknown2003-01-211-1/+1
|
* Only set thd->query to 0 if LOCK_thread_count is holdunknown2003-01-181-9/+8
| | | | | | | | | | | | | This fixes a possible core dump problem in SHOW PROCESSLIST sql/slave.cc: Only set thd->query to 0 if LOCK_thread_count is hold sql/sql_db.cc: Only set thd->query to 0 if LOCK_thread_count is hold Also first set query_length, then query sql/sql_parse.cc: Indentation changes
* Forbid SLAVE STOP if the thread executing the query has lockedunknown2002-12-131-0/+18
| | | | | | | tables. This removes a possible deadlock situation.
* proper casting in COM_TABLE_DUMP (backported from 4.0)unknown2002-12-041-2/+2
|
* Security bug: password length check should be in check_user, not ↵unknown2002-12-041-2/+2
| | | | | | | | | check_connections(), otherwise COM_CHANGE_USER is unprotected and can be used for both privilege escalation and buffer overrun
* fixed race that caused sig11s on simultaneous FLUSH LOGSunknown2002-10-071-4/+4
| | | | | | | | | | | | | (possibly also fixes binlog filename corruption problems--hasn't been reproduced since) sql/log.cc: Fixed race caused by calling MYSQL_LOG::is_open() outside of critical section. sql/sql_parse.cc: added missing args to calls to MYSQL_LOG::new_file(bool) BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* Change name -> alias in TABLE_LIST.unknown2002-09-211-10/+22
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added missing mutex-lock around critical section in GRANT handling. Docs/manual.texi: ChangeLog sql/lock.cc: Change name -> alias in TABLE_LIST. sql/slave.cc: Change name -> alias in TABLE_LIST. sql/sql_acl.cc: Added missing mutex-lock around critical section in GRANT handling. Changed name -> alias sql/sql_base.cc: Change name -> alias in TABLE_LIST. sql/sql_insert.cc: Change name -> alias in TABLE_LIST. sql/sql_parse.cc: Change name -> alias in TABLE_LIST. sql/sql_show.cc: Change name -> alias in TABLE_LIST. sql/sql_table.cc: Change name -> alias in TABLE_LIST. sql/sql_udf.cc: Change name -> alias in TABLE_LIST. sql/table.h: Change name -> alias in TABLE_LIST. tests/grant.pl: Fixed grant test
* Do handler specific drop-database at safe place.unknown2002-07-141-1/+2
| | | | | | | | | | Fix for access problem (merge from 4.0) sql/sql_db.cc: Do handler specific drop-database at safe place. sql/sql_parse.cc: Fix for access problem (merge from 4.0)
* Many files:unknown2002-07-081-0/+13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Merge InnoDB-3.23.52b innobase/btr/btr0btr.c: Merge InnoDB-3.23.52b innobase/btr/btr0cur.c: Merge InnoDB-3.23.52b innobase/btr/btr0sea.c: Merge InnoDB-3.23.52b innobase/buf/buf0buf.c: Merge InnoDB-3.23.52b innobase/ha/ha0ha.c: Merge InnoDB-3.23.52b innobase/ibuf/ibuf0ibuf.c: Merge InnoDB-3.23.52b innobase/include/btr0cur.h: Merge InnoDB-3.23.52b innobase/include/buf0buf.h: Merge InnoDB-3.23.52b innobase/include/ha0ha.h: Merge InnoDB-3.23.52b innobase/include/ibuf0ibuf.h: Merge InnoDB-3.23.52b innobase/include/lock0lock.h: Merge InnoDB-3.23.52b innobase/include/log0log.h: Merge InnoDB-3.23.52b innobase/include/os0file.h: Merge InnoDB-3.23.52b innobase/include/rem0rec.ic: Merge InnoDB-3.23.52b innobase/include/srv0srv.h: Merge InnoDB-3.23.52b innobase/include/sync0arr.h: Merge InnoDB-3.23.52b innobase/include/sync0sync.h: Merge InnoDB-3.23.52b innobase/include/trx0trx.h: Merge InnoDB-3.23.52b innobase/lock/lock0lock.c: Merge InnoDB-3.23.52b innobase/log/log0log.c: Merge InnoDB-3.23.52b innobase/os/os0file.c: Merge InnoDB-3.23.52b innobase/row/row0mysql.c: Merge InnoDB-3.23.52b innobase/row/row0umod.c: Merge InnoDB-3.23.52b innobase/row/row0upd.c: Merge InnoDB-3.23.52b innobase/srv/srv0srv.c: Merge InnoDB-3.23.52b innobase/srv/srv0start.c: Merge InnoDB-3.23.52b innobase/sync/sync0arr.c: Merge InnoDB-3.23.52b innobase/sync/sync0sync.c: Merge InnoDB-3.23.52b innobase/trx/trx0trx.c: Merge InnoDB-3.23.52b sql/ha_innobase.h: Merge InnoDB-3.23.52b sql/ha_innobase.cc: Merge InnoDB-3.23.52b sql/sql_lex.h: Merge InnoDB-3.23.52b sql/mysqld.cc: Merge InnoDB-3.23.52b sql/sql_parse.cc: Merge InnoDB-3.23.52b sql/sql_yacc.yy: Merge InnoDB-3.23.52b
* Renamed stripp_sp -> strip_spunknown2002-05-271-7/+9
| | | | | | | | | | | | | | | | | | | | | | | Remove end space from ENUM and SET strings mysql-test/t/type_enum.test: Test of end space in enum's Docs/manual.texi: Changelog include/my_sys.h: Renamed stripp_sp -> strip_sp mysql-test/r/type_enum.result: Test of end space in enums mysys/Makefile.am: change stripp_sp -> strip_sp mysys/mf_strip.c: change stripp_sp -> strip_sp sql/sql_db.cc: change stripp_sp -> strip_sp sql/sql_parse.cc: change stripp_sp -> strip_sp Remove end space from ENUM and SET strings
* Don't change FLOAT(X+1,X) to FLOAT(X+2,X)unknown2002-04-261-2/+2
| | | | | | | | | Docs/manual.texi: ChangeLog mysql-test/r/show_check.result: Updated test for SHOW COLUMNS mysql-test/t/show_check.test: Updated test for SHOW COLUMNS
* Fixed pthread_cond_timedwait() for HPUX and DCE threadsunknown2002-04-161-1/+1
| | | | | | | | | | | | | | | | | | Cleanup of LIBWRAP handling Docs/manual.texi: Changelog include/my_pthread.h: Fixed pthread_cond_timedwait() for HPUX and DCE threads mysys/my_pthread.c: Fixed pthread_cond_timedwait() for HPUX and DCE threads sql/item_func.cc: Fixed the GET_LOCK() works with HPUX and DCE threads sql/mysqld.cc: Cleanup of LIBWRAP handling sql/sql_parse.cc: Safety fix
* Don't give warnings for empty statements with commentsunknown2002-02-141-0/+4
|
* Made LOAD DATA LOCAL INFILE more secureunknown2002-02-131-1/+8
| | | | | | | | | Docs/manual.texi: Changelog sql/sql_yacc.yy: optimization BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* make replication work correctly if the master logs SELECT RELEASE_LOCK() unknown2001-12-181-4/+17
| | | | | | | | instead of DO RELEASE_LOCK() mysql-test/t/rpl_get_lock.test: test for SELECT RELEASE() replication bug
* Added DO commandunknown2001-12-171-0/+4
| | | | | | | Docs/manual.texi: ChangeLog sql/gen_lex_hash.cc: Safety fix
* Added status variables for all MySQL commands.unknown2001-12-131-1/+16
| | | | | Docs/manual.texi: Changelog
* removed ftfuncs argument for mysql_selectunknown2001-11-211-3/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | it uses now thd->lex.ftfunc_list moved ft-initialization to a separate function re-disabled implicit ft initialization sql/item_func.cc: re-disabled implicit initialization that was re-enabled (by me) for reasons unknown (at least the code passed all the tests) sql/mysql_priv.h: removed ftfuncs argument for mysql_select it uses now thd->lex.ftfunc_list moved ft-initialization to a separate function sql/sql_base.cc: removed ftfuncs argument for mysql_select it uses now thd->lex.ftfunc_list moved ft-initialization to a separate function sql/sql_parse.cc: removed ftfuncs argument for mysql_select it uses now thd->lex.ftfunc_list moved ft-initialization to a separate function sql/sql_select.cc: removed ftfuncs argument for mysql_select it uses now thd->lex.ftfunc_list moved ft-initialization to a separate function
* Fix for LOCK TABLES and BDB tablesunknown2001-09-081-1/+9
| | | | | Docs/manual.texi: Added more information to MySQL comparison
* Fix test that all merge tables comes from same databaseunknown2001-09-031-1/+1
|
* ix compilition for computer in a previous timezoneunknown2001-08-311-1/+0
| | | | | | | | | Build-tools/Do-compile: Fix compilition for computer in a previous timezone sql/net_serv.cc: Added comment sql/sql_parse.cc: Cleanup
* Test that all MERGE tables comes from the same databaseunknown2001-08-291-2/+10
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Docs/manual.texi: Changelog and more documentation about ALTER TABLE include/mysqld_error.h: New error message mysql-test/t/merge.test: Test of error conditions sql/gen_lex_hash.cc: Smaller array sql/ha_myisammrg.cc: Cleanup sql/share/czech/errmsg.txt: New message sql/share/danish/errmsg.txt: New message sql/share/dutch/errmsg.txt: New message sql/share/english/errmsg.txt: New message sql/share/estonian/errmsg.txt: New message sql/share/french/errmsg.txt: New message sql/share/german/errmsg.txt: New message sql/share/greek/errmsg.txt: New message sql/share/hungarian/errmsg.txt: New message sql/share/italian/errmsg.txt: New message sql/share/japanese/errmsg.txt: New message sql/share/korean/errmsg.txt: New message sql/share/norwegian-ny/errmsg.txt: New message sql/share/norwegian/errmsg.txt: New message sql/share/polish/errmsg.txt: New message sql/share/portuguese/errmsg.txt: New message sql/share/romanian/errmsg.txt: New message sql/share/russian/errmsg.txt: New message sql/share/slovak/errmsg.txt: New message sql/share/spanish/errmsg.txt: New message sql/share/swedish/errmsg.txt: New message
* Fixes for OS2.unknown2001-08-221-5/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fix bug in isamlog Add argument types to function declarations. Docs/manual.texi: Updated credits client/mysql.cc: Fixes for OS2 client/mysqladmin.c: Fixes for OS2 client/mysqldump.c: Fixes for OS2 client/mysqlimport.c: Fixes for OS2 client/mysqltest.c: Fixes for OS2 dbug/dbug.c: Fixes for OS2. Use new C calling convention. dbug/factorial.c: Fixes for OS2. Use new C calling convention. include/errmsg.h: Fix for OS2 include/global.h: Fixes for OS2. include/my_pthread.h: Fixes for OS2. include/my_sys.h: Fixes for OS2. include/mysql_com.h: Move defines to global.h include/thr_alarm.h: Fixes for OS2. isam/isamchk.c: Fixes for OS2. Add arguments to function declarations. isam/isamlog.c: Fixes for OS2. Fix bug in logfile handling. isam/test1.c: Add arguments to function decl isam/test2.c: Add arguments to function declarations. isam/test_all.res: Update result libmysql/get_password.c: Fixes for OS2. libmysql/libmysql.c: Fixes for OS2. libmysql/net.c: Fixes for OS2. libmysql/violite.c: Add arguments to function declarations. merge/_locking.c: Add argument types to function declarations. merge/close.c: Add argument types to function declarations. merge/create.c: Add argument types to function declarations. merge/extra.c: Add argument types to function declarations. merge/open.c: Add argument types to function declarations. merge/panic.c: Add argument types to function declarations. merge/rsame.c: Add argument types to function declarations. merge/update.c: Add argument types to function declarations. myisam/ft_eval.c: Portability fix myisam/ft_search.c: Portability fix myisam/ft_test1.c: Portability fix myisam/ftdefs.h: Portability fix myisam/mi_check.c: Portability fix myisam/mi_test1.c: Portability fix myisam/mi_test2.c: Portability fix myisam/mi_test_all.sh: Update to test for MACH variable myisam/myisamlog.c: Cleanup myisam/myisampack.c: Don't use variable 'new' myisam/sort.c: Portability fix myisammrg/myrg_delete.c: Add argument types to function declarations. myisammrg/myrg_locking.c: Add argument types to function declarations. myisammrg/myrg_open.c: Add argument types to function declarations. myisammrg/myrg_panic.c: Add argument types to function declarations. mysql-test/t/backup.test: Fix for OS2 mysql-test/t/show_check.test: Fix for OS2 mysys/charset.c: Dont use variable 'new' mysys/default.c: Fixes for OS2. mysys/getopt.c: Fixes for OS2. mysys/getopt1.c: Fixes for OS2. mysys/list.c: Don't use variable 'new' mysys/mf_dirname.c: Fixes for OS2. mysys/mf_format.c: Fixes for OS2. mysys/mf_path.c: Fixes for OS2. mysys/mf_qsort.c: Portability fix mysys/mf_tempfile.c: Fixes for OS2. mysys/my_clock.c: Fixes for OS2. mysys/my_copy.c: Fixes for OS2. mysys/my_create.c: Fixes for OS2. mysys/my_getwd.c: Fixes for OS2. mysys/my_init.c: Fixes for OS2. mysys/my_lib.c: Fixes for OS2. mysys/my_lock.c: Fixes for OS2. mysys/my_malloc.c: Portability fix mysys/my_mkdir.c: Fixes for OS2. mysys/my_open.c: Fixes for OS2. mysys/my_pthread.c: Fixes for OS2. mysys/my_realloc.c: Fixes for OS2. mysys/my_redel.c: Fixes for OS2. mysys/my_static.c: Fixes for OS2. mysys/my_tempnam.c: Fixes for OS2. mysys/my_thr_init.c: Fixes for OS2. mysys/my_write.c: Fixes for OS2. mysys/test_charset.c: Fixes for OS2. mysys/thr_alarm.c: Fixes for OS2. mysys/tree.c: Fixes for OS2. sql/field.cc: Fixes for OS2. sql/field.h: Fixes for OS2. sql/gen_lex_hash.cc: Fixes for OS2. sql/hostname.cc: Fixes for OS2. sql/item_func.cc: Fixes for OS2. sql/item_strfunc.cc: Fixes for OS2. sql/log_event.cc: Fixes for OS2. sql/md5.c: Fixes for OS2. sql/mini_client.cc: Fixes for OS2. sql/mysql_priv.h: Fixes for OS2. sql/mysqld.cc: Fixes for OS2. sql/net_serv.cc: Fixes for OS2. sql/slave.cc: Fixes for OS2. sql/sql_base.cc: Fixes for OS2. sql/sql_db.cc: Portability fix sql/sql_insert.cc: Fixes for OS2. sql/sql_load.cc: Fixes for OS2. sql/sql_parse.cc: Fixes for OS2. sql/sql_table.cc: Fixes for OS2. sql/sql_udf.cc: Fixes for OS2. sql/violite.c: Fixes for OS2. strings/ctype-big5.c: Fixes for OS2. strings/ctype-gbk.c: Fixes for OS2. strings/ctype-sjis.c: Fixes for OS2. strings/ctype-tis620.c: Fixes for OS2. strings/ctype.c: Fixes for OS2. strings/strnlen.c: Fixes for OS2.
* Portability fixes.unknown2001-08-211-2/+0
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Patches required by Gemini Fix to properly detect if there is an active transaction in InnoDB Fix to not lock thread structure when doing automatic rollback when thread ends Allow -O lower_case_names=0 on UNIX Docs/manual.texi: Some updates from mailing list. Changelog client/mysqlbinlog.cc: Removed variables declared in net.c configure.in: Added test for strtoll and fixed test for gethostname_r for AIX mysql-test/t/innodb.test: Added test of active transactions sql/field.cc: Patch required by Gemini sql/field.h: Patch required by Gemini sql/filesort.cc: Patch required by Gemini sql/gen_lex_hash.cc: Update to support new syntax sql/ha_gemini.cc: Patch required by Gemini sql/ha_gemini.h: Patch required by Gemini sql/ha_innobase.cc: Fix to properly detect if there is an active transaction in InnoDB sql/handler.cc: Fix to properly detect if there is an active transaction in InnoDB sql/handler.h: Fix to properly detect if there is an active transaction in InnoDB. Fix for Gemini sql/lex.h: SHOW LOCKS sql/mysqld.cc: Fix to not lock thread structure when doing automatic rollback when thread ends. sql/share/portuguese/errmsg.txt: Update sql/sql_class.cc: Fix to not lock thread structure when doing automatic rollback when thread ends. sql/sql_class.h: Fix to properly detect if there is an active transaction in InnoDB sql/sql_delete.cc: Fix for Gemini sql/sql_parse.cc: Allow -O lower_case_names=0 on UNIX sql/sql_select.cc: Fix for Gemini sql/sql_table.cc: Allow -O lower_case_names=0 on UNIX sql/sql_update.cc: Fix for Gemini sql/sql_yacc.yy: For SHOW LOCKS strings/strto.c: Portability fix
* Portability fixes.unknown2001-08-181-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Let myisamchk generate a new checksum for compressed data. Don't unconditionally force filenames to lower case on windows. Update mysqltest to match 4.0 source (to get some of the new bug fixes into 3.23) Docs/manual.texi: Link changes, and new comments about IA64 and about Sun workshop client/mysqltest.c: Updated this to match the 4.0 source include/config-win.h: Don't unconditionally force filenames to lower case on windows. innobase/include/ut0ut.h: Portability fix myisam/mi_cache.c: Fix problem where reported error number was -1 myisam/mi_check.c: Let myisamchk generate a new checksum for compressed data. myisam/mi_packrec.c: Cleanup myisam/myisamchk.c: Report checksum for compressed tables mysql-test/t/bdb.test: Fix to match new mysqltest mysql-test/t/err000001.test: Fix to match new mysqltest mysql-test/t/fulltext.test: Fix to match new mysqltest mysql-test/t/innodb.test: Fix to match new mysqltest mysql-test/t/overflow.test: Fix to match new mysqltest sql/ha_gemini.cc: Fix false -> FALSE sql/share/estonian/errmsg.txt: Updated of translation sql/share/swedish/errmsg.txt: Updated of translation sql/sql_parse.cc: Don't unconditionally force filenames to lower case on windows. sql/sql_table.cc: Don't unconditionally force filenames to lower case on windows. sql/sql_test.cc: Write current directory when using 'mysqladmin debug' strings/strto.c: Portability fix strings/strtoll.c: Portability fix strings/strtoul.c: Portability fix strings/strtoull.c: Portability fix
* mergeunknown2001-08-101-3/+2
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | BitKeeper/etc/logging_ok: auto-union innobase/buf/buf0flu.c: Auto merged sql/ha_myisam.cc: Auto merged sql/sql_parse.cc: Auto merged sql/sql_select.cc: Auto merged Docs/manual.texi: Will merge later..
| * Portability fixesunknown2001-08-101-3/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added record_rnd_buffer Added --safe-user-create Fix for ALTER TABLE RENAME on windows Docs/manual.texi: Changelog and documentation of new features. More information about using threaded client libraries include/mysql_com.h: Added prototype for my_thread_init() include/mysqld_error.h: New error for --safe-create-user innobase/buf/buf0flu.c: Portability fix innobase/include/univ.i: Portability fix mysql-test/t/distinct.test: Test for distinct bug sql/mysql_priv.h: Added record_rnd_buffer sql/mysqld.cc: Added record_rnd_buffer sql/records.cc: Added record_rnd_buffer sql/share/czech/errmsg.txt: New error message for --safe-user-create sql/share/danish/errmsg.txt: New error message for --safe-user-create sql/share/dutch/errmsg.txt: New error message for --safe-user-create sql/share/english/errmsg.txt: New error message for --safe-user-create sql/share/estonian/errmsg.txt: New error message for --safe-user-create sql/share/french/errmsg.txt: New error message for --safe-user-create sql/share/german/errmsg.txt: New error message for --safe-user-create sql/share/greek/errmsg.txt: New error message for --safe-user-create sql/share/hungarian/errmsg.txt: New error message for --safe-user-create sql/share/italian/errmsg.txt: New error message for --safe-user-create sql/share/japanese/errmsg.txt: New error message for --safe-user-create sql/share/korean/errmsg.txt: New error message for --safe-user-create sql/share/norwegian-ny/errmsg.txt: New error message for --safe-user-create sql/share/norwegian/errmsg.txt: New error message for --safe-user-create sql/share/polish/errmsg.txt: New error message for --safe-user-create sql/share/portuguese/errmsg.txt: New error message for --safe-user-create sql/share/romanian/errmsg.txt: New error message for --safe-user-create sql/share/russian/errmsg.txt: New error message for --safe-user-create sql/share/slovak/errmsg.txt: New error message for --safe-user-create sql/share/spanish/errmsg.txt: New error message for --safe-user-create sql/share/swedish/errmsg.txt: New error message for --safe-user-create sql/sql_acl.cc: Checking of privileges for --safe-user-create sql/sql_acl.h: --safe-user-create sql/sql_base.cc: --safe-user-create sql/sql_parse.cc: --safe-user-create sql/sql_show.cc: --safe-user-create sql/sql_table.cc: Fix for ALTER TABLE RENAME on windows
* | Added new optino --sql-mode to mysqld.unknown2001-08-091-2/+2
|/ | | | | | | | | | | | | | | | | | | | | | | | | | Docs/manual.texi: New option, --sql-mode=option[,option[,option]] sql/ha_myisam.cc: Fixed a segmentation fault -bug with myisam-recover which occurred if option specified was not a legal one. sql/mysql_priv.h: New option --sql-mode sql/mysqld.cc: New option --sql-mode sql/sql_class.cc: New option --sql-mode sql/sql_class.h: New option --sql-mode sql/sql_lex.cc: option --sql-mode, ansi_quotes and ignore_space sql/sql_parse.cc: option --sql-mode, ignore_space sql/sql_select.cc: option --sql-mode, mode only_full_group_by sql/sql_yacc.yy: option --sql-mode, modes pipes_as_concat and real_as_float BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* Removed wrong warning from thr_lockunknown2001-07-171-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed problem with UPDATE and BDB tables Fixed problem with GRANT FILE privilege on database level mysqld --warnings works now Fixed problem with SHOW OPEN TABLES when not using BDB Added some tests for ALTER TABLE to the test scripts Docs/manual.texi: Added link to copyleft license. Updated Changelog configure.in: Fixed typo mysys/thr_lock.c: Removed wrong warning sql/ha_berkeley.cc: Fixed problem with UPDATE sql/sql_acl.cc: Fixed problem with GRANT FILE privilege on database level sql/sql_parse.cc: Fixed that you don't get aborted connection error if you are not using --warning sql/sql_show.cc: Fixed problem with SHOW OPEN TABLES when not using BDB tests/fork2_test.pl: Added test of ALTER TABLE tests/fork_big.pl: Added test of ALTER TABLE
* Added --warnings to mysqldunknown2001-06-211-0/+1
| | | | | | | | | | | Docs/manual.texi: Changelog sql/mysql_priv.h: Added --warnings sql/mysqld.cc: Added --warnings sql/sql_parse.cc: Added --warnings
* Fixed bug that caused client to hang because mysqld never did send anunknown2001-06-021-12/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | error message if the table open or the index creation failed. Updated portuguese error messages. Fix for OS/2 that affected CHECK TABLE. Docs/manual.texi: Changelog. libmysql/errmsg.c: Updated portuguese error messages mysys/my_copy.c: Fix for OS/2 sql/net_pkg.cc: cleanup sql/share/portuguese/errmsg.txt: Updated portuguese error messages sql/slave.cc: Cleanup. Fixed bug that caused client to hang because mysqld never did send an error message if the table open or the index creation failed. sql/sql_parse.cc: Moved handling of 'no_send_ok' to fetch_nx_table. sql/sql_table.cc: Cleanup.
* Remove wrong access check for locks.unknown2001-05-231-9/+0
| | | | | | | | | | | | | | | | | | Fixed problem with fuzzy dates. mysql-test/r/func_time.result: Added test of fuzzy dates mysql-test/t/func_time.test: Added test of fuzzy dates sql/item.cc: Fixed bug with fuzzy dates sql/sql_parse.cc: Remove wrong access check for locks. (This has to be delayed for 4.0 because there is currently now way to check for "any of the following privileges" Docs/manual.texi: Changelog
* Security fix: LOCK TABLES must check for sufficient privileges.unknown2001-05-221-0/+9
| | | | | sql/sql_parse.cc: Check table access for SQLCOM_LOCK_TABLES.
* Portability fixes for Ia64 and Sgi compilerunknown2001-04-251-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | DROP DATABASE in mysqladmin asks for confirmation (again) Added examined_rows to slow query log SHOW CREATE for TEMPORARY table BitKeeper/deleted/.del-shw000001.result~8b20b03d8319b9a5: Delete: mysql-test/r/shw000001.result BitKeeper/deleted/.del-shw000001.test~770d96a2c1c65b20: Delete: mysql-test/t/shw000001.test Docs/manual.texi: Added information about InnoDB and TEMPORARY tables acinclude.m4: Portability fixes client/errmsg.c: merge with libmysqd/errmsg.c client/mysqladmin.c: DROP DATABASE asks for confirmation (again) client/mysqltest.c: Portability fixes configure.in: Portability fixes for SGI compiler on Ia64 extra/resolve_stack_dump.c: Portability fixes include/global.h: Portability fixes isam/_dbug.c: Portability fixes mysql-test/mysql-test-run.sh: Portability fixes mysql-test/r/show_check.result: New test for SHOW CREATE mysql-test/t/show_check.test: New test for SHOW CREATE scripts/make_binary_distribution.sh: Added missing files sql/filesort.cc: Added examined_rows to slow query log sql/log.cc: Added examined_rows to slow query log sql/mysql_priv.h: Added examined_rows to slow query log sql/mysqlbinlog.cc: Fixed core dump when using wrong option sql/mysqld.cc: Removed not used argument sql/sql_base.cc: Fixed name problem with SHOW CREATE for TEMPORARY table sql/sql_class.h: Added examined_rows to slow query log sql/sql_parse.cc: Added examined_rows to slow query log sql/sql_select.cc: Added examined_rows to slow query log sql/sql_select.h: Added examined_rows to slow query log sql/sql_show.cc: Fixed SHOW CREATE for TEMPORARY table sql/sql_table.cc: Added examined_rows to slow query log
* Fix for BDB and LOCK TABLESunknown2001-04-191-0/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | BitKeeper/deleted/.del-ib_config.h.in~9e57db8504e55b7: Delete: innobase/ib_config.h.in BitKeeper/deleted/.del-ib_config.h~7539e26ffc614439: Delete: innobase/ib_config.h Docs/manual.texi: Changelog myisam/mi_locking.c: Cleanup mysql-test/r/bdb.result: Test for LOCK TABLES mysql-test/r/innodb.result: Test for LOCK TABLES mysql-test/t/bdb.test: Test for LOCK TABLES mysql-test/t/innodb.test: Test for LOCK TABLES sql-bench/test-insert.sh: Allow loop to be small sql/ha_berkeley.cc: Fixed bug when using LOCK TABLES with BDB sql/ha_berkeley.h: Fixed bug when using LOCK TABLES with BDB sql/handler.h: Fixed bug when using LOCK TABLES with BDB sql/sql_base.cc: Fixed bug when using LOCK TABLES with BDB sql/sql_parse.cc: UNLOCK TABLES ends transaction sql/sql_select.cc: Fix to not call index_end() twice
* Test case for bug when updating on keyunknown2001-03-231-11/+21
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed bug in CONCAT_WS() Print the default ISOLATION level. Change lock type for CREATE ... SELECT and INSERT/REPLACE ... SELECT Docs/manual.texi: Changelog mysql-test/r/func_str.result: Added tests for CONCAT_WS() mysql-test/r/update.result: Test case for bug when updating on key mysql-test/t/func_str.test: Added tests for CONCAT_WS() mysql-test/t/update.test: Test case for bug when updating on key sql/gen_lex_hash.cc: Better hash values sql/handler.cc: Added missig NullS sql/item_strfunc.cc: Fixed bug in CONCAT_WS() sql/mysql_priv.h: Print the default ISOLATION level. sql/mysqld.cc: Print the default ISOLATION level. sql/sql_insert.cc: Remove unnecessary call to setup_tables() sql/sql_parse.cc: Change lock type for CREATE ... SELECT and INSERT/REPLACE ... SELECT sql/sql_yacc.yy: Change lock type for CREATE ... SELECT and INSERT/REPLACE ... SELECT BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* Split setup_fields to setup_tables and setup_fieldsunknown2001-03-211-1/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed problem with UPDATE TABLE when keys wheren't always used. Docs/manual.texi: Added comment to ALTER TABLE scripts/mysql_install_db.sh: Added test for mysqld in libexec sql/ha_innobase.cc: Removed compiler warning sql/mysql_priv.h: Split setup_fields to setup_tables and setup_fields sql/sql_base.cc: Split setup_fields to setup_tables and setup_fields sql/sql_insert.cc: Split setup_fields to setup_tables and setup_fields sql/sql_load.cc: Split setup_fields to setup_tables and setup_fields sql/sql_parse.cc: Fixed missing 'mysql_info" with now clients. sql/sql_select.cc: Split setup_fields to setup_tables and setup_fields sql/sql_update.cc: Fixed problem with UPDATE TABLE when keys wheren't always used. sql/sql_yacc.yy: Small isolation change
* Added isolation levelsunknown2001-03-211-11/+27
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added SELECT .. FOR UPDATE and SELECT .. IN SHARE MODE Docs/manual.texi: Updated information about SET TRANSACTION ISOLATION LEVEL configure.in: Upgraded version number isam/_dbug.c: Fixed wrong fprintf isam/isamchk.c: Added new error message myisam/mi_check.c: Added new error message mysql-test/mysql-test-run.sh: Don't wait too long for server start mysys/mf_keycache.c: Cleaned up some error messages scripts/mysqlhotcopy.sh: Applied patch for --resetmaster --resetslave sql-bench/bench-init.pl.sh: Fix for windows sql/handler.cc: Added isolation levels and gemini spinlocks sql/handler.h: Added isolation levels sql/item_strfunc.cc: Cleanup of CONCAT_WS() sql/lex.h: Added isolation levels sql/mysql_priv.h: Added isolation levels sql/mysqld.cc: Added isolation levels sql/sql_class.cc: Added isolation levels Moved variable initialization to different code segments sql/sql_class.h: Added isolation levels sql/sql_lex.h: Added isolation levels sql/sql_parse.cc: Added isolation levels sql/sql_update.cc: cleanup BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* Moved state_map copying to THD::THD().unknown2001-03-141-4/+0
| | | | | sql/sql_lex.cc: Changed serg's fix back.
* Merge work:/home/bk/mysqlunknown2001-03-121-0/+4
|\ | | | | | | | | | | | | | | | | | | | | | | into mysql.sashanet.com:/home/sasha/src/bk/mysql Docs/manual.texi: Auto merged sql/sql_parse.cc: Auto merged sql/sql_class.h: Auto merged
| * Added SQL_ANSI_MODE.unknown2001-03-121-0/+4
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Docs/manual.texi: Added News section for 3.23.35, and change notes for SQL_ANSI_MODE. sql/gen_lex_hash.cc: Fixed typo. Updated the values, so the parser can be created. sql/mysql_priv.h: Added ``global_state_map'' from sql_lex.cc. sql/sql_class.h: Added ``state_map'' to THD. This is a per-thread state map for lex. sql/sql_lex.cc: Renamed ``state_map'' to ``global_state_map''. Changed yylex() to use the new per-thread state map. sql/sql_parse.cc: Copy global_state_map into thd->state_map on thread start. sql/sql_yacc.yy: Added SQL_ANSI_MODE. Cleaned up some.
* | untested changes to close socket on slave stop for OS's that do notunknown2001-03-121-15/+1
|/ | | | | | | | | | | | | | | | | | | | | | interrupt I/O after thr_alarm_kill() test case for order by desc coredump mysql-test/t/order_by.test: added test case for order by desc bug sql/slave.cc: close socket on slave stop sql/slave.h: close socket on slave stop sql/sql_class.cc: close socket on slave stop sql/sql_class.h: close socket on slave stop sql/sql_parse.cc: changed kill_one_thread to use prepare_to_die() sql/sql_repl.cc: close socket on slave stop
* Fixed test cases for innobaseunknown2001-03-071-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Fixed bug introduced with last ORDER BY optimization Changed log position to longlong to avoid warnings. Docs/manual.texi: Update for innobase mysql-test/r/innobase.result: Fixed test cases mysql-test/t/bdb.test: Removed not used tables mysql-test/t/innobase.test: Fixed test cases sql/field.h: Fixed bug introduced with last ORDER BY optimization sql/ha_berkeley.cc: Fixed bug when index_init() was called twice. sql/mysql_priv.h: Added option to not get stack trace (when using gdb) sql/mysqld.cc: Added option to not get stack trace (when using gdb) sql/slave.cc: Changed log position to longlong to avoid warnings. sql/slave.h: Changed log position to longlong to avoid warnings. sql/sql_parse.cc: Removed warnings sql/sql_select.cc: Cleanups
* Merged some functions and removed some unused client functions.unknown2001-03-061-37/+57
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Remember UNION for ALTER TABLE Added test for if we are supporting transactions. Don't allow REPLACE to replace a row when we have generated an auto_increment key Fixed bug when using BLOB keys Fixed bug in SET @variable=user. Docs/manual.texi: Added some examples and moved the Error access denied section to the error section. client/mysqltest.c: Changed to use the new mysql_send_query() include/mysql.h: Changed mysql_reap_query() to mysql_send_query(). libmysql/libmysql.c: Changed mysql_reap_query() to mysql_send_query() Merged some functions and removed some unused functions. mysql-test/r/bdb.result: New test case mysql-test/r/distinct.result: New test case mysql-test/r/key.result: New test case mysql-test/r/merge.result: New test case mysql-test/r/replace.result: New test case mysql-test/t/bdb.test: New test case mysql-test/t/key.test: New test case mysql-test/t/merge.test: New test case mysql-test/t/replace.test: New test case mysys/my_lock.c: Moved global lock variable to static sql-bench/test-insert.sh: Added test case for index-read only sql/field.h: Fixed that one can optimize ORDER BY with ISAM and GEMINI sql/ha_berkeley.cc: Added type casts needed for Windows sql/ha_innobase.cc: Removed reference to manual from comment. sql/ha_myisammrg.cc: Remember UNION for ALTER TABLE sql/ha_myisammrg.h: Remember UNION for ALTER TABLE sql/handler.cc: Added test for if we are supporting transactions. Don't allow REPLACE to replace a row when we have generated an auto_increment key. sql/handler.h: Remember UNION for ALTER TABLE sql/key.cc: Fixed bug when using BLOB keys sql/mysql_priv.h: Added new variables sql/mysqld.cc: Added new variables sql/opt_range.cc: Fixed problem with BLOB keys sql/opt_sum.cc: Fix for BLOB keys sql/sql_class.cc: Added test if we need to init/clean transaction variables sql/sql_insert.cc: Fix for REPLACE and auto_increment keys sql/sql_parse.cc: Fixed bug in max_user_connections sql/sql_select.cc: Fixed problem with key on BLOB sql/sql_yacc.yy: Fixed bug in SET @variable=user. sql/table.cc: Fixed problem with keys on BLOB
* Fixes for innobaseunknown2001-02-211-1/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added test for ALTER TABLE ORDER BY BUILD/FINISH.sh: Fixes for innobase BUILD/compile-pentium-debug: Fixes for innobase Docs/manual.texi: Fixes for innobase include/my_pthread.h: Fixes for innobase innobase/Makefile.am: Fixes for innobase innobase/btr/Makefile.am: Fixes for innobase innobase/data/Makefile.am: Fixes for innobase innobase/eval/Makefile.am: Fixes for innobase innobase/include/Makefile.i: Fixes for innobase innobase/os/Makefile.am: Fixes for innobase mysql-test/t/alter_table.test: Added test for ALTER TABLE ORDER BY mysys/my_error.c: Skip 'l' in '%lu' mysys/my_vsnprintf.c: cleanup sql/ha_innobase.cc: Fixed type + remove warnings sql/ha_innobase.h: Remove warnings sql/handler.cc: cleanup sql/sql_class.cc: remove warnings sql/sql_parse.cc: remove warnings sql/sql_table.cc: Fixed bug in ALTER TABLE ... ORDER BY BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* Added max_user_connectionsunknown2001-02-211-3/+131
| | | | | | | | | BUILD/compile-pentium-debug: Added --with-innobase Docs/manual.texi: Added documentation for -O max_user_connections innobase/os/os0sync.c: Fix for Heikki
* Merge work.mysql.com:/home/bk/mysqlunknown2001-02-161-3/+10
|\ | | | | | | | | | | | | | | | | | | into tetra.spaceapes.com:/usr/home/jcole/bk/mysql BitKeeper/etc/logging_ok: auto-union sql/sql_parse.cc: Auto merged
| * COM_TABLE_DUMP and COM_BINLOG_DUMP are no longer erroneously logged unknown2001-02-161-3/+10
| | | | | | | | | | | | | | | | to the slow query log. BitKeeper/etc/logging_ok: Logging to logging@openlogging.org accepted
* | Updates for innobaseunknown2001-02-151-1/+2
|/ | | | | | | | | | | | | | | | Removed a ' that casued 'make paper' to fail Docs/manual.texi: Updated myisamchk section; Removed a ' that casued 'make paper' to fail sql/handler.cc: Updates for innobase sql/mysqld.cc: Updates for innobase sql/sql_parse.cc: Fixed possible overrun if the mysqld server name is too big sql/sql_select.cc: Updates for innobase