Commits · ff921a55fc2b7245fb90b645c6b000951d78b8df · nexedi / MariaDB

05 Jul, 2003 1 commit

avoiding of allocating JOIN structure on every UNION executing · ff921a55

unknown authored Jul 05, 2003

(SCRUM)


sql/sql_select.cc:
  support of fake_select_lex join clean
  removed compiler warning
sql/sql_select.h:
  JOIN clean for fake_select_lex
sql/sql_union.cc:
  avoiding of allocating JOIN structure on every UNION executing

ff921a55

03 Jul, 2003 1 commit

merged · ae518209

unknown authored Jul 03, 2003


mysql-test/r/subselect.result:
  Auto merged
mysql-test/t/subselect.test:
  Auto merged
sql/item.cc:
  Auto merged
sql/item_cmpfunc.cc:
  Auto merged
sql/item_cmpfunc.h:
  Auto merged
sql/item_func.cc:
  Auto merged
sql/item_subselect.cc:
  Auto merged
sql/mysql_priv.h:
  Auto merged
sql/sql_lex.cc:
  Auto merged
sql/sql_lex.h:
  Auto merged
sql/sql_parse.cc:
  Auto merged
sql/sql_select.cc:
  Auto merged
sql/sql_yacc.yy:
  Auto merged

ae518209

02 Jul, 2003 6 commits

(SCRUM) · 642dbeba

unknown authored Jul 03, 2003

It looks like samll revolution in SELECT_LEX tree, but it was only natural way to solve problem with name resolution of external fields inside subselect which belongs to global order of union
also it have following advantages:
 - removed mess with current_select type conversion
   - type checking/converting
   - a lot of virtual methods
 - fake select for union execution allocated only once (it was allocated for every subselect with union executing)

changes:
fixed bug with outer fields name resolution of subqueries which belong to global ORDER BY clause
remuved select_lex() function, now thd->lex.current_select always have type SELECT_LEX
new SELECT_LEX (fake_select_lex) will be allocated in case of UNION for using in UNION processing
fake_select_lex allocated for union hold global ORDER BY & LIMIT clauses and have linkage equal to GLOBAL_OPTIONS_TYPE 
new description of SELECT_LEX tree

(SCRUM)


sql/item.cc:
  global parameters moved to fake_select_lex
sql/item_subselect.cc:
  global parameters moved to fake_select_lex
sql/item_sum.cc:
  no need type checking & converion now
sql/sql_delete.cc:
  no need type checking & converion now
sql/sql_derived.cc:
  global parameters moved to fake_select_lex
sql/sql_lex.cc:
  not used fields/mrthods moved from st_select_lex_node to st_select_lex
  global parameters moved to fake_select_lex
sql/sql_lex.h:
  comments about new tree of select_lex s
  not used fields/mrthods moved from st_select_lex_node to st_select_lex
  global parameters moved to fake_select_lex
sql/sql_parse.cc:
  global parameters moved to fake_select_lex
  allocation of fake_select_lex on demand
sql/sql_select.cc:
  now fake_select_lex marked as GLOBAL_OPTIONS_TYPE
sql/sql_union.cc:
  global parameters moved to fake_select_lex
sql/sql_yacc.yy:
  global parameters moved to fake_select_lex

642dbeba

There is no Item->binary() anymore. It was remain from 4.0. · 475e0a9f
unknown authored Jul 02, 2003

475e0a9f
fixed typos · 8713e677
unknown authored Jul 02, 2003

8713e677
fixed bug, which lead to crash mysqld by running 'mysql some_db_with_tables' · f08c35de
unknown authored Jul 02, 2003

f08c35de

Item tree iterator · 7644ca44

unknown authored Jul 02, 2003

fixed dependence of items from reduced subquery
(SCRUM)


sql/item.cc:
  fixed dependence of items from reduced subquery
sql/item.h:
  fixed dependence of items from reduced subquery
  Item tree iterator
sql/item_cmpfunc.cc:
  Item tree iterator
sql/item_cmpfunc.h:
  Item tree iterator
sql/item_func.cc:
  Item tree iterator
sql/item_func.h:
  Item tree iterator
sql/item_row.cc:
  Item tree iterator
sql/item_row.h:
  Item tree iterator
sql/item_strfunc.h:
  Item tree iterator
sql/item_subselect.cc:
  Item tree iterator

7644ca44

Removed dbug.h inclussion from client/get_password.c (windows build fix) · 98a5419f
unknown authored Jul 02, 2003
```
client/get_password.c:
  Removed dbug.h inclussion (windows build fix)
```
98a5419f

01 Jul, 2003 12 commits

after review changes (SCRUM) · b4a58234

unknown authored Jul 02, 2003

removed outer resolving flag (because of movingtransformation after fix_fields)


sql/item.cc:
  removed outer resolving flag (because of movingtransformation after fix_fields)
sql/item.h:
  removed outer resolving flag (because of movingtransformation after fix_fields)
