An error occurred fetching the project authors.
  1. 01 Feb, 2004 1 commit
    • unknown's avatar
      now all tables of query are locked in one place (including derived tables) · 68c0a299
      unknown authored
      fixed BUG#2120 and other problem with EXPLAINing derived tables
      
      
      mysql-test/r/derived.result:
        correct tables names & Co in derived tables
        test case for BUG#2120
      mysql-test/t/derived.test:
        test case for BUG#2120
      sql/mysql_priv.h:
        derived tables processing moved after open/locking all tables (in open_and_lock_tables)
      sql/repl_failsafe.cc:
        correct initialization of TABLE_LIST
      sql/sql_acl.cc:
        used simple table opening without derived table processing to avoid unneeded initialization of SELECT_LEX
      sql/sql_base.cc:
        derived tables processing moved after open/locking all tables (in open_and_lock_tables)
      sql/sql_delete.cc:
        all tables processing is done during opening
      sql/sql_derived.cc:
        derived tables processing moved after open/locking all tables (in open_and_lock_tables) to sutisfy "all query tables locking" at the moment
      sql/sql_insert.cc:
        all tables processing is done during opening
        correct initialization of TABLE_LIST
      sql/sql_lex.cc:
        now table list will be created for whole query
        layout fix
        correct check of updated table in subqueries
      sql/sql_lex.h:
        now table list will be created for whole query
        correct check of updated table in subqueries
      sql/sql_olap.cc:
        THIS FUNCTION IS USED NOWHERE
        it will be good to remove it at all (handle_olaps)
      sql/sql_parse.cc:
        derived tables processing moved after open/locking all tables (in open_and_lock_tables)
      sql/sql_prepare.cc:
        new creating list parameters
        all tables processing is done during opening
      sql/sql_select.cc:
        all tables processing is done during opening
      sql/sql_select.h:
        now it used only within file where is defined
      sql/sql_udf.cc:
        used simple table opening without derived table processing to avoid unneeded initialization of SELECT_LEX
      sql/sql_update.cc:
        all tables processing is done during opening
      68c0a299
  2. 02 Jan, 2004 1 commit
    • unknown's avatar
      removed droping field->query_id for reinitialization tables for subquery. · b21d8b0e
      unknown authored
      (BUG#2089)
      
      
      mysql-test/r/subselect_innodb.result:
        correct results
      sql/mysql_priv.h:
        new parameter for setup_tables()
      sql/sql_base.cc:
        new parameter for setup_tables() added to avoid dropping query_id of fields during reinitialization subquery
      sql/sql_class.cc:
        layout fixed
      sql/sql_help.cc:
        new parameter for setup_tables()
      sql/sql_insert.cc:
        new parameter for setup_tables()
      sql/sql_lex.cc:
        removed incorrect code
      sql/sql_load.cc:
        new parameter for setup_tables()
      sql/sql_olap.cc:
        new parameter for setup_tables()
      sql/sql_prepare.cc:
        new parameter for setup_tables()
      sql/sql_select.cc:
        new parameter for setup_tables()
      sql/sql_update.cc:
        new parameter for setup_tables()
      b21d8b0e
  3. 14 May, 2003 1 commit
    • unknown's avatar
      subselect transformation moved in after-fix_field place · a32b868c
      unknown authored
      removed "of is null" if it is possible
        (this cset should be SCRUM related, but not approved as scrum task yet)
      
      
      mysql-test/r/subselect.result:
        new subselect test result (new place of error detecting & and more subselect reducing)
      sql/item.cc:
        layout fix
      sql/item.h:
        unneed ';'
        fixed print pethod
      sql/item_cmpfunc.cc:
        new method to support transformation after fix_fields
      sql/item_cmpfunc.h:
        new method to support transformation after fix_fields
        fixed Item printing
      sql/item_subselect.cc:
        new transformation
      sql/item_subselect.h:
        new transformation
      sql/sql_derived.cc:
        'table' & 'table_list' now is not union
      sql/sql_lex.cc:
        'table' & 'table_list' now is not union to support reinit only shared tables (but all)
      sql/sql_lex.h:
        mark fake st_select_lex
      sql/sql_olap.cc:
        fixed table assignment
        TODO added
      sql/sql_select.cc:
        'table' & 'table_list' now is not union
        transforming subselect
      sql/sql_union.cc:
        prepare make on fix_fields
      sql/sql_yacc.yy:
        fixed layout
      sql/table.h:
        'table & 'table_list' now is different fields
      a32b868c
  4. 25 Jan, 2003 1 commit
    • unknown's avatar
      fixed subselects with temporary tables (SCRUM) · b2354133
      unknown authored
      fixed memory leacks
      
      
      mysql-test/r/subselect.result:
        some changes in subselect tests
      mysql-test/t/subselect.test:
        some changes in subselect tests
      sql/item.cc:
        some item made copyable
        methods for creating copy of item list
        tmp_table_field() splited
      sql/item.h:
        some item made copyable
        methods for creating copy of item list
        tmp_table_field() splited
      sql/item_cmpfunc.cc:
        changed references creation
      sql/item_cmpfunc.h:
        changed references creation
      sql/item_func.cc:
        some item made copyable
        methods for creating copy of item list
        changed references creation
      sql/item_func.h:
        some item made copyable
        methods for creating copy of item list
        changed references creation
        tmp_table_field() splited
      sql/item_subselect.cc:
        changed references creation
      sql/item_sum.cc:
        some item made copyable
        methods for creating copy of item list
      sql/item_sum.h:
        some item made copyable
        methods for creating copy of item list
      sql/item_timefunc.h:
        tmp_table_field() splited
      sql/item_uniq.h:
        some item made copyable
        methods for creating copy of item list
      sql/mysql_priv.h:
        fixed subselects with temporary tables
      sql/sql_base.cc:
        fixed subselects with temporary tables
      sql/sql_class.h:
        fixed subselects with temporary tables
      sql/sql_delete.cc:
        fixed subselects with temporary tables
      sql/sql_derived.cc:
        fixed subselects with temporary tables
      sql/sql_do.cc:
        fixed subselects with temporary tables
      sql/sql_insert.cc:
        fixed subselects with temporary tables
      sql/sql_lex.cc:
        fixed subselects with temporary tables
      sql/sql_lex.h:
        fixed subselects with temporary tables
      sql/sql_list.h:
        fixed subselects with temporary tables
      sql/sql_load.cc:
        fixed subselects with temporary tables
      sql/sql_olap.cc:
        fixed subselects with temporary tables
      sql/sql_parse.cc:
        fixed subselects with temporary tables
      sql/sql_prepare.cc:
        fixed subselects with temporary tables
      sql/sql_select.cc:
        fixed subselects with temporary tables
      sql/sql_select.h:
        fixed subselects with temporary tables
      sql/sql_table.cc:
        fixed subselects with temporary tables
      sql/sql_union.cc:
        fixed subselects with temporary tables
      sql/sql_update.cc:
        fixed subselects with temporary tables
      sql/sql_yacc.yy:
        fixed subselects with temporary tables
      b2354133
  5. 27 Dec, 2002 1 commit
    • unknown's avatar
      postreview fix (SCRUM) · 3ab0ddc2
      unknown authored
      fixed layout
      
      
      sql/filesort.cc:
        fixed layout
      sql/gstream.cc:
        fixed layout
      sql/item.cc:
        postreview fix
      sql/item.h:
        postreview fix
      sql/item_cmpfunc.cc:
        postreview fix
      sql/item_cmpfunc.h:
        fixed layout
      sql/item_func.h:
        fixed layout
      sql/item_row.h:
        fixed layout
      sql/item_strfunc.cc:
        fixed layout
      sql/item_subselect.cc:
        postreview fix
      sql/item_subselect.h:
        postreview fix
      sql/nt_servc.cc:
        fixed layout
      sql/opt_range.cc:
        fixed layout
      sql/password.c:
        fixed layout
      sql/spatial.cc:
        fixed layout
      sql/sql_help.cc:
        fixed layout
      sql/sql_lex.cc:
        fixed layout
      sql/sql_olap.cc:
        fixed layout
      sql/sql_select.cc:
        fixed layout
      sql/sql_show.cc:
        fixed layout
      sql/sql_string.cc:
        fixed layout
      sql/sql_table.cc:
        fixed layout
      sql/stacktrace.c:
        fixed layout
      3ab0ddc2
  6. 29 Nov, 2002 1 commit
    • unknown's avatar
      New multi-table-update code · 46536219
      unknown authored
      New (simpler) internal timestamp handling.
      More debuging to heap tables.
      Small cleanups to multi-table-delete
      false -> 0 and true -> 1  (We should use TRUE and FALSE)
      
      
      heap/_check.c:
        Added checking of rows
      heap/hp_delete.c:
        Extra debugging
      heap/hp_scan.c:
        Extra debugging
      heap/hp_update.c:
        Extra debugging
      heap/hp_write.c:
        Extra debugging
      include/my_base.h:
        Added option to disable row cache when using updates
      isam/extra.c:
        Added option to disable row cache when using updates
      myisam/mi_check.c:
        Comment cleanup
      myisam/mi_extra.c:
        Added option to disable row cache when using updates
      myisam/sort.c:
        Indentaion cleanups
      myisammrg/myrg_extra.c:
        Added option to disable row cache when using updates
      mysql-test/r/multi_update.result:
        Updated results
      mysql-test/t/multi_update.test:
        Cleanup up to only use table names t1, t2,...
      mysys/mf_iocache.c:
        Safety fix
      sql/item_cmpfunc.cc:
        change true-> 1 and false -> 0
      sql/mysql_priv.h:
        Cleaned up SQL_LIST handling
      sql/sql_base.cc:
        Fixed grant checking if SELECT tablename.*
      sql/sql_class.h:
        Cleaned up multi-table-update
      sql/sql_delete.cc:
        Fixed OPTION_SAFE_UPDATE checking in multi-table-delete.
        Fixed query-cache invalidation in multi-table-delete
      sql/sql_insert.cc:
        cleaned up timestamp handling
      sql/sql_olap.cc:
        false -> 0
      sql/sql_parse.cc:
        Optimized some list handling.
        Moved multi-table-update to sql_update.cc
      sql/sql_select.cc:
        More comments
        Fixed create_tmp_table for multi-table-update
      sql/sql_select.h:
        New prototypes
      sql/sql_union.cc:
        false -> 0
        Cleaned up timestamp handling
      sql/sql_update.cc:
        New multi-update-table code
      sql/sql_yacc.yy:
        false -> 0, true -> 1
        Optimized some list handling
      sql/table.h:
        Added union for temporary values.
        Made shared int to be able to store counters.
      sql/uniques.cc:
        Indentation cleanup
      46536219
  7. 29 Jul, 2002 1 commit
    • unknown's avatar
      lot's of small changes · e35a73d1
      unknown authored
      mysql-test/r/olap.result:
        some small changes
      sql/sql_delete.cc:
        A dirty fix for wrong ref_length returned ...
      sql/sql_olap.cc:
        NULL instead of ALL
      sql/sql_select.cc:
        This seems like a better solution to me ...
        At least after this a DISTINCT crash bug happens much later.
      e35a73d1
  8. 24 Jul, 2002 1 commit
    • unknown's avatar
      Removed wrong implementation of CUBE/ROLLUP · 72dec690
      unknown authored
      Fixed bugfix of INSERT ... SET db_name.table_name.column_name
      Changed locking to external-locking
      Fix client hangup for some invalid SQL queries.
      
      
      Docs/manual.texi:
        Changelog & recent incompatible changes to 4.0.3
      include/mysqld_error.h:
        New error messages
      myisam/ft_boolean_search.c:
        Removed compiler warning
      myisam/mi_check.c:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/mi_dynrec.c:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/mi_extra.c:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/mi_key.c:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/mi_open.c:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/mi_packrec.c:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/myisamdef.h:
        Change mi_fix_rec_buff_for_blob to mi_alloc_rec_buff
      myisam/sort.c:
        Fixed uninitialized variable
      mysql-test/r/insert_set.result:
        Change test case to use database foo
      mysql-test/r/union.result:
        Test wrong usage of union
      mysql-test/t/insert_set.test:
        Test bug in insert
      mysql-test/t/union.test:
        Test wrong usage of union
      sql/item.h:
        Indentation cleanup
      sql/item_cmpfunc.h:
        Indentation cleanup
      sql/item_func.h:
        Indentation cleanup
      sql/item_strfunc.h:
        Indentation cleanup
      sql/item_sum.h:
        Indentation cleanup
      sql/item_timefunc.h:
        Indentation cleanup
      sql/item_uniq.h:
        Indentation cleanup
      sql/mysql_priv.h:
        Fix that we always generate an error message when calling YYABORT
      sql/mysqld.cc:
        Changed command line arguments regarding locking to always use --external-locking
        Disable external locking by default
      sql/procedure.h:
        Cleanup
      sql/set_var.cc:
        change locking -> external_locking
      sql/share/czech/errmsg.txt:
        New error messages
      sql/share/danish/errmsg.txt:
        New error messages
      sql/share/dutch/errmsg.txt:
        New error messages
      sql/share/english/errmsg.txt:
        New error messages
      sql/share/estonian/errmsg.txt:
        New error messages
      sql/share/french/errmsg.txt:
        New error messages
      sql/share/german/errmsg.txt:
        New error messages
      sql/share/greek/errmsg.txt:
        New error messages
      sql/share/hungarian/errmsg.txt:
        New error messages
      sql/share/italian/errmsg.txt:
        New error messages
      sql/share/japanese/errmsg.txt:
        New error messages
      sql/share/korean/errmsg.txt:
        New error messages
      mysql-test/r/olap.result:
        Removed CUBE/ROLLUP
      mysql-test/t/olap.test:
        Removed CUBE/ROLLUP
      sql/share/norwegian-ny/errmsg.txt:
        New error messages
      sql/share/norwegian/errmsg.txt:
        New error messages
      sql/share/polish/errmsg.txt:
        New error messages
      sql/share/portuguese/errmsg.txt:
        New error messages
      sql/share/romanian/errmsg.txt:
        New error messages
      sql/share/russian/errmsg.txt:
        New error messages
      sql/share/slovak/errmsg.txt:
        New error messages
      sql/share/spanish/errmsg.txt:
        New error messages
      sql/share/swedish/errmsg.txt:
        New error messages
      sql/share/ukrainian/errmsg.txt:
        New error messages
      sql/sql_base.cc:
        Removed wrong patch for INSERT...
      sql/sql_insert.cc:
        Fix bug in INSERT ... SET db_name.table_name.column_name
      sql/sql_lex.h:
        Changed NON_EXISTIONG_ONE -> UNSPECIFIED_OLAP_TYPE
      sql/sql_olap.cc:
        Removed wrong implementation of CUBE/ROLLUP
      sql/sql_parse.cc:
        Removed wrong implementation of CUBE/ROLLUP
        Added function to give better error messages
      sql/sql_select.cc:
        Removed wrong implementation of CUBE/ROLLUP
      sql/sql_union.cc:
        Added comment
      sql/sql_yacc.yy:
        Fix that we always generate an error message when calling YYABORT
      72dec690
  9. 20 Jul, 2002 2 commits