*REPRO.* Import from some RDBMS (I tried MySQL this time).
Add a query which has a join and some aliases. Ex. SELECT tbl1.x as alias1, tbl2.y as alias2 FROM tbl1 INNER JOIN tbl2 on tbl1.id = tbl2.id; *EXPECTED.* loaded class should contain properties with the alias names, alias1 and alias2. *ACTUAL.* Loaded class has x and y properties. Note: the last time I tried to use OrientDB for a project it was with MSSQL and this worked but I didn't have any joins. Note#2: I've given up on trying to use ETL and wrote a Java program to do it (first time w/ Java in 9 years). *I did notice the same bug in my Java program at first.I needed to call rsmd.getColumnLabel(i) instead of rsmd.getColumnName(i).* Note#3: It seemed to be a little random. Sometimes the alias worked like when I had to add a function to clean MySql dates -- e.g. IF(time_to_sec(tbl1.dob)=0,null,tbl1.dob) AS db -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
