9d76e2a042
FIX Make sure nested transactions get reset on implicit commits
2018-06-20 12:49:08 +01:00
6b3959ba48
FIX Support nested transactions
2018-02-08 21:37:59 +00:00
76fb2b29dc
Fix class loading issues
2018-01-19 16:27:18 +13:00
2b6a70e529
Merge remote-tracking branch 'origin/1'
...
# Conflicts:
# code/MSSQLDatabase.php
# code/MSSQLSchemaManager.php
# composer.json
2017-12-07 16:05:30 +13:00
ada270c884
[SS-2017-008] Fix SQL injection in search engine
2017-11-22 11:52:50 +00:00
a34d67c753
Rename SS_ prefixed classes ( #39 )
2016-09-09 18:55:53 +12:00
da6cefac06
Upgrade code for core namespaces
2016-08-30 13:08:11 +12:00
9309cf3a50
API Namespace MSSQL connector ( #31 )
...
API Update to support customtable names
Update to support new namespaced orm
Cleanup PHPDoc
2016-07-15 13:57:54 +12:00
4badb07597
Converted to PSR-2
2015-12-18 07:50:59 +13:00
758fe810a5
API Upgraded module to use new database ORM
2014-07-11 09:46:32 +12:00
e884a1cc31
BUG: Indexes were not being fully escaped (the parent table name was, but if the relational table is also namespaced then it would trigger an error).
2014-01-18 21:30:27 +13:00
91a2a6ceb4
Merge branch '3.0-index-fixes' of git://github.com/tractorcow/silverstripe-mssql into tractorcow-3.0-index-fixes
2013-09-13 15:15:10 +12:00
01d376f501
BUG Fixing problem where duplicate items appear on pages
...
Reverts 13cdb07539
2013-05-27 15:21:24 +12:00
1560bad60c
Free the result when at the end of a set using mssql drivers
2013-05-22 22:38:05 +12:00
13cdb07539
Removing paging subset occuring before pagination is set
2013-05-17 11:45:15 +12:00
9ae0cecc36
Revert fc3df54eab
2013-04-25 11:33:54 +12:00
55c56b9b66
default float spec to 53 so dev/build doesn't continually show as changed
...
otherwise it continually shows as changed from "float(53) not null..." to
"float not null"
2013-04-25 11:28:05 +12:00
fc3df54eab
Removing dropping of indexes, has problems with running dev/build twice
2013-04-05 17:23:13 +13:00
bd18c0a1f3
removing double up of quotes in getIndexSqlDefinition()
2013-01-07 17:40:30 +13:00
d6a075f9c7
Fixing MSSQLDatabase to conform to dev/build change detection
...
This involves changing a few things around so that it's closer to
how the MySQLDatabase adapter works. indexList() should return an
array in the same format instead of using arbitrary "indexname"
and "spec". indexNames() has also been introduced to MSSQLDatabase
so that we can drop all indexes (except for fulltext and primary key
indexes) on a table when altering the table columns, this helps when
constraints not directly related to a modified column refuse to allow changes.
2013-01-07 16:25:31 +13:00
91548f76be
Checking for underscore in SortColumn just to be sure
2012-12-20 16:04:44 +13:00
7c369a383a
BUG Fix SortColumn ORDER BY not working when using a limit
...
MSSQL doesn't support putting an alias into the OVER clause,
something which is required when limiting results with an offset.
The workaround is to just put the aggregate inline, taken from
the select list.
2012-12-20 15:57:50 +13:00
e527665c5c
Show the last error a bit more clearly if available
2012-12-19 11:39:51 +13:00
f64c662124
Tidying up error reporting in databaseError() and adding getLastError()
...
Whenever databaseError() is called when a database problem occurred
then the last error is automatically appended to the end of the
general error message.
2012-12-19 11:27:49 +13:00
f34996ae1c
BUG Remove "empty" keywords when building search SQL
2012-12-19 11:19:48 +13:00
d17ae37411
BUG Support for case sensitive searches
...
Through newly added Database->comparisonClause() API
2012-12-11 01:47:35 +01:00
334c2634ac
Removed deprecated transaction methods on MSSQLDatabase
2012-11-16 14:25:13 +13:00
93eab9c132
FIXED: Repaired failing test cases (DataObjectSchemaGenerationTest)
...
FIXED: Incorrect implementation of alterIndex
UPDATED: Improved parsing of index specification by including code borrowed from the postgres database connector module. Possibly a candidate for refactor into SS_Database.
2012-09-24 15:36:59 +12:00
357482d6c9
BUG: open ticket 7813 fixing dobule quoting issue in getIndexSqlDefinition
2012-08-27 15:05:37 +12:00
530c97f671
Added supportsTimezoneOverride() method
2012-07-06 11:36:07 +02:00
05e706ea18
BUG: Fixed MSSQL index name generation for tables with \ in the name.
...
Right now the name of a table with a namespace will contain a '\' character. The internal index name generated clashes with this, so we've dealt with it by turning the '\' into a '_'
2012-06-26 14:52:18 +12:00
22d53b036b
BUG: Fixed index generation to meet new SS3 expectations.
...
In SS3, the column lists passed through for index specifications are now quoted. The database adaptor needed to be updated to meet this change.
2012-06-26 14:35:59 +12:00
0465f1b1a2
MINOR Performance optimisation in MSSQLDatabase::nextRecord() by
...
building field meta-data only on construct of MSSQLQuery
2012-06-12 13:31:29 +12:00
a4c269bf62
BUGFIX Fixing date/datetime handling in MSSQLDatabase
...
Fixing the date type to actually be "date", and not "datetime" so
that values are returned as "Y-m-d" for dates, and not "Y-m-d H:i:s".
Additionally, fixing a case where using the mssql functions would
return strange datetime formats. We need the datetime field values
in Y-m-d H:i:s. To get this working, we need to inspect the field type
when retrieving rows from the database and re-format the datetime
value at this point. This is done in MSSQLQuery::nextRecord()
2012-06-12 12:57:53 +12:00
84ec3a2014
BUGFIX Fixed undefined notice regression
2012-05-08 17:41:01 +12:00
f1daa29592
BUGFIX Fixing MSSQLDatabase to work with latest SQLQuery changes in SS3
2012-05-07 16:40:47 +12:00
05d24b0843
BUGFIX Ensure DateTime objects are handled correctly
2012-05-04 21:58:48 +12:00
30f017335b
BUGFIX Fixing SS3 broken search, use simpler query syntax
2012-05-03 14:33:17 +12:00
731874772c
BUGFIX Fixing broken SS3 query code in MSSQLDatabase
2012-05-03 12:01:50 +12:00
a872e30256
BUGFIX Fixing database to use prepareWhere instead which is renamed
2012-05-01 12:08:19 +12:00
cb01716d39
BUGFIX Fixing order by fields for SS 3.0 in MSSQLDatabase::sqlQueryToString()
2012-04-27 17:25:50 +12:00
c7ae517c99
BUGFIX Fixed support for SS 3.0 with SQLQuery changes in 9938b64cf6ed0e05583633f1b894f89bd1e9f71f
2012-04-27 17:17:55 +12:00
b6082a023e
ENHANCEMENT Use CONTAINSTABLE for fulltext searches, as it provides better fuzzy search results.
2012-04-26 17:31:12 +12:00
375d440677
BUGFIX Ensure that values with unicode characters like macrons are saved
...
to the database correctly. Overload the prepStringForDB() method and
include an "N" prefix.
2012-03-21 12:03:11 +13:00
2312b49b9c
BUGFIX Fixes to searchEngine() to support SS 3.0 ORM changes
2011-12-17 12:43:09 +13:00
a9444a8313
MINOR Removed unused variables from MSSQLDatabase::alterTable()
2011-10-13 14:13:33 +13:00
6cbe886a33
BUGFIX Fixed case where DROP FULLTEXT INDEX failed because it was being called twice, unncessarily. Do it once when altering a table structure.
...
MINOR Cleanup of code in MSSQLDatabase
2011-10-13 14:12:58 +13:00
c1ba0fafc9
BUGFIX MSSQLDatabase::getIndexSqlDefinition() should check a primary key exists before trying to use an empty variable and causing dev/build failures
2011-10-13 13:57:04 +13:00
4b933d7e73
ENHANCEMENT Optionally filtering by new File.ShowInSearch flag in MSSQLDatabase->searcnEngine()
2011-09-15 16:02:23 +02:00
00b81bbdd4
BUGFIX MSSQLDatabase::alterTableAlterColumn() creates ALTER COLUMN clauses twice in the same query for the same column unnecessarily
2011-06-09 13:56:55 +12:00
Daniel Hensby
Daniel Hensby
Dylan Wagstaff
Damian Mooyman
Daniel Hensby
helpfulrobot
Damian Mooyman
Nik Rolls
Sean Harvey
Sean Harvey
Matt Gunn
Ingo Schommer
Kirk Mayo
Sam Minnee