summaryrefslogtreecommitdiff
path: root/sql/sql_yacc.yy
Commit message (Collapse)AuthorAgeFilesLines
* Merged 4.1 into 5.0.pem@mysql.com2003-03-271-27/+651
|\
| * Added IF EXISTS to DROP PROCEDURE|FUNCTION.pem@mysql.com2003-03-261-4/+6
| | | | | | | | Changed another unecessary use of Item_string into LEX_STRING (in sp_pcontext).
| * Merged 4.1 -> 5.0.pem@mysql.com2003-03-181-27/+649
| |\
| | * Improved error handling regarding SPs (with info like names etc in the output).pem@mysql.com2003-03-051-14/+54
| | | | | | | | | | | | Disabled queries in FUNCTIONs.
| | * Made FUNCTIONs work in insert and select queries, as well as nested function ↵pem@mysql.com2003-03-021-1/+3
| | | | | | | | | | | | | | | | | | | | | invocations. Had to add a cahing mechanism which is in parts an ugly kludge, but it will be reworked once the real SP caching is implemented.
| | * Made stored FUNCTION invokation work almost always. Still buggy and ↵pem@mysql.com2003-02-261-3/+20
| | | | | | | | | | | | | | | | | | unstable, and various known problems, but good enough for a checkpoint commit.
| | * Most of the groundwork for sprint task 729 (implement FUNCTIONs).pem@mysql.com2003-02-211-39/+85
| | | | | | | | | | | | | | | | | | | | | | | | | | | Expanded the mysql.proc table, reworked the find/create/drop functions completely, added new functions for FUNCTIONs (lotta functions here :), got rid of some unnecessary use of Item_strings while at it. Extended the parser correspondingly, and fiddled around a bit to make SP FUNCTIONs coexist with UDFs. Can now CREATE and DROP FUNCTIONs. Invoking yet to come...
| | * Post-merge fixes (adapting new SP code to 4.1 changes).pem@mysql.com2003-02-181-3/+3
| | |
| | * Merging 4.1 into 5.0pem@mysql.com2003-02-181-22/+538
| | |\
| | | * Fixed some DBUGing, and optimized SET slightly.pem@mysql.com2003-02-121-4/+12
| | | |
| | | * Merge sinisa@work.mysql.com:/home/bk/mysql-5.0Sinisa@sinisa.nasamreza.org2003-01-281-10/+20
| | | |\ | | | | | | | | | | | | | | | into sinisa.nasamreza.org:/mnt/work/petica
| | | | * Added check for selects without into in SPs, and updated error messages and ↵pem@mysql.com2003-01-231-6/+15
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | tests accordingly.
| | | | * solve the lex conflict between the existing repeat() function vva@eagle.mysql.r18.ru2003-01-231-4/+5
| | | | | | | | | | | | | | | | | | | | and repeat SP-construction
| | | * | SELECT ... INTO local_vars ...;Sinisa@sinisa.nasamreza.org2003-01-181-2/+21
| | | |/ | | | | | | | | | | | | For Stored Procedures
| | | * Fixed some error handling in the SP parts of the parser.pem@mysql.com2003-01-151-12/+7
| | | |
| | | * Removed dummy SPSET construct.pem@mysql.com2003-01-101-36/+36
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Setting of SP local variables is now part of the existing SET syntax. Note: This has the result that a somewhat extended syntax (from SQL-99) is allowed. We allow a list of settings ("SET a=1, b=2, ...;"), where the different variables can be of different types (SP local, system or user (@)). This also means that certain optional modifiers, such as GLOBAL, are allowed when setting an SP local variable, but then has no meaning and is ignored.
| | | * Mergepem@mysql.com2003-01-091-7/+491
| | | |\
| | | | * Added parsing of CASE (both generic and "simple").pem@mysql.com2002-12-171-8/+76
| | | | |
| | | | * Fixed the broken backpatching implementation.pem@mysql.com2002-12-161-12/+54
| | | | | | | | | | | | | | | | | | | | Implemented IF-THEN-ELSE.
| | | | * Moved create/find/drop functions to a separate files (sp.cc,sp.h).pem@mysql.com2002-12-121-16/+49
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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.
| | | | * Fixed bugs in the parameter evaluation and modified the execution enginepem@mysql.com2002-12-111-23/+129
| | | | | | | | | | | | | | | | | | | | | | | | | for better jump support. Some flow control support added too (but not complete).
| | | | * Simplistic, experimental framework for Stored Procedures (SPs).pem@mysql.com2002-12-081-7/+242
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | 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....
* | | | | More OpenGIS compatibility:bar@bar.mysql.r18.ru2003-03-271-2/+12
| | | | | | | | | | | | | | | | | | | | | | | | | Point, MultiLine, Poligom, etc, are now not aliases for Geometry, but separate field types.
* | | | | Two separate commands: SHOW COLLATION and SHOW CHARACTER SETbar@bar.mysql.r18.ru2003-03-251-0/+2
| | | | |
* | | | | sql_yacc.yy:bar@bar.mysql.r18.ru2003-03-211-4/+4
| | | | | | | | | | | | | | | | | | | | | | | | | Reduce/reduce conflict fix.
* | | | | COLLATE precedence bug has been fixed:bar@bar.mysql.r18.ru2003-03-211-5/+5
| | | | | | | | | | | | | | | | | | | | "a LIKE b COLLATE c" worked as "(a LIKE b) COLLATE c" which is not right
* | | | | A separate variable national_charset_info bar@bar.mysql.r18.ru2003-03-211-8/+7
| | | | | | | | | | | | | | | | | | | | Fixes according coercibility tables, p162, SQL Complete
* | | | | SELECT N'string'bar@bar.mysql.r18.ru2003-03-201-1/+6
| | | | |
* | | | | NATIONAL CHARACTER VARYING(n)bar@bar.mysql.r18.ru2003-03-201-4/+13
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | NATIONAL CHAR VARYING(n) NCHAR VARYING(n) are now aliases for VARCHAR(n) CHARACTER SET utf8
* | | | | NCHAR(n) and NATIONAL CHARACTER(n)bar@bar.mysql.r18.ru2003-03-201-3/+13
| | | | | | | | | | | | | | | | | | | | | | | | | is now synonim for CHARACTER(n) CHARACTER SET utf8
* | | | | New syntax for character strings:bar@bar.mysql.r18.ru2003-03-201-0/+8
| | | | | | | | | | | | | | | | | | | | | | | | | SELECT _latin1 0x345678; SELECT _latin x'345678';
* | | | | Merge bk-internal.mysql.com:/home/bk/mysql-4.1monty@narttu.mysql.fi2003-03-201-54/+128
|\ \ \ \ \ | | | | | | | | | | | | | | | | | | into narttu.mysql.fi:/my/mysql-4.1
| * | | | | CONVERT class was removedbar@bar.mysql.r18.ru2003-03-181-2/+8
| | | | | |
| * | | | | SRID support.ram@mysql.r18.ru2003-03-181-8/+13
| |/ / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | GeomertyFromWKB() function. SRID() function. ::store() methods for Field_geom. Code cleanup.
| * | | | sql_yacc.yy:bar@bar.mysql.r18.ru2003-03-181-1/+3
| | | | | | | | | | | | | | | | | | | | SET NAMES BINARY now works
| * | | | (no commit message)bar@bar.mysql.r18.ru2003-03-171-43/+104
| | | | |
* | | | | Merge with 4.0.12monty@narttu.mysql.fi2003-03-191-0/+3
|\ \ \ \ \
| * | | | | Allow optimzation of multi-table-update also for InnoDB tablesmonty@narttu.mysql.fi2003-03-191-0/+3
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | MEMORY is alias for HEAP for CREATE TABLE ... TYPE=HEAP Fixed bug in multi-table-update where a row could be updated several times
* | | | | | After merge fixesmonty@narttu.mysql.fi2003-03-171-2/+3
| |/ / / / |/| | | | | | | | | | | | | | Don't create temporary objects with no table name
* | | | | New function my_charset_same()mysql@home.(none)2003-03-161-3/+3
| | | | |
* | | | | Every charset now have its own parser state arraysbar@bar.mysql.r18.ru2003-03-141-3/+3
| | | | |
* | | | | Conflicts relsolvinggluh@gluh.mysql.r18.ru2003-03-111-5/+28
|\ \ \ \ \
| * | | | | Added 'PURGE LOGS BEFORE' commandgluh@gluh.mysql.r18.ru2003-03-111-6/+5
| | | | | | | | | | | | | | | | | | | | | | | | Added expire-logs-days option
| * | | | | SCRUM: 'Replication: PURGE LOGS with date' taskgluh@gluh.mysql.r18.ru2003-02-161-6/+29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Added: PURGE [MASTER] LOGS BEFORE date/date_expression expire-logs-days option With this option old files are deleted when - mysqld is started - log is rotated - someone does FLUSH LOGS
* | | | | | Merge sinisa@work.mysql.com:/home/bk/mysql-4.1Sinisa@sinisa.nasamreza.org2003-03-071-1/+29
|\ \ \ \ \ \ | | | | | | | | | | | | | | | | | | | | | into sinisa.nasamreza.org:/mnt/work/mysql-4.1
| * | | | | | New syntax to change client collation:bar@bar.mysql.r18.ru2003-03-071-1/+29
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | SET COLLATION latin1 SET COLLATION 'latin1' SET COLLATION DEFAULT
* | | | | | | An interim code cleanup.Sinisa@sinisa.nasamreza.org2003-03-071-4/+4
|/ / / / / / | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | Major re-write of code yet has to be done, to circumvent assigning of UNIT to current select and to deal better with offset, limit.
* | | | | | New fields in CHARSET_INFO structure to optimize searching forbar@bar.mysql.r18.ru2003-03-051-15/+13
| | | | | | | | | | | | | | | | | | | | | | | | binary and primary collations in the future
* | | | | | SET NAMES has been extended to support optional collation:bar@bar.mysql.r18.ru2003-03-051-7/+27
| | | | | | | | | | | | | | | | | | | | | | | | SET NAMES <charset name> [COLLATE <collation name>]
* | | | | | SELECT BINARY expr bar@bar.mysql.r18.ru2003-03-041-4/+12
| | | | | | | | | | | | | | | | | | | | | | | | | | | | | | is now synonim for SELECT expr COLLATE <expr_charset>_bin