1. 17 Dec, 2002 1 commit
    • unknown's avatar
      Added parsing of CASE (both generic and "simple"). · b12330b3
      unknown authored
      
      sql/sp_head.cc:
        Init. the simple_case flag.
      sql/sp_head.h:
        New flag for (simple)case parsing.
      sql/sp_pcontext.cc:
        Removed push_gen_label method (not needed any more).
      sql/sp_pcontext.h:
        Removed push_gen_label method (not needed any more).
        Fixed bug in pop().
      sql/sql_yacc.yy:
        Added CASE parsing.
      b12330b3
  2. 16 Dec, 2002 1 commit
    • unknown's avatar
      Fixed the broken backpatching implementation. · f6611aa0
      unknown authored
      Implemented IF-THEN-ELSE.
      
      
      sql/sp_head.cc:
        Reimplemented the broken backpatching, so it works for nested constructions and
        IF-THEN-ELSE too.
      sql/sp_head.h:
        Reimplemented the broken backpatching, so it works for nested constructions and
        IF-THEN-ELSE too.
      sql/sp_pcontext.cc:
        Return the value from push-methods, for convenience.
      sql/sp_pcontext.h:
        Return the value from push-methods, for convenience.
      sql/sql_yacc.yy:
        Implemented IF-THEN-ELSE.
        Corrected for the new backpatch method.
      f6611aa0
  3. 13 Dec, 2002 1 commit
    • unknown's avatar
      Added collection of called procedures in a list. · 390b3e74
      unknown authored
      Fixed eval bug; now conditions with local variables work in WHILE et al.
      Made mysql_install_db.sh create proc table.
      
      
      scripts/mysql_install_db.sh:
        Added creation of the mysql.proc table.
        Note: The table format will change later, right now it's rather minimalistic,
        just so things can be tested (and the database can easily be recreated when
        I break it :-/ ).
      sql/item.h:
        Removed unused method.
      sql/sp_head.cc:
        Added collection of called procedures in a list.
        Fixed eval bug; now conditions with local variables work in WHILE et al.
      390b3e74
  4. 12 Dec, 2002 1 commit
    • unknown's avatar
      Moved create/find/drop functions to a separate files (sp.cc,sp.h). · b1b62274
      unknown authored
      Fixed backpatching of forward jumps.
      Implemented LOOP, WHILE, REPEAT (temporarily known as SPREPEAT).
      
      Known bug: Expression evaluation still not quite ok (e.g. "x > 0"),
      which is why IF and CASE is not yet implemented.
      
      
      sql/Makefile.am:
        Added new sp.h/sp.cc file.
      sql/item.h:
        New deferred result_type() method in Item_splocal.
      sql/lex.h:
        Temporary fix until REPEAT conflict is solved. Use SPREPEAT for now.
      sql/sp_head.cc:
        Moved create/find/drop functions to sp.cc.
        Fixed the backpatch stuff.
        (Also removed some dead code and updated comments.)
      sql/sp_head.h:
        Moved create/find/drop declarations to sp.h.
        Fixed the backpatch stuff.
      sql/sp_pcontext.h:
        New method: last_label().
      sql/sql_parse.cc:
        Include sp.h.
      sql/sql_yacc.yy:
        Fixed backpatching of forward jumps.
        Implemented LOOP, WHILE, and REPEAT. (Note: SPREPEAT for now.)
      b1b62274
  5. 11 Dec, 2002 1 commit
    • unknown's avatar
      Fixed bugs in the parameter evaluation and modified the execution engine · 37ce17e2
      unknown authored
      for better jump support. Some flow control support added too (but not
      complete).
      
      
      sql/lex.h:
        Added more keywords for embedded SQL.
      sql/sp_head.cc:
        Fixed bugs in the parameter evaluation.
        Modified execute() for better jump support.
        Added jump instruction and backpatch support.
      sql/sp_head.h:
        Fixed bugs in the parameter evaluation.
        Modified execute() for better jump support.
        Added jump instruction and backpatch support.
      sql/sp_pcontext.cc:
        Added label support.
      sql/sp_pcontext.h:
        Added label support.
      sql/sql_yacc.yy:
        Outlined flow control constructs (parses, but nothing generated yet).
      37ce17e2
  6. 08 Dec, 2002 4 commits
    • unknown's avatar
      Simplistic, experimental framework for Stored Procedures (SPs). · 27de9ece
      unknown authored
      Implements creation and dropping of PROCEDUREs, IN, OUT, and INOUT parameters,
      single-statement procedures, rudimentary multi-statement (begin-end) prodedures
      (when the client can handle it), and local variables.
      Missing most of the embedded SQL language, all attributes, FUNCTIONs, error handling,
      reparses procedures at each call (no caching), etc, etc.
      Certainly buggy too, but procedures can actually be created and called....
      
      
      sql/Makefile.am:
        Added SP files.
      sql/item.cc:
        Added this*_item() methods for Item_splocal. (SP local variable)
      sql/item.h:
        Added this*_item() methods for SPs in Item, and the new Item_splocal
        class (SP local variable).
      sql/lex.h:
        Added new symbols for SPs. (Note: SPSET is temporary and will go away later.)
      sql/sql_class.cc:
        Initialize SP runtime context in THD.
      sql/sql_class.h:
        Add SP runtime context to THD.
      sql/sql_lex.cc:
        Init. buf pointer to beginning of command (needed by SPs).
        Also initialize SP head and parse time context.
      sql/sql_lex.h:
        New SQLCOM_ tags for SPs, and added pointer to beginning of command pointer and
        SP head and parse-time context to LEX.
      sql/sql_parse.cc:
        Added SQLCOM_CREATE_PROCEDURE, _CALL, _ALTER_PROCEDURE and _DROP_PROCEDURE cases.
        (Still rudimentary and lacking proper error handling...)
      sql/sql_yacc.yy:
        Lots and lots of additions for SPs...
        (Still even more missing, and no error messages...)
      27de9ece
    • unknown's avatar
      Merge mysql.com:/home/pem/work/mysql-4.1 · 3ec2f965
      unknown authored
      into mysql.com:/home/pem/work/mysql-5.0
      
      
      3ec2f965
    • unknown's avatar
      Merge sanja.is.com.ua:/home/bell/mysql/mysql-4.1 · b392b784
      unknown authored
      into sanja.is.com.ua:/home/bell/mysql/work-leak-4.1
      
      
      b392b784
    • unknown's avatar
      Post merge fix. · 2090eda8
      unknown authored
      
      BitKeeper/etc/logging_ok:
        auto-union
      configure.in:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      2090eda8
  7. 07 Dec, 2002 4 commits
  8. 06 Dec, 2002 3 commits
    • unknown's avatar
      Remove usage of acl_getroot() in embedded server. · baebdcfc
      unknown authored
      Fixed compilation problem when OPENSSL was enabled.
      
      
      libmysqld/lib_sql.cc:
        Remove usage of acl_getroot() as user accounts is not useful with embedded server
      sql/sql_acl.cc:
        Fixed compilation problem when OPENSSL was enabled
      baebdcfc
    • unknown's avatar
      merge fix · 3b0f8e89
      unknown authored
      
      libmysql/libmysql.c:
        Auto merged
      libmysql/password.c:
        Auto merged
      sql/item.h:
        Auto merged
      sql/item_cmpfunc.cc:
        Auto merged
      sql/item_cmpfunc.h:
        Auto merged
      sql/item_func.h:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/password.c:
        Auto merged
      sql/sql_analyse.cc:
        Auto merged
      sql/sql_class.h:
        Auto merged
      sql/sql_delete.cc:
        Auto merged
      sql/sql_insert.cc:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      sql/sql_update.cc:
        Auto merged
      sql-bench/server-cfg.sh:
        Auto merged
      sql/sql_yacc.yy:
        Auto merged
      3b0f8e89
    • unknown's avatar
      After merge fixes · ae4323e0
      unknown authored
      Added THD to add_to_xxx_list() functions for faster parsing.
      
      
      heap/_check.c:
        After merge fix
      mysql-test/r/distinct.result:
        After merge fix
      mysql-test/r/multi_update.result:
        Make timestamp test portable
      mysql-test/t/multi_update.test:
        Make timestamp test portable
      sql/field.cc:
        After merge fix
      sql/item_sum.cc:
        After merge fix
      sql/log_event.cc:
        Remove compiler warning
      sql/mysql_priv.h:
        Added THD to add_to_list (Faster parsing)
      sql/sql_derived.cc:
        Fixed parameters to create_tmp_table()
      sql/sql_lex.cc:
        Added THD to add_to_list (Faster parsing)
      sql/sql_lex.h:
        Added THD to add_to_list (Faster parsing)
      sql/sql_parse.cc:
        Added THD to add_to_list (Faster parsing)
      sql/sql_select.cc:
        After merge fixes
        Fixed return values from JOIN::optimize()
        Replaced test_function_query with '!tables_list'
        Optimized arguments to create_tmp_table()
      sql/sql_select.h:
        Removed test_function_query variable
        Updated prototypes
      sql/sql_union.cc:
        Updated argument lists.
      sql/sql_update.cc:
        After merge fixes
      sql/sql_yacc.yy:
        Added THD to all add_xxx_to_list() functions
      sql/table.h:
        After merge fix
      ae4323e0
  9. 05 Dec, 2002 11 commits
    • unknown's avatar
      fixed bug of PROCEDURE in same query with subselects · f67abe26
      unknown authored
      prohibited using procedure inside subquery
      fixed error handling of procedure analize
      
      
      mysql-test/r/subselect.result:
        test of PROCEDURE in subselect
        test of PROCEDURE of subselect
      mysql-test/t/subselect.test:
        test of PROCEDURE in subselect
        test of PROCEDURE of subselect
      sql/sql_analyse.cc:
        fixed error handling in procedure analize
      sql/sql_parse.cc:
        fixed bug of PROCEDURE in same query with subselects
      sql/sql_yacc.yy:
        prohibited using procedure inside subquery
      f67abe26
    • unknown's avatar
      sql_error.cc: · ef4f5b21
      unknown authored
        make tests to go ; becuase of DROP TABLE ID EXISTS warnings
      
      
      sql/sql_error.cc:
        make tests to go ; becuase of DROP TABLE ID EXISTS warnings
      ef4f5b21
    • unknown's avatar
      Merge work.mysql.com:/home/bk/mysql-4.1 · 3196a915
      unknown authored
      into myvenu.com:/home/venu/bk/src-4.1
      
      
      sql/mysql_priv.h:
        Auto merged
      3196a915
    • unknown's avatar
      Merge with 4.0.6 · 6d33f734
      unknown authored
      
      BitKeeper/etc/ignore:
        auto-union
      acinclude.m4:
        Auto merged
      configure.in:
        Auto merged
      heap/hp_delete.c:
        Auto merged
      heap/hp_scan.c:
        Auto merged
      include/my_base.h:
        Auto merged
      libmysql/libmysql.c:
        Auto merged
      libmysqld/lib_sql.cc:
        Auto merged
      myisam/mi_check.c:
        Auto merged
      myisam/mi_rnext_same.c:
        Auto merged
      myisam/sort.c:
        Auto merged
      mysql-test/r/alter_table.result:
        Auto merged
      mysql-test/r/distinct.result:
        Auto merged
      mysql-test/r/func_math.result:
        Auto merged
      mysql-test/r/group_by.result:
        Auto merged
      mysql-test/r/innodb.result:
        Auto merged
      mysql-test/r/select.result:
        Auto merged
      mysql-test/t/group_by.test:
        Auto merged
      mysql-test/t/select.test:
        Auto merged
      mysys/hash.c:
        Auto merged
      sql/field.h:
        Auto merged
      sql/field_conv.cc:
        Auto merged
      sql/ha_innodb.cc:
        Auto merged
      sql/handler.cc:
        Auto merged
      sql/item_func.cc:
        Auto merged
      sql/item_func.h:
        Auto merged
      sql/log.cc:
        Auto merged
      sql/mysql_priv.h:
        Auto merged
      sql/mysqld.cc:
        Auto merged
      sql/opt_sum.cc:
        Auto merged
      sql/set_var.cc:
        Auto merged
      sql/set_var.h:
        Auto merged
      sql/sql_analyse.cc:
        Auto merged
      sql/sql_class.cc:
        Auto merged
      sql/sql_show.cc:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      sql/sql_udf.cc:
        Auto merged
      sql/structs.h:
        Auto merged
      sql/uniques.cc:
        Auto merged
      strings/strto.c:
        Auto merged
      vio/vio.c:
        Auto merged
      BitKeeper/triggers/post-commit:
        Add changeset to commit messages
      sql-bench/crash-me.sh:
        Use version from 4.0
      sql-bench/server-cfg.sh:
        Use version from 4.0
      6d33f734
    • unknown's avatar
    • unknown's avatar
      Copy arguments given to mysql_server_init() · fdb093fc
      unknown authored
      Made keybuff_size longlong (To make show variables work similar on 32
      and 64 bit systems)
      Fixed some 'not initalized variable errors' in multi-table-update.
      Fixed memory leak in multi-table-update.
      Now all tests works under valgrind without any errors.
      
      
      libmysqld/lib_sql.cc:
        Copy arguments given to mysql_server_init()
      mysql-test/r/temp_table.result:
        Update test results (after merge form 3.23)
      sql/handler.cc:
        Made keybuff_size longlong
      sql/mysql_priv.h:
        Made keybuff_size longlong
      sql/mysqld.cc:
        Made keybuff_size longlong
      sql/set_var.cc:
        Made keybuff_size longlong
      sql/set_var.h:
        Made keybuff_size longlong
      sql/sql_select.cc:
        Simple cleanup
      sql/sql_select.h:
        Make TMP_TABLE_PARAM to be allocated through Sql_alloc
      sql/sql_update.cc:
        Fixed some 'not initalized variable errors' in multi-table-update.
        Fixed memory leak in multi-table-update
      fdb093fc
    • unknown's avatar
      Fix minor bug and add test of connection with new/old/without passwords · 47fb31aa
      unknown authored
      
      libmysql/libmysql.c:
        Small fix (resulted in connection without database even if one is specified)
      sql/mini_client.cc:
        The same fix for replication copy
      47fb31aa
    • unknown's avatar
      Merge with 3.23 · 5fdd9f87
      unknown authored
      
      BitKeeper/etc/ignore:
        auto-union
      configure.in:
        Auto merged
      BitKeeper/deleted/.del-global.h~e80d28157acfdcb5:
        Auto merged
      libmysql/password.c:
        Auto merged
      mysys/hash.c:
        Auto merged
      mysys/my_static.c:
        Auto merged
      mysys/my_static.h:
        Auto merged
      mysys/my_tempnam.c:
        Auto merged
      sql/sql_analyse.cc:
        Auto merged
      sql/sql_table.cc:
        Auto merged
      support-files/mysql.server.sh:
        Auto merged
      mysql-test/t/temp_table.test:
        Added comment
      sql/mysqld.cc:
        Don't apply change from 3.23
      sql/sql_show.cc:
        Don't apply change from 3.23
      sql/structs.h:
        Don't apply change from 3.23
      5fdd9f87
    • unknown's avatar
      Removed copying of parameters as this leads to memory leaks in embedded server. · 591b0585
      unknown authored
      Fixed 'not initialized' memory error.
      
      
      mysql-test/mysql-test-run.sh:
        Updates to be able to more easily use --valgrind
      mysql-test/r/alter_table.result:
        Added missing drop table
      mysql-test/t/alter_table.test:
        Added missing drop table
      sql/field.cc:
        Simple optimizations
      sql/ha_innodb.cc:
        Remove copying of parameters as this leads to memory leaks in MySQL.
        Should be instead fixed by, in embedded server, make a temporary copy of
        all parameters and free them on server-end
      sql/log.cc:
        Simple optimization
      sql/mysql_priv.h:
        Move external reference to struct to include file
      sql/mysqld.cc:
        Added safety asserts
      sql/sql_class.cc:
        Fixed non fatal 'not initialized memory reference error' in thread init
      sql/sql_udf.cc:
        Clear current_thd for global thread
      strings/strto.c:
        Simple optimization
      591b0585
    • unknown's avatar
      Basically minor code optimizations and cleanups · 339cf7ce
      unknown authored
      
      client/mysqladmin.c:
        fix folding
      libmysql/libmysql.c:
        Minor optimizations
      sql/mini_client.cc:
        Minor optimizations
      sql/password.c:
        Optimiations
      sql/sql_acl.cc:
        Get rid of stage parameter and flag old passwords with '*' instead of zero
      sql/sql_acl.h:
        fix prototype
      sql/sql_parse.cc:
        Minor optimizations
      339cf7ce
    • unknown's avatar
      Merge work:/home/bk/mysql-4.0 · 9d14d104
      unknown authored
      into serg.mysql.com:/usr/home/serg/Abk/mysql-4.0
      
      
      9d14d104
  10. 04 Dec, 2002 13 commits