named row index in using table-join

[anonymous]

Hello.

I executed a following program, but results differed between two environments. Why?

The preferable output for me is prefix-fully-filled column names like "a.col1 b.col1 b.col2 b.col3". Is it possible?

But in some cases "col1 col1 col2 col3" are better, so it's nice for me that output format can be switched.

Thank you.

---

Exec

(Program) oDB = sqlite3.connect(sDBFile, isolation_level=None) oDB.row_factory = sqlite3.Row for oRow in oRelFtDB.execute("select a.col1, b.* from t1 as a, t2 as b"):

print(oRow.keys())

(schema) t1: col1 text, col2 text, col3 text t2: col1 text, col2 text, col3 text

---

Outputs

(Env: Fedora15, sqlite-3.7.5, Python-3.2.2, PySqlite-2.6.0) col1 col1 col2 col3

(Env: Debian5.0.8, sqlite-3.5.9, Python-3.2.2, PySqlite-2.6.0) a.col1 col1 col2 col3

[Remy Blank]

WrongTrac.