And sorry for the Spam. But, having had cake, I really do like cake, and i
do beleive I have deliberatly forced a query to result with an object of
group:{} and users: {} information in the group.
But, having worked motstly with MySQL/MSSQL through ODBC, that's why I
would expect
select count(*) count from table alias
to have a origin column name of 'count(*)' (not null), an alias of 'count'
, a table name of 'table' and a table alias of 'alias'.
Although the ODBC stuff doesn't actually give you the choice to get the
origin names of things.
On Sun, Aug 18, 2019 at 5:01 PM J Decker <d3c...@gmail.com> wrote:
> Okay let's start with, I originally had an API compatible with ODBC, which
> the third information parameter is 'The name of the table, view, alias,
> or synonym.'
>
>
> https://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/odbc/src/tpc/db2z_fncolumns.html
>
>
>
> Column 1 TABLE_CAT (VARCHAR(128))The name of the catalog. The value is
> NULL if this table does not have catalogs.Column 2 TABLE_SCHEM
> (VARCHAR(128))The name of the schema containing TABLE_NAME.Column 3
> TABLE_NAME (VARCHAR(128) not NULL)The name of the table, view, alias, or
> synonym.Column 4 COLUMN_NAME (VARCHAR(128) not NULL)The column
> identifier. The name of the column of the specified table, view, alias, or
> synonym.Column 5 DATA_TYPE (SMALLINT not NULL)The SQL data type of the
> column that is identified by COLUMN_NAME. The DATA_TYPE is one of the
> values in the Symbolic SQL Data Type column in the table of symbolic and
> default data types for CLI.Column 6 TYPE_NAME (VARCHAR(128) not NULL)A
> character string that represents the name of the data type that corresponds
> to DATA_TYPE.Column 7 COLUMN_SIZE (INTEGER)
>
>
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
