summaryrefslogtreecommitdiff
path: root/storage/connect/tabmysql.cpp
Commit message (Collapse)AuthorAgeFilesLines
...
* - Implement the "exec source" feature for table type MYSQL.Olivier Bertrand2013-10-261-1/+211
| | | | | | | | | modified: storage/connect/ha_connect.cc storage/connect/myconn.h storage/connect/tabmysql.cpp storage/connect/tabmysql.h
* - Fix bug when closing some table typesOlivier Bertrand2013-10-111-12/+14
| | | | | | | | | | | | | | | | | | | | | modified: storage/connect/tabmul.cpp storage/connect/tabmysql.cpp storage/connect/tabodbc.cpp - Add Insert support for ODBC table Add the send command feature to ODBC tables (not documented yet) modified: storage/connect/ha_connect.cc storage/connect/myconn.cpp storage/connect/odbccat.h storage/connect/odbconn.cpp storage/connect/odbconn.h storage/connect/tabodbc.cpp storage/connect/tabodbc.h
* - Fix the default length for DOUBLE to 255 (was 256, max is 255)Olivier Bertrand2013-10-021-0/+3
| | | | | | | | | Add a trace in MakeSQL modified: storage/connect/myconn.cpp storage/connect/tabmysql.cpp
* - Implement the SERVID special columns. This imply modifying the wayOlivier Bertrand2013-08-091-16/+25
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | special columns are processed. This will be documented. Also some code cleanup and some changes to prepare the indexing of nullable columns (not achieve yet) modified: storage/connect/colblk.cpp storage/connect/colblk.h storage/connect/connect.cc storage/connect/connect.h storage/connect/ha_connect.cc storage/connect/ha_connect.h storage/connect/macutil.cpp storage/connect/mycat.cc storage/connect/plgdbsem.h storage/connect/reldef.cpp storage/connect/reldef.h storage/connect/table.cpp storage/connect/tabmysql.cpp storage/connect/tabmysql.h storage/connect/tabodbc.h storage/connect/tabtbl.cpp storage/connect/tabutil.h storage/connect/value.h storage/connect/xindex.cpp storage/connect/xindex.h storage/connect/xtable.h
* - Fix length when TYPVAL::SetValue_char is called from MYSQLCOL::ReadColumn.Olivier Bertrand2013-07-261-1/+1
| | | | | | | modified: storage/connect/tabmysql.cpp storage/connect/value.cpp
* - Fix potential bug in MYSQLCOL::WriteColumn: ShowValue was call withOlivier Bertrand2013-06-261-10/+9
| | | | | | | | *Bind->length instead of Bind->buffer_length modified: storage/connect/tabmysql.cpp
* - Implemented: The use of Federated servers.Olivier Bertrand2013-06-161-59/+85
| | | | | | | | | | | modified: storage/connect/global.h storage/connect/ha_connect.cc storage/connect/plugutil.c storage/connect/tabmysql.cpp storage/connect/tabmysql.h storage/connect/tabtbl.cpp
* - Fix setting default type to MYSQL->PROXY->DOS in some places where itOlivier Bertrand2013-05-241-1/+1
| | | | | | | | | | | | | | | was not done correctly. - Fix a bug causing add_field to generate a syntax error on DOUBLE columns with a 0 decimal value. - Column can be undefined when Srcdef is specified. modified: storage/connect/ha_connect.cc storage/connect/mycat.cc storage/connect/tabmysql.cpp storage/connect/tabutil.cpp storage/connect/tabutil.h
* - Changing CONNECT version number and dateOlivier Bertrand2013-05-221-0/+23
| | | | | | | | | | | | | | | modified: storage/connect/ha_connect.cc storage/connect/mysql-test/connect/r/xml.result - Testing default pivot columns for srcdef Fixing order by MariaDB bug for pivot tables modified: storage/connect/tabmysql.cpp storage/connect/tabmysql.h storage/connect/tabpivot.cpp storage/connect/tabpivot.h
* - Commit merged and resolveOlivier Bertrand2013-05-191-3/+1
|\ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | added: storage/connect/inihandl.h storage/connect/rcmsg.h modified: storage/connect/CMakeLists.txt storage/connect/connect.h storage/connect/ha_connect.cc storage/connect/inihandl.c storage/connect/maputil.h storage/connect/odbconn.cpp storage/connect/osutil.c storage/connect/osutil.h storage/connect/plgdbutl.cpp storage/connect/plugutil.c storage/connect/rcmsg.c storage/connect/tabmysql.cpp storage/connect/tabodbc.cpp storage/connect/tabpivot.cpp storage/connect/tabsys.cpp storage/connect/tabutil.cpp storage/connect/tabutil.h storage/connect/user_connect.cc storage/connect/value.cpp
| * Fixing warnings (mostly "no previous declaration")Alexander Barkov2013-05-131-3/+1
| | | | | | | | | | | | | | | | | | | | | | | | | | modified: storage/connect/ha_connect.cc storage/connect/maputil.h storage/connect/odbconn.cpp storage/connect/osutil.c storage/connect/osutil.h storage/connect/tabmysql.cpp storage/connect/tabutil.cpp storage/connect/tabutil.h
* | - Allowing views and queries as parameters for PROXY base tablesOlivier Bertrand2013-05-191-33/+152
|/ | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | NOTE: Checking for looping references cannot be done when using views as parameters. This should not be allowed on production servers and should be dependant on a system variable and/or on speciel grant. modified: storage/connect/CMakeLists.txt storage/connect/connect.cc storage/connect/ha_connect.cc storage/connect/myconn.cpp storage/connect/myconn.h storage/connect/mysql-test/connect/r/fmt.result storage/connect/mysql-test/connect/r/pivot.result storage/connect/mysql-test/connect/t/fmt.test storage/connect/mysql-test/connect/t/pivot.test storage/connect/plgdbsem.h storage/connect/plugutil.c storage/connect/tabcol.cpp storage/connect/tabcol.h storage/connect/tabfmt.cpp storage/connect/tabmysql.cpp storage/connect/tabmysql.h storage/connect/taboccur.cpp storage/connect/taboccur.h storage/connect/tabpivot.cpp storage/connect/tabpivot.h storage/connect/tabtbl.cpp storage/connect/tabutil.cpp storage/connect/tabutil.h storage/connect/xtable.h
* - Fix inverted test on am in MYSQLDEF::DefineAMOlivier Bertrand2013-05-091-1/+1
| | | | | | modified: storage/connect/tabmysql.cpp
* - Adding a loop test to prevent PROXY based table to loop when repointing on ↵Olivier Bertrand2013-05-021-11/+22
| | | | | | | | | | | | | | | | | | | | | | | | | itself. - Fix bug causing PROXY on non CONNECT tables to sometimes use the wrong DB. - Making some more tests in create that were in pre_create not called anymore when columns are defined. - Updating some test results to reflect new warnings. modified: storage/connect/ha_connect.cc storage/connect/mysql-test/connect/r/tbl.result storage/connect/mysql-test/connect/r/upd.result storage/connect/tabcol.h storage/connect/tabmysql.cpp storage/connect/taboccur.cpp storage/connect/taboccur.h storage/connect/tabtbl.cpp storage/connect/tabtbl.h storage/connect/tabutil.cpp storage/connect/tabutil.h storage/connect/tabxcl.cpp storage/connect/tabxcl.h
* - Allow PROXY based tables to specify MySQL access parameters when theOlivier Bertrand2013-04-301-0/+8
| | | | | | | | | | | object table is not a CONNECT table. This was the case in previous versions but was no more possible with recent changes. modified: storage/connect/mycat.cc storage/connect/tabmysql.cpp storage/connect/tabutil.cpp
* - Adding 3 new table types:Olivier Bertrand2013-04-291-4/+8
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | PROXY table base on another table. Used by several other types. XCOL proxy on a table having a colummn containing a list of values OCCUR proxy on a table having several columns containing the same type of values that can be put in a unique column and several rows. TBL Not new but now internally using the PROXY table class. - Fix 2 bugs in add_field: Change '=' to ' ' after the COMMENT keyword. Quote column names between '`' in the SQL string. - Update xml test result to the CONNECT version added: storage/connect/taboccur.cpp storage/connect/taboccur.h storage/connect/tabutil.cpp storage/connect/tabutil.h storage/connect/tabxcl.cpp storage/connect/tabxcl.h modified: storage/connect/CMakeLists.txt storage/connect/ha_connect.cc storage/connect/ha_connect.h storage/connect/mycat.cc storage/connect/myconn.cpp storage/connect/mysql-test/connect/r/xml.result storage/connect/plgdbsem.h storage/connect/tabmysql.cpp storage/connect/tabtbl.cpp storage/connect/tabtbl.h storage/connect/valblk.cpp storage/connect/valblk.h
* - Add a new table option SEPINDEX (not used yet) and remove an unusedOlivier Bertrand2013-03-251-11/+11
| | | | | | | | | | | | | | | | | | | | | | | | | | parameter to all catalog info functions. modified: storage/connect/catalog.h storage/connect/filamvct.cpp storage/connect/filamzip.cpp storage/connect/ha_connect.cc storage/connect/mycat.cc storage/connect/mycat.h storage/connect/reldef.cpp storage/connect/reldef.h storage/connect/tabdos.cpp storage/connect/tabfmt.cpp storage/connect/tabmul.cpp storage/connect/tabmysql.cpp storage/connect/tabodbc.cpp storage/connect/tabsys.cpp storage/connect/tabtbl.cpp storage/connect/tabvct.cpp storage/connect/tabwmi.cpp storage/connect/tabxml.cpp storage/connect/xindex.cpp
* - Rewriting the VALUE classes as template classesOlivier Bertrand2013-02-271-1/+1
| | | | | | | | | | | | | | modified: storage/connect/tabdos.cpp storage/connect/tabdos.h storage/connect/tabmysql.cpp storage/connect/tabodbc.cpp storage/connect/tabsys.cpp storage/connect/tabxml.cpp storage/connect/value.cpp storage/connect/value.h storage/connect/xobject.h
* - Catalog table: Use XFLD as Flag value instead of column index.Olivier Bertrand2013-02-251-7/+11
| | | | | | | | | | | | | | | - Use the COLDEF flag to initialize column nullable value. - Fix a bug on inserting null values in MYSQL tables. modified: storage/connect/colblk.cpp storage/connect/connect.cc storage/connect/ha_connect.cc storage/connect/odbconn.cpp storage/connect/plgdbsem.h storage/connect/table.cpp storage/connect/tabmysql.cpp
* - Add support to NULL values. This concern the MYSQLOlivier Bertrand2013-02-241-3/+8
| | | | | | | | | | | | | | | | | | and ODBC table types. Not supported yet for indexes. modified: storage/connect/colblk.cpp storage/connect/colblk.h storage/connect/connect.cc storage/connect/ha_connect.cc storage/connect/tabmysql.cpp storage/connect/tabodbc.cpp storage/connect/valblk.cpp storage/connect/valblk.h storage/connect/value.cpp storage/connect/value.h storage/connect/xindex.cpp
* - Fix connect string wrongly used when zero lengthOlivier Bertrand2013-02-221-2/+2
| | | | | | modified: storage/connect/tabmysql.cpp
* - Add the support of URL connection string fo MYSQL tablesOlivier Bertrand2013-02-221-8/+200
| | | | | | | | | | Federated servers are not yet supported. modified: storage/connect/ha_connect.cc storage/connect/tabmysql.cpp storage/connect/tabmysql.h
* - Update the MYSQL table handling to use only client API functions.Olivier Bertrand2013-02-201-8/+21
| | | | | | | | | | | | It is no more necessary to be liked to libmysql.lib nor mysqlclient.lib. modified: storage/connect/libdoc.cpp storage/connect/myconn.cpp storage/connect/myconn.h storage/connect/tabmysql.cpp storage/connect/tabmysql.h
* All use of a character to represent table types orOlivier Bertrand2013-02-121-2/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | catalog functions have been changed: Table_types are now internally represented be enum TABTYPE. Catalog function names are internally translated to a uint. The function GetTypeID was modified accordingly and a new function GetFuncID was implemented in mycat.cc. Modified: ha_connect.cc odbccat.h odbconn.cpp tabodbc.cpp tabfmt.cpp tabmysql.h tabmysql.cpp tabwmi.cpp mycat.h mycat.cc plgdbsem.h reldef.h tabdos.cpp rcmsg.h
* Bug fixed: Column charset were not handled on read.Olivier Bertrand2013-02-111-2/+29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Modified: ha_connect.cc (MakeRecord) Moved PlgAllocResult to plgdbutl.cpp Modified: mycat.cpp plgdbutl.cpp Continuing implementing the "catalog" tables (ex "info"). Already existing were the ODBC data source table and the WMI column info table. The common way to handle them was modified to enable each table types to send personalized data. Now takes care of all existing catalog functions for table types that can retrieve and use such information. Modified: ha_connect.cc odbconn.cpp tabodbc.h tabodbc.cpp tabfmt.h tabfmt.cpp tabmysql.h tabmysql.cpp tabwmi.h tabwmi.cpp myconn.h myconn.cpp filamdbf.cpp plgdbsem.h reldef.h reldef.cpp tabdos.h tabdos.cpp tabfix.h xtable.h table.cpp
* Put almost all function prototypes in header files that areOlivier Bertrand2013-02-091-248/+2
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | included by the program using them. Continuing implementing the "catalog" tables (ex "info"). Already existing were the ODBC data source table and the WMI column info table. A common way to handle them will permit to develop many other such tables. Implemented: The ODBC column catalog table. The ODBC tables catalog table. The ODBC drivers catalog table. The INFO table option is replaced by the CATFUNC string option whode first letter specifies the information to retrieve: C: Columns (of a table) T: Tables (of a database) S: Data sources D: Drivers Modified: ha_connect.cc odbconn.cpp odbconn.h tabodbc.h tabodbc.cpp rcmsg.c tabfmt.h tabmysql.cpp tabwmi.cpp tabwmi.h resource.h myconn.h filamdbf.h connect.cc connect.h Added: myutil.h
* Fixing some of the compilation warnings.Alexander Barkov2013-02-071-2/+4
|
* - Fixing TAB to 2 spacesAlexander Barkov2013-02-071-1105/+1105
| | | | | - Fixing line endings from "\r\n" to "\n"
* Removing os2def.hAlexander Barkov2013-01-291-1/+0
| | | | | | | | | | | | | removed: storage/connect/os2def.h modified: storage/connect/fmdlex.c storage/connect/maputil.cpp storage/connect/tabcol.cpp storage/connect/tabfmt.cpp storage/connect/tabmul.cpp storage/connect/tabmysql.cpp
* Adding an Olivier's changeset:Alexander Barkov2013-01-221-3/+13
| | | | | | | | | | | | | | | | | | | pre_create function and one is now able to create table without giving the column specifications for tables of types: DBF, ODBC, MYSQL, CSV, and WMI (on Windows) modified: sql/handler.h sql/sql_table.cc storage/connect/ha_connect.cc storage/connect/ha_connect.h storage/connect/mycat.cc storage/connect/odbconn.cpp storage/connect/plgcnx.h storage/connect/tabfmt.cpp storage/connect/tabmysql.cpp storage/connect/tabwmi.cpp
* Adding the CONNECT storage engine sources.Alexander Barkov2013-01-181-0/+1096
View Lorry Controller Status