nhibernate-commit

[Nhibernate-commit] SF.net SVN: nhibernate:[4432] trunk/nhibernate/src/NHibernate/Dialect/ MySQLDialect.cs

[<dar...@us...>]

Revision: 4432
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4432&view=rev
Author:   darioquintana
Date:     2009-06-09 17:32:21 +0000 (Tue, 09 Jun 2009)

Log Message:
-----------
NH-1824 fixed: MySQL: support for Temporary Tables

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs

Modified: trunk/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs	2009-06-09 14:11:03 UTC (rev 4431)
+++ trunk/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs	2009-06-09 17:32:21 UTC (rev 4432)
@@ -231,5 +231,15 @@
 		{
 			return " drop index " + constraintName;
 		}
+
+		public override bool SupportsTemporaryTables
+		{
+			get { return true; }
+		}
+
+		public override string CreateTemporaryTableString
+		{
+			get { return "create temporary table if not exists"; }
+		}
 	}
 }
\ No newline at end of file


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Nhibernate-commit] SF.net SVN: nhibernate:[4487] trunk/nhibernate/src/NHibernate/Dialect/ MySQLDialect.cs

[<fab...@us...>]

Revision: 4487
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=4487&view=rev
Author:   fabiomaulo
Date:     2009-06-16 14:29:49 +0000 (Tue, 16 Jun 2009)

Log Message:
-----------
Fix NH-1843

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs

Modified: trunk/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs	2009-06-16 14:25:52 UTC (rev 4486)
+++ trunk/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs	2009-06-16 14:29:49 UTC (rev 4487)
@@ -77,7 +77,7 @@
 			RegisterColumnType(DbType.Byte, "TINYINT UNSIGNED");
 			RegisterColumnType(DbType.Currency, "MONEY");
 			RegisterColumnType(DbType.Decimal, "NUMERIC(19,5)");
-			RegisterColumnType(DbType.Decimal, 19, "NUMERIC(19, $l)");
+			RegisterColumnType(DbType.Decimal, 19, "NUMERIC($p, $s)");
 			RegisterColumnType(DbType.Double, "DOUBLE");
 			//The signed range is -32768 to 32767. The unsigned range is 0 to 65535. 
 			RegisterColumnType(DbType.Int16, "SMALLINT");


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.

[Nhibernate-commit] SF.net SVN: nhibernate:[5102] trunk/nhibernate/src/NHibernate/Dialect/ MySQLDialect.cs

[<fab...@us...>]

Revision: 5102
          http://nhibernate.svn.sourceforge.net/nhibernate/?rev=5102&view=rev
Author:   fabiomaulo
Date:     2010-08-03 10:47:31 +0000 (Tue, 03 Aug 2010)

Log Message:
-----------
Fix NH-2142 (tnx to Giovanni Bismondo)

Modified Paths:
--------------
    trunk/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs

Modified: trunk/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs
===================================================================
--- trunk/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs	2010-08-02 22:34:19 UTC (rev 5101)
+++ trunk/nhibernate/src/NHibernate/Dialect/MySQLDialect.cs	2010-08-03 10:47:31 UTC (rev 5102)
@@ -2,6 +2,7 @@
 using System.Data;
 using System.Data.Common;
 using System.Text;
+using NHibernate.Dialect.Function;
 using NHibernate.Dialect.Schema;
 using NHibernate.SqlCommand;
 using NHibernate.Util;
@@ -104,6 +105,9 @@
 			//special:
 			RegisterColumnType(DbType.Guid, "VARCHAR(40)");
 
+			//functions:
+			RegisterFunction("concat", new VarArgsSQLFunction(NHibernateUtil.String, "concat(", ",", ")"));
+
 			DefaultProperties[Environment.ConnectionDriver] = "NHibernate.Driver.MySqlDataDriver";
 		}
 


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.