On Tuesday, November 6, 2012 9:48:26 AM UTC-8, JD wrote: > > Yes, we did turn off identifier quoting in our Dataset class - Teradata > doesn't like it at all :-) > > After switching to double underscore notation with a symbol as described > above, the two queries are no longer there - awesome. Interested to know > why that's working that way - I'll make sure to spend some time debugging > to get to understand Sequel better there. >
Sequel understands :'db_name.table_def' as a single identifer, "db_name.table_def". Sequel understands :db_name__table_def as a qualified identifier, "db_name"."table_def". So with your previous code, it was looking in the schema for a table named "db_name.table_def" instead of a table named "table_def" inside the "db_name" schema. So it didn't find the schema information for the table, and probably had a fall back to using a select query to get the columns. Thanks, Jeremy -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/uSz5tGaC9LoJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
