On Wednesday, May 27, 2020 at 3:23:58 AM UTC-7, Tiago Cardoso wrote:
>
> You're right. Actually, the problem seems to be the resulting query, 
> specifically that the table is in caps:
>
> SELECT NULL AS "NIL" FROM "RECORDS" LIMIT 1
>
> The same query generated for CRuby/postgres is
>
> SELECT NULL AS "nil" FROM "records" LIMIT 1
>
> And the generation seems to be all done on sequel side. I've tracked this 
> down to sequel/dataset/sql.rb, where SQL is effectively generated. When 
> passed the source ":records", it goes down this list of methods:
>
>
> source_list_append
> literal_append
> literal_symbol_append
> quote_identifier_append
> input_identifier
>
> This last one effectively upcases :records to "RECORDS" (the sql.rb 
> method). I've seen that this is overriden in share/postgres, through 
> inclusion of UnmodifiedIdentifiers module. However, this isn't happening 
> right now, at least the way I'm defining it.
>

I'm not sure how this is happening, but my guess is it is related to 
sequel-activerecord_connection.  If you can reproduce it with just Sequel, 
I'll take a look.

Thanks,
Jeremy

-- 
You received this message because you are subscribed to the Google Groups 
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to [email protected].
To view this discussion on the web visit 
https://groups.google.com/d/msgid/sequel-talk/4d4e64e5-de87-4c50-8769-19553f28480d%40googlegroups.com.

Reply via email to