Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

RDB Loader: fix ignored schema in metadata queries #178

Closed
chuwy opened this issue Mar 18, 2020 · 0 comments
Closed

RDB Loader: fix ignored schema in metadata queries #178

chuwy opened this issue Mar 18, 2020 · 0 comments
Labels
bug
Milestone
Release 33

Comments

@chuwy
Copy link
Contributor

chuwy commented Mar 18, 2020

snowplow-rdb-loader/src/main/scala/com/snowplowanalytics/snowplow/rdbloader/db/Migration.scala

Line 58 in 1c977c4

LoaderA.executeUpdate(SqlString.unsafeCoerce(s"SET SEARCH_PATH TO $dbSchema")) *>

Above statement supposed to make sure that next query is specific to one schema, but apparently it doesn't work. If user has two tables with same name in different schemas the SELECT obj_description(oid) will return two rows.
@chuwy chuwy added the bug label Mar 18, 2020
@chuwy chuwy added this to the Release 33 milestone Mar 18, 2020
stdfalse added a commit that referenced this issue Mar 19, 2020
@stdfalse
Loader: fix ignored schema in metadata queries (close #178)
32b48a6
stdfalse added a commit that referenced this issue Mar 19, 2020
@stdfalse
Loader: fix ignored schema in metadata queries (close #178)
0f3c616
stdfalse added a commit that referenced this issue Mar 19, 2020
@stdfalse
Loader: fix ignored schema in metadata queries (close #178)
b608f2b
chuwy pushed a commit that referenced this issue Mar 19, 2020
@stdfalse @chuwy
Loader: fix ignored schema in metadata queries (close #178)
2a0c122
chuwy pushed a commit that referenced this issue Jul 13, 2020
@stdfalse @chuwy
Loader: fix ignored schema in metadata queries (close #178)
fa64e91
chuwy pushed a commit that referenced this issue Oct 23, 2020
@stdfalse @chuwy
Loader: fix ignored schema in metadata queries (close #178)
5fea0a1
chuwy pushed a commit that referenced this issue Oct 29, 2020
@stdfalse @chuwy
Loader: fix ignored schema in metadata queries (close #178)
3562bc2
chuwy pushed a commit that referenced this issue Nov 25, 2020
@stdfalse @chuwy
Loader: fix ignored schema in metadata queries (close #178)
097c043
@chuwy chuwy changed the title Loader: fix ignored schema in metadata queries RDB Loader: fix ignored schema in metadata queries Nov 30, 2020
@chuwy chuwy closed this as completed in 74d8581 Dec 1, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
bug
Projects
None yet
Milestone
Release 33
Development

No branches or pull requests
1 participant
@chuwy