-
Notifications
You must be signed in to change notification settings - Fork 77
Expand file tree
/
Copy pathtestMetaDB.java
More file actions
52 lines (46 loc) · 1.4 KB
/
Copy pathtestMetaDB.java
File metadata and controls
52 lines (46 loc) · 1.4 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
package test;
/*
* Date: 13-3-14
*/
import gudusoft.gsqlparser.EDbVendor;
import gudusoft.gsqlparser.IMetaDatabase;
import gudusoft.gsqlparser.TGSqlParser;
import junit.framework.TestCase;
class NullPtrExc implements IMetaDatabase
{
public void runSql ()
{
String sql = "SELECT DISTINCT\r\n" +
" NULL AS M_CUS_AMO\r\n" +
"FROM\r\n" +
" (SELECT * --m_udf_ref\r\n" +
" FROM\r\n" +
" (SELECT T22.* ,\r\n" +
" rank() over (partition BY T22.M_TRADE_REF order by T22.M_VERSION DESC) AS ordering\r\n" +
" FROM mxcuser.TRN_EXT_DBF T22\r\n" +
" ORDER BY T22.M_VERSION DESC\r\n" +
" ) T33\r\n" +
" WHERE T33.ordering = '1'\r\n" +
" ) ext,\r\n" +
" mxcuser.TABLE#DATA#DEALCURR_DBF t\r\n" +
" WHERE ext.m_udf_ref = T.M_NB\r\n" +
"" ;
TGSqlParser parser = new TGSqlParser(EDbVendor.dbvoracle) ;
parser.sqltext = sql ;
//System.out.println(sql);
parser.setMetaDatabase (this) ; // if you don't do this everything works fine
parser.parse () ;
}
// @Override
public boolean checkColumn (String server, String database,String schema, String table, String column)
{
System.out.println ("checkcolumn") ;
return false ;
}
}
public class testMetaDB extends TestCase {
public void test1()
{
new NullPtrExc().runSql () ;
}
}