2023-05-03 11:06:20 +02:00
|
|
|
== Why is this an issue?
|
|
|
|
|
2020-06-30 12:47:33 +02:00
|
|
|
include::description.adoc[]
|
|
|
|
|
2023-05-25 14:18:12 +02:00
|
|
|
=== Noncompliant code example
|
|
|
|
|
|
|
|
[source,text]
|
|
|
|
----
|
|
|
|
SELECT *
|
|
|
|
FROM persons
|
|
|
|
INTO newyorkers
|
|
|
|
WHERE city = 'NEW YORK'.
|
|
|
|
----
|
|
|
|
|
|
|
|
|
|
|
|
=== Compliant solution
|
|
|
|
|
|
|
|
[source,text]
|
|
|
|
----
|
|
|
|
SELECT firstname, lastname
|
|
|
|
FROM persons
|
|
|
|
INTO newyorkers
|
|
|
|
WHERE city = 'NEW YORK'.
|
|
|
|
----
|
2020-06-30 12:47:33 +02:00
|
|
|
|