sql/item_cmpfunc.cc:
  removed outer resolving flag (because of movingtransformation after fix_fields)
sql/item_cmpfunc.h:
  removed outer resolving flag (because of movingtransformation after fix_fields)
sql/item_func.cc:
  removed outer resolving flag (because of movingtransformation after fix_fields)
sql/item_func.h:
  removed outer resolving flag (because of movingtransformation after fix_fields)
sql/item_row.cc:
  removed outer resolving flag (because of movingtransformation after fix_fields)
sql/item_row.h:
  removed outer resolving flag (because of movingtransformation after fix_fields)
sql/item_strfunc.h:
  removed outer resolving flag (because of movingtransformation after fix_fields)
sql/item_subselect.cc:
  after review changes
  removed outer resolving flag (because of movingtransformation after fix_fields)
sql/item_subselect.h:
  after review changes
  removed outer resolving flag (because of movingtransformation after fix_fields)
sql/mysql_priv.h:
  after review changes
sql/sql_base.cc:
  after review changes
sql/sql_lex.cc:
  after review changes
sql/sql_lex.h:
  after review changes
sql/sql_select.cc:
  after review changes
sql/sql_union.cc:
  after review changes

b4a58234

Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1 · 40ff37c6

unknown authored Jul 01, 2003

into sanja.is.com.ua:/home/bell/mysql/bk/work-err-4.1


mysql-test/r/subselect.result:
  Auto merged
sql/sql_parse.cc:
  Auto merged
sql/sql_select.cc:
  Auto merged

40ff37c6

fixed uninitialized pointer · 86c50d8c
unknown authored Jul 01, 2003

86c50d8c
Merge bk-internal.mysql.com:/home/bk/mysql-4.1 · f69252e7
unknown authored Jul 01, 2003
```
into mashka.mysql.fi:/home/my/mysql-4.1


mysql-test/r/grant_cache.result:
  Auto merged
```
f69252e7

Fixed testcases and bug introduced by last changeset · eb9cf31d

unknown authored Jul 01, 2003


mysql-test/r/func_gconcat.result:
  Fixed test case after merge
mysql-test/r/grant_cache.result:
  Updated test case (Wrong push by some developer)
mysys/mf_loadpath.c:
  Fix for my_load_path() and ./directory handling from last changeset

eb9cf31d

merge · 8101222a

unknown authored Jul 01, 2003


acinclude.m4:
  Auto merged
mysql-test/r/subselect.result:
  Auto merged
scripts/mysql_create_system_tables.sh:
  Auto merged
sql/sql_class.h:
  Auto merged
sql/sql_yacc.yy:
  Auto merged

8101222a

Fix needed to support MERGE tables in different databases · b3ff72ab

unknown authored Jul 01, 2003


mysql-test/r/merge.result:
  Test of MERGE table patch
mysql-test/t/merge.test:
  Test of MERGE table patch

b3ff72ab

fexed erroro message · 43a51366
unknown authored Jul 01, 2003

43a51366
Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1 · d65f88f1
unknown authored Jul 01, 2003
```
into sanja.is.com.ua:/home/bell/mysql/bk/work-err-4.1
```
d65f88f1
Merge bk-internal.mysql.com:/home/bk/mysql-4.1 · 26230e44
unknown authored Jul 01, 2003
```
into myvenu.com:/home/venu/work/sql/dev-4.1
```
26230e44

sql_state.h: · eb5f773b

unknown authored Jul 01, 2003

  Minor fixups for SQLSTATE values to be compatible with ODBC spec


include/sql_state.h:
  Minor fixups for SQLSTATE values to be compatible with ODBC spec

eb5f773b

merged · a25ff5d8

unknown authored Jul 01, 2003


sql/item_subselect.cc:
  Auto merged
sql/mysqld.cc:
  Auto merged
sql/sql_lex.cc:
  Auto merged
sql/sql_lex.h:
  Auto merged
sql/sql_select.cc:
  Auto merged

a25ff5d8

30 Jun, 2003 4 commits

Made check for structured option handling more robust and faster. · 34e28bd4
unknown authored Jun 30, 2003
```
Earlier it could have failed in some special cases.
```
34e28bd4

LAST_INSERT_ID() should not be set if we couldn't generate an auto_increment id. · ca071e7f

unknown authored Jun 30, 2003


mysql-test/r/auto_increment.result:
  Update after auto_increment fix
mysql-test/t/auto_increment.test:
  Another fix for LAST_INSERT_ID()
sql/handler.cc:
  Another fix for LAST_INSERT_ID()
sql/sql_class.h:
  Another fix for LAST_INSERT_ID()

ca071e7f

Remove FORCE_INIT_OF_VARS when compiling for valgrind/purify to spot wrong LINT_INIT() options · 94d05b12

unknown authored Jun 30, 2003

Fixed bug in ALTER TABLE ... MODIFY integer-column
Added ref_or_null optimization (needed for subqueries)


