public virtual void TestIsSelectUser()
{
NUnit.Framework.Assert.AreEqual(ServerParseSelect.User, ServerParseSelect.Parse(" select user() "
, 7));
NUnit.Framework.Assert.AreEqual(ServerParseSelect.User, ServerParseSelect.Parse("SELECT USER()"
, 6));
NUnit.Framework.Assert.AreEqual(ServerParseSelect.User, ServerParseSelect.Parse(" selECT USER() "
, 7));
}
public virtual void TestIsSelectDatabase()
{
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Database, ServerParseSelect.Parse
(" select database() ", 7));
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Database, ServerParseSelect.Parse
("SELECT DATABASE()", 6));
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Database, ServerParseSelect.Parse
(" selECT DATABASE() ", 7));
}
public virtual void TestIsSelectVersion()
{
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Version, ServerParseSelect.Parse
(" select version () ", 7));
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Version, ServerParseSelect.Parse
("SELECT VERSION( )", 6));
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Version, ServerParseSelect.Parse
(" selECT VERSION() ", 7));
}
public virtual void TestIsSelectVersionComment()
{
NUnit.Framework.Assert.AreEqual(ServerParseSelect.VersionComment, ServerParseSelect
.Parse(" select @@version_comment ", 7));
NUnit.Framework.Assert.AreEqual(ServerParseSelect.VersionComment, ServerParseSelect
.Parse("SELECT @@VERSION_COMMENT", 6));
NUnit.Framework.Assert.AreEqual(ServerParseSelect.VersionComment, ServerParseSelect
.Parse(" selECT @@VERSION_comment ", 7));
}
public virtual void TestIdentity()
{
string stmt = "select @@identity";
int indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterIdentity(stmt, stmt.
IndexOf('i'));
NUnit.Framework.Assert.AreEqual(stmt.Length, indexAfterLastInsertIdFunc);
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Identity, ServerParseSelect.Parse
(stmt, 6));
stmt = "select @@identity as id";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Identity, ServerParseSelect.Parse
(stmt, 6));
stmt = "select @@identitY id";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Identity, ServerParseSelect.Parse
(stmt, 6));
stmt = "select /*foo*/@@identitY id";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Identity, ServerParseSelect.Parse
(stmt, 6));
stmt = "select/*foo*/ @@identitY id";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Identity, ServerParseSelect.Parse
(stmt, 6));
stmt = "select/*foo*/ @@identitY As id";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Identity, ServerParseSelect.Parse
(stmt, 6));
stmt = "select @@identity ,";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Other, ServerParseSelect.Parse(
stmt, 6));
stmt = "select @@identity as, ";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Other, ServerParseSelect.Parse(
stmt, 6));
stmt = "select @@identity as id , ";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Other, ServerParseSelect.Parse(
stmt, 6));
stmt = "select @@identity ass id ";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Other, ServerParseSelect.Parse(
stmt, 6));
}
public virtual void TestLastInsertId()
{
string stmt = " last_insert_iD()";
int indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt
, stmt.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(stmt.Length, indexAfterLastInsertIdFunc);
stmt = " last_insert_iD ()";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(stmt.Length, indexAfterLastInsertIdFunc);
stmt = " last_insert_iD ( /**/ )";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(stmt.Length, indexAfterLastInsertIdFunc);
stmt = " last_insert_iD ( ) ";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(stmt.LastIndexOf(')') + 1, indexAfterLastInsertIdFunc
);
stmt = " last_insert_id( )";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(stmt.LastIndexOf(')') + 1, indexAfterLastInsertIdFunc
);
stmt = "last_iNsert_id( ) ";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(stmt.LastIndexOf(')') + 1, indexAfterLastInsertIdFunc
);
stmt = " last_insert_iD";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(-1, indexAfterLastInsertIdFunc);
stmt = " last_insert_i ";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(-1, indexAfterLastInsertIdFunc);
stmt = " last_insert_i d ";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(-1, indexAfterLastInsertIdFunc);
stmt = " last_insert_id ( ";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(-1, indexAfterLastInsertIdFunc);
stmt = " last_insert_id( d) ";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(-1, indexAfterLastInsertIdFunc);
stmt = " last_insert_id( ) d ";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(stmt.LastIndexOf(')') + 1, indexAfterLastInsertIdFunc
);
stmt = " last_insert_id(d)";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(-1, indexAfterLastInsertIdFunc);
stmt = " last_insert_id(#\r\nd) ";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(-1, indexAfterLastInsertIdFunc);
stmt = " last_insert_id(#\n\r) ";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(stmt.LastIndexOf(')') + 1, indexAfterLastInsertIdFunc
);
stmt = " last_insert_id (#\n\r)";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(stmt.LastIndexOf(')') + 1, indexAfterLastInsertIdFunc
);
stmt = " last_insert_id(#\n\r)";
indexAfterLastInsertIdFunc = ServerParseSelect.IndexAfterLastInsertIdFunc(stmt, stmt
.IndexOf('l'));
NUnit.Framework.Assert.AreEqual(stmt.LastIndexOf(')') + 1, indexAfterLastInsertIdFunc
);
stmt = "select last_insert_id(#\n\r)";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r) as id";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r) as `id`";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r) as 'id'";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r) id";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r) `id`";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r) 'id'";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r) a";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
// NOTE: this should be invalid, ignore this bug
stmt = "select last_insert_id(#\n\r) as";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r) asd";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
// NOTE: this should be invalid, ignore this bug
stmt = "select last_insert_id(#\n\r) as 777";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
// NOTE: this should be invalid, ignore this bug
stmt = "select last_insert_id(#\n\r) 777";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r)as `77``7`";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r)ass";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r)as 'a'";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r)as 'a\\''";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r)as 'a'''";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = "select last_insert_id(#\n\r)as 'a\"'";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 6));
stmt = " select last_insert_id(#\n\r) As 'a\"'";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.LastInsertId, ServerParseSelect
.Parse(stmt, 9));
stmt = "select last_insert_id(#\n\r)as 'a\"\\'";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Other, ServerParseSelect.Parse(
stmt, 6));
stmt = "select last_insert_id(#\n\r)as `77``7` ,";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Other, ServerParseSelect.Parse(
stmt, 6));
stmt = "select last_insert_id(#\n\r)as `77`7`";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Other, ServerParseSelect.Parse(
stmt, 6));
stmt = "select last_insert_id(#\n\r) as,";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Other, ServerParseSelect.Parse(
stmt, 6));
stmt = "select last_insert_id(#\n\r) ass a";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Other, ServerParseSelect.Parse(
stmt, 6));
stmt = "select last_insert_id(#\n\r) as 'a";
NUnit.Framework.Assert.AreEqual(ServerParseSelect.Other, ServerParseSelect.Parse(
stmt, 6));
}
