summaryrefslogtreecommitdiffstats
path: root/src/sql
Commit message (Collapse)AuthorAgeFilesLines
* Fix a SQLITE whitespace in identifiers issue.Derick Hawcroft2009-08-181-8/+13
| | | | | | Whitespaces in identifiers now past autotests Reviewed-by:Bill King
* Update license headers.Jason McDonald2009-08-1150-50/+50
| | | | Reviewed-by: Trust Me
* Fixes formatting of date strings in psql driverBill King2009-08-101-1/+1
| | | | | After the coverity fix, the proper code path executed, which failed to enquote the date field properly, so this fix fixes that issue.
* Missing break when formatting from a time valueBill King2009-08-101-0/+1
| | | | Found by coverity.
* Fixes hack around show queries not allowed to be prepared.Bill King2009-07-301-3/+3
| | | | | | | Mysql queries other than select can't be prepared, otherwise they fail to return the necessary meta-information to enable them to be seen as returning data under certain versions of mysql. This fixes the hack to work correctly until we stop preparing queries automagically.
* Fixed compile on certain Solaris versions.Rohan McGovern2009-07-201-1/+1
| | | | | Every source file must end with a newline, otherwise: "Error: There is extra text on this line."
* Fixes failure when table has null fields to updateBill King2009-07-131-1/+1
| | | | | | | Fixes an issue where too many parameters are bound when updating QSqlTableModel where the stored record has NULLs in it. Reviewed-by: Justin McPherson
* emit dataChanged() signalDerick Hawcroft2009-07-091-0/+1
| | | | Task-number:207874
* Plugged possible memory leak in getPSQLVersion()Stian Sandvik Thomassen2009-07-091-2/+2
| | | | | | | Call PQclear() regardless of the status of the result returned by PQexec(). Reviewed-by: Bill King
* Hopefully fix isnan/isinf for good (for all platforms)Bill King2009-07-081-12/+20
|
* Fixes Dericks inf/nan patch for msvcBill King2009-07-081-0/+13
|
* remove debugDerick Hawcroft2009-07-071-1/+0
|
* Handle special number cases (nan,{+-}infinity) in PostgreSQLDerick Hawcroft2009-07-071-0/+17
| | | | | | | | | When contructing the EXECUTE statement, there is a special case that we need to handle whereby we explicitly put quotes around the special float values before submutting the statement for execution Task-number:233829 Reviewed-by: Bill King
* Handle all PostgreSQL notifications sitting in the queueDerick Hawcroft2009-07-071-4/+4
| | | | | Task-number: 257247 Reviewed-by: trustme
* Fixes ::record for dialect 3 named tables in interbase/firebird.Bill King2009-07-031-2/+2
| | | | | | The comparison was mistakenly only uppercasing one side, so mixed case table names were reporting back as if they weren't found for both QSqlDatabase::record() and QSqlDatabase::primaryIndex()
* Fixes invalid length for numeric fields in oracle.Bill King2009-07-031-1/+1
| | | | | When the precisionpolicy is high, and the field is numeric, it was getting confused as a string field and pulling the wrong length value.
* Tinyint is unsigned, force it to such.Bill King2009-07-021-1/+3
| | | | | Tinyint only supports 0-255, so mark it as unsigned despite sign flag, which have the time is inverted/wrong.
* Get more autotests passing/fixed up.Bill King2009-07-021-2/+5
|
* Don assume QVariant::String data is going to always be unicode in QODBCDerick Hawcroft2009-06-301-1/+1
| | | | | | - as was not the case for the psqlODBC driver Reviewed-by: Bill King
* bug fixDerick Hawcroft2009-06-301-0/+1
| | | | | | | - case for QVariant::Bool in switch statement was missing Task-number: 215511 Reviewed-by: TrustMe
* bug fixDerick Hawcroft2009-06-291-1/+4
| | | | | Task-number: 217003 Reviewed-by: Bill King
* save on a couple of mallocsDerick Hawcroft2009-06-241-1/+1
|
* Fixup ibase.Derick Hawcroft2009-06-241-2/+2
| | | | delete -> delete []
* bug fix for ibase sql driverDerick Hawcroft2009-06-241-16/+36
| | | | | | | | - add checks for failed malloc's - convert some of the obvious malloc'ed stuff to use new/delete Task-number: 200217 Reviewed-by: Bill King
* make the last checkin compile.Bill King2009-06-231-2/+0
|
* Fixes non-unicode strings should be strings, not bytearrays.Bill King2009-06-231-17/+1
| | | | | | Passes all autotests. Task-number: 251739
* task 226042Derick Hawcroft2009-06-221-8/+21
| | | | | | | | Until the PostgreSQL API has this functionality. Use a hack to find out if a transaction has failed or not. This hack is a limited to 8.x versions of PostgreSQL. Bill King
* Update license headers as requested by the marketing department.Jason McDonald2009-06-1650-100/+100
| | | | Reviewed-by: Trust Me
* BT Revert "Fix the behaviour of sql classes regarding quoted identifiers"Bill King2009-06-1515-536/+81
| | | | | This reverts commit bb7bddc47dd0748b45d22180d9e3c8e5209010b3 due to forward binary compatibility issues in a point release.
* Fixes one of the fields of mysql bound params not initialised.Bill King2009-05-211-2/+1
| | | | | | Found by valgrind, value isn't set but is used, fixes this. Reviewed-by: Justin McPherson
* Fixes conditional jump on uninitialised valueBill King2009-05-211-1/+11
| | | | | | As found by valgrind. Also add error reporting that was missing. Reviewed-by: Justin McPherson
* Fixes a memory leak in the interbase sql driver.Bill King2009-05-201-4/+3
| | | | | | As suggested in gitorius merge request 421, solution supplied by Harald. Reviewed-by: Harald Fernengel
* Adds thread initialisation/cleanup code to mysql.Bill King2009-05-201-0/+8
| | | | | | Allows for cleaner multi-thread working for mysql clients. Task-number: 253407
* Fix some typos in the documentation.Frederik Schwarzer2009-05-181-1/+1
| | | | | | Usually, "the the" is not proper English Reviewed-By: Thiago Macieira
* Use newer safer error function if available.Bill King2009-05-141-2/+9
| | | | | | Uses fb_interpret instead of isc_interprete if using firebird. Closes a potential security hole/buffer overrun. Reviewed-by: Justin McPherson
* Fixes a segfault from out of order cleanup of mysql resources.Bill King2009-05-131-50/+73
| | | | | | | If a QSqlQuery survived the lifetime of removal of a mysql db connection (that failed), the cleanup code would cause a segfault because it was using an out of date pointer that was pointing at memory that'd been freed by the removeDatabase() call. Revby: Justin McPherson Task-number: 205701
* The description cited MySQL and the code is for PostgreSQL.Benjamin Poulain2009-05-121-1/+1
| | | | | Task-number: 253427 Reviewed-by: TrustMe
* Fixes QIBASE driver crashes on multiple execution of a prepared queryBill King2009-05-071-3/+3
| | | | Task-number: 246808
* Compiler warnings (Mac/Carbon)Bjoern Erik Nilsen2009-05-071-1/+0
| | | | Reviewed-by: nrc
* Fixes crash when mysql_init() returns 0Bill King2009-05-051-1/+1
| | | | Task-number: 250632
* Apparently this is the best way to determine which to useBill King2009-05-011-5/+4
| | | | Best as I can determine via trial and error. It should make vc6 compile again though.
* Try and clean up ODBC 64/32 bit type disparityBill King2009-04-291-6/+4
| | | | It seems that after approx version 2.7.0, microsoft changed the ODBC types of certain functions, to cater for 64bit architectures. This tries to be a little bit smarter about which types are used in which places.
* Fixes performance degradation from precision fix in 4.5.1Bill King2009-04-291-20/+20
| | | | | | | Alleviates the performance hit of querying the database except when necessary, try and use XSQLVAR as much as possible, except for floating point fields. Task-number: 252426
* Fixes over-verboseness in OCI tables function.Bill King2009-04-191-2/+2
| | | | | Differring case of username shouldn't mean adding the username on front. Also fixes autotest failures.
* Fixes long strings getting truncated by the ODBC Driver.Bill King2009-04-161-1/+1
| | | | | | | This test has always been wrong/confusing. Fix it to work, and make sense. Task-number: 250026 Revby: Lincoln Ramsay
* Fixes an issue with FreeTDS and quoting.Bill King2009-04-151-0/+5
| | | | | | | Microsofts SQL Server odbc driver calls SET QUOTED_IDENTIFIER_ON, but freetds doesn't, so any quoting fails. This fixes that issue. Reviewed-by: abcd
* Fix the behaviour of sql classes regarding quoted identifiersabcd2009-04-1515-81/+537
| | | | | | | | | | | If no quotes around identifiers are provided by the programmer, identifiers are treated identically to how the underlying engine would behave. i.e. some engines uppercase the identifiers others lowercase them. If the programmer wants case sensitivty and/or use whitespaces they will need to quote their identifiers. The previous (incorrect) behaviour always quoted the identifiers. Reviewed-by: Bill King
* DB2 driver returning double field as emptyBill King2009-04-081-1/+1
| | | | | | | | | The high precision code path was getting an empty string on the second call to getstringdata, which was causing it to return empty for the field. Really only needed to call it once anyway, so use the original call. Reviewed-by: Justin McPherson
* Missed these changes from the last commit.Bill King2009-04-081-3/+7
| | | | Last of the changes to include behaviour from QPtrVector
* Fixes: Memory leak in DB2 driverBill King2009-04-071-12/+23
| | | | | | | Looks like they were using the old QPtrVector in qt3, and didn't quite handle the porting correctly. Reviewed-by: Lincoln Ramsay