net.sf.saffron.sql.parser
Class SqlParserTest

java.lang.Object
  |
  +--junit.framework.Assert
        |
        +--junit.framework.TestCase
              |
              +--net.sf.saffron.sql.parser.SqlParserTest

All Implemented Interfaces:

Test

public class SqlParserTest

extends TestCase

A SqlParserTest is a unit-test for the SQL parser.

Since:

Mar 19, 2003

Version:

$Id: //open/saffron/src/net/sf/saffron/sql/parser/SqlParserTest.java#5 $

Author:

jhyde

Field Summary

private static String

NL

Fields inherited from class junit.framework.TestCase

Constructor Summary

SqlParserTest(String name)

Method Summary

void	_testDerivedColumnList()
void	_testDerivedColumnListInJoin()
void	_testDerivedColumnListNoAs()
void	_testDerivedColumnListWithAlias()
void	_testEmbeddedCall()
void	_testEmbeddedFunction()
void	_testInListEmpty()
void	_testJoinAssociativity()
private void	check(String sql, String expected)
private void	checkExp(String sql, String expected)
private void	checkFails(String sql, String exceptionPattern)
void	testColumnAliasWithAs()
void	testColumnAliasWithoutAs()
void	testDelete()
void	testDeleteWhere()
void	testEmbeddedDate()
void	testEmbeddedTime()
void	testEmbeddedTimestamp()
void	testEmptyValues()
void	testExists()
void	testExistsInWhere()
void	testExplain()
void	testExplainInsert()
void	testExplainWithImpl()
void	testExplainWithoutImpl()
void	testFromValues()
void	testFromWithAs()
void	testFullInnerJoinFails()
void	testFullOuterJoin()
void	testFunction()
void	testGroup()
void	testHavingAfterGroup()
void	testHavingBeforeGroupFails()
void	testHavingNoGroup()
void	testIdentifier()
void	testInList()
void	testInnerOuterJoinFails()
void	testInQuery()
void	testInsertColumnList()
void	testInsertSelect()
void	testInsertUnion()
void	testInsertValues()
void	testInSetop()
void	testJoinCross()
void	testJoinOn()
void	testJoinQuery()
void	testJoinUsing()
void	testLiteral()
void	testMixedFrom()
void	testMixedStar()
void	testNaturalCrossJoin()
void	testNotExists()
void	testOrder()
void	testOuterJoinNoiseword()
void	testParseNumber()
void	testPrecedence0()
void	testPrecedence1()
void	testPrecedence2()
void	testPrecedence3()
void	testPrecedence4()
void	testPrecedence5()
void	testPrecedenceSetOps()
void	testQueryInFrom()
void	testQuotesInString()
void	testScalarQueryInWhere()
void	testSelectDistinct()
void	testSelectList()
void	testSelectList2()
void	testSelectList3()
void	testSelectList4()
void	testSelectUnique()
void	testStar()
void	testValues()
void	testWhere()

Methods inherited from class junit.framework.TestCase

countTestCases, createResult, getName, run, run, runBare, runTest, setName, setUp, tearDown, toString

Methods inherited from class junit.framework.Assert

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, fail, fail

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

NL

private static final String NL

Constructor Detail

SqlParserTest

public SqlParserTest(String name)

Method Detail

_testDerivedColumnList

public void _testDerivedColumnList()

_testDerivedColumnListInJoin

public void _testDerivedColumnListInJoin()

_testDerivedColumnListNoAs

public void _testDerivedColumnListNoAs()

_testDerivedColumnListWithAlias

public void _testDerivedColumnListWithAlias()

_testEmbeddedCall

public void _testEmbeddedCall()

_testEmbeddedFunction

public void _testEmbeddedFunction()

testColumnAliasWithAs

public void testColumnAliasWithAs()

testColumnAliasWithoutAs

public void testColumnAliasWithoutAs()

testEmbeddedDate

public void testEmbeddedDate()

testEmbeddedTime

public void testEmbeddedTime()

testEmbeddedTimestamp

public void testEmbeddedTimestamp()

testExists

public void testExists()

testExistsInWhere

public void testExistsInWhere()

testFromWithAs

public void testFromWithAs()

testFunction

public void testFunction()

testGroup

public void testGroup()

testHavingAfterGroup

public void testHavingAfterGroup()

testHavingBeforeGroupFails

public void testHavingBeforeGroupFails()

testHavingNoGroup

public void testHavingNoGroup()

testIdentifier

public void testIdentifier()

testInList

public void testInList()

_testInListEmpty

public void _testInListEmpty()

testInQuery

public void testInQuery()

testInSetop

public void testInSetop()

testJoinCross

public void testJoinCross()

testJoinOn

public void testJoinOn()

testOuterJoinNoiseword

public void testOuterJoinNoiseword()

testJoinQuery

public void testJoinQuery()

testFullInnerJoinFails

public void testFullInnerJoinFails()

testFullOuterJoin

public void testFullOuterJoin()

testInnerOuterJoinFails

public void testInnerOuterJoinFails()

_testJoinAssociativity

public void _testJoinAssociativity()

testNaturalCrossJoin

public void testNaturalCrossJoin()

testJoinUsing

public void testJoinUsing()

testLiteral

public void testLiteral()

testMixedFrom

public void testMixedFrom()

testMixedStar

public void testMixedStar()

testNotExists

public void testNotExists()

testOrder

public void testOrder()

testParseNumber

public void testParseNumber()

testPrecedence0

public void testPrecedence0()

testPrecedence1

public void testPrecedence1()

testPrecedence2

public void testPrecedence2()

testPrecedence3

public void testPrecedence3()

testPrecedence4

public void testPrecedence4()

testPrecedence5

public void testPrecedence5()

testPrecedenceSetOps

public void testPrecedenceSetOps()

testQueryInFrom

public void testQueryInFrom()

testQuotesInString

public void testQuotesInString()

testScalarQueryInWhere

public void testScalarQueryInWhere()

testSelectList

public void testSelectList()

testSelectList2

public void testSelectList2()

testSelectList3

public void testSelectList3()

testSelectList4

public void testSelectList4()

testStar

public void testStar()

testSelectDistinct

public void testSelectDistinct()

testSelectUnique

public void testSelectUnique()

testWhere

public void testWhere()

testValues

public void testValues()

testFromValues

public void testFromValues()

testEmptyValues

public void testEmptyValues()

testExplain

public void testExplain()

testExplainWithImpl

public void testExplainWithImpl()

testExplainWithoutImpl

public void testExplainWithoutImpl()

testInsertSelect

public void testInsertSelect()

testInsertUnion

public void testInsertUnion()

testInsertValues

public void testInsertValues()

testInsertColumnList

public void testInsertColumnList()

testExplainInsert

public void testExplainInsert()

testDelete

public void testDelete()

testDeleteWhere

public void testDeleteWhere()

check

private void check(String sql,
                   String expected)

checkExp

private void checkExp(String sql,
                      String expected)

checkFails

private void checkFails(String sql,
                        String exceptionPattern)