acf3b9cc9c3932431979995a1dceacc06c659ab400fad95ce3728ff8895a022b : Off by one on the column names

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

acf3b9cc9c3932431979995a1dceacc06c659ab400fad95ce3728ff8895a022b : Off by one on the column names

Keith Medcalf

Off by one on the names:

sqlite> values (1,2), (2,3);
column1|column2
1|2
2|3

sqlite> select * from (values (1,2), (2,3));
column0|column1
1|2
2|3

---
Life should not be a journey to the grave with the intention of arriving safely in a pretty and well preserved body, but rather to skid in broadside in a cloud of smoke, thoroughly used up, totally worn out, and loudly proclaiming "Wow! What a Ride!"
 -- Hunter S. Thompson




_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: acf3b9cc9c3932431979995a1dceacc06c659ab400fad95ce3728ff8895a022b : Off by one on the column names

Kees Nuyt
On Sun, 09 Jul 2017 12:12:15 -0600, "Keith Medcalf"
<[hidden email]> wrote:

>
>Off by one on the names:
>
>sqlite> values (1,2), (2,3);
>column1|column2
>1|2
>2|3
>
>sqlite> select * from (values (1,2), (2,3));
>column0|column1
>1|2
>2|3

Solved in
=== 2017-07-09 ===
18:55:29 [70096c505d] *CURRENT* Always make "column%d"
column-names 1-based, never 0-based. (user: drh tags: trunk)

--
Regards,
Kees Nuyt
_______________________________________________
sqlite-users mailing list
[hidden email]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Loading...