BUILD/compile-pentium-valgrind-max:
  Remove FORCE_INIT_OF_VARS to spot wrong LINT_INIT() options
mysql-test/r/distinct.result:
  Update of test results (new optimizer)
mysql-test/r/null_key.result:
  Update after ref_or_null optimization
mysql-test/r/subselect.result:
  Update after ref_or_null optimization
mysql-test/t/null_key.test:
  New tests for ref_or_null optimization
sql/sql_select.cc:
  Added ref_or_null optimization
  Optimized find_best_combinations() and read-functions
sql/sql_select.h:
  Added ref_or_null optimization
sql/sql_yacc.yy:
  Fixed bug in ALTER TABLE ... MODIFY integer-column
sql/table.cc:
  Safety fix for ALTER TABLE .. MODIFY
sql/unireg.cc:
  Safety fix for ALTER TABLE .. MODIFY

94d05b12

Merge · ad67dc89

unknown authored Jun 30, 2003


mysql-test/r/subselect.result:
  Auto merged
mysql-test/t/subselect.test:
  Auto merged
sql/item.cc:
  Auto merged
sql/item_cmpfunc.cc:
  Auto merged
sql/item_cmpfunc.h:
  Auto merged
sql/sql_lex.cc:
  Auto merged
sql/sql_select.cc:
  Auto merged
sql/sql_union.cc:
  Auto merged
sql/sql_yacc.yy:
  Auto merged
sql/sql_lex.h:
  SCCS merged

ad67dc89

29 Jun, 2003 3 commits
- merged · ba5bf137
  unknown authored Jun 29, 2003
```
sql/item_cmpfunc.cc:
  Auto merged
sql/sql_lex.cc:
  Auto merged
sql/sql_lex.h:
  Auto merged
sql/sql_select.cc:
  Auto merged
```
  ba5bf137
- Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1 · aa0ae38c
  unknown authored Jun 29, 2003
```
into sanja.is.com.ua:/home/bell/mysql/bk/work-union-4.1
```
  aa0ae38c
- Merge · 7609f53a
  unknown authored Jun 29, 2003
  
  7609f53a
28 Jun, 2003 7 commits
- Merge bk-internal:/home/bk/mysql-4.1/ · 90a04a3a
  unknown authored Jun 29, 2003
```
into serg.mylan:/usr/home/serg/Abk/mysql-4.1
```
  90a04a3a
- fixed a bug that made 4.0 MYI+FT files unreadable in 4.1 · 928a4470
  unknown authored Jun 28, 2003
  
  928a4470
- timestamp MYD-4.0 format compatibility fix · ee5cd559
  unknown authored Jun 28, 2003
  
  ee5cd559
- fixed bug #745 · 09a67b7d
  unknown authored Jun 28, 2003
```
(resolving fields of reduced subselect)


mysql-test/r/subselect.result:
  test of bug #745
mysql-test/t/subselect.test:
  test of bug #745
sql/sql_union.cc:
  to get chance of outer resolved_fields resolve fields of result table as usual fileds
```
  09a67b7d
- Merge · 6e73123d
  unknown authored Jun 28, 2003
```
sql/item.cc:
  Auto merged
mysql-test/r/subselect.result:
  SCCS merged
mysql-test/t/subselect.test:
  SCCS merged
```
  6e73123d
- Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1 · b47efeb4
  unknown authored Jun 28, 2003
```
into sanja.is.com.ua:/home/bell/mysql/bk/work-cset-4.1


sql/sql_select.cc:
  Auto merged
```
  b47efeb4
- merging · 9f9fa5c8
  unknown authored Jun 28, 2003
```
test moved to other bug 
```
  9f9fa5c8
27 Jun, 2003 6 commits
- Merge bk-internal:/home/bk/mysql-4.1/ · 2fb9814e
  unknown authored Jun 27, 2003
```
into serg.mylan:/usr/home/serg/Abk/mysql-4.1
```
  2fb9814e
- merging · ab1a1c9d
  unknown authored Jun 27, 2003
```
sql/item.cc:
  Auto merged
sql/sql_lex.cc:
  Auto merged
sql/sql_lex.h:
  Auto merged
```
  ab1a1c9d
- after review patch · 0e7dfeb0
  unknown authored Jun 27, 2003
  
  0e7dfeb0
- Merge sanja.is.com.ua:/home/bell/mysql/bk/mysql-4.1 · b6d938d1
  unknown authored Jun 27, 2003
```
into sanja.is.com.ua:/home/bell/mysql/bk/work-order-4.1


sql/sql_select.cc:
  Auto merged
```
  b6d938d1
- Merge paul@bk-internal.mysql.com:/home/bk/mysql-4.1 · 4ca40773
  unknown authored Jun 27, 2003
```
into teton.kitebird.com:/home/paul/mysql-4.1
```
  4ca40773
- fix test when no InnoDB is present · 7f2288eb
  unknown authored Jun 27, 2003
  
  7f2288eb